document.cs

来自「《精通ASP.NET2.0网络应用系统开发》书中的源码」· CS 代码 · 共 235 行

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 SQLHelper;
using System.Data.SqlClient;

namespace DocumentManager
{
    /// <summary>
    /// Summary description for Document
    /// </summary>
    public class Document
    {
        public SqlDataReader GetDocuments()
        {
            ///定义类SQLHelper
            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

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

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

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

        public SqlDataReader GetDocumentByCategory(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_GetDocumentByCategory", paramList, out dr);
            }
            catch (Exception ex)
            {
                ///抛出执行数据库异常
                SystemError.CreateErrorLog(ex.Message);
                throw new Exception(ex.Message, ex);
            }

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

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

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

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

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

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

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

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

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

        public void UpdateDocument(int nDocumentID, string sDesn, string sBody, int nCategoryID,
            string sAuthor, string sFromSource)
        {
            ///定义类SQLHelper
            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

            ///创建访问数据库的参数			
            SqlParameter[] paramList = {
                sqlHelper.CreateInParam("@DocumentID",SqlDbType.Int,4,nDocumentID),
                sqlHelper.CreateInParam("@Desn",SqlDbType.VarChar,200,sDesn),
                sqlHelper.CreateInParam("@Body",SqlDbType.VarChar,8000,sBody),
                sqlHelper.CreateInParam("@CategoryID",SqlDbType.Int,4,nCategoryID),
                sqlHelper.CreateInParam("@Author",SqlDbType.VarChar,200,sAuthor),
                sqlHelper.CreateInParam("@FromSource",SqlDbType.VarChar,200,sFromSource)								   
			};

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

        public void UpdateDocumentIsAttachment(int nDocumentID,int nIsAttachment)
        {
            ///定义类SQLHelper
            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

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

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

        public void UpdateDocumentView(int nDocumentID,int nUserID)
        {
            ///定义类SQLHelper
            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

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

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

        public int DeleteDocument(int nDocumentID)
        {
            ///定义类SQLHelper
            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

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

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

            return ((int)paramList[1].Value);
        }
    }
}