public void FolderListChange(object sender, System.EventArgs e)
{
bool sqlFlag = true;
string sql = "";
int FolderType = Int32.Parse(this.listFolderType.SelectedItem.Value); //����ת��Ŀ��
MailClass mail = new MailClass();
HttpCookie UserCookie = Request.Cookies["Username"];
foreach(DataGridItem dgi in dgMailList.Items)
{
CheckBox cb=(CheckBox)(dgi.Cells[0].Controls[1]);
if (cb.Checked==true)
{
int i = dgi.ItemIndex;
string id = dgMailList.DataKeys[i].ToString();
if (sqlFlag)
{
sql+=" MailID= "+id;
sqlFlag=false;
}
else
{
sql+=" or";
sql+=" MailID= "+id;
}
}
}
//ѡ��Ϊ��
if( sql==String.Empty)
{
Response.Write("<script language=javascript>alert('��ѡ���ʼ�!');window.location='Index.aspx?FolderType="+FolderType+"';</script>");
}
else
{
if(mail.MailRemove(FolderType,sql))
{
Response.Write("<script language=javascript>alert('�ʼ��ƶ��ɹ�!');window.location='Index.aspx?FolderType="+FolderType+"';</script>");
}
else
{
Server.Transfer("../../Error.aspx");
}
}
mail=null;
}
/// <summary>
/// �������б���г�ʼ��
/// </summary>
private void PopulateListView()
{
listFolderType.Items.Clear();
listFolderType.Items.Add(new ListItem("�����ʼ���...","0"));
listFolderType.Items.Add(new ListItem("�ռ���","1"));
listFolderType.Items.Add(new ListItem("�Ѿ����͵��ʼ�","2"));
listFolderType.Items.Add(new ListItem("�ϼ���","3"));
if(this.listExtMail.Visible)
{
try
{
MailClass mail = new MailClass();
this.listExtMail.DataTextField = "Title";
this.listExtMail.DataValueField = "OrderID";
this.listExtMail.DataSource = mail.ExtGetAvaSetting(Request.Cookies["Username"].Value.ToString());
this.listExtMail.DataBind();
this.listExtMail.Items.Insert(0,"ȫ���ⲿ����");
this.listExtMail.Items.FindByText("ȫ���ⲿ����").Value="0";
this.listExtMail.SelectedIndex=0;
}
catch(Exception ex)
{
UDS.Components.Error.Log(ex.ToString());
Server.Transfer("../../Error.aspx");
}
}
}
private void btnDelete_Click(object sender, System.EventArgs e)
{
MailClass mail = new MailClass();
bool sqlFlag = true;
string sql = "";
foreach(DataGridItem dgi in dgMailList.Items)
{
CheckBox cb=(CheckBox)(dgi.Cells[0].Controls[1]);
if (cb.Checked==true)
{
int i = dgi.ItemIndex;
string id = dgMailList.DataKeys[i].ToString();
if (sqlFlag)
{
sql+=" MailID= '"+id + "'";
sqlFlag=false;
}
else
{
sql+=" or";
sql+=" MailID= '"+id + "'";
}
}
}
//ѡ��Ϊ��
if( sql==String.Empty)
{
Response.Write("<script language=javascript>alert('��ѡ���ʼ�!');window.location='Index.aspx?FolderType="+Session["FolderType"].ToString()+"';</script>");
}
else
{
try
{
if(Session["FolderType"].ToString()=="3")
{
mail.MailDelete(sql,1);//����ɾ��
}
else if(Session["FolderType"].ToString() == "4")
{
mail.MailDelete(sql, 40);
}
else
{
mail.MailDelete(sql,0);//�����ϼ���
}
Response.Write("<script language=javascript>alert('�ʼ�ɾ���ɹ�!');window.location='Index.aspx?FolderType="+Session["FolderType"].ToString()+"';</script>");
}
catch(Exception ex)
{
UDS.Components .Error.Log(ex.ToString());
Server.Transfer("../../Error.aspx");
}
}
mail=null;
}
private void btnClear_Click(object sender, System.EventArgs e)
{
MailClass mail = new MailClass();
UserCookie = Request.Cookies["Username"];
try
{
if(mail.FolderClear(UserCookie.Value.ToString(),3))
{
Response.Write("<script language=javascript>alert('�ʼ�ɾ���ɹ�!');window.location='Index.aspx?FolderType="+Session["FolderType"].ToString()+"';</script>");
}
else
{
Server.Transfer("../../Error.aspx");
}
}
catch(Exception ex)
{
UDS.Components.Error .Log(ex.ToString());
Server.Transfer("../../Error.aspx");
}
mail=null;
}
private void btnBeginReceive_Click(object sender, System.EventArgs e)
{
MailClass mail = new MailClass();
string Username = Request.Cookies["Username"].Value.ToString();
int OrderID = Int32.Parse(this.listExtMail.SelectedItem.Value.ToString());
try
{
mail.ReceiveMails(Username,OrderID);
Response.Write("<script language=javascript>alert('�������!');</script>");
}
catch(Exception ex)
{
UDS.Components.Error.Log(ex.ToString());
//Server.Transfer("../../Error.aspx");
Response.Write("<script language=javascript>alert('����������æµ��,���Ժ�����');</script>");
}
}
/// <summary>
/// ��ij�û����ʼ�ȡ������DataGrid
/// </summary>
protected void BindGrid()
{
MailClass mail = new MailClass();
DataTable datatable = mail.GetMails(Int32.Parse(Session["FolderType"].ToString()),UserCookie.Value.ToString());
DataView source = datatable.DefaultView;
FolderType = Int32.Parse(Session["FolderType"].ToString());
// for( int i=0 ;i<datatable.Columns.Count;i++)
// {
// if(datatable.Columns[i].ColumnName==SortBy)
// {
// SortByIndex=i;
// break;
// }
// }
if(CurrentPageIndex!="") dgMailList.CurrentPageIndex = Int32.Parse(CurrentPageIndex);
if(FolderType!=4)
{
source.Sort = SortBy+" "+ SortRule;
}
dgMailList.DataSource=source;
dgMailList.DataBind();
// Response.Write(CurrentPageIndex);
//���������������ʾ��������
switch (FolderType)
{
case 1:
dgMailList.Columns[3].Visible = false; //�������ռ���
dgMailList.Columns[4].Visible = false; //�����������ռ���
break;
case 2:
dgMailList.Columns[2].Visible = false; //�����ط�����
dgMailList.Columns[3].Visible = false; //�������ռ���
//dgMailList.Columns[4].Visible = true; //�����������ռ���
break;
case 3:
dgMailList.Columns[2].Visible = true; //����ʾ������
dgMailList.Columns[3].Visible = false; //�������ռ���
dgMailList.Columns[4].Visible = false; //�����������ռ���
this.btnClear .Attributes["onclick"] = "javascript:return confirm('��ȷ��Ҫ�����?');";
break;
case 4:
dgMailList.Columns[4].Visible = false; //�������ռ���
dgMailList.Columns[6].Visible = false; //������������Ŀ
break;
default:
break;
}
if(FolderType!=4)
{
DataView dataView = new DataView();
dataView = datatable.DefaultView;
dataView.RowFilter = "MailReadFlag = false";
this.lblMsg.Text = datatable.Rows.Count+"/<font color=red>"+dataView.Count.ToString()+"</font>�";
this.lblMsg .Text+= (SortRule=="Desc")?" ��":" ��";
}
if (datatable.Rows.Count !=0)
{
this.btnDelete.Visible =true;
this.btnDelete.Attributes ["onclick"]="javascript:return confirm('��ȷ��Ҫɾ����?');";
}
mail = null;
datatable = null;
}
/// <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
}
protected void ShowBodyDetail()
{
MailClass mailclass = new MailClass();
SqlDataReader dataReader = null;
try
{
dataReader = mailclass.GetMailCompleteInfoDbreader(MailID);
}
catch
{
Server.Transfer("../../Error.aspx");
}
if(dataReader.Read())
{
this.lblSenderName.Text = dataReader["MailSender"].ToString();
this.lblCcToAddr.Text = UDS.Components.Staff.GetRealNameStrByUsernameStr(dataReader["MailCcToAddr"].ToString(),0);
// �ж��Ƿ���ʾ�ܳ�����Ϣ�����û�
string[] RecvAr = System.Text.RegularExpressions.Regex.Split(dataReader["MailBccToAddr"].ToString() ,",");
for(int i=0;i<RecvAr.Length-1;i++)
{ //�ж��ܳ������Ƿ�����Լ�
if( RecvAr[i].ToString()==UserCookie.Value.ToString())
{
//this.lblBccToAddr.Text = UserCookie.Value.ToString();
this.lblBccToAddr.Text = UDS.Components .Staff.GetRealNameByUsername(UserCookie.Value.ToString());
}
}
this.lblSubject.Text = dataReader["MailSubject"].ToString();
this.lblBody.Text = dataReader["MailBody"].ToString();
this.lblSendDate.Text = dataReader["MailSendDate"].ToString();
this.lblReceiverStr .Text = UDS.Components.Staff.GetRealNameStrByUsernameStr(dataReader["MailReceiverStr"].ToString(),0);
this.lblProjectName .Text = dataReader["classname"].ToString();
}
dataReader.Close();
// ��ʼ��ȡ������Ϣ
try
{
dataReader = mailclass.GetMailAttInfoDbreader(MailID);
}
catch
{
Server.Transfer("../../Error.aspx");
}
while(dataReader.Read())
{
lblAttachFile.Text += " <a href='Download.aspx?destFileName="+Server.UrlEncode(dataReader[2].ToString())+"'>"+dataReader[0].ToString()+"("+dataReader[1].ToString()+" Byte)</a><br>";
}
dataReader.Close();
mailclass = null;
}
private void SaveSetting()
{
MailClass mail = new MailClass();
string Username = Request.Cookies["Username"].Value.ToString();
try
{
if(mail.ExtClearSettings(Username))
{
mail.ExtSaveSetting(Username,this.txtTitle1.Text,this.txtEmail1 .Text,true,"","","","21",this.txtPopSvrName1.Text,this.txtPopUserName1.Text,(this.txtPopPwd1.Text!="")?this.txtPopPwd1.Text:this.lblPwd1.Value,Int32.Parse(this.txtPort1.Text),this.chkDelSvrMsg1.Checked,this.chkDownNew1.Checked,Int32.Parse(this.txtTimeOut1.Text),1);
mail.ExtSaveSetting(Username,this.txtTitle2.Text,this.txtEmail2 .Text,true,"","","","21",this.txtPopSvrName2.Text,this.txtPopUserName2.Text,(this.txtPopPwd2.Text!="")?this.txtPopPwd2.Text:this.lblPwd2.Value,Int32.Parse(this.txtPort2.Text),this.chkDelSvrMsg2.Checked,this.chkDownNew2.Checked,Int32.Parse(this.txtTimeOut2.Text),2);
mail.ExtSaveSetting(Username,this.txtTitle3.Text,this.txtEmail3. Text,true,"","","","21",this.txtPopSvrName3.Text,this.txtPopUserName3.Text,(this.txtPopPwd3.Text!="")?this.txtPopPwd3.Text:this.lblPwd3.Value,Int32.Parse(this.txtPort3.Text),this.chkDelSvrMsg3.Checked,this.chkDownNew3.Checked,Int32.Parse(this.txtTimeOut3.Text),3);
}
else
{
Server.Transfer("../../../Error.aspx");
}
}
catch(Exception ex)
{
UDS.Components.Error .Log(ex.ToString());
Server.Transfer("../../../Error.aspx");
}
mail=null;
}
/// <summary>
/// �ظ��ʼ�����
/// </summary>
private void ReplySet()
{
// ��ȡԭ�ʼ�����
MailClass mailclass = new MailClass();
SqlDataReader dataReader = null;
try
{
dataReader = mailclass.GetMailCompleteInfoDbreader(MailID);
}
catch
{
Server.Transfer("../../Error.aspx");
}
try
{
if (dataReader.Read())
{
string tmpStr = "<br/>" + dataReader[7].ToString();
tmpStr = tmpStr.Replace("<br/>", "\r\n>");
this.txtSubject.Text = "Re:" + dataReader[4].ToString();
SendToRealName = dataReader[1].ToString() + ",";
SendTo = dataReader[10].ToString() + ",";
this.txtBody.Text = SendToRealName + "���!\n\n\n\n\n\n\n";
this.txtBody.Text += "=======" + dataReader[3].ToString() + "�����������:" + "=======\n\n";
this.txtBody.Text += tmpStr;
}
}
finally
{
dataReader.Close();
mailclass = null;
}
}
/// <summary>
/// ת���ʼ�����
/// </summary>
private void ForwardSet()
{
// ��ȡԭ�ʼ�����
MailClass mailclass = new MailClass();
SqlDataReader dataReader = null;
try
{
try
{
dataReader = mailclass.GetMailCompleteInfoDbreader(MailID);
}
catch
{
Server.Transfer("../../Error.aspx");
}
if (dataReader.Read())
{
string tmpStr = "<br/>" + dataReader[7].ToString();
tmpStr = tmpStr.Replace("<br/>", "\r\n>");
this.txtSubject.Text = "Fw::" + dataReader[4].ToString();
this.txtBody.Text = ",���!\n\n\n\n\n\n\n";
this.txtBody.Text += "=======������ת���ʼ�=======\n";
this.txtBody.Text += "ԭ�ʼ�����������:" + dataReader[1].ToString() + "\n";
this.txtBody.Text += "ԭ�ʼ������˴���:" + dataReader[10].ToString() + "\n";
this.txtBody.Text += tmpStr;
}
dataReader.Close();
try
{
dataReader = mailclass.GetMailAttInfoDbreader(MailID);
}
catch
{
Server.Transfer("../../Error.aspx");
}
while (dataReader.Read())
{
UDS.Components.MailAttachFile att = new MailAttachFile();
att.FileAttribute = 0;
att.FileSize = Int32.Parse(dataReader[1].ToString());
att.FileName = dataReader[0].ToString();
att.FileAuthor = Username;
att.FileCatlog = "�ʼ�";
att.FileVisualPath = dataReader[2].ToString();
upattlist.Add(att);
}
BindAttList();
}
finally
{
dataReader.Close();
}
mailclass = null;
}
/// <summary>
/// ���Ŵ���������ʼ��������������
/// </summary>
private void btnSendMail_Click(object sender, System.EventArgs e)
{
HttpCookie UserCookie = Request.Cookies["Username"];
Username = Server.UrlDecode(Request.Cookies["UserName"].Value);
MailClass mailclass = new UDS.Components.MailClass();
MailMainBody mailbody = new UDS.Components.MailMainBody();
ArrayList listmail = new ArrayList();
ArrayList upattlist = (ArrayList)Session["upattlist"];
// ArrayList listattfile = new ArrayList();
// �õ�mailbody��
mailbody = ProcessFormPost();
//�ʼ�����
try
{
listmail = mailclass.MailSend(mailbody); // �����Ѿ����͵��ʼ�ID�б�(�������ͺ��ܳ�)
// listattfile = AttUpload(mailbody.MailReceiverStr.ToString()); // �����ʼ���������
foreach(string mailID in listmail)
{ // ѭ�������ʼ�����
foreach(UDS.Components.MailAttachFile att in upattlist)
{ //�������ʼ����������ݿ��������
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);
File.Copy(Server.MapPath(".")+"\\"+att.FileVisualPath ,Server.MapPath(".")+"\\AttachFiles\\"+Username+"\\"+NewDocDirName+"\\"+att.FileName,true);
// Directory.Delete(Server.MapPath(".")+"\\"+att.FileVisualPath.ToString().Replace(att.FileName,""),true);
att.FileVisualPath = "\\AttachFiles\\"+Username+"\\"+NewDocDirName+"\\"+att.FileName;
mailclass.AttSend(att,Int32.Parse(mailID));
}
}
if(cblistAttribute.Items[1].Selected&&Request.Form["hdnProjectID"].ToString()!="0")
{
DocProcess(mailbody,upattlist);
}
Response.Write("<script language=javascript>alert('�ʼ����ͳɹ�!');if(parent.frames.length==0) window.close();else self.location=('Index.aspx');</script>");
}
catch (Exception sendex)
{
UDS.Components.Error.Log(sendex.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();
}
}
}
}
private void btnDelete_Click(object sender, System.EventArgs e)
{
MailClass mail = new MailClass();
string sql = " MailID="+MailID.ToString();
if(FolderType!="3"?mail.MailDelete(sql,0):mail.MailDelete(sql,1))
{
Response.Write("<script language=javascript>alert('�ʼ�ɾ���ɹ�!');window.location='Index.aspx?FolderType="+FolderType+"';</script>");
}
else
{
Server.Transfer("../../Error.aspx");
}
mail=null;
}
private void BindData()
{
MailClass mail = new MailClass();
string Username = Request.Cookies["Username"].Value.ToString();
SqlDataReader dataReader = null;
try
{
dataReader = mail.ExtGetSetting(Username,1);
if(dataReader.Read())
{
this.txtTitle1 .Text = dataReader["Title"].ToString();
this.txtEmail1 .Text = dataReader["Email"].ToString();
this.txtPopSvrName1 .Text = dataReader["PopServer"].ToString();
this.txtPopUserName1 .Text = dataReader["PopUsername"].ToString();
this.lblPwdShow1.Visible = true;
this.lblPwd1.Value = dataReader["PopPassword"].ToString();
this.txtTimeOut1 .Text = dataReader["TimeOut"].ToString();
this.txtPort1.Text = dataReader["PopPort"].ToString();
this.chkDelSvrMsg1 .Checked = dataReader["IsDelAfterRead"].ToString()=="True"?true:false;
this.chkDownNew1 .Checked = dataReader["IsReceiveNew"].ToString()=="True"?true:false;
}
dataReader.Close();
dataReader = mail.ExtGetSetting(Username,2);
if(dataReader.Read())
{
this.txtTitle2 .Text = dataReader["Title"].ToString();
this.txtEmail2 .Text = dataReader["Email"].ToString();
this.txtPopSvrName2 .Text = dataReader["PopServer"].ToString();
this.txtPopUserName2 .Text = dataReader["PopUsername"].ToString();
this.lblPwdShow2.Visible = true;
this.lblPwd2.Value = dataReader["PopPassword"].ToString();
this.txtTimeOut2 .Text = dataReader["TimeOut"].ToString();
this.txtPort2.Text = dataReader["PopPort"].ToString();
this.chkDelSvrMsg2 .Checked = dataReader["IsDelAfterRead"].ToString()=="True"?true:false;
this.chkDownNew2 .Checked = dataReader["IsReceiveNew"].ToString()=="True"?true:false;
}
dataReader = null;
dataReader = mail.ExtGetSetting(Username,3);
if(dataReader.Read())
{
this.txtTitle3 .Text = dataReader["Title"].ToString();
this.txtEmail3 .Text = dataReader["Email"].ToString();
this.txtPopSvrName3 .Text = dataReader["PopServer"].ToString();
this.txtPopUserName3 .Text = dataReader["PopUsername"].ToString();
this.lblPwdShow3.Visible = true;
this.lblPwd3.Value = dataReader["PopPassword"].ToString();
this.txtTimeOut3 .Text = dataReader["TimeOut"].ToString();
this.txtPort3.Text = dataReader["PopPort"].ToString();
this.chkDelSvrMsg3 .Checked = dataReader["IsDelAfterRead"].ToString()=="True"?true:false;
this.chkDownNew3 .Checked = dataReader["IsReceiveNew"].ToString()=="True"?true:false;
}
dataReader = null;
}
catch(Exception ex)
{
dataReader.Close();
UDS.Components.Error .Log(ex.ToString());
Server.Transfer("../../../Error.aspx");
}
}
/// <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(); }
}
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();
}
}
}
}
