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("此记录不存在,可能已被删除！");
}
}
}
