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();
}
}
}
}
