/// <summary> /// 获得查询where /// </summary> /// <returns></returns> string GetWhere() { JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL(); string str = "Workprogress=3"; string id = com.getsid("tast").ToString(); if (id == "3") { str = "Workprogress=" + id.ToString(); } else if (id == "9") { str = "Workprogress=9 and Manager=" + "'" + getvalue(2) + "'"; } else if (id == "45678") { str = "Workprogress in(4,5,6,7,8)"; str += " and Manager=" + "'" + getvalue(2) + "'"; } if (Tasktitle.Text.Trim() != "") { str += " and (Tasktitle like " + "'" + Tasktitle.Text.Trim() + "%')"; } if (classse.SelectedValue.ToString() != "0") { str += " and classse=" + "'" + classse.SelectedValue.ToString() + "'"; } return(str); }
public string getstrobj(object name, int i) { JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL(); string str = ""; if (i == 1) { DataTable dt = com.COM_Select("OA_ItemTB", "id", "", name.ToString(), "", 4); if (dt.Rows.Count != 0) { str = dt.Rows[0]["titlename"].ToString(); } } else { if (name.ToString() == "1") { str = "一般"; } else if (name.ToString() == "2") { str = "紧急"; } else { str = "十分紧急"; } } return(str); }
protected void drop() { JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL(); Itemid.DataSource = com.COM_Select("OA_ItemTB", "typeid", "parentid", "1", "0", 8); Itemid.DataTextField = "titlename"; Itemid.DataValueField = "Id"; Itemid.DataBind(); }
protected void gvlist_RowDataBound(object sender, GridViewRowEventArgs e) { int num = 0; // if (e.Row.RowIndex != -1) { int id = e.Row.RowIndex + 1; e.Row.Cells[0].Text = id.ToString(); } if (e.Row.RowType == DataControlRowType.DataRow) { #region 行事件 string fid = gvlist.DataKeys[e.Row.RowIndex].Value.ToString().Trim(); GridView gvlist3 = (GridView)e.Row.FindControl("GridView2"); if (fid != "") { JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL(); DataTable dt = com.COM_Select("OA_ItemTB", "parentid", "Isdelete", fid, "1", 8); gvlist3.DataSource = dt; gvlist3.DataBind(); if (com.getsid("uid") != "-1" && com.getsid("kq") != "-1") { DataTable ds =com.COM_Proc_Sel3("Pc_SelOpposebyPTI",fid,com.getsid("uid"), com.getsid("kq")); for (int i = 0; i < ds.Rows.Count; i++) { Label lb = (Label)gvlist3.Rows[i].FindControl("lbtxt"); switch (getvalue(4)) { case "1": lb.Text = ds.Rows[i]["threescore"].ToString(); break; case "2": lb.Text = ds.Rows[i]["twoscore"].ToString(); break; case "3": lb.Text = ds.Rows[i]["onescore"].ToString(); break; case "4": lb.Text = ds.Rows[i]["custom"].ToString(); break; } num +=Convert.ToInt32(lb.Text.Trim()); TextBox txt = (TextBox)gvlist3.Rows[i].FindControl("txtremark"); txt.Text = ds.Rows[i]["remrk"].ToString(); } } } #endregion Label lbtxt = (Label)e.Row.FindControl("labnum"); lbtxt.Text = num.ToString(); Snum += num; } // 合计 if (e.Row.RowType == DataControlRowType.Footer) { e.Row.Cells[3].Text = "合计您给的总分:<font style=\"color:red\">"+Snum.ToString()+"</font>"; } }
protected void drop() { JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL(); dropitem.DataSource = com.COM_Select("OA_ItemTB", "typeid", "parentid", "1", "0", 8); dropitem.DataTextField = "titlename"; dropitem.DataValueField = "Id"; dropitem.DataBind(); dropitem.Items.Insert(0, new ListItem("======全部项目======", "0")); }
void show() { JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL(); DataTable table = com.COM_Select("OA_Message", "Mid", "", mes.ToString(), "", 4); if (table.Rows.Count != 0) { ren.Visible = false; } else { ren.Visible = true; drop(); } }
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); }
public string getstrobj(object name, int i) { JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL(); string str = ""; if (i == 1) { DataTable dt = com.COM_Select("OA_ItemTB", "id", "", name.ToString(), "", 4); if (dt.Rows.Count != 0) str = dt.Rows[0]["titlename"].ToString(); } else { if (name.ToString() == "1") str = "一般"; else if (name.ToString() == "2") str = "紧急"; else str = "十分紧急"; } return str; }
void showdp() { JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL(); int uid = Convert.ToInt32(com.getsid("fid")); if (uid != -1) { int dpid = new JumbotOA.BLL.UserBLL().GetEntity(uid).Did; DropDownList1.SelectedValue = dpid.ToString(); DropDownList1.Enabled = false; this.DropDownList2.DataSource = new JumbotOA.BLL.UserBLL().GetList("Did=" + DropDownList1.SelectedValue.ToString()); this.DropDownList2.DataTextField = "Uname"; this.DropDownList2.DataValueField = "Uid"; this.DropDownList2.DataBind(); DropDownList2.SelectedValue = uid.ToString(); DropDownList2.Enabled = false; } else { DropDownList1.Enabled = true; DropDownList2.Enabled = true; } }
protected void Show() { JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL(); string id = com.getsid("tast").ToString(); switch (id) { case "-1": gvlist.Visible = false; AspNetPager1.Visible = false; break; case "3": gvlist.Columns[7].Visible = false; gvlist.Columns[9].Visible = false; gvlist.Columns[4].Visible = false; break; case "9": gvlist.Columns[5].Visible = false; break; case "45678": gvlist.Columns[7].Visible = false; gvlist.Columns[8].Visible = false; break; } }
void show() { JumbotOA.BLL.COMDLL com=new JumbotOA.BLL.COMDLL (); DataTable table = com.COM_Select("OA_Message", "Mid", "", mes.ToString(), "", 4); if (table.Rows.Count != 0) { ren.Visible = false; } else { ren.Visible = true; drop(); } }
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 Show() { JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL(); string id = com.getsid("tast").ToString(); switch (id) { case "-1": gvlist.Visible = false; AspNetPager1.Visible = false; break; case "3": gvlist.Columns[7].Visible=false;gvlist.Columns[9].Visible=false;gvlist.Columns[4].Visible=false; break; case "9": gvlist.Columns[5].Visible = false; break; case "45678": gvlist.Columns[7].Visible = false;gvlist.Columns[8].Visible=false; break; } }
protected void gvlist_RowDataBound(object sender, GridViewRowEventArgs e) { int num = 0; // if (e.Row.RowIndex != -1) { int id = e.Row.RowIndex + 1; e.Row.Cells[0].Text = id.ToString(); } if (e.Row.RowType == DataControlRowType.DataRow) { #region 行事件 string fid = gvlist.DataKeys[e.Row.RowIndex].Value.ToString().Trim(); GridView gvlist3 = (GridView)e.Row.FindControl("GridView2"); if (fid != "") { JumbotOA.BLL.COMDLL com = new JumbotOA.BLL.COMDLL(); DataTable dt = com.COM_Select("OA_ItemTB", "parentid", "Isdelete", fid, "1", 8); gvlist3.DataSource = dt; gvlist3.DataBind(); if (com.getsid("uid") != "-1" && com.getsid("kq") != "-1") { DataTable ds = com.COM_Proc_Sel3("Pc_SelOpposebyPTI", fid, com.getsid("uid"), com.getsid("kq")); for (int i = 0; i < ds.Rows.Count; i++) { Label lb = (Label)gvlist3.Rows[i].FindControl("lbtxt"); switch (getvalue(4)) { case "1": lb.Text = ds.Rows[i]["threescore"].ToString(); break; case "2": lb.Text = ds.Rows[i]["twoscore"].ToString(); break; case "3": lb.Text = ds.Rows[i]["onescore"].ToString(); break; case "4": lb.Text = ds.Rows[i]["custom"].ToString(); break; } num += Convert.ToInt32(lb.Text.Trim()); TextBox txt = (TextBox)gvlist3.Rows[i].FindControl("txtremark"); txt.Text = ds.Rows[i]["remrk"].ToString(); } } } #endregion Label lbtxt = (Label)e.Row.FindControl("labnum"); lbtxt.Text = num.ToString(); Snum += num; } // 合计 if (e.Row.RowType == DataControlRowType.Footer) { e.Row.Cells[3].Text = "合计您给的总分:<font style=\"color:red\">" + Snum.ToString() + "</font>"; } }
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, "您还没有保存过邮箱名称和密码信息!暂时无法检索!"); } }
/// <summary> /// 获得查询where /// </summary> /// <returns></returns> string GetWhere() { JumbotOA.BLL.COMDLL com=new JumbotOA.BLL.COMDLL (); string str = "Workprogress=3"; string id=com.getsid("tast").ToString(); if (id == "3") str = "Workprogress=" + id.ToString(); else if (id == "9") { str = "Workprogress=9 and Manager=" + "'" + getvalue(2) + "'"; } else if (id == "45678") { str = "Workprogress in(4,5,6,7,8)"; str += " and Manager=" + "'" + getvalue(2) + "'"; } if (Tasktitle.Text.Trim() != "") str += " and (Tasktitle like " + "'" + Tasktitle.Text.Trim() + "%')"; if (classse.SelectedValue.ToString() != "0") str += " and classse=" +"'"+ classse.SelectedValue.ToString()+"'"; return str; }