protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
hkdb.PassTo("10114", "0");
SqlDataReader datar = SqlHelper.ExecuteReader("SELECT * FROM HK_WDYJ WHERE YJID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'");
if (datar.Read())
{
lblyjbt.Text = datar["yjbt"].ToString();
lblnr.Text = datar["yjnr"].ToString();
lblfbsj.Text = string.Format("{0:d}", datar["fbsj"]);
lblfbrmc.Text = datar["fbrmc"].ToString();
hfnr.Text = datar["hfnr"].ToString();
Number.Text = datar["fjmc"].ToString();
if (datar["zt"].ToString() == "待回复")
{
SaveBtn.Visible = true;
hfnr.Enabled = true;
}
datar.Close();
}
else
{
datar.Close();
mydb.Alert_Close("此记录不存在,可能已被删除！");
}
bd.GetAtt(hkdb.GetStr(Number.Text), "p03", "portal/yjx", fujian);
}
}
protected void Page_Load(object sender, EventArgs e)
{
mydb hkdb = new mydb();
hkdb.VeriSess("4");
if (!IsPostBack)
{
SqlDataReader datar = SqlHelper.ExecuteReader("SELECT A.*,B.MC FROM HK_QYGG A LEFT OUTER JOIN HK_ZDYLX B ON(A.GGFL=B.ID) WHERE A.GGID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'");
if (datar.Read())
{
ggflmc.Text = datar["mc"].ToString();
kssj.Text = string.Format("{0:d}", datar["kssj"]) + " 至 " + string.Format("{0:d}", datar["jssj"]);
ggzt.Text = datar["ggzt"].ToString();
ggnr.Text = datar["ggnr"].ToString();
fqsj.Text = string.Format("{0:d}", datar["lrsj"]);
Number.Text = datar["ggfj"].ToString();
datar.Close();
//附件
bd.GetAtt(Number.Text, "p02", "portal/gg", fujian);
}
else
{
datar.Close();
mydb.Alert_Close("此记录不存在,可能已被删除！");
}
}
}
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)
{
//附件
bd.GetAtt(Request.QueryString["number"].ToString(), Request.QueryString["class"].ToString(), Request.QueryString["folder"].ToString(), fujian);
}
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
hkdb.PassTo("11718", "0");
//短信
dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms());
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
SqlDataReader dr = SqlHelper.ExecuteReader("SELECT A.* FROM OA_KQ_SM01 A WHERE SID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "' AND CHARINDEX('" + this.Session["userid"] + "',jsrIDs)>0 AND SMZT='已审批'");
if (dr.Read())
{
lblqdsj.Text = hkdb.GetDate(dr["qdsj"].ToString());
ynqd1.Checked = hkdb.GetValueChk_Checked(dr["ynqd1"].ToString());
ynqt1.Checked = hkdb.GetValueChk_Checked(dr["ynqt1"].ToString());
ynqd2.Checked = hkdb.GetValueChk_Checked(dr["ynqd2"].ToString());
ynqt2.Checked = hkdb.GetValueChk_Checked(dr["ynqt2"].ToString());
ynqd3.Checked = hkdb.GetValueChk_Checked(dr["ynqd3"].ToString());
ynqt3.Checked = hkdb.GetValueChk_Checked(dr["ynqt3"].ToString());
lblkqqksm.Text = dr["kqqksm"].ToString();
lblsqr.Text = dr["sqrmc"].ToString();
sssj.Text = dr["sssj"].ToString();
lblspr.Text = dr["jsrNames"].ToString();
sqrid.Text = dr["sqrid"].ToString();
lblsqbmmc.Text = dr["sqbmmc"].ToString();
lblsqsj.Text = dr["sqsj"].ToString();
Number.Text = dr["smfj"].ToString();
lblsscs.Text = dr["sscs"].ToString();
dr.Close();
bd.GetAtt(Number.Text, "o3", "oa/kqsm", fujian);
GridViewBind();
}
else
{
dr.Close();
mydb.Alert_Close("该记录已确认完成，无需重复确认！");
}
}
else
{
mydb.Alert_Close("此记录不存在,可能已被删除！");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
hkdb.PassTo("11716", "0");
//短信
dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms());
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
SqlDataReader dr = SqlHelper.ExecuteReader("SELECT A.* FROM OA_KQ_QJD01 A WHERE QID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "' AND CHARINDEX('" + this.Session["userid"] + "',jsrIDs)>0 AND QJZT='已审批'");
if (dr.Read())
{
lblqjlx.Text = dr["qjlx"].ToString();
lblgjlb.Text = dr["gjlb"].ToString();
lblqjkssj.Text = hkdb.GetDate(dr["qjkssj"].ToString());
lblqjkssd.Text = dr["qjkssd"].ToString();
lblqjjssj.Text = hkdb.GetDate(dr["qjjssj"].ToString());
lblqjjssd.Text = dr["qjjssd"].ToString();
lblqjts.Text = dr["qjts"].ToString();
lblqjly.Text = dr["qjly"].ToString();
lblgztzqk.Text = dr["gztzqk"].ToString();
sqrid.Text = dr["sqrid"].ToString();
lblsqr.Text = dr["sqrmc"].ToString();
sssj.Text = dr["sssj"].ToString();
lblspr.Text = dr["jsrNames"].ToString();
lblsqbmmc.Text = dr["sqbmmc"].ToString();
lblsqsj.Text = dr["sqsj"].ToString();
Number.Text = dr["qjfj"].ToString();
dr.Close();
bd.GetAtt(Number.Text, "o2", "oa/qjd", fujian);
GridViewBind();
}
else
{
dr.Close();
mydb.Alert_Close("该记录已确认完成，无需重复确认！");
}
}
else
{
mydb.Alert_Close("此记录不存在,可能已被删除！");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
hkdb.PassTo("11728", "0");
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
SqlDataReader dr = SqlHelper.ExecuteReader("SELECT * from OA_KQ_QJD01 WHERE QID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'");
if (dr.Read())
{
qjlx.SelectedValue = dr["qjlx"].ToString();
gjlb.SelectedValue = dr["gjlb"].ToString();
qjkssj.Text = hkdb.GetDate(dr["qjkssj"].ToString());
qjkssd.SelectedValue = dr["qjkssd"].ToString();
qjjssj.Text = hkdb.GetDate(dr["qjjssj"].ToString());
qjjssd.SelectedValue = dr["qjjssd"].ToString();
qjts.Text = dr["qjts"].ToString();
lblqjly.Text = dr["qjly"].ToString();
lblgztzqk.Text = dr["gztzqk"].ToString();
lblsqr.Text = dr["sqrmc"].ToString();
lblsqbmmc.Text = dr["sqbmmc"].ToString();
Number.Text = dr["qjfj"].ToString();
bgyy.Text = dr["bgyy"].ToString();
dr.Close();
if (qjlx.SelectedValue == "公假")
{
lblgjlb.Visible = true;
gjlb.Visible = true;
}
bd.GetAtt(Number.Text, "o2", "oa/qjd", fujian);
}
else
{
dr.Close();
}
}
else
{
mydb.Alert_Close("此记录不存在,可能已被删除！");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
hkdb.PassTo("11726,11730", "0");
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
SqlDataReader dr = SqlHelper.ExecuteReader("SELECT A.* FROM OA_KQ_SM01 A WHERE SID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'");
if (dr.Read())
{
lblqdsj.Text = hkdb.GetDate(dr["qdsj"].ToString());
ynqd1.Checked = hkdb.GetValueChk_Checked(dr["ynqd1"].ToString());
ynqt1.Checked = hkdb.GetValueChk_Checked(dr["ynqt1"].ToString());
ynqd2.Checked = hkdb.GetValueChk_Checked(dr["ynqd2"].ToString());
ynqt2.Checked = hkdb.GetValueChk_Checked(dr["ynqt2"].ToString());
ynqd3.Checked = hkdb.GetValueChk_Checked(dr["ynqd3"].ToString());
ynqt3.Checked = hkdb.GetValueChk_Checked(dr["ynqt3"].ToString());
lblkqqksm.Text = dr["kqqksm"].ToString();
lblsqr.Text = dr["sqrmc"].ToString();
sssj.Text = dr["sssj"].ToString();
lblspr.Text = dr["jsrNames"].ToString();
lblsqbmmc.Text = dr["sqbmmc"].ToString();
lblsqsj.Text = dr["sqsj"].ToString();
Number.Text = dr["smfj"].ToString();
lblsscs.Text = dr["sscs"].ToString();
dr.Close();
bd.GetAtt(Number.Text, "o3", "oa/kqsm", fujian);
GridViewBind();
}
else
{
dr.Close();
mydb.Alert_Close("此记录不存在,可能已被删除！");
}
}
else
{
mydb.Alert_Close("此记录不存在,可能已被删除！");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
hkdb.PassTo("11716", "0");
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
SqlDataReader dr = SqlHelper.ExecuteReader("SELECT DISTINCT * from OA_KQ_QJD02 A LEFT OUTER JOIN OA_KQ_QJD01 B ON(A.SSQID=B.QID) WHERE B.QID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "' AND A.SPRID='" + this.Session["userid"] + "' AND A.SPZT='确认完成'");
if (dr.Read())
{
lblqjlx.Text = dr["qjlx"].ToString();
lblgjlb.Text = dr["gjlb"].ToString();
lblqjkssj.Text = hkdb.GetDate(dr["qjkssj"].ToString());
lblqjkssd.Text = dr["qjkssd"].ToString();
lblqjjssj.Text = hkdb.GetDate(dr["qjjssj"].ToString());
lblqjjssd.Text = dr["qjjssd"].ToString();
lblqjts.Text = dr["qjts"].ToString();
lblqjly.Text = dr["qjly"].ToString();
lblgztzqk.Text = dr["gztzqk"].ToString();
lblsqr.Text = dr["sqrmc"].ToString();
sssj.Text = dr["sssj"].ToString();
lblspr.Text = dr["jsrNames"].ToString();
lblsqbmmc.Text = dr["sqbmmc"].ToString();
lblsqsj.Text = dr["sqsj"].ToString();
Number.Text = dr["qjfj"].ToString();
dr.Close();
bd.GetAtt(Number.Text, "o2", "oa/qjd", fujian);
GridViewBind();
}
else
{
dr.Close();
}
}
else
{
mydb.Alert_Close("此记录不存在,可能已被删除！");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
hkdb.PassTo("11718", "0");
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
SqlDataReader dr = SqlHelper.ExecuteReader("SELECT DISTINCT * from OA_KQ_SM02 A LEFT OUTER JOIN OA_KQ_SM01 B ON(A.SSSID=B.SID) WHERE B.SID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "' AND A.SPRID='" + this.Session["userid"] + "' AND A.SPZT='确认完成'");
if (dr.Read())
{
lblqdsj.Text = hkdb.GetDate(dr["qdsj"].ToString());
ynqd1.Checked = hkdb.GetValueChk_Checked(dr["ynqd1"].ToString());
ynqt1.Checked = hkdb.GetValueChk_Checked(dr["ynqt1"].ToString());
ynqd2.Checked = hkdb.GetValueChk_Checked(dr["ynqd2"].ToString());
ynqt2.Checked = hkdb.GetValueChk_Checked(dr["ynqt2"].ToString());
ynqd3.Checked = hkdb.GetValueChk_Checked(dr["ynqd3"].ToString());
ynqt3.Checked = hkdb.GetValueChk_Checked(dr["ynqt3"].ToString());
lblkqqksm.Text = dr["kqqksm"].ToString();
lblsqr.Text = dr["sqrmc"].ToString();
sssj.Text = dr["sssj"].ToString();
lblspr.Text = dr["jsrNames"].ToString();
lblsqbmmc.Text = dr["sqbmmc"].ToString();
lblsqsj.Text = dr["sqsj"].ToString();
Number.Text = dr["smfj"].ToString();
lblsscs.Text = dr["sscs"].ToString();
dr.Close();
bd.GetAtt(Number.Text, "o3", "oa/kqsm", fujian);
GridViewBind();
}
else
{
dr.Close();
}
}
else
{
mydb.Alert_Close("此记录不存在,可能已被删除！");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
hkdb.PassTo("11802,11803,11804,11805,11806,11807", "0");
//参数判断
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
SqlDataReader datar = SqlHelper.ExecuteReader("SELECT A.*,B.mc AS MiJi_mc,C.mc as Dengji_mc,D.mc as WjType_mc,E.mc as GwType_mc FROM OA_FilesManageBook A LEFT OUTER JOIN hk_ZDYLX B ON(A.MiJi=B.ID) LEFT OUTER JOIN hk_ZDYLX C ON(A.Dengji=C.ID) LEFT OUTER JOIN hk_ZDYLX D ON(A.WjType=D.ID) LEFT OUTER JOIN hk_ZDYLX E ON(A.GwType=E.ID) WHERE A.ID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'");
if (datar.Read())
{
Number.Text = datar["Number"].ToString();
lblNum.Text = datar["Num"].ToString();
lblName.Text = datar["Name"].ToString();
lblwjTitle.Text = datar["Title"].ToString();
lblOtherTitle.Text = datar["OtherTitle"].ToString();
lblFwCompany.Text = datar["FwCompany"].ToString();
lblFwTime.Text = datar["FwTime"].ToString();
lblMiji.Text = datar["MiJi_mc"].ToString();
lblDengji.Text = datar["Dengji_mc"].ToString();
lblWjType.Text = datar["WjType_mc"].ToString();
lblGwType.Text = datar["GwType_mc"].ToString();
lblWjNum.Text = datar["WjNum"].ToString();
lblDyNum.Text = datar["DyNum"].ToString();
lblFilesName.Text = datar["FilesName"].ToString();
lblRemark.Text = datar["Remark"].ToString();
datar.Close();
//附件
bd.GetAtt(Number.Text, "o01", "oa/dagl", fujian);
}
else
{
datar.Close();
mydb.Alert_Close("此记录不存在,可能已被删除！");
}
}
}
}
protected void Page_Load(object Sender, EventArgs E)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
hkdb.PassTo("81107", "0");
//被考评人
lblbkpr.Text = SqlHelper.ExecuteScalar("SELECT XM FROM HR_Kpdf_Bkpr01 WHERE BID='" + hkdb.GetStr(Request.QueryString["bid"].ToString()) + "'").ToString();
//评委类型
SqlDataReader dr = SqlHelper.ExecuteReader("SELECT PWLX FROM HR_Kpdf_Pw WHERE PID='" + this.Session["userid"] + "'");
if (dr.Read())
{
lblpwlx.Text = dr["PWLX"].ToString();
dr.Close();
}
else
{
dr.Close();
mydb.Alert_Close("对不起，您并未被设定为评委，无法评分！");
}
//附件
SqlDataReader datar = SqlHelper.ExecuteReader("SELECT KPFJ FROM HR_Kpdf_Kpxm03 WHERE SSKPID='" + hkdb.GetStr(Request.QueryString["kpid"]) + "' AND SSBID='" + hkdb.GetStr(Request.QueryString["bid"]) + "'");
if (datar.Read())
{
Number.Text = datar["KPFJ"].ToString();
}
datar.Close();
//评分材料
bd.GetAtt(Number.Text, "h21", "hr/jxgl", fujian);
}
GridViewBind();
}
protected void Page_Load(object Sender, EventArgs E)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
hkdb.PassTo("81107", "0");
//评委类型
SqlDataReader dr_pw = SqlHelper.ExecuteReader("SELECT PWLX FROM HR_Kpdf_Pw WHERE PID='" + this.Session["userid"] + "'");
if (dr_pw.Read())
{
lblpwlx.Text = dr_pw["PWLX"].ToString();
dr_pw.Close();
}
else
{
dr_pw.Close();
mydb.Alert_Goto("对不起，您并未被设定为评委，不能继续！", "Pwpf.aspx");
}
//考评项目
SqlDataReader dr_xm = SqlHelper.ExecuteReader("SELECT KPQS,KPZT,XMFJ FROM HR_Kpdf_Kpxm01 WHERE KPID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'");
if (dr_xm.Read())
{
lblxmmc.Text = dr_xm["KPQS"].ToString();
lblkpzt.Text = dr_xm["KPZT"].ToString();
Number.Text = dr_xm["XMFJ"].ToString();
}
dr_xm.Close();
//公共评分材料
bd.GetAtt(Number.Text, "h22", "hr/jxgl", fujian);
GridViewBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
hkdb.PassTo("11717", "0");
//短信
dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms());
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
SqlDataReader dr = SqlHelper.ExecuteReader("SELECT A.* FROM OA_KQ_SM01 A WHERE SID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "' AND CHARINDEX('" + this.Session["userid"] + "',jsrIDs)>0 AND SMZT='送审中'");
if (dr.Read())
{
lblqdsj.Text = hkdb.GetDate(dr["qdsj"].ToString());
ynqd1.Checked = hkdb.GetValueChk_Checked(dr["ynqd1"].ToString());
ynqt1.Checked = hkdb.GetValueChk_Checked(dr["ynqt1"].ToString());
ynqd2.Checked = hkdb.GetValueChk_Checked(dr["ynqd2"].ToString());
ynqt2.Checked = hkdb.GetValueChk_Checked(dr["ynqt2"].ToString());
ynqd3.Checked = hkdb.GetValueChk_Checked(dr["ynqd3"].ToString());
ynqt3.Checked = hkdb.GetValueChk_Checked(dr["ynqt3"].ToString());
smzt.Text = dr["smzt"].ToString();
lblkqqksm.Text = dr["kqqksm"].ToString();
lblsqr.Text = dr["sqrmc"].ToString();
sssj.Text = dr["sssj"].ToString();
lblspr.Text = dr["jsrNames"].ToString();
lblsqbmid.Text = dr["sqbmid"].ToString();
lblsqbmmc.Text = dr["sqbmmc"].ToString();
lblsqsj.Text = dr["sqsj"].ToString();
Number.Text = dr["smfj"].ToString();
lblsscs.Text = dr["sscs"].ToString();
dr.Close();
DropDownListBind();
//考勤审批说明
Kqspsm();
bd.GetAtt(Number.Text, "o3", "oa/kqsm", fujian);
GridViewBind();
//判断是否分管领导或中心领导，如果是则默认选中为“转给考勤管理员”
SqlDataReader dr0 = SqlHelper.ExecuteReader("SELECT * FROM OA_KQ_QX WHERE YHID='" + this.Session["UserID"] + "' AND (KQSPRY2='是' OR KQSPRY3='是')");
if (dr0.Read())
{
jsr.SelectedValue = "jdqr";
kqry.Visible = true;
kqry.Items.Clear();
string Str = " WHERE Z.KQGLRY='是'";
//考勤管理人员
string sql_kqry = "SELECT UI_ID,UI_DESC+'('+B.BM_MC+'-'+C.ZWMC+')' AS UI_DESC FROM OA_KQ_QX Z LEFT OUTER JOIN YH A ON(Z.YHID=A.UI_ID) LEFT OUTER JOIN BM B ON (A.UI_SSBM=B.BM_ID) LEFT OUTER JOIN ZW C ON(A.UI_ZW=C.ZWID) " + Str + " ORDER BY UI_DESC";
bd.Bind_DropDownList_NoBlank(kqry, sql_kqry, "UI_ID", "UI_DESC", "", "");
}
dr0.Close();
//PrnLbl.Attributes.Add("onclick", "Javascript:popPrn('Xydcx_View_Prn.aspx?xydid=" + xydidstr.Text + "');");
}
else
{
dr.Close();
mydb.Alert_Close("此记录已审批完成，无需再审！");
}
}
else
{
mydb.Alert_Close("此记录不存在,可能已被删除！");
}
}
}
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("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);
}
}