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 Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { Calc_fs(); str_sql = "SELECT name,name from t_dict where flm=3 ;"; DBFun.FillDwList(ddlist_cGroup, str_sql); ddlist_cGroup.Items.Insert(0, "全部"); str_sql = "SELECT url,name from t_dict where flm=11 ;"; DBFun.FillDwList(ddlist_xmzt0, str_sql); ddlist_xmzt0.Items.Insert(0, "全部"); str_sql = "select content from t_dict where flm = 14 and bm =3"; str_sql = DBFun.ExecuteScalar(str_sql).ToString(); DBFun.FillDwList(ddlist_year, str_sql); //读取PageSize信息 AspNetPager1.PageSize = Convert.ToInt16(ConfigurationManager.AppSettings.Get("PageSize")); bindData(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { str_sql = "exec Q_dict_flm3"; DBFun.FillDwList(ddlist_Group, str_sql); ddlist_Group.Items.Insert(0, "全部"); str_sql = "SELECT url,name from t_dict where flm=11 ;"; DBFun.FillDwList(ddlist_xmzt, str_sql); ddlist_xmzt.Items.Insert(0, "全部"); AspNetPager1.PageSize = Convert.ToInt16(ConfigurationManager.AppSettings.Get("PageSize")); try { ddl_PageSize.SelectedValue = ConfigurationManager.AppSettings.Get("PageSize"); } catch { ddl_PageSize.SelectedIndex = 0; } bindData(); this.GridView1.SelectedIndex = -1; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { string str_sql = "exec Q_dict_flm3"; DBFun.FillDwList(ddlist_Group, str_sql); ddlist_Group.Items.Insert(0, "全部"); ////读取PageSize信息 //AspNetPager1.PageSize = Convert.ToInt16(ConfigurationManager.AppSettings.Get("PageSize")); //try //{ // ddl_PageSize.SelectedValue = ConfigurationManager.AppSettings.Get("PageSize"); //} //catch //{ // ddl_PageSize.SelectedIndex = 0; //} AspNetPager1.PageSize = 10; //GridView1.SelectedRowStyle.BackColor = System.Drawing.Color.RosyBrown; bindData(); this.GridView1.SelectedIndex = -1; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Write("<script>alert('页面失效,请您重新登录!');location.href = './admin_login.aspx';</script>"); return; } if (!IsPostBack) { string str_sql = "select flag from master where admin_name = '" + Session["admin_name"].ToString() + "'"; if ((int)DBFun.ExecuteScalar(str_sql) != 2) { Response.Write("<script>alert('您没有权限访问此页面!');location.href = './main.aspx';</script>"); return; } str_sql = "select bm,name from t_dict where flm = 1"; DBFun.FillDwList(dw_group, str_sql); bindData(); this.GridView1.Columns[8].Visible = false; this.GridView1.Columns[7].Visible = false; this.GridView1.Columns[this.GridView1.Columns.Count - 4].Visible = false; this.GridView1.Columns[this.GridView1.Columns.Count - 2].Visible = false; this.GridView1.AllowSorting = false; this.GridView1.AllowPaging = false; this.GridView1.SelectedIndex = -1; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { str_sql = "SELECT name,name from t_dict where flm=1 ;"; DBFun.FillDwList(ddlist_dept, str_sql); str_sql = "SELECT url,name from t_dict where flm=11 ;"; DBFun.FillDwList(ddlist_Status, str_sql); ddlist_Status.Items.Insert(0, "全部"); str_sql = "SELECT name,name from t_dict where flm=13 ;"; DBFun.FillDwList(ddlist_sqbm, str_sql); ddlist_sqbm.Items.Insert(0, "全部"); //str_sql = "select distinct left(appNo,4)&'年',left(appNo,4) from t_teacher_list order by left(appNo,4) desc"; //DBFun.FillDwList(ddlist_year, str_sql); //读取PageSize信息 AspNetPager1.PageSize = Convert.ToInt16(ConfigurationManager.AppSettings.Get("PageSize")); bindData(); } }
protected void Page_Load(object sender, EventArgs e) { //Session["jsh"] = "2006030"; //Session["jsm"] = "史磊"; if (Session["jsh"] == null) { Response.Write("<script>alert('页面失效,请您重新登录!');</script>"); Response.Redirect("admin/admin_login.aspx?type=zgcpry"); return; } if (!IsPostBack) { lbl_jsm.Text = Session["jsm"].ToString() + ",已登陆"; Session["msg"] = "yes"; //Save(); //系别 string str_qry = "SELECT name,name from t_dict where flm=1 ;"; DBFun.FillDwList(ddlist5_szbm, str_qry); DBFun.FillDwList(ddlist6_szbm, str_qry); DBFun.FillDwList(ddlist_sqbm, str_qry); CommFun.Add_mz(ddlist_mz); //ddlist_gznx.Items.Clear(); //for (int i = 1; i <= 20; i++) //{ // ddlist_gznx.Items.Add(i.ToString()); //} SetStatus(Table1); } this.lbtn_commit.Attributes.Add("onclick", "return confirm (\"一旦提交就不可以在修改了,确定要提交吗?\");"); this.lbtn_quit.Attributes.Add("onclick", "return confirm (\"退出后所有未保存的数据将会丢失,确定要退出吗?\");"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string str_sql = "select bm,name from t_dict where flm = 1"; ddlist_Group.Items.Add("all"); DBFun.FillDwList(ddlist_Group, str_sql); bindData_cpry(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { CommFun.IsAdmin(); string strqry = "select id,Caption From T_class"; DBFun.FillDwList(dw_class, strqry); strqry = "Select * From T_Class"; GridView1.DataSource = DBFun.GetDataView(strqry); GridView1.DataBind(); } }
protected void bindData() { DBFun.FillDwList(ddlist_zj, "select bm,name from t_dict where flm = 1"); DBFun.FillDwList(ddlist_cpry, "select bm,name from t_dict where flm = 3"); DataView dv = DBFun.GetDataView(" SELECT aa.bm as id ,zj.name as zj ,cpry.name as cpry from t_dict as aa," + " (select bm,name from t_dict where flm = 1) as zj," + " (select bm,name from t_dict where flm = 3) as cpry" + " where aa.flm = 4 and format(zj.bm,'#') = aa.name and format(cpry.bm,'#') = aa.url"); gv_detail.DataSource = dv; gv_detail.DataBind(); Session["dv_detail"] = dv; }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { string str_sql = "exec Q_dict_flm3"; DBFun.FillDwList(ddlist_Group, str_sql); ddlist_Group.Items.Insert(0, "全部"); bindData(); this.GridView1.SelectedIndex = -1; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { CommFun.IsAdmin(); DBFun.FillDwList(dw_class, "select ID,caption From T_Class"); string strqry = "select * From T_IndexPage"; GridView1.DataSource = DBFun.GetDataView(strqry); GridView1.DataBind(); } catch (Exception ex) { Response.Write("执行时出错!" + ex.Message); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { string str_sql = "exec Q_dict_flm3"; DBFun.FillDwList(ddlist_Group, str_sql); ddlist_Group.Items.Insert(0, "全部"); bindData(); this.GridView1.SelectedIndex = -1; this.btn_CreateRws.Attributes.Add("onclick", "return confirm (\"生成任务书会删除原有任务书,确定要继续吗?\");"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { str_sql = "exec Q_dict_flm3"; DBFun.FillDwList(dw_group, str_sql); DBFun.FillDwList(ddlist_Group, str_sql); ddlist_Group.Items.Insert(0, "全部"); //读取PageSize信息 AspNetPager1.PageSize = Convert.ToInt16(ConfigurationManager.AppSettings.Get("PageSize")); bindData(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Write("<script>alert('页面失效,请您重新登录!');location.href = './admin_login.aspx';</script>"); return; } if (!IsPostBack) { //CommFun.IsAdmin(); //string str_qry = "SELECT stext,stext from q_newstype ;"; //DBFun.FillDwList(dw_class, str_qry); //string str_leibie = Request.QueryString["flag"]; //lbl_leibie.Text = str_leibie; //if (str_leibie == "") return; string str_sql = "select bm,name from t_dict where flm = 3"; DBFun.FillDwList(Dropdownlist1, str_sql); bindData(); } //File.Delete("./aa.xls"); }
private void bindData() { string str_qry = "SELECT url,name from t_dict where flm=2 ;"; DBFun.FillDwList(ddlist_gzdw, str_qry); str_qry = "SELECT gzdw,yourname,xrzw,csgz,sbzw,tbrq from cpry where sfzh = '" + Session["sfzh"].ToString() + "' ;"; DataRow dr = DBFun.GetDataRow(str_qry); tbx_xm.Text = dr["yourname"].ToString(); try { ddlist_gzdw.SelectedValue = dr["gzdw"].ToString(); } catch { ddlist_gzdw.SelectedIndex = 0; } try { ddlist_xrzw.SelectedValue = dr["xrzw"].ToString(); } catch { ddlist_xrzw.SelectedIndex = 0; } try { ddlist_sbzw.SelectedValue = dr["sbzw"].ToString(); } catch { ddlist_sbzw.SelectedIndex = 1; } lbl_tbrq.Value = dr["tbrq"].ToString(); if (dr["tbrq"].ToString() == "") { lbl_tbrq.Value = DateTime.Now.ToString("yyyy-MM-dd"); } if (ddlist_sbzw.SelectedValue == "研究员") { ddlist_csgz_yjy.Visible = true; ddlist_csgz_zyjgg.Visible = false; try { ddlist_csgz_yjy.SelectedValue = dr["csgz"].ToString(); } catch { ddlist_csgz_yjy.SelectedIndex = 0; } } else { ddlist_csgz_yjy.Visible = false; ddlist_csgz_zyjgg.Visible = true; try { ddlist_csgz_zyjgg.SelectedValue = dr["csgz"].ToString(); } catch { ddlist_csgz_zyjgg.SelectedIndex = 0; } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("./SessionTimeOut.aspx?type=top"); } if (!IsPostBack) { //CommFun.IsAdmin(); string str_qry = "SELECT stext,stext from q_newstype ;"; DBFun.FillDwList(dw_class, str_qry); string str_leibie = Request.QueryString["flag"]; lbl_leibie.Text = str_leibie; if (str_leibie == "") { return; } string strqry = "select id,title,shijian ,admin,hits,leibie,iif(leixing='0','正高级',iif(leixing='1','专业技术二级',iif(leixing='2','特殊津贴人员',iif(leixing='3','优秀论文')))) as lx from news where leibie = '" + str_leibie + "' and leixing='0' order by shijian desc "; Session["dv_detail"] = DBFun.GetDataView(strqry); bindData(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { str_sql = "exec Q_dict_flm3"; DBFun.FillDwList(ddlist_Group, str_sql); ddlist_Group.Items.Insert(0, "全部"); //读取PageSize信息 AspNetPager1.PageSize = Convert.ToInt16(ConfigurationManager.AppSettings.Get("PageSize")); bindData(); this.GridView1.SelectedIndex = -1; btn_create.Attributes.Add("onclick", "return confirm (\"原有的对应关系将会删除,是否继续?\");"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_name"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!CommFun.IsAdmin(Session["admin_name"].ToString())) { Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin"); } if (!IsPostBack) { str_sql = "exec Q_dict_flm3"; DBFun.FillDwList(dw_group, str_sql); DBFun.FillDwList(ddlist_Group, str_sql); ddlist_Group.Items.Insert(0, "全部"); //读取PageSize信息 AspNetPager1.PageSize = Convert.ToInt16(ConfigurationManager.AppSettings.Get("PageSize")); bindData(); this.GridView1.SelectedIndex = -1; } //Label lbl; //for (int i = 0; i < GridView1.Rows.Count; i++) //{ // CheckBox ckb = (CheckBox)GridView1.Rows[i].FindControl("cbx_HandOn"); // lbl = (Label)this.GridView1.Rows[i].FindControl("lbl_Flag"); // if (ckb.Checked) // { // lbl.Text = "已提交"; // lbl.ForeColor = System.Drawing.Color.Green; // } // else // { // lbl.Text = "未提交"; // lbl.ForeColor = System.Drawing.Color.Red; // } //} }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { //数据绑定 if (e.Row.RowType == DataControlRowType.DataRow || GridView1.EditIndex != -1) { DataRowView dr = (System.Data.DataRowView)e.Row.DataItem; DropDownList dw_class_ed = (DropDownList)e.Row.FindControl("dw_class_ed"); if (dw_class_ed != null) { DBFun.FillDwList(dw_class_ed, "select ID,caption From T_Class"); dw_class_ed.Items.FindByValue(dr["film_classid"].ToString()).Selected = true; } DropDownList dw_Template_ed = (DropDownList)e.Row.FindControl("dw_Template_ed"); if (dw_Template_ed != null) { dw_Template_ed.Items.FindByValue(dr["templateID"].ToString()).Selected = true; } DropDownList dw_isopen_ed = (DropDownList)e.Row.FindControl("dw_isopen_ed"); if (dw_isopen_ed != null) { dw_isopen_ed.Items.FindByValue(dr["isopen"].ToString()).Selected = true; } } }
private void bindData() { string str_qry = ""; lbl_id.Text = ""; if (Table1.Visible) { str_qry = "SELECT url,name from t_dict where flm=2 ;"; DBFun.FillDwList(ddl_dw, str_qry); str_qry = "SELECT bm,name from t_dict where flm=7 ;"; DBFun.FillDwList(ddl_xkfx, str_qry); str_qry = "select yourname,birth,xingbie,zgxl,zgxw,xrgw,zgsj,prsj,gwxl,dw,xkfx,xkfx_qt,qtwt,gzjj from ej_cpry where sfzh = '" + Session["sfzh"].ToString() + "' ;"; DataRow dr = DBFun.GetDataRow(str_qry); ddl_dw.SelectedValue = dr["dw"].ToString(); tbx_Name.Text = dr["yourname"].ToString(); txt_csny.Value = dr["birth"].ToString(); txt_zgsj.Value = dr["zgsj"].ToString(); txt_prsj.Value = dr["prsj"].ToString(); try { ddl_xb.SelectedValue = dr["xingbie"].ToString(); ddl_xl.SelectedValue = dr["zgxl"].ToString(); ddl_xw.SelectedValue = dr["zgxw"].ToString(); ddl_xrgw.SelectedValue = dr["xrgw"].ToString(); ddl_gwxl.SelectedValue = dr["gwxl"].ToString(); ddl_dw.SelectedValue = dr["dw"].ToString(); ddl_xkfx.SelectedValue = dr["xkfx"].ToString(); tbx_xkfx.Text = dr["xkfx_qt"].ToString(); tbx_gzjj.Text = dr["gzjj"].ToString(); } catch { } tbx_xkfx.Visible = (ddl_xkfx.SelectedValue == "14"); } else if (Table2.Visible) { str_qry = "SELECT * from ej_cdxmqk where sfzh = '" + Session["sfzh"].ToString() + "' ;"; Session["ej_cdxmqk"] = DBFun.FillGridView(str_qry, gv_cdxmqk, true); tbx2_xmmc.Focus(); tbx2_xmmc.Text = ""; tbx2_xmlb.Text = ""; //ddl2_xmlb.SelectedIndex = 0; tbx2_xmjf.Text = ""; ddl2_brjs.SelectedIndex = 0; txt2_1.Value = ""; txt2_2.Value = ""; tbx2_qzsj.Text = ""; } else if (Table3.Visible) { str_qry = "SELECT * from ej_dbxlz where sfzh = '" + Session["sfzh"].ToString() + "' ;"; Session["ej_dbxlz"] = DBFun.FillGridView(str_qry, gv_dbxlz, true); tbx3_tm.Focus(); tbx3_tm.Text = ""; txt3.Value = ""; tbx3_kwmc.Text = ""; tbx3_brpm.Text = ""; } else if (Table4.Visible) { str_qry = "SELECT * from ej_zlycgzh where sfzh = '" + Session["sfzh"].ToString() + "' ;"; Session["ej_zlycgzh"] = DBFun.FillGridView(str_qry, gv_zl, true); tbx4_zlmc.Focus(); tbx4_zlmc.Text = ""; tbx4_zhjg.Text = ""; } else if (Table5.Visible) { str_qry = "SELECT * from ej_hjqk where sfzh = '" + Session["sfzh"].ToString() + "' ;"; Session["ej_hjqk"] = DBFun.FillGridView(str_qry, gv_hjqk, true); for (int i = DateTime.Today.Year; i >= 1980; i--) { ddl5_nd.Items.Add(i.ToString()); } ddl5_nd.Focus(); ddl5_nd.SelectedIndex = 0; ddl5_jlzl.SelectedIndex = 0; tbx5_hjcgmc.Text = ""; //tbx5_jldj.Text = ""; ddl5_jldj.SelectedIndex = 0; tbx5_pm.Text = ""; } else if (Table6.Visible) { str_qry = "SELECT * from ej_xsrzqk where sfzh = '" + Session["sfzh"].ToString() + "' ;"; Session["ej_xsrzqk"] = DBFun.FillGridView(str_qry, gv_xsrzqk, true); tbx6_rzzzmc.Focus(); tbx6_rzzzmc.Text = ""; tbx6_drzw.Text = ""; txt6_1.Value = ""; txt6_2.Value = ""; tbx6_qzsj.Text = ""; } else if (Table7.Visible) { str_qry = "select qtwt from ej_cpry where sfzh = '" + Session["sfzh"].ToString() + "' ;"; DataRow dr = DBFun.GetDataRow(str_qry); tbx7_qtwt.Text = dr["qtwt"].ToString(); } }
protected void ddlist_zclb_SelectedIndexChanged(object sender, EventArgs e) { string str_qry = "exec Q_Para_T_dict_By_name '" + ddlist_zclb.SelectedValue + "'"; DBFun.FillDwList(ddlist_zc, str_qry); }
private void bindData() { lbl_id.Text = ""; if (Table1.Visible) { imgbtn_save.ImageUrl = "./img/save.gif"; //str_qry = "select * from t_teacher_list where appyear=year(date()) and jsh = '" + Session["jsh"].ToString() + "' ;"; str_sql = "EXEC Q_Para_Teacher_List_By_sbh '" + Session["appNo"].ToString() + "'"; //根据申请状态判断提交按钮状态 DataRow dr = DBFun.GetDataRow(str_sql); //lbtn_commit.Enabled = Convert.ToBoolean(dr["edit_flag"]); try { try { ddlist_zzlb.SelectedValue = dr["zzlb"].ToString(); //类别 } catch { ddlist_zzlb.SelectedIndex = 0; } try { ddlist_lb.SelectedValue = dr["xmlb"].ToString(); //类别 } catch { ddlist_lb.SelectedIndex = 0; } try { ddlist_sqbm.SelectedValue = dr["sqbm"].ToString(); //类别 } catch { ddlist_sqbm.SelectedIndex = 0; } try { ddlist_zclb.SelectedValue = dr["zclb"].ToString(); //类别 } catch { ddlist_zclb.SelectedIndex = 0; } try { str_sql = "exec Q_Para_T_dict_By_name '" + ddlist_zclb.SelectedValue + "'"; DBFun.FillDwList(ddlist_zc, str_sql); ddlist_zc.SelectedValue = dr["zc"].ToString(); //类别 } catch { ddlist_zc.SelectedIndex = 0; } try { ddlist_zw.SelectedValue = dr["zw"].ToString(); //类别 } catch { ddlist_zw.SelectedIndex = 0; } try { ddlist_xw.SelectedValue = dr["xw"].ToString(); //类别 } catch { ddlist_xw.SelectedIndex = 0; } try { ddlist_yjnx.SelectedValue = dr["yjnx"].ToString(); //类别 } catch { ddlist_yjnx.SelectedIndex = 0; } try { ddlist_szbm.SelectedValue = dr["szbm"].ToString(); //类别 } catch { ddlist_szbm.SelectedIndex = 0; } if (dr["sqbm"].ToString() == "") { ddlist_sqbm.SelectedIndex = 0; } tbx_xmmc.Text = dr["ktmc"].ToString(); //专家代码 tbx_xmfzr.Text = dr["sqr"].ToString(); //专家代码 //tbx_szbm.Text = dr["szbm"].ToString(); //专家代码 tbx_lxdh.Text = dr["lxdh"].ToString(); //专家标识 tbx_dzyx.Text = dr["email"].ToString(); //专家标识 txt_sqrq.Value = string.Format("{0:yyyy-MM-dd}", (dr["sqrq"])); //姓名 tbx_zyfx.Text = dr["zyfx"].ToString(); tbx_tsje.Text = dr["xmjf_tsje"].ToString(); //专家代码 tbx_tsyj.Text = dr["xmjf_tsyj"].ToString(); //专家代码 tbx_dyje.Text = dr["xmjf_dyje"].ToString(); //专家代码 tbx_dyyj.Text = dr["xmjf_dyyj"].ToString(); //专家标识 tbx_wyje.Text = dr["xmjf_wyje"].ToString(); //专家代码 tbx_wyyj.Text = dr["xmjf_wyyj"].ToString(); //专家代码 tbx_hyje.Text = dr["xmjf_hyje"].ToString(); //专家代码 tbx_hyyj.Text = dr["xmjf_hyyj"].ToString(); //专家标识 tbx_bmje.Text = dr["xmjf_bmje"].ToString(); //专家代码 tbx_bmyj.Text = dr["xmjf_bmyj"].ToString(); //专家代码 tbx_clje.Text = dr["xmjf_clje"].ToString(); //专家代码 tbx_clyj.Text = dr["xmjf_clyj"].ToString(); //专家代码 tbx_qtje.Text = dr["xmjf_qtje"].ToString(); //专家代码 tbx_qtyj.Text = dr["xmjf_qtyj"].ToString(); //专家代码 lbl_xmjf.Text = dr["xmjf"].ToString(); //项目经费 } catch { } } else if (Table2.Visible) { imgbtn_save.ImageUrl = "./img/save.gif"; //str_qry = "SELECT * from t_teacher_list where appyear=year(date()) and jsh = '" + Session["jsh"].ToString() + "' ;"; str_sql = "EXEC Q_Para_Teacher_List_By_sbh '" + Session["appNo"].ToString() + "'"; DataRow dr = DBFun.GetDataRow(str_sql); tbx2_1.Text = dr["lxyjmb_1"].ToString(); tbx2_2.Text = dr["lxyjmb_2"].ToString(); tbx2_3.Text = dr["lxyjmb_3"].ToString(); tbx2_4.Text = dr["lxyjmb_4"].ToString(); tbx2_5.Text = dr["lxyjmb_5"].ToString(); } //教学工作经历 else if (Table3.Visible) { imgbtn_save.ImageUrl = "./img/add.gif"; str_sql = "SELECT * from t_jxgzjl where appNo = '" + Session["appNo"].ToString() + "' order by orderid asc ;"; DBFun.FillGridView(str_sql, gv3, true); ViewState["sql3"] = str_sql; //第一行上移不可用,最后一行下移不可用 if (gv3.Rows.Count != 0) { ((LinkButton)gv3.Rows[0].Cells[6].Controls[1]).Enabled = false; ((LinkButton)gv3.Rows[gv3.Rows.Count - 1].Cells[6].Controls[3]).Enabled = false; } tbx3_rksj.Focus(); tbx3_rksj.Text = ""; tbx3_kcmc.Text = ""; tbx3_skdx.Text = ""; tbx3_xs.Text = ""; tbx3_szdw.Text = ""; } //主要教学改革和科学研究工作简历 else if (Table4.Visible) { imgbtn_save.ImageUrl = "./img/add.gif"; str_sql = "SELECT * from t_jgkyjl where appNo = '" + Session["appNo"].ToString() + "' order by orderid asc ;"; DBFun.FillGridView(str_sql, gv4, true); ViewState["sql4"] = str_sql; //第一行上移不可用,最后一行下移不可用 if (gv4.Rows.Count != 0) { ((LinkButton)gv4.Rows[0].Cells[5].Controls[1]).Enabled = false; ((LinkButton)gv4.Rows[gv4.Rows.Count - 1].Cells[5].Controls[3]).Enabled = false; } tbx4_qzsj.Focus(); tbx4_qzsj.Text = ""; tbx4_xmmc.Text = ""; tbx4_lxdw.Text = ""; tbx4_hjqk.Text = ""; } //课题组成员情况 else if (Table5.Visible) { imgbtn_save.ImageUrl = "./img/add.gif"; str_sql = "SELECT * from t_cyqk where appNo = '" + Session["appNo"].ToString() + "' order by orderid asc ;"; DBFun.FillGridView(str_sql, gv5, true); ViewState["sql5"] = str_sql; //第一行上移不可用,最后一行下移不可用 if (gv5.Rows.Count != 0) { ((LinkButton)gv5.Rows[0].Cells[6].Controls[1]).Enabled = false; ((LinkButton)gv5.Rows[gv5.Rows.Count - 1].Cells[6].Controls[3]).Enabled = false; } tbx5_jsh.Focus(); tbx5_jsh.Text = ""; tbx5_xm.Text = ""; tbx5_zc.Text = ""; tbx5_zy.Text = ""; ddlist5_xw.SelectedIndex = 0; tbx5_fg.Text = ""; } else if (Table6.Visible) { imgbtn_save.ImageUrl = "./img/save.gif"; str_sql = "EXEC Q_Para_Teacher_List_By_sbh '" + Session["appNo"].ToString() + "'"; DataRow dr = DBFun.GetDataRow(str_sql); tbx6_1.Text = dr["yjffjj_1"].ToString(); tbx6_2.Text = dr["yjffjj_2"].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { //Session["jsh"] = "2006030"; //Session["jsm"] = "史磊"; if (Session["jsh"] == null) { Response.Redirect("./SessionTimeOut.aspx?type=top"); } //设置页面的所有控件为只读,不可用 //foreach (Control ct in Page.Form.Controls) //{ // if (ct is TextBox) // { // TextBox tb = (TextBox)ct; // tb.Enabled = false; // } // else if (ct is DropDownList) // { // DropDownList ddl = (DropDownList)ct; // ddl.Enabled = false; // } //} if (!IsPostBack) { try { lbl_type.Text = Request.QueryString["type"].ToLower(); } catch { } //如果是查看模式,则不显示操作按钮 if (lbl_type.Text == "view") { lbtn_PassWord.Visible = false; lbtn_dyyl.Visible = false; lbtn_commit.Visible = false; lbtn_quit.Visible = false; imgbtn_save.Visible = false; imgbtn_SaveNext.Visible = false; imgbtn_quit.Visible = false; } else { str_sql = "select Status from t_teacher_list where appNo = '" + Session["appNo"].ToString() + "'"; string str_qry1 = " exec Q_Para_qzrq 1"; if (Convert.ToInt16(DBFun.ExecuteScalar(str_sql)) == 1 && Convert.ToInt16(DBFun.ExecuteScalar(str_qry1)) == 1) { lbl_jsm.Text = Session["jsm"].ToString() + ",已登陆"; } else { lbl_jsm.Text = Session["jsm"].ToString() + ",已提交或截止日期已到"; imgbtn_save.Visible = false; imgbtn_SaveNext.Visible = false; lbtn_commit.Enabled = false; } } Session["msg"] = "yes"; //初始化申请部门 str_sql = "SELECT name,name from t_dict where flm=13 order by bm;"; DBFun.FillDwList(ddlist_sqbm, str_sql); //初始化所在部门 str_sql = "SELECT name,name from t_dict where flm=1 order by bm;"; DBFun.FillDwList(ddlist_szbm, str_sql); //初始化职称 str_sql = "SELECT name,name from Q_dict_flm12;"; DBFun.FillDwList(ddlist_zclb, str_sql); ViewState["CurrentNum"] = 1; SetStatus(); this.lbtn_commit.Attributes.Add("onclick", "return confirm (\"一旦提交就不可以在修改了,确定要提交吗?\");"); this.lbtn_quit.Attributes.Add("onclick", "return confirm (\"退出后所有未保存的数据将会丢失,确定要退出吗?\");"); } }
private void bindData() { string str_qry = ""; lbl_id.Text = ""; if (Table1.Visible) { imgbtn_save.ImageUrl = "./img/save.gif"; //民族 str_qry = "、阿昌族、白族、保安族、布朗族、布依族、德昂族、东乡族、侗族、独龙族、俄罗斯族、鄂伦春族、鄂温克族、高山族、哈尼族、哈萨克族、赫哲族、回族、基诺族、京族、景颇族、柯尔克孜族、拉祜族、黎族、僳僳族、珞巴族、满族、毛南族、门巴族、蒙古族、苗族、仫佬族、纳西族、怒族、普米族、羌族、撒拉族、畲族、水族、塔吉克族、塔塔尔族、土族、土家族、佤族、维吾尔族、乌孜别克族、锡伯族、瑶族、彝族、朝鲜族、达斡尔族、傣族、仡佬族、裕固族、壮族、藏族、汉族"; for (int i = 0; i < 56; i++) { ddlist_mz.Items.Add(str_qry.Substring(str_qry.LastIndexOf("、") + 1)); str_qry = str_qry.Substring(0, str_qry.LastIndexOf("、")); } try { //直属单位编码 str_qry = "SELECT url,name from t_dict where flm=11 ;"; DBFun.FillDwList(ddlist_tjdw, str_qry); //一级学科编码 str_qry = "SELECT url,name from t_dict where flm=9 ;"; DBFun.FillDwList(ddlist_yjxkdm, str_qry); } catch { } //甘肃省地震局 and name in('地球物理研究所,地质研究所') //湖北省地震局 //地震预测研究所 //工程力学研究所 //地壳应力研究所 str_qry = "select * from yxxwlw_cpry where sfzh = '" + Session["sfzh"].ToString() + "' ;"; DataRow dr = DBFun.GetDataRow(str_qry); try { rblist_cplb.SelectedValue = dr["cplb"].ToString(); //参评类别 tbx_Name.Text = dr["yourname"].ToString(); //姓名 ddlist_xb.SelectedValue = dr["xingbie"].ToString(); //性别 txt_csny.Value = dr["birth"].ToString(); //出生年月 ddlist_mz.SelectedValue = dr["mz"].ToString(); //民族 ddlist_tjdw.SelectedValue = dr["tjdw"].ToString(); //推荐单位 txt_rxny.Value = dr["rxny"].ToString(); //入学年月 txt_dbrq.Value = dr["lwdbrq"].ToString(); //论文答辩日期 txt_hxwrq.Value = dr["xwhdrq"].ToString(); //获学位日期 ddlist_yjxkdm.SelectedValue = dr["yjxk_dm"].ToString(); //一级学科代码 //二级学科编码 str_qry = "SELECT url,name from t_dict where flm= 10 and url like '" + ddlist_yjxkdm.SelectedValue + "%'; "; DBFun.FillDwList(ddlist_ejxkdm, str_qry); ddlist_ejxkdm.SelectedValue = dr["ejxk_dm"].ToString(); //二级学科代码 cbx_zsxkzy.Checked = Convert.ToBoolean(dr["sfzsxkzy"]); //是否自设学科专业 tbx_zsxkzy.Visible = cbx_zsxkzy.Checked; tbx_zsxkzy.Text = dr["zsxkzy"].ToString(); //自设学科专业 tbx_ctitle.Text = dr["lw_ctitle"].ToString(); //论文题目 tbx_etitle.Text = dr["lw_etitle"].ToString(); //论文英文题目 tbx_yjfx.Text = dr["lw_yjfx"].ToString(); //论文设计的研究方向 ddlist_gdxwfs.SelectedValue = dr["gdxwfs"].ToString(); //攻读学位方式 } catch { } } else if (Table2.Visible) { imgbtn_save.ImageUrl = "./img/add.gif"; str_qry = "SELECT * from yxxwlw_ll where sfzh = '" + Session["sfzh"].ToString() + "' ;"; Session["yxxwlw_ll"] = DBFun.FillGridView(str_qry, gv_ll, true); tbx2_gzjl.Focus(); tbx2_gzjl.Text = ""; } else if (Table3.Visible) { imgbtn_save.ImageUrl = "./img/save.gif"; str_qry = "SELECT lw_Cabstract,lw_Eabstract,lw_cxd,lw_fj_displayname from yxxwlw_cpry where sfzh = '" + Session["sfzh"].ToString() + "';"; DataRow dr = DBFun.GetDataRow(str_qry); ftb3_1.Focus = true; try { ftb3_1.Text = dr["lw_Cabstract"].ToString(); ftb3_2.Text = dr["lw_Eabstract"].ToString(); ftb3_3.Text = dr["lw_cxd"].ToString(); lbl_uploaded.Text = "已上传附件: “" + dr["lw_fj_displayname"].ToString() + "”"; } catch { } } else if (Table4.Visible) { imgbtn_save.ImageUrl = "./img/add.gif"; str_qry = "SELECT * from yxxwlw_lw where sfzh = '" + Session["sfzh"].ToString() + "' ;"; Session["yxxwlw_lw"] = DBFun.FillGridView(str_qry, gv_lw, true); tbx4_tm.Focus(); tbx4_tm.Text = ""; tbx4_kwmc.Text = ""; tbx4_kwqh.Text = ""; txt4_fbsj.Value = ""; tbx4_pm.Text = ""; ddlist4_slqk.SelectedIndex = 0; } else if (Table5.Visible) { imgbtn_save.ImageUrl = "./img/add.gif"; str_qry = "SELECT * from yxxwlw_zz where sfzh = '" + Session["sfzh"].ToString() + "' ;"; Session["yxxwlw_zz"] = DBFun.FillGridView(str_qry, gv_zz, true); tbx5_zzmc.Focus(); tbx5_zzmc.Text = ""; tbx5_cbs.Text = ""; txt5_cbsj.Value = ""; tbx5_pm.Text = ""; } else if (Table6.Visible) { imgbtn_save.ImageUrl = "./img/add.gif"; str_qry = "SELECT * from yxxwlw_cg where sfzh = '" + Session["sfzh"].ToString() + "' ;"; Session["yxxwlw_cg"] = DBFun.FillGridView(str_qry, gv_cg, true); tbx6_cgmc.Focus(); tbx6_cgmc.Text = ""; tbx6_jlmc.Text = ""; try { ddlist6_jldj.SelectedIndex = 0; } catch { } txt6_hjsj.Value = ""; tbx6_pm.Text = ""; } else if (Table7.Visible) { imgbtn_save.ImageUrl = "./img/save.gif"; str_qry = "select * from yxxwlw_cpry where sfzh = '" + Session["sfzh"].ToString() + "' ;"; DataRow dr = DBFun.GetDataRow(str_qry); try { tbx7_zdjs_xm.Text = dr["zdjs_xm"].ToString(); //指导教师姓名 txt7_zdjs_csny.Value = dr["zdjs_csny"].ToString(); //出生年月 ddlist7_zdjs_xingbie.SelectedValue = dr["zdjs_xingbie"].ToString(); //性别 ddlist7_zdjs_zzxl.SelectedValue = dr["zdjs_zzxl"].ToString(); //最终学历 ddlist7_zdjs_zgxw.SelectedValue = dr["zdjs_zgxw"].ToString(); //最高学位 ddlist7_zdjs_sfys.SelectedValue = dr["zdjs_sfys"].ToString(); //是否院士 Txt7_zdjs_srbdny.Value = dr["zdjs_srbdny"].ToString(); //首任博导年月 Txt7_zdjs_srsdny.Value = dr["zdjs_srsdny"].ToString(); //首任硕导年月 tbx7_zdjs_yjfx.Text = dr["zdjs_yjfx"].ToString(); //研究方向 tbx7_zdjs_dsdh.Text = dr["zdjs_dsdh"].ToString(); //导师电话 tbx7_zdjs_dsyx.Text = dr["zdjs_dsyx"].ToString(); //导师邮箱 if (dr["zdjs_xzrs"].ToString() == "0") { tbx7_zdjs_xzrs.Text = ""; } else { tbx7_zdjs_xzrs.Text = dr["zdjs_xzrs"].ToString(); //协助指导的教师人数 } if (dr["zdjs_zdss"].ToString() == "0") { tbx7_zdjs_zdss.Text = ""; } else { tbx7_zdjs_zdss.Text = dr["zdjs_zdss"].ToString(); //培养在读研究生数(含在职) 在读硕士 } if (dr["zdjs_zdbs"].ToString() == "0") { tbx7_zdjs_zdbs.Text = ""; } else { tbx7_zdjs_zdbs.Text = dr["zdjs_zdbs"].ToString(); //在读博士 } if (dr["zdjs_byss"].ToString() == "0") { tbx7_zdjs_byss.Text = ""; } else { tbx7_zdjs_byss.Text = dr["zdjs_byss"].ToString(); //培养已毕业研究生数 毕业硕士 } if (dr["zdjs_bybs"].ToString() == "0") { tbx7_zdjs_bybs.Text = ""; } else { tbx7_zdjs_bybs.Text = dr["zdjs_bybs"].ToString(); //毕业博士 } tbx7_jzbd_gzdw.Text = dr["jzbd_gzdw"].ToString(); //兼职博导工作单位名称 tbx7_xrzw.Text = dr["xrzw"].ToString(); //现任职务 } catch { } } }
protected void Page_Load(object sender, EventArgs e) { //加载 CommFun.IsAdmin(); strqry = ""; if (!IsPostBack) { strqry = "select * From T_Class"; dwclass.DataSource = DBFun.GetDataView(strqry); dwclass.DataTextField = "caption"; dwclass.DataValueField = "id"; dwclass.DataBind(); dw_NewClass.DataSource = dwclass.DataSource; dw_NewClass.DataTextField = "caption"; dw_NewClass.DataValueField = "id"; dw_NewClass.DataBind(); ListItem lt = new ListItem(); lt.Text = "--请选择--"; lt.Value = "0"; dwclass.Items.Add(lt); dwclass.Text = "0"; strqry = "Select id,caption From T_Path order by id desc"; DBFun.FillDwList(dw_ServerList, strqry); dw_ServerList.Items.Add(new ListItem("--请选择--", "0")); dw_ServerList.Text = "0"; strqry = "select * From T_films order by id desc"; if (Request.QueryString["FilmisSeq"] == "1") { //连载中 strqry = "select * From T_films where filmisseq=1 order by id desc"; } Session["strqry"] = strqry; //绑定数据 dvlist = DBFun.GetDataView(strqry); AspNetPager1.RecordCount = dvlist.Table.Rows.Count; Cache.Insert("dvlist", (DataView)dvlist, null, System.Web.Caching.Cache.NoAbsoluteExpiration, new TimeSpan(0, 5, 0)); bindData(); } else { //回发 string ctrlname = Page.Request.Params.Get("__EVENTTARGET"); if (ctrlname.IndexOf("dw") != -1) { //是由dropdwonlist 引发的 strqry = "select * From T_films where 1=1"; string filter = ""; if (dwclass.Text != "0") { filter += (" and film_classid=" + dwclass.Text); } if (dwfrom.Text != "0") { filter += (" and film_from = " + dwfrom.Text); } if (dwseecount.Text != "0") { filter += (" and see_count<=" + dwseecount.Text); } if (dw_ServerList.Text != "0") { filter += (" and pathid=" + dw_ServerList.Text); } if (dw_jointime.Text != "0") { filter += string.Format(" and join_time>=DateAdd('m',-{0},date())", dw_jointime.Text); } filter += " order by id desc"; strqry += filter; Session["strqry"] = strqry; dvlist = DBFun.GetDataView(strqry); AspNetPager1.RecordCount = dvlist.Table.Rows.Count; Cache["dvlist"] = dvlist; bindData(); } } }
protected void ddlist_yjxkdm_SelectedIndexChanged(object sender, EventArgs e) { string str_qry = "SELECT url,name from t_dict where flm= 10 and url like '" + ddlist_yjxkdm.SelectedValue + "%'; "; DBFun.FillDwList(ddlist_ejxkdm, str_qry); }