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(); }