📄 bbsdata.cs

📁 一个简单的网上书店形式
💻 CS
字号:
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using SQLHelper;

namespace ASPNET2BBS
{
	public class AttachmentsInfo
	{
		public string Desn;
		public string Url;
	}

	public class Title
	{
		public SqlDataReader GetTitles()
		{
			///定义类SQLHelper
			SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

			///定义保存从数据库获取的结果的DataReader
			SqlDataReader dr = null;

			try
			{
				///执行存储过程
				sqlHelper.RunProc("Pr_GetTitles", out dr);
			}
			catch (Exception ex)
			{
				///抛出执行数据库异常
				SystemError.CreateErrorLog(ex.Message);
				throw new Exception(ex.Message, ex);
			}

			///返回从数据库获取的结果
			return (dr);
		}

		public SqlDataReader GetTitleByCategory(int nCategoryID)
		{
			///定义类SQLHelper
			SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

			///定义保存从数据库获取的结果的DataReader
			SqlDataReader dr = null;

			///创建访问数据库的参数			
			SqlParameter[] paramList = {
				sqlHelper.CreateInParam("@CategoryID",SqlDbType.Int,4,nCategoryID)
			};

			try
			{
				///执行存储过程
				sqlHelper.RunProc("Pr_GetTitleByCategory", paramList, out dr);
			}
			catch (Exception ex)
			{
				///抛出执行数据库异常
				SystemError.CreateErrorLog(ex.Message);
				throw new Exception(ex.Message, ex);
			}

			///返回从数据库获取的结果
			return (dr);
		}

		public SqlDataReader GetSingleTitle(int nTitleID)
		{
			///定义类SQLHelper
			SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

			///定义保存从数据库获取的结果的DataReader
			SqlDataReader dr = null;

			///创建访问数据库的参数			
			SqlParameter[] paramList = {
				sqlHelper.CreateInParam("@TitleID",SqlDbType.Int,4,nTitleID)
			};

			try
			{
				///执行存储过程
				sqlHelper.RunProc("Pr_GetSingleTitle", paramList, out dr);
			}
			catch (Exception ex)
			{
				///抛出执行数据库异常
				SystemError.CreateErrorLog(ex.Message);
				throw new Exception(ex.Message, ex);
			}

			///返回从数据库获取的结果
			return (dr);
		}

		public int AddTitle(int nCategoryID,string sDesn,string sBody,int nUserID,int nFlag)
		{
			///定义类SQLHelper
			SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

			///创建访问数据库的参数			
			SqlParameter[] paramList = {
				sqlHelper.CreateInParam("@CategoryID",SqlDbType.Int,4,nCategoryID),
				sqlHelper.CreateInParam("@Desn",SqlDbType.VarChar,200,sDesn),
				sqlHelper.CreateInParam("@Body",SqlDbType.VarChar,8000,sBody),
                sqlHelper.CreateInParam("@UserID",SqlDbType.Int,4,nUserID),
				sqlHelper.CreateInParam("@Flag",SqlDbType.Int,4,nFlag)
            };

			try
			{
				///执行存储过程
				return (sqlHelper.RunProc("Pr_AddTitle", paramList));
			}
			catch (Exception ex)
			{
				///抛出执行数据库异常
				SystemError.CreateErrorLog(ex.Message);
				throw new Exception(ex.Message, ex);
			}
		}

		public void UpdateTitle(int nTitleID,string sDesn,string sBody)
		{
			///定义类SQLHelper
			SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

			///创建访问数据库的参数			
			SqlParameter[] paramList = {
				sqlHelper.CreateInParam("@TitleID",SqlDbType.Int,4,nTitleID),
				sqlHelper.CreateInParam("@Desn",SqlDbType.VarChar,200,sDesn),
				sqlHelper.CreateInParam("@Body",SqlDbType.VarChar,8000,sBody)
            };

			try
			{
				///执行存储过程
				sqlHelper.RunProc("Pr_UpdateTitle", paramList);
			}
			catch (Exception ex)
			{
				///抛出执行数据库异常
				SystemError.CreateErrorLog(ex.Message);
				throw new Exception(ex.Message, ex);
			}
		}

		public void UpdateTitleVisitNum(int nTitleID)
		{
			///定义类SQLHelper
			SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

			///创建访问数据库的参数			
			SqlParameter[] paramList = {
				sqlHelper.CreateInParam("@TitleID",SqlDbType.Int,4,nTitleID)
			};

			try
			{
				///执行存储过程
				sqlHelper.RunProc("Pr_UpdateTitleVisitNum", paramList);
			}
			catch (Exception ex)
			{
				///抛出执行数据库异常
				SystemError.CreateErrorLog(ex.Message);
				throw new Exception(ex.Message, ex);
			}
		}

		public void UpdateTitleAnswerNum(int nTitleID)
		{
			///定义类SQLHelper
			SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

			///创建访问数据库的参数			
			SqlParameter[] paramList = {
				sqlHelper.CreateInParam("@TitleID",SqlDbType.Int,4,nTitleID)
			};

			try
			{
				///执行存储过程
				sqlHelper.RunProc("Pr_UpdateTitleAnswerNum", paramList);
			}
			catch (Exception ex)
			{
				///抛出执行数据库异常
				SystemError.CreateErrorLog(ex.Message);
				throw new Exception(ex.Message, ex);
			}
		}

		public void DeleteTitle(int nTitleID)
		{
			///定义类SQLHelper
			SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

			///创建访问数据库的参数			
			SqlParameter[] paramList = {
				sqlHelper.CreateInParam("@TitleID",SqlDbType.Int,4,nTitleID)
			};

			try
			{
				///执行存储过程
				sqlHelper.RunProc("Pr_DeleteTitle", paramList);
			}
			catch (Exception ex)
			{
				///抛出执行数据库异常
				SystemError.CreateErrorLog(ex.Message);
				throw new Exception(ex.Message, ex);
			}
		}
	}

	public class Content
	{
		public SqlDataReader GetContents()
		{
			///定义类SQLHelper
			SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

			///定义保存从数据库获取的结果的DataReader
			SqlDataReader dr = null;

			try
			{
				///执行存储过程
				sqlHelper.RunProc("Pr_GetContents", out dr);
			}
			catch (Exception ex)
			{
				///抛出执行数据库异常
				SystemError.CreateErrorLog(ex.Message);
				throw new Exception(ex.Message, ex);
			}

			///返回从数据库获取的结果
			return (dr);
		}

		public SqlDataReader GetContentByTitle(int nTitleID)
		{
			///定义类SQLHelper
			SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

			///定义保存从数据库获取的结果的DataReader
			SqlDataReader dr = null;

			///创建访问数据库的参数			
			SqlParameter[] paramList = {
				sqlHelper.CreateInParam("@TitleID",SqlDbType.Int,4,nTitleID)
			};

			try
			{
				///执行存储过程
				sqlHelper.RunProc("Pr_GetContentByTitle", paramList, out dr);
			}
			catch (Exception ex)
			{
				///抛出执行数据库异常
				SystemError.CreateErrorLog(ex.Message);
				throw new Exception(ex.Message, ex);
			}

			///返回从数据库获取的结果
			return (dr);
		}

		public SqlDataReader GetSingleContent(int nContentID)
		{
			///定义类SQLHelper
			SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

			///定义保存从数据库获取的结果的DataReader
			SqlDataReader dr = null;

			///创建访问数据库的参数			
			SqlParameter[] paramList = {
				sqlHelper.CreateInParam("@ContentID",SqlDbType.Int,4,nContentID)
			};

			try
			{
				///执行存储过程
				sqlHelper.RunProc("Pr_GetSingleContent", paramList, out dr);
			}
			catch (Exception ex)
			{
				///抛出执行数据库异常
				SystemError.CreateErrorLog(ex.Message);
				throw new Exception(ex.Message, ex);
			}

			///返回从数据库获取的结果
			return (dr);
		}

		public int AddContent(int nTitleID, string sDesn, string sBody, int nUserID, int nFlag)
		{
			///定义类SQLHelper
			SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

			///创建访问数据库的参数			
			SqlParameter[] paramList = {
				sqlHelper.CreateInParam("@TitleID",SqlDbType.Int,4,nTitleID),
				sqlHelper.CreateInParam("@Desn",SqlDbType.VarChar,200,sDesn),
				sqlHelper.CreateInParam("@Body",SqlDbType.VarChar,8000,sBody),
                sqlHelper.CreateInParam("@UserID",SqlDbType.Int,4,nUserID),
				sqlHelper.CreateInParam("@Flag",SqlDbType.Int,4,nFlag)
            };

			try
			{
				///执行存储过程
				return (sqlHelper.RunProc("Pr_AddContent", paramList));
			}
			catch (Exception ex)
			{
				///抛出执行数据库异常
				SystemError.CreateErrorLog(ex.Message);
				throw new Exception(ex.Message, ex);
			}
		}

		public void UpdateContent(int nContentID, string sDesn, string sBody)
		{
			///定义类SQLHelper
			SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

			///创建访问数据库的参数			
			SqlParameter[] paramList = {
				sqlHelper.CreateInParam("@ContentID",SqlDbType.Int,4,nContentID),
				sqlHelper.CreateInParam("@Desn",SqlDbType.VarChar,200,sDesn),
				sqlHelper.CreateInParam("@Body",SqlDbType.VarChar,8000,sBody)
            };

			try
			{
				///执行存储过程
				sqlHelper.RunProc("Pr_UpdateContent", paramList);
			}
			catch (Exception ex)
			{
				///抛出执行数据库异常
				SystemError.CreateErrorLog(ex.Message);
				throw new Exception(ex.Message, ex);
			}
		}
		
		public void DeleteContent(int nContentID)
		{
			///定义类SQLHelper
			SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

			///创建访问数据库的参数			
			SqlParameter[] paramList = {
				sqlHelper.CreateInParam("@ContentID",SqlDbType.Int,4,nContentID)
			};

			try
			{
				///执行存储过程
				sqlHelper.RunProc("Pr_DeleteContent", paramList);
			}
			catch (Exception ex)
			{
				///抛出执行数据库异常
				SystemError.CreateErrorLog(ex.Message);
				throw new Exception(ex.Message, ex);
			}
		}
	}

	public class Attachment
	{
		public SqlDataReader GetAttachments()
		{
			///定义类SQLHelper
			SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

			///定义保存从数据库获取的结果的DataReader
			SqlDataReader dr = null;

			try
			{
				///执行存储过程
				sqlHelper.RunProc("Pr_GetAttachments", out dr);
			}
			catch (Exception ex)
			{
				///抛出执行数据库异常
				SystemError.CreateErrorLog(ex.Message);
				throw new Exception(ex.Message, ex);
			}

			///返回从数据库获取的结果
			return (dr);
		}

		public SqlDataReader GetAttachmentByDocument(int nContentID)
		{
			///定义类SQLHelper
			SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

			///定义保存从数据库获取的结果的DataReader
			SqlDataReader dr = null;

			///创建访问数据库的参数			
			SqlParameter[] paramList = {
				sqlHelper.CreateInParam("@ContentID",SqlDbType.Int,4,nContentID)
			};

			try
			{
				///执行存储过程
				sqlHelper.RunProc("Pr_GetAttachmentByContent", paramList, out dr);
			}
			catch (Exception ex)
			{
				///抛出执行数据库异常
				SystemError.CreateErrorLog(ex.Message);
				throw new Exception(ex.Message, ex);
			}

			///返回从数据库获取的结果
			return (dr);
		}

		public SqlDataReader GetSingleAttachment(int nAttachmentID)
		{
			///定义类SQLHelper
			SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

			///定义保存从数据库获取的结果的DataReader
			SqlDataReader dr = null;

			///创建访问数据库的参数			
			SqlParameter[] paramList = {
				sqlHelper.CreateInParam("@AttachmentID",SqlDbType.Int,4,nAttachmentID)
			};

			try
			{
				///执行存储过程
				sqlHelper.RunProc("Pr_GetSingleAttachment", paramList, out dr);
			}
			catch (Exception ex)
			{
				///抛出执行数据库异常
				SystemError.CreateErrorLog(ex.Message);
				throw new Exception(ex.Message, ex);
			}

			///返回从数据库获取的结果
			return (dr);
		}

		public int AddAttachment(string sDesn, string sUrl, string sFileType,
			int nContentID)
		{
			///定义类SQLHelper
			SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

			///创建访问数据库的参数			
			SqlParameter[] paramList = {
                sqlHelper.CreateInParam("@Desn",SqlDbType.VarChar,200,sDesn),
                sqlHelper.CreateInParam("@Url",SqlDbType.VarChar,200,sUrl),
                sqlHelper.CreateInParam("@FileType",SqlDbType.VarChar,200,sFileType),
                sqlHelper.CreateInParam("@ContentID",SqlDbType.Int,4,nContentID)
            };

			try
			{
				///执行存储过程
				return (sqlHelper.RunProc("Pr_AddAttachment", paramList));
			}
			catch (Exception ex)
			{
				///抛出执行数据库异常
				SystemError.CreateErrorLog(ex.Message);
				throw new Exception(ex.Message, ex);
			}
		}

		public void DeleteAttachment(int nAttachmentID)
		{
			///定义类SQLHelper
			SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

			///创建访问数据库的参数			
			SqlParameter[] paramList = {
				sqlHelper.CreateInParam("@AttachmentID",SqlDbType.Int,4,nAttachmentID)
			};

			try
			{
				///执行存储过程
				sqlHelper.RunProc("Pr_DeleteAttachment", paramList);
			}
			catch (Exception ex)
			{
				///抛出执行数据库异常
				SystemError.CreateErrorLog(ex.Message);
				throw new Exception(ex.Message, ex);
			}
		}
	}
}
💿 文件大小 1266 K
👤 上传用户 jinhongfei0528
📂 所属分类书籍源码
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -