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

namespace OfficeAutomatization
{
    /// <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 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 nUserID,string sAuthor,
			string sFromSource,string sUrl,string sRemark)
        {
            ///定义类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("@Author",SqlDbType.VarChar,200,sAuthor),
                sqlHelper.CreateInParam("@FromSource",SqlDbType.VarChar,200,sFromSource),
				sqlHelper.CreateInParam("@Url",SqlDbType.VarChar,200,sUrl),
				sqlHelper.CreateInParam("@Remark",SqlDbType.VarChar,8000,sRemark)
            };

            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, string sAuthor,
			string sFromSource,string sRemark)
        {
            ///定义类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("@Author",SqlDbType.VarChar,200,sAuthor),
                sqlHelper.CreateInParam("@FromSource",SqlDbType.VarChar,200,sFromSource),
				sqlHelper.CreateInParam("@Remark",SqlDbType.VarChar,8000,sRemark)
            };

            try
            {
                ///执行存储过程
				sqlHelper.RunProc("Pr_UpdateDocument", 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)
			};

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

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