affichesmake.cs

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

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

namespace Com.SMS.Dal
{
	/// <summary>
	/// AffichesMake 的摘要说明。
	/// </summary>
	public class AffichesMake
	{
		/// <summary>
		/// 发布公告
		/// </summary>
		/// <param name="ass"></param>
		/// <returns></returns>
		public bool Insert(Entity.Affiches ass)
		{
			SqlParameter[] parms=
			{
				new SqlParameter("@aTitle",ass.ATitle),
				new SqlParameter("@aContent",ass.AContent),
				new SqlParameter("@sendId",ass.SendId),
				new SqlParameter("@sendTime",ass.SendTime),
			};

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

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

		/// <summary>
		/// 删除公告
		/// </summary>
		/// <param name="aId"></param>
		/// <returns></returns>
		public bool Delete(int aId)
		{
			int i=SqlBasic.ExecuteNonQuery(
				SqlBasic.CONN_STRING,
				CommandType.Text,
				SqlCollections.SQL_AFFICHES_DELETE,
				new SqlParameter("@aId",aId)
				);

			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_AFFICHES_SELECTALL,
				dt
				);

			return dt;
		}

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

			return dt;
		}
	}
}