private void hysendxx(string lssendtype, string lstxconent) { //lssendtype:发送哪几个提醒,字符串的值为:手机短信#即时消息#待办事宜 //向登记人发:手机短信、即时消息、待办事宜 具体哪个环节发送,写在调用的函数里。 此字段不通用 string[] lvsendtype; lvsendtype = lssendtype.Split('#'); HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); for (int k = 0; k < lvsendtype.Length; k++) { if (lvsendtype[k] == "手机短信") { HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh2 = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); string cb_jsrsjh2 = Hyoa_user.GetMobilebyuserid(this.hy_djrid.Text); Hyoa_global.Sendsms_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), cb_fsrsjh2, this.hy_djrid.Text, this.hy_djrname.Text, cb_jsrsjh2, this.hy_mudelid.Text, lstxconent, 1, "", "", 0, this.hy_tableid.Text); } if (lvsendtype[k] == "即时消息") { Hyoa_global.Sendjstx_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), this.hy_djrid.Text, this.hy_djrname.Text, this.hy_mudelid.Text, lstxconent, 0, this.hy_tableid.Text); } if (lvsendtype[k] == "待办事宜") { Hyoa_global.Senddbsy_global(this.txtdocid.Value, this.hy_djrid.Text, this.hy_djrname.Text, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1", "待办", this.hy_mudelid.Text, "待办箱", "一般", lstxconent, "请办理", 0, this.hy_flowid.Text, this.txtnexttacheid.Value, this.hy_tableid.Text); } } }
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //保存 protected void Button_Save_Click(object sender, EventArgs e) { if (this.Session["hyuid"].ToString() == "") this.Response.Redirect("login.aspx"); string ls_tip = "保存成功!"; #region 新建时先进行一次保存 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); string sql = ""; if (this.txtop.Value == "add") { //处理特殊字符 this.hy_bt.Text = ReplaceString_Tszf(this.hy_bt.Text); if (Session["conntype"].ToString() == "SQL") { //edited by xf 20140625 sql = "insert into hyc_" + this.hy_tableid.Text + " (DOCID,hy_mudelid,hy_tableid,hy_flowid,hy_flowname,hy_curtacheid,hy_curtachename,hy_curclrid,hy_curclrname,hy_djrid,hy_djrname,hy_djrbmid,hy_djrbmname,hy_djsj,hy_bt,hy_readuserlist,hy_readdatelist,hy_clrylist,hy_cyrylist) values ("; sql += "'" + this.txtdocid.Value + "','" + this.hy_mudelid.Text + "','" + this.hy_tableid.Text + "','" + this.hy_flowid.Text + "','" + this.hy_flowname.Text + "'"; sql += ",'" + this.hy_curtacheid.Text + "','" + this.hy_curtachename.Text + "','" + this.hy_curclrid.Text + "','" + this.hy_curclrname.Text + "','" + this.hy_djrid.Text + "'"; sql += ",'" + this.hy_djrname.Text + "','" + this.hy_djrbmid.Text + "','" + this.hy_djrbmname.Text + "','" + this.hy_djsj.Text + "','" + this.hy_bt.Text + "'"; sql += ",'','','," + Session["hyuid"].ToString() + ",',',') "; } if (Session["conntype"].ToString() == "ORACLE") { //edited by xf 20140625 sql = "insert into hyc_" + this.hy_tableid.Text + " (DOCID,hy_mudelid,hy_tableid,hy_flowid,hy_flowname,hy_curtacheid,hy_curtachename,hy_curclrid,hy_curclrname,hy_djrid,hy_djrname,hy_djrbmid,hy_djrbmname,hy_djsj,hy_bt,hy_readuserlist,hy_readdatelist,hy_clrylist,hy_cyrylist) values ("; sql += "'" + this.txtdocid.Value + "','" + this.hy_mudelid.Text + "','" + this.hy_tableid.Text + "','" + this.hy_flowid.Text + "','" + this.hy_flowname.Text + "'"; sql += ",'" + this.hy_curtacheid.Text + "','" + this.hy_curtachename.Text + "','" + this.hy_curclrid.Text + "','" + this.hy_curclrname.Text + "','" + this.hy_djrid.Text + "'"; sql += ",'" + this.hy_djrname.Text + "','" + this.hy_djrbmid.Text + "','" + this.hy_djrbmname.Text + "',to_date('" + this.hy_djsj.Text + "','YYYY-MM-DD HH24:MI:SS'),'" + this.hy_bt.Text + "'"; sql += ",'','','," + Session["hyuid"].ToString() + ",',',') "; } Hyoa_global.ExcuteSQL(sql); //插入历史处理表 Hyoa_global.Saveflowhistoryinfo_cl_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.hy_curtacheid.Text, this.hy_curtachename.Text, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "", "", "", this.hy_djsj.Text, ""); } #endregion //更新内容 sql = "update hyc_" + this.hy_tableid.Text + " set hy_tableid='" + hy_tableid.Text + "',hy_bt='" + hy_bt.Text + "' "; #region 根据“需要保存的字段”来进行保存 if (txtsavefields.Text != "") { string[] lv_savefields = txtsavefields.Text.Split(','); string[] lv_savefields_sx = txtsavefields_sx.Text.Split(','); string fielddocvalue = ""; for (int i = 0; i < lv_savefields.Length; i++) { if (lv_savefields_sx[i].ToString() == "0") //文本 { if (this.Request.Form[lv_savefields[i].ToString()] != null) { fielddocvalue = this.Request.Form[lv_savefields[i].ToString()].ToString(); fielddocvalue = ReplaceString_Tszf(fielddocvalue); sql += ",hyc_" + lv_savefields[i].ToString() + "='" + fielddocvalue + "'"; } } if (lv_savefields_sx[i].ToString() == "1") //日期 { if (this.Request.Form[lv_savefields[i].ToString()] != null) { fielddocvalue = this.Request.Form[lv_savefields[i].ToString()].ToString(); if (Session["conntype"].ToString() == "SQL") { if (fielddocvalue == "") sql += ",hyc_" + lv_savefields[i].ToString() + "=null"; else sql += ",hyc_" + lv_savefields[i].ToString() + "='" + fielddocvalue + "'"; } if (Session["conntype"].ToString() == "ORACLE") { if (fielddocvalue == "") sql += ",hyc_" + lv_savefields[i].ToString() + "=null"; else sql += ",hyc_" + lv_savefields[i].ToString() + "=to_date('" + fielddocvalue + "','YYYY-MM-DD HH24:MI:SS')"; } } } if (lv_savefields_sx[i].ToString() == "3") //数值 { if (this.Request.Form[lv_savefields[i].ToString()] != null) { fielddocvalue = this.Request.Form[lv_savefields[i].ToString()].ToString(); if (fielddocvalue == "") sql += ",hyc_" + lv_savefields[i].ToString() + "=0"; else sql += ",hyc_" + lv_savefields[i].ToString() + "=" + fielddocvalue; } } if (lv_savefields_sx[i].ToString() == "5") //口令 { if (this.Request.Form[lv_savefields[i].ToString()] != null) { fielddocvalue = this.Request.Form[lv_savefields[i].ToString()].ToString(); fielddocvalue = ReplaceString_Tszf(fielddocvalue); sql += ",hyc_" + lv_savefields[i].ToString() + "='" + fielddocvalue + "'"; } } if (lv_savefields_sx[i].ToString() == "6") //编辑器 { if (this.Request.Form[lv_savefields[i].ToString()] != null) { fielddocvalue = this.Request.Form[lv_savefields[i].ToString()].ToString(); fielddocvalue = ReplaceString_Tszf(fielddocvalue); sql += ",hyc_" + lv_savefields[i].ToString() + "='" + fielddocvalue + "'"; } } if (lv_savefields_sx[i].ToString() == "7") //复选框 { string s = ""; CheckBoxList txfs = (CheckBoxList)this.FindControl(lv_savefields[i].ToString()); foreach (ListItem li in txfs.Items) { if (li.Selected) { if (li.Selected) s += li.Value + ","; } } s = s.TrimEnd(','); s = ReplaceString_Tszf(s); sql += ",hyc_" + lv_savefields[i].ToString() + "='" + s + "'"; } if (lv_savefields_sx[i].ToString() == "8") //单选框 { string s = ""; RadioButtonList txfs = (RadioButtonList)this.FindControl(lv_savefields[i].ToString()); foreach (ListItem li in txfs.Items) { if (li.Selected) { if (li.Selected) s += li.Value + ","; } } s = s.TrimEnd(','); s = ReplaceString_Tszf(s); sql += ",hyc_" + lv_savefields[i].ToString() + "='" + s + "'"; } if (lv_savefields_sx[i].ToString() == "9") //意见 { if (this.Request.Form[lv_savefields[i].ToString()] != null) { fielddocvalue = this.Request.Form[lv_savefields[i].ToString()].ToString(); fielddocvalue = ReplaceString_Tszf(fielddocvalue); if (fielddocvalue != "") { HyoaClass.Hyoa_yj Hyoa_yj = new HyoaClass.Hyoa_yj(); Hyoa_yj.yjid = Hyoa_global.GetRandom(); Hyoa_yj.hy_tableid = this.hy_tableid.Text; Hyoa_yj.hy_fatherid = this.txtdocid.Value; Hyoa_yj.hy_fieldid = lv_savefields[i].ToString(); Hyoa_yj.hy_yjuserid = Session["hyuid"].ToString(); Hyoa_yj.hy_yjusername = Session["hyuname"].ToString(); Hyoa_yj.hy_yjdeptid = Session["hydeptid"].ToString(); Hyoa_yj.hy_yjdeptname = Session["hydeptname"].ToString(); Hyoa_yj.hy_yjtime = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); Hyoa_yj.hy_yjbody = fielddocvalue; Hyoa_yj.hy_yjip = HttpContext.Current.Request.UserHostAddress; Hyoa_yj.hy_yjifshow = ""; Hyoa_yj.Insert(); } } } } } #endregion #region 保存 if (this.txtwhichoperation.Value == "1") { sql += hylcbctscl(); //特殊处理 } #endregion #region 提交 if (this.txtwhichoperation.Value == "2") { //更新主文档 sql += ",hy_curtacheid='" + this.txtnexttacheid.Value + "'"; sql += ",hy_curtachename='" + this.txtnexttachename.Value + "'"; sql += ",hy_curclrid='" + this.txtnextclrid.Value + "'"; sql += ",hy_curclrname='" + this.txtnextclrname.Value + "'"; //---- 添加当前环节的处理时间 ---- start HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocidtacheid(this.txtdocid.Value, this.hy_curtacheid.Text); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") { Hyoa_flowhistoryinfo_cl.hy_clsj = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } else { Hyoa_flowhistoryinfo_cl.hy_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } Hyoa_flowhistoryinfo_cl.Update(); } //---- 添加当前环节的处理时间 ---- end ////////////////////如果后续环节选择了“结束”,则不需要发待办事宜和短消息 start////////////////////// HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); if (this.txtnexttacheid.Value != "**") { //--- 创建后续处理的处理记录+建立处理人待办事宜 ---- start Hyoa_global.Saveflowhistoryinfo_cl_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.txtnexttacheid.Value, this.txtnexttachename.Value, this.txtnextclrid.Value, this.txtnextclrname.Value, "", this.txtnextcyrid.Value, this.txtnextcyrname.Value, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), ""); //待办事宜、短信、即时消息 string[] lv_dbrid = this.txtnextclrid.Value.Split(new Char[] { ',' }); string[] lv_dbrname = this.txtnextclrname.Value.Split(new Char[] { ',' }); for (var i = 0; i < lv_dbrid.Length; i++) { if (lv_dbrid[i].ToString() != "") { //得到当前用户手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); //得到后续处理人手机号 string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(lv_dbrid[i].ToString()); //给后续处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(this.txtdocid.Value, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1", "待办", this.hy_mudelid.Text, "待办箱", "一般", this.hy_bt.Text, "请办理", 0, this.hy_flowid.Text, this.txtnexttacheid.Value, this.hy_tableid.Text); //给后续处理人发送即时消息(提醒) if (this.txtisSendjstx_clr.Value == "1") { Hyoa_global.Sendjstx_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.hy_mudelid.Text, this.hy_bt.Text, 0, this.hy_tableid.Text); } //给后续处理人发送短信(提醒) if (this.txtisSendsms_clr.Value == "1") { Hyoa_global.Sendsms_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), cb_fsrsjh, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_jsrsjh, this.hy_mudelid.Text, this.hy_bt.Text, 1, "", "", 0, this.hy_tableid.Text); } } } //--- 创建后续处理的处理记录+建立处理人待办事宜 ---- end //--- 创建后续传阅记录+建立待办事宜 ---- start string[] lv_cyrid = this.txtnextcyrid.Value.Split(new Char[] { ',' }); string[] lv_cyrname = this.txtnextcyrname.Value.Split(new Char[] { ',' }); for (var i = 0; i < lv_cyrid.Length; i++) { if (lv_cyrid[i].ToString() != "") { //建立传阅数据 Hyoa_global.Saveflowhistoryinfo_cy_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.txtnexttacheid.Value, this.txtnexttachename.Value, lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), "", System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); //待办事宜、短信、即时消息 //得到当前用户手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); //得到后续传阅人手机号 string cb_cyrsjh = Hyoa_user.GetMobilebyuserid(lv_cyrid[i].ToString()); //给后续处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(this.txtdocid.Value, lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1", "待阅", this.hy_mudelid.Text, "待办箱", "一般", this.hy_bt.Text, "请阅读", 0, this.hy_flowid.Text, this.txtnexttacheid.Value, this.hy_tableid.Text); //给后续处理人发送即时消息(提醒) if (this.txtisSendjstx_cyr.Value == "1") { Hyoa_global.Sendjstx_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), this.hy_mudelid.Text, this.hy_bt.Text, 0, this.hy_tableid.Text); } //给后续处理人发送短信(提醒) if (this.txtisSendsms_cyr.Value == "1") { Hyoa_global.Sendsms_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), cb_fsrsjh, lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), cb_cyrsjh, this.hy_mudelid.Text, this.hy_bt.Text, 1, "", "", 0, this.hy_tableid.Text); } } } //--- 创建后续传阅记录+建立待办事宜 ---- end } ////////////////////如果后续环节选择了“结束”,则不需要发待办事宜和短消息 start////////////////////// //--- 当前处理人的待办事宜转已办 ---- start Hyoa_dbsy.Dbsytoybbydocidtacheiduserid(this.txtdocid.Value, this.hy_curtacheid.Text, this.Session["hyuid"].ToString()); //--- 当前处理人的待办事宜转已办 ---- end ls_tip = "文档已成功发送到[" + this.txtnexttachename.Value + "]环节"; sql += hylcclcylist(); //更新hy_clrylist hy_cyrylist edited by xf 20140625 sql += hylctjtscl();//特殊处理 //调用添加客户名称的方法 if (this.hy_mudelid.Text == "MudelVODfwxy" && this.hy_tableid.Text == "TableVODfwxy" || this.hy_mudelid.Text == "Mudelffpdfwht" && this.hy_tableid.Text == "Tableffpdfwht" || this.hy_mudelid.Text == "Mudeljdhazfwht" && this.hy_tableid.Text == "Tablejdhazfwht" || this.hy_mudelid.Text == "Mudelsyyhfwxy" && this.hy_tableid.Text == "Tablesyyhfwxy" || this.hy_mudelid.Text == "MudelDVBazfwdght" && this.hy_tableid.Text == "TableDVBazfwdght" || this.hy_mudelid.Text == "MudelDVBazfwdght" && this.hy_tableid.Text == "TableDVBazfwdght" || this.hy_mudelid.Text == "Mudeljwdsjsxy" && this.hy_tableid.Text == "Tablejwdsjsxy" || this.hy_mudelid.Text == "Mudeljwdscsxy" && this.hy_tableid.Text == "Tablejwdscsxy" || this.hy_mudelid.Text == "Mudelkdjrht" && this.hy_tableid.Text == "Tablekdjrht" || this.hy_mudelid.Text == "Mudelsjcsfwht" && this.hy_tableid.Text == "Tablesjcsfwht" || this.hy_mudelid.Text == "Mudelsjgdcsfwht" && this.hy_tableid.Text == "Tablesjgdcsfwht" || this.hy_mudelid.Text == "Mudelsjtxyyhzxy" && this.hy_tableid.Text == "Tablesjtxyyhzxy" || this.hy_mudelid.Text == "Mudelzdyht" && this.hy_tableid.Text == "Tablezdyht") { if (this.txtop.Value == "add") { Khdaxx(); } } } #endregion #region 收回 if (this.txtwhichoperation.Value == "3") { //得到上个环节处理人 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value); if (dt_clinfo.Rows.Count > 1) { //删除当前处理人员的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy_sh = new HyoaClass.Hyoa_dbsy(); //edited by xf 20140625 string[] lv_temp = dt_clinfo.Rows[0]["hy_clrid"].ToString().Split(','); for (int xf = 0; xf < lv_temp.Length; xf++) { Hyoa_dbsy_sh.DeleteByDocid_flowid_tacheid_userid(this.txtdocid.Value, dt_clinfo.Rows[0]["hy_flowid"].ToString(), dt_clinfo.Rows[0]["hy_tacheid"].ToString(), lv_temp[xf]); } string ls_lastclrid = dt_clinfo.Rows[1]["hy_clrid"].ToString(); //上个环节处理人ID string ls_lastclrname = dt_clinfo.Rows[1]["hy_clrname"].ToString(); //上个环节处理人中文名 string ls_lastcldoc = dt_clinfo.Rows[1]["ID"].ToString(); //上个环节处理的记录ID string ls_lasttacheid = dt_clinfo.Rows[1]["hy_tacheid"].ToString(); //上个环节处理环节ID string ls_lasttachename = dt_clinfo.Rows[1]["hy_tachename"].ToString(); //上个环节处理环节名称 string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID dt_clinfo.Clear(); //删除当前处理的记录 Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.Delete(); //清空上个环节处理时间,更新创建时间 Hyoa_flowhistoryinfo_cl.ID = ls_lastcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ""; Hyoa_flowhistoryinfo_cl.hy_createtime = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); Hyoa_flowhistoryinfo_cl.Update_sh(); //更新主文档中的当前环节ID、当前环节名称、当前处理人ID和中文名 sql += ",hy_curtacheid='" + ls_lasttacheid + "'"; sql += ",hy_curtachename='" + ls_lasttachename + "'"; sql += ",hy_curclrid='" + ls_lastclrid + "'"; sql += ",hy_curclrname='" + ls_lastclrname + "'"; ls_tip = "文档已成功收回到[" + ls_lasttachename + "]环节"; sql += hylcclcylist(); //更新hy_clrylist hy_cyrylist edited by xf 20140625 sql += hylcshtscl();//特殊处理 } } #endregion #region 退回 if (this.txtwhichoperation.Value == "4") { //更新主文档 sql += ",hy_curtacheid='" + this.txtnexttacheid.Value + "'"; sql += ",hy_curtachename='" + this.txtnexttachename.Value + "'"; sql += ",hy_curclrid='" + this.txtnextclrid.Value + "'"; sql += ",hy_curclrname='" + this.txtnextclrname.Value + "'"; //处理历史处理记录 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID string ls_clsj = ""; //当前处理的记录处理时间 if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") ls_clsj = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); else ls_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); dt_clinfo.Clear(); Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ls_clsj; Hyoa_flowhistoryinfo_cl.Update(); } //新建一条处理记录 Hyoa_global.Saveflowhistoryinfo_cl_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.txtnexttacheid.Value, this.txtnexttachename.Value, this.txtnextclrid.Value, this.txtnextclrname.Value, "", "", "", System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "是"); //处理待办事宜 //转已办-当前处理人的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy.Dbsytoybbydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); //得到发送人手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); //(考虑多人的情况) string[] lv_dbrid = this.txtnextclrid.Value.Split(new Char[] { ',' }); string[] lv_dbrname = this.txtnextclrname.Value.Split(new Char[] { ',' }); for (var i = 0; i < lv_dbrid.Length; i++) { if (lv_dbrid[i].ToString() != "") { //得到接收人手机号 string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(lv_dbrid[i].ToString()); HyoaClass.Hyoa_global Hyoa_global2 = new HyoaClass.Hyoa_global(); //给退回到的处理人发送一个新的待办事宜(提醒) Hyoa_global2.Senddbsy_global(this.txtdocid.Value, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1", "待办", this.hy_mudelid.Text, "待办箱", "一般", this.hy_bt.Text, "请办理", 0, this.hy_flowid.Text, this.txtnexttacheid.Value, this.hy_tableid.Text); //给退回到的处理人发送即时消息(提醒) if (this.txtisSendjstx.Value == "1") { Hyoa_global.Sendjstx_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.hy_mudelid.Text, this.hy_bt.Text, 0, this.hy_tableid.Text); } //给退回到的处理人发送短信(提醒) if (this.txtisSendsms.Value == "1") { Hyoa_global.Sendsms_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), cb_fsrsjh, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_jsrsjh, this.hy_mudelid.Text, this.hy_bt.Text, 1, "", "", 0, this.hy_tableid.Text); } } } ls_tip = "已成功退回到[" + this.txtnexttachename.Value + "]环节"; sql += hylcthtscl();//特殊处理 } #endregion #region 多人处理 if (this.txtwhichoperation.Value == "5") { //更新主文档 string ls_newclrid = Hyoa_global.MoveOneString_dh(this.hy_curclrid.Text, this.Session["hyuid"].ToString()); string ls_newclrname = Hyoa_global.MoveOneString_dh(this.hy_curclrname.Text, this.Session["hyuname"].ToString()); sql += ",hy_curclrid='" + ls_newclrid + "'"; sql += ",hy_curclrname='" + ls_newclrname + "'"; //处理当前记录 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = new DataTable(); dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID string ls_clsj = ""; //当前处理的记录处理时间 if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") ls_clsj = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); else ls_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); dt_clinfo.Clear(); Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ls_clsj; Hyoa_flowhistoryinfo_cl.Update(); } //处理待办事宜 //转已办-当前处理人的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy.Dbsytoybbydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); ls_tip = "提交成功,当前环节还需要[" + ls_newclrname + "]进行办理"; sql += hylcdrcltscl();//特殊处理 } #endregion #region 催办 if (this.txtwhichoperation.Value == "6") { string cb_docid = this.txtdocid.Value; string cb_dbrid = this.hy_curclrid.Text; string cb_dbrname = this.hy_curclrname.Text; string cb_fsrid = this.Session["hyuid"].ToString(); string cb_fsrname = this.Session["hyuname"].ToString(); string cb_url = "main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1"; string cb_property = "催办"; string cb_mudelid = this.hy_mudelid.Text; string cb_foldername = "待办箱"; string cb_hj = "一般"; string cb_bt = this.txtcbideas.Value + "-" + this.hy_bt.Text; string cb_subbt = "请阅读"; float cb_ifyb = 0; string cb_flowid = this.hy_flowid.Text; string cb_tacheid = this.hy_curtacheid.Text; string cb_from = this.hy_mudelid.Text; //得到发送人手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(cb_fsrid); //得到接收人手机号 string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(cb_dbrid); //给当前处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(cb_docid, cb_dbrid, cb_dbrname, cb_fsrid, cb_fsrname, cb_url, cb_property, cb_mudelid, cb_foldername, cb_hj, cb_bt, cb_subbt, cb_ifyb, cb_flowid, cb_tacheid, this.hy_tableid.Text); //给当前处理人发送即时消息(提醒) if (this.txtisSendjstx.Value == "1") { Hyoa_global.Sendjstx_global(cb_docid, cb_fsrid, cb_fsrname, cb_dbrid, cb_dbrname, cb_from, cb_bt, 0, this.hy_tableid.Text); } //给当前处理人发送短信(提醒) if (this.txtisSendsms.Value == "1") { Hyoa_global.Sendsms_global(cb_docid, cb_fsrid, cb_fsrname, cb_fsrsjh, cb_dbrid, cb_dbrname, cb_jsrsjh, cb_from, cb_bt, 1, "", "", 0, this.hy_tableid.Text); } ls_tip = "催办成功!"; sql += hylccbtscl();//特殊处理 } #endregion #region 流程结束时的提交 if (this.txtwhichoperation.Value == "7") { //更新主文档 sql += ",hy_curtacheid='**'"; sql += ",hy_curtachename='结束'"; sql += ",hy_curclrid=''"; sql += ",hy_curclrname=''"; //更新处理表 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID string ls_clsj = ""; //当前处理的记录处理时间 if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") ls_clsj = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); else ls_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); dt_clinfo.Clear(); Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ls_clsj; Hyoa_flowhistoryinfo_cl.Update(); //开票流程中开票在流程结束时付款处理。 if (this.hy_tableid.Text == "Tablefpbd") { htfk(); } } ////流程结束时删除所有该文档对应的待办事宜 //HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); //Hyoa_dbsy.Deletebydocid(this.txtdocid.Value); //处理待办事宜 //转已办-当前处理人的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy.Dbsytoybbydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); ls_tip = "流程结束!"; sql += hylcjstscl();//特殊处理 } #endregion #region 收文阅件分发 if (this.txtwhichoperation.Value == "8") { string cb_docid = this.txtdocid.Value; string cb_dbrid = this.hy_curclrid.Text; string cb_dbrname = this.hy_curclrname.Text; string cb_fsrid = this.Session["hyuid"].ToString(); string cb_fsrname = this.Session["hyuname"].ToString(); string cb_url = "main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1"; string cb_property = "待阅"; string cb_mudelid = this.hy_mudelid.Text; string cb_foldername = "待办箱"; string cb_hj = "一般"; string cb_bt = this.hy_bt.Text; string cb_subbt = "请阅读"; float cb_ifyb = 0; string cb_flowid = this.hy_flowid.Text; string cb_tacheid = this.hy_curtacheid.Text; string cb_from = this.hy_mudelid.Text; string[] lv_dbrid = this.txtswly_dbsy_userids.Text.Split(new Char[] { '+' }); string[] lv_dbrname = this.txtswly_dbsy_usernames.Text.Split(new Char[] { '+' }); for (var i = 0; i < lv_dbrid.Length; i++) { if (lv_dbrid[i].ToString() != "") { //得到当前用户手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); //得到后续处理人手机号 string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(lv_dbrid[i].ToString()); //给后续处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(cb_docid, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_fsrid, cb_fsrname, cb_url, cb_property, cb_mudelid, cb_foldername, cb_hj, cb_bt, cb_subbt, 0, cb_flowid, cb_tacheid, this.hy_tableid.Text); //给后续处理人发送即时消息(提醒) Hyoa_global.Sendjstx_global(cb_docid, cb_fsrid, cb_fsrname, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_mudelid, cb_bt, 0, this.hy_tableid.Text); //给后续处理人发送短信(提醒) Hyoa_global.Sendsms_global(cb_docid, cb_fsrid, cb_fsrname, cb_fsrsjh, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_jsrsjh, cb_mudelid, cb_bt, 1, "", "", 0, this.hy_tableid.Text); //在hyp_flowhistoryinfo_cy中添加传阅信息 string sql_cy = "select * from hyp_flowhistoryinfo_cy where DOCID='" + this.txtdocid.Value + "' and hy_cyrid='" + lv_dbrid[i] + "' order by hy_createtime DESC "; DataTable dt_cy = Hyoa_global.GetDataTable(sql_cy); if (dt_cy.Rows.Count > 0) { } else { HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy(); Hyoa_flowhistoryinfo_cy.ID = Hyoa_global.GetRandom(); Hyoa_flowhistoryinfo_cy.DOCID = this.txtdocid.Value; Hyoa_flowhistoryinfo_cy.hy_flowid = this.hy_flowid.Text; Hyoa_flowhistoryinfo_cy.hy_flowname = this.hy_flowname.Text; Hyoa_flowhistoryinfo_cy.hy_tacheid = this.hy_curtacheid.Text; Hyoa_flowhistoryinfo_cy.hy_tachename = this.hy_curtachename.Text; Hyoa_flowhistoryinfo_cy.hy_cyrid = lv_dbrid[i]; Hyoa_flowhistoryinfo_cy.hy_cyrname = lv_dbrname[i]; Hyoa_flowhistoryinfo_cy.hy_ydsj = ""; Hyoa_flowhistoryinfo_cy.hy_createtime = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); Hyoa_flowhistoryinfo_cy.Insert(); } } } //在当前环节处理的记录中添加传阅信息,主要用于列表的显示控制 string sql_cl = "select * from hyp_flowhistoryinfo_cl where DOCID='" + this.txtdocid.Value + "' order by hy_createtime DESC "; DataTable dt_cl = Hyoa_global.GetDataTable(sql_cl); if (dt_cl.Rows.Count > 0) { if (dt_cl.Rows[0]["hy_cyrid"].ToString() == "") { sql_cl = "update hyp_flowhistoryinfo_cl set hy_cyrid='" + this.txtswly_dbsy_userids.Text.Replace("+", ",") + "',hy_cyrname='" + this.txtswly_dbsy_usernames.Text.Replace("+", ",") + "' where ID='" + dt_cl.Rows[0]["ID"].ToString() + "'"; Hyoa_global.ExcuteSQL(sql_cl); } else { if (Session["conntype"].ToString() == "SQL") { sql_cl = "update hyp_flowhistoryinfo_cl set hy_cyrid=hy_cyrid+'," + this.txtswly_dbsy_userids.Text.Replace("+", ",") + "',hy_cyrname=hy_cyrname+'," + this.txtswly_dbsy_usernames.Text.Replace("+", ",") + "' where ID='" + dt_cl.Rows[0]["ID"].ToString() + "'"; } if (Session["conntype"].ToString() == "ORACLE") { sql_cl = "update hyp_flowhistoryinfo_cl set hy_cyrid=CONCAT(hy_cyrid,'," + this.txtswly_dbsy_userids.Text.Replace("+", ",") + "'),hy_cyrname=CONCAT(hy_cyrname,'," + this.txtswly_dbsy_usernames.Text.Replace("+", ",") + ")' where ID='" + dt_cl.Rows[0]["ID"].ToString() + "'"; } Hyoa_global.ExcuteSQL(sql_cl); } } ls_tip = "阅件分发成功!"; sql += hylcclcylist(); //更新hy_clrylist hy_cyrylist edited by xf 20140625 } #endregion //20140809 hjadd start #region 收发文分发 if (this.txtwhichoperation.Value == "11") { string cb_docid = this.txtdocid.Value; string cb_dbrid = this.hy_curclrid.Text; string cb_dbrname = this.hy_curclrname.Text; string cb_fsrid = this.Session["hyuid"].ToString(); string cb_fsrname = this.Session["hyuname"].ToString(); string cb_url = "main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1"; string cb_property = "待阅"; string cb_mudelid = this.hy_mudelid.Text; string cb_foldername = "待办箱"; string cb_hj = "一般"; string cb_bt = this.hy_bt.Text; string cb_subbt = "请阅读"; float cb_ifyb = 0; string cb_flowid = this.hy_flowid.Text; string cb_tacheid = this.hy_curtacheid.Text; string cb_from = this.hy_mudelid.Text; string[] lv_dbrid = this.txtffly_dbsy_userids.Text.Split(new Char[] { '+' }); string[] lv_dbrname = this.txtffly_dbsy_usernames.Text.Split(new Char[] { '+' }); for (var i = 0; i < lv_dbrid.Length; i++) { if (lv_dbrid[i].ToString() != "") { //得到当前用户手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); //得到后续处理人手机号 string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(lv_dbrid[i].ToString()); //给后续处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(cb_docid, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_fsrid, cb_fsrname, cb_url, cb_property, cb_mudelid, cb_foldername, cb_hj, cb_bt, cb_subbt, 0, cb_flowid, cb_tacheid, this.hy_tableid.Text); //给后续处理人发送即时消息(提醒) Hyoa_global.Sendjstx_global(cb_docid, cb_fsrid, cb_fsrname, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_mudelid, cb_bt, 0, this.hy_tableid.Text); //给后续处理人发送短信(提醒) Hyoa_global.Sendsms_global(cb_docid, cb_fsrid, cb_fsrname, cb_fsrsjh, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_jsrsjh, cb_mudelid, cb_bt, 1, "", "", 0, this.hy_tableid.Text); //在hyp_flowhistoryinfo_cy中添加传阅信息 string sql_cy = "select * from hyp_flowhistoryinfo_cy where DOCID='" + this.txtdocid.Value + "' and hy_cyrid='" + lv_dbrid[i] + "' order by hy_createtime DESC "; DataTable dt_cy = Hyoa_global.GetDataTable(sql_cy); if (dt_cy.Rows.Count > 0) { } else { HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy(); Hyoa_flowhistoryinfo_cy.ID = Hyoa_global.GetRandom(); Hyoa_flowhistoryinfo_cy.DOCID = this.txtdocid.Value; Hyoa_flowhistoryinfo_cy.hy_flowid = this.hy_flowid.Text; Hyoa_flowhistoryinfo_cy.hy_flowname = this.hy_flowname.Text; Hyoa_flowhistoryinfo_cy.hy_tacheid = this.hy_curtacheid.Text; Hyoa_flowhistoryinfo_cy.hy_tachename = this.hy_curtachename.Text; Hyoa_flowhistoryinfo_cy.hy_cyrid = lv_dbrid[i]; Hyoa_flowhistoryinfo_cy.hy_cyrname = lv_dbrname[i]; Hyoa_flowhistoryinfo_cy.hy_ydsj = ""; Hyoa_flowhistoryinfo_cy.hy_createtime = System.DateTime.Now.ToString(); Hyoa_flowhistoryinfo_cy.Insert(); } } } ls_tip = "分发成功!"; } #endregion //20140809 hj add end #region 在主表单内嵌列表的功能中,保存、提交和确认子表单时,需要将父文档的DOCID保存到当前记录的hy_motherid中 //ADD BY XF 2011-11-17 if (this.txtwhichoperation.Value == "1" || this.txtwhichoperation.Value == "2" || this.txtwhichoperation.Value == "111") { if (Request.QueryString["op"] != null) { if (Request.QueryString["op"].ToString() != "") { if (Request.QueryString["motherid"] != null) { if (Request.QueryString["motherid"].ToString() != "") { sql += ",hy_motherid='" + Request.QueryString["motherid"].ToString() + "'"; } } } } } #endregion sql += " where DOCID='" + this.txtdocid.Value + "'"; Hyoa_global.ExcuteSQL(sql); #region 处理完成后的提示及跳转(增加刷新附件功能) if (this.txtifsxfj.Text == "1") { Response.Write("<script>window.location='main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&url=" + this.txturl.Value + "'</script>"); } else { if (this.txturl.Value == "2") { Response.Write("<script>alert('" + ls_tip + "');try{window.opener.location.reload();}catch(err){}self.close();parent.location.reload();</script>"); } else if (this.txtifpop.Value == "") { if (this.hy_tableid.Text == "Tablefpbd") { Response.Write("<script>alert('" + ls_tip + "');window.location='list_myadd.aspx?mid=Mudelfp&tableid=Tablefpbd&listid=6b07b57d-2906-4f5b-bc47-a8c7754ea5bf&rnd=afc25663-de8a-43ba-bc48-db224b3e5c92'</script>"); } else { Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>"); } } else { Response.Write("<script>alert('" + ls_tip + "');try{window.opener.location.reload();}catch(err){}self.close();</script>"); } } #endregion }
//流程流程结束时的特殊处理 private string hylcjstscl() { string sql = ""; #region 流程结束给登记人发送提醒start string cb_docid = this.txtdocid.Value; string cb_dbrid = this.hy_djrid.Text; string cb_dbrname = this.hy_djrname.Text; string cb_fsrid = this.Session["hyuid"].ToString(); string cb_fsrname = this.Session["hyuname"].ToString(); string cb_url = "main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1"; string cb_property = "待阅"; string cb_mudelid = this.hy_mudelid.Text; string cb_foldername = "待阅箱"; string cb_hj = "一般"; string cb_bt = this.hy_bt.Text; string cb_subbt = "[流程已结束]"; float cb_ifyb = 0; string cb_flowid = this.hy_flowid.Text; string cb_tacheid = this.hy_curtacheid.Text; string cb_from = this.hy_mudelid.Text; //得到发送人手机号 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); //HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); //string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(cb_fsrid); ////得到接收人手机号 //string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(cb_dbrid); //给当前处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(cb_docid, cb_dbrid, cb_dbrname, cb_fsrid, cb_fsrname, cb_url, cb_property, cb_mudelid, cb_foldername, cb_hj, cb_bt, cb_subbt, cb_ifyb, cb_flowid, cb_tacheid, this.hy_tableid.Text); //给当前处理人发送即时消息(提醒) Hyoa_global.Sendjstx_global(cb_docid, cb_fsrid, cb_fsrname, cb_dbrid, cb_dbrname, cb_from, cb_bt, 0, this.hy_tableid.Text); #endregion 流程结束给登记人发送提醒end return sql; }
//保存 protected void Button_Save_Click(object sender, EventArgs e) { if (this.Session["hyuid"].ToString() == "") this.Response.Redirect("../login.aspx"); string ls_tip = "发送成功!"; HyoaClass.Hyoa_wjcd Hyoa_wjcd = new HyoaClass.Hyoa_wjcd(); HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); string ls_insert = ""; string ls_update = ""; //取提醒方式 string ls_txfs = ""; CheckBoxList txfs = (CheckBoxList)this.FindControl("txfs"); foreach (ListItem li in txfs.Items) { if (li.Selected) { if (li.Selected) ls_txfs += li.Value + ","; } } ls_txfs = ls_txfs.TrimEnd(','); //发送 if (this.txtwhichoperation.Value == "1") { string[] lv_jsrid = this.txthy_jsrid.Text.Split('+'); string[] lv_jsrname = this.txthy_jsrname.Value.Split('+'); for (var i = 0; i < lv_jsrid.Length; i++) { if (lv_jsrid[i] != "") { string ls_id = Hyoa_global.GetRandom(); ls_insert = "insert into hyp_wjcd (ID,DOCID,hy_type,hy_foldername,hy_fsrid,hy_fsrname,hy_jsrid,hy_jsrname"; ls_insert += ",hy_title,hy_body,hy_datetime,hy_ifsavetofjx,hy_yxj,hy_yjbg,hy_zycd,hy_hz,hy_status,hy_jzsj"; ls_insert += ",hy_txfs,hy_ifyhf,hy_txstatus) values ('" + ls_id + "','" + this.txtdocid.Value + "','收件','" + this.ddlhy_foldername.Text + "'"; ls_insert += ",'" + this.lblhy_fsrid.Text + "','" + this.lblhy_fsrname.Text + "','" + lv_jsrid[i].ToString() + "'"; ls_insert += ",'" + lv_jsrname[i].ToString() + "','" + this.txthy_title.Text + "','" + this.hy_content1.Value + "'"; ls_insert += ",'" + System.DateTime.Now.ToString() + "','','','','','','已发送','" + this.jzsj.Value + "','" + ls_txfs + "','0','0')"; Hyoa_global.ExcuteSQL(ls_insert); //发送待办事宜提醒 HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); Hyoa_global.Senddbsy_global(ls_id, lv_jsrid[i].ToString(), lv_jsrname[i].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "wjcd/main_read.aspx?id=" + ls_id + "&pop=1", "待阅", "Mudelwjcd", "待办箱", "一般", this.txthy_title.Text, "请阅读", 0, "", "", ""); //发送即时通讯提醒 Hyoa_global.Sendjstx_global(ls_id, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), lv_jsrid[i].ToString(), lv_jsrname[i].ToString(), "Mudelwjcd", this.txthy_title.Text, 0, ""); } } //发送的同时,则保存一份 if (this.txtop.Value == "add") { ls_insert = "insert into hyp_wjcd (ID,DOCID,hy_type,hy_foldername,hy_fsrid,hy_fsrname,hy_jsrid,hy_jsrname"; ls_insert += ",hy_title,hy_body,hy_datetime,hy_ifsavetofjx,hy_yxj,hy_yjbg,hy_zycd,hy_hz,hy_status,hy_jzsj"; ls_insert += ",hy_txfs,hy_ifyhf,hy_txstatus) values ('" + Hyoa_global.GetRandom() + "','" + this.txtdocid.Value + "','发件','" + this.ddlhy_foldername.Text + "'"; ls_insert += ",'" + this.lblhy_fsrid.Text + "','" + this.lblhy_fsrname.Text + "','" + this.txthy_jsrid.Text + "'"; ls_insert += ",'" + this.txthy_jsrname.Value + "','" + this.txthy_title.Text + "','" + this.hy_content1.Value + "'"; ls_insert += ",'" + System.DateTime.Now.ToString() + "','" + this.ddlifsavetofjx.SelectedValue + "','','','',''"; ls_insert += ",'已发送','" + this.jzsj.Value + "','" + ls_txfs + "','0','0')"; Hyoa_global.ExcuteSQL(ls_insert); } else { string ls_id = this.txtid.Value; Hyoa_wjcd.ID = ls_id; this.txtid.Value = ls_id; ls_update = "update hyp_wjcd set DOCID='" + this.txtdocid.Value + "',hy_type='发件',hy_foldername='" + this.ddlhy_foldername.Text + "'"; ls_update += ",hy_fsrid='" + this.lblhy_fsrid.Text + "',hy_fsrname='" + this.lblhy_fsrname.Text + "',hy_jsrid='" + this.txthy_jsrid.Text + "'"; ls_update += ",hy_jsrname='" + this.txthy_jsrname.Value + "',hy_title='" + this.txthy_title.Text + "',hy_body='" + this.hy_content1.Value + "'"; ls_update += ",hy_datetime='" + System.DateTime.Now.ToString() + "',hy_ifsavetofjx='" + this.ddlifsavetofjx.SelectedValue + "',hy_status='已发送'"; ls_update += ",hy_jzsj='" + this.jzsj.Value + "',hy_txfs='" + ls_txfs + "' where ID= '" + ls_id + "' "; Hyoa_global.ExcuteSQL(ls_update); ls_tip = "保存成功!"; } this.txturl.Value = "list_wjcd_yfs.aspx?mid=" + this.txtmudelid.Value + "&tableid="; //返回URL } //保存 if (this.txtwhichoperation.Value == "2") { if (this.txtop.Value == "add") { string ls_id = this.txtdocid.Value; Hyoa_wjcd.ID = ls_id; this.txtid.Value = ls_id; Hyoa_wjcd.DOCID = this.txtdocid.Value; Hyoa_wjcd.hy_type = "发件"; Hyoa_wjcd.hy_foldername = this.ddlhy_foldername.Text; Hyoa_wjcd.hy_fsrid = this.lblhy_fsrid.Text; Hyoa_wjcd.hy_fsrname = this.lblhy_fsrname.Text; Hyoa_wjcd.hy_jsrid = this.txthy_jsrid.Text; Hyoa_wjcd.hy_jsrname = this.txthy_jsrname.Value; Hyoa_wjcd.hy_title = this.txthy_title.Text; Hyoa_wjcd.hy_body = this.hy_content1.Value; Hyoa_wjcd.hy_datetime = System.DateTime.Now.ToString(); Hyoa_wjcd.hy_ifsavetofjx = this.ddlifsavetofjx.SelectedValue; Hyoa_wjcd.hy_yxj = ""; Hyoa_wjcd.hy_yjbg = ""; Hyoa_wjcd.hy_zycd = ""; Hyoa_wjcd.hy_hz = ""; Hyoa_wjcd.hy_status = "未发送"; Hyoa_wjcd.Insert(); ls_tip = "保存成功!"; } else { string ls_id = this.txtid.Value; Hyoa_wjcd.ID = ls_id; this.txtid.Value = ls_id; Hyoa_wjcd.DOCID = this.txtdocid.Value; Hyoa_wjcd.hy_type = "发件"; Hyoa_wjcd.hy_foldername = this.ddlhy_foldername.Text; Hyoa_wjcd.hy_fsrid = this.lblhy_fsrid.Text; Hyoa_wjcd.hy_fsrname = this.lblhy_fsrname.Text; Hyoa_wjcd.hy_jsrid = this.txthy_jsrid.Text; Hyoa_wjcd.hy_jsrname = this.txthy_jsrname.Value; Hyoa_wjcd.hy_title = this.txthy_title.Text; Hyoa_wjcd.hy_body = this.hy_content1.Value; Hyoa_wjcd.hy_datetime = System.DateTime.Now.ToString(); Hyoa_wjcd.hy_ifsavetofjx = this.ddlifsavetofjx.SelectedValue; Hyoa_wjcd.hy_yxj = ""; Hyoa_wjcd.hy_yjbg = ""; Hyoa_wjcd.hy_zycd = ""; Hyoa_wjcd.hy_hz = ""; Hyoa_wjcd.hy_status = "未发送"; Hyoa_wjcd.Update(); ls_tip = "保存成功!"; } this.txturl.Value = "list_wjcd_wfs.aspx?mid=" + this.txtmudelid.Value + "&tableid="; //返回URL } //处理完成后的提示及跳转(增加刷新附件功能) if (this.txtifsxfj.Text == "1") { Response.Write("<script>window.location='main_wjcd.aspx?op=modify&mid=" + this.txtmudelid.Value + "&id=" + this.txtid.Value + "&url=" + this.txturl.Value + "'</script>"); } else { Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>"); } }
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //保存 protected void Button_Save_Click(object sender, EventArgs e) { if (this.Session["hyuid"].ToString() == "") this.Response.Redirect("/login.aspx"); string ls_tip = "保存成功!"; //新文档时 //新建时先进行一次保存 HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain(); if (this.txtop.Value == "add") { #region 字段信息 Hyoa_flowmain.DOCID = this.txtdocid.Value; Hyoa_flowmain.hy_mudelid = this.hy_mudelid.Text; Hyoa_flowmain.hy_tableid = this.hy_tableid.Text; Hyoa_flowmain.hy_flowid = this.hy_flowid.Text; Hyoa_flowmain.hy_flowname = this.hy_flowname.Text; Hyoa_flowmain.hy_curtacheid = this.hy_curtacheid.Text; Hyoa_flowmain.hy_curtachename = this.hy_curtachename.Text; Hyoa_flowmain.hy_curclrid = this.hy_curclrid.Text; Hyoa_flowmain.hy_curclrname = this.hy_curclrname.Text; Hyoa_flowmain.hy_djrid = this.hy_djrid.Text; Hyoa_flowmain.hy_djrname = this.hy_djrname.Text; Hyoa_flowmain.hy_djrbmid = this.hy_djrbmid.Text; Hyoa_flowmain.hy_djrbmname = this.hy_djrbmname.Text; Hyoa_flowmain.hy_djsj = this.hy_djsj.Text; Hyoa_flowmain.hy_bt = this.hy_bt.Text; Hyoa_flowmain.hy_content1 = this.hy_content1.Text; Hyoa_flowmain.hy_content2 = this.hy_content2.Text; Hyoa_flowmain.hy_content3 = this.hy_content3.Text; Hyoa_flowmain.hy_content4 = this.hy_content4.Text; Hyoa_flowmain.hy_content5 = this.hy_content5.Text; Hyoa_flowmain.hy_content6 = this.hy_content6.Text; Hyoa_flowmain.hy_content7 = this.hy_content7.Text; Hyoa_flowmain.hy_content8 = this.hy_content8.Text; Hyoa_flowmain.hy_content9 = this.hy_content9.Text; Hyoa_flowmain.hy_content10 = this.hy_content10.Text; Hyoa_flowmain.hy_content11 = this.hy_content11.Text; Hyoa_flowmain.hy_content12 = this.hy_content12.Text; Hyoa_flowmain.hy_content13 = this.hy_content13.Text; Hyoa_flowmain.hy_content14 = this.hy_content14.Text; Hyoa_flowmain.hy_content15 = this.hy_content15.Text; Hyoa_flowmain.hy_field1 = this.hy_field1.Text; Hyoa_flowmain.hy_field2 = this.hy_field2.Text; Hyoa_flowmain.hy_field3 = this.hy_field3.Text; Hyoa_flowmain.hy_field4 = this.hy_field4.Text; Hyoa_flowmain.hy_field5 = this.hy_field5.Text; Hyoa_flowmain.hy_field6 = this.hy_field6.Text; Hyoa_flowmain.hy_field7 = this.hy_field7.Text; Hyoa_flowmain.hy_field8 = this.hy_field8.Text; Hyoa_flowmain.hy_field9 = this.hy_field9.Text; Hyoa_flowmain.hy_field10 = this.hy_field10.Text; Hyoa_flowmain.hy_field11 = this.hy_field11.Text; Hyoa_flowmain.hy_field12 = this.hy_field12.Text; Hyoa_flowmain.hy_field13 = this.hy_field13.Text; Hyoa_flowmain.hy_field14 = this.hy_field14.Text; Hyoa_flowmain.hy_field15 = this.hy_field15.Text; Hyoa_flowmain.hy_field16 = this.hy_field16.Text; Hyoa_flowmain.hy_field17 = this.hy_field17.Text; Hyoa_flowmain.hy_field18 = this.hy_field18.Text; Hyoa_flowmain.hy_field19 = this.hy_field19.Text; Hyoa_flowmain.hy_field20 = this.hy_field20.Text; Hyoa_flowmain.hy_field21 = this.hy_field21.Text; Hyoa_flowmain.hy_field22 = this.hy_field22.Text; Hyoa_flowmain.hy_field23 = this.hy_field23.Text; Hyoa_flowmain.hy_field24 = this.hy_field24.Text; Hyoa_flowmain.hy_field25 = this.hy_field25.Text; Hyoa_flowmain.hy_field26 = this.hy_field26.Text; Hyoa_flowmain.hy_field27 = this.hy_field27.Text; Hyoa_flowmain.hy_field28 = this.hy_field28.Text; Hyoa_flowmain.hy_field29 = this.hy_field29.Text; Hyoa_flowmain.hy_field30 = this.hy_field30.Text; Hyoa_flowmain.hy_field31 = this.hy_field31.Text; Hyoa_flowmain.hy_field32 = this.hy_field32.Text; Hyoa_flowmain.hy_field33 = this.hy_field33.Text; Hyoa_flowmain.hy_field34 = this.hy_field34.Text; Hyoa_flowmain.hy_field35 = this.hy_field35.Text; if (this.hy_field36.Text == "") Hyoa_flowmain.hy_field36 = 0; else Hyoa_flowmain.hy_field36 = float.Parse(this.hy_field36.Text); if (this.hy_field37.Text == "") Hyoa_flowmain.hy_field37 = 0; else Hyoa_flowmain.hy_field37 = float.Parse(this.hy_field37.Text); if (this.hy_field38.Text == "") Hyoa_flowmain.hy_field38 = 0; else Hyoa_flowmain.hy_field38 = float.Parse(this.hy_field38.Text); if (this.hy_field39.Text == "") Hyoa_flowmain.hy_field39 = 0; else Hyoa_flowmain.hy_field39 = float.Parse(this.hy_field39.Text); if (this.hy_field40.Text == "") Hyoa_flowmain.hy_field40 = 0; else Hyoa_flowmain.hy_field40 = float.Parse(this.hy_field40.Text); Hyoa_flowmain.hy_field41 = this.hy_field41.Text; Hyoa_flowmain.hy_field42 = this.hy_field42.Text; Hyoa_flowmain.hy_field43 = this.hy_field43.Text; Hyoa_flowmain.hy_field44 = this.hy_field44.Text; Hyoa_flowmain.hy_field45 = this.hy_field45.Text; Hyoa_flowmain.hy_field46 = this.hy_field46.Text; Hyoa_flowmain.hy_field47 = this.hy_field47.Text; Hyoa_flowmain.hy_field48 = this.hy_field48.Text; Hyoa_flowmain.hy_field49 = this.hy_field49.Text; Hyoa_flowmain.hy_field50 = this.hy_field50.Text; Hyoa_flowmain.hy_field51 = this.hy_field51.Text; Hyoa_flowmain.hy_field52 = this.hy_field52.Text; Hyoa_flowmain.hy_field53 = this.hy_field53.Text; Hyoa_flowmain.hy_field54 = this.hy_field54.Text; Hyoa_flowmain.hy_field55 = this.hy_field55.Text; Hyoa_flowmain.hy_field56 = this.hy_field56.Text; Hyoa_flowmain.hy_field57 = this.hy_field57.Text; Hyoa_flowmain.hy_field58 = this.hy_field58.Text; Hyoa_flowmain.hy_field59 = this.hy_field59.Text; Hyoa_flowmain.hy_field60 = this.hy_field60.Text; Hyoa_flowmain.hy_field61 = this.hy_field61.Text; Hyoa_flowmain.hy_field62 = this.hy_field62.Text; Hyoa_flowmain.hy_field63 = this.hy_field63.Text; Hyoa_flowmain.hy_field64 = this.hy_field64.Text; Hyoa_flowmain.hy_field65 = this.hy_field65.Text; Hyoa_flowmain.hy_field66 = this.hy_field66.Text; Hyoa_flowmain.hy_field67 = this.hy_field67.Text; Hyoa_flowmain.hy_field68 = this.hy_field68.Text; Hyoa_flowmain.hy_field69 = this.hy_field69.Text; Hyoa_flowmain.hy_field70 = this.hy_field70.Text; if (this.hy_field71.Text == "") Hyoa_flowmain.hy_field71 = 0; else Hyoa_flowmain.hy_field71 = float.Parse(this.hy_field71.Text); if (this.hy_field72.Text == "") Hyoa_flowmain.hy_field72 = 0; else Hyoa_flowmain.hy_field72 = float.Parse(this.hy_field72.Text); if (this.hy_field73.Text == "") Hyoa_flowmain.hy_field73 = 0; else Hyoa_flowmain.hy_field73 = float.Parse(this.hy_field73.Text); if (this.hy_field74.Text == "") Hyoa_flowmain.hy_field74 = 0; else Hyoa_flowmain.hy_field74 = float.Parse(this.hy_field74.Text); if (this.hy_field75.Text == "") Hyoa_flowmain.hy_field75 = 0; else Hyoa_flowmain.hy_field75 = float.Parse(this.hy_field75.Text); if (this.hy_field76.Text == "") Hyoa_flowmain.hy_field76 = 0; else Hyoa_flowmain.hy_field76 = float.Parse(this.hy_field76.Text); if (this.hy_field77.Text == "") Hyoa_flowmain.hy_field77 = 0; else Hyoa_flowmain.hy_field77 = float.Parse(this.hy_field77.Text); if (this.hy_field78.Text == "") Hyoa_flowmain.hy_field78 = 0; else Hyoa_flowmain.hy_field78 = float.Parse(this.hy_field78.Text); if (this.hy_field79.Text == "") Hyoa_flowmain.hy_field79 = 0; else Hyoa_flowmain.hy_field79 = float.Parse(this.hy_field79.Text); if (this.hy_field80.Text == "") Hyoa_flowmain.hy_field80 = 0; else Hyoa_flowmain.hy_field80 = float.Parse(this.hy_field80.Text); if (this.hy_field81.Text == "") Hyoa_flowmain.hy_field81 = 0; else Hyoa_flowmain.hy_field81 = float.Parse(this.hy_field81.Text); if (this.hy_field82.Text == "") Hyoa_flowmain.hy_field82 = 0; else Hyoa_flowmain.hy_field82 = float.Parse(this.hy_field82.Text); if (this.hy_field83.Text == "") Hyoa_flowmain.hy_field83 = 0; else Hyoa_flowmain.hy_field83 = float.Parse(this.hy_field83.Text); if (this.hy_field84.Text == "") Hyoa_flowmain.hy_field84 = 0; else Hyoa_flowmain.hy_field84 = float.Parse(this.hy_field84.Text); if (this.hy_field85.Text == "") Hyoa_flowmain.hy_field85 = 0; else Hyoa_flowmain.hy_field85 = float.Parse(this.hy_field85.Text); if (this.hy_field86.Text == "") Hyoa_flowmain.hy_field86 = 0; else Hyoa_flowmain.hy_field86 = float.Parse(this.hy_field86.Text); if (this.hy_field87.Text == "") Hyoa_flowmain.hy_field87 = 0; else Hyoa_flowmain.hy_field87 = float.Parse(this.hy_field87.Text); if (this.hy_field88.Text == "") Hyoa_flowmain.hy_field88 = 0; else Hyoa_flowmain.hy_field88 = float.Parse(this.hy_field88.Text); if (this.hy_field89.Text == "") Hyoa_flowmain.hy_field89 = 0; else Hyoa_flowmain.hy_field89 = float.Parse(this.hy_field89.Text); if (this.hy_field90.Text == "") Hyoa_flowmain.hy_field90 = 0; else Hyoa_flowmain.hy_field90 = float.Parse(this.hy_field90.Text); if (this.hy_field91.Text == "") Hyoa_flowmain.hy_field91 = 0; else Hyoa_flowmain.hy_field91 = float.Parse(this.hy_field91.Text); if (this.hy_field92.Text == "") Hyoa_flowmain.hy_field92 = 0; else Hyoa_flowmain.hy_field92 = float.Parse(this.hy_field92.Text); if (this.hy_field93.Text == "") Hyoa_flowmain.hy_field93 = 0; else Hyoa_flowmain.hy_field93 = float.Parse(this.hy_field93.Text); if (this.hy_field94.Text == "") Hyoa_flowmain.hy_field94 = 0; else Hyoa_flowmain.hy_field94 = float.Parse(this.hy_field94.Text); if (this.hy_field95.Text == "") Hyoa_flowmain.hy_field95 = 0; else Hyoa_flowmain.hy_field95 = float.Parse(this.hy_field95.Text); if (this.hy_field96.Text == "") Hyoa_flowmain.hy_field96 = 0; else Hyoa_flowmain.hy_field96 = float.Parse(this.hy_field96.Text); if (this.hy_field97.Text == "") Hyoa_flowmain.hy_field97 = 0; else Hyoa_flowmain.hy_field97 = float.Parse(this.hy_field97.Text); if (this.hy_field98.Text == "") Hyoa_flowmain.hy_field98 = 0; else Hyoa_flowmain.hy_field98 = float.Parse(this.hy_field98.Text); if (this.hy_field99.Text == "") Hyoa_flowmain.hy_field99 = 0; else Hyoa_flowmain.hy_field99 = float.Parse(this.hy_field99.Text); if (this.hy_field100.Text == "") Hyoa_flowmain.hy_field100 = 0; else Hyoa_flowmain.hy_field100 = float.Parse(this.hy_field100.Text); Hyoa_flowmain.hy_iftx = this.hy_iftx.Text; Hyoa_flowmain.hy_zhtxsj = this.hy_zhtxsj.Text; Hyoa_flowmain.hy_readuserlist = this.hy_readuserlist.Text; #endregion Hyoa_flowmain.Insert(); //插入历史处理表 HyoaClass.Hyoa_global Hyoa_global_add = new HyoaClass.Hyoa_global(); Hyoa_global_add.Saveflowhistoryinfo_cl_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.hy_curtacheid.Text, this.hy_curtachename.Text, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "", "", "", this.hy_djsj.Text, ""); } #region 更新内容 Hyoa_flowmain.DOCID = this.txtdocid.Value; Hyoa_flowmain.hy_curtacheid = this.hy_curtacheid.Text; Hyoa_flowmain.hy_curtachename = this.hy_curtachename.Text; Hyoa_flowmain.hy_curclrid = this.hy_curclrid.Text; Hyoa_flowmain.hy_curclrname = this.hy_curclrname.Text; Hyoa_flowmain.hy_bt = this.hy_bt.Text; Hyoa_flowmain.hy_content1 = this.hy_content1.Text; Hyoa_flowmain.hy_content2 = this.hy_content2.Text; Hyoa_flowmain.hy_content3 = this.hy_content3.Text; Hyoa_flowmain.hy_content4 = this.hy_content4.Text; Hyoa_flowmain.hy_content5 = this.hy_content5.Text; Hyoa_flowmain.hy_content6 = this.hy_content6.Text; Hyoa_flowmain.hy_content7 = this.hy_content7.Text; Hyoa_flowmain.hy_content8 = this.hy_content8.Text; Hyoa_flowmain.hy_content9 = this.hy_content9.Text; Hyoa_flowmain.hy_content10 = this.hy_content10.Text; Hyoa_flowmain.hy_content11 = this.hy_content11.Text; Hyoa_flowmain.hy_content12 = this.hy_content12.Text; Hyoa_flowmain.hy_content13 = this.hy_content13.Text; Hyoa_flowmain.hy_content14 = this.hy_content14.Text; Hyoa_flowmain.hy_content15 = this.hy_content15.Text; Hyoa_flowmain.hy_field1 = this.hy_field1.Text; Hyoa_flowmain.hy_field2 = this.hy_field2.Text; Hyoa_flowmain.hy_field3 = this.hy_field3.Text; Hyoa_flowmain.hy_field4 = this.hy_field4.Text; Hyoa_flowmain.hy_field5 = this.hy_field5.Text; Hyoa_flowmain.hy_field6 = this.hy_field6.Text; Hyoa_flowmain.hy_field7 = this.hy_field7.Text; Hyoa_flowmain.hy_field8 = this.hy_field8.Text; Hyoa_flowmain.hy_field9 = this.hy_field9.Text; Hyoa_flowmain.hy_field10 = this.hy_field10.Text; Hyoa_flowmain.hy_field11 = this.hy_field11.Text; Hyoa_flowmain.hy_field12 = this.hy_field12.Text; Hyoa_flowmain.hy_field13 = this.hy_field13.Text; Hyoa_flowmain.hy_field14 = this.hy_field14.Text; Hyoa_flowmain.hy_field15 = this.hy_field15.Text; Hyoa_flowmain.hy_field16 = this.hy_field16.Text; Hyoa_flowmain.hy_field17 = this.hy_field17.Text; Hyoa_flowmain.hy_field18 = this.hy_field18.Text; Hyoa_flowmain.hy_field19 = this.hy_field19.Text; Hyoa_flowmain.hy_field20 = this.hy_field20.Text; Hyoa_flowmain.hy_field21 = this.hy_field21.Text; Hyoa_flowmain.hy_field22 = this.hy_field22.Text; Hyoa_flowmain.hy_field23 = this.hy_field23.Text; Hyoa_flowmain.hy_field24 = this.hy_field24.Text; Hyoa_flowmain.hy_field25 = this.hy_field25.Text; Hyoa_flowmain.hy_field26 = this.hy_field26.Text; Hyoa_flowmain.hy_field27 = this.hy_field27.Text; Hyoa_flowmain.hy_field28 = this.hy_field28.Text; Hyoa_flowmain.hy_field29 = this.hy_field29.Text; Hyoa_flowmain.hy_field30 = this.hy_field30.Text; Hyoa_flowmain.hy_field31 = this.hy_field31.Text; Hyoa_flowmain.hy_field32 = this.hy_field32.Text; Hyoa_flowmain.hy_field33 = this.hy_field33.Text; Hyoa_flowmain.hy_field34 = this.hy_field34.Text; Hyoa_flowmain.hy_field35 = this.hy_field35.Text; if (this.hy_field36.Text == "") Hyoa_flowmain.hy_field36 = 0; else Hyoa_flowmain.hy_field36 = float.Parse(this.hy_field36.Text); if (this.hy_field37.Text == "") Hyoa_flowmain.hy_field37 = 0; else Hyoa_flowmain.hy_field37 = float.Parse(this.hy_field37.Text); if (this.hy_field38.Text == "") Hyoa_flowmain.hy_field38 = 0; else Hyoa_flowmain.hy_field38 = float.Parse(this.hy_field38.Text); if (this.hy_field39.Text == "") Hyoa_flowmain.hy_field39 = 0; else Hyoa_flowmain.hy_field39 = float.Parse(this.hy_field39.Text); if (this.hy_field40.Text == "") Hyoa_flowmain.hy_field40 = 0; else Hyoa_flowmain.hy_field40 = float.Parse(this.hy_field40.Text); Hyoa_flowmain.hy_field41 = this.hy_field41.Text; Hyoa_flowmain.hy_field42 = this.hy_field42.Text; Hyoa_flowmain.hy_field43 = this.hy_field43.Text; Hyoa_flowmain.hy_field44 = this.hy_field44.Text; Hyoa_flowmain.hy_field45 = this.hy_field45.Text; Hyoa_flowmain.hy_field46 = this.hy_field46.Text; Hyoa_flowmain.hy_field47 = this.hy_field47.Text; Hyoa_flowmain.hy_field48 = this.hy_field48.Text; Hyoa_flowmain.hy_field49 = this.hy_field49.Text; Hyoa_flowmain.hy_field50 = this.hy_field50.Text; Hyoa_flowmain.hy_field51 = this.hy_field51.Text; Hyoa_flowmain.hy_field52 = this.hy_field52.Text; Hyoa_flowmain.hy_field53 = this.hy_field53.Text; Hyoa_flowmain.hy_field54 = this.hy_field54.Text; Hyoa_flowmain.hy_field55 = this.hy_field55.Text; Hyoa_flowmain.hy_field56 = this.hy_field56.Text; Hyoa_flowmain.hy_field57 = this.hy_field57.Text; Hyoa_flowmain.hy_field58 = this.hy_field58.Text; Hyoa_flowmain.hy_field59 = this.hy_field59.Text; Hyoa_flowmain.hy_field60 = this.hy_field60.Text; Hyoa_flowmain.hy_field61 = this.hy_field61.Text; Hyoa_flowmain.hy_field62 = this.hy_field62.Text; Hyoa_flowmain.hy_field63 = this.hy_field63.Text; Hyoa_flowmain.hy_field64 = this.hy_field64.Text; Hyoa_flowmain.hy_field65 = this.hy_field65.Text; Hyoa_flowmain.hy_field66 = this.hy_field66.Text; Hyoa_flowmain.hy_field67 = this.hy_field67.Text; Hyoa_flowmain.hy_field68 = this.hy_field68.Text; Hyoa_flowmain.hy_field69 = this.hy_field69.Text; Hyoa_flowmain.hy_field70 = this.hy_field70.Text; if (this.hy_field71.Text == "") Hyoa_flowmain.hy_field71 = 0; else Hyoa_flowmain.hy_field71 = float.Parse(this.hy_field71.Text); if (this.hy_field72.Text == "") Hyoa_flowmain.hy_field72 = 0; else Hyoa_flowmain.hy_field72 = float.Parse(this.hy_field72.Text); if (this.hy_field73.Text == "") Hyoa_flowmain.hy_field73 = 0; else Hyoa_flowmain.hy_field73 = float.Parse(this.hy_field73.Text); if (this.hy_field74.Text == "") Hyoa_flowmain.hy_field74 = 0; else Hyoa_flowmain.hy_field74 = float.Parse(this.hy_field74.Text); if (this.hy_field75.Text == "") Hyoa_flowmain.hy_field75 = 0; else Hyoa_flowmain.hy_field75 = float.Parse(this.hy_field75.Text); if (this.hy_field76.Text == "") Hyoa_flowmain.hy_field76 = 0; else Hyoa_flowmain.hy_field76 = float.Parse(this.hy_field76.Text); if (this.hy_field77.Text == "") Hyoa_flowmain.hy_field77 = 0; else Hyoa_flowmain.hy_field77 = float.Parse(this.hy_field77.Text); if (this.hy_field78.Text == "") Hyoa_flowmain.hy_field78 = 0; else Hyoa_flowmain.hy_field78 = float.Parse(this.hy_field78.Text); if (this.hy_field79.Text == "") Hyoa_flowmain.hy_field79 = 0; else Hyoa_flowmain.hy_field79 = float.Parse(this.hy_field79.Text); if (this.hy_field80.Text == "") Hyoa_flowmain.hy_field80 = 0; else Hyoa_flowmain.hy_field80 = float.Parse(this.hy_field80.Text); if (this.hy_field81.Text == "") Hyoa_flowmain.hy_field81 = 0; else Hyoa_flowmain.hy_field81 = float.Parse(this.hy_field81.Text); if (this.hy_field82.Text == "") Hyoa_flowmain.hy_field82 = 0; else Hyoa_flowmain.hy_field82 = float.Parse(this.hy_field82.Text); if (this.hy_field83.Text == "") Hyoa_flowmain.hy_field83 = 0; else Hyoa_flowmain.hy_field83 = float.Parse(this.hy_field83.Text); if (this.hy_field84.Text == "") Hyoa_flowmain.hy_field84 = 0; else Hyoa_flowmain.hy_field84 = float.Parse(this.hy_field84.Text); if (this.hy_field85.Text == "") Hyoa_flowmain.hy_field85 = 0; else Hyoa_flowmain.hy_field85 = float.Parse(this.hy_field85.Text); if (this.hy_field86.Text == "") Hyoa_flowmain.hy_field86 = 0; else Hyoa_flowmain.hy_field86 = float.Parse(this.hy_field86.Text); if (this.hy_field87.Text == "") Hyoa_flowmain.hy_field87 = 0; else Hyoa_flowmain.hy_field87 = float.Parse(this.hy_field87.Text); if (this.hy_field88.Text == "") Hyoa_flowmain.hy_field88 = 0; else Hyoa_flowmain.hy_field88 = float.Parse(this.hy_field88.Text); if (this.hy_field89.Text == "") Hyoa_flowmain.hy_field89 = 0; else Hyoa_flowmain.hy_field89 = float.Parse(this.hy_field89.Text); if (this.hy_field90.Text == "") Hyoa_flowmain.hy_field90 = 0; else Hyoa_flowmain.hy_field90 = float.Parse(this.hy_field90.Text); if (this.hy_field91.Text == "") Hyoa_flowmain.hy_field91 = 0; else Hyoa_flowmain.hy_field91 = float.Parse(this.hy_field91.Text); if (this.hy_field92.Text == "") Hyoa_flowmain.hy_field92 = 0; else Hyoa_flowmain.hy_field92 = float.Parse(this.hy_field92.Text); if (this.hy_field93.Text == "") Hyoa_flowmain.hy_field93 = 0; else Hyoa_flowmain.hy_field93 = float.Parse(this.hy_field93.Text); if (this.hy_field94.Text == "") Hyoa_flowmain.hy_field94 = 0; else Hyoa_flowmain.hy_field94 = float.Parse(this.hy_field94.Text); if (this.hy_field95.Text == "") Hyoa_flowmain.hy_field95 = 0; else Hyoa_flowmain.hy_field95 = float.Parse(this.hy_field95.Text); if (this.hy_field96.Text == "") Hyoa_flowmain.hy_field96 = 0; else Hyoa_flowmain.hy_field96 = float.Parse(this.hy_field96.Text); if (this.hy_field97.Text == "") Hyoa_flowmain.hy_field97 = 0; else Hyoa_flowmain.hy_field97 = float.Parse(this.hy_field97.Text); if (this.hy_field98.Text == "") Hyoa_flowmain.hy_field98 = 0; else Hyoa_flowmain.hy_field98 = float.Parse(this.hy_field98.Text); if (this.hy_field99.Text == "") Hyoa_flowmain.hy_field99 = 0; else Hyoa_flowmain.hy_field99 = float.Parse(this.hy_field99.Text); if (this.hy_field100.Text == "") Hyoa_flowmain.hy_field100 = 0; else Hyoa_flowmain.hy_field100 = float.Parse(this.hy_field100.Text); Hyoa_flowmain.hy_iftx = this.hy_iftx.Text; Hyoa_flowmain.hy_zhtxsj = this.hy_zhtxsj.Text; Hyoa_flowmain.hy_readuserlist = this.hy_readuserlist.Text; #endregion //保存 if (this.txtwhichoperation.Value == "1") { hylcbctscl(Hyoa_flowmain);//特殊处理 //效能系统日志20150603 if (this.txtop.Value == "add") { hyXnxtSaveLogs("撰写", "表单:" + this.lblcurtachenameshow.Text + "新增一条记录", "新增"); } else if (this.txtop.Value == "modify") { hyXnxtSaveLogs("修改", "表单:" + this.lblcurtachenameshow.Text + "修改一条记录", "修改"); } if (this.hy_tableid.Text == "f1265875-5494-465f-ac33-6fa43d208c8f" && this.txtop.Value == "add") { string strAuthor = ""; string strAuthorDept = ""; if (this.hy_field6.Text != "") { strAuthor += this.hy_field6.Text + ","; } if (this.hy_field5.Text != "") { strAuthorDept += this.hy_field5.Text + ","; } hyXnxtMessageLogs("录用", "录用一篇文章", strAuthor, strAuthorDept); } } //提交 if (this.txtwhichoperation.Value == "2") { //更新主文档 Hyoa_flowmain.hy_curtacheid = this.txtnexttacheid.Value; Hyoa_flowmain.hy_curtachename = this.txtnexttachename.Value; Hyoa_flowmain.hy_curclrid = this.txtnextclrid.Value; Hyoa_flowmain.hy_curclrname = this.txtnextclrname.Value; //---- 添加当前环节的处理时间 ---- start HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocidtacheid(this.txtdocid.Value, this.hy_curtacheid.Text); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") { Hyoa_flowhistoryinfo_cl.hy_clsj = System.DateTime.Now.ToString(); } else { Hyoa_flowhistoryinfo_cl.hy_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString(); } Hyoa_flowhistoryinfo_cl.Update(); } //---- 添加当前环节的处理时间 ---- end //--- 创建后续处理的处理记录+建立处理人待办事宜 ---- start Hyoa_global.Saveflowhistoryinfo_cl_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.txtnexttacheid.Value, this.txtnexttachename.Value, this.txtnextclrid.Value, this.txtnextclrname.Value, "", this.txtnextcyrid.Value, this.txtnextcyrname.Value, System.DateTime.Now.ToString(), ""); //待办事宜、短信、即时消息 HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); string[] lv_dbrid = this.txtnextclrid.Value.Split(new Char[] { ',' }); string[] lv_dbrname = this.txtnextclrname.Value.Split(new Char[] { ',' }); for (var i = 0; i < lv_dbrid.Length; i++) { if (lv_dbrid[i].ToString() != "") { //得到当前用户手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); //得到后续处理人手机号 string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(lv_dbrid[i].ToString()); //给后续处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(this.txtdocid.Value, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "/main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1", "待办", this.hy_mudelid.Text, "待办箱", "一般", this.hy_bt.Text, "请办理", 0, this.hy_flowid.Text, this.txtnexttacheid.Value); //给后续处理人发送即时消息(提醒) if (this.txtisSendjstx_clr.Value == "1") { Hyoa_global.Sendjstx_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.hy_mudelid.Text, this.hy_bt.Text, 0); } //给后续处理人发送短信(提醒) if (this.txtisSendsms_clr.Value == "1") { Hyoa_global.Sendsms_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), cb_fsrsjh, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_jsrsjh, this.hy_mudelid.Text, this.hy_bt.Text, 1, "", "", 0); } } } //--- 创建后续处理的处理记录+建立处理人待办事宜 ---- end //--- 创建后续传阅记录+建立待办事宜 ---- start string[] lv_cyrid = this.txtnextcyrid.Value.Split(new Char[] { ',' }); string[] lv_cyrname = this.txtnextcyrname.Value.Split(new Char[] { ',' }); for (var i = 0; i < lv_cyrid.Length; i++) { if (lv_cyrid[i].ToString() != "") { //建立传阅数据 Hyoa_global.Saveflowhistoryinfo_cy_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.txtnexttacheid.Value, this.txtnexttachename.Value, lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), "", System.DateTime.Now.ToString()); //待办事宜、短信、即时消息 //得到当前用户手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); //得到后续传阅人手机号 string cb_cyrsjh = Hyoa_user.GetMobilebyuserid(lv_cyrid[i].ToString()); //给后续处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(this.txtdocid.Value, lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "/main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1", "待阅", this.hy_mudelid.Text, "待办箱", "一般", this.hy_bt.Text, "请阅读", 0, this.hy_flowid.Text, this.txtnexttacheid.Value); //给后续处理人发送即时消息(提醒) if (this.txtisSendjstx_cyr.Value == "1") { Hyoa_global.Sendjstx_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), this.hy_mudelid.Text, this.hy_bt.Text, 0); } //给后续处理人发送短信(提醒) if (this.txtisSendsms_cyr.Value == "1") { Hyoa_global.Sendsms_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), cb_fsrsjh, lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), cb_cyrsjh, this.hy_mudelid.Text, this.hy_bt.Text, 1, "", "", 0); } } } //效能办公系统传阅数据 hyXnxtFlowLogs("文章发送给" + this.txtnextcyrname.Value + "阅读", "传阅"); //--- 创建后续传阅记录+建立待办事宜 ---- end //--- 当前处理人的待办事宜转已办 ---- start Hyoa_dbsy.Dbsytoybbydocidtacheiduserid(this.txtdocid.Value, this.hy_curtacheid.Text, this.Session["hyuid"].ToString()); //--- 当前处理人的待办事宜转已办 ---- end ls_tip = "文档已成功发送到[" + this.txtnexttachename.Value + "]环节"; hylctjtscl(Hyoa_flowmain);//特殊处理 } //收回 if (this.txtwhichoperation.Value == "3") { //得到上个环节处理人 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value); if (dt_clinfo.Rows.Count > 1) { //删除当前处理人员的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy_sh = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy_sh.DeleteByDocid_flowid_tacheid_userid(this.txtdocid.Value, dt_clinfo.Rows[0]["hy_flowid"].ToString(), dt_clinfo.Rows[0]["hy_tacheid"].ToString(), dt_clinfo.Rows[0]["hy_clrid"].ToString()); string ls_lastclrid = dt_clinfo.Rows[1]["hy_clrid"].ToString(); //上个环节处理人ID string ls_lastclrname = dt_clinfo.Rows[1]["hy_clrname"].ToString(); //上个环节处理人中文名 string ls_lastcldoc = dt_clinfo.Rows[1]["ID"].ToString(); //上个环节处理的记录ID string ls_lasttacheid = dt_clinfo.Rows[1]["hy_tacheid"].ToString(); //上个环节处理环节ID string ls_lasttachename = dt_clinfo.Rows[1]["hy_tachename"].ToString(); //上个环节处理环节名称 string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID dt_clinfo.Clear(); //删除当前处理的记录 Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.Delete(); //清空上个环节处理时间,更新创建时间 Hyoa_flowhistoryinfo_cl.ID = ls_lastcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ""; Hyoa_flowhistoryinfo_cl.hy_createtime = System.DateTime.Now.ToString(); Hyoa_flowhistoryinfo_cl.Update_sh(); //更新主文档中的当前环节ID、当前环节名称、当前处理人ID和中文名 Hyoa_flowmain.hy_curtacheid = ls_lasttacheid; Hyoa_flowmain.hy_curtachename = ls_lasttachename; Hyoa_flowmain.hy_curclrid = ls_lastclrid; Hyoa_flowmain.hy_curclrname = ls_lastclrname; ls_tip = "文档已成功收回到[" + ls_lasttachename + "]环节"; //绩效考核日志 hyXnxtFlowLogs("从" + this.hy_curtachename.Text + "环节收回到" + ls_lasttachename + "", "收回"); hylcshtscl(Hyoa_flowmain);//特殊处理 } } //退回 if (this.txtwhichoperation.Value == "4") { //更新主文档 Hyoa_flowmain.hy_curtacheid = this.txtnexttacheid.Value; Hyoa_flowmain.hy_curtachename = this.txtnexttachename.Value; Hyoa_flowmain.hy_curclrid = this.txtnextclrid.Value; Hyoa_flowmain.hy_curclrname = this.txtnextclrname.Value; //处理历史处理记录 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID string ls_clsj = ""; //当前处理的记录处理时间 if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") ls_clsj = System.DateTime.Now.ToString(); else ls_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString(); dt_clinfo.Clear(); Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ls_clsj; Hyoa_flowhistoryinfo_cl.Update(); } //新建一条处理记录 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); Hyoa_global.Saveflowhistoryinfo_cl_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.txtnexttacheid.Value, this.txtnexttachename.Value, this.txtnextclrid.Value, this.txtnextclrname.Value, "", "", "", System.DateTime.Now.ToString(), "是"); //处理待办事宜 //转已办-当前处理人的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy.Dbsytoybbydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); //得到发送人手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); //(考虑多人的情况) string[] lv_dbrid = this.txtnextclrid.Value.Split(new Char[] { ',' }); string[] lv_dbrname = this.txtnextclrname.Value.Split(new Char[] { ',' }); for (var i = 0; i < lv_dbrid.Length; i++) { if (lv_dbrid[i].ToString() != "") { //得到接收人手机号 string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(lv_dbrid[i].ToString()); HyoaClass.Hyoa_global Hyoa_global2 = new HyoaClass.Hyoa_global(); //给退回到的处理人发送一个新的待办事宜(提醒) Hyoa_global2.Senddbsy_global(this.txtdocid.Value, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "/main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1", "待办", this.hy_mudelid.Text, "待办箱", "一般", this.hy_bt.Text, "请办理", 0, this.hy_flowid.Text, this.txtnexttacheid.Value); //给退回到的处理人发送即时消息(提醒) if (this.txtisSendjstx.Value == "1") { Hyoa_global.Sendjstx_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.hy_mudelid.Text, this.hy_bt.Text, 0); } //给退回到的处理人发送短信(提醒) if (this.txtisSendsms.Value == "1") { Hyoa_global.Sendsms_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), cb_fsrsjh, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_jsrsjh, this.hy_mudelid.Text, this.hy_bt.Text, 1, "", "", 0); } } } //绩效考核写日志 add by wjs at 20150603 hyXnxtFlowLogs("从" + this.hy_curtachename.Text + "环节退回到" + this.txtnexttachename.Value + "", "退回"); ls_tip = "已成功退回到[" + this.txtnexttachename.Value + "]环节"; hylcthtscl(Hyoa_flowmain);//特殊处理 } //多人处理 if (this.txtwhichoperation.Value == "5") { //更新主文档 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); string ls_newclrid = Hyoa_global.MoveOneString_dh(this.hy_curclrid.Text, this.Session["hyuid"].ToString()); string ls_newclrname = Hyoa_global.MoveOneString_dh(this.hy_curclrname.Text, this.Session["hyuname"].ToString()); Hyoa_flowmain.hy_curclrid = ls_newclrid; Hyoa_flowmain.hy_curclrname = ls_newclrname; //处理处理记录 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID string ls_clsj = ""; //当前处理的记录处理时间 if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") ls_clsj = System.DateTime.Now.ToString(); else ls_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString(); dt_clinfo.Clear(); Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ls_clsj; Hyoa_flowhistoryinfo_cl.Update(); //办公效率智能分析添加 add by wjs at 20150603 hyXnxtFlowLogs("从" + this.hy_curtachename.Text + "环节提交到" + this.txtnexttachename.Value + "环节", "提交"); } //处理待办事宜 //转已办-当前处理人的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy.Dbsytoybbydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); ls_tip = "提交成功,当前环节还需要[" + ls_newclrname + "]进行办理"; hylcdrcltscl(Hyoa_flowmain);//特殊处理 } //催办 if (this.txtwhichoperation.Value == "6") { HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); string cb_docid = this.txtdocid.Value; string cb_dbrid = this.hy_curclrid.Text; string cb_dbrname = this.hy_curclrname.Text; string cb_fsrid = this.Session["hyuid"].ToString(); string cb_fsrname = this.Session["hyuname"].ToString(); string cb_url = "main.aspx?op=modify&docid=" + this.txtdocid.Value + "&pop=1"; string cb_property = "催办"; string cb_mudelid = this.hy_mudelid.Text; string cb_foldername = "待办箱"; string cb_hj = "一般"; string cb_bt = this.txtcbideas.Value + "-" + this.hy_bt.Text; string cb_subbt = "请阅读"; float cb_ifyb = 0; string cb_flowid = this.hy_flowid.Text; string cb_tacheid = this.hy_curtacheid.Text; string cb_from = this.hy_mudelid.Text; //得到发送人手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(cb_fsrid); //得到接收人手机号 string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(cb_dbrid); //给当前处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(cb_docid, cb_dbrid, cb_dbrname, cb_fsrid, cb_fsrname, cb_url, cb_property, cb_mudelid, cb_foldername, cb_hj, cb_bt, cb_subbt, cb_ifyb, cb_flowid, cb_tacheid); //给当前处理人发送即时消息(提醒) if (this.txtisSendjstx.Value == "1") { Hyoa_global.Sendjstx_global(cb_docid, cb_fsrid, cb_fsrname, cb_dbrid, cb_dbrname, cb_from, cb_bt, 0); } //给当前处理人发送短信(提醒) if (this.txtisSendsms.Value == "1") { Hyoa_global.Sendsms_global(cb_docid, cb_fsrid, cb_fsrname, cb_fsrsjh, cb_dbrid, cb_dbrname, cb_jsrsjh, cb_from, cb_bt, 1, "", "", 0); } //绩效考核写日志 add by wjs at 20150603 hyXnxtFlowLogs("催办" + this.hy_curtachename.Text + "环节", "催办"); ls_tip = "催办成功!"; hylccbtscl(Hyoa_flowmain);//特殊处理 } //流程结束时的提交 if (this.txtwhichoperation.Value == "7") { //更新主文档 Hyoa_flowmain.hy_curtacheid = "**"; Hyoa_flowmain.hy_curtachename = "结束"; Hyoa_flowmain.hy_curclrid = ""; Hyoa_flowmain.hy_curclrname = ""; //更新处理表 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID string ls_clsj = ""; //当前处理的记录处理时间 if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") ls_clsj = System.DateTime.Now.ToString(); else ls_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString(); dt_clinfo.Clear(); Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ls_clsj; Hyoa_flowhistoryinfo_cl.Update(); } ////流程结束时删除所有该文档对应的待办事宜 //HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); //Hyoa_dbsy.Deletebydocid(this.txtdocid.Value); //处理待办事宜 //转已办-当前处理人的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy.Dbsytoybbydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); ls_tip = "流程结束!"; hylcjstscl(Hyoa_flowmain);//特殊处理 hyXnxtFlowLogs("流程结束,文件已归档", "归档"); if (this.hy_tableid.Text == "1a564b74-3d94-4cef-bb94-f0c0342ae8dd") { string strAuthor = ""; string strAuthorDept = ""; if (this.hy_field2.Text != "") { strAuthor += this.hy_field2.Text + ","; } if (this.hy_field3.Text != "") { strAuthorDept += this.hy_field3.Text + ","; } if (this.hy_field4.Text != "") { strAuthor += this.hy_field4.Text + ","; } if (this.hy_field5.Text != "") { strAuthorDept += this.hy_field5.Text + ","; } if (this.hy_field6.Text != "") { strAuthor += this.hy_field6.Text + ","; } if (this.hy_field7.Text != "") { strAuthorDept += this.hy_field7.Text + ","; } hyXnxtMessageLogs("通过", "通过一篇文章", strAuthor, strAuthorDept); } } Hyoa_flowmain.Update(); ////处理完成后的提示及跳转(增加刷新附件功能) if (this.txtifsxfj.Text == "1") { //Response.Write("<script>window.location='/main.aspx?op=modify&mid="+this.hy_mudelid.Text+"&tableid="+this.hy_tableid.Text+"&docid="+this.txtdocid.Value+"&url="+this.txturl.Value+"'</script>"); Response.Write("<script>window.location='/main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&url=" + this.txturl.Value + "'</script>"); } else { if (this.txtifpop.Value == "") { Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>"); } else { Response.Write("<script>alert('" + ls_tip + "');window.opener.location.reload();window.opener=null;window.open('','_self');window.close();</script>"); } } }
//////////置为文档已读状态 ////////private void UpdateReadFlag() ////////{ //////// HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain(); //////// Hyoa_flowmain.UpdateReadFlag(this.txtdocid.Value, Session["hyuid"].ToString()); ////////} //保存 protected void Button_Save_Click(object sender, EventArgs e) { if (this.Session["hyuid"].ToString() == "") this.Response.Redirect("../login.aspx"); string ls_tip = "保存成功!"; //新文档时 //新建时先进行一次保存 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); //HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain(); if (this.txtop.Value == "add") { //Hyoa_flowmain.DOCID = this.txtdocid.Value; //Hyoa_flowmain.hy_mudelid = this.hy_mudelid.Text; //Hyoa_flowmain.hy_tableid = this.hy_tableid.Text; //Hyoa_flowmain.hy_flowid = this.hy_flowid.Text; //Hyoa_flowmain.hy_flowname = this.hy_flowname.Text; //Hyoa_flowmain.hy_curtacheid = this.hy_curtacheid.Text; //Hyoa_flowmain.hy_curtachename = this.hy_curtachename.Text; //Hyoa_flowmain.hy_curclrid = this.hy_curclrid.Text; //Hyoa_flowmain.hy_curclrname = this.hy_curclrname.Text; //Hyoa_flowmain.hy_djrid = this.hy_djrid.Text; //Hyoa_flowmain.hy_djrname = this.hy_djrname.Text; //Hyoa_flowmain.hy_djrbmid = this.hy_djrbmid.Text; //Hyoa_flowmain.hy_djrbmname = this.hy_djrbmname.Text; //Hyoa_flowmain.hy_djsj = this.hy_djsj.Text; //Hyoa_flowmain.hy_bt = this.hy_bt.Text; //Hyoa_flowmain.hy_iftx = this.hy_iftx.Text; //Hyoa_flowmain.hy_zhtxsj = this.hy_zhtxsj.Text; //Hyoa_flowmain.hy_readuserlist = this.hy_readuserlist.Text; //Hyoa_flowmain.Insert(); //动态插入数据 //HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); string lssqlfield = "SELECT * FROM hyt_flowfield WHERE (hy_tableid = 'Tabledcxt') AND (hy_mudelid = 'Mudeldcxt')"; DataTable dtfield = Hyoa_global.GetDataTable_BASE(lssqlfield); //得到所有配置域 string lssqlinsert = ""; string lssqlinsert1 = ""; string lssqlinsert2 = ""; string lssqlinsert3 = ""; string lssqlinsert4 = ""; string lssqlinsert5 = ""; lssqlinsert1 = "insert into hyc_" + this.hy_tableid.Text + "("; lssqlinsert2 = "DOCID,hy_mudelid,hy_tableid,hy_flowid,hy_flowname,hy_curtacheid,hy_curtachename,hy_curclrid,hy_curclrname,hy_djrid,hy_djrname,hy_djrbmid,hy_djrbmname,hy_djsj,hy_bt,hy_iftx,hy_zhtxsj,hy_readuserlist"; lssqlinsert3 = ") values ("; lssqlinsert4 = "'" + this.txtdocid.Value + "'"; lssqlinsert4 += ",'" + this.hy_mudelid.Text + "'"; lssqlinsert4 += ",'" + this.hy_tableid.Text + "'"; lssqlinsert4 += ",'" + this.hy_flowid.Text + "'"; lssqlinsert4 += ",'" + this.hy_flowname.Text + "'"; lssqlinsert4 += ",'" + this.hy_curtacheid.Text + "'"; lssqlinsert4 += ",'" + this.hy_curtachename.Text + "'"; lssqlinsert4 += ",'" + this.hy_curclrid.Text + "'"; lssqlinsert4 += ",'" + this.hy_curclrname.Text + "'"; lssqlinsert4 += ",'" + this.hy_djrid.Text + "'"; lssqlinsert4 += ",'" + this.hy_djrname.Text + "'"; lssqlinsert4 += ",'" + this.hy_djrbmid.Text + "'"; lssqlinsert4 += ",'" + this.hy_djrbmname.Text + "'"; if (Session["conntype"].ToString() == "SQL") { lssqlinsert4 += ",'"+this.hy_djsj.Text + "'"; } if (Session["conntype"].ToString() == "ORACLE") { lssqlinsert4 += ",to_date('" + this.hy_djsj.Text + "','YYYY-MM-DD HH24:MI:SS')"; } lssqlinsert4 += ",'" + this.hy_bt.Text + "'"; lssqlinsert4 += ",'" + this.hy_iftx.Text + "'"; lssqlinsert4 += ",'" + this.hy_zhtxsj.Text + "'"; lssqlinsert4 += ",'" + this.hy_readuserlist.Text+"'"; lssqlinsert5 = ")"; for (int ii = 0; ii < dtfield.Rows.Count; ii++) { lssqlinsert2 += "," + "hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString(); if (dtfield.Rows[ii]["hy_fieldtype"].ToString() == "文本" || dtfield.Rows[ii]["hy_fieldtype"].ToString() == "多行文本") { TextBox txt1 = (TextBox)this.FindControl("txthyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()); lssqlinsert4 += ",'" + txt1.Text + "'"; } if (dtfield.Rows[ii]["hy_fieldtype"].ToString() == "日期") { TextBox txt1 = (TextBox)this.FindControl("txthyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()); if (Session["conntype"].ToString() == "SQL") { lssqlinsert4 += ",'" + txt1.Text + "'"; } if (Session["conntype"].ToString() == "ORACLE") { lssqlinsert4 += ",to_date('" + txt1.Text + "','YYYY-MM-DD HH24:MI:SS')"; } } if (dtfield.Rows[ii]["hy_fieldtype"].ToString() == "对话框列表") { DropDownList ddl1 = (DropDownList)this.FindControl("txthyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()); lssqlinsert4 += ",'" + ddl1.SelectedValue + "'"; } } lssqlinsert = lssqlinsert1 + lssqlinsert2 + lssqlinsert3 + lssqlinsert4 + lssqlinsert5; //HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); //Response.Write(lssqlinsert); Hyoa_global.ExcuteSQL(lssqlinsert); //插入历史处理表 HyoaClass.Hyoa_global Hyoa_global_add = new HyoaClass.Hyoa_global(); Hyoa_global_add.Saveflowhistoryinfo_cl_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.hy_curtacheid.Text, this.hy_curtachename.Text, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "", "", "", this.hy_djsj.Text, ""); } //更新内容 //Hyoa_flowmain.DOCID = this.txtdocid.Value; //Hyoa_flowmain.hy_curtacheid = this.hy_curtacheid.Text; //Hyoa_flowmain.hy_curtachename = this.hy_curtachename.Text; //Hyoa_flowmain.hy_curclrid = this.hy_curclrid.Text; //Hyoa_flowmain.hy_curclrname = this.hy_curclrname.Text; //Hyoa_flowmain.hy_bt = this.hy_bt.Text; //Hyoa_flowmain.hy_iftx = this.hy_iftx.Text; //Hyoa_flowmain.hy_zhtxsj = this.hy_zhtxsj.Text; //Hyoa_flowmain.hy_readuserlist = this.hy_readuserlist.Text; string lssqlfield2 = "SELECT * FROM hyt_flowfield WHERE (hy_tableid = 'Tabledcxt') AND (hy_mudelid = 'Mudeldcxt')"; DataTable dtfield2 = Hyoa_global.GetDataTable_BASE(lssqlfield2); //得到所有配置域 string lssqlupdate1 = "update hyc_" + this.hy_tableid.Text + " set hy_curtacheid = '" + this.hy_curtacheid.Text + "'"; lssqlupdate1 += ",hy_curtachename='" + this.hy_curtachename.Text + "'"; lssqlupdate1 += ",hy_curclrid='" + this.hy_curclrid.Text + "'"; lssqlupdate1 += ",hy_curclrname='" + this.hy_curclrname.Text + "'"; lssqlupdate1 += ",hy_bt='" + this.hy_bt.Text + "'"; for (int ii = 0; ii < dtfield2.Rows.Count; ii++) { if (dtfield2.Rows[ii]["hy_fieldtype"].ToString() == "文本" || dtfield2.Rows[ii]["hy_fieldtype"].ToString() == "多行文本" || dtfield2.Rows[ii]["hy_fieldtype"].ToString() == "日期") { TextBox txt1 = (TextBox)this.FindControl("txthyc_" + dtfield2.Rows[ii]["hy_fieldid"].ToString()); lssqlupdate1 += ",hyc_" + dtfield2.Rows[ii]["hy_fieldid"].ToString() + "='" + txt1.Text + "'"; } if (dtfield2.Rows[ii]["hy_fieldtype"].ToString() == "对话框列表") { DropDownList ddl1 = (DropDownList)this.FindControl("txthyc_" + dtfield2.Rows[ii]["hy_fieldid"].ToString()); lssqlupdate1 += ",hyc_" + dtfield2.Rows[ii]["hy_fieldid"].ToString() + "='" + ddl1.SelectedValue + "'"; } } lssqlupdate1 += " where DOCID='" + this.txtdocid.Value + "'"; Hyoa_global.ExcuteSQL(lssqlupdate1); //更新hy_bt字段 string sql_updatebt = ""; if (Session["conntype"].ToString() == "SQL") { sql_updatebt = "update hyc_" + this.hy_tableid.Text + " set hy_bt = '['+hyc_nf+']'+hyc_bh+'号' where DOCID='" + this.txtdocid.Value + "'"; } if (Session["conntype"].ToString() == "ORACLE") { sql_updatebt = "update hyc_" + this.hy_tableid.Text + " set hy_bt = CONCAT(CONCAT(CONCAT(CONCAT('[',hyc_nf),']'),hyc_bh),'号') where DOCID='" + this.txtdocid.Value + "'"; } Hyoa_global.ExcuteSQL(sql_updatebt); sql_updatebt = "select * from hyc_" + this.hy_tableid.Text + " where DOCID='" + this.txtdocid.Value + "' "; DataTable dt_updatebt = Hyoa_global.GetDataTable(sql_updatebt); if (dt_updatebt.Rows.Count > 0) this.hy_bt.Text = dt_updatebt.Rows[0]["hy_bt"].ToString(); //保存 if (this.txtwhichoperation.Value == "1") { hylcbctscl();//特殊处理 } //提交 if (this.txtwhichoperation.Value == "2") { //更新主文档 lssqlupdate1 = "update hyc_" + this.hy_tableid.Text +" set hy_curtacheid='" + this.txtnexttacheid.Value + "'"; lssqlupdate1 += ",hy_curtachename='" + this.txtnexttachename.Value + "'"; lssqlupdate1 += ",hy_curclrid='" + this.txtnextclrid.Value + "'"; lssqlupdate1 += ",hy_curclrname='" + this.txtnextclrname.Value + "'"; lssqlupdate1 += " where DOCID='" + this.txtdocid.Value + "'"; Hyoa_global.ExcuteSQL(lssqlupdate1); //Hyoa_flowmain.hy_curtacheid = this.txtnexttacheid.Value; //Hyoa_flowmain.hy_curtachename = this.txtnexttachename.Value; //Hyoa_flowmain.hy_curclrid = this.txtnextclrid.Value; //Hyoa_flowmain.hy_curclrname = this.txtnextclrname.Value; //---- 添加当前环节的处理时间 ---- start HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); //HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocidtacheid(this.txtdocid.Value, this.hy_curtacheid.Text); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") { Hyoa_flowhistoryinfo_cl.hy_clsj = System.DateTime.Now.ToString(); } else { Hyoa_flowhistoryinfo_cl.hy_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString(); } Hyoa_flowhistoryinfo_cl.Update(); } //---- 添加当前环节的处理时间 ---- end //--- 创建后续处理的处理记录+建立处理人待办事宜 ---- start Hyoa_global.Saveflowhistoryinfo_cl_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.txtnexttacheid.Value, this.txtnexttachename.Value, this.txtnextclrid.Value, this.txtnextclrname.Value, "", this.txtnextcyrid.Value, this.txtnextcyrname.Value, System.DateTime.Now.ToString(), ""); //待办事宜、短信、即时消息 HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); string[] lv_dbrid = this.txtnextclrid.Value.Split(new Char[] { ',' }); string[] lv_dbrname = this.txtnextclrname.Value.Split(new Char[] { ',' }); for (var i = 0; i < lv_dbrid.Length; i++) { if (lv_dbrid[i].ToString() != "") { //得到当前用户手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); //得到后续处理人手机号 string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(lv_dbrid[i].ToString()); string ls_sendbt; if (this.txtnexttacheid.Value == "tache0002") { //ls_sendbt = "有督查件:《区政府政务督查通知单〔" + this.hy_field36.Text + "〕" + this.hy_field37.Text + "号》,请在区政府信息督查系统查收并于" + this.hy_field34.Text.ToString() + "前按要求及时反馈。"; if (this.txthyc_lb.SelectedValue == "办件") { ls_sendbt = "《督查通知单〔" + this.txthyc_nf.Text + "〕" + this.txthyc_bh.Text + "号》已发,请尽快查收并于" + this.txthyc_cbqx.Text.ToString() + "前按要求反馈。"; //《区政府督查通知单〔2012〕235号》已发,请尽快查收并于2012-08-10前按要求反馈。 } else { ls_sendbt = "有" + this.txthyc_lb.SelectedValue + ":《督查通知单〔" + this.txthyc_nf.Text + "〕" + this.txthyc_bh.Text + "号》已发,请及时查收并转交领导。"; //有重要阅件:《区政府督查通知单〔2012〕235号》已发,请及时查收并转交领导。 } } else { ls_sendbt = this.hy_bt.Text; } //给后续处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(this.txtdocid.Value, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "zwdc/main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1", "待办", this.hy_mudelid.Text, "待办箱", "一般", this.hy_bt.Text, "请办理", 0, this.hy_flowid.Text, this.txtnexttacheid.Value, this.hy_tableid.Text); //给后续处理人发送即时消息(提醒) if (this.txtisSendjstx_clr.Value == "1") { Hyoa_global.Sendjstx_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.hy_mudelid.Text, ls_sendbt, 0, this.hy_tableid.Text); } //给后续处理人发送短信(提醒) if (this.txtisSendsms_clr.Value == "1") { Hyoa_global.Sendsms_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), cb_fsrsjh, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_jsrsjh, this.hy_mudelid.Text, ls_sendbt, 1, "", "", 0, this.hy_tableid.Text); } } } //--- 创建后续处理的处理记录+建立处理人待办事宜 ---- end //--- 创建后续传阅记录+建立待办事宜 ---- start string[] lv_cyrid = this.txtnextcyrid.Value.Split(new Char[] { ',' }); string[] lv_cyrname = this.txtnextcyrname.Value.Split(new Char[] { ',' }); for (var i = 0; i < lv_cyrid.Length; i++) { if (lv_cyrid[i].ToString() != "") { //建立传阅数据 Hyoa_global.Saveflowhistoryinfo_cy_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.txtnexttacheid.Value, this.txtnexttachename.Value, lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), "", System.DateTime.Now.ToString()); //待办事宜、短信、即时消息 //得到当前用户手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); //得到后续传阅人手机号 string cb_cyrsjh = Hyoa_user.GetMobilebyuserid(lv_cyrid[i].ToString()); string ls_sendbt; if (this.txtnexttacheid.Value == "tache0002") { if (this.txthyc_lb.SelectedValue == "办件") { ls_sendbt = "《督查通知单〔" + this.txthyc_nf.Text + "〕" + this.txthyc_bh.Text + "号》已发,请尽快查收并于" + this.txthyc_cbqx.Text.ToString() + "前按要求反馈。"; //《区政府督查通知单〔2012〕235号》已发,请尽快查收并于2012-08-10前按要求反馈。 } else { ls_sendbt = "有" + this.txthyc_lb.SelectedValue + ":《督查通知单〔" + this.txthyc_nf.Text + "〕" + this.txthyc_bh.Text + "号》已发,请及时查收并转交领导。"; //有重要阅件:《区政府督查通知单〔2012〕235号》已发,请及时查收并转交领导。 } } else { ls_sendbt = this.txthyc_dcsx.Text; } //给后续处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(this.txtdocid.Value, lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "zwdc/main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1", "待阅", this.hy_mudelid.Text, "待办箱", "一般", this.hy_bt.Text, "请阅读", 0, this.hy_flowid.Text, this.txtnexttacheid.Value, this.hy_tableid.Text); //给后续处理人发送即时消息(提醒) if (this.txtisSendjstx_cyr.Value == "1") { Hyoa_global.Sendjstx_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), this.hy_mudelid.Text, ls_sendbt, 0, this.hy_tableid.Text); } //给后续处理人发送短信(提醒) if (this.txtisSendsms_cyr.Value == "1") { Hyoa_global.Sendsms_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), cb_fsrsjh, lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), cb_cyrsjh, this.hy_mudelid.Text, ls_sendbt, 1, "", "", 0, this.hy_tableid.Text); } } } //--- 创建后续传阅记录+建立待办事宜 ---- end //--- 当前处理人的待办事宜转已办 ---- start Hyoa_dbsy.Dbsytoybbydocidtacheiduserid(this.txtdocid.Value, this.hy_curtacheid.Text, this.Session["hyuid"].ToString()); //--- 当前处理人的待办事宜转已办 ---- end ls_tip = "文档已成功发送到[" + this.txtnexttachename.Value + "]环节"; hylctjtscl();//特殊处理 } //收回 if (this.txtwhichoperation.Value == "3") { //得到上个环节处理人 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value); if (dt_clinfo.Rows.Count > 1) { //删除当前处理人员的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy_sh = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy_sh.DeleteByDocid_flowid_tacheid_userid(this.txtdocid.Value, dt_clinfo.Rows[0]["hy_flowid"].ToString(), dt_clinfo.Rows[0]["hy_tacheid"].ToString(), dt_clinfo.Rows[0]["hy_clrid"].ToString()); string ls_lastclrid = dt_clinfo.Rows[1]["hy_clrid"].ToString(); //上个环节处理人ID string ls_lastclrname = dt_clinfo.Rows[1]["hy_clrname"].ToString(); //上个环节处理人中文名 string ls_lastcldoc = dt_clinfo.Rows[1]["ID"].ToString(); //上个环节处理的记录ID string ls_lasttacheid = dt_clinfo.Rows[1]["hy_tacheid"].ToString(); //上个环节处理环节ID string ls_lasttachename = dt_clinfo.Rows[1]["hy_tachename"].ToString(); //上个环节处理环节名称 string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID dt_clinfo.Clear(); //删除当前处理的记录 Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.Delete(); //清空上个环节处理时间,更新创建时间 Hyoa_flowhistoryinfo_cl.ID = ls_lastcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ""; Hyoa_flowhistoryinfo_cl.hy_createtime = System.DateTime.Now.ToString(); Hyoa_flowhistoryinfo_cl.Update_sh(); //更新主文档中的当前环节ID、当前环节名称、当前处理人ID和中文名 lssqlupdate1 = "update hyc_" + this.hy_tableid.Text + " set hy_curtacheid='" + ls_lasttacheid + "'"; lssqlupdate1 += ",hy_curtachename='" + ls_lasttachename + "'"; lssqlupdate1 += ",hy_curclrid='" + ls_lastclrid + "'"; lssqlupdate1 += ",hy_curclrname='" + ls_lastclrname + "'"; lssqlupdate1 += " where DOCID='" + this.txtdocid.Value + "'"; Hyoa_global.ExcuteSQL(lssqlupdate1); //Hyoa_flowmain.hy_curtacheid = ls_lasttacheid; //Hyoa_flowmain.hy_curtachename = ls_lasttachename; //Hyoa_flowmain.hy_curclrid = ls_lastclrid; //Hyoa_flowmain.hy_curclrname = ls_lastclrname; ls_tip = "文档已成功收回到[" + ls_lasttachename + "]环节"; hylcshtscl();//特殊处理 } } //退回 if (this.txtwhichoperation.Value == "4") { //更新主文档 //Hyoa_flowmain.hy_curtacheid = this.txtnexttacheid.Value; //Hyoa_flowmain.hy_curtachename = this.txtnexttachename.Value; //Hyoa_flowmain.hy_curclrid = this.txtnextclrid.Value; //Hyoa_flowmain.hy_curclrname = this.txtnextclrname.Value; lssqlupdate1 = "update hyc_" + this.hy_tableid.Text + " set hy_curtacheid='" + this.txtnexttacheid.Value + "'"; lssqlupdate1 += ",hy_curtachename='" + this.txtnexttachename.Value + "'"; lssqlupdate1 += ",hy_curclrid='" + this.txtnextclrid.Value + "'"; lssqlupdate1 += ",hy_curclrname='" + this.txtnextclrname.Value + "'"; lssqlupdate1 += " where DOCID='" + this.txtdocid.Value + "'"; Hyoa_global.ExcuteSQL(lssqlupdate1); //处理历史处理记录 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID string ls_clsj = ""; //当前处理的记录处理时间 if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") ls_clsj = System.DateTime.Now.ToString(); else ls_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString(); dt_clinfo.Clear(); Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ls_clsj; Hyoa_flowhistoryinfo_cl.Update(); } //新建一条处理记录 //HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); Hyoa_global.Saveflowhistoryinfo_cl_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.txtnexttacheid.Value, this.txtnexttachename.Value, this.txtnextclrid.Value, this.txtnextclrname.Value, "", "", "", System.DateTime.Now.ToString(), "是"); //处理待办事宜 //转已办-当前处理人的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy.Dbsytoybbydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); string ls_sendbt; if (this.txtnexttacheid.Value == "tache0002") { if (this.txthyc_lb.SelectedValue == "办件") { ls_sendbt = "《督查通知单〔" + this.txthyc_nf.Text + "〕" + this.txthyc_bh.Text + "号》已发,请尽快查收并于" + this.txthyc_cbqx.Text.ToString() + "前按要求反馈。"; //《区政府督查通知单〔2012〕235号》已发,请尽快查收并于2012-08-10前按要求反馈。 } else { ls_sendbt = "有" + this.txthyc_lb.Text + ":《督查通知单〔" + this.txthyc_nf.Text + "〕" + this.txthyc_bh.Text + "号》已发,请及时查收并转交领导。"; //有重要阅件:《区政府督查通知单〔2012〕235号》已发,请及时查收并转交领导。 } } else { ls_sendbt = this.hy_bt.Text; } //得到发送人手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); //(考虑多人的情况) string[] lv_dbrid = this.txtnextclrid.Value.Split(new Char[] { ',' }); string[] lv_dbrname = this.txtnextclrname.Value.Split(new Char[] { ',' }); for (var i = 0; i < lv_dbrid.Length; i++) { if (lv_dbrid[i].ToString() != "") { //得到接收人手机号 string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(lv_dbrid[i].ToString()); HyoaClass.Hyoa_global Hyoa_global2 = new HyoaClass.Hyoa_global(); //给退回到的处理人发送一个新的待办事宜(提醒) Hyoa_global2.Senddbsy_global(this.txtdocid.Value, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "zwdc/main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1", "待办", this.hy_mudelid.Text, "待办箱", "一般", this.hy_bt.Text, "请办理", 0, this.hy_flowid.Text, this.txtnexttacheid.Value, this.hy_tableid.Text); //给退回到的处理人发送即时消息(提醒) if (this.txtisSendjstx.Value == "1") { Hyoa_global.Sendjstx_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.hy_mudelid.Text, ls_sendbt, 0, this.hy_tableid.Text); } //给退回到的处理人发送短信(提醒) if (this.txtisSendsms.Value == "1") { Hyoa_global.Sendsms_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), cb_fsrsjh, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_jsrsjh, this.hy_mudelid.Text, ls_sendbt, 1, "", "", 0, this.hy_tableid.Text); } } } ls_tip = "已成功退回到[" + this.txtnexttachename.Value + "]环节"; hylcthtscl();//特殊处理 } //多人处理 if (this.txtwhichoperation.Value == "5") { //更新主文档 //HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); string ls_newclrid = Hyoa_global.MoveOneString_dh(this.hy_curclrid.Text, this.Session["hyuid"].ToString()); string ls_newclrname = Hyoa_global.MoveOneString_dh(this.hy_curclrname.Text, this.Session["hyuname"].ToString()); lssqlupdate1 = "update hyc_" + this.hy_tableid.Text + " set hy_curclrid='" + ls_newclrid + "'"; lssqlupdate1 += ",hy_curclrname='" + ls_newclrname + "'"; lssqlupdate1 += " where DOCID='" + this.txtdocid.Value + "'"; Hyoa_global.ExcuteSQL(lssqlupdate1); //Hyoa_flowmain.hy_curclrid = ls_newclrid; //Hyoa_flowmain.hy_curclrname = ls_newclrname; //处理处理记录 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID string ls_clsj = ""; //当前处理的记录处理时间 if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") ls_clsj = System.DateTime.Now.ToString(); else ls_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString(); dt_clinfo.Clear(); Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ls_clsj; Hyoa_flowhistoryinfo_cl.Update(); } //处理待办事宜 //转已办-当前处理人的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy.Dbsytoybbydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); ls_tip = "提交成功,当前环节还需要[" + ls_newclrname + "]进行办理"; hylcdrcltscl();//特殊处理 } //催办 if (this.txtwhichoperation.Value == "6") { //HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); string cb_docid = this.txtdocid.Value; string cb_dbrid = this.hy_curclrid.Text; string cb_dbrname = this.hy_curclrname.Text; string cb_fsrid = this.Session["hyuid"].ToString(); string cb_fsrname = this.Session["hyuname"].ToString(); string cb_url = "zwdc/main.aspx?op=modify&docid=" + this.txtdocid.Value + "&pop=1"; string cb_property = "催办"; string cb_mudelid = this.hy_mudelid.Text; string cb_foldername = "待办箱"; string cb_hj = "一般"; string cb_bt = this.txtcbideas.Value + "-" + this.hy_bt.Text; string cb_subbt = "请阅读"; float cb_ifyb = 0; string cb_flowid = this.hy_flowid.Text; string cb_tacheid = this.hy_curtacheid.Text; string cb_from = this.hy_mudelid.Text; //得到发送人手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(cb_fsrid); //得到接收人手机号 string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(cb_dbrid); //给当前处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(cb_docid, cb_dbrid, cb_dbrname, cb_fsrid, cb_fsrname, cb_url, cb_property, cb_mudelid, cb_foldername, cb_hj, cb_bt, cb_subbt, cb_ifyb, cb_flowid, cb_tacheid, this.hy_tableid.Text); //给当前处理人发送即时消息(提醒) if (this.txtisSendjstx.Value == "1") { Hyoa_global.Sendjstx_global(cb_docid, cb_fsrid, cb_fsrname, cb_dbrid, cb_dbrname, cb_from, cb_bt, 0, this.hy_tableid.Text); } //给当前处理人发送短信(提醒) if (this.txtisSendsms.Value == "1") { Hyoa_global.Sendsms_global(cb_docid, cb_fsrid, cb_fsrname, cb_fsrsjh, cb_dbrid, cb_dbrname, cb_jsrsjh, cb_from, cb_bt, 1, "", "", 0, this.hy_tableid.Text); } ls_tip = "催办成功!"; hylccbtscl();//特殊处理 } //流程结束时的提交 if (this.txtwhichoperation.Value == "7") { //更新主文档 lssqlupdate1 = "update hyc_" + this.hy_tableid.Text + " set hy_curtacheid='" + "**" + "'"; lssqlupdate1 += ",hy_curtachename='" + "结束" + "'"; lssqlupdate1 += ",hy_curclrid='" + "" + "'"; lssqlupdate1 += ",hy_curclrname='" + "" + "'"; lssqlupdate1 += " where DOCID='" + this.txtdocid.Value + "'"; Hyoa_global.ExcuteSQL(lssqlupdate1); //Hyoa_flowmain.hy_curtacheid = "**"; //Hyoa_flowmain.hy_curtachename = "结束"; //Hyoa_flowmain.hy_curclrid = ""; //Hyoa_flowmain.hy_curclrname = ""; //更新处理表 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID string ls_clsj = ""; //当前处理的记录处理时间 if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") ls_clsj = System.DateTime.Now.ToString(); else ls_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString(); dt_clinfo.Clear(); Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ls_clsj; Hyoa_flowhistoryinfo_cl.Update(); } ////流程结束时删除所有该文档对应的待办事宜 //HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); //Hyoa_dbsy.Deletebydocid(this.txtdocid.Value); //处理待办事宜 //转已办-当前处理人的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy.Dbsytoybbydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); ls_tip = "流程结束!"; hylcjstscl();//特殊处理 } lssqlupdate1 += " where DOCID='" + this.txtdocid.Value + "'"; //HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); Hyoa_global.ExcuteSQL(lssqlupdate1); //Hyoa_flowmain.Update(); //处理完成后的提示及跳转(增加刷新附件功能) if (this.txtifsxfj.Text == "1") { Response.Write("<script>window.location='zwdc/main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&url=" + this.txturl.Value + "'</script>"); } else { if (this.txtifpop.Value == "") { Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>"); } else { Response.Write("<script>alert('" + ls_tip + "');self.close();</script>"); } } }
//保存 protected void Button_Save_Click(object sender, EventArgs e) { if (this.Session["hyuid"].ToString() == "") this.Response.Redirect("../login.aspx"); //HyoaClass.Hyoa_reback Hyoa_reback = new HyoaClass.Hyoa_reback(); HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); //DataTable rebackdt = Hyoa_reback.Getrebackbyfatheridandrebackuserid(this.txtfatherid.Value, ""); string[] lv_username; string[] lv_userid; string lsunid; string lstxconent; lv_userid = this.txtrebackuserid.Value.Split(','); lv_username = this.txtrebackusername.Value.Split(','); //HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain(); for (int i = 0; i < lv_userid.Length; i++) { lsunid = Hyoa_global.GetRandom(); //Hyoa_reback.ID = lsunid; //Hyoa_reback.hy_fatherid = this.txtfatherid.Value; //Hyoa_reback.hy_senddate = System.DateTime.Now.ToShortDateString(); //Hyoa_reback.hy_senduserid = this.Session["hyuid"].ToString(); //Hyoa_reback.hy_sendusername = this.Session["hyuname"].ToString(); //Hyoa_reback.hy_rebackuserid = lv_userid[i]; //Hyoa_reback.hy_rebackusername = lv_username[i]; //Hyoa_reback.hy_rebackresion = this.txtrebackidea.Text; //Hyoa_reback.hy_rebackdate = ""; //Hyoa_reback.hy_ifreback = ""; //Hyoa_reback.Insert(); String sql = "insert into hyt_reback(ID,hy_fatherid,hy_senddate,hy_senduserid,hy_sendusername,hy_rebackuserid,hy_rebackusername,hy_rebackresion,hy_rebackdate,hy_ifreback) values "; if (Session["conntype"].ToString() == "SQL") { sql += "('" + lsunid + "','" + this.txtfatherid.Value + "','" + System.DateTime.Now.ToShortDateString() + "','" + this.Session["hyuid"].ToString() + "','" + this.Session["hyuname"].ToString() + "','" + lv_userid[i] + "','" + lv_username[i] + "','" + this.txtrebackidea.Text + "','','') "; } if (Session["conntype"].ToString() == "ORACLE") { sql += "('" + lsunid + "','" + this.txtfatherid.Value + "',to_date('" + System.DateTime.Now.ToShortDateString() + "','YYYY-MM-DD HH24:MI:SS'),'" + this.Session["hyuid"].ToString() + "','" + this.Session["hyuname"].ToString() + "','" + lv_userid[i] + "','" + lv_username[i] + "','" + this.txtrebackidea.Text + "','','') "; } Hyoa_global.GetDataTable(sql); string lssqlfatherdoc = "select * from hyc_" + this.txtfathertableid.Text + " where DOCID='" + this.txtfatherid.Value + "'"; DataTable flowmaindt = Hyoa_global.GetDataTable(lssqlfatherdoc); if (flowmaindt.Rows[0]["hy_mudelid"].ToString() == "ldps") { lstxconent = "领导批示件需再反馈!"; } else { lstxconent = "政务督查件需再反馈!"; } Hyoa_global.Senddbsy_global(lsunid, lv_userid[i], lv_username[i], this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "/zwdc/main.aspx?op=modify&mid=" + flowmaindt.Rows[0]["hy_mudelid"].ToString() + "&tableid=" + flowmaindt.Rows[0]["hy_tableid"].ToString() + "&docid=" + flowmaindt.Rows[0]["DOCID"].ToString() + "&pop=1", "待阅", flowmaindt.Rows[0]["hy_mudelid"].ToString(), "待办箱", "一般", lstxconent, "请办理", 0, flowmaindt.Rows[0]["hy_flowid"].ToString(), "tache0002", this.txtfathertableid.Text); } string ls_tip = "保存成功!"; //处理完成后的提示及跳转 //if (this.txtifpop.Value == "") //{ // Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>"); //} //else //{ Response.Write("<script>var fm = window.opener.document.forms[0];fm.txtwhichoperation.value = '1';fm.btn_save.click();window.close();</script>"); //Response.Write("<script>alert('" + ls_tip + "');self.close();</script>"); //} }
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //保存 protected void Button_Save_Click(object sender, EventArgs e) { if (this.Session["hyuid"].ToString() == "") this.Response.Redirect("login.aspx"); string ls_tip = "保存成功!"; //新文档时 //新建时先进行一次保存 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); string sql = ""; if (this.txtop.Value == "add") { if (Session["conntype"].ToString() == "SQL") { sql = "insert into hyc_" + this.hy_tableid.Text + " (DOCID,hy_mudelid,hy_tableid,hy_flowid,hy_flowname,hy_curtacheid,hy_curtachename,hy_curclrid,hy_curclrname,hy_djrid,hy_djrname,hy_djrbmid,hy_djrbmname,hy_djsj,hy_bt,hy_readuserlist,hy_readdatelist) values ("; sql += "'" + this.txtdocid.Value + "','" + this.hy_mudelid.Text + "','" + this.hy_tableid.Text + "','" + this.hy_flowid.Text + "','" + this.hy_flowname.Text + "'"; sql += ",'" + this.hy_curtacheid.Text + "','" + this.hy_curtachename.Text + "','" + this.hy_curclrid.Text + "','" + this.hy_curclrname.Text + "','" + this.hy_djrid.Text + "'"; sql += ",'" + this.hy_djrname.Text + "','" + this.hy_djrbmid.Text + "','" + this.hy_djrbmname.Text + "','" + this.hy_djsj.Text + "','" + this.hy_bt.Text + "'"; sql += ",'','') "; } if (Session["conntype"].ToString() == "ORACLE") { sql = "insert into hyc_" + this.hy_tableid.Text + " (DOCID,hy_mudelid,hy_tableid,hy_flowid,hy_flowname,hy_curtacheid,hy_curtachename,hy_curclrid,hy_curclrname,hy_djrid,hy_djrname,hy_djrbmid,hy_djrbmname,hy_djsj,hy_bt,hy_readuserlist,hy_readdatelist) values ("; sql += "'" + this.txtdocid.Value + "','" + this.hy_mudelid.Text + "','" + this.hy_tableid.Text + "','" + this.hy_flowid.Text + "','" + this.hy_flowname.Text + "'"; sql += ",'" + this.hy_curtacheid.Text + "','" + this.hy_curtachename.Text + "','" + this.hy_curclrid.Text + "','" + this.hy_curclrname.Text + "','" + this.hy_djrid.Text + "'"; sql += ",'" + this.hy_djrname.Text + "','" + this.hy_djrbmid.Text + "','" + this.hy_djrbmname.Text + "',to_date('" + this.hy_djsj.Text + "','YYYY-MM-DD HH24:MI:SS'),'" + this.hy_bt.Text + "'"; sql += ",'','') "; } Hyoa_global.ExcuteSQL(sql); //插入历史处理表(如果是流程文档) if (txtifhaveflow.Value == "是") { Hyoa_global.Saveflowhistoryinfo_cl_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.hy_curtacheid.Text, this.hy_curtachename.Text, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "", "", "", this.hy_djsj.Text, ""); } } //更新内容 sql = "update hyc_" + this.hy_tableid.Text + " set hy_tableid='" + hy_tableid.Text + "' "; //根据“需要保存的字段”来进行保存 if (txtsavefields.Text != "") { string[] lv_savefields = txtsavefields.Text.Split(','); string[] lv_savefields_sx = txtsavefields_sx.Text.Split(','); string fielddocvalue = ""; for (int i = 0; i < lv_savefields.Length; i++) { if (lv_savefields_sx[i].ToString() == "0") //文本 { if (this.Request.Form[lv_savefields[i].ToString()] != null) { fielddocvalue = this.Request.Form[lv_savefields[i].ToString()].ToString(); sql += ",hyc_" + lv_savefields[i].ToString() + "='" + fielddocvalue + "'"; } } if (lv_savefields_sx[i].ToString() == "1") //日期 { if (this.Request.Form[lv_savefields[i].ToString()] != null) { fielddocvalue = this.Request.Form[lv_savefields[i].ToString()].ToString(); if (Session["conntype"].ToString() == "SQL") { if (fielddocvalue == "") sql += ",hyc_" + lv_savefields[i].ToString() + "=null"; else sql += ",hyc_" + lv_savefields[i].ToString() + "='" + fielddocvalue + "'"; } if (Session["conntype"].ToString() == "ORACLE") { if (fielddocvalue == "") sql += ",hyc_" + lv_savefields[i].ToString() + "=null"; else sql += ",hyc_" + lv_savefields[i].ToString() + "=to_date('" + fielddocvalue + "','YYYY-MM-DD HH24:MI:SS')"; } } } if (lv_savefields_sx[i].ToString() == "3") //数值 { if (this.Request.Form[lv_savefields[i].ToString()] != null) { fielddocvalue = this.Request.Form[lv_savefields[i].ToString()].ToString(); if (fielddocvalue == "") sql += ",hyc_" + lv_savefields[i].ToString() + "=0"; else sql += ",hyc_" + lv_savefields[i].ToString() + "=" + fielddocvalue; } } if (lv_savefields_sx[i].ToString() == "5") //口令 { if (this.Request.Form[lv_savefields[i].ToString()] != null) { fielddocvalue = this.Request.Form[lv_savefields[i].ToString()].ToString(); sql += ",hyc_" + lv_savefields[i].ToString() + "='" + fielddocvalue + "'"; } } if (lv_savefields_sx[i].ToString() == "6") //编辑器 { if (this.Request.Form[lv_savefields[i].ToString()] != null) { fielddocvalue = this.Request.Form[lv_savefields[i].ToString()].ToString(); sql += ",hyc_" + lv_savefields[i].ToString() + "='" + fielddocvalue + "'"; } } if (lv_savefields_sx[i].ToString() == "7") //复选框 { string s = ""; CheckBoxList txfs = (CheckBoxList)this.FindControl(lv_savefields[i].ToString()); foreach (ListItem li in txfs.Items) { if (li.Selected) { if (li.Selected) s += li.Value + ","; } } s = s.TrimEnd(','); sql += ",hyc_" + lv_savefields[i].ToString() + "='" + s + "'"; } if (lv_savefields_sx[i].ToString() == "8") //单选框 { string s = ""; RadioButtonList txfs = (RadioButtonList)this.FindControl(lv_savefields[i].ToString()); foreach (ListItem li in txfs.Items) { if (li.Selected) { if (li.Selected) s += li.Value + ","; } } s = s.TrimEnd(','); sql += ",hyc_" + lv_savefields[i].ToString() + "='" + s + "'"; } } } //保存 if (this.txtwhichoperation.Value == "1") { hylcbctscl(sql); //特殊处理 } //确认 if (this.txtwhichoperation.Value == "111") { sql += ",hy_ifconfirm='1'"; } //取消确认 if (this.txtwhichoperation.Value == "112") { sql += ",hy_ifconfirm='0'"; } //提交 if (this.txtwhichoperation.Value == "2") { //更新主文档 sql += ",hy_curtacheid='" + this.txtnexttacheid.Value + "'"; sql += ",hy_curtachename='" + this.txtnexttachename.Value + "'"; sql += ",hy_curclrid='" + this.txtnextclrid.Value + "'"; sql += ",hy_curclrname='" + this.txtnextclrname.Value + "'"; //---- 添加当前环节的处理时间 ---- start HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocidtacheid(this.txtdocid.Value, this.hy_curtacheid.Text); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") { Hyoa_flowhistoryinfo_cl.hy_clsj = System.DateTime.Now.ToString(); } else { Hyoa_flowhistoryinfo_cl.hy_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString(); } Hyoa_flowhistoryinfo_cl.Update(); } //---- 添加当前环节的处理时间 ---- end ////////////////////如果后续环节选择了“结束”,则不需要发待办事宜和短消息 start////////////////////// HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); if (this.txtnexttacheid.Value != "**") { //--- 创建后续处理的处理记录+建立处理人待办事宜 ---- start Hyoa_global.Saveflowhistoryinfo_cl_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.txtnexttacheid.Value, this.txtnexttachename.Value, this.txtnextclrid.Value, this.txtnextclrname.Value, "", this.txtnextcyrid.Value, this.txtnextcyrname.Value, System.DateTime.Now.ToString(), ""); //待办事宜、短信、即时消息 string[] lv_dbrid = this.txtnextclrid.Value.Split(new Char[] { ',' }); string[] lv_dbrname = this.txtnextclrname.Value.Split(new Char[] { ',' }); for (var i = 0; i < lv_dbrid.Length; i++) { if (lv_dbrid[i].ToString() != "") { //得到当前用户手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); //得到后续处理人手机号 string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(lv_dbrid[i].ToString()); //给后续处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(this.txtdocid.Value, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1", "待办", this.hy_mudelid.Text, "待办箱", "一般", this.hy_bt.Text, "请办理", 0, this.hy_flowid.Text, this.txtnexttacheid.Value, this.hy_tableid.Text); //给后续处理人发送即时消息(提醒) if (this.txtisSendjstx_clr.Value == "1") { Hyoa_global.Sendjstx_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.hy_mudelid.Text, this.hy_bt.Text, 0, this.hy_tableid.Text); } //给后续处理人发送短信(提醒) if (this.txtisSendsms_clr.Value == "1") { Hyoa_global.Sendsms_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), cb_fsrsjh, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_jsrsjh, this.hy_mudelid.Text, this.hy_bt.Text, 1, "", "", 0, this.hy_tableid.Text); } } } //--- 创建后续处理的处理记录+建立处理人待办事宜 ---- end //--- 创建后续传阅记录+建立待办事宜 ---- start string[] lv_cyrid = this.txtnextcyrid.Value.Split(new Char[] { ',' }); string[] lv_cyrname = this.txtnextcyrname.Value.Split(new Char[] { ',' }); for (var i = 0; i < lv_cyrid.Length; i++) { if (lv_cyrid[i].ToString() != "") { //建立传阅数据 Hyoa_global.Saveflowhistoryinfo_cy_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.txtnexttacheid.Value, this.txtnexttachename.Value, lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), "", System.DateTime.Now.ToString()); //待办事宜、短信、即时消息 //得到当前用户手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); //得到后续传阅人手机号 string cb_cyrsjh = Hyoa_user.GetMobilebyuserid(lv_cyrid[i].ToString()); //给后续处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(this.txtdocid.Value, lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1", "待阅", this.hy_mudelid.Text, "待办箱", "一般", this.hy_bt.Text, "请阅读", 0, this.hy_flowid.Text, this.txtnexttacheid.Value, this.hy_tableid.Text); //给后续处理人发送即时消息(提醒) if (this.txtisSendjstx_cyr.Value == "1") { Hyoa_global.Sendjstx_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), this.hy_mudelid.Text, this.hy_bt.Text, 0, this.hy_tableid.Text); } //给后续处理人发送短信(提醒) if (this.txtisSendsms_cyr.Value == "1") { Hyoa_global.Sendsms_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), cb_fsrsjh, lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), cb_cyrsjh, this.hy_mudelid.Text, this.hy_bt.Text, 1, "", "", 0, this.hy_tableid.Text); } } } //--- 创建后续传阅记录+建立待办事宜 ---- end } ////////////////////如果后续环节选择了“结束”,则不需要发待办事宜和短消息 start////////////////////// //--- 当前处理人的待办事宜转已办 ---- start Hyoa_dbsy.Dbsytoybbydocidtacheiduserid(this.txtdocid.Value, this.hy_curtacheid.Text, this.Session["hyuid"].ToString()); //--- 当前处理人的待办事宜转已办 ---- end ls_tip = "文档已成功发送到[" + this.txtnexttachename.Value + "]环节"; hylctjtscl(sql);//特殊处理 } //收回 if (this.txtwhichoperation.Value == "3") { //得到上个环节处理人 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value); if (dt_clinfo.Rows.Count > 1) { //删除当前处理人员的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy_sh = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy_sh.DeleteByDocid_flowid_tacheid_userid(this.txtdocid.Value, dt_clinfo.Rows[0]["hy_flowid"].ToString(), dt_clinfo.Rows[0]["hy_tacheid"].ToString(), dt_clinfo.Rows[0]["hy_clrid"].ToString()); string ls_lastclrid = dt_clinfo.Rows[1]["hy_clrid"].ToString(); //上个环节处理人ID string ls_lastclrname = dt_clinfo.Rows[1]["hy_clrname"].ToString(); //上个环节处理人中文名 string ls_lastcldoc = dt_clinfo.Rows[1]["ID"].ToString(); //上个环节处理的记录ID string ls_lasttacheid = dt_clinfo.Rows[1]["hy_tacheid"].ToString(); //上个环节处理环节ID string ls_lasttachename = dt_clinfo.Rows[1]["hy_tachename"].ToString(); //上个环节处理环节名称 string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID dt_clinfo.Clear(); //删除当前处理的记录 Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.Delete(); //清空上个环节处理时间,更新创建时间 Hyoa_flowhistoryinfo_cl.ID = ls_lastcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ""; Hyoa_flowhistoryinfo_cl.hy_createtime = System.DateTime.Now.ToString(); Hyoa_flowhistoryinfo_cl.Update_sh(); //更新主文档中的当前环节ID、当前环节名称、当前处理人ID和中文名 sql += ",hy_curtacheid='" + ls_lasttacheid + "'"; sql += ",hy_curtachename='" + ls_lasttachename + "'"; sql += ",hy_curclrid='" + ls_lastclrid + "'"; sql += ",hy_curclrname='" + ls_lastclrname + "'"; ls_tip = "文档已成功收回到[" + ls_lasttachename + "]环节"; hylcshtscl(sql);//特殊处理 } } //退回 if (this.txtwhichoperation.Value == "4") { //更新主文档 sql += ",hy_curtacheid='" + this.txtnexttacheid.Value + "'"; sql += ",hy_curtachename='" + this.txtnexttachename.Value + "'"; sql += ",hy_curclrid='" + this.txtnextclrid.Value + "'"; sql += ",hy_curclrname='" + this.txtnextclrname.Value + "'"; //处理历史处理记录 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID string ls_clsj = ""; //当前处理的记录处理时间 if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") ls_clsj = System.DateTime.Now.ToString(); else ls_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString(); dt_clinfo.Clear(); Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ls_clsj; Hyoa_flowhistoryinfo_cl.Update(); } //新建一条处理记录 Hyoa_global.Saveflowhistoryinfo_cl_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.txtnexttacheid.Value, this.txtnexttachename.Value, this.txtnextclrid.Value, this.txtnextclrname.Value, "", "", "", System.DateTime.Now.ToString(), "是"); //处理待办事宜 //转已办-当前处理人的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy.Dbsytoybbydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); //得到发送人手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); //(考虑多人的情况) string[] lv_dbrid = this.txtnextclrid.Value.Split(new Char[] { ',' }); string[] lv_dbrname = this.txtnextclrname.Value.Split(new Char[] { ',' }); for (var i = 0; i < lv_dbrid.Length; i++) { if (lv_dbrid[i].ToString() != "") { //得到接收人手机号 string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(lv_dbrid[i].ToString()); HyoaClass.Hyoa_global Hyoa_global2 = new HyoaClass.Hyoa_global(); //给退回到的处理人发送一个新的待办事宜(提醒) Hyoa_global2.Senddbsy_global(this.txtdocid.Value, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1", "待办", this.hy_mudelid.Text, "待办箱", "一般", this.hy_bt.Text, "请办理", 0, this.hy_flowid.Text, this.txtnexttacheid.Value, this.hy_tableid.Text); //给退回到的处理人发送即时消息(提醒) if (this.txtisSendjstx.Value == "1") { Hyoa_global.Sendjstx_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.hy_mudelid.Text, this.hy_bt.Text, 0, this.hy_tableid.Text); } //给退回到的处理人发送短信(提醒) if (this.txtisSendsms.Value == "1") { Hyoa_global.Sendsms_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), cb_fsrsjh, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_jsrsjh, this.hy_mudelid.Text, this.hy_bt.Text, 1, "", "", 0, this.hy_tableid.Text); } } } ls_tip = "已成功退回到[" + this.txtnexttachename.Value + "]环节"; hylcthtscl(sql);//特殊处理 } //多人处理 if (this.txtwhichoperation.Value == "5") { //更新主文档 string ls_newclrid = Hyoa_global.MoveOneString_dh(this.hy_curclrid.Text, this.Session["hyuid"].ToString()); string ls_newclrname = Hyoa_global.MoveOneString_dh(this.hy_curclrname.Text, this.Session["hyuname"].ToString()); sql += ",hy_curclrid='" + ls_newclrid + "'"; sql += ",hy_curclrname='" + ls_newclrname + "'"; //处理处理记录 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID string ls_clsj = ""; //当前处理的记录处理时间 if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") ls_clsj = System.DateTime.Now.ToString(); else ls_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString(); dt_clinfo.Clear(); Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ls_clsj; Hyoa_flowhistoryinfo_cl.Update(); } //处理待办事宜 //转已办-当前处理人的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy.Dbsytoybbydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); ls_tip = "提交成功,当前环节还需要[" + ls_newclrname + "]进行办理"; hylcdrcltscl(sql);//特殊处理 } //催办 if (this.txtwhichoperation.Value == "6") { string cb_docid = this.txtdocid.Value; string cb_dbrid = this.hy_curclrid.Text; string cb_dbrname = this.hy_curclrname.Text; string cb_fsrid = this.Session["hyuid"].ToString(); string cb_fsrname = this.Session["hyuname"].ToString(); string cb_url = "main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1"; string cb_property = "催办"; string cb_mudelid = this.hy_mudelid.Text; string cb_foldername = "待办箱"; string cb_hj = "一般"; string cb_bt = this.txtcbideas.Value + "-" + this.hy_bt.Text; string cb_subbt = "请阅读"; float cb_ifyb = 0; string cb_flowid = this.hy_flowid.Text; string cb_tacheid = this.hy_curtacheid.Text; string cb_from = this.hy_mudelid.Text; //得到发送人手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(cb_fsrid); //得到接收人手机号 string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(cb_dbrid); //给当前处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(cb_docid, cb_dbrid, cb_dbrname, cb_fsrid, cb_fsrname, cb_url, cb_property, cb_mudelid, cb_foldername, cb_hj, cb_bt, cb_subbt, cb_ifyb, cb_flowid, cb_tacheid, this.hy_tableid.Text); //给当前处理人发送即时消息(提醒) if (this.txtisSendjstx.Value == "1") { Hyoa_global.Sendjstx_global(cb_docid, cb_fsrid, cb_fsrname, cb_dbrid, cb_dbrname, cb_from, cb_bt, 0, this.hy_tableid.Text); } //给当前处理人发送短信(提醒) if (this.txtisSendsms.Value == "1") { Hyoa_global.Sendsms_global(cb_docid, cb_fsrid, cb_fsrname, cb_fsrsjh, cb_dbrid, cb_dbrname, cb_jsrsjh, cb_from, cb_bt, 1, "", "", 0, this.hy_tableid.Text); } ls_tip = "催办成功!"; hylccbtscl(sql);//特殊处理 } //流程结束时的提交 if (this.txtwhichoperation.Value == "7") { //更新主文档 sql += ",hy_curtacheid='**'"; sql += ",hy_curtachename='结束'"; sql += ",hy_curclrid=''"; sql += ",hy_curclrname=''"; //更新处理表 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID string ls_clsj = ""; //当前处理的记录处理时间 if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") ls_clsj = System.DateTime.Now.ToString(); else ls_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString(); dt_clinfo.Clear(); Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ls_clsj; Hyoa_flowhistoryinfo_cl.Update(); } ////流程结束时删除所有该文档对应的待办事宜 //HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); //Hyoa_dbsy.Deletebydocid(this.txtdocid.Value); //处理待办事宜 //转已办-当前处理人的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy.Dbsytoybbydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); ls_tip = "流程结束!"; hylcjstscl(sql);//特殊处理 } //收文阅件分发 if (this.txtwhichoperation.Value == "8") { string cb_docid = this.txtdocid.Value; string cb_dbrid = this.hy_curclrid.Text; string cb_dbrname = this.hy_curclrname.Text; string cb_fsrid = this.Session["hyuid"].ToString(); string cb_fsrname = this.Session["hyuname"].ToString(); string cb_url = "main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1"; string cb_property = "待阅"; string cb_mudelid = this.hy_mudelid.Text; string cb_foldername = "待办箱"; string cb_hj = "一般"; string cb_bt = this.hy_bt.Text; string cb_subbt = "请阅读"; float cb_ifyb = 0; string cb_flowid = this.hy_flowid.Text; string cb_tacheid = this.hy_curtacheid.Text; string cb_from = this.hy_mudelid.Text; string[] lv_dbrid = this.txtswly_dbsy_userids.Text.Split(new Char[] { '+' }); string[] lv_dbrname = this.txtswly_dbsy_usernames.Text.Split(new Char[] { '+' }); for (var i = 0; i < lv_dbrid.Length; i++) { if (lv_dbrid[i].ToString() != "") { //得到当前用户手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); //得到后续处理人手机号 string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(lv_dbrid[i].ToString()); //给后续处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(cb_docid, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_fsrid, cb_fsrname, cb_url, cb_property, cb_mudelid, cb_foldername, cb_hj, cb_bt, cb_subbt, 0, cb_flowid, cb_tacheid, this.hy_tableid.Text); //给后续处理人发送即时消息(提醒) Hyoa_global.Sendjstx_global(cb_docid, cb_fsrid, cb_fsrname, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_mudelid, cb_bt, 0, this.hy_tableid.Text); //给后续处理人发送短信(提醒) Hyoa_global.Sendsms_global(cb_docid, cb_fsrid, cb_fsrname, cb_fsrsjh, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_jsrsjh, cb_mudelid, cb_bt, 1, "", "", 0, this.hy_tableid.Text); //在hyp_flowhistoryinfo_cy中添加传阅信息 string sql_cy = "select * from hyp_flowhistoryinfo_cy where DOCID='" + this.txtdocid.Value + "' and hy_cyrid='" + lv_dbrid[i] + "' order by hy_createtime DESC "; DataTable dt_cy = Hyoa_global.GetDataTable(sql_cy); if (dt_cy.Rows.Count > 0) { } else { HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy(); Hyoa_flowhistoryinfo_cy.ID = Hyoa_global.GetRandom(); Hyoa_flowhistoryinfo_cy.DOCID = this.txtdocid.Value; Hyoa_flowhistoryinfo_cy.hy_flowid = this.hy_flowid.Text; Hyoa_flowhistoryinfo_cy.hy_flowname = this.hy_flowname.Text; Hyoa_flowhistoryinfo_cy.hy_tacheid = this.hy_curtacheid.Text; Hyoa_flowhistoryinfo_cy.hy_tachename = this.hy_curtachename.Text; Hyoa_flowhistoryinfo_cy.hy_cyrid = lv_dbrid[i]; Hyoa_flowhistoryinfo_cy.hy_cyrname = lv_dbrname[i]; Hyoa_flowhistoryinfo_cy.hy_ydsj = ""; Hyoa_flowhistoryinfo_cy.hy_createtime = System.DateTime.Now.ToString(); Hyoa_flowhistoryinfo_cy.Insert(); } } } //在当前环节处理的记录中添加传阅信息,主要用于列表的显示控制 string sql_cl = "select * from hyp_flowhistoryinfo_cl where DOCID='" + this.txtdocid.Value + "' order by hy_createtime DESC "; DataTable dt_cl = Hyoa_global.GetDataTable(sql_cl); if (dt_cl.Rows.Count > 0) { if (dt_cl.Rows[0]["hy_cyrid"].ToString() == "") { sql_cl = "update hyp_flowhistoryinfo_cl set hy_cyrid='" + this.txtswly_dbsy_userids.Text.Replace("+", ",") + "',hy_cyrname='" + this.txtswly_dbsy_usernames.Text.Replace("+", ",") + "' where ID='" + dt_cl.Rows[0]["ID"].ToString() + "'"; Hyoa_global.ExcuteSQL(sql_cl); } else { if (Session["conntype"].ToString() == "SQL") { sql_cl = "update hyp_flowhistoryinfo_cl set hy_cyrid=hy_cyrid+'," + this.txtswly_dbsy_userids.Text.Replace("+", ",") + "',hy_cyrname=hy_cyrname+'," + this.txtswly_dbsy_usernames.Text.Replace("+", ",") + "' where ID='" + dt_cl.Rows[0]["ID"].ToString() + "'"; } if (Session["conntype"].ToString() == "ORACLE") { sql_cl = "update hyp_flowhistoryinfo_cl set hy_cyrid=CONCAT(hy_cyrid,'," + this.txtswly_dbsy_userids.Text.Replace("+", ",") + "'),hy_cyrname=CONCAT(hy_cyrname,'," + this.txtswly_dbsy_usernames.Text.Replace("+", ",") + ")' where ID='" + dt_cl.Rows[0]["ID"].ToString() + "'"; } Hyoa_global.ExcuteSQL(sql_cl); } } ls_tip = "阅件分发成功!"; } //在主表单内嵌列表的功能中,保存、提交和确认子表单时,需要将父文档的DOCID保存到当前记录的hy_motherid中 //ADD BY XF 2011-11-17 if (this.txtwhichoperation.Value == "1" || this.txtwhichoperation.Value == "2" || this.txtwhichoperation.Value == "111") { if (Request.QueryString["op"] != null) { if (Request.QueryString["op"].ToString() != "") { if (Request.QueryString["motherid"] != null) { if (Request.QueryString["motherid"].ToString() != "") { sql += ",hy_motherid='" + Request.QueryString["motherid"].ToString() + "'"; } } } } } sql += " where DOCID='" + this.txtdocid.Value + "'"; Hyoa_global.ExcuteSQL(sql); //处理完成后的提示及跳转(增加刷新附件功能) if (this.txtifsxfj.Text == "1") { Response.Write("<script>window.location='wap_main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&url=" + this.txturl.Value + "'</script>"); } else { if (this.txtifpop.Value == "") { Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>"); } else { Response.Write("<script>alert('" + ls_tip + "');window.location='wap_list.aspx?mid=dbsy'</script>"); } } }
//流程流程结束时的特殊处理 private void hylcjstscl(string sql) { //流程结束给登记人发送提醒start string cb_docid = this.txtdocid.Value; string cb_dbrid = this.hy_djrid.Text; string cb_dbrname = this.hy_djrname.Text; string cb_fsrid = this.Session["hyuid"].ToString(); string cb_fsrname = this.Session["hyuname"].ToString(); string cb_url = "main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1"; string cb_property = "待阅"; string cb_mudelid = this.hy_mudelid.Text; string cb_foldername = "待阅箱"; string cb_hj = "一般"; string cb_bt = this.hy_bt.Text; string cb_subbt = "[流程已结束]"; float cb_ifyb = 0; string cb_flowid = this.hy_flowid.Text; string cb_tacheid = this.hy_curtacheid.Text; string cb_from = this.hy_mudelid.Text; //得到发送人手机号 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); //HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); //string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(cb_fsrid); ////得到接收人手机号 //string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(cb_dbrid); //给当前处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(cb_docid, cb_dbrid, cb_dbrname, cb_fsrid, cb_fsrname, cb_url, cb_property, cb_mudelid, cb_foldername, cb_hj, cb_bt, cb_subbt, cb_ifyb, cb_flowid, cb_tacheid, this.hy_tableid.Text); //给当前处理人发送即时消息(提醒) Hyoa_global.Sendjstx_global(cb_docid, cb_fsrid, cb_fsrname, cb_dbrid, cb_dbrname, cb_from, cb_bt, 0, this.hy_tableid.Text); //流程结束给登记人发送提醒end ////会议管理的最后环节发信息提醒给登记人*****不通用start //if (this.hy_curtacheid.Text == "tache0004" & this.hy_mudelid.Text == "hysgl" & this.hy_tableid.Text == "02548a1e-cfed-4ee5-afb4-054da97ce9a7") //{ // hysendxx(this.hy_field7.Text, this.hy_field2.Text); //会议管理专用 //} ////会议管理的最后环节发信息提醒给登记人*****不通用end /////物品领用,最后环节将库存减去当前领用数量start //if (this.hy_mudelid.Text == "bgyply" & this.hy_tableid.Text == "cbe421b0-21dd-4e49-8fa7-0c0d34934304") //{ // hywply(this.txtdocid.Value); //} /////物品领用,最后环节将库存减去当前领用数量end }
//保存 private void DataPlay() { //hy_json = "{\"success\":true,\"total\":\"60\",\"rows\":[{\"hy_mudelid\":\"111\",\"hy_mudelname\":\"1111\",\"hy_roleid\":\"111111\",\"hy_qqroleid\":\"111111\",\"hy_isenabled\":\"111111\"}]}"; string hy_json = ""; string ls_success = "true"; //调用方法成功 string ls_flag = "0"; //失败 string ls_tip = "保存成功!"; string txtop = ""; if (Request.Form["txtop"] != null) txtop = Request.Form["txtop"].ToString(); string hy_bt = ""; if (Request.Form["hy_bt"] != null) hy_bt = Request.Form["hy_bt"].ToString(); //新文档时 //新建时先进行一次保存 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); string sql = ""; if (txtop == "add") { //处理特殊字符 hy_bt = ReplaceString_Tszf(hy_bt); if (Session["conntype"].ToString() == "SQL") { //edited by xf 20140625 sql = "insert into hyc_" + Request.Form["hy_tableid"].ToString() + " (DOCID,hy_mudelid,hy_tableid,hy_flowid,hy_flowname,hy_curtacheid,hy_curtachename,hy_curclrid,hy_curclrname,hy_djrid,hy_djrname,hy_djrbmid,hy_djrbmname,hy_djsj,hy_bt,hy_readuserlist,hy_readdatelist,hy_clrylist,hy_cyrylist) values ("; sql += "'" + Request.Form["txtdocid"].ToString() + "','" + Request.Form["hy_mudelid"].ToString() + "','" + Request.Form["hy_tableid"].ToString() + "','" + Request.Form["hy_flowid"].ToString() + "','" + Request.Form["hy_flowname"].ToString() + "'"; sql += ",'" + Request.Form["hy_curtacheid"].ToString() + "','" + Request.Form["hy_curtachename"].ToString() + "','" + Request.Form["hy_curclrid"].ToString() + "','" + Request.Form["hy_curclrname"].ToString() + "','" + Request.Form["hy_djrid"].ToString() + "'"; sql += ",'" + Request.Form["hy_djrname"].ToString() + "','" + Request.Form["hy_djrbmid"].ToString() + "','" + Request.Form["hy_djrbmname"].ToString() + "','" + Request.Form["hy_djsj"].ToString() + "','" + Request.Form["hy_bt"].ToString() + "'"; sql += ",'','','," + Session["hyuid"].ToString() + ",',',') "; } if (Session["conntype"].ToString() == "ORACLE") { //edited by xf 20140625 sql = "insert into hyc_" + Request.Form["hy_tableid"].ToString() + " (DOCID,hy_mudelid,hy_tableid,hy_flowid,hy_flowname,hy_curtacheid,hy_curtachename,hy_curclrid,hy_curclrname,hy_djrid,hy_djrname,hy_djrbmid,hy_djrbmname,hy_djsj,hy_bt,hy_readuserlist,hy_readdatelist,hy_clrylist,hy_cyrylist) values ("; sql += "'" + Request.Form["txtdocid"].ToString() + "','" + Request.Form["hy_mudelid"].ToString() + "','" + Request.Form["hy_tableid"].ToString() + "','" + Request.Form["hy_flowid"].ToString() + "','" + Request.Form["hy_flowname"].ToString() + "'"; sql += ",'" + Request.Form["hy_curtacheid"].ToString() + "','" + Request.Form["hy_curtachename"].ToString() + "','" + Request.Form["hy_curclrid"].ToString() + "','" + Request.Form["hy_curclrname"].ToString() + "','" + Request.Form["hy_djrid"].ToString() + "'"; sql += ",'" + Request.Form["hy_djrname"].ToString() + "','" + Request.Form["hy_djrbmid"].ToString() + "','" + Request.Form["hy_djrbmname"].ToString() + "',to_date('" + Request.Form["hy_djsj"].ToString() + "','YYYY-MM-DD HH24:MI:SS'),'" + Request.Form["hy_bt"].ToString() + "'"; sql += ",'','','," + Session["hyuid"].ToString() + ",',',') "; } Hyoa_global.ExcuteSQL(sql); //插入历史处理表(如果是流程文档) if (Request.Form["txtifhaveflow"].ToString() == "是") { Hyoa_global.Saveflowhistoryinfo_cl_global(Request.Form["txtdocid"].ToString(), Request.Form["hy_flowid"].ToString(), Request.Form["hy_flowname"].ToString(), Request.Form["hy_curtacheid"].ToString(), Request.Form["hy_curtachename"].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "", "", "", Request.Form["hy_djsj"].ToString(), ""); } } //更新内容 sql = "update hyc_" + Request.Form["hy_tableid"].ToString() + " set hy_tableid='" + Request.Form["hy_tableid"].ToString() + "',hy_bt='" + Request.Form["hy_bt"].ToString() + "' "; //根据“需要保存的字段”来进行保存 if (Request.Form["txtsavefields"].ToString() != "") { string[] lv_savefields = Request.Form["txtsavefields"].ToString().Split(','); string[] lv_savefields_sx = Request.Form["txtsavefields_sx"].ToString().Split(','); string fielddocvalue = ""; for (int i = 0; i < lv_savefields.Length; i++) { if (lv_savefields_sx[i].ToString() == "0") //文本 { if (this.Request.Form[lv_savefields[i].ToString()] != null) { fielddocvalue = this.Request.Form[lv_savefields[i].ToString()].ToString(); fielddocvalue = ReplaceString_Tszf(fielddocvalue); sql += ",hyc_" + lv_savefields[i].ToString() + "='" + fielddocvalue + "'"; } } if (lv_savefields_sx[i].ToString() == "1") //日期 { if (this.Request.Form[lv_savefields[i].ToString()] != null) { fielddocvalue = this.Request.Form[lv_savefields[i].ToString()].ToString(); if (Session["conntype"].ToString() == "SQL") { if (fielddocvalue == "") sql += ",hyc_" + lv_savefields[i].ToString() + "=null"; else sql += ",hyc_" + lv_savefields[i].ToString() + "='" + fielddocvalue + "'"; } if (Session["conntype"].ToString() == "ORACLE") { if (fielddocvalue == "") sql += ",hyc_" + lv_savefields[i].ToString() + "=null"; else sql += ",hyc_" + lv_savefields[i].ToString() + "=to_date('" + fielddocvalue + "','YYYY-MM-DD HH24:MI:SS')"; } } } if (lv_savefields_sx[i].ToString() == "3") //数值 { if (this.Request.Form[lv_savefields[i].ToString()] != null) { fielddocvalue = this.Request.Form[lv_savefields[i].ToString()].ToString(); if (fielddocvalue == "") sql += ",hyc_" + lv_savefields[i].ToString() + "=0"; else sql += ",hyc_" + lv_savefields[i].ToString() + "=" + fielddocvalue; } } if (lv_savefields_sx[i].ToString() == "5") //口令 { if (this.Request.Form[lv_savefields[i].ToString()] != null) { fielddocvalue = this.Request.Form[lv_savefields[i].ToString()].ToString(); fielddocvalue = ReplaceString_Tszf(fielddocvalue); sql += ",hyc_" + lv_savefields[i].ToString() + "='" + fielddocvalue + "'"; } } if (lv_savefields_sx[i].ToString() == "6") //编辑器 { if (this.Request.Form[lv_savefields[i].ToString()] != null) { fielddocvalue = this.Request.Form[lv_savefields[i].ToString()].ToString(); fielddocvalue = ReplaceString_Tszf(fielddocvalue); sql += ",hyc_" + lv_savefields[i].ToString() + "='" + fielddocvalue + "'"; } } if (lv_savefields_sx[i].ToString() == "7") //复选框 { //string s = ""; //CheckBoxList txfs = (CheckBoxList)this.FindControl(lv_savefields[i].ToString()); //foreach (ListItem li in txfs.Items) //{ // if (li.Selected) // { // if (li.Selected) s += li.Value + ","; // } //} //s = s.TrimEnd(','); //s = ReplaceString_Tszf(s); //sql += ",hyc_" + lv_savefields[i].ToString() + "='" + s + "'"; if (this.Request.Form[lv_savefields[i].ToString()] != null) { fielddocvalue = this.Request.Form[lv_savefields[i].ToString()].ToString(); fielddocvalue = ReplaceString_Tszf(fielddocvalue); sql += ",hyc_" + lv_savefields[i].ToString() + "='" + fielddocvalue + "'"; } } if (lv_savefields_sx[i].ToString() == "8") //单选框 { //string s = ""; //RadioButtonList txfs = (RadioButtonList)this.FindControl(lv_savefields[i].ToString()); //foreach (ListItem li in txfs.Items) //{ // if (li.Selected) // { // if (li.Selected) s += li.Value + ","; // } //} //s = s.TrimEnd(','); //s = ReplaceString_Tszf(s); //sql += ",hyc_" + lv_savefields[i].ToString() + "='" + s + "'"; if (this.Request.Form[lv_savefields[i].ToString()] != null) { fielddocvalue = this.Request.Form[lv_savefields[i].ToString()].ToString(); fielddocvalue = ReplaceString_Tszf(fielddocvalue); sql += ",hyc_" + lv_savefields[i].ToString() + "='" + fielddocvalue + "'"; } } if (lv_savefields_sx[i].ToString() == "9") //意见 { if (this.Request.Form[lv_savefields[i].ToString()] != null) { fielddocvalue = this.Request.Form[lv_savefields[i].ToString()].ToString(); fielddocvalue = ReplaceString_Tszf(fielddocvalue); if (fielddocvalue != "") { HyoaClass.Hyoa_yj Hyoa_yj = new HyoaClass.Hyoa_yj(); Hyoa_yj.yjid = Hyoa_global.GetRandom(); Hyoa_yj.hy_tableid = Request.Form["hy_tableid"].ToString(); Hyoa_yj.hy_fatherid = Request.Form["txtdocid"].ToString(); Hyoa_yj.hy_fieldid = lv_savefields[i].ToString(); Hyoa_yj.hy_yjuserid = Session["hyuid"].ToString(); Hyoa_yj.hy_yjusername = Session["hyuname"].ToString(); Hyoa_yj.hy_yjdeptid = Session["hydeptid"].ToString(); Hyoa_yj.hy_yjdeptname = Session["hydeptname"].ToString(); Hyoa_yj.hy_yjtime = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); Hyoa_yj.hy_yjbody = fielddocvalue; Hyoa_yj.hy_yjip = HttpContext.Current.Request.UserHostAddress; Hyoa_yj.hy_yjifshow = ""; Hyoa_yj.Insert(); } } } } } //保存 if (Request.Form["txtwhichoperation"].ToString() == "1") { hylcbctscl(sql); //特殊处理 } //确认 if (Request.Form["txtwhichoperation"].ToString() == "111") { sql += ",hy_ifconfirm='1'"; } //取消确认 if (Request.Form["txtwhichoperation"].ToString() == "112") { sql += ",hy_ifconfirm='0'"; } //提交 if (Request.Form["txtwhichoperation"].ToString() == "2") { //更新主文档 sql += ",hy_curtacheid='" + Request.Form["txtnexttacheid"].ToString() + "'"; sql += ",hy_curtachename='" + Request.Form["txtnexttachename"].ToString() + "'"; sql += ",hy_curclrid='" + Request.Form["txtnextclrid"].ToString() + "'"; sql += ",hy_curclrname='" + Request.Form["txtnextclrname"].ToString() + "'"; //---- 添加当前环节的处理时间 ---- start HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocidtacheid(Request.Form["txtdocid"].ToString(), Request.Form["hy_curtacheid"].ToString()); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") { Hyoa_flowhistoryinfo_cl.hy_clsj = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } else { Hyoa_flowhistoryinfo_cl.hy_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } Hyoa_flowhistoryinfo_cl.Update(); } //---- 添加当前环节的处理时间 ---- end ////////////////////如果后续环节选择了“结束”,则不需要发待办事宜和短消息 start////////////////////// HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); if (Request.Form["txtnexttacheid"].ToString() != "**") { //--- 创建后续处理的处理记录+建立处理人待办事宜 ---- start Hyoa_global.Saveflowhistoryinfo_cl_global(Request.Form["txtdocid"].ToString(), Request.Form["hy_flowid"].ToString(), Request.Form["hy_flowname"].ToString(), Request.Form["txtnexttacheid"].ToString(), Request.Form["txtnexttachename"].ToString(), Request.Form["txtnextclrid"].ToString(), Request.Form["txtnextclrname"].ToString(), "", Request.Form["txtnextcyrid"].ToString(), Request.Form["txtnextcyrname"].ToString(), System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), ""); //待办事宜、短信、即时消息 string[] lv_dbrid = Request.Form["txtnextclrid"].ToString().Split(new Char[] { ',' }); string[] lv_dbrname = Request.Form["txtnextclrname"].ToString().Split(new Char[] { ',' }); for (var i = 0; i < lv_dbrid.Length; i++) { if (lv_dbrid[i].ToString() != "") { //得到当前用户手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); //得到后续处理人手机号 string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(lv_dbrid[i].ToString()); //给后续处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(Request.Form["txtdocid"].ToString(), lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "main.aspx?op=modify&mid=" + Request.Form["hy_mudelid"].ToString() + "&tableid=" + Request.Form["hy_tableid"].ToString() + "&docid=" + Request.Form["txtdocid"].ToString() + "&pop=1", "待办", Request.Form["hy_mudelid"].ToString(), "待办箱", "一般", Request.Form["hy_bt"].ToString(), "请办理", 0, Request.Form["hy_flowid"].ToString(), Request.Form["txtnexttacheid"].ToString(), Request.Form["hy_tableid"].ToString()); //给后续处理人发送即时消息(提醒) if (Request.Form["txtisSendjstx_clr"].ToString() == "1") { Hyoa_global.Sendjstx_global(Request.Form["txtdocid"].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), Request.Form["hy_mudelid"].ToString(), Request.Form["hy_bt"].ToString(), 0, Request.Form["hy_tableid"].ToString()); } //给后续处理人发送短信(提醒) if (Request.Form["txtisSendsms_clr"].ToString() == "1") { Hyoa_global.Sendsms_global(Request.Form["txtdocid"].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), cb_fsrsjh, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_jsrsjh, Request.Form["hy_mudelid"].ToString(), Request.Form["hy_bt"].ToString(), 1, "", "", 0, Request.Form["hy_tableid"].ToString()); } } } //--- 创建后续处理的处理记录+建立处理人待办事宜 ---- end //--- 创建后续传阅记录+建立待办事宜 ---- start string[] lv_cyrid = Request.Form["txtnextcyrid"].ToString().Split(new Char[] { ',' }); string[] lv_cyrname = Request.Form["txtnextcyrname"].ToString().Split(new Char[] { ',' }); for (var i = 0; i < lv_cyrid.Length; i++) { if (lv_cyrid[i].ToString() != "") { //建立传阅数据 Hyoa_global.Saveflowhistoryinfo_cy_global(Request.Form["txtdocid"].ToString(), Request.Form["hy_flowid"].ToString(), Request.Form["hy_flowname"].ToString(), Request.Form["txtnexttacheid"].ToString(), Request.Form["txtnexttachename"].ToString(), lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), "", System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); //待办事宜、短信、即时消息 //得到当前用户手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); //得到后续传阅人手机号 string cb_cyrsjh = Hyoa_user.GetMobilebyuserid(lv_cyrid[i].ToString()); //给后续处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(Request.Form["txtdocid"].ToString(), lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "main.aspx?op=modify&mid=" + Request.Form["hy_mudelid"].ToString() + "&tableid=" + Request.Form["hy_tableid"].ToString() + "&docid=" + Request.Form["txtdocid"].ToString() + "&pop=1", "待阅", Request.Form["hy_mudelid"].ToString(), "待办箱", "一般", Request.Form["hy_bt"].ToString(), "请阅读", 0, Request.Form["hy_flowid"].ToString(), Request.Form["txtnexttacheid"].ToString(), Request.Form["hy_tableid"].ToString()); //给后续处理人发送即时消息(提醒) if (Request.Form["txtisSendjstx_cyr"].ToString() == "1") { Hyoa_global.Sendjstx_global(Request.Form["txtdocid"].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), Request.Form["hy_mudelid"].ToString(), Request.Form["hy_bt"].ToString(), 0, Request.Form["hy_tableid"].ToString()); } //给后续处理人发送短信(提醒) if (Request.Form["txtisSendsms_cyr"].ToString() == "1") { Hyoa_global.Sendsms_global(Request.Form["txtdocid"].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), cb_fsrsjh, lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), cb_cyrsjh, Request.Form["hy_mudelid"].ToString(), Request.Form["hy_bt"].ToString(), 1, "", "", 0, Request.Form["hy_tableid"].ToString()); } } } //--- 创建后续传阅记录+建立待办事宜 ---- end } ////////////////////如果后续环节选择了“结束”,则不需要发待办事宜和短消息 start////////////////////// //--- 当前处理人的待办事宜转已办 ---- start Hyoa_dbsy.Dbsytoybbydocidtacheiduserid(Request.Form["txtdocid"].ToString(), Request.Form["hy_curtacheid"].ToString(), this.Session["hyuid"].ToString()); //--- 当前处理人的待办事宜转已办 ---- end ls_tip = "文档已成功发送到[" + Request.Form["txtnexttachename"].ToString() + "]环节"; hylctjtscl(sql);//特殊处理 } //收回 if (Request.Form["txtwhichoperation"].ToString() == "3") { //得到上个环节处理人 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(Request.Form["txtdocid"].ToString()); if (dt_clinfo.Rows.Count > 1) { //删除当前处理人员的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy_sh = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy_sh.DeleteByDocid_flowid_tacheid_userid(Request.Form["txtdocid"].ToString(), dt_clinfo.Rows[0]["hy_flowid"].ToString(), dt_clinfo.Rows[0]["hy_tacheid"].ToString(), dt_clinfo.Rows[0]["hy_clrid"].ToString()); string ls_lastclrid = dt_clinfo.Rows[1]["hy_clrid"].ToString(); //上个环节处理人ID string ls_lastclrname = dt_clinfo.Rows[1]["hy_clrname"].ToString(); //上个环节处理人中文名 string ls_lastcldoc = dt_clinfo.Rows[1]["ID"].ToString(); //上个环节处理的记录ID string ls_lasttacheid = dt_clinfo.Rows[1]["hy_tacheid"].ToString(); //上个环节处理环节ID string ls_lasttachename = dt_clinfo.Rows[1]["hy_tachename"].ToString(); //上个环节处理环节名称 string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID dt_clinfo.Clear(); //删除当前处理的记录 Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.Delete(); //清空上个环节处理时间,更新创建时间 Hyoa_flowhistoryinfo_cl.ID = ls_lastcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ""; Hyoa_flowhistoryinfo_cl.hy_createtime = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); Hyoa_flowhistoryinfo_cl.Update_sh(); //更新主文档中的当前环节ID、当前环节名称、当前处理人ID和中文名 sql += ",hy_curtacheid='" + ls_lasttacheid + "'"; sql += ",hy_curtachename='" + ls_lasttachename + "'"; sql += ",hy_curclrid='" + ls_lastclrid + "'"; sql += ",hy_curclrname='" + ls_lastclrname + "'"; ls_tip = "文档已成功收回到[" + ls_lasttachename + "]环节"; hylcshtscl(sql);//特殊处理 } } //退回 if (Request.Form["txtwhichoperation"].ToString() == "4") { //更新主文档 sql += ",hy_curtacheid='" + Request.Form["txtnexttacheid"].ToString() + "'"; sql += ",hy_curtachename='" + Request.Form["txtnexttachename"].ToString() + "'"; sql += ",hy_curclrid='" + Request.Form["txtnextclrid"].ToString() + "'"; sql += ",hy_curclrname='" + Request.Form["txtnextclrname"].ToString() + "'"; //处理历史处理记录 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(Request.Form["txtdocid"].ToString()); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID string ls_clsj = ""; //当前处理的记录处理时间 if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") ls_clsj = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); else ls_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); dt_clinfo.Clear(); Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ls_clsj; Hyoa_flowhistoryinfo_cl.Update(); } //新建一条处理记录 Hyoa_global.Saveflowhistoryinfo_cl_global(Request.Form["txtdocid"].ToString(), Request.Form["hy_flowid"].ToString(), Request.Form["hy_flowname"].ToString(), Request.Form["txtnexttacheid"].ToString(), Request.Form["txtnexttachename"].ToString(), Request.Form["txtnextclrid"].ToString(), Request.Form["txtnextclrname"].ToString(), "", "", "", System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "是"); //处理待办事宜 //转已办-当前处理人的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy.Dbsytoybbydociduserid(Request.Form["txtdocid"].ToString(), this.Session["hyuid"].ToString()); //得到发送人手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); //(考虑多人的情况) string[] lv_dbrid = Request.Form["txtnextclrid"].ToString().Split(new Char[] { ',' }); string[] lv_dbrname = Request.Form["txtnextclrname"].ToString().Split(new Char[] { ',' }); for (var i = 0; i < lv_dbrid.Length; i++) { if (lv_dbrid[i].ToString() != "") { //得到接收人手机号 string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(lv_dbrid[i].ToString()); HyoaClass.Hyoa_global Hyoa_global2 = new HyoaClass.Hyoa_global(); //给退回到的处理人发送一个新的待办事宜(提醒) Hyoa_global2.Senddbsy_global(Request.Form["txtdocid"].ToString(), lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "main.aspx?op=modify&mid=" + Request.Form["hy_mudelid"].ToString() + "&tableid=" + Request.Form["hy_tableid"].ToString() + "&docid=" + Request.Form["txtdocid"].ToString() + "&pop=1", "待办", Request.Form["hy_mudelid"].ToString(), "待办箱", "一般", Request.Form["hy_bt"].ToString(), "请办理", 0, Request.Form["hy_flowid"].ToString(), Request.Form["txtnexttacheid"].ToString(), Request.Form["hy_tableid"].ToString()); //给退回到的处理人发送即时消息(提醒) if (Request.Form["txtisSendjstx"].ToString() == "1") { Hyoa_global.Sendjstx_global(Request.Form["txtdocid"].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), Request.Form["hy_mudelid"].ToString(), Request.Form["hy_bt"].ToString(), 0, Request.Form["hy_tableid"].ToString()); } //给退回到的处理人发送短信(提醒) if (Request.Form["txtisSendsms"].ToString() == "1") { Hyoa_global.Sendsms_global(Request.Form["txtdocid"].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), cb_fsrsjh, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_jsrsjh, Request.Form["hy_mudelid"].ToString(), Request.Form["hy_bt"].ToString(), 1, "", "", 0, Request.Form["hy_tableid"].ToString()); } } } ls_tip = "已成功退回到[" + Request.Form["txtnexttachename"].ToString() + "]环节"; hylcthtscl(sql);//特殊处理 } //多人处理 if (Request.Form["txtwhichoperation"].ToString() == "5") { //更新主文档 string ls_newclrid = Hyoa_global.MoveOneString_dh(Request.Form["hy_curclrid"].ToString(), this.Session["hyuid"].ToString()); string ls_newclrname = Hyoa_global.MoveOneString_dh(Request.Form["hy_curclrname"].ToString(), this.Session["hyuname"].ToString()); sql += ",hy_curclrid='" + ls_newclrid + "'"; sql += ",hy_curclrname='" + ls_newclrname + "'"; //处理处理记录 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(Request.Form["txtdocid"].ToString()); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID string ls_clsj = ""; //当前处理的记录处理时间 if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") ls_clsj = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); else ls_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); dt_clinfo.Clear(); Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ls_clsj; Hyoa_flowhistoryinfo_cl.Update(); } //处理待办事宜 //转已办-当前处理人的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy.Dbsytoybbydociduserid(Request.Form["txtdocid"].ToString(), this.Session["hyuid"].ToString()); ls_tip = "提交成功,当前环节还需要[" + ls_newclrname + "]进行办理"; hylcdrcltscl(sql);//特殊处理 } //催办 if (Request.Form["txtwhichoperation"].ToString() == "6") { string cb_docid = Request.Form["txtdocid"].ToString(); string cb_dbrid = Request.Form["hy_curclrid"].ToString(); string cb_dbrname = Request.Form["hy_curclrname"].ToString(); string cb_fsrid = this.Session["hyuid"].ToString(); string cb_fsrname = this.Session["hyuname"].ToString(); string cb_url = "main.aspx?op=modify&mid=" + Request.Form["hy_mudelid"].ToString() + "&tableid=" + Request.Form["hy_tableid"].ToString() + "&docid=" + Request.Form["txtdocid"].ToString() + "&pop=1"; string cb_property = "催办"; string cb_mudelid = Request.Form["hy_mudelid"].ToString(); string cb_foldername = "待办箱"; string cb_hj = "一般"; string cb_bt = Request.Form["txtcbideas"].ToString() + "-" + Request.Form["hy_bt"].ToString(); string cb_subbt = "请阅读"; float cb_ifyb = 0; string cb_flowid = Request.Form["hy_flowid"].ToString(); string cb_tacheid = Request.Form["hy_curtacheid"].ToString(); string cb_from = Request.Form["hy_mudelid"].ToString(); //得到发送人手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(cb_fsrid); //得到接收人手机号 string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(cb_dbrid); //给当前处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(cb_docid, cb_dbrid, cb_dbrname, cb_fsrid, cb_fsrname, cb_url, cb_property, cb_mudelid, cb_foldername, cb_hj, cb_bt, cb_subbt, cb_ifyb, cb_flowid, cb_tacheid, Request.Form["hy_tableid"].ToString()); //给当前处理人发送即时消息(提醒) if (Request.Form["txtisSendjstx"].ToString() == "1") { Hyoa_global.Sendjstx_global(cb_docid, cb_fsrid, cb_fsrname, cb_dbrid, cb_dbrname, cb_from, cb_bt, 0, Request.Form["hy_tableid"].ToString()); } //给当前处理人发送短信(提醒) if (Request.Form["txtisSendsms"].ToString() == "1") { Hyoa_global.Sendsms_global(cb_docid, cb_fsrid, cb_fsrname, cb_fsrsjh, cb_dbrid, cb_dbrname, cb_jsrsjh, cb_from, cb_bt, 1, "", "", 0, Request.Form["hy_tableid"].ToString()); } ls_tip = "催办成功!"; hylccbtscl(sql);//特殊处理 } //流程结束时的提交 if (Request.Form["txtwhichoperation"].ToString() == "7") { //更新主文档 sql += ",hy_curtacheid='**'"; sql += ",hy_curtachename='结束'"; sql += ",hy_curclrid=''"; sql += ",hy_curclrname=''"; //更新处理表 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(Request.Form["txtdocid"].ToString()); if (dt_clinfo.Rows.Count > 0) { string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID string ls_clsj = ""; //当前处理的记录处理时间 if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "") ls_clsj = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); else ls_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); dt_clinfo.Clear(); Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc; Hyoa_flowhistoryinfo_cl.hy_clsj = ls_clsj; Hyoa_flowhistoryinfo_cl.Update(); } ////流程结束时删除所有该文档对应的待办事宜 //HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); //Hyoa_dbsy.Deletebydocid(Request.Form["txtdocid"].ToString()); //处理待办事宜 //转已办-当前处理人的待办事宜 HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy.Dbsytoybbydociduserid(Request.Form["txtdocid"].ToString(), this.Session["hyuid"].ToString()); ls_tip = "流程结束!"; hylcjstscl(sql);//特殊处理 } //收文阅件分发 if (Request.Form["txtwhichoperation"].ToString() == "8") { string cb_docid = Request.Form["txtdocid"].ToString(); string cb_dbrid = Request.Form["hy_curclrid"].ToString(); string cb_dbrname = Request.Form["hy_curclrname"].ToString(); string cb_fsrid = this.Session["hyuid"].ToString(); string cb_fsrname = this.Session["hyuname"].ToString(); string cb_url = "main.aspx?op=modify&mid=" + Request.Form["hy_mudelid"].ToString() + "&tableid=" + Request.Form["hy_tableid"].ToString() + "&docid=" + Request.Form["txtdocid"].ToString() + "&pop=1"; string cb_property = "待阅"; string cb_mudelid = Request.Form["hy_mudelid"].ToString(); string cb_foldername = "待办箱"; string cb_hj = "一般"; string cb_bt = Request.Form["hy_bt"].ToString(); string cb_subbt = "请阅读"; float cb_ifyb = 0; string cb_flowid = Request.Form["hy_flowid"].ToString(); string cb_tacheid = Request.Form["hy_curtacheid"].ToString(); string cb_from = Request.Form["hy_mudelid"].ToString(); string[] lv_dbrid = Request.Form["txtswly_dbsy_userids"].ToString().Split(new Char[] { '+' }); string[] lv_dbrname = Request.Form["txtswly_dbsy_usernames"].ToString().Split(new Char[] { '+' }); for (var i = 0; i < lv_dbrid.Length; i++) { if (lv_dbrid[i].ToString() != "") { //得到当前用户手机号 HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString()); //得到后续处理人手机号 string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(lv_dbrid[i].ToString()); //给后续处理人发送一个新的待办事宜(提醒) Hyoa_global.Senddbsy_global(cb_docid, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_fsrid, cb_fsrname, cb_url, cb_property, cb_mudelid, cb_foldername, cb_hj, cb_bt, cb_subbt, 0, cb_flowid, cb_tacheid, Request.Form["hy_tableid"].ToString()); //给后续处理人发送即时消息(提醒) Hyoa_global.Sendjstx_global(cb_docid, cb_fsrid, cb_fsrname, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_mudelid, cb_bt, 0, Request.Form["hy_tableid"].ToString()); //给后续处理人发送短信(提醒) Hyoa_global.Sendsms_global(cb_docid, cb_fsrid, cb_fsrname, cb_fsrsjh, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_jsrsjh, cb_mudelid, cb_bt, 1, "", "", 0, Request.Form["hy_tableid"].ToString()); //在hyp_flowhistoryinfo_cy中添加传阅信息 string sql_cy = "select * from hyp_flowhistoryinfo_cy where DOCID='" + Request.Form["txtdocid"].ToString() + "' and hy_cyrid='" + lv_dbrid[i] + "' order by hy_createtime DESC "; DataTable dt_cy = Hyoa_global.GetDataTable(sql_cy); if (dt_cy.Rows.Count > 0) { } else { HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy(); Hyoa_flowhistoryinfo_cy.ID = Hyoa_global.GetRandom(); Hyoa_flowhistoryinfo_cy.DOCID = Request.Form["txtdocid"].ToString(); Hyoa_flowhistoryinfo_cy.hy_flowid = Request.Form["hy_flowid"].ToString(); Hyoa_flowhistoryinfo_cy.hy_flowname = Request.Form["hy_flowname"].ToString(); Hyoa_flowhistoryinfo_cy.hy_tacheid = Request.Form["hy_curtacheid"].ToString(); Hyoa_flowhistoryinfo_cy.hy_tachename = Request.Form["hy_curtachename"].ToString(); Hyoa_flowhistoryinfo_cy.hy_cyrid = lv_dbrid[i]; Hyoa_flowhistoryinfo_cy.hy_cyrname = lv_dbrname[i]; Hyoa_flowhistoryinfo_cy.hy_ydsj = ""; Hyoa_flowhistoryinfo_cy.hy_createtime = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); Hyoa_flowhistoryinfo_cy.Insert(); } } } //在当前环节处理的记录中添加传阅信息,主要用于列表的显示控制 string sql_cl = "select * from hyp_flowhistoryinfo_cl where DOCID='" + Request.Form["txtdocid"].ToString() + "' order by hy_createtime DESC "; DataTable dt_cl = Hyoa_global.GetDataTable(sql_cl); if (dt_cl.Rows.Count > 0) { if (dt_cl.Rows[0]["hy_cyrid"].ToString() == "") { sql_cl = "update hyp_flowhistoryinfo_cl set hy_cyrid='" + Request.Form["txtswly_dbsy_userids"].ToString().Replace("+", ",") + "',hy_cyrname='" + Request.Form["txtswly_dbsy_usernames"].ToString().Replace("+", ",") + "' where ID='" + dt_cl.Rows[0]["ID"].ToString() + "'"; Hyoa_global.ExcuteSQL(sql_cl); } else { if (Session["conntype"].ToString() == "SQL") { sql_cl = "update hyp_flowhistoryinfo_cl set hy_cyrid=hy_cyrid+'," + Request.Form["txtswly_dbsy_userids"].ToString().Replace("+", ",") + "',hy_cyrname=hy_cyrname+'," + Request.Form["txtswly_dbsy_usernames"].ToString().Replace("+", ",") + "' where ID='" + dt_cl.Rows[0]["ID"].ToString() + "'"; } if (Session["conntype"].ToString() == "ORACLE") { sql_cl = "update hyp_flowhistoryinfo_cl set hy_cyrid=CONCAT(hy_cyrid,'," + Request.Form["txtswly_dbsy_userids"].ToString().Replace("+", ",") + "'),hy_cyrname=CONCAT(hy_cyrname,'," + Request.Form["txtswly_dbsy_usernames"].ToString().Replace("+", ",") + ")' where ID='" + dt_cl.Rows[0]["ID"].ToString() + "'"; } Hyoa_global.ExcuteSQL(sql_cl); } } ls_tip = "阅件分发成功!"; } //在主表单内嵌列表的功能中,保存、提交和确认子表单时,需要将父文档的DOCID保存到当前记录的hy_motherid中 //ADD BY XF 2011-11-17 if (Request.Form["txtwhichoperation"].ToString() == "1" || Request.Form["txtwhichoperation"].ToString() == "2" || Request.Form["txtwhichoperation"].ToString() == "111") { if (Request.QueryString["op"] != null) { if (Request.QueryString["op"].ToString() != "") { if (Request.QueryString["motherid"] != null) { if (Request.QueryString["motherid"].ToString() != "") { sql += ",hy_motherid='" + Request.QueryString["motherid"].ToString() + "'"; } } } } } sql += " where DOCID='" + Request.Form["txtdocid"].ToString() + "'"; Hyoa_global.ExcuteSQL(sql); ls_flag = "1"; hy_json = "{\"success\":" + ls_success + ",\"flag\":\"" + ls_flag + "\"}"; Response.Write(hy_json); ////处理完成后的提示及跳转(增加刷新附件功能) //if (Request.Form["txtifsxfj"].ToString() == "1") //{ // //Response.Write("<script>window.location='main.aspx?op=modify&mid=" + Request.Form["hy_mudelid"].ToString() + "&tableid=" + Request.Form["hy_tableid"].ToString() + "&docid=" + Request.Form["txtdocid"].ToString() + "&url=" + Request.Form["txturl"].ToString() + "'</script>"); //} //else //{ // //if (Request.Form["txtifpop"].ToString() == "") // //{ // // //Response.Write("<script>alert('" + ls_tip + "');window.location='" + Request.Form["txturl"].ToString() + "'</script>"); // //} // //else // //{ // // Response.Write("<script>alert('" + ls_tip + "');try{window.opener.location.reload();}catch(err){}self.close();</script>"); // //} // Response.Write("<div data-role=\"dialog\">"); // Response.Write("<div data-role=\"header\" data-theme=\"d\">"); // Response.Write("<h1>"); // Response.Write("消息窗口</h1>"); // Response.Write("</div>"); // Response.Write("<div data-role=\"content\" style=\"text-align: center\">"); // Response.Write("<h1>"); // Response.Write(ls_tip + "</h1>"); // Response.Write("<a href=\"" + Request.Form["txturl"].ToString() + "\" data-icon=\"gear\" data-role=\"button\" data-theme=\"b\" data-transition=\"flip\">确 定</a>"); // Response.Write("</div>"); // Response.Write("</div>"); //} }
//打开文档显示 private void DataPlay() { if (this.Request.QueryString["op"] != null) { this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); HyoaClass.DAO db = new HyoaClass.DAO(); string sql = ""; //新文档 if (this.Request.QueryString["op"] == "add") { this.txtdocid.Value = System.Guid.NewGuid().ToString(); this.txtdjr.Value = Session["hyuname"].ToString(); this.txtdjrid.Value = Session["hyuid"].ToString(); this.txtdjsj.Value = System.DateTime.Now.ToString("yyyy-MM-dd"); this.hy_tpjssj.Value = System.DateTime.Now.AddDays(7).ToString("yyyy-MM-dd"); //是投票管理员,提交按钮显示 this.btn_submit.Visible = true; //提交 this.btn_tj.Visible = true; //提交 } //旧文档 if (this.Request.QueryString["op"] == "modify") { if (this.Request.QueryString["id"] != null) { //根据id得到信息 this.txtdocid.Value = this.Request.QueryString["id"].ToString(); sql = "select * from hyk_whzx_tpgl where id='" + this.txtdocid.Value + "'"; DataTable dt = db.GetDataTable(sql); if (dt.Rows.Count > 0) { #region 根据id得到信息 this.txtdjr.Value = dt.Rows[0]["hy_djr"].ToString(); this.txtdjrid.Value = dt.Rows[0]["hy_djrid"].ToString(); this.txtdjsj.Value = System.DateTime.Parse(dt.Rows[0]["hy_djsj"].ToString()).ToString("yyyy-MM-dd"); this.hy_bt.Text = dt.Rows[0]["hy_bt"].ToString(); this.hy_btR.Text = dt.Rows[0]["hy_bt"].ToString(); this.hy_tpjssj.Value = System.DateTime.Parse(dt.Rows[0]["hy_tpjssj"].ToString()).ToString("yyyy-MM-dd"); this.hy_tpjssjR.Text = System.DateTime.Parse(dt.Rows[0]["hy_tpjssj"].ToString()).ToString("yyyy-MM-dd"); //this.ddlType.SelectedValue = dt.Rows[0]["hy_tplbid"].ToString(); foreach (ListItem lt in this.ddlType.Items) { if (lt.Value == dt.Rows[0]["hy_tplbid"].ToString()) { lt.Selected = true; break; } } this.hy_tplbR.Text = dt.Rows[0]["hy_tplb"].ToString(); this.hy_xxsm.Text = dt.Rows[0]["hy_xxsm"].ToString(); this.hy_xxsmR.Text = dt.Rows[0]["hy_xxsm"].ToString(); StringBuilder str = new StringBuilder(); string lssql = "select * from hyk_whzx_tpgl_tpxx where hy_tpztid='" + this.txtdocid.Value + "'"; DataTable dt2 = db.GetDataTable(lssql); if (dt2.Rows.Count > 0) { for (int i = 0; i < dt2.Rows.Count; i++) { string ls_xxid = dt2.Rows[i]["id"].ToString(); //根据选项ID去统计该选项有多少选票 string xxsql = "select * from hyk_whzx_tpgl_tpmx where hy_tpxxid='" + ls_xxid + "'"; DataTable dt3 = db.GetDataTable(xxsql); string ls_ytps = dt3.Rows.Count.ToString(); str.Append("<div style=\"height:25px\">"); str.Append(i+1+"、"+dt2.Rows[i]["hy_tpxxmc"].ToString()); str.Append(" (已投" + ls_ytps + "票)"); str.Append("</div>"); dt3.Clear(); } } dt2.Clear(); this.hy_hxxR.Text = str.ToString(); if (dt.Rows[0]["hy_ktxx"].ToString() == "单选") { hy_rdi1.Checked = true; } else { hy_rdi2.Checked = true; } this.hy_ktxxR.Text = dt.Rows[0]["hy_ktxx"].ToString(); this.hy_kydz.Text = dt.Rows[0]["hy_ktpz"].ToString(); this.hy_kydzid.Value = dt.Rows[0]["hy_ktpzid"].ToString(); this.hy_kydzR.Text = dt.Rows[0]["hy_ktpz"].ToString(); this.hy_kcktpjg.Text = dt.Rows[0]["hy_kcktpjg"].ToString(); this.hy_kcktpjgid.Value = dt.Rows[0]["hy_kcktpjgid"].ToString(); this.hy_kcktpjgR.Text = dt.Rows[0]["hy_kcktpjg"].ToString(); //投票状态 this.txthy_gjzt.Value = dt.Rows[0]["hy_gjzt"].ToString(); //判断该投票是否已经过期============== if (System.DateTime.Parse(dt.Rows[0]["hy_tpjssj"].ToString()).ToString("yyyy-MM-dd") != "1900-01-01" && Convert.ToDateTime(System.DateTime.Now.ToString("yyyy-MM-dd")) > Convert.ToDateTime(System.DateTime.Parse(dt.Rows[0]["hy_tpjssj"].ToString()).ToString("yyyy-MM-dd"))) { //将该文档设为“结束投票” string ls_sql = "update hyk_whzx_tpgl set hy_jssj=getdate(),hy_gjzt='结束投票' where id='" + this.txtdocid.Value + "'"; db.Execute(ls_sql); //发送待办事宜给审阅人员 string ls_dburl = "/ekp/whzx/list_tpgl_tpjg.aspx?fid=" + this.txtdocid.Value + "&mid=" + this.txtmudelid.Value + "&pop=1"; string ls_body = "[" + this.hy_bt.Text + "]的投票已结束,请查看"; //部分可查看结果人员 string[] lv_kydzid = this.hy_kcktpjgid.Value.Split('+'); string[] lv_kydzname = this.hy_kcktpjgR.Text.Split('+'); for (int ii = 0; ii < lv_kydzid.Length; ii++) { Hyoa_global.Senddbsy_global(this.txtdocid.Value, lv_kydzid[ii], lv_kydzname[ii], this.txtdjrid.Value, this.txtdjr.Value, ls_dburl, "待阅", this.txtmudelid.Value, "待办箱", "一般", ls_body, "请阅读", 0, "", ""); } } #endregion } dt.Clear(); //-----隐藏控制 s------- //结果可以查看人员的权限 //Response.Write(this.hy_kcktpjgid.Value); if (this.hy_kcktpjgid.Value.IndexOf(this.Session["hyuid"].ToString()) > 0) { this.btn_jg.Visible = true; } if (this.txtdjrid.Value == Session["hyuid"].ToString()) { #region 如果当前用户是登记人员 if (this.txthy_gjzt.Value == "准备投票" || this.txthy_gjzt.Value == "驳回投票" || this.txthy_gjzt.Value == "撤销投票") { //未提交审核,则显示保存按钮和提交按钮 this.btn_submit.Visible = true; this.btn_tj.Visible = true; } else if (this.txthy_gjzt.Value == "投票中") { //已提交投票就不能修改字段了 NoEdit(); this.btn_js.Visible = true; } else if (this.txthy_gjzt.Value == "待审投票") { } else { NoEdit(); } //else //{ // //已提交投票就不能修改字段了 // NoEdit(); //} #endregion } if (Hyoa_global.isHaveRole("Role_ekp004", this.Session["hyuid"].ToString())) { #region 如果当前用户是审核人员 //待审时,则显示发布、驳回按钮 if (this.txthy_gjzt.Value == "待审投票") { this.btn_fb.Visible = true; this.btn_bh.Visible = true; } //发布时,则显示撤稿按钮 if (this.txthy_gjzt.Value == "投票中") { this.btn_cg.Visible = true; } //撤稿时,则显示发布按钮 if (this.txthy_gjzt.Value == "撤销投票") { this.btn_fb.Visible = true; } #endregion } if (this.txthy_gjzt.Value == "结束投票") { #region 如果稿件状态是结束投票 NoEdit(); #endregion } //-----隐藏控制 e------- } } db.Close(); } }
//提交 protected void btn_tj1_Click(object sender, EventArgs e) { this.txthy_tpkssj.Value = System.DateTime.Now.ToString("yyyy-MM-dd"); this.txthy_fbsj.Value = System.DateTime.Now.ToString("yyyy-MM-dd"); //更新投票表 savetj("待审投票"); //发送待办事宜给审阅人员 HyoaClass.DAO db = new HyoaClass.DAO(); HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); string sql1 = "select a.hy_userid,b.hy_username,b.hy_deptid from hyt_roleuser as a,hyt_user as b where a.hy_userid=b.hy_userid and a.hy_roleid='Role_ekp004' and hy_isenabled='是'"; DataTable dt = db.GetDataTable(sql1); if (dt.Rows.Count > 0) { for (var i = 0; i < dt.Rows.Count; i++) { string ls_dburl = "/ekp/whzx/main_tpgl.aspx?op=modify&id=" + this.txtdocid.Value + "&mid=" + this.txtmudelid.Value + "&pop=1"; string ls_body = this.txtdjr.Value + "发起投票[" + this.hy_bt.Text + "],请审核"; Hyoa_global.Senddbsy_global(this.txtdocid.Value, dt.Rows[i]["hy_userid"].ToString(), dt.Rows[i]["hy_username"].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), ls_dburl, "待办", this.txtmudelid.Value, "待办箱", "一般", ls_body, "请审核", 0, "", ""); } } dt.Clear(); db.Close(); //处理完成后的提示及跳转(增加刷新附件功能) string ls_tip = "提交审核成功!"; if (this.txtifpop.Value == "") { Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>"); } else { Response.Write("<script>alert('" + ls_tip + "');self.close();</script>"); } }
//结束投票 protected void btn_js1_Click(object sender, EventArgs e) { HyoaClass.DAO db = new HyoaClass.DAO(); string ls_sql = "update hyk_whzx_tpgl set hy_jssj=getdate(),hy_gjzt='结束投票' where id='" + this.txtdocid.Value + "'"; db.Execute(ls_sql); //发送待办事宜给审阅人员 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); string ls_dburl = "/ekp/whzx/list_tpgl_tpjg.aspx?fid=" + this.txtdocid.Value + "&mid=" + this.txtmudelid.Value + "&pop=1"; string ls_body = "[" + this.hy_bt.Text + "]的投票已结束,请查看"; //部分可查看结果人员 string[] lv_kydzid = this.hy_kcktpjgid.Value.Split('+'); string[] lv_kydzname = this.hy_kcktpjgR.Text.Split('+'); for (int ii = 0; ii < lv_kydzid.Length; ii++) { Hyoa_global.Senddbsy_global(this.txtdocid.Value, lv_kydzid[ii], lv_kydzname[ii], this.txtdjrid.Value, this.txtdjr.Value, ls_dburl, "待阅", this.txtmudelid.Value, "待办箱", "一般", ls_body, "请阅读", 0, "", ""); } db.Close(); //处理完成后的提示及跳转 string ls_tip = "结束投票成功!"; if (this.txtifpop.Value == "") { Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>"); } else { Response.Write("<script>alert('" + ls_tip + "');self.close();</script>"); } }
//发布 protected void btn_fb1_Click(object sender, EventArgs e) { this.txthy_tpkssj.Value = System.DateTime.Now.ToString("yyyy-MM-dd"); this.txthy_fbsj.Value = System.DateTime.Now.ToString("yyyy-MM-dd"); savetj("投票中"); //发送待办事宜给审阅人员 HyoaClass.DAO db = new HyoaClass.DAO(); HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); string ls_dburl = "/ekp/whzx/main_tpgl_wytp.aspx?op=add&id=" + this.txtdocid.Value + "&mid=" + this.txtmudelid.Value + "&pop=1"; string ls_body = this.txtdjr.Value + "发起投票[" + this.hy_bt.Text + "],请投票"; if (this.hy_kydzid.Value == "") { //全体人员 string sql = "select * from hyt_user "; DataTable dt = db.GetDataTable(sql); if (dt.Rows.Count > 0) { for (var i = 0; i < dt.Rows.Count; i++) { Hyoa_global.Senddbsy_global(this.txtdocid.Value, dt.Rows[i]["hy_userid"].ToString(), dt.Rows[i]["hy_username"].ToString(), this.txtdjrid.Value, this.txtdjr.Value, ls_dburl, "待办", this.txtmudelid.Value, "待办箱", "一般", ls_body, "请投票", 0, "", ""); } } dt.Clear(); } else { //部分可投票人员 string[] lv_kydzid = this.hy_kydzid.Value.Split('+'); string[] lv_kydzname = this.hy_kydz.Text.Split('+'); for (int ii = 0; ii < lv_kydzid.Length; ii++) { Hyoa_global.Senddbsy_global(this.txtdocid.Value, lv_kydzid[ii], lv_kydzname[ii], this.txtdjrid.Value, this.txtdjr.Value, ls_dburl, "待办", this.txtmudelid.Value, "待办箱", "一般", ls_body, "请投票", 0, "", ""); } } //发起投票积分日志 //根据UID得到该人员的部门信息 string ls_bm = "", ls_bmid = ""; string ls_sql22 = "select * from hyt_user as a,hyt_dept as b where a.hy_deptid = b.hy_deptid and hy_userid = '" + this.txtdjrid.Value + "' "; DataTable dt2 = db.GetDataTable(ls_sql22); if (dt2.Rows.Count > 0) { ls_bm = dt2.Rows[0]["hy_deptname"].ToString(); ls_bmid = dt2.Rows[0]["hy_deptid"].ToString(); } dt2.Clear(); InsertScoresLogs(this.txtmudelid.Value, this.txtdocid.Value, this.txtdjr.Value, this.txtdjrid.Value, ls_bm, ls_bmid, "投票积分", System.Int32.Parse(this.hy_cssz1.Value), "发起投票", "0"); //将待办事宜置为已办事宜 string ls_sql2222 = "update hyt_dbsy set hy_ifyb='1' where hy_mudelid ='" + this.txtmudelid.Value + "' and hy_subbt='请审核' and docid='" + this.txtdocid.Value + "'"; db.Execute(ls_sql2222); db.Close(); //处理完成后的提示及跳转 string ls_tip = "发布投票成功!"; if (this.txtifpop.Value == "") { Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>"); } else { Response.Write("<script>alert('" + ls_tip + "');self.close();</script>"); } }