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