//任务性质 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, "", "", ""); }