protected void btndelinfo_my_Click(object sender, EventArgs e) { HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); String[] v_uids = this.txtuids.Value.Split(','); string ls_filepath = ""; for (var i = 0; i < v_uids.Length; i++) { if (v_uids[i] != "") { //判断是否是当前用户的文档 string sql = "select * from hyc_" + txttableid.Value + " where DOCID='" + v_uids[i] + "'"; DataTable dt_judge = Hyoa_global.GetDataTable(sql); if (dt_judge.Rows.Count > 0) { if (dt_judge.Rows[0]["hy_djrid"].ToString() == Session["hyuid"].ToString()) { sql = "delete from hyc_" + txttableid.Value + " where DOCID='" + v_uids[i] + "'"; Hyoa_global.ExcuteSQL(sql); //删除文档时将待办事宜删除start HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy.DOCID = v_uids[i]; Hyoa_dbsy.Deletebydocid(v_uids[i]); //删除文档时将待办事宜删除end //删除文档对应的hyp_flowhistoryinfo_cl hyp_flowhistoryinfo_cy start add by xf 20121016 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); Hyoa_flowhistoryinfo_cl.DOCID = v_uids[i]; Hyoa_flowhistoryinfo_cl.DeleteByDOCID(); HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy(); Hyoa_flowhistoryinfo_cy.DOCID = v_uids[i]; Hyoa_flowhistoryinfo_cy.DeleteByDOCID(); //删除文档对应的hyp_flowhistoryinfo_cl hyp_flowhistoryinfo_cy end //删的时候将附件也删除start HyoaClass.Hyoa_fileatt Hyoa_fileatt = new HyoaClass.Hyoa_fileatt(); DataTable dtfileatt = Hyoa_fileatt.GetfileattByFatherid(v_uids[i]); if (dtfileatt.Rows.Count > 0) { for (int k = 0; k < dtfileatt.Rows.Count; k++) { ls_filepath = Server.MapPath("~/") + dtfileatt.Rows[k]["hy_filepath"].ToString(); if (File.Exists(ls_filepath)) { System.IO.File.Delete(ls_filepath); } Hyoa_fileatt.ID = dtfileatt.Rows[k]["ID"].ToString(); Hyoa_fileatt.Delete(); } } //删的时候将附件也删除end } } } } this.txtuids.Value = ""; //DataPlay(1); DataPlay(System.Int32.Parse(this.curpage.Text)); }
protected void btndelinfo_Click(object sender, EventArgs e) { HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); String[] v_uids = this.txtuids.Value.Split(','); string ls_filepath = ""; for (var i = 0; i < v_uids.Length; i++) { if (v_uids[i] != "") { string sql = "delete from hyc_" + txttableid.Value + " where DOCID='" + v_uids[i] + "'"; Hyoa_global.ExcuteSQL(sql); //删除文档时将待办事宜删除start HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy.DOCID = v_uids[i]; Hyoa_dbsy.Deletebydocid(v_uids[i]); //删除文档时将待办事宜删除end //删除文档对应的hyp_flowhistoryinfo_cl hyp_flowhistoryinfo_cy start add by xf 20121016 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); Hyoa_flowhistoryinfo_cl.DOCID = v_uids[i]; Hyoa_flowhistoryinfo_cl.DeleteByDOCID(); HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy(); Hyoa_flowhistoryinfo_cy.DOCID = v_uids[i]; Hyoa_flowhistoryinfo_cy.DeleteByDOCID(); //删除文档对应的hyp_flowhistoryinfo_cl hyp_flowhistoryinfo_cy end //删的时候将附件也删除start HyoaClass.Hyoa_fileatt Hyoa_fileatt = new HyoaClass.Hyoa_fileatt(); DataTable dtfileatt = Hyoa_fileatt.GetfileattByFatherid(v_uids[i]); if (dtfileatt.Rows.Count > 0) { for (int k = 0; k < dtfileatt.Rows.Count; k++) { ls_filepath = Server.MapPath("~/") + dtfileatt.Rows[k]["hy_filepath"].ToString(); if (File.Exists(ls_filepath)) { System.IO.File.Delete(ls_filepath); } Hyoa_fileatt.ID = dtfileatt.Rows[k]["ID"].ToString(); Hyoa_fileatt.Delete(); } } //删的时候将附件也删除end //生成删除日志 start string ls_oppcontent = "表名:hyc_" + txttableid.Value + ";文档ID:" + v_uids[i] + "被删除。"; HyoaClass.Hyoa_log Hyoa_log = new HyoaClass.Hyoa_log(); Hyoa_log.ID = System.Guid.NewGuid().ToString(); Hyoa_log.hy_createtime = System.DateTime.Now.ToString(); string userip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (userip == null || userip == "") { userip = Request.ServerVariables["REMOTE_ADDR"]; } Hyoa_log.hy_oppip = userip; Hyoa_log.hy_opptype = "删除"; Hyoa_log.hy_oppcontent = ls_oppcontent; Hyoa_log.hy_oppuserid = this.Session["hyuid"].ToString(); Hyoa_log.hy_oppusername = this.Session["hyuname"].ToString(); Hyoa_log.Insert(); //生成删除日志end } } this.txtuids.Value = ""; //DataPlay(1); DataPlay(System.Int32.Parse(this.curpage.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 }
//加载主表单 Written by xf 20110515 private void DataPlay() { txtsavefields.Text = ""; txtsavefields_sx.Text = ""; if (this.Request.QueryString["op"] != null) { this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); #region 新文档 if (this.Request.QueryString["op"] == "add") { this.td_ydry.Visible = false; //新文档时,“已读人员”按钮隐藏 this.txtiffirsttache.Value = "1"; //新文档时,“是否第一环节”置为1 //文档ID(保存POST到当前页面时,DOCID不重新加载) if (!this.IsPostBack) { this.txtdocid.Value = Hyoa_global.GetRandom(); this.hy_djsj.Text = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } this.hy_djrid.Text = this.Session["hyuid"].ToString(); this.hy_djrname.Text = this.Session["hyuname"].ToString(); this.hy_djrbmid.Text = this.Session["hydeptid"].ToString(); this.hy_djrbmname.Text = this.Session["hydeptname"].ToString(); HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig(); DataTable dt_tableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text); if (dt_tableconfig.Rows.Count > 0) { if (dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "是") { //根据模块ID得到流程信息 HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor(); DataTable dt = Hyoa_flowinfor.Getfirsttacheinfobymudelid(this.hy_mudelid.Text); if (dt.Rows.Count > 0) { //判断当前用户是否有登记权限 //得到第一环节ID string ls_firsttacheid = Hyoa_global.GetFirstTacheid(dt.Rows[0]["hy_flowid"].ToString()); if (Hyoa_global.IfHaveRegiRight_Lc(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid, this.Session["hyuid"].ToString())) { this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString(); this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString(); this.hy_curtacheid.Text = dt.Rows[0]["hy_nexttacheid"].ToString(); this.hy_curtachename.Text = dt.Rows[0]["hy_nexttachename"].ToString(); this.hy_curclrid.Text = this.Session["hyuid"].ToString(); this.hy_curclrname.Text = this.Session["hyuname"].ToString(); this.lblcurtachenameshow.Text = dt.Rows[0]["hy_nexttachename"].ToString(); this.txtSystemClRight.Value = "1"; //-------条件流程start------- HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache(); DataTable dt_firsttache = Hyoa_flowtache.Getflowtachebyflowidtacheid(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid); if (dt_firsttache.Rows.Count > 0) { if (dt_firsttache.Rows[0]["hy_enablecondition"].ToString() == "是") ConditionFlow(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid); } //-------条件流程end------- } else { if (this.txtifpop.Value == "") { this.td_submit.Visible = false; this.td_nextstep.Visible = false; Response.Write("<script>alert('您无权进行此项操作,请联系管理员!');window.location='" + this.txturl.Value + "';</script>"); return; } else { this.td_submit.Visible = false; this.td_nextstep.Visible = false; Response.Write("<script>alert('您无权进行此项操作,请联系管理员!');self.close();</script>"); return; } } } dt.Clear(); this.td_nextstep.Visible = true; //提交 } } //加载页面 if (this.hy_tableid.Text == "Tablefpbd") { this.td_dc.Visible = true; } GetMainTableHtml("0", this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text); this.td_submit.Visible = true; //保存 hywebopen_newdoc(); //新文档OPEN时的特殊处理 } #endregion #region 旧文档 if (this.Request.QueryString["op"] == "modify") { this.td_browseflow.Visible = true; //查看流程 if (this.Request.QueryString["docid"] != null) { this.txtdocid.Value = this.Request.QueryString["docid"].ToString(); string sql = "select * from hyc_" + this.hy_tableid.Text + " where DOCID='" + this.txtdocid.Value + "' "; DataTable dt = Hyoa_global.GetDataTable(sql); if (dt.Rows.Count > 0) { this.hy_mudelid.Text = dt.Rows[0]["hy_mudelid"].ToString(); this.hy_tableid.Text = dt.Rows[0]["hy_tableid"].ToString(); this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString(); this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString(); this.hy_curtacheid.Text = dt.Rows[0]["hy_curtacheid"].ToString(); this.hy_curtachename.Text = dt.Rows[0]["hy_curtachename"].ToString(); this.lblcurtachenameshow.Text = dt.Rows[0]["hy_curtachename"].ToString(); this.hy_curclrid.Text = dt.Rows[0]["hy_curclrid"].ToString(); this.hy_curclrname.Text = dt.Rows[0]["hy_curclrname"].ToString(); this.hy_djrid.Text = dt.Rows[0]["hy_djrid"].ToString(); this.hy_djrname.Text = dt.Rows[0]["hy_djrname"].ToString(); this.hy_djrbmid.Text = dt.Rows[0]["hy_djrbmid"].ToString(); this.hy_djrbmname.Text = dt.Rows[0]["hy_djrbmname"].ToString(); this.hy_djsj.Text = dt.Rows[0]["hy_djsj"].ToString(); if (!this.IsPostBack) { this.hy_bt.Text = dt.Rows[0]["hy_bt"].ToString(); } this.hy_iftx.Text = dt.Rows[0]["hy_iftx"].ToString(); this.hy_zhtxsj.Text = dt.Rows[0]["hy_zhtxsj"].ToString(); this.hy_readuserlist.Text = dt.Rows[0]["hy_readuserlist"].ToString(); this.hy_readdatelist.Text = dt.Rows[0]["hy_readdatelist"].ToString(); this.hy_clrylist.Text = dt.Rows[0]["hy_clrylist"].ToString(); this.hy_cyrylist.Text = dt.Rows[0]["hy_cyrylist"].ToString(); this.hy_motherid.Text = dt.Rows[0]["hy_motherid"].ToString(); this.hy_ifconfirm.Text = dt.Rows[0]["hy_ifconfirm"].ToString(); UpdateReadFlag(); //打开时添加阅读情况 } dt.Clear(); //流程已结束 if (this.hy_curtacheid.Text == "**") { this.lblcurtachenameshow.Text = "流程已结束"; //20111216 add start if (this.hy_mudelid.Text == "Mudelfwgl" || this.hy_mudelid.Text == "Mudelswgl") { //有发布权限 if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1") { this.td_fabu.Visible = true; //收发文模块流程结束后显示发布按钮 //收发文流程结束后分发轮阅 20140809 hjadd start this.td_ffly.Visible = true; //收发文模块流程结束后显示分发按钮 //收发文流程结束后分发轮阅 20140809 hjadd start } } //20111216 add end //判断是否为传阅人 HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy(); dt = Hyoa_flowhistoryinfo_cy.Getifcyrybydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); if (dt.Rows.Count > 0) { this.txtSystemClRight.Value = "0"; this.txtSystemYdRight.Value = "1"; } //判断是否历史处理人 //判断是否是历史处理人员 if (Hyoa_global.ifhistoryclr(this.txtdocid.Value, this.Session["hyuid"].ToString())) { this.txtifhistoryclr.Value = "1"; this.txtSystemClRight.Value = "0"; this.txtSystemYdRight.Value = "1"; } } else { //////////////流程未结束/////////////////////// //判断是否为当前处理人 if (("," + this.hy_curclrid.Text + ",").IndexOf(("," + this.Session["hyuid"].ToString() + ",")) >= 0) { this.txtSystemClRight.Value = "1"; this.td_submit.Visible = true; //保存 this.td_nextstep.Visible = true; //提交 if (this.hy_curtacheid.Text != "tache0001") { this.td_returnsumbit.Visible = true; //退回 } //-------条件流程start------- HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache(); DataTable dt_firsttache = Hyoa_flowtache.Getflowtachebyflowidtacheid(this.hy_flowid.Text, this.hy_curtacheid.Text); if (dt_firsttache.Rows.Count > 0) { if (dt_firsttache.Rows[0]["hy_enablecondition"].ToString() == "是") ConditionFlow(this.hy_flowid.Text, this.hy_curtacheid.Text); } //-------条件流程end------- } else { //判断是否为传阅人 HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy(); dt = Hyoa_flowhistoryinfo_cy.Getifcyrybydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); if (dt.Rows.Count > 0) { this.txtSystemYdRight.Value = "1"; } //判断是否是上一环节处理人 if (Hyoa_global.iflastclr(this.txtdocid.Value, this.Session["hyuid"].ToString())) { this.txtiflastclr.Value = "1"; this.txtSystemYdRight.Value = "1"; this.td_withdraw.Visible = true; //收回 this.td_press.Visible = true; //催办 } else { //判断是否是历史处理人员 if (Hyoa_global.ifhistoryclr(this.txtdocid.Value, this.Session["hyuid"].ToString())) { this.txtifhistoryclr.Value = "1"; this.txtSystemYdRight.Value = "1"; this.td_press.Visible = true; //催办 } } } //判断是否为第一个环节 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); DataTable dt_flowhistoryinfo_cl = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value); if (dt_flowhistoryinfo_cl.Rows.Count == 1) { this.txtiffirsttache.Value = "1"; //旧文档时,如果历史处理环节中只有一条记录,“是否第一环节”置为1 } dt_flowhistoryinfo_cl.Clear(); //判断是否为最后一个环节 HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork(); DataTable dtflowwork = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.hy_flowid.Text, this.hy_curtacheid.Text); if (dtflowwork.Rows.Count > 0) { if (dtflowwork.Rows[0]["hy_nexttacheid"].ToString() == "**") this.txtiflasttache.Value = "1"; } dtflowwork.Clear(); //////////////流程未结束/////////////////////// } //如果表单是流程后公开显示,则置为阅读权限 if (this.hy_curtacheid.Text == "**") { HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig(); DataTable dt_tableconfig = Hyoa_tableconfig.GetTable(this.hy_tableid.Text); if (dt_tableconfig.Rows.Count > 0) { if (dt_tableconfig.Rows[0]["hy_ispuballByflowYB"].ToString() == "是") { this.txtSystemYdRight.Value = "1"; } } } //没有操作权限的用户,如果是全权用户,则置为阅读权限 ADD BY XF 2011-11-17 if (this.txtSystemClRight.Value == "0" && this.txtSystemYdRight.Value == "0") { //得到当前模块对应的全权用户组 HyoaClass.Hyoa_mudel Hyoa_mudel_forqqyh = new HyoaClass.Hyoa_mudel(); DataTable dt_mudel_forqqyh = Hyoa_mudel_forqqyh.Getmudel(this.hy_mudelid.Text); if (dt_mudel_forqqyh.Rows.Count > 0) { if (dt_mudel_forqqyh.Rows[0]["hy_qqroleid"] != null) { if (dt_mudel_forqqyh.Rows[0]["hy_qqroleid"] != "") { string ls_role_forqqyh = dt_mudel_forqqyh.Rows[0]["hy_qqroleid"].ToString(); HyoaClass.Hyoa_global Hyoa_global_forqqyh = new HyoaClass.Hyoa_global(); if (Hyoa_global_forqqyh.isHaveRole(ls_role_forqqyh, this.Session["hyuid"].ToString())) { this.txtSystemYdRight.Value = "1"; //阅读权限 } } } } } //指定的特殊模块,流转过程中,所有人员可以浏览该文档 hySetYdRight_TS(); //如果是“可修改所有文档的权限人员”,则可以修改所有的,可以把已办文件转在办 if (Hyoa_global.isHaveRole("Role9995", Session["hyuid"].ToString())) { this.txtSystemYdRight.Value = "1"; this.td_submit.Visible = true; //保存 if (this.hy_curtacheid.Text == "**") this.td_ybtozb.Visible = true; //已办转在办 } //既没有处理权限,又没有阅读权限的情况下 if (this.txtSystemClRight.Value == "0" && this.txtSystemYdRight.Value == "0") { if (this.txtifpop.Value == "") { this.td_submit.Visible = false; this.td_nextstep.Visible = false; Response.Write("<script>alert('您无权进行此项操作,请联系管理员!');window.location='" + this.txturl.Value + "';</script>"); return; } else { this.td_submit.Visible = false; this.td_nextstep.Visible = false; Response.Write("<script>alert('您无权进行此项操作,请联系管理员!');self.close();</script>"); return; } } //加载页面 if (this.hy_tableid.Text == "Tablefpbd") { this.td_dc.Visible = true; } GetMainTableHtml("1", this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text); //----加载补充意见页面 s add by xf 2013-6-24----- HyoaClass.Hyoa_tableconfig Hyoa_tableconfig_forbcyj = new HyoaClass.Hyoa_tableconfig(); DataTable dt_tableconfig_forbcyj = Hyoa_tableconfig_forbcyj.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text); if (dt_tableconfig_forbcyj.Rows.Count > 0) { if (dt_tableconfig_forbcyj.Rows[0]["hy_ifcomment"] != null) { if (dt_tableconfig_forbcyj.Rows[0]["hy_ifcomment"].ToString() == "是") { this.tb_nbsp.Visible = true; this.tb_bctitle.Visible = true; this.tb_bcbody.Visible = true; if (this.txtSystemClRight.Value == "0") { this.td_bcyj.Visible = true; this.tr_bcyj.Visible = true; } //得到已经补充意见内容 HyoaClass.Hyoa_bcyj Hyoa_bcyj = new HyoaClass.Hyoa_bcyj(); DataTable dt_bcyj = Hyoa_bcyj.GetdocsByfatherid(this.txtdocid.Value); if (dt_bcyj.Rows.Count > 0) { //输出补充意见记录 this.lblbody_bcyj.Text = ""; for (var i = 0; i < dt_bcyj.Rows.Count; i++) { this.lblbody_bcyj.Text += dt_bcyj.Rows[i]["hy_bcbody"].ToString() + "<br> "; this.lblbody_bcyj.Text += "(补充意见人:" + dt_bcyj.Rows[i]["hy_bcusername"].ToString() + " 所在部门:" + dt_bcyj.Rows[i]["hy_bcdeptname"].ToString(); this.lblbody_bcyj.Text += " 补充时间:" + dt_bcyj.Rows[i]["hy_bctime"].ToString() + " IP:" + dt_bcyj.Rows[i]["hy_bcip"].ToString(); this.lblbody_bcyj.Text += ")<br><hr height=1 color=#DEEEFE></hr>"; } } } } } //----加载补充意见页面 e----- } hywebopen_olddoc(); //旧文档OPEN的特殊处理 } #endregion } }
//加载主表单 Written by xf 20110515 private void DataPlay() { if (this.Request.QueryString["op"] != null) { this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改 //新文档 if (this.Request.QueryString["op"] == "add") { HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); //文档ID this.txtdocid.Value = Hyoa_global.GetRandom(); this.hy_djrid.Text = this.Session["hyuid"].ToString(); this.hy_djrname.Text = this.Session["hyuname"].ToString(); this.hy_djrbmid.Text = this.Session["hydeptid"].ToString(); this.hy_djrbmname.Text = this.Session["hydeptname"].ToString(); this.hy_djsj.Text = System.DateTime.Now.ToString(); if (this.txtifhaveflow.Value == "是") { HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig(); DataTable dt_tableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text); if (dt_tableconfig.Rows.Count > 0) { if (dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "是") { //根据模块ID得到流程信息 HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor(); DataTable dt = Hyoa_flowinfor.Getfirsttacheinfobymudelid(this.hy_mudelid.Text); //Response.Write("<script>alert('"+dt.Rows.Count.ToString()+"')</script>"); if (dt.Rows.Count > 0) { //判断当前用户是否有登记权限 //得到第一环节ID string ls_firsttacheid = Hyoa_global.GetFirstTacheid(dt.Rows[0]["hy_flowid"].ToString()); if (Hyoa_global.IfHaveRegiRight_Lc(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid, this.Session["hyuid"].ToString())) { this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString(); this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString(); this.hy_curtacheid.Text = dt.Rows[0]["hy_nexttacheid"].ToString(); this.hy_curtachename.Text = dt.Rows[0]["hy_nexttachename"].ToString(); this.hy_curclrid.Text = this.Session["hyuid"].ToString(); this.hy_curclrname.Text = this.Session["hyuname"].ToString(); this.lblcurtachenameshow.Text = dt.Rows[0]["hy_nexttachename"].ToString(); this.txtSystemClRight.Value = "1"; } else { Response.Write("<script>alert('您无权进行此项操作,请联系管理员!');history.back();</script>"); } } dt.Clear(); this.td_nextstep.Visible = true; //提交 } } //加载页面 this.rptlist.DataSource = GetDataTableFieldHtml(this.hy_mudelid.Text, this.hy_tableid.Text, "0", "0", this.txtdocid.Value, this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text); this.rptlist.DataBind(); this.td_submit.Visible = true; //保存 } else { this.lblcurtachenameshow.Text = this.lbltablename.Text; //如果非流程(授权用户统一管理) if (this.txttablerole.Value == "0") { if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1") this.txtSystemClRight.Value = "1"; } //如果非流程(每个人管理自己的信息) if (this.txttablerole.Value == "1") { this.txtSystemClRight.Value = "1"; } //如果非流程(每个人操作自己的信息、授权用户可管理所有信息) if (this.txttablerole.Value == "2") { this.txtSystemClRight.Value = "1"; } if(this.txtSystemClRight.Value == "1") this.td_submit.Visible = true; //保存 else this.td_submit.Visible = false; //保存 //加载页面 this.rptlist.DataSource = GetDataTableFieldHtml(this.hy_mudelid.Text, this.hy_tableid.Text, "0", "0", this.txtdocid.Value, this.txtSystemClRight.Value, "0", ""); this.rptlist.DataBind(); } hywebopen_newdoc(); //新文档OPEN时的特殊处理 } //旧文档 if (this.Request.QueryString["op"] == "modify") { this.td_browseflow.Visible = true; //查看流程 if (this.Request.QueryString["docid"] != null) { this.txtdocid.Value = this.Request.QueryString["docid"].ToString(); HyoaClass.Hyoa_flowmain flowmain = new HyoaClass.Hyoa_flowmain(); DataTable dt = flowmain.Getflowmain(this.txtdocid.Value); if (dt.Rows.Count > 0) { this.hy_mudelid.Text = dt.Rows[0]["hy_mudelid"].ToString(); this.hy_tableid.Text = dt.Rows[0]["hy_tableid"].ToString(); this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString(); this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString(); this.hy_curtacheid.Text = dt.Rows[0]["hy_curtacheid"].ToString(); this.hy_curtachename.Text = dt.Rows[0]["hy_curtachename"].ToString(); this.lblcurtachenameshow.Text = dt.Rows[0]["hy_curtachename"].ToString(); this.hy_curclrid.Text = dt.Rows[0]["hy_curclrid"].ToString(); this.hy_curclrname.Text = dt.Rows[0]["hy_curclrname"].ToString(); this.hy_djrid.Text = dt.Rows[0]["hy_djrid"].ToString(); this.hy_djrname.Text = dt.Rows[0]["hy_djrname"].ToString(); this.hy_djrbmid.Text = dt.Rows[0]["hy_djrbmid"].ToString(); this.hy_djrbmname.Text = dt.Rows[0]["hy_djrbmname"].ToString(); this.hy_djsj.Text = dt.Rows[0]["hy_djsj"].ToString(); this.hy_bt.Text = dt.Rows[0]["hy_bt"].ToString(); this.hy_content1.Text = dt.Rows[0]["hy_content1"].ToString(); this.hy_content2.Text = dt.Rows[0]["hy_content2"].ToString(); this.hy_content3.Text = dt.Rows[0]["hy_content3"].ToString(); this.hy_content4.Text = dt.Rows[0]["hy_content4"].ToString(); this.hy_content5.Text = dt.Rows[0]["hy_content5"].ToString(); this.hy_content6.Text = dt.Rows[0]["hy_content6"].ToString(); this.hy_content7.Text = dt.Rows[0]["hy_content7"].ToString(); this.hy_content8.Text = dt.Rows[0]["hy_content8"].ToString(); this.hy_content9.Text = dt.Rows[0]["hy_content9"].ToString(); this.hy_content10.Text = dt.Rows[0]["hy_content10"].ToString(); this.hy_content11.Text = dt.Rows[0]["hy_content11"].ToString(); this.hy_content12.Text = dt.Rows[0]["hy_content12"].ToString(); this.hy_content13.Text = dt.Rows[0]["hy_content13"].ToString(); this.hy_content14.Text = dt.Rows[0]["hy_content14"].ToString(); this.hy_content15.Text = dt.Rows[0]["hy_content15"].ToString(); this.hy_field1.Text = dt.Rows[0]["hy_field1"].ToString(); this.hy_field2.Text = dt.Rows[0]["hy_field2"].ToString(); this.hy_field3.Text = dt.Rows[0]["hy_field3"].ToString(); this.hy_field4.Text = dt.Rows[0]["hy_field4"].ToString(); this.hy_field5.Text = dt.Rows[0]["hy_field5"].ToString(); this.hy_field6.Text = dt.Rows[0]["hy_field6"].ToString(); this.hy_field7.Text = dt.Rows[0]["hy_field7"].ToString(); this.hy_field8.Text = dt.Rows[0]["hy_field8"].ToString(); this.hy_field9.Text = dt.Rows[0]["hy_field9"].ToString(); this.hy_field10.Text = dt.Rows[0]["hy_field10"].ToString(); this.hy_field11.Text = dt.Rows[0]["hy_field11"].ToString(); this.hy_field12.Text = dt.Rows[0]["hy_field12"].ToString(); this.hy_field13.Text = dt.Rows[0]["hy_field13"].ToString(); this.hy_field14.Text = dt.Rows[0]["hy_field14"].ToString(); this.hy_field15.Text = dt.Rows[0]["hy_field15"].ToString(); this.hy_field16.Text = dt.Rows[0]["hy_field16"].ToString(); this.hy_field17.Text = dt.Rows[0]["hy_field17"].ToString(); this.hy_field18.Text = dt.Rows[0]["hy_field18"].ToString(); this.hy_field19.Text = dt.Rows[0]["hy_field19"].ToString(); this.hy_field20.Text = dt.Rows[0]["hy_field20"].ToString(); this.hy_field21.Text = dt.Rows[0]["hy_field21"].ToString(); this.hy_field22.Text = dt.Rows[0]["hy_field22"].ToString(); this.hy_field23.Text = dt.Rows[0]["hy_field23"].ToString(); this.hy_field24.Text = dt.Rows[0]["hy_field24"].ToString(); this.hy_field25.Text = dt.Rows[0]["hy_field25"].ToString(); this.hy_field26.Text = dt.Rows[0]["hy_field26"].ToString(); this.hy_field27.Text = dt.Rows[0]["hy_field27"].ToString(); this.hy_field28.Text = dt.Rows[0]["hy_field28"].ToString(); this.hy_field29.Text = dt.Rows[0]["hy_field29"].ToString(); this.hy_field30.Text = dt.Rows[0]["hy_field30"].ToString(); this.hy_field31.Text = dt.Rows[0]["hy_field31"].ToString(); this.hy_field32.Text = dt.Rows[0]["hy_field32"].ToString(); this.hy_field33.Text = dt.Rows[0]["hy_field33"].ToString(); this.hy_field34.Text = dt.Rows[0]["hy_field34"].ToString(); this.hy_field35.Text = dt.Rows[0]["hy_field35"].ToString(); this.hy_field36.Text = dt.Rows[0]["hy_field36"].ToString(); this.hy_field37.Text = dt.Rows[0]["hy_field37"].ToString(); this.hy_field38.Text = dt.Rows[0]["hy_field38"].ToString(); this.hy_field39.Text = dt.Rows[0]["hy_field39"].ToString(); this.hy_field40.Text = dt.Rows[0]["hy_field40"].ToString(); this.hy_field41.Text = dt.Rows[0]["hy_field41"].ToString(); this.hy_field42.Text = dt.Rows[0]["hy_field42"].ToString(); this.hy_field43.Text = dt.Rows[0]["hy_field43"].ToString(); this.hy_field44.Text = dt.Rows[0]["hy_field44"].ToString(); this.hy_field45.Text = dt.Rows[0]["hy_field45"].ToString(); this.hy_field46.Text = dt.Rows[0]["hy_field46"].ToString(); this.hy_field47.Text = dt.Rows[0]["hy_field47"].ToString(); this.hy_field48.Text = dt.Rows[0]["hy_field48"].ToString(); this.hy_field49.Text = dt.Rows[0]["hy_field49"].ToString(); this.hy_field50.Text = dt.Rows[0]["hy_field50"].ToString(); this.hy_field51.Text = dt.Rows[0]["hy_field51"].ToString(); this.hy_field52.Text = dt.Rows[0]["hy_field52"].ToString(); this.hy_field53.Text = dt.Rows[0]["hy_field53"].ToString(); this.hy_field54.Text = dt.Rows[0]["hy_field54"].ToString(); this.hy_field55.Text = dt.Rows[0]["hy_field55"].ToString(); this.hy_field56.Text = dt.Rows[0]["hy_field56"].ToString(); this.hy_field57.Text = dt.Rows[0]["hy_field57"].ToString(); this.hy_field58.Text = dt.Rows[0]["hy_field58"].ToString(); this.hy_field59.Text = dt.Rows[0]["hy_field59"].ToString(); this.hy_field60.Text = dt.Rows[0]["hy_field60"].ToString(); this.hy_field61.Text = dt.Rows[0]["hy_field61"].ToString(); this.hy_field62.Text = dt.Rows[0]["hy_field62"].ToString(); this.hy_field63.Text = dt.Rows[0]["hy_field63"].ToString(); this.hy_field64.Text = dt.Rows[0]["hy_field64"].ToString(); this.hy_field65.Text = dt.Rows[0]["hy_field65"].ToString(); this.hy_field66.Text = dt.Rows[0]["hy_field66"].ToString(); this.hy_field67.Text = dt.Rows[0]["hy_field67"].ToString(); this.hy_field68.Text = dt.Rows[0]["hy_field68"].ToString(); this.hy_field69.Text = dt.Rows[0]["hy_field69"].ToString(); this.hy_field70.Text = dt.Rows[0]["hy_field70"].ToString(); this.hy_field71.Text = dt.Rows[0]["hy_field71"].ToString(); this.hy_field72.Text = dt.Rows[0]["hy_field72"].ToString(); this.hy_field73.Text = dt.Rows[0]["hy_field73"].ToString(); this.hy_field74.Text = dt.Rows[0]["hy_field74"].ToString(); this.hy_field75.Text = dt.Rows[0]["hy_field75"].ToString(); this.hy_field76.Text = dt.Rows[0]["hy_field76"].ToString(); this.hy_field77.Text = dt.Rows[0]["hy_field77"].ToString(); this.hy_field78.Text = dt.Rows[0]["hy_field78"].ToString(); this.hy_field79.Text = dt.Rows[0]["hy_field79"].ToString(); this.hy_field80.Text = dt.Rows[0]["hy_field80"].ToString(); this.hy_field81.Text = dt.Rows[0]["hy_field81"].ToString(); this.hy_field82.Text = dt.Rows[0]["hy_field82"].ToString(); this.hy_field83.Text = dt.Rows[0]["hy_field83"].ToString(); this.hy_field84.Text = dt.Rows[0]["hy_field84"].ToString(); this.hy_field85.Text = dt.Rows[0]["hy_field85"].ToString(); this.hy_field86.Text = dt.Rows[0]["hy_field86"].ToString(); this.hy_field87.Text = dt.Rows[0]["hy_field87"].ToString(); this.hy_field88.Text = dt.Rows[0]["hy_field88"].ToString(); this.hy_field89.Text = dt.Rows[0]["hy_field89"].ToString(); this.hy_field90.Text = dt.Rows[0]["hy_field90"].ToString(); this.hy_field91.Text = dt.Rows[0]["hy_field91"].ToString(); this.hy_field92.Text = dt.Rows[0]["hy_field92"].ToString(); this.hy_field93.Text = dt.Rows[0]["hy_field93"].ToString(); this.hy_field94.Text = dt.Rows[0]["hy_field94"].ToString(); this.hy_field95.Text = dt.Rows[0]["hy_field95"].ToString(); this.hy_field96.Text = dt.Rows[0]["hy_field96"].ToString(); this.hy_field97.Text = dt.Rows[0]["hy_field97"].ToString(); this.hy_field98.Text = dt.Rows[0]["hy_field98"].ToString(); this.hy_field99.Text = dt.Rows[0]["hy_field99"].ToString(); this.hy_field100.Text = dt.Rows[0]["hy_field100"].ToString(); this.hy_iftx.Text = dt.Rows[0]["hy_iftx"].ToString(); this.hy_zhtxsj.Text = dt.Rows[0]["hy_zhtxsj"].ToString(); this.hy_readuserlist.Text = dt.Rows[0]["hy_readuserlist"].ToString(); } dt.Clear(); //流程文档 if (this.txtifhaveflow.Value == "是") { //流程已结束 if (this.hy_curtacheid.Text == "**") { //////////////流程已结束/////////////////////// this.lblcurtachenameshow.Text = "流程已结束"; UpdateReadFlag(); //打开时置为已读 //////////////流程已结束/////////////////////// } else { //////////////流程未结束/////////////////////// //判断是否为当前处理人 if (this.hy_curclrid.Text.IndexOf(this.Session["hyuid"].ToString()) >= 0) { this.txtSystemClRight.Value = "1"; this.td_submit.Visible = true; //保存 this.td_nextstep.Visible = true; //提交 this.td_returnsumbit.Visible = true; //退回 } else { //判断是否为传阅人 HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy(); dt = Hyoa_flowhistoryinfo_cy.Getifcyrybydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); if (dt.Rows.Count > 0) { this.txtSystemYdRight.Value = "1"; } //判断是否是上一环节处理人 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.iflastclr(this.txtdocid.Value, this.Session["hyuid"].ToString())) { this.txtiflastclr.Value = "1"; this.txtSystemYdRight.Value = "1"; this.td_withdraw.Visible = true; //收回 this.td_press.Visible = true; //催办 } else { //判断是否是历史处理人员 if (Hyoa_global.ifhistoryclr(this.txtdocid.Value, this.Session["hyuid"].ToString())) { this.txtifhistoryclr.Value = "1"; this.txtSystemYdRight.Value = "1"; this.td_press.Visible = true; //催办 } } } //判断是否为最后一个环节 HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork(); DataTable dtflowwork = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.hy_flowid.Text, this.hy_curtacheid.Text); if (dtflowwork.Rows.Count > 0) { if (dtflowwork.Rows[0]["hy_nexttacheid"].ToString() == "**") this.txtiflasttache.Value = "1"; } dtflowwork.Clear(); //既没有处理权限,又没有阅读权限的情况下 if (this.txtSystemClRight.Value == "0" && this.txtSystemYdRight.Value == "0") { Response.Write("<script>alert('您无权进行此项操作,请联系管理员!');history.back();</script>"); } //////////////流程未结束/////////////////////// } //加载页面 this.rptlist.DataSource = GetDataTableFieldHtml(this.hy_mudelid.Text, this.hy_tableid.Text, "1", "0", this.txtdocid.Value, this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text); this.rptlist.DataBind(); } else { this.lblcurtachenameshow.Text = this.lbltablename.Text; //非流程表单 this.td_nextstep.Visible = false; this.td_withdraw.Visible = false; this.td_returnsumbit.Visible = false; this.td_press.Visible = false; this.td_browseflow.Visible = false; ////////////判断当前表单是否为只显示个人 //////////HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig(); //////////DataTable dt_tableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text); //////////if (dt_tableconfig.Rows.Count > 0) //////////{ ////////// //不是流程文档,不显示所有记录 ////////// if (dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "否" && dt_tableconfig.Rows[0]["hy_ifdisplayall"].ToString() == "否") ////////// { ////////// //判断是否为当前文档登记人 ////////// if(this.hy_djrid.Text==Session["hyuid"].ToString()) ////////// this.txtSystemClRight.Value = "1"; ////////// } ////////// else ////////// { ////////// if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1") ////////// this.txtSystemClRight.Value = "1"; ////////// } //////////} //如果非流程(授权用户统一管理) if (this.txttablerole.Value == "0") { if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1") this.txtSystemClRight.Value = "1"; } //如果非流程(每个人管理自己的信息) if (this.txttablerole.Value == "1") { //判断是否为当前文档登记人 if (this.hy_djrid.Text == Session["hyuid"].ToString()) this.txtSystemClRight.Value = "1"; } //如果非流程(每个人操作自己的信息、授权用户可管理所有信息) if (this.txttablerole.Value == "2") { if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1") { this.txtSystemClRight.Value = "1"; } else { if (this.hy_djrid.Text == Session["hyuid"].ToString()) this.txtSystemClRight.Value = "1"; } } if (this.txtSystemClRight.Value == "1") this.td_submit.Visible = true; //保存 else this.td_submit.Visible = false; //保存 //加载页面 this.rptlist.DataSource = GetDataTableFieldHtml(this.hy_mudelid.Text, this.hy_tableid.Text, "1", "0", this.txtdocid.Value, this.txtSystemClRight.Value, "0",""); this.rptlist.DataBind(); UpdateReadFlag(); //打开时置为已读 } } hywebopen_olddoc(); //旧文档OPEN的特殊处理 } } }
//加载主表单 Written by xf 20110515 private void DataPlay() { if (this.Request.QueryString["op"] != null) { this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改 //新文档 if (this.Request.QueryString["op"] == "add") { HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); //文档ID this.txtdocid.Value = Hyoa_global.GetRandom(); this.hy_djrid.Text = this.Session["hyuid"].ToString(); this.hy_djrname.Text = this.Session["hyuname"].ToString(); this.hy_djrbmid.Text = this.Session["hydeptid"].ToString(); this.hy_djrbmname.Text = this.Session["hydeptname"].ToString(); this.hy_djsj.Text = System.DateTime.Now.ToString(); if (this.txtifhaveflow.Value == "是") { HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig(); DataTable dt_tableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text); if (dt_tableconfig.Rows.Count > 0) { if (dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "是") { //根据模块ID得到流程信息 HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor(); DataTable dt = Hyoa_flowinfor.Getfirsttacheinfobymudelid(this.hy_mudelid.Text); //Response.Write("<script>alert('"+dt.Rows.Count.ToString()+"')</script>"); if (dt.Rows.Count > 0) { //判断当前用户是否有登记权限 //得到第一环节ID string ls_firsttacheid = Hyoa_global.GetFirstTacheid(dt.Rows[0]["hy_flowid"].ToString()); if (Hyoa_global.IfHaveRegiRight_Lc(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid, this.Session["hyuid"].ToString())) { this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString(); this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString(); this.hy_curtacheid.Text = dt.Rows[0]["hy_nexttacheid"].ToString(); this.hy_curtachename.Text = dt.Rows[0]["hy_nexttachename"].ToString(); this.hy_curclrid.Text = this.Session["hyuid"].ToString(); this.hy_curclrname.Text = this.Session["hyuname"].ToString(); this.lblcurtachenameshow.Text = dt.Rows[0]["hy_nexttachename"].ToString(); this.txtSystemClRight.Value = "1"; } else { Response.Write("<script>alert('您无权进行此项操作,请联系管理员!');history.back();</script>"); } } dt.Clear(); this.td_nextstep.Visible = true; //提交 } } //加载页面 this.rptlist.DataSource = GetDataTableFieldHtml(this.hy_mudelid.Text, this.hy_tableid.Text, "0", "0", this.txtdocid.Value, this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text); this.rptlist.DataBind(); this.td_submit.Visible = true; //保存 } else { this.lblcurtachenameshow.Text = this.lbltablename.Text; //如果非流程(授权用户统一管理) if (this.txttablerole.Value == "0") { if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1") this.txtSystemClRight.Value = "1"; } //如果非流程(每个人管理自己的信息) if (this.txttablerole.Value == "1") { this.txtSystemClRight.Value = "1"; } //如果非流程(每个人操作自己的信息、授权用户可管理所有信息) if (this.txttablerole.Value == "2") { this.txtSystemClRight.Value = "1"; } if (this.txtSystemClRight.Value == "1") this.td_submit.Visible = true; //保存 else this.td_submit.Visible = false; //保存 //加载页面 this.rptlist.DataSource = GetDataTableFieldHtml(this.hy_mudelid.Text, this.hy_tableid.Text, "0", "0", this.txtdocid.Value, this.txtSystemClRight.Value, "0", ""); this.rptlist.DataBind(); } hywebopen_newdoc(); //新文档OPEN时的特殊处理 } //旧文档 if (this.Request.QueryString["op"] == "modify") { this.td_browseflow.Visible = true; //查看流程 if (this.Request.QueryString["docid"] != null) { this.txtdocid.Value = this.Request.QueryString["docid"].ToString(); HyoaClass.Hyoa_flowmain flowmain = new HyoaClass.Hyoa_flowmain(); DataTable dt = flowmain.Getflowmain(this.txtdocid.Value); if (dt.Rows.Count > 0) { this.hy_mudelid.Text = dt.Rows[0]["hy_mudelid"].ToString(); this.hy_tableid.Text = dt.Rows[0]["hy_tableid"].ToString(); this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString(); this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString(); this.hy_curtacheid.Text = dt.Rows[0]["hy_curtacheid"].ToString(); this.hy_curtachename.Text = dt.Rows[0]["hy_curtachename"].ToString(); this.lblcurtachenameshow.Text = dt.Rows[0]["hy_curtachename"].ToString(); this.hy_curclrid.Text = dt.Rows[0]["hy_curclrid"].ToString(); this.hy_curclrname.Text = dt.Rows[0]["hy_curclrname"].ToString(); this.hy_djrid.Text = dt.Rows[0]["hy_djrid"].ToString(); this.hy_djrname.Text = dt.Rows[0]["hy_djrname"].ToString(); this.hy_djrbmid.Text = dt.Rows[0]["hy_djrbmid"].ToString(); this.hy_djrbmname.Text = dt.Rows[0]["hy_djrbmname"].ToString(); this.hy_djsj.Text = dt.Rows[0]["hy_djsj"].ToString(); this.hy_bt.Text = dt.Rows[0]["hy_bt"].ToString(); this.hy_content1.Text = dt.Rows[0]["hy_content1"].ToString(); this.hy_content2.Text = dt.Rows[0]["hy_content2"].ToString(); this.hy_content3.Text = dt.Rows[0]["hy_content3"].ToString(); this.hy_content4.Text = dt.Rows[0]["hy_content4"].ToString(); this.hy_content5.Text = dt.Rows[0]["hy_content5"].ToString(); this.hy_content6.Text = dt.Rows[0]["hy_content6"].ToString(); this.hy_content7.Text = dt.Rows[0]["hy_content7"].ToString(); this.hy_content8.Text = dt.Rows[0]["hy_content8"].ToString(); this.hy_content9.Text = dt.Rows[0]["hy_content9"].ToString(); this.hy_content10.Text = dt.Rows[0]["hy_content10"].ToString(); this.hy_content11.Text = dt.Rows[0]["hy_content11"].ToString(); this.hy_content12.Text = dt.Rows[0]["hy_content12"].ToString(); this.hy_content13.Text = dt.Rows[0]["hy_content13"].ToString(); this.hy_content14.Text = dt.Rows[0]["hy_content14"].ToString(); this.hy_content15.Text = dt.Rows[0]["hy_content15"].ToString(); this.hy_field1.Text = dt.Rows[0]["hy_field1"].ToString(); this.hy_field2.Text = dt.Rows[0]["hy_field2"].ToString(); this.hy_field3.Text = dt.Rows[0]["hy_field3"].ToString(); this.hy_field4.Text = dt.Rows[0]["hy_field4"].ToString(); this.hy_field5.Text = dt.Rows[0]["hy_field5"].ToString(); this.hy_field6.Text = dt.Rows[0]["hy_field6"].ToString(); this.hy_field7.Text = dt.Rows[0]["hy_field7"].ToString(); this.hy_field8.Text = dt.Rows[0]["hy_field8"].ToString(); this.hy_field9.Text = dt.Rows[0]["hy_field9"].ToString(); this.hy_field10.Text = dt.Rows[0]["hy_field10"].ToString(); this.hy_field11.Text = dt.Rows[0]["hy_field11"].ToString(); this.hy_field12.Text = dt.Rows[0]["hy_field12"].ToString(); this.hy_field13.Text = dt.Rows[0]["hy_field13"].ToString(); this.hy_field14.Text = dt.Rows[0]["hy_field14"].ToString(); this.hy_field15.Text = dt.Rows[0]["hy_field15"].ToString(); this.hy_field16.Text = dt.Rows[0]["hy_field16"].ToString(); this.hy_field17.Text = dt.Rows[0]["hy_field17"].ToString(); this.hy_field18.Text = dt.Rows[0]["hy_field18"].ToString(); this.hy_field19.Text = dt.Rows[0]["hy_field19"].ToString(); this.hy_field20.Text = dt.Rows[0]["hy_field20"].ToString(); this.hy_field21.Text = dt.Rows[0]["hy_field21"].ToString(); this.hy_field22.Text = dt.Rows[0]["hy_field22"].ToString(); this.hy_field23.Text = dt.Rows[0]["hy_field23"].ToString(); this.hy_field24.Text = dt.Rows[0]["hy_field24"].ToString(); this.hy_field25.Text = dt.Rows[0]["hy_field25"].ToString(); this.hy_field26.Text = dt.Rows[0]["hy_field26"].ToString(); this.hy_field27.Text = dt.Rows[0]["hy_field27"].ToString(); this.hy_field28.Text = dt.Rows[0]["hy_field28"].ToString(); this.hy_field29.Text = dt.Rows[0]["hy_field29"].ToString(); this.hy_field30.Text = dt.Rows[0]["hy_field30"].ToString(); this.hy_field31.Text = dt.Rows[0]["hy_field31"].ToString(); this.hy_field32.Text = dt.Rows[0]["hy_field32"].ToString(); this.hy_field33.Text = dt.Rows[0]["hy_field33"].ToString(); this.hy_field34.Text = dt.Rows[0]["hy_field34"].ToString(); this.hy_field35.Text = dt.Rows[0]["hy_field35"].ToString(); this.hy_field36.Text = dt.Rows[0]["hy_field36"].ToString(); this.hy_field37.Text = dt.Rows[0]["hy_field37"].ToString(); this.hy_field38.Text = dt.Rows[0]["hy_field38"].ToString(); this.hy_field39.Text = dt.Rows[0]["hy_field39"].ToString(); this.hy_field40.Text = dt.Rows[0]["hy_field40"].ToString(); this.hy_field41.Text = dt.Rows[0]["hy_field41"].ToString(); this.hy_field42.Text = dt.Rows[0]["hy_field42"].ToString(); this.hy_field43.Text = dt.Rows[0]["hy_field43"].ToString(); this.hy_field44.Text = dt.Rows[0]["hy_field44"].ToString(); this.hy_field45.Text = dt.Rows[0]["hy_field45"].ToString(); this.hy_field46.Text = dt.Rows[0]["hy_field46"].ToString(); this.hy_field47.Text = dt.Rows[0]["hy_field47"].ToString(); this.hy_field48.Text = dt.Rows[0]["hy_field48"].ToString(); this.hy_field49.Text = dt.Rows[0]["hy_field49"].ToString(); this.hy_field50.Text = dt.Rows[0]["hy_field50"].ToString(); this.hy_field51.Text = dt.Rows[0]["hy_field51"].ToString(); this.hy_field52.Text = dt.Rows[0]["hy_field52"].ToString(); this.hy_field53.Text = dt.Rows[0]["hy_field53"].ToString(); this.hy_field54.Text = dt.Rows[0]["hy_field54"].ToString(); this.hy_field55.Text = dt.Rows[0]["hy_field55"].ToString(); this.hy_field56.Text = dt.Rows[0]["hy_field56"].ToString(); this.hy_field57.Text = dt.Rows[0]["hy_field57"].ToString(); this.hy_field58.Text = dt.Rows[0]["hy_field58"].ToString(); this.hy_field59.Text = dt.Rows[0]["hy_field59"].ToString(); this.hy_field60.Text = dt.Rows[0]["hy_field60"].ToString(); this.hy_field61.Text = dt.Rows[0]["hy_field61"].ToString(); this.hy_field62.Text = dt.Rows[0]["hy_field62"].ToString(); this.hy_field63.Text = dt.Rows[0]["hy_field63"].ToString(); this.hy_field64.Text = dt.Rows[0]["hy_field64"].ToString(); this.hy_field65.Text = dt.Rows[0]["hy_field65"].ToString(); this.hy_field66.Text = dt.Rows[0]["hy_field66"].ToString(); this.hy_field67.Text = dt.Rows[0]["hy_field67"].ToString(); this.hy_field68.Text = dt.Rows[0]["hy_field68"].ToString(); this.hy_field69.Text = dt.Rows[0]["hy_field69"].ToString(); this.hy_field70.Text = dt.Rows[0]["hy_field70"].ToString(); this.hy_field71.Text = dt.Rows[0]["hy_field71"].ToString(); this.hy_field72.Text = dt.Rows[0]["hy_field72"].ToString(); this.hy_field73.Text = dt.Rows[0]["hy_field73"].ToString(); this.hy_field74.Text = dt.Rows[0]["hy_field74"].ToString(); this.hy_field75.Text = dt.Rows[0]["hy_field75"].ToString(); this.hy_field76.Text = dt.Rows[0]["hy_field76"].ToString(); this.hy_field77.Text = dt.Rows[0]["hy_field77"].ToString(); this.hy_field78.Text = dt.Rows[0]["hy_field78"].ToString(); this.hy_field79.Text = dt.Rows[0]["hy_field79"].ToString(); this.hy_field80.Text = dt.Rows[0]["hy_field80"].ToString(); this.hy_field81.Text = dt.Rows[0]["hy_field81"].ToString(); this.hy_field82.Text = dt.Rows[0]["hy_field82"].ToString(); this.hy_field83.Text = dt.Rows[0]["hy_field83"].ToString(); this.hy_field84.Text = dt.Rows[0]["hy_field84"].ToString(); this.hy_field85.Text = dt.Rows[0]["hy_field85"].ToString(); this.hy_field86.Text = dt.Rows[0]["hy_field86"].ToString(); this.hy_field87.Text = dt.Rows[0]["hy_field87"].ToString(); this.hy_field88.Text = dt.Rows[0]["hy_field88"].ToString(); this.hy_field89.Text = dt.Rows[0]["hy_field89"].ToString(); this.hy_field90.Text = dt.Rows[0]["hy_field90"].ToString(); this.hy_field91.Text = dt.Rows[0]["hy_field91"].ToString(); this.hy_field92.Text = dt.Rows[0]["hy_field92"].ToString(); this.hy_field93.Text = dt.Rows[0]["hy_field93"].ToString(); this.hy_field94.Text = dt.Rows[0]["hy_field94"].ToString(); this.hy_field95.Text = dt.Rows[0]["hy_field95"].ToString(); this.hy_field96.Text = dt.Rows[0]["hy_field96"].ToString(); this.hy_field97.Text = dt.Rows[0]["hy_field97"].ToString(); this.hy_field98.Text = dt.Rows[0]["hy_field98"].ToString(); this.hy_field99.Text = dt.Rows[0]["hy_field99"].ToString(); this.hy_field100.Text = dt.Rows[0]["hy_field100"].ToString(); this.hy_iftx.Text = dt.Rows[0]["hy_iftx"].ToString(); this.hy_zhtxsj.Text = dt.Rows[0]["hy_zhtxsj"].ToString(); this.hy_readuserlist.Text = dt.Rows[0]["hy_readuserlist"].ToString(); //信息管理市局录用记录 特殊显示取消按钮用于删除复制的这条数据 if (this.hy_mudelid.Text == "xxgl" && this.hy_tableid.Text == "f1265875-5494-465f-ac33-6fa43d208c8f" && this.hy_field100.Text == "1") { //this.td_qx.Visible = true; this.td_return.Visible = false; } HyoaClass.DAO DAO = new HyoaClass.DAO(); string sql_SelectCount = "select count(*) as num from hyp_flowhistoryinfo_cl where docid='" + this.txtdocid.Value + "'"; DataTable dt_Count = DAO.GetDataTable(sql_SelectCount); if (dt_Count.Rows.Count > 0) { this.txtclts.Value = dt_Count.Rows[0]["num"].ToString(); } } dt.Clear(); //流程文档 if (this.txtifhaveflow.Value == "是") { //流程已结束 if (this.hy_curtacheid.Text == "**") { //////////////流程已结束/////////////////////// this.lblcurtachenameshow.Text = "流程已结束"; UpdateReadFlag(); //打开时置为已读 //////////////流程已结束/////////////////////// } else { //////////////流程未结束/////////////////////// //判断是否为当前处理人 if (this.hy_curclrid.Text.IndexOf(this.Session["hyuid"].ToString()) >= 0) { this.txtSystemClRight.Value = "1"; this.td_submit.Visible = true; //保存 this.td_nextstep.Visible = true; //提交 this.td_returnsumbit.Visible = true; //退回 } else { //判断是否为传阅人 HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy(); dt = Hyoa_flowhistoryinfo_cy.Getifcyrybydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); if (dt.Rows.Count > 0) { this.txtSystemYdRight.Value = "1"; } //判断是否是上一环节处理人 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.iflastclr(this.txtdocid.Value, this.Session["hyuid"].ToString())) { this.txtiflastclr.Value = "1"; this.txtSystemYdRight.Value = "1"; this.td_withdraw.Visible = true; //收回 this.td_press.Visible = true; //催办 } else { //判断是否是历史处理人员 if (Hyoa_global.ifhistoryclr(this.txtdocid.Value, this.Session["hyuid"].ToString())) { this.txtifhistoryclr.Value = "1"; this.txtSystemYdRight.Value = "1"; this.td_press.Visible = true; //催办 } } } //判断是否为最后一个环节 HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork(); DataTable dtflowwork = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.hy_flowid.Text, this.hy_curtacheid.Text); if (dtflowwork.Rows.Count > 0) { if (dtflowwork.Rows[0]["hy_nexttacheid"].ToString() == "**") this.txtiflasttache.Value = "1"; } dtflowwork.Clear(); //既没有处理权限,又没有阅读权限的情况下 if (this.txtSystemClRight.Value == "0" && this.txtSystemYdRight.Value == "0") { Response.Write("<script>alert('您无权进行此项操作,请联系管理员!');history.back();</script>"); } //////////////流程未结束/////////////////////// } //加载页面 this.rptlist.DataSource = GetDataTableFieldHtml(this.hy_mudelid.Text, this.hy_tableid.Text, "1", "0", this.txtdocid.Value, this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text); this.rptlist.DataBind(); ////////补充意见s 只要是旧文档,且有流程的模块就能填写轮阅意见 this.tb_bctitle.Visible = true; this.tb_bcbody.Visible = true; //流程已结束 if (this.hy_curtacheid.Text == "**") { this.tr_bcyj.Visible = false; } else { this.tr_bcyj.Visible = true; } //得到已经补充意见内容 HyoaClass.Hyoa_bcyj Hyoa_bcyj = new HyoaClass.Hyoa_bcyj(); DataTable dt_bcyj = Hyoa_bcyj.GetdocsByfatherid(this.txtdocid.Value); if (dt_bcyj.Rows.Count > 0) { //输出补充意见记录 this.lblbody_bcyj.Text = ""; for (var i = 0; i < dt_bcyj.Rows.Count; i++) { this.lblbody_bcyj.Text += dt_bcyj.Rows[i]["hy_bcbody"].ToString() + "<br> "; this.lblbody_bcyj.Text += "(轮阅人:" + dt_bcyj.Rows[i]["hy_bcusername"].ToString() + " 所在部门:" + dt_bcyj.Rows[i]["hy_bcdeptname"].ToString(); this.lblbody_bcyj.Text += " 填写时间:" + dt_bcyj.Rows[i]["hy_bctime"].ToString(); //+ " IP:" + dt_bcyj.Rows[i]["hy_bcip"].ToString(); this.lblbody_bcyj.Text += ")<br><hr height=1 color=#DEEEFE></hr>"; } } ////////补充意见e } else { this.lblcurtachenameshow.Text = this.lbltablename.Text; //非流程表单 this.td_nextstep.Visible = false; this.td_withdraw.Visible = false; this.td_returnsumbit.Visible = false; this.td_press.Visible = false; this.td_browseflow.Visible = false; ////////////判断当前表单是否为只显示个人 //////////HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig(); //////////DataTable dt_tableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text); //////////if (dt_tableconfig.Rows.Count > 0) //////////{ ////////// //不是流程文档,不显示所有记录 ////////// if (dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "否" && dt_tableconfig.Rows[0]["hy_ifdisplayall"].ToString() == "否") ////////// { ////////// //判断是否为当前文档登记人 ////////// if(this.hy_djrid.Text==Session["hyuid"].ToString()) ////////// this.txtSystemClRight.Value = "1"; ////////// } ////////// else ////////// { ////////// if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1") ////////// this.txtSystemClRight.Value = "1"; ////////// } //////////} //如果非流程(授权用户统一管理) if (this.txttablerole.Value == "0") { if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1") this.txtSystemClRight.Value = "1"; } //如果非流程(每个人管理自己的信息) if (this.txttablerole.Value == "1") { //判断是否为当前文档登记人 if (this.hy_djrid.Text == Session["hyuid"].ToString()) this.txtSystemClRight.Value = "1"; } //如果非流程(每个人操作自己的信息、授权用户可管理所有信息) if (this.txttablerole.Value == "2") { if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1") { this.txtSystemClRight.Value = "1"; } else { if (this.hy_djrid.Text == Session["hyuid"].ToString()) this.txtSystemClRight.Value = "1"; } } if (this.txtSystemClRight.Value == "1") { //只有登记人和管理员可以修改,有保存按钮 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (this.hy_djrid.Text == Session["hyuid"].ToString() || Hyoa_global.isHaveRole("Role9999", Session["hyuid"].ToString())) { this.td_submit.Visible = true; //保存 //信息管理市局录用记录 if (this.hy_mudelid.Text == "xxgl" && this.hy_tableid.Text == "f1265875-5494-465f-ac33-6fa43d208c8f") { this.td_sc.Visible = false; //删除 } } else { this.td_submit.Visible = false; //保存 } } else { this.td_submit.Visible = false; //保存 } //加载页面 this.rptlist.DataSource = GetDataTableFieldHtml(this.hy_mudelid.Text, this.hy_tableid.Text, "1", "0", this.txtdocid.Value, this.txtSystemClRight.Value, "0", ""); this.rptlist.DataBind(); UpdateReadFlag(); //打开时置为已读 } } hywebopen_olddoc(); //旧文档OPEN的特殊处理 } } }
//加载主表单 Written by xf 20110515 private void DataPlay() { if (this.Request.QueryString["op"] != null) { HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改 //新文档 if (this.Request.QueryString["op"] == "add") { //HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); //文档ID this.txtdocid.Value = Hyoa_global.GetRandom(); this.hy_djrid.Text = this.Session["hyuid"].ToString(); this.hy_djrname.Text = this.Session["hyuname"].ToString(); this.hy_djrbmid.Text = this.Session["hydeptid"].ToString(); this.hy_djrbmname.Text = this.Session["hydeptname"].ToString(); this.hy_djsj.Text = System.DateTime.Now.ToString(); this.txthyc_nf.Text = System.DateTime.Now.ToString("yyyy"); this.txthyc_djsj.Text = System.DateTime.Now.ToString("yyyy-MM-dd"); this.txthyc_lxks.Text = this.Session["hydeptname"].ToString(); this.txthyc_lxr.Text = this.Session["hyuname"].ToString(); HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig(); DataTable dt_tableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text); if (dt_tableconfig.Rows.Count > 0) { if (dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "是") { //根据模块ID得到流程信息 HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor(); DataTable dt = Hyoa_flowinfor.Getfirsttacheinfobymudelid(this.hy_mudelid.Text); //Response.Write("<script>alert('"+dt.Rows.Count.ToString()+"')</script>"); if (dt.Rows.Count > 0) { //判断当前用户是否有登记权限 //得到第一环节ID string ls_firsttacheid = Hyoa_global.GetFirstTacheid(dt.Rows[0]["hy_flowid"].ToString()); if (Hyoa_global.IfHaveRegiRight_Lc(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid, this.Session["hyuid"].ToString())) { this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString(); this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString(); this.hy_curtacheid.Text = dt.Rows[0]["hy_nexttacheid"].ToString(); this.hy_curtachename.Text = dt.Rows[0]["hy_nexttachename"].ToString(); this.hy_curclrid.Text = this.Session["hyuid"].ToString(); this.hy_curclrname.Text = this.Session["hyuname"].ToString(); this.lblcurtachenameshow.Text = dt.Rows[0]["hy_nexttachename"].ToString(); this.txtSystemClRight.Value = "1"; this.txtSystemYdRight.Value = "0"; } else { Response.Write("<script>alert('您无权进行此项操作,请联系管理员!');</script>"); } } dt.Clear(); this.td_nextstep.Visible = true; //提交 this.td_submit.Visible = true; //保存 } } //加载页面 WebOpen(this.hy_mudelid.Text, this.hy_tableid.Text, this.hy_flowid.Text, this.hy_curtacheid.Text, this.txtSystemClRight.Value, this.txtSystemYdRight.Value, "0"); } //旧文档 if (this.Request.QueryString["op"] == "modify") { this.td_browseflow.Visible = true; //查看流程 if (this.Request.QueryString["docid"] != null) { this.txtdocid.Value = this.Request.QueryString["docid"].ToString(); //HyoaClass.Hyoa_flowmain flowmain = new HyoaClass.Hyoa_flowmain(); //DataTable dt = flowmain.Getflowmain(this.txtdocid.Value); //HyoaClass.Hyoa_global Hyoa_global=new HyoaClass.Hyoa_global (); string lssql = "select * from hyc_Tabledcxt where DOCID='" + this.txtdocid.Value + "'"; DataTable dt = Hyoa_global.GetDataTable(lssql); if (dt.Rows.Count > 0) { this.hy_mudelid.Text = dt.Rows[0]["hy_mudelid"].ToString(); this.hy_tableid.Text = dt.Rows[0]["hy_tableid"].ToString(); this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString(); this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString(); this.hy_curtacheid.Text = dt.Rows[0]["hy_curtacheid"].ToString(); this.hy_curtachename.Text = dt.Rows[0]["hy_curtachename"].ToString(); this.lblcurtachenameshow.Text = dt.Rows[0]["hy_curtachename"].ToString(); this.hy_curclrid.Text = dt.Rows[0]["hy_curclrid"].ToString(); this.hy_curclrname.Text = dt.Rows[0]["hy_curclrname"].ToString(); this.hy_djrid.Text = dt.Rows[0]["hy_djrid"].ToString(); this.hy_djrname.Text = dt.Rows[0]["hy_djrname"].ToString(); this.hy_djrbmid.Text = dt.Rows[0]["hy_djrbmid"].ToString(); this.hy_djrbmname.Text = dt.Rows[0]["hy_djrbmname"].ToString(); this.hy_djsj.Text = dt.Rows[0]["hy_djsj"].ToString(); this.hy_bt.Text = dt.Rows[0]["hy_bt"].ToString(); string lssqlfield = "SELECT * FROM hyt_flowfield WHERE (hy_tableid = 'Tabledcxt') AND (hy_mudelid = 'Mudeldcxt')"; DataTable dtfield = Hyoa_global.GetDataTable_BASE(lssqlfield); //得到所有配置域 for (int ii = 0; ii < dtfield.Rows.Count; ii++) { if (dtfield.Rows[ii]["hy_fieldtype"].ToString() == "文本") { TextBox txt1 = (TextBox)this.FindControl("txthyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()); txt1.Text = dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString(); Label lbl1 = (Label)this.FindControl("lblhyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()); lbl1.Text = dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString(); } if (dtfield.Rows[ii]["hy_fieldtype"].ToString() == "多行文本") { TextBox txt1 = (TextBox)this.FindControl("txthyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()); txt1.Text = dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString(); Label lbl1 = (Label)this.FindControl("lblhyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()); lbl1.Text = RtfToText2(dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString()); } if (dtfield.Rows[ii]["hy_fieldtype"].ToString() == "日期") { TextBox txt1 = (TextBox)this.FindControl("txthyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()); Label lbl1 = (Label)this.FindControl("lblhyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()); if (dtfield.Rows[ii]["hy_defaultvalue"].ToString() == "yyyy-mm-dd") { txt1.Text = System.DateTime.Parse(dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString()).ToShortDateString(); lbl1.Text = System.DateTime.Parse(dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString()).ToShortDateString(); } else { txt1.Text = dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString(); lbl1.Text = dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString(); } } if (dtfield.Rows[ii]["hy_fieldtype"].ToString() == "对话框列表") { DropDownList ddl1 = (DropDownList)this.FindControl("txthyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()); ddl1.SelectedValue = dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString(); Label lbl1 = (Label)this.FindControl("lblhyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()); lbl1.Text = dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString(); } //this.FindControl("11111"). = "1"; //this.FindControl("txthyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()).value = dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString(); //this.FindControl("lblhyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()).value = dt.Rows[0]["hyc_" + dtfield.Rows[ii]["hy_fieldid"].ToString()].ToString(); } //this.txthyc_nf.Text = dt.Rows[0]["hyc_nf"].ToString(); //this.txthyc_bh.Text = dt.Rows[0]["hyc_bh"].ToString(); //this.txthyc_lb.SelectedValue = dt.Rows[0]["hyc_lb"].ToString(); //this.txthyc_hj.SelectedValue = dt.Rows[0]["hyc_hj"].ToString(); //this.txthyc_djsj.Text = dt.Rows[0]["hyc_djsj"].ToString(); //this.txthyc_cbdw.Text = dt.Rows[0]["hyc_cbdw"].ToString(); //this.txthyc_dcsx.Text = dt.Rows[0]["hyc_dcsx"].ToString(); //this.txthyc_blyq.Text = dt.Rows[0]["hyc_blyq"].ToString(); //this.txthyc_lxks.Text = dt.Rows[0]["hyc_lxks"].ToString(); //this.txthyc_lxr.Text = dt.Rows[0]["hyc_lxr"].ToString(); //this.txthyc_lxdh.Text = dt.Rows[0]["hyc_lxdh"].ToString(); //this.txthyc_cbqx.Text = dt.Rows[0]["hyc_cbqx"].ToString(); //this.lblhyc_nf.Text = dt.Rows[0]["hyc_nf"].ToString(); //this.lblhyc_bh.Text = dt.Rows[0]["hyc_bh"].ToString(); //this.lblhyc_lb.SelectedValue = dt.Rows[0]["hyc_lb"].ToString(); //this.lblhyc_hj.SelectedValue = dt.Rows[0]["hyc_hj"].ToString(); //this.lblhyc_djsj.Text = dt.Rows[0]["hyc_djsj"].ToString(); //this.lblhyc_cbdw.Text = dt.Rows[0]["hyc_cbdw"].ToString(); //this.lblhyc_dcsx.Text = dt.Rows[0]["hyc_dcsx"].ToString(); //this.lblhyc_blyq.Text = dt.Rows[0]["hyc_blyq"].ToString(); //this.lblhyc_lxks.Text = dt.Rows[0]["hyc_lxks"].ToString(); //this.lblhyc_lxr.Text = dt.Rows[0]["hyc_lxr"].ToString(); //this.lblhyc_lxdh.Text = dt.Rows[0]["hyc_lxdh"].ToString(); //this.lblhyc_cbqx.Text = dt.Rows[0]["hyc_cbqx"].ToString(); this.hy_iftx.Text = dt.Rows[0]["hy_iftx"].ToString(); this.hy_zhtxsj.Text = dt.Rows[0]["hy_zhtxsj"].ToString(); this.hy_readuserlist.Text = dt.Rows[0]["hy_readuserlist"].ToString(); } dt.Clear(); //流程文档 if (this.txtifhaveflow.Value == "是") { //流程已结束 if (this.hy_curtacheid.Text == "**") { //////////////流程已结束/////////////////////// this.lblcurtachenameshow.Text = "流程已结束"; //UpdateReadFlag(); //打开时置为已读 //////////////流程已结束/////////////////////// //判断是否为传阅人 HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy(); dt = Hyoa_flowhistoryinfo_cy.Getifcyrybydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); if (dt.Rows.Count > 0) { this.txtSystemClRight.Value = "0"; this.txtSystemYdRight.Value = "1"; } //判断是否历史处理人 //判断是否是历史处理人员 //HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.ifhistoryclr(this.txtdocid.Value, this.Session["hyuid"].ToString())) { this.txtifhistoryclr.Value = "1"; this.txtSystemClRight.Value = "0"; this.txtSystemYdRight.Value = "1"; } } else { //////////////流程未结束/////////////////////// //判断是否为当前处理人 if (this.hy_curclrid.Text.IndexOf(this.Session["hyuid"].ToString()) >= 0) { this.txtSystemClRight.Value = "1"; this.txtSystemYdRight.Value = "0"; this.td_submit.Visible = true; //保存 this.td_nextstep.Visible = true; //提交 //this.td_returnsumbit.Visible = true; //退回 } else { //判断是否为传阅人 HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy(); dt = Hyoa_flowhistoryinfo_cy.Getifcyrybydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); if (dt.Rows.Count > 0) { this.txtSystemClRight.Value = "0"; this.txtSystemYdRight.Value = "1"; } //判断是否是上一环节处理人 //HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.iflastclr(this.txtdocid.Value, this.Session["hyuid"].ToString())) { this.txtiflastclr.Value = "1"; this.txtSystemClRight.Value = "0"; this.txtSystemYdRight.Value = "1"; //this.td_withdraw.Visible = true; //收回 //this.td_press.Visible = true; //催办 } else { //判断是否是历史处理人员 if (Hyoa_global.ifhistoryclr(this.txtdocid.Value, this.Session["hyuid"].ToString())) { this.txtifhistoryclr.Value = "1"; this.txtSystemClRight.Value = "0"; this.txtSystemYdRight.Value = "1"; //this.td_press.Visible = true; //催办 } } } //判断是否为最后一个环节 HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork(); DataTable dtflowwork = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.hy_flowid.Text, this.hy_curtacheid.Text); if (dtflowwork.Rows.Count > 0) { if (dtflowwork.Rows[0]["hy_nexttacheid"].ToString() == "**") this.txtiflasttache.Value = "1"; } dtflowwork.Clear(); //////////////流程未结束/////////////////////// } //既没有处理权限,又没有阅读权限的情况下 if (this.txtSystemClRight.Value == "0" && this.txtSystemYdRight.Value == "0") { Response.Write("<script>alert('您无权进行此项操作,请联系管理员!');</script>"); } //加载页面 WebOpen(this.hy_mudelid.Text, this.hy_tableid.Text, this.hy_flowid.Text, this.hy_curtacheid.Text, this.txtSystemClRight.Value, this.txtSystemYdRight.Value, "1"); } } } //隐藏、显示控制 string lssqlfield5 = "SELECT * FROM hyt_flowfield WHERE (hy_tableid = 'Tabledcxt') AND (hy_mudelid = 'Mudeldcxt')"; DataTable dtfield5 = Hyoa_global.GetDataTable_BASE(lssqlfield5); //得到所有配置域 string lssqlflowtachefield = "";//流程环节对应的域 DataTable dtflowtachefield; for (int ii = 0; ii < dtfield5.Rows.Count; ii++) { lssqlflowtachefield = "select * from hyt_flowtachefield where hy_flowid = '" + this.hy_flowid.Text + "' and hy_tacheid = '" + this.hy_curtacheid.Text + "' and hy_fieldid='" + dtfield5.Rows[ii]["hy_fieldid"].ToString() + "'"; dtflowtachefield = Hyoa_global.GetDataTable_BASE(lssqlflowtachefield); if (dtflowtachefield.Rows.Count > 0) { this.FindControl("txthyc_" + dtfield5.Rows[ii]["hy_fieldid"].ToString()).Visible = true; this.FindControl("lblhyc_" + dtfield5.Rows[ii]["hy_fieldid"].ToString()).Visible = false; } else { this.FindControl("txthyc_" + dtfield5.Rows[ii]["hy_fieldid"].ToString()).Visible = false; this.FindControl("lblhyc_" + dtfield5.Rows[ii]["hy_fieldid"].ToString()).Visible = true; } } } }
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"; //删除失败 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); string txtuids = ""; if (this.Request.Form["txtuids"] != null) txtuids = this.Request.Form["txtuids"].ToString(); string txttableid = ""; if (this.Request.Form["txttableid"] != null) txttableid = this.Request.Form["txttableid"].ToString(); String[] v_uids = txtuids.Split(','); string ls_filepath = ""; for (var i = 0; i < v_uids.Length; i++) { if (v_uids[i] != "") { string sql = "delete from hyc_" + txttableid + " where DOCID='" + v_uids[i] + "'"; Hyoa_global.ExcuteSQL(sql); //删除文档时将待办事宜删除start HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy(); Hyoa_dbsy.DOCID = v_uids[i]; Hyoa_dbsy.Deletebydocid(v_uids[i]); //删除文档时将待办事宜删除end //删除文档对应的hyp_flowhistoryinfo_cl hyp_flowhistoryinfo_cy start add by xf 20121016 HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl(); Hyoa_flowhistoryinfo_cl.DOCID = v_uids[i]; Hyoa_flowhistoryinfo_cl.DeleteByDOCID(); HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy(); Hyoa_flowhistoryinfo_cy.DOCID = v_uids[i]; Hyoa_flowhistoryinfo_cy.DeleteByDOCID(); //删除文档对应的hyp_flowhistoryinfo_cl hyp_flowhistoryinfo_cy end //删的时候将附件也删除start HyoaClass.Hyoa_fileatt Hyoa_fileatt = new HyoaClass.Hyoa_fileatt(); DataTable dtfileatt = Hyoa_fileatt.GetfileattByFatherid(v_uids[i]); if (dtfileatt.Rows.Count > 0) { for (int k = 0; k < dtfileatt.Rows.Count; k++) { ls_filepath = Server.MapPath("~/") + dtfileatt.Rows[k]["hy_filepath"].ToString(); if (File.Exists(ls_filepath)) { System.IO.File.Delete(ls_filepath); } Hyoa_fileatt.ID = dtfileatt.Rows[k]["ID"].ToString(); Hyoa_fileatt.Delete(); } } //删的时候将附件也删除end //生成删除日志 start string ls_oppcontent = "表名:hyc_" + txttableid + ";文档ID:" + v_uids[i] + "被删除。"; HyoaClass.Hyoa_log Hyoa_log = new HyoaClass.Hyoa_log(); Hyoa_log.ID = System.Guid.NewGuid().ToString(); Hyoa_log.hy_createtime = System.DateTime.Now.ToString(); string userip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (userip == null || userip == "") { userip = Request.ServerVariables["REMOTE_ADDR"]; } Hyoa_log.hy_oppip = userip; Hyoa_log.hy_opptype = "删除"; Hyoa_log.hy_oppcontent = ls_oppcontent; Hyoa_log.hy_oppuserid = this.Session["hyuid"].ToString(); Hyoa_log.hy_oppusername = this.Session["hyuname"].ToString(); Hyoa_log.Insert(); //生成删除日志end ls_flag = "1"; } } hy_json = "{\"success\":" + ls_success + ",\"flag\":\"" + ls_flag + "\"}"; Response.Write(hy_json); }
//加载主表单 Written by xf 20110515 private void DataPlay() { txtsavefields.Text = ""; txtsavefields_sx.Text = ""; if (this.Request.QueryString["op"] != null) { this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); //新文档 if (this.Request.QueryString["op"] == "add") { //文档ID(保存POST到当前页面时,DOCID不重新加载) if (!this.IsPostBack) { this.txtdocid.Value = Hyoa_global.GetRandom(); } this.hy_djrid.Text = this.Session["hyuid"].ToString(); this.hy_djrname.Text = this.Session["hyuname"].ToString(); this.hy_djrbmid.Text = this.Session["hydeptid"].ToString(); this.hy_djrbmname.Text = this.Session["hydeptname"].ToString(); this.hy_djsj.Text = System.DateTime.Now.ToString(); if (this.txtifhaveflow.Value == "是") { HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig(); DataTable dt_tableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text); if (dt_tableconfig.Rows.Count > 0) { if (dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "是") { //根据模块ID得到流程信息 HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor(); DataTable dt = Hyoa_flowinfor.Getfirsttacheinfobymudelid(this.hy_mudelid.Text); if (dt.Rows.Count > 0) { //判断当前用户是否有登记权限 //得到第一环节ID string ls_firsttacheid = Hyoa_global.GetFirstTacheid(dt.Rows[0]["hy_flowid"].ToString()); if (Hyoa_global.IfHaveRegiRight_Lc(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid, this.Session["hyuid"].ToString())) { this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString(); this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString(); this.hy_curtacheid.Text = dt.Rows[0]["hy_nexttacheid"].ToString(); this.hy_curtachename.Text = dt.Rows[0]["hy_nexttachename"].ToString(); this.hy_curclrid.Text = this.Session["hyuid"].ToString(); this.hy_curclrname.Text = this.Session["hyuname"].ToString(); this.lblcurtachenameshow.Text = "当前环节:" + dt.Rows[0]["hy_nexttachename"].ToString(); this.txtSystemClRight.Value = "1"; //-------条件流程start------- HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache(); DataTable dt_firsttache = Hyoa_flowtache.Getflowtachebyflowidtacheid(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid); if (dt_firsttache.Rows.Count > 0) { if (dt_firsttache.Rows[0]["hy_enablecondition"].ToString() == "是") ConditionFlow(dt.Rows[0]["hy_flowid"].ToString(), ls_firsttacheid); } //-------条件流程end------- } else { if (this.txtifpop.Value == "") { Response.Write("<script>alert('您无权进行此项操作,请联系管理员!');window.location='" + this.txturl.Value + "';</script>"); this.td_submit.Visible = false; this.td_nextstep.Visible = false; return; } else { Response.Write("<script>alert('您无权进行此项操作,请联系管理员!');self.close();</script>"); return; } } } dt.Clear(); this.td_nextstep.Visible = true; //提交 } } //加载页面 GetMainTableHtml("0", this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text); this.td_submit.Visible = true; //保存 } else { //this.lblcurtachenameshow.Text = this.lbltablename.Text; //如果非流程(授权用户可新建信息、可删除所有信息) if (this.txttablerole.Value == "0") { if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1") this.txtSystemClRight.Value = "1"; } //如果非流程(每个人管理自己的信息) if (this.txttablerole.Value == "1") { this.txtSystemClRight.Value = "1"; } //如果非流程(每个人管理自己的信息、授权用户可管理所有信息) if (this.txttablerole.Value == "2") { this.txtSystemClRight.Value = "1"; } //如果非流程(授权用户可新建、只能删自己新建的信息) if (this.txttablerole.Value == "3") { if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1") this.txtSystemClRight.Value = "1"; } if (this.txtSystemClRight.Value == "1") { this.td_submit.Visible = true; //保存 } else { this.td_submit.Visible = false; //保存 } //加载页面 GetMainTableHtml("0", this.txtSystemClRight.Value, "0", ""); } hywebopen_newdoc(); //新文档OPEN时的特殊处理 } //旧文档 if (this.Request.QueryString["op"] == "modify") { this.td_browseflow.Visible = true; //查看流程 if (this.Request.QueryString["docid"] != null) { this.txtdocid.Value = this.Request.QueryString["docid"].ToString(); string sql = "select * from hyc_" + this.hy_tableid.Text + " where DOCID='" + this.txtdocid.Value + "' "; DataTable dt = Hyoa_global.GetDataTable(sql); if (dt.Rows.Count > 0) { this.hy_mudelid.Text = dt.Rows[0]["hy_mudelid"].ToString(); this.hy_tableid.Text = dt.Rows[0]["hy_tableid"].ToString(); this.hy_flowid.Text = dt.Rows[0]["hy_flowid"].ToString(); this.hy_flowname.Text = dt.Rows[0]["hy_flowname"].ToString(); this.hy_curtacheid.Text = dt.Rows[0]["hy_curtacheid"].ToString(); this.hy_curtachename.Text = dt.Rows[0]["hy_curtachename"].ToString(); this.lblcurtachenameshow.Text = dt.Rows[0]["hy_curtachename"].ToString(); this.hy_curclrid.Text = dt.Rows[0]["hy_curclrid"].ToString(); this.hy_curclrname.Text = dt.Rows[0]["hy_curclrname"].ToString(); this.hy_djrid.Text = dt.Rows[0]["hy_djrid"].ToString(); this.hy_djrname.Text = dt.Rows[0]["hy_djrname"].ToString(); this.hy_djrbmid.Text = dt.Rows[0]["hy_djrbmid"].ToString(); this.hy_djrbmname.Text = dt.Rows[0]["hy_djrbmname"].ToString(); this.hy_djsj.Text = dt.Rows[0]["hy_djsj"].ToString(); this.hy_bt.Text = dt.Rows[0]["hy_bt"].ToString(); this.hy_iftx.Text = dt.Rows[0]["hy_iftx"].ToString(); this.hy_zhtxsj.Text = dt.Rows[0]["hy_zhtxsj"].ToString(); this.hy_readuserlist.Text = dt.Rows[0]["hy_readuserlist"].ToString(); this.hy_readdatelist.Text = dt.Rows[0]["hy_readdatelist"].ToString(); this.hy_motherid.Text = dt.Rows[0]["hy_motherid"].ToString(); this.hy_ifconfirm.Text = dt.Rows[0]["hy_ifconfirm"].ToString(); UpdateReadFlag(); //打开时添加阅读情况 } //dt.Clear(); //流程文档 if (this.txtifhaveflow.Value == "是") { this.lblcurtachenameshow.Text = "当前环节:" + dt.Rows[0]["hy_curtachename"].ToString(); //流程已结束 if (this.hy_curtacheid.Text == "**") { this.lblcurtachenameshow.Text = "当前环节:" + "流程已结束"; //20111216 add start if (this.hy_mudelid.Text == "Mudelfwgl" || this.hy_mudelid.Text == "Mudelswgl") { //有发布权限 if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1") this.td_fabu.Visible = true; //收发文模块流程结束后显示发布按钮 } //20111216 add end //判断是否为传阅人 HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy(); dt = Hyoa_flowhistoryinfo_cy.Getifcyrybydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); if (dt.Rows.Count > 0) { this.txtSystemClRight.Value = "0"; this.txtSystemYdRight.Value = "1"; } //判断是否历史处理人 //判断是否是历史处理人员 if (Hyoa_global.ifhistoryclr(this.txtdocid.Value, this.Session["hyuid"].ToString())) { this.txtifhistoryclr.Value = "1"; this.txtSystemClRight.Value = "0"; this.txtSystemYdRight.Value = "1"; } } else { //////////////流程未结束/////////////////////// //判断是否为当前处理人 if (this.hy_curclrid.Text.IndexOf(this.Session["hyuid"].ToString()) >= 0) { this.txtSystemClRight.Value = "1"; this.td_submit.Visible = true; //保存 this.td_nextstep.Visible = true; //提交 this.td_returnsumbit.Visible = true; //退回 //-------条件流程start------- HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache(); DataTable dt_firsttache = Hyoa_flowtache.Getflowtachebyflowidtacheid(this.hy_flowid.Text, this.hy_curtacheid.Text); if (dt_firsttache.Rows.Count > 0) { if (dt_firsttache.Rows[0]["hy_enablecondition"].ToString() == "是") ConditionFlow(this.hy_flowid.Text, this.hy_curtacheid.Text); } //-------条件流程end------- } else { //判断是否为传阅人 HyoaClass.Hyoa_flowhistoryinfo_cy Hyoa_flowhistoryinfo_cy = new HyoaClass.Hyoa_flowhistoryinfo_cy(); dt = Hyoa_flowhistoryinfo_cy.Getifcyrybydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString()); if (dt.Rows.Count > 0) { this.txtSystemYdRight.Value = "1"; } //判断是否是上一环节处理人 if (Hyoa_global.iflastclr(this.txtdocid.Value, this.Session["hyuid"].ToString())) { this.txtiflastclr.Value = "1"; this.txtSystemYdRight.Value = "1"; this.td_withdraw.Visible = true; //收回 this.td_press.Visible = true; //催办 } else { //判断是否是历史处理人员 if (Hyoa_global.ifhistoryclr(this.txtdocid.Value, this.Session["hyuid"].ToString())) { this.txtifhistoryclr.Value = "1"; this.txtSystemYdRight.Value = "1"; this.td_press.Visible = true; //催办 } } } //判断是否为最后一个环节 HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork(); DataTable dtflowwork = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.hy_flowid.Text, this.hy_curtacheid.Text); if (dtflowwork.Rows.Count > 0) { if (dtflowwork.Rows[0]["hy_nexttacheid"].ToString() == "**") this.txtiflasttache.Value = "1"; } dtflowwork.Clear(); //////////////流程未结束/////////////////////// } //如果表单是流程后公开显示,则置为阅读权限 if (this.hy_curtacheid.Text == "**") { HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig(); DataTable dt_tableconfig = Hyoa_tableconfig.GetTable(this.hy_tableid.Text); if (dt_tableconfig.Rows.Count > 0) { if (dt_tableconfig.Rows[0]["hy_ispuballByflowYB"].ToString() == "是") { this.txtSystemYdRight.Value = "1"; } } } //没有操作权限的用户,如果是全权用户,则置为阅读权限 ADD BY XF 2011-11-17 if (this.txtSystemClRight.Value == "0" && this.txtSystemYdRight.Value == "0") { //得到当前模块对应的全权用户组 HyoaClass.Hyoa_mudel Hyoa_mudel_forqqyh = new HyoaClass.Hyoa_mudel(); DataTable dt_mudel_forqqyh = Hyoa_mudel_forqqyh.Getmudel(this.hy_mudelid.Text); if (dt_mudel_forqqyh.Rows.Count > 0) { if (dt_mudel_forqqyh.Rows[0]["hy_qqroleid"] != null) { if (dt_mudel_forqqyh.Rows[0]["hy_qqroleid"] != "") { string ls_role_forqqyh = dt_mudel_forqqyh.Rows[0]["hy_qqroleid"].ToString(); HyoaClass.Hyoa_global Hyoa_global_forqqyh = new HyoaClass.Hyoa_global(); if (Hyoa_global_forqqyh.isHaveRole(ls_role_forqqyh, this.Session["hyuid"].ToString())) { this.txtSystemYdRight.Value = "1"; //阅读权限 } } } } } //指定的特殊模块,流转过程中,所有人员可以浏览该文档 hySetYdRight_TS(); //既没有处理权限,又没有阅读权限的情况下 if (this.txtSystemClRight.Value == "0" && this.txtSystemYdRight.Value == "0") { if (this.txtifpop.Value == "") { Response.Write("<script>alert('您无权进行此项操作,请联系管理员!');window.location='" + this.txturl.Value + "';</script>"); this.td_submit.Visible = false; this.td_nextstep.Visible = false; return; } else { Response.Write("<script>alert('您无权进行此项操作,请联系管理员!');self.close();</script>"); return; } } //加载页面 GetMainTableHtml("1", this.txtSystemClRight.Value, "1", this.hy_curtacheid.Text); } else { //this.lblcurtachenameshow.Text = this.lbltablename.Text; //非流程表单 this.td_nextstep.Visible = false; this.td_withdraw.Visible = false; this.td_returnsumbit.Visible = false; this.td_press.Visible = false; this.td_browseflow.Visible = false; ////////////判断当前表单是否为只显示个人 //////////HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig(); //////////DataTable dt_tableconfig = Hyoa_tableconfig.GetTablesbymudelidandtableid(this.hy_mudelid.Text, this.hy_tableid.Text); //////////if (dt_tableconfig.Rows.Count > 0) //////////{ ////////// //不是流程文档,不显示所有记录 ////////// if (dt_tableconfig.Rows[0]["hy_ifflowdoc"].ToString() == "否" && dt_tableconfig.Rows[0]["hy_ifdisplayall"].ToString() == "否") ////////// { ////////// //判断是否为当前文档登记人 ////////// if(this.hy_djrid.Text==Session["hyuid"].ToString()) ////////// this.txtSystemClRight.Value = "1"; ////////// } ////////// else ////////// { ////////// if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1") ////////// this.txtSystemClRight.Value = "1"; ////////// } //////////} //如果非流程(授权用户统一管理) if (this.txttablerole.Value == "0") { if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1") this.txtSystemClRight.Value = "1"; } //如果非流程(每个人管理自己的信息) if (this.txttablerole.Value == "1") { //判断是否为当前文档登记人 if (this.hy_djrid.Text == Session["hyuid"].ToString()) this.txtSystemClRight.Value = "1"; } //如果非流程(每个人操作自己的信息、授权用户可管理所有信息) if (this.txttablerole.Value == "2") { if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1") { this.txtSystemClRight.Value = "1"; } else { if (this.hy_djrid.Text == Session["hyuid"].ToString()) this.txtSystemClRight.Value = "1"; } } //如果非流程(授权用户可新建、只能删自己新建的信息) if (this.txttablerole.Value == "3") { if (Hy_IfHaveRole(this.hy_mudelid.Text, Session["hyuid"].ToString()) == "1") { if (this.hy_djrid.Text == Session["hyuid"].ToString()) this.txtSystemClRight.Value = "1"; } } if (this.txtSystemClRight.Value == "1") { this.td_submit.Visible = true; //保存 } else { this.td_submit.Visible = false; //保存 } //加载主表单页面 GetMainTableHtml("1", this.txtSystemClRight.Value, "0", ""); } } hywebopen_olddoc(); //旧文档OPEN的特殊处理 } } }
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //保存 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 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>"); //} }