//任务性质
public void DropDownListBind()
{
string sql_rwxz = "select id,mc FROM hk_ZDYLX where fl='o10' and zt='正常'";
bd.Bind_DropDownList(rwxz, sql_rwxz, "id", "mc", "", "");
bd1.Bind_DropDownList_bm(bm, "", "领导&科级干部，部门中心负责人", "");
bdqt.Bind_DropDownList_bm(bm1, "", "领导&科级干部，部门中心负责人", "");
bdrzld.Bind_DropDownList_bm(bm2, "", "领导&科级干部，部门中心负责人", "");
bdrzrr.Bind_DropDownList_bm(bm3, "", "领导&科级干部，部门中心负责人", "");
bdqt.Bind_DropDownList_bm(bm4, "", "领导&科级干部，部门中心负责人", "");
}
//任务性质
public void DropDownListBind()
{
string sql_rwxz = "select id,mc FROM hk_ZDYLX where fl='o10' and zt<>'删除'";
bd.Bind_DropDownList(rwxz, sql_rwxz, "id", "mc", "", "全部");
bd.Bind_DropDownList_bm(fbbm, "", "", "");
}
//dp绑定
public void DropDownListBind()
{
bd.Bind_DropDownList_bm(ssbm, "", "", "");
string sql_zw = "select zwid,zwmc FROM ZW order by zwid";
bd.Bind_DropDownList(zw, sql_zw, "zwid", "zwmc", "", "");
}
//dp绑定
public void DropDownListBind()
{
//所属公司
string sql_ssgs = "SELECT QY_ID,QY_QC FROM QY ORDER BY QY_ID";
bd.Bind_DropDownList(ssgs, sql_ssgs, "qy_id", "qy_qc", "", "");
//角色
string sql_js = null;
if (Request.QueryString["id"].ToString() == "admin")
{
sql_js = "SELECT ROLE_ID,ROLE_NAME FROM JS WHERE ROLE_LX='企业' ORDER BY ROLE_ID";
}
else
{
sql_js = "SELECT ROLE_ID,ROLE_NAME FROM JS WHERE ROLE_LX='企业' AND ROLE_ID<>'1' ORDER BY ROLE_ID";
}
bd.Bind_DropDownList(gwjs, sql_js, "role_id", "role_name", "", "");
//职位
string sql_zw = "SELECT ZWID,ZWMC FROM ZW ORDER BY ZWID";
bd.Bind_DropDownList(zwmc, sql_zw, "zwid", "zwmc", "", "");
//部门
bd.Bind_DropDownList_bm(bm, "", "", "");
}
//dp绑定
public void DropDownListBind()
{
string sql_bmlx = "SELECT ID,MC FROM hk_ZDYLX WHERE fl='p01' AND ZT='正常'";
bd.Bind_DropDownList(bm_lx, sql_bmlx, "id", "mc", "", "");
bd.Bind_DropDownList_bm(bm_sjbm, "0", "顶层部门", " AND JGLB<>'2'");
}
//dp绑定
public void DropDownListBind()
{
string sql_zyfl = "select flmc,flid from OA_ZYFL order by flid";
bd.Bind_DropDownList(zyfl, sql_zyfl, "flid", "flmc", "", "");
//绑定部门
bd.Bind_DropDownList_bm(szbm, "", "", "");
}
//dp绑定
public void DropDownListBind_sjbm()
{
string sql_glry = "select ui_id,ui_desc from yh where ui_lx='企业' and ui_status='正常' order by ui_id";
bd.Bind_DropDownList(glry, sql_glry, "ui_id", "ui_desc", "", "");
bd.Bind_DropDownList_bm(ssbm, "", "", "");
}
//审批人
public void DropDownListBind_lx()
{
string sql_jhlx = "select id,mc FROM hk_ZDYLX where fl='o02' and zt='正常'";
bd.Bind_DropDownList(jhlx, sql_jhlx, "id", "mc", "", "");
//绑定部门
bd.Bind_DropDownList_bm(bm, "", "", "");
}
public void BindDplist()
{
string sql_fname = "SELECT fID,fName FROM hk_Form ORDER BY fID DESC";
bd.Bind_DropDownList(txt_fName, sql_fname, "fID", "fName", "0", "所有表单类型");
//绑定部门
bd.Bind_DropDownList_bm(fqbm, "", "", "");
}
//dp绑定
public void DropDownListBind()
{
string sql_xycl = "select id,clmc from oa_clda";
bd.Bind_DropDownList(xycl, sql_xycl, "id", "clmc", "", "");
string sql_jsy = "select xm,id from OA_JSYDA order by id";
bd.Bind_DropDownList(jsy, sql_jsy, "id", "xm", "", "");
bd.Bind_DropDownList_bm(sqbm, "", "", "");
}
//dp绑定
public void DropDownListBind()
{
string sql_hylx = "select mc,id FROM hk_ZDYLX where fl='o01' and zt<>'删除' order by id";
bd.Bind_DropDownList(hylx, sql_hylx, "id", "mc", "", "");
string sql_zkdd = "select hys_id,hys_mc from oa_hys order by hys_id";
bd.Bind_DropDownList(zkdd, sql_zkdd, "hys_id", "hys_mc", "", "");
bd.Bind_DropDownList_bm(dept, "", "", "");
}
//dp绑定
public void DropDownListBind()
{
// SqlDataReader datar = SqlHelper.ExecuteReader("select id,clmc from oa_clda where id not in (select xycl from oa_clsq where zt in ('审批中','已同意') and (getdate() between xssj_s and xssj_e))");
string sql_xycl = "select id,clmc from oa_clda where clzt='未借出'";
bd.Bind_DropDownList(xycl, sql_xycl, "id", "clmc", "", "");
string sql_jsy = "select xm,id from OA_JSYDA order by id";
bd.Bind_DropDownList(jsy, sql_jsy, "id", "xm", "", "");
bd.Bind_DropDownList_bm(sqbm, "", "", "");
}
//dp绑定
public void DropDownListBind()
{
//部门
bd.Bind_DropDownList_bm(UnitName, "", "", "");
//案卷密级
string sql_dengji = "SELECT ID,MC FROM hk_zdylx where fl='o04' AND zt='正常'";
bd.Bind_DropDownList(DengJi, sql_dengji, "ID", "MC", "", "");
//凭证类别
string sql_pinzheng = "SELECT ID,MC FROM hk_zdylx where fl='o05' AND zt='正常'";
bd.Bind_DropDownList(PinZheng, sql_pinzheng, "ID", "MC", "", "");
//所属卷库
string sql_roomname = "select * from oa_FilesRoom where (CHARINDEX('," + this.Session["deptid"] + ",',','+QxUnitId+',')>0) order by id desc";
bd.Bind_DropDownList(RoomName, sql_roomname, "ID", "name", "", "");
}
//dp绑定
public void DropDownListBind()
{
//所属公司
string sql_ssgs = "SELECT QY_ID,QY_QC FROM QY ORDER BY QY_ID";
bd.Bind_DropDownList(ssgs, sql_ssgs, "qy_id", "qy_qc", "", "");
//角色
string sql_js = "SELECT ROLE_ID,ROLE_NAME FROM JS WHERE ROLE_LX='企业' AND ROLE_ID<>'1' ORDER BY ROLE_ID";
bd.Bind_DropDownList(gwjs, sql_js, "role_id", "role_name", "", "");
//职位
string sql_zw = "SELECT ZWID,ZWMC FROM ZW ORDER BY ZWID";
bd.Bind_DropDownList(zwmc, sql_zw, "zwid", "zwmc", "", "");
//部门
bd.Bind_DropDownList_bm(bm, "", "", "");
}
//dp绑定
public void DropDownListBind()
{
bd.Bind_DropDownList_bm(bm, "", "全部部门", "");
}
//dp绑定
public void DropDownListBind()
{
//部门
bd.Bind_DropDownList_bm(UnitName, "", "", "");
}
//dp绑定
public void DropDownListBind()
{
bd.Bind_DropDownList_bm(Dept, "", "", "");
}
//dp绑定
public void DropDownListBind()
{
//绑定部门
bd.Bind_DropDownList_bm(ssbm, "", "", "");
}
//dp绑定
public void DropDownListBind_sjbm()
{
bd.Bind_DropDownList_bm(sybm, "", "", "");
}
