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();
}
}