attachment.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 DocumentManager
{
    /// <summary>
    /// Summary description for Attachment
    /// </summary>
    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 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_GetAttachmentByDocument", 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 nAttachType,
            int nDocumentID)
        {
            ///定义类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("@AttachType",SqlDbType.Int,4,nAttachType),
                sqlHelper.CreateInParam("@DocumentID",SqlDbType.Int,4,nDocumentID)
            };

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

        public void UpdateAttachment(int nAttachmentID, string sDesn)
        {
            ///定义类SQLHelper
            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

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

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