protected void bindData()
{
//绑定GridView
string str_sql = "select * from ej_cpry where dw = '" + Session["admin_id"].ToString() + "'";
Session["dv_detail"] = DBFun.FillGridView(str_sql, GridView1, true);
str_sql = "select InitPwd from t_dict where flm = 2 and url = '" + Session["admin_id"].ToString() + "'";
if (DBFun.ExecuteScalar(str_sql) == null)
{
tbx_InitPwd.Text = "";
}
else
{
tbx_InitPwd.Text = DBFun.ExecuteScalar(str_sql).ToString();
}
}
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();
}
}
private void bindData()
{
string str_qry = "";
lbl_id.Text = "";
if (Table1.Visible)
{
imgbtn_save.ImageUrl = "./img/save.gif";
str_qry = "select jsm,num from t_teacher,(" +
" select count(*) as num,jsh from t_cyqk where xm='" + Session["jsm"].ToString() + "' " +
" group by jsh) as cy where t_teacher.jsh = cy.jsh ";
DataTable dt = DBFun.dataTable(str_qry);
if (dt.Rows.Count > 1)
{
string str_name = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
str_name += " [ " + dt.Rows[i]["jsm"].ToString() + " ] ";
}
lbl_cjxm.Text = "您已经参与了" + str_name + "的项目，不能再申请项目了！";
ddlist_sfsb.Enabled = false;
return;
}
str_qry = "select * from t_teacher where jsh = '" + Session["jsh"].ToString() + "' ;";
DataRow dr = DBFun.GetDataRow(str_qry);
try
{
try
{
ddlist_sfsb.SelectedValue = dr["status_sb"].ToString(); //类别
}
catch
{
ddlist_sfsb.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;
}
if (dr["sqbm"].ToString() == "")
{
ddlist_sqbm.SelectedIndex = 0;
}
tbx_xmmc.Text = dr["ktmc"].ToString(); //专家代码
tbx_xmfzr.Text = dr["jsm"].ToString(); //专家代码
tbx_szbm.Text = dr["szbm"].ToString(); //专家代码
tbx_lxdh.Text = dr["lxdh"].ToString(); //专家标识
txt_sqrq.Value = dr["sqrq"].ToString(); //姓名
txt_csny.Value = dr["csny"].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_qtje.Text = dr["xmjf_qtje"].ToString(); //专家代码
tbx_qtyj.Text = dr["xmjf_qtyj"].ToString(); //专家代码
tbx_yjzc.Text = dr["yjzc"].ToString(); //学位
tbx_email.Text = dr["email"].ToString(); //学位
try
{
ddlist_xb.SelectedValue = dr["xb"].ToString(); //政治面貌
}
catch
{
ddlist_xb.SelectedIndex = 0;
}
try
{
ddlist_mz.SelectedValue = dr["mz"].ToString(); //民族
}
catch
{
ddlist_mz.SelectedIndex = 0;
}
try
{
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_gznx.SelectedValue = dr["gznx"].ToString(); //文化程度
}
catch
{
ddlist_gznx.SelectedIndex = 0;
}
try
{
ddlist_xl.SelectedValue = dr["xl"].ToString(); //文化程度
}
catch
{
ddlist_xl.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;
}
}
catch { }
}
else if (Table2.Visible)
{
imgbtn_save.ImageUrl = "./img/save.gif";
str_qry = "SELECT bg_1,bg_2,bg_3,bg_4 from t_teacher where jsh = '" + Session["jsh"].ToString() + "' ;";
DataRow dr = DBFun.GetDataRow(str_qry);
tbx2_1.Text = dr[0].ToString();
tbx2_2.Text = dr[1].ToString();
tbx2_3.Text = dr[2].ToString();
tbx2_4.Text = dr[3].ToString();
}
else if (Table3.Visible)
{
imgbtn_save.ImageUrl = "./img/add.gif";
str_qry = "SELECT * from t_ktqk where jsh = '" + Session["jsh"].ToString() + "' ;";
Session["t_ktqk"] = DBFun.FillGridView(str_qry, gv_ktqk, true);
tbx3_xmmc.Focus();
tbx3_xmmc.Text = "";
tbx3_xmbh.Text = "";
tbx3_xmjb.Text = "";
ddlist3_sfjt.SelectedIndex = 0;
ddlist3_zccy.SelectedIndex = 0;
}
else if (Table4.Visible)
{
imgbtn_save.ImageUrl = "./img/add.gif";
str_qry = "SELECT * from t_kycg where jsh = '" + Session["jsh"].ToString() + "' ;";
Session["t_kycg"] = DBFun.FillGridView(str_qry, gv_kycg, true);
tbx4_lwmc.Focus();
tbx4_lwmc.Text = "";
tbx4_fbbk.Text = "";
ddlist4_brpm.SelectedIndex = 0;
ddlist4_zrs.SelectedIndex = 0;
}
else if (Table5.Visible)
{
imgbtn_save.ImageUrl = "./img/add.gif";
str_qry = "SELECT * from t_cyqk where jsh = '" + Session["jsh"].ToString() + "' ;";
Session["t_cyqk"] = DBFun.FillGridView(str_qry, gv_cyqk, true);
tbx5_xm.Focus();
tbx5_xm.Text = "";
tbx5_zc.Text = "";
tbx5_yjzc.Text = "";
ddlist5_szbm.SelectedIndex = 0;
tbx5_fg.Text = "";
}
else if (Table6.Visible)
{
imgbtn_save.ImageUrl = "./img/add.gif";
str_qry = "SELECT * from t_tjyj where jsh = '" + Session["jsh"].ToString() + "' ;";
Session["t_tjyj"] = DBFun.FillGridView(str_qry, gv_tjyj, true);
tbx6_xm.Focus();
tbx6_xm.Text = "";
tbx6_zc.Text = "";
ddlist6_szbm.SelectedIndex = 0;
tbx6_tjyj.Text = "";
}
}
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 { }
}
}
private void bindData()
{
string str_qry = "";
lbl_id.Text = "";
if (Table1.Visible)
{
//民族
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("、"));
}
str_qry = "SELECT url from t_dict where flm = 8 and bm = 6";
int i_year = DateTime.Now.Year;
try
{
i_year = Convert.ToInt16(DBFun.ExecuteScalar(str_qry));
}
catch
{
}
ddlist_ttnf.Items.Clear();
ddlist_ttnf.Items.Add("无");
ddlist_tgnf.Items.Clear();
ddlist_tgnf.Items.Add("无");
ddlist_sbnf.Items.Clear();
ddlist_sbnf.Items.Add("无");
ddlist_hgnf.Items.Clear();
ddlist_hgnf.Items.Add("无");
ddlist_bdnf.Items.Clear();
ddlist_bdnf.Items.Add("无");
ddlist_jbzn.Items.Clear();
ddlist_jbzn.Items.Add("无");
for (int i = 0; i < 10; i++)
{
//ddlist_ttnf.Items.Add(Convert.ToString(i_year - 1 - i) + "年");
ddlist_tgnf.Items.Add(Convert.ToString(i_year - 1 - i) + "年");
ddlist_sbnf.Items.Add(Convert.ToString(i_year - 1 - i) + "年");
ddlist_hgnf.Items.Add(Convert.ToString(i_year - 1 - i) + "年");
ddlist_bdnf.Items.Add(Convert.ToString(i_year - 1 - i) + "年");
ddlist_jbzn.Items.Add(Convert.ToString(i_year - 1 - i) + "年");
if (i == 9)
{
ddlist_tgnf.Items.Add(Convert.ToString(i_year - 1 - i) + "年以前");
ddlist_sbnf.Items.Add(Convert.ToString(i_year - 1 - i) + "年以前");
ddlist_hgnf.Items.Add(Convert.ToString(i_year - 1 - i) + "年以前");
ddlist_bdnf.Items.Add(Convert.ToString(i_year - 1 - i) + "年以前");
ddlist_jbzn.Items.Add(Convert.ToString(i_year - 1 - i) + "年以前");
}
}
str_qry = "select * from ts_cpry where sfzh = '" + Session["sfzh"].ToString() + "' ;";
DataRow dr = DBFun.GetDataRow(str_qry);
try
{
tbx_bm.Text = dr["dept"].ToString(); //部门
ddlist_lb.SelectedValue = dr["leibie"].ToString(); //类别
tbx_zjdm.Text = dr["zjdm"].ToString(); //专家代码
tbx_zjbs.Text = dr["zjbs"].ToString(); //专家标识
tbx_Name.Text = dr["yourname"].ToString(); //姓名
txt_csrq.Value = dr["birth"].ToString(); //出生日期
ddlist_xb.SelectedValue = dr["xingbie"].ToString(); //性别
tbx_csd.Text = dr["csd"].ToString(); //出生地
ddlist_zzmm.SelectedValue = dr["zzmm"].ToString(); //政治面貌
ddlist_mz.SelectedValue = dr["mz"].ToString(); //民族
ddlist_whcd.SelectedValue = dr["whcd"].ToString(); //文化程度
ddlist_xw.SelectedValue = dr["xw"].ToString(); //学位
txt_bysj.Value = dr["bysj"].ToString(); //毕业时间
tbx_byxx.Text = dr["byxx"].ToString(); //毕业学校
tbx_sxzy.Text = dr["sxzy"].ToString(); //所学专业
tbx_cszy.Text = dr["cszy"].ToString(); //从事专业
ddlist_jszc.SelectedValue = dr["jszc"].ToString(); //技术职称
tbx_gzdw.Text = dr["gzdw_mc"].ToString(); //工作单位
txt_gzsj.Value = dr["gzsj"].ToString(); //工作时间
ddlist_dwlb.SelectedValue = dr["dwlb"].ToString(); //单位类别
ddlist_dwxz.SelectedValue = dr["dwxz"].ToString(); //单位性质
ddlist_zgzt.SelectedValue = dr["zgzt"].ToString(); //在岗状态
ddlist_xzzw.SelectedValue = dr["xzzw"].ToString(); //行政职务
ddlist_xzjb.SelectedValue = dr["xzjb"].ToString(); //行政级别
ddlist_ggqjb.SelectedValue = dr["ggqjb"].ToString(); //工改前级别
ddlist_gkhy.SelectedValue = dr["gkhy"].ToString(); //归口行业
tbx_lxdh.Text = dr["lxdh"].ToString(); //联系电话
tbx_yzbm.Text = dr["yzbm"].ToString(); //邮政编码
ddlist_ys.SelectedValue = dr["ys"].ToString(); //院士
tbx_gzbj.Text = dr["gzbj"].ToString(); //跟踪标记
ddlist_ttnf.SelectedValue = dr["ttnf"].ToString(); //特贴年份
tbx_ttje.Text = "无"; //特贴金额
ddlist_tgnf.SelectedValue = dr["tgnf"].ToString(); //突贡年份
ddlist_sbnf.SelectedValue = dr["sbnf"].ToString(); //省部年份
ddlist_hgnf.SelectedValue = dr["hgnf"].ToString(); //回国年份
tbx_hcgl.Text = dr["hcgl"].ToString(); //何处归来
tbx_lhjt.Text = dr["lhjt"].ToString(); //来华津贴
ddlist_bdnf.SelectedValue = dr["bdnf"].ToString(); //博导年份
ddlist_jbzn.SelectedValue = dr["jbzn"].ToString(); //进博站年
}
catch { }
}
else if (Table2.Visible)
{
str_qry = "SELECT gzjl from ts_cpry where sfzh = '" + Session["sfzh"].ToString() + "' ;";
ftb2_1.Text = DBFun.ExecuteScalar(str_qry).ToString();
}
else if (Table3.Visible)
{
str_qry = "SELECT * from ts_hjqk where sfzh = '" + Session["sfzh"].ToString() + "' ;";
Session["ts_hjqk"] = DBFun.FillGridView(str_qry, gv_hjqk, true);
for (int i = DateTime.Today.Year; i >= 1980; i--)
{
ddlist3_nd.Items.Add(i.ToString());
}
ddlist3_nd.Focus();
ddlist3_nd.SelectedIndex = 0;
ddlist3_jlzl.SelectedIndex = 0;
tbx3_hjxm.Text = "";
ddlist3_jldj.SelectedIndex = 0;
tbx3_pm.Text = "";
}
else if (Table4.Visible)
{
str_qry = "SELECT gxsj,lwzz,zxcg from ts_cpry where sfzh = '" + Session["sfzh"].ToString() + "' ;";
DataRow dr = DBFun.GetDataRow(str_qry);
ftb4_1.Focus = true;
ftb4_1.Text = dr["gxsj"].ToString();
ftb4_2.Text = dr["lwzz"].ToString();
ftb4_3.Text = dr["zxcg"].ToString();
}
else if (Table5.Visible)
{
str_qry = "SELECT * from ts_khqk where sfzh = '" + Session["sfzh"].ToString() + "' ;";
Session["ts_khqk"] = DBFun.FillGridView(str_qry, gv_khqk, true);
for (int i = DateTime.Today.Year; i >= 1980; i--)
{
ddlist5_khnd.Items.Add(i.ToString());
}
ddlist5_khnd.Focus();
ddlist5_khnd.SelectedIndex = 0;
tbx5_khnr.Text = "";
ddlist5_khjl.SelectedIndex = 0;
}
}
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 bindData()
{
DataView dv;
Label lbl_Value;
int i_id;
string str_sql = "SELECT yourname,gzdw_mc,dept,leibie," +
" zjdm ,zjbs, xingbie,birth, format(birth,'yyyy年MM月DD日') as csrq,csd,zzmm," +
" mz,whcd,xw, bysj, byxx,sxzy,cszy,jszc,gzsj,dwlb,dwxz,zgzt,xzzw,xzjb,ggqjb," +
" gkhy,lxdh,yzbm,ys,gzbj,ttnf,ttje,tgnf,sbnf,hgnf,hcgl,lhjt,bdnf,jbzn, " +
" gzjl,gxsj,lwzz,zxcg" +
" FROM ts_cpry,t_dict" +
" WHERE flm = 2 and gzdw = url and sfzh='" + Session["sfzh"].ToString() + "'";
DataRow dr = DBFun.GetDataRow(str_sql);
//1
//lbl1_zjdm.Text = " ";
lbl_xm.Text = dr["yourname"].ToString();
//lbl_dw.Text = dr["gzdw_mc"].ToString();
//lbl_bm.Text = dr["dept"].ToString();
//lbl_lb.Text = dr["leibie"].ToString();
//2
//lbl1_zjdm.Text = dr["zjdm"].ToString();
//lbl1_xm.Text = dr["yourname"].ToString();
//lbl1_zjbs.Text = dr["zjbs"].ToString();
lbl1_xb.Text = dr["xingbie"].ToString();
lbl1_csrq.Text = dr["birth"].ToString();
lbl1_csd.Text = dr["csd"].ToString();
lbl1_zzmm.Text = dr["zzmm"].ToString();
lbl1_mz.Text = dr["mz"].ToString();
lbl1_whcd.Text = dr["whcd"].ToString();
lbl1_xw.Text = dr["xw"].ToString();
lbl1_bysj.Text = dr["bysj"].ToString();
lbl1_byxx.Text = dr["byxx"].ToString();
lbl1_sxzy.Text = dr["sxzy"].ToString();
lbl1_cszy.Text = dr["cszy"].ToString();
lbl1_jszc.Text = dr["jszc"].ToString();
lbl1_gzdw.Text = dr["gzdw_mc"].ToString();
lbl1_gzsj.Text = dr["gzsj"].ToString();
//lbl1_dwlb.Text = dr["dwlb"].ToString();
//lbl1_dwxz.Text = dr["dwxz"].ToString();
//lbl1_zgzt.Text = dr["zgzt"].ToString();
//lbl1_xzzw.Text = dr["xzzw"].ToString();
//lbl1_xzjb.Text = dr["xzjb"].ToString();
//lbl1_ggqjb.Text = dr["ggqjb"].ToString();
//lbl1_gkhy.Text = dr["gkhy"].ToString();
//lbl1_lxdh.Text = dr["lxdh"].ToString();
//lbl1_yzbm.Text = dr["yzbm"].ToString();
//lbl1_ys.Text = dr["ys"].ToString();
//lbl1_gzbj.Text = dr["gzbj"].ToString();
//lbl1_ttnf.Text = dr["ttnf"].ToString();
//lbl1_ttje.Text = dr["ttje"].ToString();
//lbl1_tgnf.Text = dr["tgnf"].ToString();
//lbl1_sbnf.Text = dr["sbnf"].ToString();
//lbl1_hgnf.Text = dr["hgnf"].ToString();
//lbl1_hcgl.Text = dr["hcgl"].ToString();
//lbl1_lhjt.Text = dr["lhjt"].ToString();
lbl1_bdnf.Text = dr["bdnf"].ToString();
lbl1_jbzn.Text = dr["jbzn"].ToString();
lbl1_gzjl.Text = dr["gzjl"].ToString();
string str_text = dr["gzjl"].ToString();
//string str_1 = "mso-bidi-font-size:";
//string str_2 = "FONT-SIZE:";
//string str_OldString;
//string str_NewString = "18";
//int i_index1 = 0;
//int i_index2 = 0;
//int i_lenth = 0;
//i_index1 = str_text.IndexOf(str_1, i_index1) + 19;
//if (i_index1 > 19)
//{
// i_index2 = str_text.IndexOf("pt;", i_index1);
// if (i_index2 > 0)
// {
// i_lenth = i_index2 - i_index1;
// str_OldString = str_text.Substring(i_index1, i_lenth);
// str_text = str_text.Replace(str_OldString, str_NewString);
// }
// i_index1 = 0;
// i_index1 = str_text.IndexOf(str_2, i_index1) + 10;
// if (i_index1 > 10)
// {
// i_index2 = str_text.IndexOf("pt;", i_index1);
// if (i_index2 > 0)
// {
// i_lenth = i_index2 - i_index1;
// str_OldString = str_text.Substring(i_index1, i_lenth);
// str_text = str_text.Replace(str_OldString, str_NewString);
// }
// }
//}
lbl1_gzjl.Text = str_text;
ftb2_1.Text = str_text;
//3获奖情况
str_sql = "SELECT * from ts_hjqk where sfzh = '" + Session["sfzh"].ToString() + "' order by id;";
//dv = DBFun.GetDataView(str_sql);
DBFun.FillGridView(str_sql, gv_hjqk, true);
//for (int i = 0; i < dv.Table.Rows.Count; i++)
//{
// if (i == 12) break;
// i_id = i + 1;
// lbl_Value = (Label)this.FindControl("lbl2_" + i_id.ToString() + "1");
// lbl_Value.Text = dv.Table.Rows[i]["jlzl"].ToString();
// lbl_Value = (Label)this.FindControl("lbl2_" + i_id.ToString() + "2");
// lbl_Value.Text = dv.Table.Rows[i]["hjxm"].ToString();
// lbl_Value = (Label)this.FindControl("lbl2_" + i_id.ToString() + "3");
// lbl_Value.Text = dv.Table.Rows[i]["jldj"].ToString();
// lbl_Value = (Label)this.FindControl("lbl2_" + i_id.ToString() + "4");
// lbl_Value.Text = dv.Table.Rows[i]["pm"].ToString();
// lbl_Value = (Label)this.FindControl("lbl2_" + i_id.ToString() + "5");
// lbl_Value.Text = dv.Table.Rows[i]["nd"].ToString();
//}
//4.专业水平情况
//主要突出贡献事迹
lbl3_1.Text = dr["gxsj"].ToString();
//代表论文和著作
lbl3_2.Text = dr["lwzz"].ToString();
//最新成果
lbl3_3.Text = dr["zxcg"].ToString();
ftb4_1.Text = dr["gxsj"].ToString();
//代表论文和著作
ftb4_2.Text = dr["lwzz"].ToString();
//最新成果
ftb4_3.Text = dr["zxcg"].ToString();
//5获奖情况
str_sql = "SELECT * from ts_khqk where sfzh = '" + Session["sfzh"].ToString() + "' order by id;";
//dv = DBFun.GetDataView(str_sql);
DBFun.FillGridView(str_sql, gv_khqk, true);
//for (int i = 0; i < dv.Table.Rows.Count; i++)
//{
// if (i == 8) break;
// i_id = i + 1;
// lbl_Value = (Label)this.FindControl("lbl4_" + i_id.ToString() + "1");
// lbl_Value.Text = dv.Table.Rows[i]["khnd"].ToString();
// lbl_Value = (Label)this.FindControl("lbl4_" + i_id.ToString() + "2");
// lbl_Value.Text = dv.Table.Rows[i]["khnr"].ToString();
// lbl_Value = (Label)this.FindControl("lbl4_" + i_id.ToString() + "3");
// lbl_Value.Text = dv.Table.Rows[i]["khjl"].ToString();
//}
////专利与成果转化情况
//str_sql = "SELECT * from ej_zlycgzh where sfzh = '" + Session["sfzh"].ToString() + "' order by id;";
//dv = DBFun.GetDataView(str_sql);
//for (int i = 0; i < dv.Table.Rows.Count; i++)
//{
// if (i == 5) break;
// i_id = i + 1;
// lbl_Value = (Label)this.FindControl("lbl_zlcg_" + i_id.ToString() + "1");
// lbl_Value.Text = dv.Table.Rows[i]["zlmc"].ToString();
// lbl_Value = (Label)this.FindControl("lbl_zlcg_" + i_id.ToString() + "2");
// lbl_Value.Text = dv.Table.Rows[i]["zhjg"].ToString();
//}
////获奖情况
//str_sql = "SELECT * from ej_hjqk where sfzh = '" + Session["sfzh"].ToString() + "' order by id ;";
//dv = DBFun.GetDataView(str_sql);
//for (int i = 0; i < dv.Table.Rows.Count; i++)
//{
// if (i == 5) break;
// i_id = i + 1;
// lbl_Value = (Label)this.FindControl("lbl_hjqk_" + i_id.ToString() + "1");
// lbl_Value.Text = dv.Table.Rows[i]["nd"].ToString();
// lbl_Value = (Label)this.FindControl("lbl_hjqk_" + i_id.ToString() + "2");
// lbl_Value.Text = dv.Table.Rows[i]["jlzl"].ToString();
// lbl_Value = (Label)this.FindControl("lbl_hjqk_" + i_id.ToString() + "3");
// lbl_Value.Text = dv.Table.Rows[i]["hjcgmc"].ToString();
// lbl_Value = (Label)this.FindControl("lbl_hjqk_" + i_id.ToString() + "4");
// lbl_Value.Text = dv.Table.Rows[i]["jldj"].ToString();
// lbl_Value = (Label)this.FindControl("lbl_hjqk_" + i_id.ToString() + "5");
// lbl_Value.Text = dv.Table.Rows[i]["pm"].ToString();
//}
////国内外学术任职情况
//str_sql = "SELECT * from ej_xsrzqk where sfzh = '" + Session["sfzh"].ToString() + "' order by id;";
//dv = DBFun.GetDataView(str_sql);
//for (int i = 0; i < dv.Table.Rows.Count; i++)
//{
// if (i == 5) break;
// i_id = i + 1;
// lbl_Value = (Label)this.FindControl("lbl_xsrz_" + i_id.ToString() + "1");
// lbl_Value.Text = dv.Table.Rows[i]["rzzzmc"].ToString();
// lbl_Value = (Label)this.FindControl("lbl_xsrz_" + i_id.ToString() + "2");
// lbl_Value.Text = dv.Table.Rows[i]["drzw"].ToString();
// lbl_Value = (Label)this.FindControl("lbl_xsrz_" + i_id.ToString() + "3");
// lbl_Value.Text = dv.Table.Rows[i]["rzqzsj"].ToString();
//}
}
