newsmake.cs

企业内部的短信交流管理平台。 设计详细

using System;
using System.Data;
using System.Data.SqlClient;

namespace Com.SMS.Dal
{
	/// <summary>
	/// NewsMake 的摘要说明。
	/// </summary>
	public class NewsMake
	{
		/// <summary>
		/// 发布新闻
		/// </summary>
		/// <param name="ns"></param>
		/// <returns></returns>
		public bool Insert(Entity.News ns)
		{
			SqlParameter[] parms=
			{
				new SqlParameter("@newsTitle",ns.NewsTitle),
				new SqlParameter("@newsContent",ns.NewsContent),
				new SqlParameter("@sendId",ns.SendId),
				new SqlParameter("@sendTime",ns.SendTime),
			};

			int i=SqlBasic.ExecuteNonQuery(
				SqlBasic.CONN_STRING,
				CommandType.Text,
				SqlCollections.SQL_NEWS_INSERT,
				parms
				);

			if(i==1)
			{
				return true;
			}else
				return false;
		}

		/// <summary>
		/// 删除新闻
		/// </summary>
		/// <param name="newsId"></param>
		/// <returns></returns>
		public bool Delete(int newsId)
		{
			int i=SqlBasic.ExecuteNonQuery(
				SqlBasic.CONN_STRING,
				CommandType.Text,
				SqlCollections.SQL_NEWS_DELETE,
				new SqlParameter("@newsId",newsId)
				);

			if(i==1)
			{
				return true;
			}else
				return false;
		}

		/// <summary>
		/// 查询所有新闻
		/// </summary>
		/// <returns></returns>
		public DataTable FindAll()
		{
			DataTable dt=new DataTable();
			SqlBasic.FillDatatable(
				SqlBasic.CONN_STRING,
				CommandType.Text,
				SqlCollections.SQL_NEWS_SELECTALL,
				dt
				);

			return dt;
		}

		/// <summary>
		/// 按编号查询新闻
		/// </summary>
		/// <param name="newsId"></param>
		/// <returns></returns>
		public DataTable FindById(int newsId)
		{
			DataTable dt=new DataTable();
			SqlBasic.FillDatatable(
				SqlBasic.CONN_STRING,
				CommandType.Text,
				SqlCollections.SQL_NEWS_SELECTBYID,
				dt,
				new SqlParameter("@newsId",newsId)
				);

			return dt;
		}
	}
}