artaccess.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 ArtAccess
	{
		private string connString=ConfigHelper.ConnString;

		#region Update

		/// <summary>
		/// 更新帖子的资料
		/// </summary>
		/// <param name="art">要更新的帖子</param>
		public void Update(Art art)
		{
			SqlParameter[] parms=this.getUpdateParms();
			this.setUpdateParms(parms,art);

			if(art is TopArt)
				SQLHelper.ExecuteNonQuery(connString,CommandType.StoredProcedure,"topics_Update",parms);
			else
				SQLHelper.ExecuteNonQuery(connString,CommandType.StoredProcedure,"replies_Update",parms);

		}

		private SqlParameter[] getUpdateParms()
		{
			SqlParameter[] parms=SQLHelper.GetCachedParameters("UpdateArt");
			
			if(parms==null)
			{
				parms=new SqlParameter[]{
											new SqlParameter("@aid",SqlDbType.Int,0),
											new SqlParameter("@topic",SqlDbType.VarChar,100),
											new SqlParameter("@content",SqlDbType.Text,0),
										};
				SQLHelper.CacheParameters("UpdateArt",parms);
			}

			return parms;
		}

		private void setUpdateParms(SqlParameter[] parms,Art art)
		{
			parms[0].Value=art.Aid;
			parms[1].Value=art.Caption;
			parms[2].Value=art.Content;
		}

		#endregion

		#region Up

		/// <summary>
		/// 置顶
		/// </summary>
		/// <param name="art">要置顶的帖子</param>
		public void Up(Art art)
		{
			SqlParameter[] parms=this.getUpParms();
			this.setUpParms(parms,art);
			
			SQLHelper.ExecuteNonQuery(connString,CommandType.StoredProcedure,"topics_Up",parms);

		}

		private SqlParameter[] getUpParms()
		{
			SqlParameter[] parms=SQLHelper.GetCachedParameters("Up");
			
			if(parms==null)
			{
				parms=new SqlParameter[]{
											new SqlParameter("@aid",SqlDbType.Int,0),
											new SqlParameter("@up",SqlDbType.SmallInt,0)
				};
				SQLHelper.CacheParameters("Up",parms);
			}

			return parms;
		}

		private void setUpParms(SqlParameter[] parms,Art art)
		{
			parms[0].Value=art.Aid;
			parms[1].Value=art.Up;
		}

		#endregion


        #region Create

		#region TopArt

		/// <summary>
		/// 添加帖子
		/// </summary>
		/// <param name="art">要添加的帖子</param>
		public void Create(TopArt art)
		{
			SqlParameter[] parms=this.getCreateTopParms();
			this.setCreateTopParms(parms,art);
			SQLHelper.ExecuteNonQuery(connString,CommandType.StoredProcedure,"topics_Create",parms);
		}

		private SqlParameter[] getCreateTopParms()
		{
			SqlParameter[] parms=SQLHelper.GetCachedParameters("CreateTopArt");
			
			if(parms==null)
			{
				parms=new SqlParameter[]{
											new SqlParameter("@topic",SqlDbType.VarChar,100),
											new SqlParameter("@content",SqlDbType.Text,0),
											new SqlParameter("@addedMember",SqlDbType.VarChar,20),
											new SqlParameter("@themeId",SqlDbType.Int,0),
				};
				SQLHelper.CacheParameters("CreateTopArt",parms);
			}

			return parms;
		}

		private void setCreateTopParms(SqlParameter[] parms,TopArt art)
		{
			parms[0].Value=art.Caption;
			parms[1].Value=art.Content;
			parms[2].Value=art.AddedMemberName;
			parms[3].Value=art.ThemeId;
		}

		#endregion

        #region CommonArt

		/// <summary>
		/// 添加帖子
		/// </summary>
		/// <param name="art">要添加的帖子</param>
		public void Create(CommonArt art)
		{
			SqlParameter[] parms=this.getCreateCommonParms();
		    this.setCreateCommonParms(parms,art);
		    SQLHelper.ExecuteNonQuery(connString,CommandType.StoredProcedure,"replies_Create",parms);
		}
		
		private SqlParameter[] getCreateCommonParms()
		{
			SqlParameter[] parms=SQLHelper.GetCachedParameters("CreateCommonArt");
			
			if(parms==null)
			{
				parms=new SqlParameter[]{
											new SqlParameter("@topic",SqlDbType.VarChar,50),
											new SqlParameter("@content",SqlDbType.Text,0),
											new SqlParameter("@addedMember",SqlDbType.VarChar,20),
											new SqlParameter("@ReplyTid",SqlDbType.Int,0),
											new SqlParameter("@themeId",SqlDbType.Int,0),
				};
				SQLHelper.CacheParameters("CreateCommonArt",parms);
			}

			return parms;
		}

		private void setCreateCommonParms(SqlParameter[] parms,CommonArt art)
		{
			parms[0].Value=art.Caption;
			parms[1].Value=art.Content;
			parms[2].Value=art.AddedMemberName;
			parms[3].Value=art.ReplyTid;
			parms[4].Value=art.ThemeId;
		}

		#endregion

		#endregion

		#region Remove

		
		/// <summary>
		/// 删除帖子
		/// </summary>
	   /// <param name="art">要删除的帖子</param>
		public void Remove(Art art)
		{
			SqlParameter[] parms=new SqlParameter[]{
													   new SqlParameter("@aid",SqlDbType.Int,0)
												   };
			parms[0].Value=art.Aid;

			if(art is TopArt)
				SQLHelper.ExecuteNonQuery(connString,CommandType.StoredProcedure,"topics_DeleteBytid",parms);
			else
				SQLHelper.ExecuteNonQuery(connString,CommandType.StoredProcedure,"replies_DeleteByrid",parms);
		}

		#endregion

		#region SelectInfo

		
		/// <summary>
		/// 查找帖子信息
		/// </summary>
		/// <param name="art">要填充的帖子</param>
		public void SelectInfo(Art art)
		{
			SqlParameter[] parms=new SqlParameter[]{
													   new SqlParameter("@aid",SqlDbType.Int,0)
												   };
			parms[0].Value=art.Aid;

			SqlDataReader sdr;
			if(art is TopArt)
				sdr=SQLHelper.ExecuteReader(connString,CommandType.StoredProcedure,"topics_SelectInfoByTid",parms);
			else
				sdr=SQLHelper.ExecuteReader(connString,CommandType.StoredProcedure,"replies_SelectInfoByRid",parms);
			using(sdr)
			{
				if(sdr.Read())
				{
					art.Caption=sdr.GetString(1);
					art.Content=sdr.GetString(2);
				}
			}
		}

		#endregion


	}
}