protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); ZWL.BLL.ERPLanEmail MyLanEmail = new ZWL.BLL.ERPLanEmail(); MyLanEmail.GetModel(int.Parse(Request.QueryString["ID"].ToString().Trim())); this.Label1.Text = MyLanEmail.EmailTitle; this.Label2.Text = MyLanEmail.FromUser; this.Label3.Text = MyLanEmail.ToUser; this.Label4.Text = MyLanEmail.TimeStr.ToString(); this.Label5.Text = ZWL.Common.PublicMethod.GetWenJian(MyLanEmail.FuJian, "../UploadFile/"); this.Label6.Text = MyLanEmail.EmailContent; //写系统日志 ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi(); MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName"); MyRiZhi.DoSomething = "用户查看邮件(" + this.Label1.Text + ")"; MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString(); MyRiZhi.Add(); //设置为已读 if (MyLanEmail.ToUser.Trim() == ZWL.Common.PublicMethod.GetSessionValue("UserName").Trim()) { if (MyLanEmail.EmailState == "未读") { ZWL.DBUtility.DbHelperSQL.ExecuteSQL("update ERPLanEmail set EmailState='已读' where ID=" + Request.QueryString["ID"].ToString().Trim()); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); ZWL.BLL.ERPLanEmail MyLanEmail = new ZWL.BLL.ERPLanEmail(); MyLanEmail.GetModel(int.Parse(Request.QueryString["ID"].ToString().Trim())); this.Label1.Text = MyLanEmail.EmailTitle; this.Label2.Text = MyLanEmail.FromUser; this.Label3.Text = MyLanEmail.ToUser; this.Label4.Text = MyLanEmail.TimeStr.ToString(); this.Label5.Text =ZWL.Common.PublicMethod.GetWenJian(MyLanEmail.FuJian,"../UploadFile/"); this.Label6.Text = MyLanEmail.EmailContent; //写系统日志 ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi(); MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName"); MyRiZhi.DoSomething = "用户查看邮件(" + this.Label1.Text + ")"; MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString(); MyRiZhi.Add(); //设置为已读 if (MyLanEmail.ToUser.Trim() == ZWL.Common.PublicMethod.GetSessionValue("UserName").Trim()) { if (MyLanEmail.EmailState == "未读") { ZWL.DBUtility.DbHelperSQL.ExecuteSQL("update ERPLanEmail set EmailState='已读' where ID=" + Request.QueryString["ID"].ToString().Trim()); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //if (Request.Params["fanhui"] != null && Request.Params["fanhui"].Trim() != "") //{ // this.fanhui.Style.Add("display", ""); //} //else //{ // this.fanhui.Style.Add("display", ""); //} ZWL.Common.PublicMethod.CheckSession(); //设置上传的附件为空 ZWL.Common.PublicMethod.SetSessionValue("WenJianList", ""); try { this.TextBox2.Text = Request.QueryString["UserName"].ToString(); } catch { } //检测是回复或者转发 try { if (Request.QueryString["Type"].ToString().Trim() == "HuiFu") { ZWL.BLL.ERPLanEmail MyModel = new ZWL.BLL.ERPLanEmail(); MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString())); //设置页面数据 this.TextBox1.Text = "Re:" + MyModel.EmailTitle; this.TextBox2.Text = MyModel.FromUser; } } catch { } //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ try { if (Request.QueryString["Type"].ToString().Trim() == "ZhuanFa") { ZWL.BLL.ERPLanEmail MyModel = new ZWL.BLL.ERPLanEmail(); MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString())); //设置页面数据 this.TextBox1.Text = "RW:" + MyModel.EmailTitle; this.TxtContent.Text = MyModel.EmailContent; ZWL.Common.PublicMethod.SetSessionValue("WenJianList", MyModel.FuJian); ZWL.Common.PublicMethod.BindDDL(this.CheckBoxList1, ZWL.Common.PublicMethod.GetSessionValue("WenJianList")); } } catch { } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); ZWL.BLL.ERPLanEmail MyLanEmail = new ZWL.BLL.ERPLanEmail(); MyLanEmail.GetModel(int.Parse(Request.QueryString["ID"].ToString().Trim())); this.Label1.Text = MyLanEmail.EmailTitle; this.Label2.Text = ZWL.DBUtility.DbHelperSQL.GetSHSL("select [TrueName] from ERPUser where [UserName]='" + MyLanEmail.FromUser + "'"); string ToUser = ""; foreach (string C in MyLanEmail.ToUser.Split(',')) { string CTrueName = ZWL.DBUtility.DbHelperSQL.GetSHSL("select [TrueName] from ERPUser where [UserName]='" + C + "'"); if (!string.IsNullOrEmpty(CTrueName)) { ToUser += ToUser == "" ? CTrueName : "," + CTrueName; } else { ToUser += ToUser == "" ? C : "," + C; } } this.Label3.Text = ToUser; this.Label4.Text = MyLanEmail.TimeStr.ToString(); this.Label5.Text = ZWL.Common.PublicMethod.GetWenJian(MyLanEmail.FuJian, "../UploadFile/"); this.Label6.Text = MyLanEmail.EmailContent; //写系统日志 ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi(); MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName"); MyRiZhi.DoSomething = "用户查看调度(" + this.Label1.Text + ")"; MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString(); MyRiZhi.Add(); //设置为已读 if (MyLanEmail.ToUser.Trim() == ZWL.Common.PublicMethod.GetSessionValue("UserName").Trim()) { if (MyLanEmail.EmailState == "未读") { ZWL.DBUtility.DbHelperSQL.ExecuteSQL("update ERPLanEmail set EmailState='已读' where ID=" + Request.QueryString["ID"].ToString().Trim()); } } ReturnInput.Value = Request.UrlReferrer.ToString() == null ? "../LanEmail/LanEmailShou.aspx" : Request.UrlReferrer.ToString(); if (ReturnInput.Value.IndexOf("LanEmailAdd") != -1) //若上级是新增页面 { iframeid.Value = Request.QueryString["iframeid"].ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); ZWL.BLL.ERPLanEmail MyLanEmail = new ZWL.BLL.ERPLanEmail(); MyLanEmail.GetModel(int.Parse(Request.QueryString["ID"].ToString().Trim())); this.Label1.Text = MyLanEmail.EmailTitle; this.Label2.Text = ZWL.DBUtility.DbHelperSQL.GetSHSL("select [TrueName] from ERPUser where [UserName]='" + MyLanEmail.FromUser + "'"); string ToUser = ""; foreach(string C in MyLanEmail.ToUser.Split(',')) { string CTrueName = ZWL.DBUtility.DbHelperSQL.GetSHSL("select [TrueName] from ERPUser where [UserName]='" + C + "'"); if(!string.IsNullOrEmpty(CTrueName)) { ToUser += ToUser == "" ? CTrueName : "," + CTrueName; } else { ToUser += ToUser == "" ? C : "," + C; } } this.Label3.Text = ToUser; this.Label4.Text = MyLanEmail.TimeStr.ToString(); this.Label5.Text =ZWL.Common.PublicMethod.GetWenJian(MyLanEmail.FuJian,"../UploadFile/"); this.Label6.Text = MyLanEmail.EmailContent; //写系统日志 ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi(); MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName"); MyRiZhi.DoSomething = "用户查看调度(" + this.Label1.Text + ")"; MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString(); MyRiZhi.Add(); //设置为已读 if (MyLanEmail.ToUser.Trim() == ZWL.Common.PublicMethod.GetSessionValue("UserName").Trim()) { if (MyLanEmail.EmailState == "未读") { ZWL.DBUtility.DbHelperSQL.ExecuteSQL("update ERPLanEmail set EmailState='已读' where ID=" + Request.QueryString["ID"].ToString().Trim()); } } ReturnInput.Value = Request.UrlReferrer.ToString() == null ? "../LanEmail/LanEmailShou.aspx" : Request.UrlReferrer.ToString(); if(ReturnInput.Value.IndexOf("LanEmailAdd") != -1) { //若上级是新增页面 iframeid.Value = Request.QueryString["iframeid"].ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); ZWL.BLL.ERPLanEmail MyLanEmail = new ZWL.BLL.ERPLanEmail(); //获得最新的一个未读ID int NewMailID = int.Parse(ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select top 1 ID from ERPLanEmail where ToUser='******' and EmailState='未读' order by ID desc")); MyLanEmail.GetModel(NewMailID); this.Label5.Text = MyLanEmail.EmailTitle; this.Label2.Text = MyLanEmail.FromUser; this.Label4.Text = MyLanEmail.ToUser; this.Label3.Text = MyLanEmail.TimeStr.ToString(); this.Label6.Text = MyLanEmail.EmailContent + "<br>" + ZWL.Common.PublicMethod.GetWenJian(MyLanEmail.FuJian, "../UploadFile/"); this.Label7.Text = NewMailID.ToString(); //新邮件个数 this.Label1.Text = ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select count(*) from ERPLanEmail where ToUser='******' and EmailState='未读'"); this.HyperLink1.NavigateUrl = "../LanEmail/EmailView.aspx?ID=" + NewMailID.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); ZWL.BLL.ERPLanEmail MyLanEmail = new ZWL.BLL.ERPLanEmail(); //获得最新的一个未读ID int NewMailID = int.Parse(ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select top 1 ID from ERPLanEmail where ToUser='******' and EmailState='未读' order by ID desc")); MyLanEmail.GetModel(NewMailID); this.Label5.Text = MyLanEmail.EmailTitle; this.Label2.Text = MyLanEmail.FromUser; this.Label4.Text = MyLanEmail.ToUser; this.Label3.Text = MyLanEmail.TimeStr.ToString(); this.Label6.Text = MyLanEmail.EmailContent + "<br>" + ZWL.Common.PublicMethod.GetWenJian(MyLanEmail.FuJian, "../UploadFile/"); this.Label7.Text = NewMailID.ToString(); //新邮件个数 this.Label1.Text = ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select count(*) from ERPLanEmail where ToUser='******' and EmailState='未读'"); this.HyperLink1.NavigateUrl = "../LanEmail/EmailView.aspx?ID=" + NewMailID.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); //设置上传的附件为空 ZWL.Common.PublicMethod.SetSessionValue("WenJianList", ""); try { this.TextBox2.Text = Request.QueryString["UserName"].ToString(); } catch { } //检测是回复或者转发 try { if (Request.QueryString["Type"].ToString().Trim() == "HuiFu") { ZWL.BLL.ERPLanEmail MyModel = new ZWL.BLL.ERPLanEmail(); MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString())); //设置页面数据 this.TextBox1.Text = "Re:" + MyModel.EmailTitle; this.TextBox2.Text = MyModel.FromUser; } } catch { } //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ try { if (Request.QueryString["Type"].ToString().Trim() == "ZhuanFa") { ZWL.BLL.ERPLanEmail MyModel = new ZWL.BLL.ERPLanEmail(); MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString())); //设置页面数据 this.TextBox1.Text = "RW:" + MyModel.EmailTitle; this.TxtContent.Value = MyModel.EmailContent; ZWL.Common.PublicMethod.SetSessionValue("WenJianList", MyModel.FuJian); ZWL.Common.PublicMethod.BindDDL(this.CheckBoxList1, ZWL.Common.PublicMethod.GetSessionValue("WenJianList")); } } catch { } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); //设置上传的附件为空 ZWL.Common.PublicMethod.SetSessionValue("WenJianList", ""); try { string UserNames = "'" + Request.QueryString["UserName"].ToString().Replace(",", "','") + "'"; this.UserName_Input.Value = Request.QueryString["UserName"].ToString(); DataTable dt = ZWL.DBUtility.DbHelperSQL.GetDataTable("select [TrueName] from ERPUser where [UserName] in (" + UserNames + ")"); string UserName = ""; foreach (DataRow R in dt.Rows) { UserName += UserName == "" ? R["TrueName"] : "," + R["TrueName"]; } this.TextBox2.Text = UserName; } catch { } //检测是回复或者转发 try { if (Request.QueryString["Type"].ToString().Trim() == "HuiFu") { ZWL.BLL.ERPLanEmail MyModel = new ZWL.BLL.ERPLanEmail(); MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString())); //设置页面数据 this.TextBox1.Text = "Re:" + MyModel.EmailTitle; this.UserName_Input.Value = MyModel.FromUser; string FromUser = ""; foreach (string C in MyModel.FromUser.Split(',')) { string CTrueName = ZWL.DBUtility.DbHelperSQL.GetSHSL("select [TrueName] from ERPUser where [UserName]='" + C + "'"); if (!string.IsNullOrEmpty(CTrueName)) { FromUser += FromUser == "" ? CTrueName : "," + CTrueName; } else { FromUser += FromUser == "" ? C : "," + C; } } this.TextBox2.Text = FromUser; } } catch { } //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ try { if (Request.QueryString["Type"].ToString().Trim() == "ZhuanFa") { ZWL.BLL.ERPLanEmail MyModel = new ZWL.BLL.ERPLanEmail(); MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString())); //设置页面数据 this.TextBox1.Text = "RW:" + MyModel.EmailTitle; this.TxtContent.Text = MyModel.EmailContent; ZWL.Common.PublicMethod.SetSessionValue("WenJianList", MyModel.FuJian); ZWL.Common.PublicMethod.BindDDL(this.CheckBoxList1, MyModel.FuJian); } } catch { } if (Request.UrlReferrer.ToString().IndexOf("Main.aspx") == -1) { ReturnInput.Value = Request.UrlReferrer == null ? "../LanEmail/LanEmailShou.aspx" : Request.UrlReferrer.ToString(); } else { ReturnInput.Value = "../LanEmail/LanEmailShou.aspx"; } } }
protected void Page_Load(object sender, EventArgs e) { if(!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); //设置上传的附件为空 ZWL.Common.PublicMethod.SetSessionValue("WenJianList", ""); try { string UserNames = "'"+Request.QueryString["UserName"].ToString().Replace(",","','")+"'"; this.UserName_Input.Value = Request.QueryString["UserName"].ToString(); DataTable dt= ZWL.DBUtility.DbHelperSQL.GetDataTable("select [TrueName] from ERPUser where [UserName] in (" +UserNames + ")"); string UserName =""; foreach(DataRow R in dt.Rows) { UserName += UserName == "" ? R["TrueName"] : "," + R["TrueName"]; } this.TextBox2.Text = UserName; } catch { } //检测是回复或者转发 try { if(Request.QueryString["Type"].ToString().Trim() == "HuiFu") { ZWL.BLL.ERPLanEmail MyModel = new ZWL.BLL.ERPLanEmail(); MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString())); //设置页面数据 this.TextBox1.Text = "Re:" + MyModel.EmailTitle; this.UserName_Input.Value = MyModel.FromUser; string FromUser = ""; foreach(string C in MyModel.FromUser.Split(',')) { string CTrueName = ZWL.DBUtility.DbHelperSQL.GetSHSL("select [TrueName] from ERPUser where [UserName]='" + C + "'"); if(!string.IsNullOrEmpty(CTrueName)) { FromUser += FromUser == "" ? CTrueName : "," + CTrueName; } else { FromUser += FromUser == "" ? C : "," + C; } } this.TextBox2.Text = FromUser; } } catch { } //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ try { if(Request.QueryString["Type"].ToString().Trim() == "ZhuanFa") { ZWL.BLL.ERPLanEmail MyModel = new ZWL.BLL.ERPLanEmail(); MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString())); //设置页面数据 this.TextBox1.Text = "RW:" + MyModel.EmailTitle; this.TxtContent.Text = MyModel.EmailContent; ZWL.Common.PublicMethod.SetSessionValue("WenJianList", MyModel.FuJian); ZWL.Common.PublicMethod.BindDDL(this.CheckBoxList1, MyModel.FuJian); } } catch { } if(Request.UrlReferrer.ToString().IndexOf("Main.aspx") == -1) { ReturnInput.Value = Request.UrlReferrer == null ? "../LanEmail/LanEmailShou.aspx" : Request.UrlReferrer.ToString(); } else { ReturnInput.Value = "../LanEmail/LanEmailShou.aspx"; } } }