//任务性质 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() { //文件密级 string sql_mini = "SELECT ID,MC FROM hk_zdylx where fl='o06' AND zt='正常'"; bd.Bind_DropDownList(Miji, sql_mini, "ID", "MC", "", ""); //紧急等级 string sql_dengji = "SELECT ID,MC FROM hk_zdylx where fl='o07' AND zt='正常'"; bd.Bind_DropDownList(Dengji, sql_dengji, "ID", "MC", "", ""); //文件分类 string sql_wjtype = "SELECT ID,MC FROM hk_zdylx where fl='o08' AND zt='正常'"; bd.Bind_DropDownList(WjType, sql_wjtype, "ID", "MC", "", ""); //公文类别 string sql_gwtype = "SELECT ID,MC FROM hk_zdylx where fl='o09' AND zt='正常'"; bd.Bind_DropDownList(GwType, sql_gwtype, "ID", "MC", "", ""); //所属案卷 string sql_filesname = "select * from oa_FilesManage where (CHARINDEX('," + this.Session["deptid"] + ",',','+QxUnitId+',')>0) order by id desc"; bd.Bind_DropDownList(FilesName, sql_filesname, "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 = 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, "", "", ""); }
public void DropDownListBind_sjmk() { moduupid.Items.Clear(); string sql_modu = "SELECT MODU_ID,MODU_MC FROM HK_MODU WHERE MODU_UPID=0 AND MODU_LX<>'G' AND MODU_LX='" + modu_lx.SelectedValue + "' ORDER BY ORDERID"; bd.Bind_DropDownList(moduupid, sql_modu, "MODU_ID", "MODU_MC", "0", ""); }
//dp绑定 public void DropDownListBind_sqzy() { string sql_sqzy = "select djid,CAST(djid AS VARCHAR(10))+'-'+zymc as zymc from OA_ZYDJ order by djid"; bd.Bind_DropDownList(sqzy, sql_sqzy, "djid", "zymc", "", ""); string sql_zyfl = "select flid,CAST(flid AS VARCHAR(10))+'-'+flmc AS flmc from OA_ZYFL order by flid"; bd.Bind_DropDownList(zyfl, sql_zyfl, "flid", "flmc", "", ""); }
//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() { // 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() { 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, "", "", ""); }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { hkdb.PassTo("10111", "0"); BindAttr(); DropDownListBind(); //dp绑定 //Random f = new Random(); //string sjs = f.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() + "" + sjs + ""; if (!IsPostBack) { SqlDataReader datar = SqlHelper.ExecuteReader("select * from OA_KnowLedge where ID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'"); if (datar.Read()) { BigName.SelectedValue = datar["Bigid"].ToString(); //知识小类 LittleName.Items.Clear(); string sql_LittleName = "select ID,Name from OA_KlClassSub where BigId='" + BigName.SelectedValue + "' order by ID"; bd.Bind_DropDownList(LittleName, sql_LittleName, "ID", "Name", "", ""); TitleName.Text = datar["Title"].ToString(); Content.Text = datar["Content"].ToString(); AthourSay.Text = datar["AthourSay"].ToString(); KeyWord.Text = datar["KeyWord"].ToString(); UserName.Text = datar["QxYdRealname"].ToString(); UserID.Text = datar["QxYdUsername"].ToString(); LittleName.SelectedValue = datar["LittleId"].ToString(); Number.Text = datar["Number"].ToString(); datar.Close(); } else { datar.Close(); mydb.Alert_Close("此记录不存在,可能已被删除!"); } } } }
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(); } }
//dp绑定 public void DropDownListBind() { string Sql1 = " where produid NOT IN('Y','X')"; 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(); Sql1 = Sql1 + " and ProduID in ('" + str + "')"; } else //子登录页 { if (this.Session["systype"].ToString() == "M") { Sql1 = Sql1 + " and (ProduID='G' or ProduID='P')"; } else { Sql1 = Sql1 + " and (ProduID='" + this.Session["systype"] + "' or ProduID='P')"; } } string sql = "SELECT produid,produname FROM hk_init " + Sql1 + " ORDER BY InitType"; bd.Bind_DropDownList(xt, sql, "produid", "produname", "", ""); }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { BindAttr(); SqlDataReader dr = SqlHelper.ExecuteReader("SELECT * FROM hk_WorkFlowNode WHERE fnID='" + hkdb.GetStr(Request.QueryString["id"]) + "'"); if (dr.Read()) { fnNum.Text = dr["fnNum"].ToString(); fnName.Text = dr["fnName"].ToString(); lblwfno.Text = dr["FK_wfno"].ToString(); lblfno.Text = dr["FK_fno"].ToString(); strlist = "" + dr["NextNodeNum"].ToString() + "0"; } dr.Close(); string sql_dpStep = "SELECT fnID,fnName FROM hk_WorkFlowNode WHERE fnNum IN (" + strlist + ") AND FK_wfno='" + lblwfno.Text + "'"; bd.Bind_DropDownList(dpStep, sql_dpStep, "fnID", "fnName", "请选择", "请选择"); } if (dpStep.SelectedValue != "请选择") { GridVidwBind("WHERE fbTofnid='" + dpStep.SelectedValue + "' AND FK_fnid='" + hkdb.GetStr(Request.QueryString["id"]) + "'"); } else { GridVidwBind("WHERE fbTofnid='0'"); } }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { BindAttr(); } if (!IsPostBack) { SqlDataReader dr = SqlHelper.ExecuteReader("SELECT * FROM hk_WorkFlow WHERE wfNo='" + hkdb.GetStr(Request.QueryString["FlowNumber"]) + "'"); if (dr.Read()) { lblfid.Text = dr["FK_fid"].ToString(); lblfno.Text = dr["FK_fno"].ToString(); lblwfid.Text = dr["wfID"].ToString(); } dr.Close(); //电子印章 string sql_seal = "SELECT clNo,clName FROM hk_FormColumn WHERE FK_fno='" + lblfno.Text + "'AND clType='[电子印章]'"; bd.Bind_DropDownList(sealarea, sql_seal, "clNo", "clName", "请选择", "请选择"); } }
protected void Page_Load(object sender, EventArgs e) { mydb hkdb = new mydb(); hkdb.VeriSess("4"); usname = this.Session["username"].ToString(); this.SaveBtn.Attributes.Add("onclick", "javascript: SaveFile();"); if (!IsPostBack) { adfile = Request.QueryString["file"].ToString(); number = Request.QueryString["number"].ToString(); SqlDataReader dr = SqlHelper.ExecuteReader("SELECT attName FROM hk_AttUpload WHERE attNewName='" + hkdb.GetStr(Request.QueryString["file"]) + "' AND attClass='w01'"); if (dr.Read()) { adname = dr["attName"].ToString(); } dr.Close(); if (Request.QueryString["filetype"].ToString() == ".doc" || Request.QueryString["filetype"].ToString() == ".DOC") { prnBtn.Visible = true; clrTrkBtn.Visible = true; TrkBtn.Visible = true; unTrkBtn.Visible = true; dp_admindoc.Visible = true; Button3.Visible = true; } if (Request.QueryString["filetype"].ToString() == ".xls" || Request.QueryString["filetype"].ToString() == ".XLS") { prnBtn.Visible = false; clrTrkBtn.Visible = false; TrkBtn.Visible = false; unTrkBtn.Visible = false; dp_admindoc.Visible = false; Button3.Visible = false; } if (Request.QueryString["filetype"].ToString() == ".ppt" || Request.QueryString["filetype"].ToString() == ".PPT") { prnBtn.Visible = true; clrTrkBtn.Visible = false; TrkBtn.Visible = false; unTrkBtn.Visible = false; dp_admindoc.Visible = false; Button3.Visible = false; } string sql_admindoc = "SELECT * FROM hk_AdminDoc WHERE adType='" + hkdb.GetStr(Request.QueryString["filetype"].ToString()) + "' AND (CHARINDEX('," + this.Session["userid"].ToString() + ",',','+adUserIDs+',') > 0)"; bd.Bind_DropDownList(dp_admindoc, sql_admindoc, "adNewName", "adName", "请选择", "请选择"); } string fileName = System.IO.Path.GetFileName(Request.QueryString["file"].ToString()); extfilename = System.IO.Path.GetExtension(fileName); }
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", "请选择", "请选择"); } }
public void DropDownListBind() { string Str = " WHERE (Z.KQSPRY1='是' OR Z.KQSPRY2='是')"; SqlDataReader dr_sp = SqlHelper.ExecuteReader("SELECT qzcyid FROM hk_QZDA WHERE CJR='" + this.Session["UserID"] + "' AND QZLX='OA考勤说明审批专用群组'"); if (dr_sp.Read()) { Str += " AND CHARINDEX(UI_ID,'" + dr_sp["qzcyid"].ToString() + "')>0"; } dr_sp.Close(); //下一步审批人 string sql_jsr = "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(jsr, sql_jsr, "ui_id", "ui_desc", "", "选择下一步审批人员"); ListItem theItem1 = new ListItem(); theItem1.Text = "----------------"; theItem1.Value = ""; jsr.Items.Add(theItem1); ListItem theItem2 = new ListItem(); theItem2.Text = "转给考勤管理员"; theItem2.Value = "jdqr"; jsr.Items.Add(theItem2); }
//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", "", ""); }
public void DropDownListBind() { //贺卡模板 string sql = "SELECT A.MBID,A.MBMC FROM VI_MBDA A LEFT OUTER JOIN VI_MBFL B ON (A.MBFL=B.FLID) WHERE B.BJ='sr'"; bd.Bind_DropDownList(hkmb, sql, "MBID", "MBMC", "", "选择信纸模板"); }
//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, "", "", ""); }
//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, "", "", ""); }
//审批人 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, "", "", ""); }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { string sql_wfno = "SELECT wfNo,wfName FROM hk_WorkFlow WHERE wfNo!='" + hkdb.GetStr(Request.QueryString["FlowNumber"]) + "' ORDER BY wfID DESC"; bd.Bind_DropDownList(dp_wfno, sql_wfno, "wfNo", "wfName", "请选择", "请选择"); } }
//部门切换 protected void bm_SelectedIndexChanged(object sender, EventArgs e) { if (!string.IsNullOrEmpty(bm.SelectedValue)) { ry.Items.Clear(); string sql = "SELECT UI_ID,UI_ID+'-'+UI_DESC AS UI_DESC FROM YH WHERE UI_LX='企业' AND UI_SSBM='" + bm.SelectedValue + "' ORDER BY UI_ID"; bd.Bind_DropDownList(ry, sql, "UI_ID", "UI_DESC", "", ""); } }
//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(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", "", ""); }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { string sql_dpSeal = "SELECT sPicNewName,sName+'('+sType+')' AS sName FROM hk_Seal WHERE sUser='******' AND sStatus='正常'"; bd.Bind_DropDownList(dpSeal, sql_dpSeal, "sPicNewName", "sName", "请选择", "请选择"); } Button1.Attributes["onclick"] = "javascript:return chknull();"; }
//任务性质 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, "", "领导&科级干部,部门中心负责人", ""); }
protected void Page_Load(object sender, EventArgs e) { hkdb.VeriSess("4"); if (!IsPostBack) { string sql_down_bh = "select bm_id,dLine+bm_mc as aaa from BM order by dQxStr asc"; bd.Bind_DropDownList(Unit, sql_down_bh, "bm_id", "aaa", "", ""); } GridViewBind(); }