protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("3"); if (!IsPostBack) { hkdb.PassTo("11717", "11717"); //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); DropDownListBind(); //判断是否分管领导或中心领导,如果是则默认选中为“转给考勤管理员” 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(); AspNetPager1.PageSize = int.Parse(Request.Cookies["haoke"].Values["pagecount"]); GridViewBind(); } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { BindDroList(); BindAttr(); //步骤节点 SqlDataReader dr = SqlHelper.ExecuteReader("SELECT A.*,B.fnName FROM hk_Work A LEFT OUTER JOIN hk_WorkFlowNode B ON(A.FK_fnno=B.fnNo) WHERE wNo='" + hkdb.GetStr(Request.QueryString["Number"]) + "'"); if (dr.Read()) { strfnName = dr["fnName"].ToString(); strwSerialNo = dr["wSerialNo"].ToString(); Name = dr["wTitle"].ToString(); } dr.Close(); //短信 yndx.Visible = Convert.ToBoolean(hkdb.VeriSms()); } BindLb(FormName.SelectedValue); //判断是否自动跳转 if (iNodeCount == 1 && iUserCount == 1 && lblSelectMode.Text == "审批时由当前用户从指定人员中选择") { lblwUserIDs.Text = lblyhid.Text; wUserNames.Text = lblyhmc.Text; AudiRun(); } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { hkdb.PassTo("10108", "0"); //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); //资源分类 string sql_zyfl = "select flmc,flid from OA_ZYFL order by flid"; bd.Bind_DropDownList(zyfl, sql_zyfl, "flid", "flmc", "", ""); //Init //SaveBtn.Enabled = false; txtSdate.Text = DateTime.Now.AddDays(0).ToString("yyyy-MM-dd"); txtEdate.Text = DateTime.Now.AddDays(0).ToString("yyyy-MM-dd"); //绑定部门 DropDownListBind_sjbm(); sybm.SelectedValue = this.Session["deptid"].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { hkdb.PassTo("10102,1002", "0"); //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); 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 dr = SqlHelper.ExecuteReader("SELECT p_string FROM hk_CSDA WHERE paramt='P_AttType'"); if (dr.Read()) { attKey = dr["p_string"].ToString(); } dr.Close(); BindAttr(); if (!string.IsNullOrEmpty(Request.QueryString["id"])) { UserID.Text = Request.QueryString["id"]; UserName.Text = Request.QueryString["mc"]; } } BindDpList(); }
public int iUserCount = 0; //下一步骤的用户数量 protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("9"); if (!IsPostBack) { //步骤节点ID SqlDataReader dr = SqlHelper.ExecuteReader("SELECT A.* FROM hk_Work A WHERE wNo='" + hkdb.GetStr(Request.QueryString["Number"]) + "'"); if (dr.Read()) { lblName.Text = dr["wTitle"].ToString(); lblFlowId.Text = dr["FK_wfid"].ToString(); } dr.Close(); BindDplist(); BindAttr(); //短信 dxtx.Visible = Convert.ToBoolean(hkdb.VeriSms()); } BindLb(rblFormName.SelectedValue); //判断是否自动跳转 if (iNodeCount == 1 && iUserCount == 1 && lblSelectMode.Text == "审批时由当前用户从指定人员中选择") { txt_wUserIDs.Text = lblyhid.Text; txt_wUserNames.Text = lblyhmc.Text; AudiRun(); } }
public int iUserCount = 0; //下一步骤的用户数量 protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { //步骤节点ID SqlDataReader dr = SqlHelper.ExecuteReader("SELECT A.* FROM hk_Work A WHERE wNo='" + hkdb.GetStr(Request.QueryString["Number"]) + "'"); if (dr.Read()) { lblstrfnName.Text = dr["NextNodeName"].ToString(); lblstrwSerialNo.Text = dr["wSerialNo"].ToString(); lblName.Text = dr["wTitle"].ToString(); lblFlowId.Text = dr["FK_wfid"].ToString(); } dr.Close(); BindDplist(); BindAttr(); //短信 dxtx.Visible = Convert.ToBoolean(hkdb.VeriSms()); //审批意见 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 IN (SELECT WID FROM hk_WORK WHERE wNo='" + hkdb.GetStr(Request.QueryString["Number"]) + "') 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; } } BindLb(rblFormName.SelectedValue); //判断是否自动跳转 if (iNodeCount == 1 && iUserCount == 1 && lblSelectMode.Text == "审批时由当前用户从指定人员中选择") { txt_wUserIDs.Text = lblyhid.Text; txt_wUserNames.Text = lblyhmc.Text; AudiRun(); } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { hkdb.PassTo("10503", "0"); //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); SqlDataReader datar = SqlHelper.ExecuteReader("select a.*,b.bm_mc,c.zymc from OA_ZYSQ a left outer JOIN BM b on (a.sybm=b.bm_id) left outer join oa_zydj c on (a.sqzy=c.djid) where sqid='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'"); if (datar.Read()) { sqbm.Text = datar["bm_mc"].ToString(); jysm.Text = datar["jysm"].ToString(); sysj.Text = string.Format("{0:d}", datar["sysj"]); ghsj.Text = string.Format("{0:d}", datar["ghsj"]); sqzy.Text = datar["zymc"].ToString(); ycxx.Text = datar["sqr"].ToString(); if (datar["zt"].ToString() != "审批中") { SpBtn.Visible = false; ThBtn.Visible = false; ShBtn.Visible = false; } datar.Close(); } else { datar.Close(); mydb.Alert_Close("此记录不存在,可能已被删除!"); } } }
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) { //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); BindAttr(); SqlDataReader datar1 = SqlHelper.ExecuteReader("SELECT A.* FROM hk_Work A WHERE wID='" + hkdb.GetStr(Request.QueryString["id"]) + "'"); if (datar1.Read()) { lbltitle.Text = datar1["wTitle"].ToString(); strfnName = datar1["NextNodeName"].ToString(); Name = datar1["wName"].ToString(); UserID.Text = datar1["AttentUserIDs"].ToString(); UserName.Text = datar1["AttentUserNames"].ToString(); } datar1.Close(); //我的常用语 string sql_appcomm = "SELECT nr FROM hk_Cyy WHERE fl='02' and zt='正常' and cjr='" + this.Session["UserID"] + "'"; bd.Bind_DropDownList(dp_appcomm, sql_appcomm, "nr", "nr", "请选择", "请选择"); } }
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("11102", "0"); DropDownListBind_fl(); 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'")); //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); if (!string.IsNullOrEmpty(Request.QueryString["id"])) { lbltitle.Text = "修改"; SqlDataReader datar = SqlHelper.ExecuteReader("select * from OA_XWNR where xwid='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "' and zt='草稿'"); if (datar.Read()) { xwbt.Text = datar["xwbt"].ToString(); xwzy.Text = datar["xwzy"].ToString(); xwly.Text = datar["xwly"].ToString(); xwfl.SelectedValue = datar["fl"].ToString(); xwzz.Text = datar["xwzz"].ToString(); editor.Value = datar["xwnr"].ToString(); xwsj.Text = hkdb.GetDate(datar["xwsj"].ToString()); savefj.Text = datar["fjmc"].ToString(); savelj.Text = datar["fjlj"].ToString(); savefj.NavigateUrl = (datar["fjlj"] == System.DBNull.Value ? "" : "../.." + datar["fjlj"].ToString()) + datar["fjmc"].ToString(); datar.Close(); } else { datar.Close(); mydb.Alert_Close("此记录不存在,可能已被删除!"); } } else { lbltitle.Text = "新增"; SendBtn.Enabled = false; } } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { hkdb.PassTo("10108", "0"); //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); DropDownListBind(); sqbm.SelectedValue = this.Session["deptid"].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { hkdb.PassTo("10505", "0"); qy_fjylurl.Text = Convert.ToString(SqlHelper.ExecuteScalar("SELECT qy_fjylurl FROM qy WHERE qy_id='001'")); //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); GridViewBind(); SpBtn.Enabled = false; } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { hkdb.PassTo("81109", "0"); //短信 dxtx.Visible = Convert.ToBoolean(hkdb.VeriSms()); lblcbry.Text = SqlHelper.ExecuteScalar("SELECT PWXM FROM HR_Kpdf_Pw WHERE PID='" + hkdb.GetStr(Request.QueryString["bid"]) + "'").ToString(); txnr.Text = "关于【" + SqlHelper.ExecuteScalar("SELECT KPQS FROM HR_Kpdf_Kpxm01 WHERE KPID='" + hkdb.GetStr(Request.QueryString["kpid"]) + "'").ToString() + "】的绩效考评项目,请您尽快完成评分,谢谢!"; } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("3"); if (!IsPostBack) { hkdb.PassTo("10301", "10301"); //AspNetPager1.PageSize = int.Parse(Request.Cookies["haoke"].Values["pagecount"]); //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); //页面绑定 GridViewBind(); } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { hkdb.PassTo("11714", "0"); //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); //附件 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 + ""; DropDownListBind(); //设置本部门的用户为默认下一步审批人 SqlDataReader dr_jsr = SqlHelper.ExecuteReader("SELECT TOP 1 YHID FROM OA_KQ_QX Z LEFT OUTER JOIN YH A ON(Z.YHID=A.UI_ID) WHERE (Z.KQSPRY1='是' OR Z.KQSPRY2='是') AND A.UI_SSBM='" + this.Session["DeptID"] + "'"); if (dr_jsr.Read()) { jsr.SelectedValue = dr_jsr["YHID"].ToString(); } dr_jsr.Close(); //考勤审批说明 Kqspsm(); } BindDpList(); }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { //短信 dxtx.Visible = Convert.ToBoolean(hkdb.VeriSms()); SqlDataReader datar1 = SqlHelper.ExecuteReader("SELECT * FROM hk_Work WHERE wID='" + hkdb.GetStr(Request.QueryString["id"]) + "'"); if (datar1.Read()) { mscContent.Text = "请尽快审批办理【" + datar1["wTitle"].ToString() + "】,催办人:" + this.Session["username"].ToString() + ""; wUserIDs.Text = datar1["wUserIDs"].ToString(); wUserNames.Text = datar1["wUserNames"].ToString(); } datar1.Close(); wUserIDs.Attributes.Add("readonly", "readonly"); } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { hkdb.PassTo("10107", "0"); BindAttr(); lblAttachSize.Text = Convert.ToString(SqlHelper.ExecuteScalar("SELECT P_STRING FROM hk_CSDA WHERE PARAMT='P_fj_size'")); //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); DropDownListBind(); txtSdate.Text = DateTime.Now.AddDays(0).ToString("yyyy-MM-dd"); txtEdate.Text = DateTime.Now.AddDays(0).ToString("yyyy-MM-dd"); sxs.SelectedValue = DateTime.Now.AddDays(0).ToString("HH") + ":"; exs.SelectedValue = DateTime.Now.AddDays(0).ToString("HH") + ":"; } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { hkdb.PassTo("10804", "0"); //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); SqlDataReader datar = SqlHelper.ExecuteReader("select a.*,b.bm_mc from oa_clsq a left outer JOIN BM b on (a.sqbm=b.bm_id) where id='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'"); if (datar.Read()) { if (datar["zt"].ToString() == "审批中") { DropDownListBind(); } if (datar["zt"].ToString() == "已同意") { SpBtn.Visible = false; ThBtn.Visible = false; DropDownListBind_ty(); xzcl.Enabled = false; xzjsy.Enabled = false; spyj.Enabled = false; Panelghsm.Visible = true; QRGH.Visible = true; ghsm.Enabled = true; } if (datar["zt"].ToString() == "已归还") { SpBtn.Visible = false; ThBtn.Visible = false; DropDownListBind_ty(); xzcl.Enabled = false; xzjsy.Enabled = false; spyj.Enabled = false; Panelghsm.Visible = true; QRGH.Visible = false; ghsm.Enabled = false; } if (datar["zt"].ToString() == "已拒绝") { SpBtn.Visible = false; ThBtn.Visible = false; DropDownListBind_ty(); xzcl.Enabled = false; xzjsy.Enabled = false; spyj.Enabled = false; QRGH.Visible = false; Panelghsm.Visible = false; } sqbm.Text = datar["bm_mc"].ToString(); ccxs.SelectedValue = datar["ccxs"].ToString(); fcdd.Text = datar["fcdd"].ToString(); dddd.Text = datar["dddd"].ToString(); czrs.Text = datar["czrs"].ToString(); ccsy.Text = datar["ccsy"].ToString(); xycl.SelectedValue = datar["xycl"].ToString(); jsy.SelectedValue = datar["jsy"].ToString(); xzjsy.SelectedValue = datar["jsy"].ToString(); xzcl.SelectedValue = datar["xycl"].ToString(); bz.Text = datar["bz"].ToString(); kssj.Text = datar["xssj_s"].ToString(); jssj.Text = datar["xssj_e"].ToString(); spyj.Text = datar["spyj"].ToString(); ghsm.Text = datar["ghsm"].ToString(); ycxx.Text = datar["sqr"].ToString(); } else { mydb.Alert_Close("此记录不存在,可能已被删除!"); } datar.Close(); } }
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) { hkdb.PassTo("11714", "0"); //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); //附件 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 + ""; DropDownListBind(); SqlDataReader dr = SqlHelper.ExecuteReader("SELECT A.* FROM OA_KQ_QJD01 A 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(); qjzt.Text = dr["qjzt"].ToString(); qjly.Text = dr["qjly"].ToString(); gztzqk.Text = dr["gztzqk"].ToString(); lblspr.Text = dr["jsrNames"].ToString(); lblsssj.Text = dr["sssj"].ToString(); jsr.SelectedValue = dr["jsrIDs"].ToString(); if (!string.IsNullOrEmpty(dr["qjfj"].ToString())) { Number.Text = dr["qjfj"].ToString(); } dr.Close(); if (qjlx.SelectedValue == "公假") { lblgjlb.Visible = true; gjlb.Visible = true; } } else { dr.Close(); mydb.Alert_Close("此记录不存在,可能已被删除!"); } switch (qjzt.Text) { case "录入": DelJhBtn.Visible = true; SendBtn.Visible = true; SaveBtn.Visible = true; p_jsr.Visible = true; AttDelBtn.Visible = true; uploadBtn.Visible = true; break; case "已退回": DelJhBtn.Visible = true; SendBtn.Visible = true; SaveBtn.Visible = true; p_jsr.Visible = true; AttDelBtn.Visible = true; uploadBtn.Visible = true; break; default: break; } //考勤审批说明 Kqspsm(); GridViewBind(); } BindDpList(); }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { hkdb.PassTo("10203", "0"); BindAttr(); SqlDataReader dr = SqlHelper.ExecuteReader("select a.*,b.bm_mc from oa_gzjh01 a,BM b where a.jhbm=b.bm_id and jhid='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'"); if (dr.Read()) { ny.Text = dr["jhnf"].ToString() + "年" + dr["jhyf"].ToString() + dr["bm_mc"].ToString() + " 工作计划"; ztmb.Text = dr["ztmb"].ToString(); zt.Text = dr["zt"].ToString(); spyj.Text = dr["spyj"].ToString(); zwpj.Text = dr["zwpj"].ToString(); zgpjnr.Text = dr["zgpjnr"].ToString(); df.Text = dr["zgpjfs"].ToString(); UserID.Text = dr["sprIDs"].ToString(); UserName.Text = dr["sprNames"].ToString(); dr.Close(); } else { dr.Close(); mydb.Alert_Close("此记录不存在,可能已被删除!"); } switch (zt.Text) { case "录入": AddBtn.Visible = true; DelBtn.Visible = true; DelJhBtn.Visible = true; songshen.Visible = true; SendBtn.Visible = true; SaveBtn.Visible = true; ztmb.ReadOnly = false; //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); //增加按钮 AddBtn.Attributes.Add("onclick", "Javascript:popView('bmjh_gzx_add.aspx?type=m&id=" + Request.QueryString["id"] + "');"); istr = "lr"; break; case "审核中": istr = "shz"; break; case "评价中": //songshen.Visible = true; UpBtn.Visible = true; spyjpanel.Visible = true; zwpj.ReadOnly = false; istr = "pjz"; break; case "完成": spyjpanel.Visible = true; zgpjpanel.Visible = true; istr = "wc"; break; } GridViewBind(); } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { hkdb.PassTo("10102,1002", "0"); //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); lblAttachSize.Text = Convert.ToString(SqlHelper.ExecuteScalar("SELECT P_STRING FROM hk_CSDA WHERE PARAMT='P_fj_size'")); 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 dr = SqlHelper.ExecuteReader("SELECT p_string FROM hk_CSDA WHERE paramt='P_AttType'"); if (dr.Read()) { attKey = dr["p_string"].ToString(); } dr.Close(); BindAttr(); //页面来源 switch (Request.QueryString["type"]) { case "zf": //转发 SqlDataReader dr_zf = SqlHelper.ExecuteReader("SELECT * FROM hk_Mail_JS WHERE JSID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'"); if (dr_zf.Read()) { bt.Text = "转发:" + dr_zf["jsbt"].ToString(); editor.Value = dr_zf["jsnr"].ToString(); zyx.SelectedValue = dr_zf["zyjb"].ToString(); if (!string.IsNullOrEmpty(dr_zf["yjfj"].ToString())) { Number.Text = dr_zf["yjfj"].ToString(); } } dr_zf.Close(); delBtn.Visible = false; uploadBtn.Visible = false; uploadFile.Disabled = true; break; case "hf": //回复 SqlDataReader dr_hf = SqlHelper.ExecuteReader("SELECT * FROM hk_Mail_JS WHERE JSID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'"); if (dr_hf.Read()) { UserID.Text = dr_hf["fsrID"].ToString(); UserName.Text = dr_hf["fsrName"].ToString(); bt.Text = "回复:" + dr_hf["jsbt"].ToString(); editor.Value = dr_hf["jsnr"].ToString(); } dr_hf.Close(); break; case "cg": //草稿 SqlDataReader dr_cg = SqlHelper.ExecuteReader("SELECT * FROM hk_Mail_FS WHERE YJID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'"); if (dr_cg.Read()) { UserID.Text = dr_cg["jsrIDs"].ToString(); UserName.Text = dr_cg["jsrNames"].ToString(); bt.Text = dr_cg["fsbt"].ToString(); editor.Value = dr_cg["fsnr"].ToString(); msbz.Checked = hkdb.GetValueChk_Checked(dr_cg["msbz"].ToString()); zyx.SelectedValue = dr_cg["zyjb"].ToString(); if (!string.IsNullOrEmpty(dr_cg["yjfj"].ToString())) { Number.Text = dr_cg["yjfj"].ToString(); } } dr_cg.Close(); break; } } BindDpList(); }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { hkdb.PassTo("10203", "0"); BindAttr(); //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); DropDownListBind_lx(); if (!string.IsNullOrEmpty(Request.QueryString["id"])) { SqlDataReader dr = SqlHelper.ExecuteReader("select a.*,b.bm_mc from oa_gzjh01 a,BM b where a.jhbm=b.bm_id and jhid='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'"); if (dr.Read()) { jhnf.Text = dr["jhnf"].ToString(); jhlx.SelectedValue = dr["jhlx"].ToString(); ztmb.Text = dr["ztmb"].ToString(); bm.SelectedValue = dr["jhbm"].ToString(); switch ((dr["jhyf"].ToString()).Substring((dr["jhyf"].ToString()).Length - 1)) { case "度": rblcq.SelectedValue = "按季度"; yf.Items.Clear(); ListItem theItem3 = new ListItem(); theItem3.Text = ""; theItem3.Value = ""; yf.Items.Add(theItem3); ListItem theItem4 = new ListItem(); theItem4.Text = "一季度"; theItem4.Value = "一季度"; yf.Items.Add(theItem4); ListItem theItem5 = new ListItem(); theItem5.Text = "二季度"; theItem5.Value = "二季度"; yf.Items.Add(theItem5); ListItem theItem6 = new ListItem(); theItem6.Text = "三季度"; theItem6.Value = "三季度"; yf.Items.Add(theItem6); ListItem theItem7 = new ListItem(); theItem7.Text = "四季度"; theItem7.Value = "四季度"; yf.Items.Add(theItem7); break; case "年": rblcq.SelectedValue = "按半年"; yf.Items.Clear(); ListItem theItem = new ListItem(); theItem.Text = ""; theItem.Value = ""; yf.Items.Add(theItem); ListItem theItem1 = new ListItem(); theItem1.Text = "上半年"; theItem1.Value = "上半年"; yf.Items.Add(theItem1); ListItem theItem2 = new ListItem(); theItem2.Text = "下半年"; theItem2.Value = "下半年"; yf.Items.Add(theItem2); break; default: rblcq.SelectedValue = "按月份"; yf.Items.Clear(); ListItem theItem0 = new ListItem(); theItem0.Text = ""; theItem0.Value = ""; yf.Items.Add(theItem0); ListItem theItem8 = new ListItem(); theItem8.Text = "01月"; theItem8.Value = "01月"; yf.Items.Add(theItem8); ListItem theItem9 = new ListItem(); theItem9.Text = "02月"; theItem9.Value = "02月"; yf.Items.Add(theItem9); ListItem theItem10 = new ListItem(); theItem10.Text = "03月"; theItem10.Value = "03月"; yf.Items.Add(theItem10); ListItem theItem11 = new ListItem(); theItem11.Text = "04月"; theItem11.Value = "04月"; yf.Items.Add(theItem11); ListItem theItem12 = new ListItem(); theItem12.Text = "05月"; theItem12.Value = "05月"; yf.Items.Add(theItem12); ListItem theItem13 = new ListItem(); theItem13.Text = "06月"; theItem13.Value = "06月"; yf.Items.Add(theItem13); ListItem theItem14 = new ListItem(); theItem14.Text = "07月"; theItem14.Value = "07月"; yf.Items.Add(theItem14); ListItem theItem15 = new ListItem(); theItem15.Text = "08月"; theItem15.Value = "08月"; yf.Items.Add(theItem15); ListItem theItem16 = new ListItem(); theItem16.Text = "09月"; theItem16.Value = "09月"; yf.Items.Add(theItem16); ListItem theItem17 = new ListItem(); theItem17.Text = "10月"; theItem17.Value = "10月"; yf.Items.Add(theItem17); ListItem theItem18 = new ListItem(); theItem18.Text = "11月"; theItem18.Value = "11月"; yf.Items.Add(theItem18); ListItem theItem19 = new ListItem(); theItem19.Text = "12月"; theItem19.Value = "12月"; yf.Items.Add(theItem19); break; } yf.SelectedValue = dr["jhyf"].ToString(); dr.Close(); } SaveBtn.Visible = false; DelBtn.Visible = true; AddBtn.Visible = true; SendBtn.Visible = true; songshen.Visible = true; AddBtn.Attributes.Add("onclick", "Javascript:popMod('bmjh_gzx_add.aspx?type=a&id=" + Request.QueryString["id"] + "');"); } GridViewBind(); } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("3"); reurl = Request.QueryString["reurl"]; if ((Request.QueryString["day"] != null)) { date = DateTime.Parse(Request.QueryString["day"]); } if ((Request.QueryString["id"] != null)) { scheid = Int32.Parse(Request.QueryString["id"]); } if (!IsPostBack) { hkdb.PassTo("10113,1005", "0"); BindAttr(); //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); if ((Request.QueryString["id"] != null)) { scheid = Int32.Parse(Request.QueryString["id"]); SqlDataReader datar = SqlHelper.ExecuteReader("SELECT * FROM HK_JSB WHERE SchID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'"); if (datar.Read()) { zt.Text = datar["Subject"].ToString(); lx.SelectedValue = datar["SchType"].ToString(); dd.Text = datar["Place"].ToString(); nr.Text = datar["Content"].ToString(); srq.Text = string.Format("{0:d}", datar["fdate"]); erq.Text = string.Format("{0:d}", datar["tdate"]); sxs.SelectedValue = string.Format("{0:HH:}", datar["fdate"]); exs.SelectedValue = string.Format("{0:HH:}", datar["tdate"]); sfz.SelectedValue = string.Format("{0:mm:ss}", datar["fdate"]); efz.SelectedValue = string.Format("{0:mm:ss}", datar["tdate"]); //提醒 if ((bool)datar["RemindFlag"] == true) { tx.Checked = true; txts.Text = datar["RemindDay"].ToString(); } //私人性质 if ((bool)datar["PrivFlag"] == true) { srxz.Checked = true; } //重复 if ((bool)datar["RepeatFlag"] == true) { cf.Checked = true; cfzq.SelectedValue = datar["RequenCate"].ToString(); jzrq.Text = string.Format("{0:d}", datar["UpToDate"]); } //预约人员 UserID.Text = datar["yyry"].ToString(); if (!string.IsNullOrEmpty(UserID.Text)) { UserName.Text = Convert.ToString(SqlHelper.ExecuteScalar("EXEC sp_IdToName '" + hkdb.GetStr(UserID.Text) + "','1'")); } cjrq.Text = string.Format("{0:d}", datar["Cdate"]); datar.Close(); } DelBtn.Visible = true; } else { srq.Text = date.ToString("d"); erq.Text = date.ToString("d"); } //Init txts.Enabled = tx.Checked; jzrq.Enabled = cf.Checked; cfzq.Enabled = cf.Checked; cjr.Text = this.Session["username"].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { hkdb.PassTo("11714", "0"); //短信 dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms()); //附件 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 + ""; DropDownListBind(); SqlDataReader dr = SqlHelper.ExecuteReader("SELECT A.* FROM OA_KQ_SM01 A WHERE SID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'"); if (dr.Read()) { qdsj.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(); kqqksm.Text = dr["kqqksm"].ToString(); lblspr.Text = dr["jsrNames"].ToString(); lblsssj.Text = dr["sssj"].ToString(); jsr.SelectedValue = dr["jsrIDs"].ToString(); if (!string.IsNullOrEmpty(dr["smfj"].ToString())) { Number.Text = dr["smfj"].ToString(); } lblsscs.Text = dr["sscs"].ToString(); dr.Close(); } else { dr.Close(); mydb.Alert_Close("该考勤说明可能已被删除!"); } switch (smzt.Text) { case "录入": DelJhBtn.Visible = true; SendBtn.Visible = true; SaveBtn.Visible = true; p_jsr.Visible = true; AttDelBtn.Visible = true; uploadBtn.Visible = true; break; case "已退回": DelJhBtn.Visible = true; SendBtn.Visible = true; SaveBtn.Visible = true; p_jsr.Visible = true; AttDelBtn.Visible = true; uploadBtn.Visible = true; break; default: SendBtn.Visible = true; SaveBtn.Visible = true; p_jsr.Visible = true; AttDelBtn.Visible = true; uploadBtn.Visible = true; break; } //考勤审批说明 Kqspsm(); GridViewBind(); } BindDpList(); }
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("此记录不存在,可能已被删除!"); } } }