private void Page_Load(object sender, System.EventArgs e) { if(!Page.IsPostBack) { SqlDataReader dataReader = null; try { DocumentClass dc = new DocumentClass(); dataReader = dc.GetManageQueryDetail(); if (dataReader.Read()) { this.iNormalMedia.Attributes["src"] = "../Document/" + dataReader["FileVisualPath"].ToString(); dataReader.Close(); } else { Response.Write("���������ĵ�!"); } dc = null; } finally { dataReader.Close(); } } }
private void btnThowAwayDocument_Click(object sender, System.EventArgs e) { UDS.Components.DocumentClass myDocument = new UDS.Components.DocumentClass(); String DocIDs = GetSelectedItemID("DocID"); myDocument.DocDelete(DocIDs, 0); Response.Write("<Script language='javascript'>alert('文件丢弃成功!');</script>"); Bangding(); }
protected void ShowBodyDetail() { UDS.Components.DocumentClass doc = new UDS.Components.DocumentClass(); SqlDataReader dataReader = null; try { dataReader = doc.GetDocDetail(DocID, UserCookie.Value); } catch { Server.Transfer("../../Error.aspx"); } // this.DataListDocument.DataSource = UDS.Components .Tools.ConvertDataReaderToDataTable(dataReader).DefaultView; // this.DataListDocument.DataBind(); int count = 0; while (dataReader.Read()) { count++; this.lblDocTitle.Text = dataReader["DocTitle"].ToString(); this.lblDocApprover.Text = UDS.Components.Staff.GetRealNameByUsername(dataReader["DocApprover"].ToString()); this.lblDocApproveDate.Text = dataReader["DocApproveDate"].ToString(); this.lblAddedBy.Text = UDS.Components.Staff.GetRealNameByUsername(dataReader["DocAddedBy"].ToString()); this.lblAddedDate.Text = dataReader["DocAddedDate"].ToString(); this.lblDocViewedTimes.Text = dataReader["DocViewedTimes"].ToString(); this.lblClassName.Text = dataReader["ClassName"].ToString(); this.lblDocContent.Text = dataReader["DocContent"].ToString(); if (dataReader["FileVisualPath"].ToString() != "") { if (dataReader["FileVisualPath"].ToString().Substring(0, 4) == "Mail") { this.lblFileVisualPath.Text += " <a href='Download.aspx?destFileName=\\" + Server.UrlEncode(dataReader["FileVisualPath"].ToString()) + "'>" + dataReader["FileName"].ToString() + "</a><br>"; } //this.lblFileVisualPath.Text += "<a href='../"+dataReader[21].ToString()+"'>"+dataReader[18].ToString()+"</a><br> "; else { this.lblFileVisualPath.Text += "<a href='Download.aspx?destFileName=\\Document\\" + Server.UrlEncode(dataReader["FileVisualPath"].ToString()) + "'>" + dataReader["FileName"].ToString() + "</a><br> "; } } } dataReader.Close(); doc = null; }
protected void ShowBodyDetail() { UDS.Components.DocumentClass doc = new UDS.Components.DocumentClass(); SqlDataReader dataReader = null; try { dataReader = doc.GetDocDetail(DocID, Server.UrlDecode(Request.Cookies["UserName"].Value)); } catch { Server.Transfer("../../Error.aspx"); } // this.DataListDocument.DataSource = UDS.Components .Tools.ConvertDataReaderToDataTable(dataReader).DefaultView; // this.DataListDocument.DataBind(); int count = 0; try { while (dataReader.Read()) { count++; this.lblDocTitle.Text = dataReader["DocTitle"].ToString(); this.lblDocApprover.Text = UDS.Components.Staff.GetRealNameByUsername(dataReader["DocApprover"].ToString()); this.lblDocApproveDate.Text = dataReader["DocApproveDate"].ToString(); this.lblAddedBy.Text = UDS.Components.Staff.GetRealNameByUsername(dataReader["DocAddedBy"].ToString()); this.lblAddedDate.Text = dataReader["DocAddedDate"].ToString(); this.lblDocViewedTimes.Text = dataReader["DocViewedTimes"].ToString(); this.lblClassName.Text = dataReader["ClassName"].ToString(); this.lblDocContent.Text = dataReader["DocContent"].ToString(); if (dataReader["FileVisualPath"].ToString() != "") { if (dataReader["FileVisualPath"].ToString().Substring(0, 4) == "Mail") this.lblFileVisualPath.Text += " <a target='blank' href='Download.aspx?destFileName=\\" + Server.UrlEncode(dataReader["FileVisualPath"].ToString()) + "'>" + dataReader["FileName"].ToString() + "</a><br>"; //this.lblFileVisualPath.Text += "<a href='../"+dataReader[21].ToString()+"'>"+dataReader[18].ToString()+"</a><br> "; else this.lblFileVisualPath.Text += "<a target='blank' href='Download.aspx?destFileName=\\Document\\" + Server.UrlEncode(dataReader["FileVisualPath"].ToString()) + "'>" + dataReader["FileName"].ToString() + "</a><br> "; } } } finally { dataReader.Close(); doc = null; } }
protected void ShowBodyDetail() { UDS.Components.DocumentClass doc = new UDS.Components.DocumentClass(); SqlDataReader dataReader = null; try { dataReader = doc.GetDocDetail(DocID, Server.UrlDecode(Request.Cookies["UserName"].Value)); } catch { Server.Transfer("../../Error.aspx"); } int count = 0; try { while (dataReader.Read()) { count++; this.lblDocTitle.Text = dataReader["DocTitle"].ToString(); this.lblDocApprover.Text = UDS.Components.Staff.GetRealNameByUsername(dataReader["DocApprover"].ToString()); this.lblDocApproveDate.Text = dataReader["DocApproveDate"].ToString() == "1900-1-1 00:00:00" ? "" : dataReader["DocApproveDate"].ToString(); this.lblAddedBy.Text = UDS.Components.Staff.GetRealNameByUsername(dataReader["DocAddedby"].ToString()); this.lblAddedDate.Text = dataReader["DocAddedDate"].ToString(); this.lblDocViewedTimes.Text = dataReader["DocViewedTimes"].ToString(); this.lblClassName.Text = dataReader["ClassName"].ToString(); this.lblDocContent.Text = dataReader["DocContent"].ToString(); if (dataReader["FileCatlog"].ToString() != "") { if (dataReader["FileCatlog"].ToString() == "Mail") this.lblFileVisualPath.Text += " <a href='Download.aspx?destFileName=\\" + dataReader["FileVisualPath"].ToString() + "'>" + dataReader["FileName"].ToString() + "</a><br>"; //this.lblFileVisualPath.Text += "<a href='../"+dataReader[21].ToString()+"'>"+dataReader[18].ToString()+"</a><br> "; else this.lblFileVisualPath.Text += "<a href='Download.aspx?destFileName=\\Document\\" + dataReader["FileVisualPath"].ToString() + "'>" + dataReader["FileName"].ToString() + "</a><br> "; } } } finally { dataReader.Close(); } doc = null; }
/// <summary> /// ��ij�û����ʼ�ȡ������DataGrid /// </summary> protected void BindGrid() { UserCookie = Request.Cookies["Username"]; string Username = UserCookie.Value.ToString(); DocumentClass doc = new DocumentClass(); SqlDataReader dr = doc.GetDocListInClass(Int32.Parse(ClassID),Username,Int32.Parse(DisplayType)); DataTable datatable = Tools.ConvertDataReaderToDataTable(dr); DataView source = datatable.DefaultView; source.Sort = SortBy+" "+ SortRule; dgDocList.DataSource = source; dgDocList.DataBind(); // // if (datatable.Rows.Count !=0) // { // this.lnkbtnDelete.Visible =true; // // } doc = null; datatable = null; }
/// <summary> /// ��ʾ���� /// </summary> private void PopulateData() { #region ��ʼ������ SqlDataReader dataReader = null; //try //{ DataTable dataTable = new DataTable(); ProjectClass pjt = new ProjectClass(); MailClass mail = new MailClass(); DocumentClass doc = new DocumentClass(); #endregion #region ��ȡ��Ŀ��Ϣ dataReader = pjt.GetClassInfo(classID); try { if (dataReader.Read()) { this.lblClassName.Text = dataReader[0].ToString(); // this.lblParentClassName.Text = dataReader[2].ToString(); // this.lblBuildDate.Text = dataReader[3].ToString(); // this.lblEndDate.Text = dataReader[4].ToString(); // this.lblFinishedScale.Text = dataReader[8].ToString(); // this.lblDescription.Text = dataReader[7].ToString(); } } catch (Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../Error.aspx"); } dataReader = null; #endregion #region ��ȡ��Ŀ��Ա��Ϣ dataReader = pjt.GetMemberInClass(classID); int i = 0; try { while (dataReader.Read()) { if (i < 3) this.lblMember.Text += "<a href='Mail/Compose.aspx?Action=3" + "&ClassID=" + classID.ToString() + "&Username="******"Staff_Name"].ToString() + "&Name=" + Server.UrlEncode(dataReader["RealName"].ToString()) + "'>" + dataReader["RealName"].ToString() + "</a> "; i++; } if (i >= 3) this.lblMember.Text += ".."; if (this.lblMember.Text == "") this.lblMember.Text = ""; } catch (Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../Error.aspx"); } dataReader = null; #endregion #region ����Ȩ����ʾ��ع��ܱ��� // ����ȱʡֵ int cstRightToApproveDocument = 2; int cstRightToViewDocument = 10; int cstRightToBuildNode = 5; int cstDisplayMember = 6; int cstTeamRight = 7; int cstComposeMail = 11; int cstDeliveryDoc = 11; int cstProjectMove = 12; this.lblManageProject.Visible = pjt.GetAccessPermission(classID, Username, cstRightToBuildNode); // this.imgManageProject.Visible = this.lblManageProject.Visible; this.lblManageDirectory.Visible = pjt.GetAccessPermission(classID, Username, cstRightToBuildNode); // this.imgManageDirectory.Visible = this.lblManageDirectory.Visible; this.lblComposeMail.Visible = pjt.GetAccessPermission(classID, Username, cstComposeMail); // this.imgComposeMail.Visible = this.lblComposeMail.Visible; this.lblDeliveryDoc.Visible = pjt.GetAccessPermission(classID, Username, cstDeliveryDoc); // this.imgDeliveryDoc.Visible = this.lblDeliveryDoc.Visible; this.lblShowMember.Visible = pjt.GetAccessPermission(classID, Username, cstDisplayMember); // this.imgShowMember.Visible = this.lblShowMember.Visible; this.lblManagePermission.Visible = pjt.GetAccessPermission(classID, Username, cstTeamRight); // this.imgManagePermission.Visible = this.lblManagePermission.Visible; this.lblRemove.Visible = pjt.GetAccessPermission(classID, Username, cstProjectMove); // this.imgRemove.Visible = this.lblRemove.Visible; // this.tr1.Visible = pjt.GetAccessPermission(classID,Username,cstRightToViewDocument); // this.tr3.Visible = pjt.GetAccessPermission(classID,Username,cstRightToApproveDocument); this.line1.Visible = pjt.GetAccessPermission(classID, Username, cstRightToViewDocument); //this.IMG1.Visible = this.line1.Visible; this.dgDocList.Visible = this.line1.Visible; // this.imgSubscribe.Visible = this.line1.Visible; this.lblSubscribe.Visible = this.line1.Visible; this.line2.Visible = pjt.GetAccessPermission(classID, Username, cstRightToApproveDocument); //this.IMG3.Visible = this.line2.Visible; this.dgAppDocList.Visible = this.line2.Visible; #endregion #region ����Ȩ��ȡ���ʼ����� /// <summary> /// ��ij�û���ȡ���ʼ����� /// </summary> dataTable = mail.GetClassMails(classID, Server.UrlDecode(Request.Cookies["UserName"].Value)); dgMailList.DataSource = dataTable.DefaultView; dgMailList.DataBind(); mail = null; #endregion #region ����Ȩ��ȡ���ĵ����� /// <summary> /// ��ij�û����ĵ�����ȡ�� /// </summary> if (pjt.GetAccessPermission(classID, Username, cstRightToViewDocument) || bSubscription) { dataTable = doc.GetClassDocs(classID); dgDocList.DataSource = dataTable.DefaultView; dgDocList.DataBind(); dataTable = null; } else { // IMG1.Visible = false; // IMG4.Visible = false; dgDocList.Visible = false; } #endregion #region ����Ȩ��ȡ��ij��Ŀ�������ĵ����� /// <summary> /// ��ij��Ŀ�������ĵ�����ȡ�� /// </summary> if (pjt.GetAccessPermission(classID, Username, cstRightToApproveDocument)) { dataTable = doc.GetApproveClassDocs(classID); dgAppDocList.DataSource = dataTable.DefaultView; dgAppDocList.DataBind(); dataTable = null; doc = null; } else { //IMG3.Visible = false; dgAppDocList.Visible = false; lblApp.Visible = false; } #endregion //} //finally //{ dataReader.Close(); } }
private void btnSubmit_Click(object sender, System.EventArgs e) { string DocID = ""; DocBody docbody = ProcessFormPost(); DocumentClass doc = new DocumentClass(); // ����ĵ�,������ID DocID = doc.AddDocBody(docbody); ArrayList listattfile = (ArrayList)Session["listattfile"]; foreach(UDS.Components.DocAttachFile att in listattfile) { try { if(!Directory.Exists(Server.MapPath(".")+"\\AttachFiles\\"+Username)) Directory.CreateDirectory(Server.MapPath(".")+"\\AttachFiles\\"+Username); //Directory.Move(att.FileVisualPath.ToString().Replace(att.FileName,""),Server.MapPath(".")+"\\AttachFiles\\"+Username+"\\"); Random TempNameInt = new Random(); string NewDocDirName = TempNameInt.Next(100000000).ToString(); Directory.CreateDirectory(Server.MapPath(".")+"\\AttachFiles\\"+Username+"\\"+NewDocDirName); File.Move(Server.MapPath(".")+"\\"+att.FileVisualPath ,Server.MapPath(".")+"\\AttachFiles\\"+Username+"\\"+NewDocDirName+"\\"+att.FileName); Directory.Delete(Server.MapPath(".")+"\\"+att.FileVisualPath.ToString().Replace(att.FileName,""),true); att.FileVisualPath = "\\AttachFiles\\"+Username+"\\"+NewDocDirName+"\\"+att.FileName; att.FileAddedDate = DateTime.Now.ToString(); // �������ݿ�� doc.AddAttach(att,Int32.Parse(DocID)); } catch(Exception ioex) { UDS.Components.Error.Log(ioex.ToString()); Server.Transfer("../../Error.aspx"); } } Response.Write("<script language=javascript>alert('�ĵ��ύ�ɹ�!');self.location='../Switch.aspx?Action=1&ClassID="+ClassID+"';</script>"); }
/// <summary> /// ��ʾ���� /// </summary> private void PopulateData() { #region ��ʼ������ DataTable dataTable = new DataTable(); SqlDataReader dataReader = null; ProjectClass pjt = new ProjectClass (); MailClass mail = new MailClass(); DocumentClass doc = new DocumentClass(); #endregion #region ��ȡ��Ŀ��Ϣ dataReader = pjt.GetClassInfo(classID); try { if (dataReader.Read()) { this.lblClassName.Text = dataReader[0].ToString(); this.lblParentClassName.Text = dataReader[2].ToString(); this.lblBuildDate.Text = dataReader[3].ToString(); this.lblEndDate.Text = dataReader[4].ToString(); this.lblFinishedScale.Text = dataReader[8].ToString(); this.lblDescription.Text = dataReader[7].ToString(); } } catch (Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../Error.aspx"); } dataReader = null; #endregion #region ��ȡ����Ŀ��Ϣ dataReader = pjt.GetSubClassInfo(classID); try { while (dataReader.Read()) { this.lblSubClass.Text += "<a href='Switch.aspx?Action=1&ClassID=" + dataReader[0].ToString() + "'>" + dataReader[1].ToString() + "</a> "; } if (this.lblSubClass.Text == "") this.lblSubClass.Text = "��"; } catch (Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../Error.aspx"); } dataReader = null; #endregion #region ��ȡ��Ŀ��Ա��Ϣ dataReader = pjt.GetMemberInClass(classID); try { while (dataReader.Read()) { this.lblMember.Text += "<a href='Mail/Compose.aspx?Action=3" + "&ClassID=" + classID.ToString() + "&Username="******"Staff_Name"].ToString() + "&Name=" + Server.UrlEncode(dataReader["RealName"].ToString()) + "'>" + dataReader["RealName"].ToString() + "</a> "; } if (this.lblMember.Text == "") this.lblMember.Text = "��"; } catch (Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../Error.aspx"); } dataReader = null; #endregion #region ��ȡ��Ŀ�ϼ���������Ϣ dataReader = pjt.GetParentLeader(classID); try { if (dataReader.Read()) { this.lblParentLeader.Text += "<a href='Mail/Compose.aspx?Action=3" + "&ClassID=" + classID.ToString() + "&Username="******"Staff_Name"].ToString() + "&Name=" + Server.UrlEncode(dataReader["RealName"].ToString()) + "'>" + dataReader["RealName"].ToString() + "</a> "; } if (this.lblParentLeader.Text == "") this.lblParentLeader.Text = "��"; } catch (Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../Error.aspx"); } dataReader = null; #endregion #region ��ȡ��Ŀ��������Ϣ dataReader = pjt.GetLeader(classID); try { while (dataReader.Read()) { this.lblLeader.Text += "<a href='Mail/Compose.aspx?Action=3" + "&ClassID=" + classID.ToString() + "&Username="******"Staff_Name"].ToString() + "&Name=" + Server.UrlEncode(dataReader["RealName"].ToString()) + "'>" + dataReader["RealName"].ToString() + "</a> "; } if (this.lblLeader.Text == "") this.lblLeader.Text = "��"; } catch (Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../Error.aspx"); } //dataReader = null; finally { dataReader.Close(); } #endregion }
private void lnkbtnDelete_Click(object sender, System.EventArgs e) { DocumentClass doc = new DocumentClass(); bool sqlFlag = true; string sql = ""; foreach(DataGridItem dgi in dgDocList.Items) { CheckBox cb=(CheckBox)(dgi.Cells[0].Controls[1]); if (cb.Checked==true) { int i = dgi.ItemIndex; string id = dgDocList.DataKeys[i].ToString(); if (sqlFlag) { sql+=id; sqlFlag=false; } else { sql+=" ,"; sql+=id; } } } //ѡ��Ϊ�� if( sql==String.Empty) { Response.Write("<script language=javascript>alert('��ѡ���ĵ�!');window.location='ListView.aspx?ClassID="+ClassID+"';</script>"); } else { int deleteFlag = DisplayType.ToString()=="3"?1:0; if(doc.DocDelete(sql,deleteFlag)) { Response.Write("<script language=javascript>alert('�ĵ������ɹ�!');window.location='ListView.aspx?ClassID="+ClassID+"';</script>"); } else { Server.Transfer("../../Error.aspx"); } } doc=null; }
/// <summary> /// ���ż�����ָ���ֶν������� /// </summary> protected void DataGrid_Sort(Object Src, DataGridSortCommandEventArgs E) { SortRule = (SortRule=="Desc")?"Asc":"Desc"; SortBy = E.SortExpression ; DocumentClass doc = new DocumentClass(); DataTable datatable = Tools.ConvertDataReaderToDataTable(doc.GetDocListInClass(Int32.Parse(ClassID),Username,Int32.Parse(DisplayType))); DataView Source = datatable.DefaultView; Source.Sort = SortBy+" "+ SortRule; doc = null; dgDocList.DataSource = Source; dgDocList.DataBind(); }
private void btnThowAwayDocument_Click(object sender, System.EventArgs e) { UDS.Components.DocumentClass myDocument = new UDS.Components.DocumentClass(); String DocIDs = GetSelectedItemID("DocID"); myDocument.DocDelete(DocIDs,0); Response.Write("<Script language='javascript'>alert('�ļ������ɹ���');</script>"); Bangding(); }
/// <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"); } } }
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(); } } } }
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(); } } } }