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();
}
}
//dp绑定
public void DropDownListBind_lx()
{
//打印尺寸
string sql_size = "select dymc,dyz from hk_DYSZ where dyzt='正常'";
bd.Bind_DropDownList_NoBlank(papersize, sql_size, "dyz", "dymc", "", "");
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
AspNetPager1.PageSize = int.Parse(Request.Cookies["haoke"].Values["pagecount"]);
SqlDataReader datar1 = SqlHelper.ExecuteReader("SELECT * FROM hk_WorkFlowFolder WHERE ffID='" + int.Parse(Request.QueryString["id"]) + "'");
if (datar1.Read())
{
strfoldername = datar1["ffName"].ToString();
}
else
{
strfoldername = "暂没选中任何文件夹";
}
datar1.Close();
BindAttr();
GridViewBind();
//文件夹
string sql_folder = "SELECT ffID,ffLine+ffName AS ffName FROM hk_WorkFlowFolder ORDER BY ffQxStr ASC";
bd.Bind_DropDownList_NoBlank(dp_folder, sql_folder, "ffID", "ffName", "", "");
}
}
//dp绑定
public void DropDownListBind()
{
string Sql = " WHERE Tstatus='正常'";
if (this.Session["systype"].ToString() == "A") //主登录页
{
string str = null;
SqlDataReader datar1 = SqlHelper.ExecuteReader("SELECT ProduID FROM hk_Init");
while (datar1.Read())
{
str = str + "','" + datar1["ProduID"].ToString();
}
datar1.Close();
Sql = Sql + " AND ProduID in ('" + str + "')";
}
else //子登录页
{
Sql = Sql + " AND (ProduID='" + this.Session["systype"] + "' or ProduID='P')";
}
string sql_xzlx = "SELECT TID,PRODUID+'-'+TNAME AS TNAME FROM HK_TYPE " + Sql + " ORDER BY PRODUID,TID";
bd.Bind_DropDownList_NoBlank(xzlx, sql_xzlx, "TID", "TNAME", "", "");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlDataReader dr = SqlHelper.ExecuteReader("SELECT B.fName FROM hk_WorkFlow A LEFT OUTER JOIN hk_Form B ON (A.FK_fid=B.fID) WHERE FK_fid='" + hkdb.GetStr(Request.QueryString["FormId"]) + "'");
if (dr.Read())
{
formName = dr["fName"].ToString();
}
else
{
formName = "暂无流程";
}
dr.Close();
BindAttr();
//页面绑定
GridViewBind();
}
if (!IsPostBack)
{
string sql_dpform = "SELECT fID,fName FROM hk_Form ORDER BY fID DESC";
bd.Bind_DropDownList_NoBlank(dpform, sql_dpform, "fID", "fName", "", "");
}
}
public void DropDownListBind()
{
string Sql = "";
if (this.Session["systype"].ToString() == "A") //主登录页
{
string str = null;
SqlDataReader datar1 = SqlHelper.ExecuteReader("SELECT ProduID FROM hk_Init");
while (datar1.Read())
{
str = str + "','" + datar1["ProduID"].ToString();
}
datar1.Close();
Sql = Sql + " and ProduID in ('" + str + "')";
}
else //子登录页
{
Sql = Sql + " and (ProduID='" + this.Session["systype"] + "' OR ProduID='P')";
}
string sql_Name = "select * from hk_DeskTop where Status='正常' and id not in (select a.id from hk_DeskTop a left outer join hk_MyDesk b on (a.id=b.ssdmid) where Status='正常' and ssdmid is not null and Username='******')" + Sql + " order by id asc";
bd.Bind_DropDownList_NoBlank(Name, sql_Name, "id", "Name", "", "");
}
public void BindDpList()
{
//附件列表
fjlb.Items.Clear();
string sql_fjlb = "select * from OA_KlChapAtt where KeyField='" + hkdb.GetStr(Number.Text) + "' order by id desc";
bd.Bind_DropDownList_NoBlank(fjlb, sql_fjlb, "NewName", "Name", "", "");
}
//附件
public void BindDplist()
{
attlist.Items.Clear();
string sql_attlist = "SELECT attName,attNewName FROM hk_AttUpload WHERE attClass='w01' AND attKey='" + hkdb.GetStr(Number.Text) + "'";
bd.Bind_DropDownList_NoBlank(attlist, sql_attlist, "attNewName", "attName", "", "");
}
public void BindDpList()
{
fjlb.Items.Clear();
string sql_fjlb = "select * from hk_AttUpload where attkey='" + hkdb.GetStr(Number.Text) + "' and attClass='p01' order by attID desc";
bd.Bind_DropDownList_NoBlank(fjlb, sql_fjlb, "attNewName", "attName", "", "");
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
hkdb.PassTo("10111", "0");
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();
SqlDataReader datar = SqlHelper.ExecuteReader("select id,Number,Title from OA_KnowLedge where Number='" + hkdb.GetStr(Request.QueryString["Number"]) + "' ");
if (datar.Read())
{
KmTitle = datar["Title"].ToString();
}
datar.Close();
}
if (!IsPostBack)
{
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
SqlDataReader datar = SqlHelper.ExecuteReader("select * from OA_KlChap where id='" + hkdb.GetStr(Request.QueryString["id"]) + "'");
if (datar.Read())
{
Name.Text = datar["Name"].ToString();
editor.Value = datar["Content"].ToString();
Number.Text = datar["Number"].ToString();
string sql_fjlb = "select * from OA_KlChapAtt where KeyField='" + hkdb.GetStr(Number.Text) + "' order by id desc";
bd.Bind_DropDownList_NoBlank(fjlb, sql_fjlb, "NewName", "Name", "", "");
}
datar.Close();
}
}
BindDpList();
}
public void BindDplist()
{
//流程表单
string sql_fName = "SELECT fID,fName FROM hk_Form ORDER BY fID DESC";
bd.Bind_DropDownList_NoBlank(fName, sql_fName, "fID", "fName", "", "");
//归档文件夹
if (!IsPostBack)
{
string sql_ffid = "SELECT ffID,ffLine+ffName AS ffName FROM hk_WorkFlowFolder ORDER BY ffQxStr ASC";
bd.Bind_DropDownList(FK_ffid, sql_ffid, "ffID", "ffName", "0", "不归档");
}
}
public void BindDpList()
{
fjlb.Items.Clear();
string sql_fjlb = "select * from hk_AttUpload where attkey='" + hkdb.GetStr(fjNumber.Text) + "' and attClass='p02' order by attID desc";
bd.Bind_DropDownList_NoBlank(fjlb, sql_fjlb, "attNewName", "attName", "", "");
//if (fjlb.Items.Count > 0)
//{
// Label1.Text = fjlb.Items[0].Value.ToString();
//}
//else {
// fjNumber.Text = "";
//}
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
hkdb.PassTo("11310", "0");
string sql_down_bh = "select id,Linew+name as aaa from hk_Ygtxl_lb order by QxString asc";
bd.Bind_DropDownList_NoBlank(Folder, sql_down_bh, "id", "aaa", "", "");
BindAttr();
if (Request.QueryString["typeid"] != null)
{
Folder.SelectedValue = Request.QueryString["typeid"].ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("4");
if (!IsPostBack)
{
hkdb.PassTo("11310", "0");
string sql_down_bh = "select id,Linew+name as aaa from hk_Ygtxl_lb order by QxString asc";
bd.Bind_DropDownList_NoBlank(Folder, sql_down_bh, "id", "aaa", "", "");
SqlDataReader dr = SqlHelper.ExecuteReader("select * from hk_Ygtxl where id='" + hkdb.GetStr(Request.QueryString["id"]) + "'");
if (dr.Read())
{
Folder.SelectedValue = dr["FoldersID"].ToString();
PxNum.Text = dr["PxNum"].ToString();
Name.Text = dr["Name"].ToString();
Worknum.Text = dr["Worknum"].ToString();
Unit.Text = dr["Unit"].ToString();
Respon.Text = dr["Respon"].ToString();
Post.Text = dr["Post"].ToString();
Sex.SelectedValue = dr["Sex"].ToString();
Officetel.Text = dr["Officetel"].ToString();
Fax.Text = dr["Fax"].ToString();
MoveTel.Text = dr["MoveTel"].ToString();
HomeTel.Text = dr["HomeTel"].ToString();
Email.Text = dr["Email"].ToString();
QQNum.Text = dr["QQNum"].ToString();
MsnNum.Text = dr["MsnNum"].ToString();
NbNum.Text = dr["NbNum"].ToString();
Address.Text = dr["Address"].ToString();
ZipCode.Text = dr["ZipCode"].ToString();
Remark.Text = dr["Remark"].ToString();
BothDay.Text = dr["BothDay"].ToString();
}
dr.Close();
BindAttr();
}
}
//dp绑定
public void dropdownlistBind()
{
string sql_zyflxz = "select flid,flmc from OA_ZYFL where glry='" + this.Session["userid"] + "'";
bd.Bind_DropDownList_NoBlank(zyflxz, sql_zyflxz, "flid", "flmc", "", "");
}
//dp绑定
public void dropdownlistBind()
{
string sql_xwfl = "select flmc,flid from oa_xwfl where glry='" + this.Session["userid"] + "' order by flid";
bd.Bind_DropDownList_NoBlank(xwfl, sql_xwfl, "flid", "flmc", "", "");
}
//dp绑定
public void dropdownlistBind()
{
string sql_zyflxz = "select flmc,flid from OA_ZYFL order by flid";
bd.Bind_DropDownList_NoBlank(zyflxz, sql_zyflxz, "flid", "flmc", "", "");
}
//dp绑定
public void DropDownListBind()
{
string sql_dxlx = "select id,mc from hk_ZDYLX where fl='p04' and zt='正常'";
bd.Bind_DropDownList_NoBlank(dxlx, sql_dxlx, "id", "mc", "", "");
}
//dp绑定
public void DropDownListBind()
{
string sql_dxlx = "SELECT ID,MC FROM HK_ZDYLX WHERE fl='p04' AND ZT='正常' ORDER BY ID";
bd.Bind_DropDownList_NoBlank(dxlx, sql_dxlx, "id", "mc", "", "");
}
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("此记录不存在,可能已被删除！");
}
}
}
//dp绑定
public void DropDownListBind()
{
string sql_FormType = "SELECT fcID,fcName FROM hk_FormClass";
bd.Bind_DropDownList_NoBlank(FormType, sql_FormType, "fcID", "fcName", "", "");
}