news.cs

面向.net的WEB应用程序设计-----C#语言

using System;
using System.Data;
using System.Data.SqlClient;
using NewsKindAdmin.DBase;

namespace NewsKindAdmin.Operate_DB
{
	/// <summary>
	/// News 的摘要说明。
	/// </summary>
	public class News
	{
		public News()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public SqlDataReader GetNewsKindData()
		{
			DB db=new DB();
			SqlConnection Con=db.GetConnection();
			string Sql="select * from newstable";
			SqlCommand Cmd=new SqlCommand(Sql,Con);
			Con.Open();
			SqlDataReader Sdr=Cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
			return Sdr;
		}
		public SqlDataReader GetNewsDataByKindId(int kid)
		{
			DB db=new DB();
			SqlConnection Con=db.GetConnection();
			string Sql="select * from news where KindId="+kid.ToString();
			SqlCommand Cmd=new SqlCommand(Sql,Con);
			Con.Open();
			SqlDataReader Sdr=Cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
			return Sdr;
		}
		public DataRow GetNewsEditDataByNId(int newsid)
		{
			DB db=new DB();
			SqlConnection Con=db.GetConnection();
			string Sql="select * from News where NId="+newsid.ToString();
			SqlDataAdapter Sda=new SqlDataAdapter(Sql,Con);
			DataSet DS=new DataSet();
			Sda.Fill(DS,"New");
			DataRow row=DS.Tables["New"].Rows[0];
			return row;
		}
		public bool UpdateEditNewsData(int newsid,string newstitle,string newscontent)
		{
			DB db=new DB();
			SqlConnection Con=db.GetConnection();
			string Sql="Update News set NewsTitle='"+newstitle+"',NewsContent='"+newscontent+"',PubDate=GetDate() where NId="+newsid.ToString();
			SqlCommand Cmd=new SqlCommand(Sql,Con);
			try
			{
				Con.Open();
				Cmd.ExecuteNonQuery();
				return true;
			}
			catch
			{
				return false;
			}
			finally
			{
				Con.Close();
			}
		}
		public bool DeleteNewsData(int newsid)
		{
			DB db=new DB();
			SqlConnection Con=db.GetConnection();
			string Sql="delete from News where NId="+newsid.ToString();
			SqlCommand Cmd=new SqlCommand(Sql,Con);
			try
			{
				Con.Open();
				Cmd.ExecuteNonQuery();
				return true;
			}
			catch
			{
				return false;
			}
			finally
			{
				Con.Close();
			}
		}
		public bool InsertNewsData(string NewsTitle,string NewsContent,int kid)
		{
			DB db=new DB();
			SqlConnection Con=db.GetConnection();
			string Sql="insert into News(NewsTitle,NewsContent,PubDate,KindId)values('"+NewsTitle+"','"+NewsContent+"',GetDate(),'"+kid.ToString()+"')";
			SqlCommand Cmd=new SqlCommand(Sql,Con);
			try
			{
				Con.Open();
				Cmd.ExecuteNonQuery();
				return true;
			}
			catch
			{
				return false;
			}
			finally
			{
				Con.Close();
			}
		}
	}
}