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("该用户编码不存在，可能已被删除！");
}
}
}
}
