protected void bindData() { string str_sql = " SELECT jsh,xsh,jsm,dept from t_teacher "; if (tbx_spm.Text.Trim() != "") { str_sql += " where ( spm LIKE '%" + tbx_spm.Text.Trim() + "%') " + " or ( jsm LIKE '%" + tbx_spm.Text.Trim() + "%') " + " or ( jsh LIKE '%" + tbx_spm.Text.Trim() + "%') "; } //if (rbl_tj_status.SelectedIndex != 0) // str_sql += " ( isnull(" + rbl_tj_status.SelectedValue + ",'False') = 'False' )"; DataView dv = DBFun.GetDataView(str_sql); GridView1.DataSource = dv; GridView1.DataBind(); Session["dv_detail"] = dv; CommFun.Add_ConfirmAttrib(GridView1, "lbtn_del"); str_sql = "select url from t_dict where flm = 8 and bm = 15 "; if (DBFun.ExecuteScalar(str_sql) == null) { tbx_InitPwd.Text = ""; } else { tbx_InitPwd.Text = DBFun.ExecuteScalar(str_sql).ToString(); } str_sql = "SELECT url,name from t_dict where flm=1 ;"; DBFun.FillDwList(ddlist_dept, str_sql); TD_AddUser.Visible = false; }
protected void bindData() { str_sql = "select bm,name from t_dict where flm = 3 order by bm;"; dv = DBFun.GetDataView(str_sql); ViewState["sql"] = str_sql; GridView1.DataSource = dv; GridView1.DataBind(); CommFun.Add_ConfirmAttrib(GridView1, ""); }
protected void bindData() { GridView1.PageSize = Convert.ToInt16(ddl_PageSize.SelectedValue); string str_sql = "select * from t_expert order by loginname "; DataView dv = DBFun.GetDataView(str_sql); GridView1.DataSource = dv; GridView1.DataBind(); Session["dv_detail"] = dv; CommFun.Add_ConfirmAttrib(GridView1, "lbtn_del"); }
protected void bindData() { DataView dv; string str_sql; str_sql = "select bm,name,url,iif(tj_flag=True,'已提交','未提交') as sftj from t_dict where flm = 13"; dv = DBFun.GetDataView(str_sql); gv_Dept.DataSource = dv; gv_Dept.DataBind(); CommFun.Add_ConfirmAttrib(gv_Dept, "lbtn_del"); Session["dv_detail"] = dv; TD_AddUser.Visible = false; }
protected void bindData() { string str_sql = "select * from t_pszj where appyear=year(date()) "; DataView dv = DBFun.GetDataView(str_sql); GridView1.DataSource = dv; GridView1.DataBind(); Session["dv_detail"] = dv; CommFun.Add_ConfirmAttrib(GridView1, "lbtn_del"); RadioButtonList rbl_fnd; for (int i = 0; i < this.GridView1.Rows.Count; i++) { rbl_fnd = (RadioButtonList)this.GridView1.Rows[i].FindControl("rbl_tj"); rbl_fnd.SelectedValue = dv.Table.Rows[i + GridView1.PageIndex * GridView1.PageSize]["tj_flag"].ToString(); } }
protected void bindData() { string str_sql = "exec Q_Para_CommitList_By_sqbm '" + Session["dept_name"].ToString() + "'"; dv = DBFun.GetDataView(str_sql); GridView1.DataSource = dv; GridView1.DataBind(); Session["dv_detail"] = dv; CommFun.Add_ConfirmAttrib(GridView1, "lbtn_del"); str_sql = "select InitPwd from t_dict where flm = 1 and url = '" + Session["dept_id"].ToString() + "'"; if (DBFun.ExecuteScalar(str_sql) == null) { tbx_InitPwd.Text = ""; } else { tbx_InitPwd.Text = DBFun.ExecuteScalar(str_sql).ToString(); } }