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