placardaccess.cs

前台：asp.net；后台: sql server 一个功能完善的BBS系统源码。

using System;
using System.Collections;
using Stella.Model;
using Stella.Utility;
using System.Data;
using System.Data.SqlClient;

namespace Stella.SQLServerDAL
{
	/// <summary>
	/// 对通告的操作
	/// </summary>
	public class PlacardAccess
	{
		private string connString=ConfigHelper.ConnString;

		#region Create

		/// <summary>
		/// 创建新通告
		/// </summary>
		/// <param name="placard">新通告</param>
		public void Create(Placard placard)
		{
			SqlParameter[] parms=this.getCreateParms();
			this.setCreateParms(parms,placard);

			SQLHelper.ExecuteNonQuery(connString,CommandType.StoredProcedure,"placards_Create",parms);
		}

		private SqlParameter[] getCreateParms()
		{
			SqlParameter[] parms=SQLHelper.GetCachedParameters("CreatePlacard");
			
			if(parms==null)
			{
				parms=new SqlParameter[]{
											new SqlParameter("@topic",SqlDbType.VarChar,50),
											new SqlParameter("@content",SqlDbType.NText,0),
											new SqlParameter("@addedAdminer",SqlDbType.VarChar,20),
				};
				SQLHelper.CacheParameters("CreatePlacard",parms);
			}

			return parms;
		}

		private void setCreateParms(SqlParameter[] parms,Placard placard)
		{
			parms[0].Value=placard.Topic;
			parms[1].Value=placard.Content;
			parms[2].Value=placard.AddedAdminer;
		}

		#endregion

		#region Update

		/// <summary>
		/// 更新通告
		/// </summary>
		/// <param name="placard">新通告</param>
		public void Update(Placard placard)
		{
			SqlParameter[] parms=this.getCreateParms();
			this.setCreateParms(parms,placard);

			SQLHelper.ExecuteNonQuery(connString,CommandType.StoredProcedure,"placards_Create",parms);
		}

		private SqlParameter[] getUpdateParms()
		{
			SqlParameter[] parms=SQLHelper.GetCachedParameters("UpdatePlacard");
			
			if(parms==null)
			{
				parms=new SqlParameter[]{
											new SqlParameter("@tid",SqlDbType.Int,0),
											new SqlParameter("@topic",SqlDbType.Text,50),
											new SqlParameter("@content",SqlDbType.NText,0),
				};
				SQLHelper.CacheParameters("UpdatePlacard",parms);
			}

			return parms;
		}

		private void setUpdateParms(SqlParameter[] parms,Placard placard)
		{
			parms[0].Value=placard.Pid;
			parms[1].Value=placard.Topic;
			parms[2].Value=placard.Content;
		}

		#endregion

		#region GetInfo

		/// <summary>
		/// 获取通告信息
		/// </summary>
		/// <param name="id">通告的编号</param>
		public Placard GetInfo(int id)
		{
			SqlParameter[] parms=new SqlParameter[]{
													   new SqlParameter("@pid",SqlDbType.Int,0)
												   };
			parms[0].Value=id;

			Placard placard=new Placard();

			using(SqlDataReader sdr=SQLHelper.ExecuteReader(connString,CommandType.StoredProcedure,"heads_SelectInfoByhid",parms))
			{
				if(sdr.Read())
				{
					placard.Pid=sdr.GetInt32(0);
					placard.Topic=sdr.GetString(1);
					placard.Content=sdr.GetString(2);
					placard.AddedAdminer=sdr.GetString(3);
					placard.AddedDate=sdr.GetDateTime(4);
				}
			}

			return placard;
		}

		#endregion

		#region FillList

		/// <summary>
		/// 获得通告列表
		/// </summary>
		/// <param name="placards">要填充的通告列表</param>
		public void FillList(PlacardList placards)
		{
			using(SqlDataReader sdr=SQLHelper.ExecuteReader(connString,CommandType.StoredProcedure,"placards_SelectInfo",null))
			{
				Placard placard;

				while(sdr.Read())
				{
					placard=new Placard();

					placard.Pid=sdr.GetInt32(0);
					placard.Topic=sdr.GetString(1);
					placard.Content=sdr.GetString(2);
					placard.AddedAdminer=sdr.GetString(3);
					placard.AddedDate=sdr.GetDateTime(4);

					placards.AddPlacard(placard);
				}
			}
		}

		#endregion

		#region Remove

		/// <summary>
		/// 删除通告
		/// </summary>
		/// <param name="id">通告的编号</param>
		public void Remove(int id)
		{
			SqlParameter[] parms=new SqlParameter[]{
													   new SqlParameter("@pid",SqlDbType.Int,0)
												   };
			parms[0].Value=id;

			SQLHelper.ExecuteNonQuery(connString,CommandType.StoredProcedure,"placards_DeleteBypid",parms);
			
		}

		#endregion

	}
}