//提交 protected void Button1_Click(object sender, EventArgs e) { string sid = txtid.Text.Trim(); if (sid == "") { sid = "-1"; } DataTable table = com.COM_Select("OA_ItemTB", "Id", "", sid, "", 4); if (table.Rows.Count != 0) { DataRow dr = table.Rows[0]; dr["typeid"] = typeid.SelectedValue.ToString(); dr["titlename"] = titlename.Text.Trim(); com.COM_Up(table, "OA_ItemTB", "typeid=@typeid,titlename=@titlename", sid); ok.Text = "修改成功!"; } else { table.Rows.Clear(); DataRow dr = table.NewRow(); dr["typeid"] = typeid.SelectedValue.ToString(); dr["titlename"] = titlename.Text.Trim(); table.Rows.Add(dr); com.COM_Add(table, "OA_ItemTB", "@typeid,@titlename"); ok.Text = "添加成功!"; } show(); txtid.Text = ""; titlename.Text = ""; }
//提交 protected void Button1_Click(object sender, EventArgs e) { string sid = com.getsid("fid"); string id = com.getsid("id"); DataTable table = com.COM_Select("OA_ItemTB", "Id", "", id, "", 4); if (table.Rows.Count != 0) { DataRow dr = table.Rows[0]; dr["titlename"] = titlename.Text.Trim(); com.COM_Up(table, "OA_ItemTB", "titlename=@titlename", id); Response.Write("<script>parent.location.href='Item.aspx'</script>"); } else { if (sid != "-1") { table.Rows.Clear(); DataRow dr = table.NewRow(); dr["titlename"] = titlename.Text.Trim(); dr["parentid"] = sid; dr["Isdelete"] = 1; table.Rows.Add(dr); com.COM_Add(table, "OA_ItemTB", "@titlename,@parentid,@Isdelete"); Response.Write("<script>parent.location.href='Item.aspx'</script>"); } else { Label2.Text = "提交无效!"; } } }
/// <summary> /// 提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button2_Click(object sender, EventArgs e) { string sid = com.getsid("sques"); DataTable dt = com.COM_Select("OA_QuestionTB", "Id", "", sid, "", 4); if (sid != "-1") { string user = getvalue(2); string u = dt.Rows[0]["quuser"].ToString(); if (user != u) { antime.Text = DateTime.Now.ToString(); } else { uptime.Text = DateTime.Now.ToString(); } DataRow dr = dt.Rows[0]; DR(dr); com.COM_Up(dt, "OA_QuestionTB", JumbotOA.BLL.Component.UpQuestion, sid); FinalMessage("提交成功!", "Squestion.aspx", 0); } else { if (getvalue(2) != touser.SelectedValue.ToString()) { quuser.Text = getvalue(2); inserttime.Text = DateTime.Now.ToString(); dt.Rows.Clear(); DataRow dr = dt.NewRow(); DR(dr); dt.Rows.Add(dr); com.COM_Add(dt, "OA_QuestionTB", JumbotOA.BLL.Component.InQuestion); FinalMessage("提交成功!", "Squestion.aspx", 0); } else { Tools.Common.JavaScript.MessageBox(this, "当前解决人和发布人不能同时存在!"); } } }
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, "保存成功!"); } }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { sid = com.getsid("address").ToString(); DataTable dt = com.COM_Select("OA_Address", "Id", "", sid, "", 4); DataRow dr; if (sid != "-1") { dr = dt.Rows[0]; drs(dr); com.COM_Up(dt, "OA_Address", "truename=@truename,phones=@phones,telephone=@telephone,email=@email,qq=@qq,Pids=@Pids", sid); } else { dr = dt.NewRow(); drs(dr); dt.Rows.Add(dr); com.COM_Add(dt, "OA_Address", "@truename,@phones,@telephone,@email,@qq,@Pids"); } go(); }
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, "您还没有保存过邮箱名称和密码信息!暂时无法检索!"); } }
//提交打分 protected void Button3_Click(object sender, EventArgs e) { Opposes = com.COM_Proc_Sel3("PC_CheckOpposes", ddlUname.SelectedValue.ToString(), intime, "1"); //1验证是否存在打分记录 if (ddlUname.SelectedValue != "0") { if (Opposes.Rows.Count != 0)//判读同周期下是否存在某角色已打分 { string statuis = Opposes.Rows[0]["statuis"].ToString(); #region 更新角色打分,统计 Opposes = com.COM_Proc_Sel3("PC_CheckOpposes", ddlUname.SelectedValue.ToString(), pids.ToString(), intime); if (Opposes.Rows.Count == 0) { //更新打分 int c = 0; for (int i = 0; i < gvlist.Rows.Count; i++) { GridView gvlist2 = (GridView)gvlist.Rows[i].FindControl("GridView2"); string sid = gvlist.DataKeys[i].Value.ToString();//考核大栏目编号 DataTable table = com.COM_Proc_Sel3("PC_GetOpposes", ddlUname.SelectedValue.ToString(), sid, intime); for (int j = 0; j < table.Rows.Count; j++) { #region up Opposes data RadioButtonList rbl = (RadioButtonList)gvlist2.Rows[j].FindControl("Radio"); string ords = ((TextBox)(gvlist2.Rows[j].Cells[4].Controls[1])).Text.Trim(); if (rbl.SelectedValue.ToString() == "") { com.COM_Proc_DelorUp_3("PC_Upall0pposes", ddlUname.SelectedValue.ToString(), intime, statuis); Tools.Common.JavaScript.MessageBox(this, "第 " + (i + 1) + " 模块下的第" + (j + 1) + "行的具体考核因素未选择,请重新选择!"); return; } if (rbl.SelectedValue.ToString() == "20" || rbl.SelectedValue.ToString() == "0") { if (ords == "") { com.COM_Proc_DelorUp_3("PC_Upall0pposes", ddlUname.SelectedValue.ToString(), intime, statuis); Tools.Common.JavaScript.MessageBox(this, "第 " + (i + 1) + " 模块下的第" + (j + 1) + "行的备注不能为空,请重新填写!"); return; } } string id = table.Rows[j]["Id"].ToString();//考核编号 string stsuid = table.Rows[j]["statuis"].ToString(); string rem = table.Rows[j]["remrk"].ToString(); string column = ""; DataRow dr = table.Rows[0]; if (ords.Trim() != "") { dr["remrk"] = rem + "|" + ords; } else { dr["remrk"] = rem; } switch (pids) { case 1: dr["threescore"] = rbl.SelectedValue.ToString(); column = "threescore=@threescore"; c += Convert.ToInt32(rbl.SelectedValue); break; case 2: dr["twoscore"] = rbl.SelectedValue.ToString(); column = "twoscore=@twoscore"; c += Convert.ToInt32(rbl.SelectedValue); break; case 3: dr["onescore"] = rbl.SelectedValue.ToString(); column = "onescore=@onescore"; c += Convert.ToInt32(rbl.SelectedValue); break; case 4: dr["custom"] = rbl.SelectedValue.ToString(); column = "custom=@custom"; c += Convert.ToInt32(rbl.SelectedValue); break; } dr["statuis"] = stsuid + pids.ToString() + ","; com.COM_Up(table, "OA_Opposes", "remrk=@remrk," + column + ",statuis=@statuis", id); #endregion // com.pkUpdate(Opposes, "OA_Opposes", "orderby=@orderby", gvlsit.DataKeys[jj].Value.ToString());//书卷编号); } } Stats(c); FinalMessage("打分成功!", "Scorelist.aspx", 0); } else { Tools.Common.JavaScript.Redirect(this, "您的角色已经打过分了,系统禁用重复打分,谢谢操作!", "Scorelist.aspx"); } #endregion } else { #region 插入打分,统计 int c = 0; for (int i = 0; i < gvlist.Rows.Count; i++) { GridView gvlist2 = (GridView)gvlist.Rows[i].FindControl("GridView2"); string sid = gvlist.DataKeys[i].Value.ToString();//考核大栏目编号 for (int j = 0; j < gvlist2.Rows.Count; j++) { #region add Opposes data RadioButtonList rbl = (RadioButtonList)gvlist2.Rows[j].FindControl("Radio"); string ords = ((TextBox)(gvlist2.Rows[j].Cells[4].Controls[1])).Text.Trim(); if (rbl.SelectedValue.ToString() == "") { com.COM_Proc_DelorUp_2("PC_DelAll0pposes", ddlUname.SelectedValue.ToString(), intime); Tools.Common.JavaScript.MessageBox(this, "第 " + (i + 1) + " 模块下的第" + (j + 1) + "行的具体考核因素未选择,请重新选择!"); return; } if (rbl.SelectedValue.ToString() == "20" || rbl.SelectedValue.ToString() == "0") { if (ords == "") { com.COM_Proc_DelorUp_2("PC_DelAll0pposes", ddlUname.SelectedValue.ToString(), intime); Tools.Common.JavaScript.MessageBox(this, "第 " + (i + 1) + " 模块下的第" + (j + 1) + "行的备注不能为空,请重新填写!"); return; } } string id = gvlist2.DataKeys[j].Value.ToString();//考核栏目编号 string column = ""; Opposes.Rows.Clear(); DataRow dr = Opposes.NewRow(); dr["Itemid"] = id; dr["parentid"] = sid; dr["uid"] = getvalue(1); dr["intimes"] = intime; dr["remrk"] = ords; switch (pids) { case 1: dr["threescore"] = rbl.SelectedValue.ToString(); column = "@threescore"; c += Convert.ToInt32(rbl.SelectedValue); break; case 2: dr["twoscore"] = rbl.SelectedValue.ToString(); column = "@twoscore"; c += Convert.ToInt32(rbl.SelectedValue); break; case 3: dr["onescore"] = rbl.SelectedValue.ToString(); column = "@onescore"; c += Convert.ToInt32(rbl.SelectedValue); break; case 4: dr["custom"] = rbl.SelectedValue.ToString(); column = "@custom"; c += Convert.ToInt32(rbl.SelectedValue); break; } dr["touser"] = ddlUname.SelectedValue.ToString(); dr["statuis"] = "," + pids.ToString() + ","; Opposes.Rows.Add(dr); com.COM_Add(Opposes, "OA_Opposes", "@Itemid,@parentid,@uid,@intimes,@remrk," + column + ",@touser,@statuis"); #endregion // com.pkUpdate(Opposes, "OA_Opposes", "orderby=@orderby", gvlsit.DataKeys[jj].Value.ToString());//书卷编号); } } Stats(c); // Tools.Common.JavaScript.Redirect(this, "打分成功!", "Scorelist.aspx"); FinalMessage("打分成功!", "Scorelist.aspx", 0); #endregion } } else { Tools.Common.JavaScript.MessageBox(this, "禁用同时给所有用户打分!请重新选择用户,谢谢操作!"); } }