protected void Page_Load(object sender, EventArgs e) { User_Load("login"); pids = Convert.ToInt32(getvalue(4)); Checkgvlist0(); if (!IsPostBack) { dropuser(); year(); mouth(); showqi(); GetList(); SHgvlist(); if (pids == 1)//验证设置打分公式 { dafen.Visible = true; } else { dafen.Visible = false; } DataTable dt = com.COM_Proc_Sel1("PC_SelOpenTB", "1"); if (dt.Rows.Count != 0) { gvlist.Enabled = true; Button3.Enabled = true; } else { //打分表格隐藏 gvlist.Enabled = false; Button3.Enabled = false; } } }
protected void Button1_Click(object sender, EventArgs e) { JumbotOA.BLL.URLENCRYP urlen = new JumbotOA.BLL.URLENCRYP(); DataTable dt = com.COM_Proc_Sel1("PC_getOA_email", UserId.ToString()); if (dt.Rows.Count == 0) { dt.Rows.Clear(); DataRow dr = dt.NewRow(); dr["emailname"] = emailname.Text.Trim() + Tpdropdown.Text.Trim(); dr["emailpwd"] = urlen.Encryp(emailpwd.Text.Trim()); dr["uid"] = UserId.ToString(); dr["inserttime"] = DateTime.Now.ToString(); dt.Rows.Add(dr); com.COM_Add(dt, "OA_emailTB", "@emailname,@emailpwd,@uid,@inserttime"); emailname.Text = emailpwd.Text = ""; Tools.Common.JavaScript.MessageBox(this, "保存成功!"); } }
public string email() { string a = ""; JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL(); DataTable dt = com.COM_Proc_Sel1("Pc_emailsystem", "," + UserId + ","); if (dt.Rows.Count != 0) { if (dt.Rows[0]["contents"].ToString() != "0") a = "<a href=" + "" + dt.Rows[0]["titles"].ToString() + "" + " target=\"_blank\">共有<font style=\"color:#000099;font-weight: bold\">" + dt.Rows[0]["files"].ToString() + "</font> 封邮件,今天有<font style=\"color: #FF0000;font-weight: bold\">" + dt.Rows[0]["contents"].ToString() + "</font>封邮件,请登录!" + "</a>"; //string sid = dt.Rows[0]["Id"].ToString(); //DataRow drw = dt.Rows[0]; //drw["files"] = "0"; //com.COM_Up(dt, "OA_EmailtextTB", "files=@files", sid); } return a; }
public string email() { string a = ""; JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL(); DataTable dt = com.COM_Proc_Sel1("Pc_emailsystem", "," + UserId + ","); if (dt.Rows.Count != 0) { if (dt.Rows[0]["contents"].ToString() != "0") { a = "<a href=" + "" + dt.Rows[0]["titles"].ToString() + "" + " target=\"_blank\">共有<font style=\"color:#000099;font-weight: bold\">" + dt.Rows[0]["files"].ToString() + "</font> 封邮件,今天有<font style=\"color: #FF0000;font-weight: bold\">" + dt.Rows[0]["contents"].ToString() + "</font>封邮件,请登录!" + "</a>"; } //string sid = dt.Rows[0]["Id"].ToString(); //DataRow drw = dt.Rows[0]; //drw["files"] = "0"; //com.COM_Up(dt, "OA_EmailtextTB", "files=@files", sid); } return(a); }
void bangemmail() { JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL(); JumbotOA.BLL.URLENCRYP urlen = new JumbotOA.BLL.URLENCRYP(); string UserId = JumbotOA.BLL.OA_SysMessageIn.userid(); string username = "", userpwd = "", pstr = ""; string[] str = null; DataTable dt = com.COM_Proc_Sel1("PC_getOA_email", UserId.ToString()); if (dt.Rows.Count != 0) { #region 存储了邮箱 str = dt.Rows[0]["emailname"].ToString().Split("@".ToCharArray()); if (str[1] == "jumbotcms.net") username = str[0].ToString(); else username = dt.Rows[0]["emailname"].ToString(); pstr = dt.Rows[0]["emailname"].ToString(); userpwd = urlen.Decryp(dt.Rows[0]["emailpwd"].ToString()); jmail.POP3Class popMail = new POP3Class(); jmail.Message mailMessage; //取得最大时间 DataTable dts = com.COM_Proc_Sel1("Pc_emailsystem", "," + UserId + ","); string popstr = JumbotOA.BLL.Eemail.GetFormatPop3(pstr).ToString(); int num = 0; try { popMail.Connect(username, userpwd, popstr, 110); //建立连接 if (0 < popMail.Count) { #region 检索今天邮件 DateTime t1= Convert.ToDateTime(DateTime.Now.ToString("yyyy-M-d").ToString() + " 01:00:00"); DateTime t2=Convert.ToDateTime(DateTime.Now.ToString("yyyy-M-d").ToString() + " 23:59:59"); for (int i = popMail.Count; i > 0; i--) { mailMessage = popMail.Messages[i]; if (dts.Rows.Count != 0) { if (mailMessage.Date >= t1 && mailMessage.Date <= t2) num++; else continue; } else { dts.Rows.Clear(); DataRow dr = dts.NewRow(); dr["uid"] = "," + UserId + ","; dr["recivetime"] = DateTime.Now; dr["files"] = popMail.Count.ToString();//邮件总数 dr["contents"] = "0"; dts.Rows.Add(dr); com.COM_Add(dts, "OA_EmailtextTB", "@uid,@recivetime,@files,@contents"); } } #endregion } string titles = ""; switch (str[1]) { case "jumbotcms.net": titles = "http://mail.jumbotcms.net/default.jsp"; break; case "sina.com": titles = "http://mail.sina.com.cn"; break; case "sina.cn": titles = "http://mail.sina.com.cn/cnmail/index.html"; break; case "163.com": titles = "http://email.163.com"; break; case "126.com": titles = "http://email.163.com"; break; case "yeah.net": titles = "http://email.163.com"; break; case "qq.com": titles = "https://mail.qq.com/cgi-bin/loginpage?flowid=16621966528880993"; break; } string Id = dts.Rows[0]["Id"].ToString(); DataRow drw = dts.Rows[0]; drw["recivetime"] = DateTime.Now; drw["titles"] = titles; drw["files"] = popMail.Count.ToString(); drw["contents"] = num.ToString(); com.COM_Up(dts, "OA_EmailtextTB", "recivetime=@recivetime,titles=@titles,files=@files,contents=@contents", Id); popMail.Disconnect(); popMail = null; Tools.Common.JavaScript.MessageBox(this, "检索成功!"); } catch (Exception e) { com.ErroLog(e.ToString()); Tools.Common.JavaScript.MessageBox(this, "检索失败!网络连接已超时!"); } #endregion } else Tools.Common.JavaScript.MessageBox(this, "您还没有保存过邮箱名称和密码信息!暂时无法检索!"); }
void bangemmail() { JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL(); JumbotOA.BLL.URLENCRYP urlen = new JumbotOA.BLL.URLENCRYP(); string UserId = JumbotOA.BLL.OA_SysMessageIn.userid(); string username = "", userpwd = "", pstr = ""; string[] str = null; DataTable dt = com.COM_Proc_Sel1("PC_getOA_email", UserId.ToString()); if (dt.Rows.Count != 0) { #region 存储了邮箱 str = dt.Rows[0]["emailname"].ToString().Split("@".ToCharArray()); if (str[1] == "jumbotcms.net") { username = str[0].ToString(); } else { username = dt.Rows[0]["emailname"].ToString(); } pstr = dt.Rows[0]["emailname"].ToString(); userpwd = urlen.Decryp(dt.Rows[0]["emailpwd"].ToString()); jmail.POP3Class popMail = new POP3Class(); jmail.Message mailMessage; //取得最大时间 DataTable dts = com.COM_Proc_Sel1("Pc_emailsystem", "," + UserId + ","); string popstr = JumbotOA.BLL.Eemail.GetFormatPop3(pstr).ToString(); int num = 0; try { popMail.Connect(username, userpwd, popstr, 110); //建立连接 if (0 < popMail.Count) { #region 检索今天邮件 DateTime t1 = Convert.ToDateTime(DateTime.Now.ToString("yyyy-M-d").ToString() + " 01:00:00"); DateTime t2 = Convert.ToDateTime(DateTime.Now.ToString("yyyy-M-d").ToString() + " 23:59:59"); for (int i = popMail.Count; i > 0; i--) { mailMessage = popMail.Messages[i]; if (dts.Rows.Count != 0) { if (mailMessage.Date >= t1 && mailMessage.Date <= t2) { num++; } else { continue; } } else { dts.Rows.Clear(); DataRow dr = dts.NewRow(); dr["uid"] = "," + UserId + ","; dr["recivetime"] = DateTime.Now; dr["files"] = popMail.Count.ToString();//邮件总数 dr["contents"] = "0"; dts.Rows.Add(dr); com.COM_Add(dts, "OA_EmailtextTB", "@uid,@recivetime,@files,@contents"); } } #endregion } string titles = ""; switch (str[1]) { case "jumbotcms.net": titles = "http://mail.jumbotcms.net/default.jsp"; break; case "sina.com": titles = "http://mail.sina.com.cn"; break; case "sina.cn": titles = "http://mail.sina.com.cn/cnmail/index.html"; break; case "163.com": titles = "http://email.163.com"; break; case "126.com": titles = "http://email.163.com"; break; case "yeah.net": titles = "http://email.163.com"; break; case "qq.com": titles = "https://mail.qq.com/cgi-bin/loginpage?flowid=16621966528880993"; break; } string Id = dts.Rows[0]["Id"].ToString(); DataRow drw = dts.Rows[0]; drw["recivetime"] = DateTime.Now; drw["titles"] = titles; drw["files"] = popMail.Count.ToString(); drw["contents"] = num.ToString(); com.COM_Up(dts, "OA_EmailtextTB", "recivetime=@recivetime,titles=@titles,files=@files,contents=@contents", Id); popMail.Disconnect(); popMail = null; Tools.Common.JavaScript.MessageBox(this, "检索成功!"); } catch (Exception e) { com.ErroLog(e.ToString()); Tools.Common.JavaScript.MessageBox(this, "检索失败!网络连接已超时!"); } #endregion } else { Tools.Common.JavaScript.MessageBox(this, "您还没有保存过邮箱名称和密码信息!暂时无法检索!"); } }