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("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("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) { //Session判断 hkdb.VeriSess("4"); if (!IsPostBack) { //模块权限 hkdb.PassTo("11712", "0"); //参数判断 if (!string.IsNullOrEmpty(Request.QueryString["id"])) { SqlDataReader datar = SqlHelper.ExecuteReader("SELECT A.*,B.QY_QC,C.ROLE_NAME,D.ZWMC,E.BM_MC,F.* FROM YH A LEFT OUTER JOIN QY B ON(A.UI_SSGS=B.QY_ID) LEFT OUTER JOIN JS C ON(A.UI_ROLE=C.ROLE_ID) LEFT OUTER JOIN ZW D ON(UI_ZW=D.ZWID) LEFT OUTER JOIN BM E ON(A.UI_SSBM=E.BM_ID) LEFT OUTER JOIN OA_KQ_QX F ON(A.UI_ID=F.YHID) WHERE A.UI_ID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'"); if (datar.Read()) { lblssgs.Text = datar["qy_qc"].ToString(); lblyhbm.Text = datar["ui_id"].ToString(); lblxm.Text = datar["ui_desc"].ToString(); lbljs.Text = datar["role_name"].ToString(); lblzt.Text = datar["ui_status"].ToString(); lblzw.Text = datar["zwmc"].ToString(); lblbm.Text = datar["bm_mc"].ToString(); kqid.Text = datar["kqid"].ToString(); ui_rzrq.Text = hkdb.GetDate(datar["ui_rzrq"].ToString()); kqspry1.Checked = hkdb.GetValueChk_Checked(datar["kqspry1"].ToString()); kqspry2.Checked = hkdb.GetValueChk_Checked(datar["kqspry2"].ToString()); kqspry3.Checked = hkdb.GetValueChk_Checked(datar["kqspry3"].ToString()); kqglry.Checked = hkdb.GetValueChk_Checked(datar["kqglry"].ToString()); tskqry.Checked = hkdb.GetValueChk_Checked(datar["tskqry"].ToString()); ynnjtj.Checked = hkdb.GetValueChk_Checked(datar["ynnjtj"].ToString()); datar.Close(); } 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_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("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("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) { //Session判断 hkdb.VeriSess("4"); if (!IsPostBack) { //模块权限 hkdb.PassTo("60305", "0"); //dp绑定 DropDownListBind(); //公司判断 if (this.Session["qyid"].ToString() != "001") { ssgs.SelectedValue = this.Session["qyid"].ToString(); ssgs.Enabled = false; } //参数判断 if (!string.IsNullOrEmpty(Request.QueryString["id"])) { SqlDataReader datar = SqlHelper.ExecuteReader("SELECT * FROM YH WHERE UI_ID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'"); if (datar.Read()) { yhbm.Text = datar["ui_id"].ToString(); xm.Text = datar["ui_desc"].ToString(); gwjs.SelectedValue = datar["ui_role"].ToString(); xb.SelectedValue = datar["ui_sex"].ToString(); zt.SelectedValue = datar["ui_status"].ToString(); bz.Text = datar["ui_comm"].ToString(); zwmc.SelectedValue = datar["ui_zw"].ToString(); bm.SelectedValue = datar["ui_ssbm"].ToString(); bgdh.Text = datar["ui_bgdh"].ToString(); yddh.Text = datar["ui_yddh"].ToString(); czdh.Text = datar["ui_czdh"].ToString(); mail.Text = datar["ui_mail"].ToString(); txtSdate.Text = string.Format("{0:d}", datar["ui_sdate"]); txtEdate.Text = string.Format("{0:d}", datar["ui_edate"]); csrq.Text = hkdb.GetDate(datar["ui_csrq"].ToString()); ssgs.SelectedValue = datar["ui_ssgs"].ToString(); ynbmglz.Checked = hkdb.GetValueChk_Checked(datar["yn_bmglz"].ToString()); fjNumber.Text = datar["photo"].ToString(); datar.Close(); //子公司用户不允许删除、修改总部或其它子公司的信息 if (this.Session["qyid"].ToString() != "001" && this.Session["qyid"].ToString() != ssgs.SelectedValue) { DelBtn.Visible = false; SaveBtn.Visible = false; } else { //操作权限 OperQx(); } if (Request.QueryString["id"].ToString() == "admin") { gwjs.Enabled = false; txtSdate.Enabled = false; txtEdate.Enabled = false; zt.Enabled = false; DelBtn.Enabled = false; mydb.Alert("为避免误操作,系统将不允许删除或修改【admin】用户的角色、日期和状态属性!"); } } else { datar.Close(); mydb.Alert_Close("该用户编码不存在,可能已被删除!"); } } } }