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