Esempio n. 1
0
        /// <summary>
        /// 文件主体添加
        /// </summary>
        /// <param name="DocBody"> 文件主体类</param>
        public string AddDocBody(DocBody docbody)
        {
            // create data object and params
            Database data  = new Database();
            string   DocID = "";

            SqlParameter[] prams =
            {
                data.MakeInParam("@ClassID",        SqlDbType.Int,        20, docbody.DocClassID),
                data.MakeInParam("@DocTitle",       SqlDbType.NVarChar,  300, docbody.DocTitle),
                data.MakeInParam("@DocContent",     SqlDbType.NVarChar, 5000, docbody.DocContent),
                data.MakeInParam("@DocApprover",    SqlDbType.NVarChar,  200, docbody.DocApprover),
                data.MakeInParam("@DocApproveDate", SqlDbType.NVarChar,   20, docbody.DocApproveDate),
                data.MakeInParam("@DocApproved",    SqlDbType.Int,         1, docbody.DocApproved),
                data.MakeInParam("@DocType",        SqlDbType.Int,         2, docbody.DocType),
                data.MakeInParam("@DocAttribute",   SqlDbType.Int,         2, docbody.DocAttribute),
                data.MakeInParam("@DocAddedBy",     SqlDbType.NVarChar,  300, docbody.DocAddedBy),
                data.MakeInParam("@DocAddedDate",   SqlDbType.DateTime,  300, DateTime.Parse(docbody.DocAddedDate)),
                data.MakeOutParam("@CurrentDocID",  SqlDbType.Int, 2)
            };



            try
            {
                data.RunProc("SP_Ext_AddDocument", prams);
                DocID = prams[10].Value.ToString();
                if (DocID == string.Empty)
                {
                    return(null);
                }
                else
                {
                    return(DocID);
                }
            }
            catch (Exception ex)
            {
                Error.Log(ex.ToString());
                throw new Exception("文档正文增加错误!", ex);
            }
        }
Esempio n. 2
0
        /// <summary>
        /// �ļ��������
        /// </summary>
        /// <param name="DocBody"> �ļ�������</param>
        public string AddDocBody(DocBody docbody)
        {
            // create data object and params
            Database data = new Database();
            string DocID = "";
            SqlParameter[] prams = {
                                       data.MakeInParam("@ClassID",   SqlDbType.Int, 20, docbody.DocClassID),
                                       data.MakeInParam("@DocTitle",  SqlDbType.NVarChar, 300, docbody.DocTitle),
                                       data.MakeInParam("@DocContent",SqlDbType.NText, 8000,docbody.DocContent),
                                       data.MakeInParam("@DocApprover",  SqlDbType.NVarChar,200, docbody.DocApprover),
                                       data.MakeInParam("@DocApproveDate",  SqlDbType.NVarChar, 20, docbody.DocApproveDate),
                                       data.MakeInParam("@DocApproved",  SqlDbType.Int, 1, docbody.DocApproved),
                                       data.MakeInParam("@DocType",  SqlDbType.Int, 2, docbody.DocType),
                                       data.MakeInParam("@DocAttribute",  SqlDbType.Int , 2, docbody.DocAttribute),
                                       data.MakeInParam("@DocAddedBy",  SqlDbType.NVarChar, 300, docbody.DocAddedBy),
                                       data.MakeInParam("@DocAddedDate",  SqlDbType.DateTime, 300,DateTime.Parse(docbody.DocAddedDate)),
                                       data.MakeOutParam("@CurrentDocID",  SqlDbType.Int, 2)
                                   };

            try
            {
                data.RunProc("SP_Ext_AddDocument", prams);
                DocID = prams[10].Value.ToString();
                if (DocID == string.Empty )
                    return null;
                else
                    return DocID;
            }
            catch (Exception ex)
            {
                Error.Log(ex.ToString());
                throw new Exception("�ĵ��������Ӵ���!",ex);
            }
            finally
            {
                if (data != null)
                {
                    data.Close();
                    data.Dispose();
                }

            }
        }
Esempio n. 3
0
        /// <summary>
        /// ������post����
        /// </summary>
        private DocBody ProcessFormPost()
        {
            ProjectClass pjt  = new ProjectClass ();
            int cstRightToApproveDocument = 2;
            //����֤
            if(Request.IsAuthenticated)
            {

                // ���������ݲ���
                DocBody  docbody			= new DocBody();
                docbody.DocTitle			= this.txtTitle.Value;
                docbody.DocContent			= this.txtContent.Value;
                docbody.DocAddedBy			= Username;
                docbody.DocClassID			= Int32.Parse(ClassID);
                docbody.DocAddedDate        = DateTime.Now.ToString();
                docbody.DocApprover			= (pjt.GetAccessPermission(Int32.Parse(ClassID),Username,cstRightToApproveDocument))?Username:"";
                docbody.DocApproveDate		= (pjt.GetAccessPermission(Int32.Parse(ClassID),Username,cstRightToApproveDocument))?DateTime.Now.ToString():"";
                docbody.DocApproved         = (docbody.DocApprover =="")?0:1;
                docbody.DocAttribute        = 0;
                docbody.DocType				= 0;
                return docbody;
            }
            else
            {
                return null;
            }
        }
Esempio n. 4
0
        /// <summary>
        /// �ĵ��������������ĵ��������������
        /// </summary>
        private void DocProcess(MailMainBody mailbody,ArrayList upattlist)
        {
            string DocID = "";
            int cstRightToApproveDocument = 2;
            ProjectClass pjt = new ProjectClass();
            DocBody docbody = new DocBody();
            docbody.DocTitle			= mailbody.MailSubject;
            docbody.DocContent			= mailbody.MailBody;
            docbody.DocAddedBy			= mailbody.MailSender;
            docbody.DocClassID			= mailbody.MailClassID;
            docbody.DocAddedDate        = DateTime.Now.ToString();
            docbody.DocApprover			= (pjt.GetAccessPermission(Int32.Parse(ClassID),Username,cstRightToApproveDocument))?Username:"";
            docbody.DocApproveDate		= (pjt.GetAccessPermission(Int32.Parse(ClassID),Username,cstRightToApproveDocument))?DateTime.Now.ToString():"";
            docbody.DocApproved         = (docbody.DocApprover =="")?0:1;
            docbody.DocAttribute        = 0;
            docbody.DocType				= 0;

            DocumentClass doc = new DocumentClass();
            // ����ĵ�,������ID

            DocID = doc.AddDocBody(docbody);
            foreach(UDS.Components.MailAttachFile  att in upattlist)
            {
                try
                {
                    DocAttachFile docatt = new DocAttachFile();
                    //  Mail Attach File ��ת��ΪDoc Attach File
                    docatt.FileAttribute  = 0;
                    docatt.FileSize       = att.FileSize;
                    docatt.FileName	      = att.FileName;
                    docatt.FileAuthor     = Username;
                    docatt.FileCatlog     = "�ĵ�";
                    docatt.FileVisualPath = "Mail"+att.FileVisualPath;
                    docatt.FileAddedDate  = DateTime.Now.ToString();
                    docatt.DocID          = Int32.Parse(DocID);
                    // ת������

                    // �������ݿ⴦��
                    doc.AddAttach(docatt,Int32.Parse(DocID));

                }
                catch(Exception ioex)
                {
                    UDS.Components.Error.Log(ioex.ToString());
                    Server.Transfer("../../Error.aspx");
                }
            }
        }
Esempio n. 5
0
        public void MailIncoming(string MailID,string ClassID)
        {
            SqlDataReader dataReader = null;

            if(MailID!=""&&ClassID!="")
            {
                try
                {
                    throw new Exception("�������");

                    String Username = Request.Cookies["Username"].Value.ToString();
                    MailClass mailclass = new MailClass();
                    ProjectClass pjt = new ProjectClass();
                    DocBody docbody = new DocBody();
                    DocumentClass doc = new DocumentClass();

                    dataReader = mailclass.GetMailCompleteInfoDbreader(MailID);
                    if (dataReader.Read())
                    {
                        int cstRightToApproveDocument = 2;

                        docbody.DocTitle = dataReader["MailSubject"].ToString();
                        docbody.DocContent = dataReader["MailBody"].ToString(); ;
                        docbody.DocAddedBy = dataReader["MailSender"].ToString(); ;
                        docbody.DocClassID = Int32.Parse(ClassID);
                        docbody.DocAddedDate = DateTime.Now.ToString();
                        docbody.DocApprover = (pjt.GetAccessPermission(Int32.Parse(ClassID), Username, cstRightToApproveDocument)) ? Username : "";
                        docbody.DocApproveDate = (pjt.GetAccessPermission(Int32.Parse(ClassID), Username, cstRightToApproveDocument)) ? DateTime.Now.ToString() : "";
                        docbody.DocApproved = (docbody.DocApprover == "") ? 0 : 1;
                        docbody.DocAttribute = 0;
                        docbody.DocType = 0;

                    }
                    dataReader.Close();
                    string DocID = doc.AddDocBody(docbody);

                    dataReader = mailclass.GetMailAttInfoDbreader(MailID);
                    while (dataReader.Read())
                    {
                        DocAttachFile docatt = new DocAttachFile();
                        docatt.FileAttribute = 0;
                        docatt.FileSize = Int32.Parse(dataReader["FileSize"].ToString());
                        docatt.FileName = dataReader["FileName"].ToString();
                        docatt.FileAuthor = Username;
                        docatt.FileCatlog = "�ĵ�";
                        docatt.FileVisualPath = "Mail" + dataReader["FileVisualPath"].ToString();
                        docatt.FileAddedDate = DateTime.Now.ToString();
                        docatt.DocID = Int32.Parse(DocID);
                        doc.AddAttach(docatt, Int32.Parse(DocID));
                    }

                    dataReader = null;
                    pjt = null;
                    docbody = null;
                }
                catch (Exception oe)
                {
                    throw new Exception(oe.Message);
                }
                finally
                {
                    if(null != dataReader)
                        if (!dataReader.IsClosed)
                        {
                            dataReader.Close();
                        }
                }
            }
        }
Esempio n. 6
0
        public void MailIncoming(string MailID,string ClassID)
        {
            if(MailID!=""&&ClassID!="")
            {
                SqlDataReader dataReader = null;
                try
                {
                    String Username = Server.UrlDecode(Request.Cookies["UserName"].Value);
                    MailClass mailclass = new MailClass();

                    ProjectClass pjt = new ProjectClass();
                    DocBody docbody = new DocBody();
                    DocumentClass doc = new DocumentClass();

                    dataReader = mailclass.GetMailCompleteInfoDbreader(MailID);
                    if (dataReader.Read())
                    {
                        int cstRightToApproveDocument = 2;

                        docbody.DocTitle = dataReader["MailSubject"].ToString();
                        docbody.DocContent = dataReader["MailBody"].ToString(); ;
                        docbody.DocAddedBy = dataReader["MailSender"].ToString(); ;
                        docbody.DocClassID = Int32.Parse(ClassID);
                        docbody.DocAddedDate = DateTime.Now.ToString();
                        docbody.DocApprover = (pjt.GetAccessPermission(Int32.Parse(ClassID), Username, cstRightToApproveDocument)) ? Username : "";
                        docbody.DocApproveDate = (pjt.GetAccessPermission(Int32.Parse(ClassID), Username, cstRightToApproveDocument)) ? DateTime.Now.ToString() : "";
                        docbody.DocApproved = (docbody.DocApprover == "") ? 0 : 1;
                        docbody.DocAttribute = 0;
                        docbody.DocType = 0;

                    }
                    dataReader.Close();
                    string DocID = doc.AddDocBody(docbody);

                    dataReader = mailclass.GetMailAttInfoDbreader(MailID);
                    while (dataReader.Read())
                    {
                        DocAttachFile docatt = new DocAttachFile();
                        docatt.FileAttribute = 0;
                        docatt.FileSize = Int32.Parse(dataReader["FileSize"].ToString());
                        docatt.FileName = dataReader["FileName"].ToString();
                        docatt.FileAuthor = Username;
                        docatt.FileCatlog = "�ĵ�";
                        docatt.FileVisualPath = "Mail" + dataReader["FileVisualPath"].ToString();
                        docatt.FileAddedDate = DateTime.Now.ToString();
                        docatt.DocID = Int32.Parse(DocID);
                        doc.AddAttach(docatt, Int32.Parse(DocID));
                    }

                   // dataReader = null;
                    if (dataReader != null)
                    {
                        dataReader.Close();
                    }
                    pjt = null;
                    docbody = null;

                    Response.Write("<script language=javascript>alert('�鵵�ɹ�!');</script>");
                }
                catch (Exception oe)
                {
                    UDS.Components.Error.Log(oe.ToString());
                    Server.Transfer("../Error.aspx");
                }
                finally
                {
                    if (dataReader != null)
                    {
                        dataReader.Close();
                    }
                }
            }
        }