protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { SqlDataReader datar1 = SqlHelper.ExecuteReader("SELECT A.*,B.ui_desc,C.fName FROM hk_WorkFolder A LEFT OUTER JOIN yh B ON(A.fdPromoterID=B.ui_id) LEFT OUTER JOIN hk_Form C ON(A.FK_fid=C.fID) WHERE fdID='" + hkdb.GetStr(Request.QueryString["id"]) + "'"); if (datar1.Read()) { strserid = datar1["fdSerialNo"].ToString(); Number.Text = datar1["fdNo"].ToString(); Name = datar1["fdName"].ToString(); strwfno = datar1["FK_wfno"].ToString(); string setfrom = null; setfrom = hkdb.GetStrTeOut(datar1["fdContent"].ToString().Replace("BACKGROUND-COLOR:", "").Replace("id=Text1", "readonly").Replace("id=\"Text1\"", "readonly").Replace("id=Text2", "readonly").Replace("id=\"Text2\"", "readonly").Replace("id=Text3", "readonly").Replace("id=\"Text3\"", "readonly")); ContractContent.Text = setfrom; lbltx.Text = setfrom; strfName = datar1["fName"].ToString(); lblFcname.Text = datar1["ui_desc"].ToString(); lblwTitle.Text = datar1["fdTitle"].ToString(); } datar1.Close(); SqlDataReader datar2 = SqlHelper.ExecuteReader("SELECT * FROM hk_Work WHERE wNo='" + hkdb.GetStr(Number.Text) + "'"); if (datar2.Read()) { strwfid = datar2["wID"].ToString(); } datar2.Close(); } BindDplist(); }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("9"); if (!IsPostBack) { SqlDataReader dr = SqlHelper.ExecuteReader("SELECT A.*,B.fName FROM hk_Work A LEFT OUTER JOIN hk_Form B ON(A.FK_fid=B.fID) WHERE wID='" + hkdb.GetStr(Request.QueryString["id"]) + "'"); if (dr.Read()) { strfnName = dr["NextNodeName"].ToString(); strwSerialNo = dr["wSerialNo"].ToString(); Number.Text = dr["wNo"].ToString(); Name = dr["wName"].ToString(); FlowNumber = dr["FK_wfno"].ToString(); string setfrom = null; setfrom = hkdb.GetStrTeOut(dr["wContent"].ToString().Replace("BACKGROUND-COLOR:", "").Replace("id=Text1", "readonly").Replace("id=\"Text1\"", "readonly").Replace("id=Text2", "readonly").Replace("id=\"Text2\"", "readonly").Replace("id=Text3", "readonly").Replace("id=\"Text3\"", "readonly")); lblhtm.Text = setfrom; strfName = dr["fName"].ToString(); lblwTitle.Text = dr["wTitle"].ToString(); lblwStatus.Text = dr["wStatus"].ToString(); } dr.Close(); //附件 bd.GetAtt(Number.Text, "wk", "flow/work", fujian); } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { hkdb.PassTo("10907", "0"); DropDownListBind(); SqlDataReader dr = SqlHelper.ExecuteReader("SELECT * FROM hk_Form WHERE fID='" + hkdb.GetStr(Request.QueryString["id"]) + "'"); if (dr.Read()) { editor.Value = hkdb.GetStrTeOut(dr["fContent"].ToString()); FormType.SelectedValue = dr["FK_fcid"].ToString(); FormName.Text = dr["fName"].ToString(); UserID.Text = dr["fUserIDs"].ToString(); UserName.Text = dr["fUserNames"].ToString(); Number.Text = dr["fNo"].ToString(); } dr.Close(); BindAttr(); } BindList(); }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("9"); if (!IsPostBack) { hkdb.PassTo("10120", "10120"); qy_fjylurl.Text = Convert.ToString(SqlHelper.ExecuteScalar("SELECT qy_fjylurl FROM qy WHERE qy_id='001'")); SqlDataReader datar = SqlHelper.ExecuteReader("SELECT b.ui_desc as ui_desc,a.cjsj as cjsj,c.bm_mc as bm_mc,d.zwmc as zwmc,a.rczt as rczt,a.rcms as rcms,a.fjmc as fjmc,a.fjlj as fjlj from hk_Wdrc a left join yh b on a.syz=b.ui_id left join BM c on b.ui_ssbm=c.bm_id left join ZW d on b.ui_zw=d.zwid WHERE RCID='" + hkdb.GetStr(Request.QueryString["rcid"].ToString()) + "'"); if (datar.Read()) { rzr.Text = datar["ui_desc"].ToString(); //cjsj.Text=hkdb.GetDate(datar["cjsj"].ToString()); cjsj.Text = datar["cjsj"].ToString(); szbm.Text = datar["bm_mc"].ToString(); zw.Text = datar["zwmc"].ToString(); rzzt.Text = datar["rczt"].ToString(); rzms.Text = hkdb.GetStrTeOut(datar["rcms"].ToString()); savefj.Text = datar["fjmc"].ToString(); savefj.NavigateUrl = (datar["fjlj"] == System.DBNull.Value ? "" : "../.." + datar["fjlj"]) + datar["fjmc"].ToString(); datar.Close(); } else { datar.Close(); mydb.Alert_Close("此记录不存在,可能已被完成或删除!"); return; } } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { SqlDataReader dr = SqlHelper.ExecuteReader("SELECT A.*,B.fName,C.ui_desc,D.fnName FROM hk_WorkEnTrust A LEFT OUTER JOIN hk_Form B ON(A.FK_fid=B.fID) LEFT OUTER JOIN yh C ON(A.etUserID=C.ui_id) LEFT OUTER JOIN hk_WorkFlowNode D ON(A.FK_fnno=D.fnNo) WHERE etID='" + hkdb.GetStr(Request.QueryString["id"]) + "'"); if (dr.Read()) { strwSerialNo = dr["etSerialNo"].ToString(); Number.Text = dr["etNo"].ToString(); Name = dr["etName"].ToString(); FlowNumber = dr["FK_wfno"].ToString(); string setfrom = null; setfrom = hkdb.GetStrTeOut(dr["etContent"].ToString().Replace("BACKGROUND-COLOR:", "").Replace("id=Text1", "readonly").Replace("id=\"Text1\"", "readonly").Replace("id=Text2", "readonly").Replace("id=\"Text2\"", "readonly").Replace("id=Text3", "readonly").Replace("id=\"Text3\"", "readonly")); ContractContent.Text = setfrom; lbltx.Text = setfrom; strfName = dr["fName"].ToString(); lbluName.Text = dr["ui_desc"].ToString(); lblwTitle.Text = dr["etTitle"].ToString(); strfnName = dr["fnName"].ToString(); } dr.Close(); } BindDroList(); }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("9"); if (!IsPostBack) { hkdb.PassTo("10302", "0"); qy_fjylurl.Text = Convert.ToString(SqlHelper.ExecuteScalar("SELECT qy_fjylurl FROM qy WHERE qy_id='001'")); //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); SqlDataReader datar = SqlHelper.ExecuteReader("SELECT A.*,B.UI_DESC,C.MC AS RWXZ_MC FROM OA_RWD01 A LEFT OUTER JOIN YH B ON (A.FBR=B.UI_ID) LEFT OUTER JOIN HK_ZDYLX C ON(A.RWXZ=C.ID) WHERE A.RWID='" + hkdb.GetStr(Request.QueryString["rwid"].ToString()) + "' AND RWZT='已发布'"); if (datar.Read()) { rwidstr.Text = datar["rwid"].ToString(); rwly.Text = datar["source"].ToString(); rwdh.Text = datar["rwdh"].ToString(); rw_nr = datar["rwid"].ToString(); lblrwbt.Text = datar["rwbt"].ToString(); lbljjcd.Text = datar["jjcd"].ToString(); lblrwxz.Text = datar["RWXZ_MC"].ToString(); lbljsdx.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["jsdx"].ToString() + "','1'")); qtld.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["qtld"].ToString() + "','1'")); zrld.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["zrld"].ToString() + "','1'")); zrr.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["zrr"].ToString() + "','1'")); lblksrq.Text = datar["ksrq"].ToString(); lbljzrq.Text = datar["jzrq"].ToString(); lblnr.Text = ReplaceHtmlTag(hkdb.GetStrTeOut(datar["rwnr"].ToString())); lblynxs.Text = datar["ynxs"].ToString(); savefj.Text = datar["fjmc"].ToString(); fbrmc.Text = datar["ui_desc"].ToString(); fqsj.Text = string.Format("{0:d}", datar["fbsj"]); savefj.Text = datar["fjmc"].ToString(); savefj.NavigateUrl = (datar["fjlj"] == System.DBNull.Value ? "" : "../.." + datar["fjlj"]) + datar["fjmc"].ToString(); datar.Close(); if (lblynxs.Text == "是") { Panelrq.Visible = true; } //页面绑定 GridViewBind(); GridViewBind2(); GridViewBind3(); GridViewBind4(); } else { datar.Close(); mydb.Alert_Close("此记录不存在,可能已被完成或删除!"); return; } } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { hkdb.PassTo("10114", "0"); //附件 SqlDataReader dr_fj = SqlHelper.ExecuteReader("SELECT p_string FROM hk_CSDA WHERE paramt='P_AttType'"); if (dr_fj.Read()) { attKey = dr_fj["p_string"].ToString(); } dr_fj.Close(); BindAttr(); Random g = new Random(); string rad = g.Next(10000).ToString(); Number.Text = "" + System.DateTime.Now.Year.ToString() + "" + System.DateTime.Now.Month.ToString() + "" + System.DateTime.Now.Day.ToString() + "" + System.DateTime.Now.Hour.ToString() + "" + System.DateTime.Now.Minute.ToString() + "" + System.DateTime.Now.Second.ToString() + "" + System.DateTime.Now.Millisecond.ToString() + "" + rad + ""; SqlDataReader datar = SqlHelper.ExecuteReader("SELECT * FROM HK_WDYJ WHERE YJID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'"); if (datar.Read()) { lblyjbt.Text = datar["yjbt"].ToString(); editor.Value = hkdb.GetStrTeOut(datar["yjnr"].ToString()); lblfbsj.Text = string.Format("{0:d}", datar["fbsj"]); lblfbrmc.Text = datar["fbrmc"].ToString(); lblhfnr.Text = datar["hfnr"].ToString(); lblhfsj.Text = string.Format("{0:d}", datar["hfsj"]); lblhfrmc.Text = datar["hfrmc"].ToString(); if (!string.IsNullOrEmpty(datar["fjmc"].ToString())) { Number.Text = datar["fjmc"].ToString(); } if (datar["zt"].ToString() == "待回复") { SaveBtn.Visible = true; DelBtn.Visible = true; uploadBtn.Visible = true; AttDelBtn.Visible = true; } datar.Close(); } else { datar.Close(); mydb.Alert_Close("此记录不存在,可能已被删除!"); } } BindDpList(); }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { SqlDataReader datar1 = SqlHelper.ExecuteReader("SELECT A.*,B.fName FROM hk_Work A LEFT OUTER JOIN hk_Form B ON(A.FK_fid=B.fID) WHERE wID='" + hkdb.GetStr(Request.QueryString["id"]) + "'"); if (datar1.Read()) { strfnName = datar1["NextNodeName"].ToString(); lshid = datar1["wSerialNo"].ToString(); Number.Text = datar1["wNo"].ToString(); Name = datar1["wName"].ToString(); FlowNumber = datar1["FK_wfno"].ToString(); string setfrom = null; setfrom = hkdb.GetStrTeOut(datar1["wContent"].ToString().Replace("BACKGROUND-COLOR:", "").Replace("id=Text1", "readonly").Replace("id=\"Text1\"", "readonly").Replace("id=Text2", "readonly").Replace("id=\"Text2\"", "readonly").Replace("id=Text3", "readonly").Replace("id=\"Text3\"", "readonly")); ContractContent.Text = setfrom; lbltx.Text = setfrom; strfName = datar1["fName"].ToString(); lblwTitle.Text = datar1["wTitle"].ToString(); lblwStatus.Text = datar1["wStatus"].ToString(); } datar1.Close(); //审批意见 int glTMP3 = 0; int sta2 = 0; string strAtt2 = "<table width=100% border=1 cellspacing=0 cellpadding=0 class=form><tr><td align=center><b>审批意见</b></td></tr><tr>"; SqlDataReader datar3 = SqlHelper.ExecuteReader("SELECT A.*,B.ui_desc FROM hk_WorkAppComm A LEFT OUTER JOIN yh B ON(A.FK_uid=B.ui_id) WHERE ac_wfID='" + hkdb.GetStr(Request.QueryString["id"]) + "' AND ac_Status='有效' ORDER BY acID"); while (datar3.Read()) { strAtt2 += " <td width=100%><font color=red>" + datar3["acContent"].ToString() + "</font> " + datar3["ui_desc"].ToString() + " " + string.Format("{0:yyyy-MM-dd HH:mm}", datar3["AddTime"]) + " <a href=WorkAttDown.aspx?number=" + datar3["acAttNewName"].ToString() + " target=_blank class=gvlink>" + datar3["acAttName"].ToString() + "</a></td>"; glTMP3 = glTMP3 + 1; if (glTMP3 == 1) { strAtt2 += "</tr><tr>"; glTMP3 = 0; } sta2 = 1; } datar3.Close(); strAtt2 += " </table>"; if (sta2 == 1) { lblspyj.Text = strAtt2; } } BindDplist(); }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { hkdb.PassTo("10306", "0"); qy_fjylurl.Text = Convert.ToString(SqlHelper.ExecuteScalar("SELECT qy_fjylurl FROM qy WHERE qy_id='001'")); //dp绑定 SqlDataReader datar = SqlHelper.ExecuteReader("select A.*,B.mc from OA_RWD01 A LEFT OUTER JOIN hk_ZDYLX B ON(A.RWXZ=B.ID) where A.rwid='" + hkdb.GetStr(Request.QueryString["rwid"].ToString()) + "'"); if (datar.Read()) { rwly.Text = datar["source"].ToString(); rwidstr.Text = datar["rwid"].ToString(); rwdh.Text = datar["rwdh"].ToString(); lbljjcd.Text = datar["jjcd"].ToString(); lblrwxz.Text = datar["mc"].ToString(); lbljsdx.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["jsdx"].ToString() + "','1'")); qtld.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["qtld"].ToString() + "','1'")); zrld.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["zrld"].ToString() + "','1'")); zrr.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["zrr"].ToString() + "','1'")); lblnr.Text = hkdb.GetStrTeOut(datar["rwnr"].ToString()); lblynxs.Text = datar["ynxs"].ToString(); lblksrq.Text = datar["ksrq"].ToString(); lbljzrq.Text = datar["jzrq"].ToString(); if (datar["ynxs"].ToString() == "是") { Panelrq.Visible = true; } lblrwbt.Text = datar["rwbt"].ToString(); fqsj.Text = string.Format("{0:d}", datar["fbsj"]); savefj.Text = datar["fjmc"].ToString(); savelj.Text = datar["fjlj"].ToString(); savefj.NavigateUrl = (datar["fjlj"] == System.DBNull.Value ? "" : "../.." + datar["fjlj"]) + datar["fjmc"].ToString(); datar.Close(); } else { datar.Close(); mydb.Alert_Close("此记录不存在,可能已被删除!"); } } //页面绑定 GridViewBind(); }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { SqlDataReader dr = SqlHelper.ExecuteReader("SELECT A.*,B.fcName FROM hk_Form A LEFT OUTER JOIN hk_FormClass B ON(A.FK_fcid=B.fcID) WHERE fID='" + hkdb.GetStr(Request.QueryString["id"]) + "'"); if (dr.Read()) { fClass.Text = dr["fcName"].ToString(); fName.Text = dr["fName"].ToString(); fContent.Text = hkdb.GetStrTeOut(dr["fContent"].ToString().Replace("id=\"Text1\"", "id=\"Text1\" readonly ").Replace("id=Text1", "id=Text1 readonly ").Replace("id=\"TextArea1\"", "id=\"TextArea1\" readonly ").Replace("id=TextArea1", "id=TextArea1 readonly ").Replace("id=\"Checkbox1\"", "id=\"Checkbox1\" disabled=true ").Replace("id=Checkbox1", "id=Checkbox1 disabled=true ")); } dr.Close(); } }
protected void Page_Load(object sender, EventArgs e) { mydb hkdb = new mydb(); hkdb.VeriSess("9"); if (!IsPostBack) { hkdb.PassTo("10116", "0"); qy_fjylurl.Text = Convert.ToString(SqlHelper.ExecuteScalar("SELECT qy_fjylurl FROM qy WHERE qy_id='001'")); SqlDataReader datar = SqlHelper.ExecuteReader("SELECT A.*,B.UI_DESC,C.MC AS RWXZ_MC FROM OA_RWD01 A LEFT OUTER JOIN YH B ON (A.FBR=B.UI_ID) LEFT OUTER JOIN HK_ZDYLX C ON(A.RWXZ=C.ID) WHERE RWID='" + hkdb.GetStr(Request.QueryString["rwid"].ToString()) + "'"); if (datar.Read()) { rwly.Text = datar["source"].ToString(); //rwdh.Text = datar["rwdh"].ToString(); rwid_nr = datar["rwid"].ToString(); lblrwbt.Text = datar["rwbt"].ToString(); lbljjcd.Text = datar["jjcd"].ToString(); lblrwxz.Text = datar["RWXZ_MC"].ToString(); lbljsdx.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["jsdx"].ToString() + "','1'")); qtld.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["qtld"].ToString() + "','1'")); zrld.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["zrld"].ToString() + "','1'")); zrr.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["zrr"].ToString() + "','1'")); qtbm.Text = datar["qtbm"].ToString(); zrbm.Text = datar["zrbm"].ToString(); lblnr.Text = ReplaceHtmlTag(hkdb.GetStrTeOut(datar["rwnr"].ToString())); lblynxs.Text = datar["ynxs"].ToString(); savefj.Text = datar["fjmc"].ToString(); fqsj.Text = string.Format("{0:d}", datar["fbsj"]); fbrmc.Text = datar["ui_desc"].ToString(); savefj.Text = datar["fjmc"].ToString(); savefj.NavigateUrl = (datar["fjlj"] == System.DBNull.Value ? "" : "../.." + datar["fjlj"]) + datar["fjmc"].ToString(); datar.Close(); } else { datar.Close(); mydb.Alert_Close("此记录不存在,可能已被删除!"); } } }
protected void Page_Load(object sender, EventArgs e) { mydb hkdb = new mydb(); hkdb.VeriSess("4"); if (!IsPostBack) { hkdb.PassTo("10116", "0"); qy_fjylurl.Text = Convert.ToString(SqlHelper.ExecuteScalar("SELECT qy_fjylurl FROM qy WHERE qy_id='001'")); SqlDataReader datar = SqlHelper.ExecuteReader("SELECT A.*,B.UI_DESC,C.MC AS RWXZ_MC FROM OA_RWD01 A LEFT OUTER JOIN YH B ON (A.FBR=B.UI_ID) LEFT OUTER JOIN HK_ZDYLX C ON(A.RWXZ=C.ID) WHERE RWID='" + hkdb.GetStr(Request.QueryString["rwid"].ToString()) + "'"); if (datar.Read()) { rwly.Text = datar["source"].ToString(); rwdh.Text = datar["rwdh"].ToString(); lblrwbt.Text = datar["rwbt"].ToString(); lbljjcd.Text = datar["jjcd"].ToString(); lblrwxz.Text = datar["RWXZ_MC"].ToString(); lbljsdx.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["jsdx"].ToString() + "','1'")); qtld.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["qtld"].ToString() + "','1'")); zrld.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["zrld"].ToString() + "','1'")); zrr.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["zrr"].ToString() + "','1'")); lblksrq.Text = datar["ksrq"].ToString(); lbljzrq.Text = datar["jzrq"].ToString(); lblnr.Text = hkdb.GetStrTeOut(datar["rwnr"].ToString()); lblynxs.Text = datar["ynxs"].ToString(); savefj.Text = datar["fjmc"].ToString(); fqsj.Text = string.Format("{0:d}", datar["fbsj"]); fbrmc.Text = datar["ui_desc"].ToString(); savefj.Text = datar["fjmc"].ToString(); savefj.NavigateUrl = (datar["fjlj"] == System.DBNull.Value ? "" : "../.." + datar["fjlj"]) + datar["fjmc"].ToString(); datar.Close(); if (lblynxs.Text == "是") { Panelrq.Visible = true; } SqlDataReader dr = SqlHelper.ExecuteReader("select a.*,b.ui_desc,c.ui_desc as sprmc from OA_RWD02 a left outer join yh b on (a.clr=b.ui_id) left outer join yh c on (a.spr=c.ui_id) where jsid='" + hkdb.GetStr(Request.QueryString["jsid"].ToString()) + "'"); if (dr.Read()) { //lblfpxs.Text = dr["fpxs"].ToString(); //lblfpry.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + dr["fpry"].ToString() + "','1'")); //lblfpsm.Text = dr["fpsm"].ToString(); lblwcqk.Text = dr["bzsm"].ToString(); wcsjmc.Text = string.Format("{0:d}", dr["clsj"]); wcrmc.Text = dr["ui_desc"].ToString(); savefj_yh.Text = dr["fjmc"].ToString(); savefj_yh.NavigateUrl = (dr["fjlj"] == System.DBNull.Value ? "" : "../.." + dr["fjlj"]) + dr["fjmc"].ToString(); lblspyj.Text = dr["spyj"].ToString(); lblsppj.Text = dr["sppj"].ToString(); spsjmc.Text = string.Format("{0:d}", dr["spsj"]); sprmc.Text = dr["sprmc"].ToString(); } dr.Close(); } else { datar.Close(); mydb.Alert_Close("此记录不存在,可能已被删除!"); } } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("9"); if (!IsPostBack) { SqlDataReader datar1 = SqlHelper.ExecuteReader("SELECT * FROM hk_WorkFlowNode WHERE fnID='" + int.Parse(Request.QueryString["UpNodeId"]) + "'"); if (datar1.Read()) { lblstrfnName.Text = datar1["fnName"].ToString(); strNextNodeNum = datar1["NextNodeNum"].ToString(); strnnNumkey = datar1["NextNodeNum"].ToString(); lblnnnk.Text = datar1["NextNodeNum"].ToString(); strfnid = datar1["fnID"].ToString(); strfnWriteID = "" + datar1["fnWriteID"].ToString() + "0"; } datar1.Close(); SqlDataReader datar2 = SqlHelper.ExecuteReader("SELECT A.*,B.fName FROM hk_Work A LEFT OUTER JOIN hk_Form B ON(A.FK_fid=B.fID) WHERE wID='" + hkdb.GetStr(Request.QueryString["id"]) + "'"); if (datar2.Read()) { strbkNextNodeNum = datar2["NextNodeNum"].ToString(); Number.Text = datar2["wNo"].ToString(); lblName.Text = datar2["wName"].ToString(); lblstrAudiMode.Text = datar2["ReviewMode"].ToString(); strwUserIDs = datar2["wUserIDs"].ToString(); lblstrhyUserIDs.Text = datar2["wUserIDs"].ToString().Replace("" + this.Session["userid"].ToString() + ",", ""); lblstrhyUserNames.Text = datar2["wUserNames"].ToString().Replace("" + this.Session["username"].ToString() + ",", ""); string setfrom = null; setfrom = hkdb.GetStrTeOut(datar2["wContent"].ToString().Replace("BACKGROUND-COLOR:", "").Replace("readOnly", "").Replace("BACKGROUND-COLOR: #EFEFEF", "").Replace("readonly", "").Replace("id=Text2", "readonly").Replace("id=\"Text2\"", "readonly")); //可写字段 SqlDataReader dr_fc = SqlHelper.ExecuteReader("SELECT * FROM hk_FormColumn WHERE clID NOT IN(" + strfnWriteID + ") AND clType!='[电子印章]'"); while (dr_fc.Read()) { setfrom = setfrom.Replace("name=" + dr_fc["clNo"] + "", "name=" + dr_fc["clNo"] + " style=\"BACKGROUND-COLOR: #EFEFEF\" readonly").Replace("name=\"" + dr_fc["clNo"] + "\"", "name=" + dr_fc["clNo"] + " style=\"BACKGROUND-COLOR: #EFEFEF\" readonly"); } dr_fc.Close(); lblhtm.Text = setfrom; lblFormName.Text = datar2["fName"].ToString(); lblwTitle.Text = datar2["wTitle"].ToString(); } datar2.Close(); //判断是否转到下一个节点 int m = strwUserIDs.Length; int s = strwUserIDs.Replace(",", "").Length; a = m - s; if (a <= 1) { Button4.Visible = true; Button1.Visible = false; } else { if (lblstrAudiMode.Text == "仅一人通过审批即可向下流转") { Button4.Visible = true; } else { Button4.Visible = false; } Button1.Visible = true; } //审批意见 string strAtt2 = ""; SqlDataReader datar3 = SqlHelper.ExecuteReader("SELECT A.*,B.ui_desc FROM hk_WorkAppComm A LEFT OUTER JOIN yh B ON(A.FK_uid=B.ui_id) WHERE ac_wfID='" + hkdb.GetStr(Request.QueryString["id"]) + "' AND ac_Status='有效' ORDER BY acID"); while (datar3.Read()) { strAtt2 += "<br>·<font color=red>" + datar3["acContent"].ToString() + "</font> " + datar3["ui_desc"].ToString() + " " + string.Format("{0:yyyy-MM-dd HH:mm}", datar3["AddTime"]) + " <a href=../../workflow/Work/WorkAttDown.aspx?number=" + datar3["acAttNewName"].ToString() + " target=_blank>" + datar3["acAttName"].ToString() + "</a>"; } datar3.Close(); lblspyj.Text = strAtt2; //附件 bd.GetAtt(Number.Text, "wk", "flow/work", fujian); } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { //附件类型 SqlDataReader dr = SqlHelper.ExecuteReader("SELECT p_string FROM hk_CSDA WHERE paramt='P_AttType'"); if (dr.Read()) { attKey = dr["p_string"].ToString(); } dr.Close(); //职位 lblZwmc.Text = Convert.ToString(SqlHelper.ExecuteScalar("SELECT B.ZWMC FROM YH A LEFT OUTER JOIN ZW B ON(A.UI_ZW=B.ZWID) WHERE A.UI_ID='" + this.Session["userid"] + "'")); BindAttr(); SqlDataReader datar1 = SqlHelper.ExecuteReader("SELECT * FROM hk_WorkFlowNode WHERE fnPosition='开始' AND FK_wfno='" + hkdb.GetStr(Request.QueryString["FlowNumber"]) + "'"); if (datar1.Read()) { nowfnName = datar1["fnName"].ToString(); NextNodeNum = datar1["NextNodeNum"].ToString(); NextNodeNumKey = datar1["NextNodeNum"].ToString(); lbloNextNodeNum.Text = datar1["NextNodeNum"].ToString(); strfnid = datar1["fnID"].ToString(); fnWriteID = "" + datar1["fnWriteID"].ToString() + "0"; //编辑附件 if (datar1["ynEditAtt"].ToString() == "是") { editimg.Visible = true; } else { editimg.Visible = false; } //删除附件 if (datar1["ynDelAtt"].ToString() == "是") { delBtn.Visible = true; } else { delBtn.Visible = false; } //编号计数 SqlDataReader dr_w = SqlHelper.ExecuteReader("SELECT TOP 1 wID,wFileNo FROM hk_Work WHERE FK_wfno='" + hkdb.GetStr(Request.QueryString["FlowNumber"]) + "' ORDER BY wID DESC"); if (dr_w.Read()) { nNameid = int.Parse(dr_w["wFileNo"].ToString()) + 1; SqlDataReader dr_wf = SqlHelper.ExecuteReader("SELECT FileNo,FileDigit,wfName,ynModFileNo FROM hk_WorkFlow WHERE wfNo='" + hkdb.GetStr(Request.QueryString["FlowNumber"]) + "'"); if (dr_wf.Read()) { if (dr_wf["ynModFileNo"].ToString() == "否") { fileid.Attributes.Add("readonly", "readonly"); } fileid.Text = showform.FormatFileno(dr_wf["FileNo"].ToString(), nNameid.ToString().PadLeft(int.Parse(dr_wf["FileDigit"].ToString()), '0'), dr_wf["FileDigit"].ToString(), dr_wf["wfName"].ToString()); } dr_wf.Close(); } else { SqlDataReader dr_wf = SqlHelper.ExecuteReader("SELECT FileNo,FileStartNo,FileDigit,wfName,ynModFileNo FROM hk_WorkFlow WHERE wfNo='" + hkdb.GetStr(Request.QueryString["FlowNumber"]) + "'"); if (dr_wf.Read()) { if (dr_wf["ynModFileNo"].ToString() == "否") { fileid.Attributes.Add("readonly", "readonly"); } nNameid = int.Parse(dr_wf["FileStartNo"].ToString()); fileid.Text = showform.FormatFileno(dr_wf["FileNo"].ToString(), nNameid.ToString().PadLeft(int.Parse(dr_wf["FileDigit"].ToString()), '0'), dr_wf["FileDigit"].ToString(), dr_wf["wfName"].ToString()); } dr_wf.Close(); } dr_w.Close(); } else { mydb.Alert_Close("该流程尚未创建【开始步骤】,请重新设计!"); return; } datar1.Close(); if (!string.IsNullOrEmpty(Request.QueryString["wid"])) { //如果重新发起 SqlDataReader datar2 = SqlHelper.ExecuteReader("SELECT A.wTitle,A.wContent,B.fName FROM hk_Work A LEFT OUTER JOIN hk_Form B ON(A.FK_fid=B.fID) WHERE A.wID='" + hkdb.GetStr(Request.QueryString["wId"]) + "'"); if (datar2.Read()) { wTitle.Text = "重新发起:" + datar2["wTitle"].ToString(); string setfrom = null; setfrom = hkdb.GetStrTeOut(datar2["wContent"].ToString().Replace("BACKGROUND-COLOR:", "").Replace("readOnly", "").Replace("BACKGROUND-COLOR: #EFEFEF", "").Replace("readonly", "").Replace("id=Text2", "readonly").Replace("id=\"Text2\"", "readonly")); //可写字段 SqlDataReader dr_fc = SqlHelper.ExecuteReader("SELECT * FROM hk_FormColumn WHERE clID NOT IN(" + fnWriteID + ") AND clType!='[电子印章]'"); while (dr_fc.Read()) { setfrom = setfrom.Replace("name=" + dr_fc["clNo"] + "", "name=" + dr_fc["clNo"] + " style=\"BACKGROUND-COLOR: #EFEFEF\" readonly").Replace("name=\"" + dr_fc["clNo"] + "\"", "name=" + dr_fc["clNo"] + " style=\"BACKGROUND-COLOR: #EFEFEF\" readonly"); } dr_fc.Close(); ContractContent.Text = setfrom; lblwricolu.Text = setfrom; fName = datar2["fName"].ToString(); } datar2.Close(); } else { //如果是新发起 //表单 SqlDataReader datar2 = SqlHelper.ExecuteReader("SELECT * FROM hk_Form WHERE fID='" + hkdb.GetStr(Request.QueryString["FormId"]) + "'"); if (datar2.Read()) { string setfrom = null; setfrom = hkdb.GetStrTeOut(datar2["fContent"].ToString().Replace("BACKGROUND-COLOR: #EFEFEF", "").Replace("readonly", "").Replace("value=\"宏控件-用户姓名\"", "readonly value=\"" + this.Session["username"].ToString() + "\"").Replace("value=\"宏控件-用户部门\"", "readonly value=\"" + this.Session["deptname"].ToString() + "\"").Replace("value=\"宏控件-用户角色\"", "readonly value=\"" + Server.UrlDecode(Request.Cookies["haoke"].Values["rolename"].ToString()) + "\"").Replace("value=\"宏控件-用户职位\"", "readonly value=" + lblZwmc.Text + "").Replace("value=\"宏控件-当前日期\"", "readonly value=\"" + System.DateTime.Now.ToShortDateString() + "\"")); //自定义宏控件 SqlDataReader dr_wf = SqlHelper.ExecuteReader("SELECT wfName FROM hk_WorkFlow WHERE wfNo='" + hkdb.GetStr(Request.QueryString["FlowNumber"]) + "'"); if (dr_wf.Read()) { setfrom = showform.FormatMac(setfrom, fileid.Text, dr_wf["wfName"].ToString()); } dr_wf.Close(); //可写字段 SqlDataReader dr_fc = SqlHelper.ExecuteReader("SELECT * FROM hk_FormColumn WHERE clID NOT IN(" + fnWriteID + ") AND clType!='[电子印章]'"); while (dr_fc.Read()) { setfrom = setfrom.Replace("name=" + dr_fc["clNo"] + "", "name=" + dr_fc["clNo"] + " style=\"BACKGROUND-COLOR: #EFEFEF\" readonly").Replace("name=\"" + dr_fc["clNo"] + "\"", "name=" + dr_fc["clNo"] + " style=\"BACKGROUND-COLOR: #EFEFEF\" readonly"); } dr_fc.Close(); ContractContent.Text = setfrom; lblwricolu.Text = setfrom; fName = datar2["fName"].ToString(); } datar2.Close(); } //流水号 SqlDataReader datar3 = SqlHelper.ExecuteReader("SELECT TOP 1 wID FROM hk_Work ORDER BY wID DESC"); if (datar3.Read()) { serid = int.Parse(datar3["wID"].ToString()) + 1; } else { serid = 1; } datar3.Close(); } if (!IsPostBack) { Random g = new Random(); string rad = g.Next(10000).ToString(); Number.Text = "" + System.DateTime.Now.Year.ToString() + "" + System.DateTime.Now.Month.ToString() + "" + System.DateTime.Now.Day.ToString() + "" + System.DateTime.Now.Hour.ToString() + "" + System.DateTime.Now.Minute.ToString() + "" + System.DateTime.Now.Second.ToString() + "" + System.DateTime.Now.Millisecond.ToString() + "" + rad + ""; } BindDpList(); }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("3"); if (!IsPostBack) { hkdb.PassTo("10102,1002", "0"); //from收件箱 if (Request.QueryString["type"].ToString() == "s") { SqlHelper.ExecuteSql("UPDATE hk_Mail_JS SET JSZT='1',JSSJ=GETDATE() WHERE JSID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'"); //显示 SqlDataReader datar = SqlHelper.ExecuteReader("SELECT A.*,(CASE WHEN msbz='是' THEN '***密送邮件***' ELSE jsrNames END)AS jsrNames2,B.UI_DESC FROM hk_Mail_JS A LEFT OUTER JOIN YH B ON (A.JSR=B.UI_ID) WHERE JSID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'"); if (datar.Read()) { bt.Text = datar["jsbt"].ToString(); fjr.Text = datar["fsrName"].ToString(); sjr.Text = datar["ui_desc"].ToString() + "【" + datar["jsrNames2"].ToString() + "】"; rq.Text = datar["fssj"].ToString(); nr.Text = hkdb.GetStrTeOut(datar["jsnr"].ToString()); //附件 Number.Text = datar["yjfj"].ToString(); bd.GetAtt(Number.Text, "p01", "portal/yj", fujian); datar.Close(); } else { datar.Close(); mydb.Alert_Goto("该邮件不存在,可能已被删除!", "sjx.aspx?i=2"); } //Init WriteBtn.Visible = true; ZhuanBtn.Visible = true; DelBtn_s.Visible = true; BackBtn_s.Visible = true; } else { SqlDataReader datar1 = SqlHelper.ExecuteReader("SELECT A.* FROM hk_Mail_FS A WHERE YJID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'"); if (datar1.Read()) { bt.Text = datar1["fsbt"].ToString(); fjr.Text = datar1["fsrName"].ToString(); sjr.Text = datar1["jsrNames"].ToString(); rq.Text = datar1["fssj"].ToString(); nr.Text = hkdb.GetStrTeOut(datar1["fsnr"].ToString()); //附件 Number.Text = datar1["yjfj"].ToString(); bd.GetAtt(Number.Text, "p01", "portal/yj", fujian); datar1.Close(); } else { datar1.Close(); mydb.Alert_Goto("该邮件不存在,可能已被删除!", "fajx.aspx"); } //Init p_cyzt.Visible = true; BackBtn_f.Visible = true; DelBtn_f.Visible = true; GridViewBind(); } } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { string str; SqlDataReader datar1 = SqlHelper.ExecuteReader("SELECT A.* FROM hk_Work A WHERE wID='" + hkdb.GetStr(Request.QueryString["id"]) + "'"); if (datar1.Read()) { string setfrom = null; setfrom = hkdb.GetStrTeOut(datar1["wContent"].ToString()); str = "流水号:" + datar1["wSerialNo"].ToString() + "-" + datar1["wName"].ToString() + " - 当前步骤:" + datar1["NextNodeName"].ToString() + " - 状态:" + datar1["wStatus"].ToString() + "<br>"; str += "工作标题:" + datar1["wTitle"].ToString() + "<br>" + setfrom + "<br>"; int glTMP2 = 0; int sta = 0; string strAtt = "<table width=100% border=0 cellspacing=0 cellpadding=2><tr>"; SqlDataReader datar2 = SqlHelper.ExecuteReader("SELECT * FROM hk_AttUpload WHERE attClass='w01' AND attKey='" + datar1["wNo"].ToString() + "' ORDER BY attID DESC"); while (datar2.Read()) { strAtt += " <td width=100% >·<a href=WorkAttDown.aspx?number=" + datar2["attNewName"].ToString() + " target=_blank>" + datar2["attName"].ToString() + "</a></td>"; glTMP2 = glTMP2 + 1; if (glTMP2 == 1) { strAtt += "</tr><tr>"; glTMP2 = 0; } sta = 1; } datar2.Close(); strAtt += " </table>"; int glTMP3 = 0; int sta2 = 0; string strAtt2 = "<table width=100% border=1 cellspacing=0 cellpadding=2><tr><td align=center><b>审批意见</b></td></tr><tr>"; SqlDataReader datar3 = SqlHelper.ExecuteReader("SELECT A.*,B.ui_desc FROM hk_WorkAppComm A LEFT OUTER JOIN yh B ON(A.FK_uid=B.ui_id) WHERE ac_wfID='" + datar1["wID"].ToString() + "' AND ac_Status='有效' ORDER BY acID"); while (datar3.Read()) { strAtt2 += " <td width=100%><font color=red>" + datar3["acContent"].ToString() + "</font> " + datar3["ui_desc"].ToString() + " " + string.Format("{0:yyyy-MM-dd HH:mm}", datar3["AddTime"]) + " <a href=WorkAttDown.aspx?number=" + datar3["acAttNewName"].ToString() + " target=_blank class=gvlink>" + datar3["acAttName"].ToString() + "</a> 步骤名称:" + datar3["ac_fName"].ToString() + "</td>"; glTMP3 = glTMP3 + 1; if (glTMP3 == 1) { strAtt2 += "</tr><tr>"; glTMP3 = 0; } sta2 = 1; } datar3.Close(); strAtt2 += " </table>"; if (sta == 1) { str = str + strAtt; } if (sta2 == 1) { str = str + strAtt2; } Response.Write(str); } datar1.Close(); this.Response.Write("<script language=javascript>document.execCommand('saveas','true','工作导出.htm')</script>"); } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { hkdb.PassTo("10116", "0"); qy_fjylurl.Text = Convert.ToString(SqlHelper.ExecuteScalar("SELECT qy_fjylurl FROM qy WHERE qy_id='001'")); lblAttachSize.Text = Convert.ToString(SqlHelper.ExecuteScalar("SELECT P_STRING FROM hk_CSDA WHERE PARAMT='P_fj_size'")); if (Request.QueryString["jszt"] != "已接收") { SSBtn.Visible = false; } //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); //dp绑定 SqlDataReader datar = SqlHelper.ExecuteReader("SELECT A.*,B.UI_DESC,C.MC AS RWXZ_MC FROM OA_RWD01 A LEFT OUTER JOIN YH B ON (A.FBR=B.UI_ID) LEFT OUTER JOIN HK_ZDYLX C ON(A.RWXZ=C.ID) WHERE RWID='" + hkdb.GetStr(Request.QueryString["rwid"].ToString()) + "'"); if (datar.Read()) { rwly.Text = datar["source"].ToString(); rwdh.Text = datar["rwdh"].ToString(); lblrwbt.Text = datar["rwbt"].ToString(); lbljjcd.Text = datar["jjcd"].ToString(); lblrwxz.Text = datar["RWXZ_MC"].ToString(); lbljsdx.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["jsdx"].ToString() + "','1'")); qtld.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["qtld"].ToString() + "','1'")); zrld.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["zrld"].ToString() + "','1'")); zrr.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["zrr"].ToString() + "','1'")); lblksrq.Text = datar["ksrq"].ToString(); lbljzrq.Text = datar["jzrq"].ToString(); lblnr.Text = hkdb.GetStrTeOut(datar["rwnr"].ToString()); lblynxs.Text = datar["ynxs"].ToString(); savefj.Text = datar["fjmc"].ToString(); fqsj.Text = string.Format("{0:d}", datar["fbsj"]); fbr.Text = datar["fbr"].ToString(); fbrmc.Text = datar["ui_desc"].ToString(); savefj.Text = datar["fjmc"].ToString(); savelj.Text = datar["fjlj"].ToString(); savefj.NavigateUrl = (datar["fjlj"] == System.DBNull.Value ? "" : "../.." + datar["fjlj"]) + datar["fjmc"].ToString(); datar.Close(); if (lblynxs.Text == "是") { Panelrq.Visible = true; } SqlDataReader dr = SqlHelper.ExecuteReader("SELECT A.*,B.UI_DESC FROM OA_RWD02 A LEFT OUTER JOIN YH B ON (A.CLR=B.UI_ID) WHERE JSID='" + hkdb.GetStr(Request.QueryString["jsid"].ToString()) + "'"); if (dr.Read()) { //lblfpxs.Text = dr["fpxs"].ToString(); //lblfpry.Text = Convert.ToString(SqlHelper.ExecuteScalar("exec sp_IdToName '" + dr["fpry"].ToString() + "','1'")); //lblfpsm.Text = dr["fpsm"].ToString(); wcqk.Text = dr["bzsm"].ToString().ToString(); wcsj.Text = string.Format("{0:d}", dr["clsj"]); wcrmc.Text = dr["ui_desc"].ToString().ToString(); savefj_yh.Text = dr["fjmc"].ToString(); savelj_yh.Text = dr["fjlj"].ToString(); savefj_yh.NavigateUrl = (dr["fjlj"] == System.DBNull.Value ? "" : "../.." + dr["fjlj"]) + dr["fjmc"].ToString(); } dr.Close(); //根据来源页面隐藏 完成 相关内容 if (Request.QueryString["type"] == "yjs") //如果是从 已接收 页面调用则隐藏 { p_wcqk.Visible = true; } else { p_xx.Visible = false; } } else { datar.Close(); mydb.Alert_Close("此记录不存在,可能已被删除!"); } } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { BindAttr(); SqlDataReader datar1 = SqlHelper.ExecuteReader("SELECT * FROM hk_WorkFlowNode WHERE fnID='" + int.Parse(Request.QueryString["UpNodeId"]) + "'"); if (datar1.Read()) { lblstrfnName.Text = datar1["fnName"].ToString(); strNextNodeNum = datar1["NextNodeNum"].ToString(); strnnNumkey = datar1["NextNodeNum"].ToString(); lblnnnk.Text = datar1["NextNodeNum"].ToString(); strfnid = datar1["fnID"].ToString(); strfnWriteID = "" + datar1["fnWriteID"].ToString() + "0"; //编辑附件 if (datar1["ynEditAtt"].ToString() == "是") { editimg.Visible = true; } else { editimg.Visible = false; } //删除附件 if (datar1["ynDelAtt"].ToString() == "是") { delBtn.Visible = true; } else { delBtn.Visible = false; } //加签判断1 if (datar1["fnPosition"].ToString() == "结束") { Button2.Visible = true; } } datar1.Close(); SqlDataReader datar2 = SqlHelper.ExecuteReader("SELECT A.*,B.fName FROM hk_Work A LEFT OUTER JOIN hk_Form B ON(A.FK_fid=B.fID) WHERE wID='" + hkdb.GetStr(Request.QueryString["id"]) + "'"); if (datar2.Read()) { strbkNextNodeNum = datar2["NextNodeNum"].ToString(); lbllshid.Text = datar2["wSerialNo"].ToString(); Number.Text = datar2["wNo"].ToString(); lblName.Text = datar2["wName"].ToString(); whname.Text = datar2["wName"].ToString(); lblstrAudiMode.Text = datar2["ReviewMode"].ToString(); strwUserIDs = datar2["wUserIDs"].ToString(); lblstrhyUserIDs.Text = datar2["wUserIDs"].ToString().Replace("" + this.Session["userid"].ToString() + ",", ""); lblstrhyUserNames.Text = datar2["wUserNames"].ToString().Replace("" + this.Session["username"].ToString() + ",", ""); string setfrom = null; setfrom = hkdb.GetStrTeOut(datar2["wContent"].ToString().Replace("BACKGROUND-COLOR:", "").Replace("readOnly", "").Replace("BACKGROUND-COLOR: #EFEFEF", "").Replace("readonly", "").Replace("id=Text2", "readonly").Replace("id=\"Text2\"", "readonly")); //可写字段 SqlDataReader dr_fc = SqlHelper.ExecuteReader("SELECT * FROM hk_FormColumn WHERE clID NOT IN(" + strfnWriteID + ") AND clType!='[电子印章]'"); while (dr_fc.Read()) { setfrom = setfrom.Replace("name=" + dr_fc["clNo"] + "", "name=" + dr_fc["clNo"] + " style=\"BACKGROUND-COLOR: #EFEFEF\" readonly").Replace("name=\"" + dr_fc["clNo"] + "\"", "name=" + dr_fc["clNo"] + " style=\"BACKGROUND-COLOR: #EFEFEF\" readonly"); } dr_fc.Close(); ContractContent.Text = setfrom; lbltx.Text = setfrom; lblFormName.Text = datar2["fName"].ToString(); //文号 SqlDataReader dr_wf = SqlHelper.ExecuteReader("SELECT ynModFileNo FROM hk_WorkFlow WHERE wfNo='" + datar2["FK_wfno"].ToString() + "'"); if (dr_wf.Read()) { if (dr_wf["ynModFileNo"].ToString() == "否") { whname.Attributes.Add("readonly", "readonly"); } } dr_wf.Close(); lblwTitle.Text = datar2["wTitle"].ToString(); //加签判断2 if (datar2["ReviewMode"].ToString() != "必须全部人员通过审批才能向下流转") { Button2.Visible = false; } } datar2.Close(); //判断是否转到下一个节点 int m = strwUserIDs.Length; int s = strwUserIDs.Replace(",", "").Length; a = m - s; if (a <= 1) { Button4.Visible = true; Button1.Visible = false; } else { if (lblstrAudiMode.Text == "仅一人通过审批即可向下流转") { Button4.Visible = true; } else { Button4.Visible = false; } Button1.Visible = true; } //审批意见列表 int glTMP3 = 0; int sta2 = 0; string strAtt2 = "<table width=100% border=1 cellspacing=0 cellpadding=0 class=form><tr><td align=center><b>审批意见</b></td></tr><tr>"; SqlDataReader datar3 = SqlHelper.ExecuteReader("SELECT A.*,B.ui_desc FROM hk_WorkAppComm A LEFT OUTER JOIN yh B ON(A.FK_uid=B.ui_id) WHERE ac_wfID='" + hkdb.GetStr(Request.QueryString["id"]) + "' AND ac_Status='有效' ORDER BY acID"); while (datar3.Read()) { strAtt2 += " <td width=100%><font color=red>" + datar3["acContent"].ToString() + "</font> " + datar3["ui_desc"].ToString() + " " + string.Format("{0:yyyy-MM-dd HH:mm}", datar3["AddTime"]) + " <a href=WorkAttDown.aspx?number=" + datar3["acAttNewName"].ToString() + " target=_blank class=gvlink>" + datar3["acAttName"].ToString() + "</a></td>"; glTMP3 = glTMP3 + 1; if (glTMP3 == 1) { strAtt2 += "</tr><tr>"; glTMP3 = 0; } sta2 = 1; } datar3.Close(); strAtt2 += " </table>"; if (sta2 == 1) { lblspyj.Text = strAtt2; } } //我的常用语 if (!IsPostBack) { string sql_accontent = "SELECT nr FROM hk_Cyy WHERE fl='02' and zt='正常' and cjr='" + this.Session["UserID"] + "'"; bd.Bind_DropDownList(accontent, sql_accontent, "nr", "nr", "请选择", "请选择"); } BindDplist(); }