news.cs

网络人才招聘,系统全面很好,喜欢的朋友拿去

using System;
using System.Data;
using System.Data.SqlClient;
using My.Hr.DbBase;
using System.Collections ;

namespace My
{
	/// <summary>
	/// News description for News。
	/// </summary>
	public class News:Base
	{
		public News()
		{
			
		}
		
		/// NewManager的所有新闻的列表要调用这个函数
		public static DataSet GetNews()
		{
			strSQL = "SELECT * FROM news";

			try
			{
				return ExecuteSql4Ds(strSQL);				
			}
			catch
			{
				throw new Exception("Get all the news Information failed!");
			}			
		}
		
		
		/// <summary>
		/// Get News Cover By NewsId
		/// </summary>
		/// <param name="NewsId">NewsId</param>
		/// <returns></returns>
		/// 
		public DataView GetNewsPicture(int newsId)
		{
			String strsql;
			DataSet myDs;
			strsql="select picture from news where Id="+newsId;
			myDs=ExecuteSql4Ds(strsql);
			return myDs.Tables[0].DefaultView ;
		}


		//get top ten best salers
		public DataView GetNewsLatest10()
		{
			String strsql;
			DataSet myDs;
			strsql="select top 10 Id,title from news order by Id DESC";
			myDs=ExecuteSql4Ds(strsql);
			return myDs.Tables[0].DefaultView ;
		}
		

		public DataView GetNewsImportant10()
		{
			String strsql;
			DataSet myDs;
			strsql="select top 10 Id,title from news order by hits desc";
			myDs=ExecuteSql4Ds(strsql);
			return myDs.Tables[0].DefaultView ;
		}

		/// <summary>
		/// add News,Operator Storeprocedure "AddNews"
		/// </summary>
		/// <param name="tempary">News detail,Kind:ArrayList</param>
		/// <returns></returns>
		public void AddNews(ArrayList tempary)
		{
			SqlConnection myCn=new SqlConnection(strConn);
			SqlCommand myCm=new SqlCommand("AddNews",myCn);
			myCm.CommandType =CommandType.StoredProcedure ;


			myCm.Parameters.Add(new SqlParameter("@publicDate",SqlDbType.DateTime));
			myCm.Parameters["@publicDate"].Value =tempary[0];

			myCm.Parameters.Add(new SqlParameter("@source",SqlDbType.VarChar,30 ));
			myCm.Parameters["@source"].Value =tempary[1];
			
			myCm.Parameters.Add(new SqlParameter("@title",SqlDbType.VarChar,100));
			myCm.Parameters["@title"].Value =tempary[2];

			myCm.Parameters.Add(new SqlParameter("@content",SqlDbType.Text ));
			myCm.Parameters["@content"].Value =tempary[3];
			
			myCm.Parameters.Add(new SqlParameter("@picture",SqlDbType.VarChar,50));
			myCm.Parameters["@picture"].Value =tempary[4];

			myCm.Parameters.Add(new SqlParameter("@hits",SqlDbType.Int));
			myCm.Parameters["@hits"].Value =0;

			try
			{
				myCn.Open() ;
				myCm.ExecuteNonQuery() ;
			}
			catch(System.Data.SqlClient.SqlException er)
			{
				throw new  Exception(er.Message);
			}
			finally
			{
				myCm.Dispose() ;
				myCn.Close() ;
			}
		}



		/// <summary>
		/// Delete News By Newsid
		/// </summary>
		/// <param name="NewsId"></param>
		public void DeleteNewsById(int Id)
		{
			strSQL = "Delete From news Where Id="+Id;
			
			try
			{
				ExecuteSql(strSQL);				
			}
			catch
			{
				throw new Exception("delete failed!");
			}
		}
		
		/// <summary>
		/// Delete a group user
		/// </summary>
		/// <param name="names">Users' names</param>		
		public static void DeleteGroup(string names)
		{
			strSQL = "Delete From news Where Id in ('" + names + "')";
			
			try
			{
				ExecuteSql(strSQL);				
			}
			catch
			{
				throw new Exception("Delete user FAILED！");
			}
		}
		
		public SqlDataReader GetNewsByHits()
		{
			string strsql;
			SqlDataReader result;
			try
			{
				SqlConnection myCn=new SqlConnection(strConn);
				strsql="select top 10 id,title,descr='&nbsp;&nbsp;'+SUBSTRING(content,0,100)+'......',image=case when(not picture is null) then ' <img src=upload/'+picture+' Border=1 width=70 height=100>' else ' <img src=img/pic.jpg border=1 width=70 height=100>' end from news order by hits DESC";
				SqlCommand myCm=new SqlCommand(strsql,myCn);
				myCn.Open ();
				result=myCm.ExecuteReader(CommandBehavior.CloseConnection);
				return result;
			}
			catch(System.Data.SqlClient.SqlException er)
			{
				throw new Exception(er.Message);
			}

		}

		public DataRow GetNewsDetail(int newsId)
		{
			string strsql;
			DataSet myDs;
			try
			{
				strsql="select Id,title,source,publicDate,hits,content from news where Id= " + newsId;
				myDs=ExecuteSql4Ds(strsql);
				return myDs.Tables[0].Rows[0];
			}
			catch(System.Data.SqlClient.SqlException er)
			{
				throw new Exception(er.Message);
			}

		}
		public DataRow GetNewsDetail(string name)
		{
			string strsql;
			DataSet myDs;
			try
			{
				strsql="select Id,title,source,publicDate,hits,content from news where title= " + name;
				myDs=ExecuteSql4Ds(strsql);
				return myDs.Tables[0].Rows[0];
			}
			catch(System.Data.SqlClient.SqlException er)
			{
				throw new Exception(er.Message);
			}

		}	
		/// <summary>
		/// Add  News hits
		/// </summary>
		/// <param name="NewsId">News ID</param>
		/// <returns></returns>
		public static void Hits(string newsId)
		{
			strSQL =  "Update news set hits=hits+1 Where Id= " + newsId;
			try
			{
				ExecuteSql4Ds(strSQL);				
			}
			catch
			{
				throw new Exception("Hits FAILED!!");
			}
		}
	}
}