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