protected void Page_Load(object sender, EventArgs e) { if (Session["admin_id"] == null) { Response.Write("<script>alert('页面失效,请您重新登录!');location.href = './admin_login.aspx';</script>"); return; } string str_sql = "SELECT tjdw_mc, " + " yourname, " + " ejxk_mc, " + " lw_ctitle, " + " zdjs_xm, " + " cplb , " + " '' as ry_group , score " + " FROM yxxwlw_cpry , " + " ( select round(avg(fs_pjys_sum),0) as score ,cpry_sfzh from zjry group by cpry_sfzh ) as a " + " where a.cpry_sfzh=sfzh and edit_flag = false and tj_flag = '推荐' and sh_flag = '通过' order by id asc "; if (Request.QueryString["type"] == "export") { DataTable dt = DBFun.dataTable(str_sql); CreateExcel(dt, "1", "1.xls"); return; } DataView dv = DBFun.GetDataView(str_sql); GridView1.DataSource = dv; GridView1.DataBind(); }
protected void btn_BatchDisplayYj_Click(object sender, EventArgs e) { TD_AddUser.Visible = true; btn_confirm.Visible = false; str_sql = " select jsm,username,jypj " + " from t_zjry1 a,t_teacher b,t_expert c " + " where a.zjNo=c.loginname and mid(appNo,5)=b.jsh " + " order by jsm,username "; //ExcelManager.Exp2Excel(this.Page, str_sql); DataTable dt = DBFun.dataTable(str_sql); if (dt == null) { return; } string str_jsmo = "", str_jsmn = "", str_yjpj; for (int i = 0; i < dt.Rows.Count; i++) { str_jsmn = dt.Rows[i]["jsm"].ToString(); if (str_jsmn != str_jsmo) { ftb_content.Text += "被评人:" + dt.Rows[i]["jsm"].ToString() + "<br/><br/>"; } str_yjpj = dt.Rows[i]["jypj"].ToString().Replace("'", "‘"); if (str_yjpj == "") { str_yjpj = "无"; } ftb_content.Text += dt.Rows[i]["UserName"] + ":<br/>" + str_yjpj + "<br/><br/>"; str_jsmo = str_jsmn; } }
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { string str_yjpj; bindData(); TD_AddUser.Visible = true; int i_rownum = e.NewEditIndex + (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize; checkCache(); dv = (DataView)Cache["dv_detail"]; lbl_jsm.Text = GridView1.Rows[e.NewEditIndex].Cells[2].Text.ToString(); lbl_appNo.Text = dv.Table.Rows[i_rownum]["appNo"].ToString(); ftb_content.Text = dv.Table.Rows[i_rownum]["yj3"].ToString(); if (ftb_content.Text == "") { str_sql = "exec Q_Para_LxZjyj_ByappNo '" + lbl_appNo.Text + "'"; DataTable dt = DBFun.dataTable(str_sql); if (dt == null) { return; } for (int i = 0; i < dt.Rows.Count; i++) { str_yjpj = dt.Rows[i]["jypj"].ToString().Replace("'", "‘"); if (str_yjpj == "") { str_yjpj = "无"; } ftb_content.Text += dt.Rows[i]["UserName"] + ":<br/>" + str_yjpj + "<br/><br/>"; } } }
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_id = Request.QueryString["id"]; Session["type"] = str_id; string str_sql = "select bm,name from t_dict where flm = " + str_id + " order by bm;"; DataTable dt = DBFun.dataTable(str_sql); DwPath.Items.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { ListItem litem = new ListItem(); litem.Value = dt.Rows[i]["bm"].ToString(); litem.Text = dt.Rows[i]["name"].ToString(); DwPath.Items.Add(litem); } GetInfo(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string str_sql; str_sql = "SELECT top 20 hot,leixing,id,title+'('+format(shijian,'mm-dd')+')' as biaoti FROM news where leibie = '新闻' order by shijian asc,id asc"; DataView dv = DBFun.GetDataView(str_sql); GV_news.DataSource = dv; GV_news.DataBind(); Session["dv_news"] = dv; //更改数据库数据类型 //str_sql = "alter table cpry alter column cdrw_gg_khyx1 varchar(255)"; //DBFun.ExecuteSql(str_sql); //str_sql = "alter table cpry alter column cdrw_gg_khcz1 varchar(255)"; //DBFun.ExecuteSql(str_sql); //str_sql = "alter table cpry alter column cdrw_gg_khyx2 varchar(255)"; //DBFun.ExecuteSql(str_sql); //str_sql = "alter table cpry alter column cdrw_gg_khcz2 varchar(255)"; //DBFun.ExecuteSql(str_sql); str_sql = "select * from cpry"; DataTable dt = DBFun.dataTable(str_sql); if (!dt.Columns.Contains("score_zj")) { str_sql = "alter table cpry add COLUMN score_zj double;"; DBFun.ExecuteSql(str_sql); } } }
protected void bindData() { string str_sql = "select iif(fs_sftj='true','○','×') as sftj,yourname from ej_cpry,zjry,t_dict " + " where cpry_sfzh = sfzh and flm = 2 and dw = url and flag = 2 and zj_sfzh = '" + str_zjid + "' and edit_flag = false and ej_cpry.tj_flag = '推荐' and sh_flag = '通过' and t_dict.ej_tj_flag=true " + " order by url,id"; //"where cpry_sfzh = sfzh and flag = 2 and zj_sfzh = '" + //Session["admin_id"].ToString() + "' and edit_flag = false and tj_flag = '推荐' and sh_flag = '通过' order by dw,id"; DataTable dt = DBFun.dataTable(str_sql); Label lbl_Value; int i_id; for (int i = 0; i < dt.Rows.Count; i++) { if (i == 35) { break; } i_id = i + 1; lbl_Value = (Label)this.FindControl("lbl" + i_id.ToString() + "_1"); lbl_Value.Text = dt.Rows[i]["yourname"].ToString(); lbl_Value = (Label)this.FindControl("lbl" + i_id.ToString() + "_2"); lbl_Value.Text = dt.Rows[i]["sftj"].ToString(); } }
protected void btn_Change_Click(object sender, EventArgs e) { string strOldid = ""; string strNewid = ""; int i_count = 0; for (int i = 0; i < GridView1.Rows.Count; i++) { CheckBox ckb = (CheckBox)GridView1.Rows[i].FindControl("cbx_select"); if (ckb.Checked) { if (strOldid == "") { strOldid = GridView1.Rows[i].Cells[0].Text; } else { strNewid = GridView1.Rows[i].Cells[0].Text; } i_count++; } } if (i_count != 2) { Response.Write("<script>alert('选且只能选择两条记录!');</script>"); } else { //互换 string strsql = " select sfzh from t_yszj where appyear=year(date()) and id in (" + strOldid + "," + strNewid + ") ;"; DataTable dt = DBFun.dataTable(strsql); strOldid = dt.Rows[0][0].ToString(); strNewid = dt.Rows[1][0].ToString(); strsql = " select count(*) from zjry where zj_sfzh = '" + strOldid + "' ;"; if (Convert.ToInt16(DBFun.ExecuteScalar(strsql)) > 0) { strsql = " update zjry set zj_sfzh = '" + strNewid + "' where flag = " + lbl_type.Text + " and zj_sfzh = '" + strOldid + "'"; } else { strsql = " update zjry set zj_sfzh = '" + strOldid + "' where flag = " + lbl_type.Text + " and zj_sfzh = '" + strNewid + "'"; } if (DBFun.ExecuteUpdate(strsql)) { Response.Write("<script>alert('互换成功!');</script>"); bindData(); } } }
protected void Button2_Click(object sender, EventArgs e) { string str_sql = "select * from t_teacher"; string str_pwd; string str_jsh; System.Data.DataTable dt = DBFun.dataTable(str_sql); for (int i = 0; i < dt.Rows.Count; i++) { str_jsh = dt.Rows[i]["jsh"].ToString(); str_pwd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(str_jsh, "MD5"); str_sql = "update t_teacher set pwd = '" + str_pwd + "' where jsh = '" + str_jsh + "'"; DBFun.ExecuteSql(str_sql); } }
protected void Button4_Click(object sender, EventArgs e) { string str_sql = "select * from t_expert"; string str_pwd; string str_xsh; System.Data.DataTable dt = DBFun.dataTable(str_sql); for (int i = 0; i < dt.Rows.Count; i++) { str_xsh = dt.Rows[i]["loginname"].ToString(); str_pwd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(str_xsh, "MD5"); str_sql = "update t_expert set pwd = '" + str_pwd + "' where loginname = '" + str_xsh + "'"; DBFun.ExecuteSql(str_sql); } Response.Write("<script>alert('执行完毕!');</script>"); }
protected void btn_exp2Excel_Click(object sender, EventArgs e) { str_sql = " select sqr ,zjpf1,zjpf2,zjpf3,zjpf4,zjpf5,zjpf6,zjpf7,zf,pjf,ps " + " from t_teacher_list " + " where appyear=year(date()) " + " and Status between (select url from t_dict where flm= 11 and bm = 4) and (select url from t_dict where flm= 11 and bm = 5)" + " and ktmc is not null " + " and sqbm in (select name from t_dict where flm= 13 and tj_flag) "; if (ddlist_cGroup.SelectedIndex != 0) { str_sql += " and ( cGroup3 = '" + ddlist_cGroup.SelectedValue + "') "; } str_sql += " order by cGroup3,pm "; DataTable dt = DBFun.dataTable(str_sql); HttpResponse resp; resp = Page.Response; resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); resp.AppendHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString() + ".xls"); int i_colnum = dt.Columns.Count; //定义表对象与行对像,同时用DataSet对其值进行初始化 string str_colHeaders = "防灾科技学院教学研究与教学改革项目立项评审结果\n"; str_colHeaders += "序号\t申请人\t评委1\t评委2\t评委3\t评委4\t评委5\t评委6\t评委7\t总分\t平均分\t排名\t同意立项票数\t备注\n"; for (int i = 0; i < dt.Rows.Count; i++) { str_colHeaders += Convert.ToString(i + 1) + "\t"; str_colHeaders += dt.Rows[i]["sqr"].ToString() + "\t"; str_colHeaders += dt.Rows[i]["zjpf1"].ToString() + "\t"; str_colHeaders += dt.Rows[i]["zjpf2"].ToString() + "\t"; str_colHeaders += dt.Rows[i]["zjpf3"].ToString() + "\t"; str_colHeaders += dt.Rows[i]["zjpf4"].ToString() + "\t"; str_colHeaders += dt.Rows[i]["zjpf5"].ToString() + "\t"; str_colHeaders += dt.Rows[i]["zjpf6"].ToString() + "\t"; str_colHeaders += dt.Rows[i]["zjpf7"].ToString() + "\t"; str_colHeaders += dt.Rows[i]["zf"].ToString() + "\t"; str_colHeaders += dt.Rows[i]["pjf"].ToString() + "\t"; str_colHeaders += Convert.ToString(i + 1) + "\t"; str_colHeaders += dt.Rows[i]["ps"].ToString() + "\n"; } resp.Write(str_colHeaders); //写缓冲区中的数据到HTTP头文件中 resp.End(); }
/// <summary> /// 导出到Excel /// </summary> /// <param name="pg">页面</param> /// <param name="str_sql">SQL</param> /// <param name="str_colHeaders">列名</param>格式为("列名1\t列名2\t……列名\n) /// <param name="i_colnum">列数</param> #region 导出到Excel函数 public static void Exp2Excel(Page pg, string str_sql) { DataTable dt = DBFun.dataTable(str_sql); HttpResponse resp; resp = HttpContext.Current.Response; resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); resp.AppendHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString() + ".xls"); int i = 0; int i_colnum = dt.Columns.Count; //定义表对象与行对像,同时用DataSet对其值进行初始化 string str_colHeaders = ""; for (int k = 0; k < i_colnum; k++) { str_colHeaders += dt.Columns[k].ColumnName + "\t"; if (k == i_colnum - 1) { str_colHeaders += "\n"; } } for (i = 0; i < dt.Rows.Count; i++) { //str_colHeaders += Convert.ToString(i + 1) + "\t"; for (int j = 0; j < i_colnum; j++) { str_colHeaders += dt.Rows[i][j].ToString() + "\t"; if (j == i_colnum - 1) { str_colHeaders += "\n"; } } } resp.Write(str_colHeaders); //写缓冲区中的数据到HTTP头文件中 resp.End(); }
protected void bindData() { string str_sql = " select gzdw_mc,yourname,sftj,tj_order from ts_cpry,t_dict," + " (select cpry_sfzh,sum(iif(fs_sftj='False',0,1)) as sftj, sum(iif(isnull(iif(fs_pjys1='',0,fs_pjys1)),0,iif(fs_pjys1='',0,fs_pjys1))) as tj_order from zjry " + " where flag = 3 group by cpry_sfzh ) " + " where cpry_sfzh = sfzh and gzdw=url and edit_flag = false and ts_cpry.tj_flag = '推荐' and sh_flag = '通过' and t_dict.ts_tj_flag=true order by url,id asc "; //"where cpry_sfzh = sfzh and flag = 2 and zj_sfzh = '" + //Session["admin_id"].ToString() + "' and edit_flag = false and tj_flag = '推荐' and sh_flag = '通过' order by dw,id"; DataTable dt = DBFun.dataTable(str_sql); Label lbl_Value; int i_id; for (int i = 0; i < dt.Rows.Count; i++) { if (i == 32) { break; } i_id = i + 1; lbl_Value = (Label)this.FindControl("lbl" + i_id.ToString() + "_1"); lbl_Value.Text = dt.Rows[i]["gzdw_mc"].ToString(); lbl_Value = (Label)this.FindControl("lbl" + i_id.ToString() + "_2"); lbl_Value.Text = dt.Rows[i]["yourname"].ToString(); lbl_Value = (Label)this.FindControl("lbl" + i_id.ToString() + "_3"); lbl_Value.Text = dt.Rows[i]["sftj"].ToString(); lbl_Value = (Label)this.FindControl("lbl" + i_id.ToString() + "_4"); lbl_Value.Text = dt.Rows[i]["tj_order"].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 = ""; } }
protected void Calc_fs() { //循环所有老师 str_sql = " select a.appNo,jsh,sqr " + " from t_teacher_list a " + " where Status = (select url from t_dict where flm= 11 and bm = 6) "; DataTable dt = DBFun.dataTable(str_sql); DataTable dt1; int i = 0; int i_pm = 0; bool[] i_zjtp = new bool[5]; int i_tjps; string str_Group = ""; string str_appNo; //把专家分数、投票数写入t_teacher_list表中 for (i = 0; i < dt.Rows.Count; i++) { str_appNo = dt.Rows[i]["appNo"].ToString(); str_sql = "SELECT appNo,zjno, sftj from t_zjry2 where appno = '" + str_appNo + "' order by zjNo "; dt1 = DBFun.dataTable(str_sql); i_tjps = 0; Array.Clear(i_zjtp, 0, i_zjtp.Length); for (int j = 0; j < dt1.Rows.Count; j++) { i_zjtp[j] = Convert.ToBoolean(dt1.Rows[j]["sftj"]); if (Convert.ToBoolean(dt1.Rows[j]["sftj"])) { i_tjps++; } } str_sql = string.Format("update t_teacher_list set zjtp2_1 = {0},zjtp2_2 = {1},zjtp2_3 = {2},zjtp2_4 = {3},zjtp2_5 = {4},ps2={5} " + " where appNo = '{6}'", i_zjtp[0], i_zjtp[1], i_zjtp[2], i_zjtp[3], i_zjtp[4], i_tjps, str_appNo); DBFun.ExecuteUpdate(str_sql); } //计算排名 str_sql = " select appNo,cGroup2 " + " from t_teacher_list " + " where Status = (select url from t_dict where flm= 11 and bm = 6)"; if (ddlist_cGroup.SelectedIndex != 0) { str_sql += " and ( cGroup2 = '" + ddlist_cGroup.SelectedValue + "') "; } str_sql += " order by cGroup2,ps2 desc,sqbm,sqr"; dt = DBFun.dataTable(str_sql); for (i = 0; i < dt.Rows.Count; i++) { str_appNo = dt.Rows[i]["appNo"].ToString(); if (str_Group != dt.Rows[i]["cGroup2"].ToString()) { i_pm = 1; } else { i_pm += 1; } str_sql = string.Format("update t_teacher_list set pm2 = {0} " + " where appNo = '{1}'", i_pm, str_appNo); DBFun.ExecuteUpdate(str_sql); str_Group = dt.Rows[i]["cGroup2"].ToString(); } }
protected void Calc_fs() { //循环所有老师 str_sql = " select appNo,mid(appNo,5) as jsh,sqr from ( " + " select a.appNo,jsh,sqr " + " from t_teacher_list a,t_zjry0 b " + " where a.appNo = b.appNo and left(a.appNo,4)=year(date()) " + //" and sqbm in (select name from t_dict where flm= 13 and tj_flag)"+ " and Status >= (select url from t_dict where flm= 11 and bm = 3) "; if (ddlist_cGroup.SelectedIndex != 0) { str_sql += " and ( cGroup0 = '" + ddlist_cGroup.SelectedValue + "') "; } str_sql += " order by sqbm,sqr " + " ) group by appNo,sqr "; DataTable dt = DBFun.dataTable(str_sql); DataTable dt1; int i = 0; int i_pm = 0; bool[] i_zjtp = new bool[5]; int i_tjps; string str_Group = ""; string str_appNo; //把专家分数、投票数写入t_teacher_list表中 for (i = 0; i < dt.Rows.Count; i++) { str_appNo = dt.Rows[i]["appNo"].ToString(); str_sql = "exec Q_Para_ZqpsFs_byappNo '" + str_appNo + "'"; dt1 = DBFun.dataTable(str_sql); i_tjps = 0; Array.Clear(i_zjtp, 0, i_zjtp.Length); for (int j = 0; j < dt1.Rows.Count; j++) { i_zjtp[j] = Convert.ToBoolean(dt1.Rows[j]["sftj"]); if (Convert.ToBoolean(dt1.Rows[j]["sftj"])) { i_tjps++; } } str_sql = string.Format("update t_teacher_list set zjtp0_1 = {0},zjtp0_2 = {1},zjtp0_3 = {2},zjtp0_4 = {3},zjtp0_5 = {4},ps0={5} " + " where appNo = '{6}'", i_zjtp[0], i_zjtp[1], i_zjtp[2], i_zjtp[3], i_zjtp[4], i_tjps, str_appNo); DBFun.ExecuteUpdate(str_sql); } //计算排名 str_sql = " select appNo,cGroup0 " + " from t_teacher_list " + " where left(appNo,4)=year(date()) " + //" and sqbm in (select name from t_dict where flm= 13 and tj_flag)"+ " and Status >= (select url from t_dict where flm= 11 and bm = 3) "; if (ddlist_cGroup.SelectedIndex != 0) { str_sql += " and ( cGroup0 = '" + ddlist_cGroup.SelectedValue + "') "; } str_sql += " order by cGroup0,ps0 desc,sqbm,sqr"; dt = DBFun.dataTable(str_sql); for (i = 0; i < dt.Rows.Count; i++) { str_appNo = dt.Rows[i]["appNo"].ToString(); if (str_Group != dt.Rows[i]["cGroup0"].ToString()) { i_pm = 1; } else { i_pm += 1; } str_sql = string.Format("update t_teacher_list set pm0 = {0} " + " where appNo = '{1}'", i_pm, str_appNo); DBFun.ExecuteUpdate(str_sql); str_Group = dt.Rows[i]["cGroup0"].ToString(); } }
protected int Save() { string str_sql = ""; //lbl_id.Text = ""; if (Table1.Visible) { if (Convert.ToBoolean(ddlist_sfsb.SelectedValue)) { str_sql = "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_sql); if (dt.Rows.Count > 1) { string str_name = ""; for (int i = 0; i < dt.Rows.Count; i++) { str_name += " [ " + dt.Rows[i]["jsm"].ToString() + " ] "; } Response.Write("<script>alert('您已经参与了" + str_name + "的项目,不能再申请项目了!');</script>"); return(-1); } } str_sql = " update t_teacher set " + " status_sb=" + ddlist_sfsb.SelectedValue + "," + " xmlb='" + ddlist_lb.SelectedValue + "'," + " ktmc='" + tbx_xmmc.Text + "'," + " lxdh='" + tbx_lxdh.Text + "'," + " sqrq='" + txt_sqrq.Value + "'," + " sqbm='" + ddlist_sqbm.SelectedValue + "', " + " csny='" + txt_csny.Value + "', " + " xb='" + ddlist_xb.SelectedValue + "', " + " mz='" + ddlist_mz.SelectedValue + "', " + " zc='" + ddlist_zc.SelectedValue + "', " + " zw='" + ddlist_zw.SelectedValue + "', " + " gznx='" + ddlist_gznx.SelectedValue + "', " + " yjzc='" + tbx_yjzc.Text + "'," + " xl='" + ddlist_xl.SelectedValue + "', " + " xw='" + ddlist_xw.SelectedValue + "', " + " email='" + tbx_email.Text + "', " + " yjnx=" + ddlist_yjnx.SelectedValue + ", " + " xmjf_tsje=" + tbx_tsje.Text + ", " + " xmjf_tsyj='" + tbx_tsyj.Text + "', " + " xmjf_dyje=" + tbx_dyje.Text + ", " + " xmjf_dyyj='" + tbx_dyyj.Text + "', " + " xmjf_wyje=" + tbx_wyje.Text + ", " + " xmjf_wyyj='" + tbx_wyyj.Text + "', " + " xmjf_hyje=" + tbx_hyje.Text + ", " + " xmjf_hyyj='" + tbx_hyyj.Text + "', " + " xmjf_bmje=" + tbx_bmje.Text + ", " + " xmjf_bmyj='" + tbx_bmyj.Text + "', " + " xmjf_qtje=" + tbx_qtje.Text + ", " + " xmjf_qtyj='" + tbx_qtyj.Text + "' " + " where jsh = '" + Session["jsh"].ToString() + "'"; } else if (Table2.Visible) { //string ls_content = tbx2_1.Text; //string ls_content = ftb2_1.HtmlStrippedText; if (CommFun.StringCounter(tbx2_1.Text) > 1500) { Response.Write("<script>alert('选题应在1500字以内!');</script>"); return(-1); } if (CommFun.StringCounter(tbx2_2.Text) > 1500) { Response.Write("<script>alert('内容应在1500字以内!');</script>"); return(-1); } if (CommFun.StringCounter(tbx2_3.Text) > 800) { Response.Write("<script>alert('预期价值应在800字以内!');</script>"); return(-1); } str_sql = " update t_teacher set bg_1='" + tbx2_1.Text + "' , bg_2 = '" + tbx2_2.Text + "' , bg_3 = '" + tbx2_3.Text + "' , bg_4 = '" + tbx2_4.Text + "'" + " where jsh = '" + Session["jsh"].ToString() + "'"; } else if (Table3.Visible) { //if (tbx3_hjxm.Text == "") return 0; if (lbl_id.Text == "") { str_sql = "select count(*) from t_ktqk where jsh = '" + Session["jsh"].ToString() + "'"; if (CommFun.JudgeRowCount(str_sql, 3)) { Response.Write("<script>alert('最多只能增加 3 项!');</script>"); return(-1); } str_sql = "select iif(isnull(max(id)),1,max(id)+1) as maxid from t_ktqk where jsh = '" + Session["jsh"].ToString() + "'"; int int_maxbm = Convert.ToInt32(DBFun.ExecuteScalar(str_sql).ToString()); str_sql = string.Format("insert into t_ktqk (id,xmmc,xmbh,xmjb,sfjt,zccy,jsh) " + " values({0},'{1}','{2}','{3}','{4}','{5}','{6}');", int_maxbm, tbx3_xmmc.Text, tbx3_xmbh.Text, tbx3_xmjb.Text, ddlist3_sfjt.SelectedValue, ddlist3_zccy.SelectedValue, Session["jsh"].ToString()); } else { str_sql = string.Format("update t_ktqk set xmmc='{0}',xmbh='{1}',xmjb='{2}',sfjt='{3}',zccy='{4}' where jsh='{5}' and id={6} ", tbx3_xmmc.Text, tbx3_xmbh.Text, tbx3_xmjb.Text, ddlist3_sfjt.SelectedValue, ddlist3_zccy.SelectedValue, Session["jsh"].ToString(), Convert.ToInt16(lbl_id.Text)); } } else if (Table4.Visible) { //if (Convert.ToInt16(ddlist4_zrs.SelectedValue) < Convert.ToInt16(ddlist4_brpm.SelectedValue)) //{ // Response.Write("<script>alert('本人排名应小于等于总人数!');</script>"); // return -1; //} if (lbl_id.Text == "") { str_sql = "select count(*) from t_kycg where jsh = '" + Session["jsh"].ToString() + "'"; if (CommFun.JudgeRowCount(str_sql, 3)) { Response.Write("<script>alert('最多只能增加 3 项!');</script>"); return(-1); } str_sql = "select iif(isnull(max(id)),1,max(id)+1) as maxid from t_kycg where jsh = '" + Session["jsh"].ToString() + "'"; int int_maxbm = Convert.ToInt32(DBFun.ExecuteScalar(str_sql).ToString()); str_sql = string.Format("insert into t_kycg (id,lwmc,fbbk,brpm,jsh,zrs) " + " values({0},'{1}','{2}','{3}','{4}','{5}');", int_maxbm, tbx4_lwmc.Text, tbx4_fbbk.Text, ddlist4_brpm.SelectedValue, Session["jsh"].ToString(), ddlist4_zrs.SelectedValue); } else { str_sql = string.Format("update t_kycg set lwmc='{0}',fbbk='{1}',brpm='{2}',zrs='{5}' where jsh='{3}' and id={4} ", tbx4_lwmc.Text, tbx4_fbbk.Text, ddlist4_brpm.SelectedValue, Session["jsh"].ToString(), Convert.ToInt16(lbl_id.Text), ddlist4_zrs.SelectedValue); } } else if (Table5.Visible) { if (lbl_id.Text == "") { str_sql = "select count(*) from t_cyqk where jsh = '" + Session["jsh"].ToString() + "' and xm ='" + tbx5_xm.Text.Trim() + "'"; if (CommFun.JudgeRowCount(str_sql, 1)) { Response.Write("<script>alert('" + tbx5_xm.Text.Trim() + " 已经是该项目成员!');</script>"); return(-1); } //str_sql = "select status_sb from t_teacher where jsm = '" + tbx5_xm.Text.Trim() + "'"; //if (Convert.ToBoolean(DBFun.ExecuteScalar(str_sql))) //{ // str_sql = "select count(*) from t_cyqk where xm = '" + tbx5_xm.Text.Trim() + "'"; // if (CommFun.JudgeRowCount(str_sql, 1)) // { // Response.Write("<script>alert('" + tbx5_xm.Text.Trim() + " 已经参与了 2 个项目,不能再参与项目了!');</script>"); // return -1; // } //} //str_sql = "select count(*) from t_cyqk where xm = '" + tbx5_xm.Text.Trim() + "'"; //if (CommFun.JudgeRowCount(str_sql, 2)) //{ // Response.Write("<script>alert('" + tbx5_xm.Text.Trim() + " 已经参与了 2 个项目,不能再参与项目了!');</script>"); // return -1; //} str_sql = "select count(*) from q_tj_list where xm= '" + tbx5_xm.Text.Trim() + "'"; if (CommFun.JudgeRowCount(str_sql, 2)) { Response.Write("<script>alert('" + tbx5_xm.Text.Trim() + " 已经参与了 2 个项目,不能再参与项目了!');</script>"); return(-1); } str_sql = "select count(*) from t_cyqk where jsh = '" + Session["jsh"].ToString() + "'"; if (CommFun.JudgeRowCount(str_sql, 5)) { Response.Write("<script>alert('最多只能增加 5 项!');</script>"); return(-1); } str_sql = "select iif(isnull(max(id)),1,max(id)+1) as maxid from t_cyqk where jsh = '" + Session["jsh"].ToString() + "'"; int int_maxbm = Convert.ToInt32(DBFun.ExecuteScalar(str_sql).ToString()); str_sql = string.Format("insert into t_cyqk (id,xm,zc,szbm,yjzc,fg,jsh) " + " values({0},'{1}','{2}','{3}','{4}','{5}','{6}');", int_maxbm, tbx5_xm.Text, tbx5_zc.Text, ddlist5_szbm.SelectedValue, tbx5_yjzc.Text, tbx5_fg.Text, Session["jsh"].ToString()); } else { str_sql = string.Format("update t_cyqk set xm='{0}',zc='{1}',szbm='{2}',yjzc='{3}',fg='{4}' where jsh='{5}' and id={6} ", tbx5_xm.Text, tbx5_zc.Text, ddlist5_szbm.SelectedValue, tbx5_yjzc.Text, tbx5_fg.Text, Session["jsh"].ToString(), Convert.ToInt16(lbl_id.Text)); } } else if (Table6.Visible) { if (lbl_id.Text == "") { str_sql = "select count(*) from t_tjyj where jsh = '" + Session["jsh"].ToString() + "' and xm ='" + tbx6_xm.Text.Trim() + "'"; if (CommFun.JudgeRowCount(str_sql, 1)) { Response.Write("<script>alert('" + tbx6_xm.Text.Trim() + " 已经是推荐人,请选择其他人员!');</script>"); return(-1); } str_sql = "select count(*) from t_tjyj where jsh = '" + Session["jsh"].ToString() + "'"; if (CommFun.JudgeRowCount(str_sql, 2)) { Response.Write("<script>alert('最多只能增加 2 位推荐人!');</script>"); return(-1); } str_sql = "select iif(isnull(max(id)),1,max(id)+1) as maxid from t_tjyj where jsh = '" + Session["jsh"].ToString() + "'"; int int_maxbm = Convert.ToInt32(DBFun.ExecuteScalar(str_sql).ToString()); str_sql = string.Format("insert into t_tjyj (id,xm,zc,szbm,tjyj,jsh) " + " values({0},'{1}','{2}','{3}','{4}','{5}');", int_maxbm, tbx6_xm.Text, tbx6_zc.Text, ddlist6_szbm.SelectedValue, tbx6_tjyj.Text, Session["jsh"].ToString()); } else { str_sql = string.Format("update t_tjtj set xm='{0}',zc='{1}',szbm='{2}',tjyj='{3}' where jsh='{4}' and id={5} ", tbx6_xm.Text, tbx6_zc.Text, ddlist6_szbm.SelectedValue, tbx6_tjyj.Text, Session["jsh"].ToString(), Convert.ToInt16(lbl_id.Text)); } } if (DBFun.ExecuteUpdate(str_sql)) { if (Session["msg"].ToString() == "no") { Session["msg"] = "yes"; } else { if (Table3.Visible || Table4.Visible || Table5.Visible || Table6.Visible) { Response.Write("<script>alert('添加成功!');</script>"); } else { Response.Write("<script>alert('保存成功!');</script>"); } // Response.Write("<script>alert('保存成功,申报材料已填写完毕,如需修改请点击相应模块!');</script>"); } bindData(); return(1); } else { Response.Write("<script>alert('保存失败!');</script>"); return(-1); } }
protected void Calc_fs() { //循环所有老师 str_sql = " select appNo,mid(appNo,5) as jsh,sqr,sum(fs) as zf,round(avg(fs),2) as pjf from ( " + " select a.appNo,jsh,sqr ,iif(isnull(fs_pjys_sum),0,fs_pjys_sum) as fs " + " from t_teacher_list a,t_zjry1 b " + " where a.appNo = b.appNo and left(a.appNo,4)=year(date()) " + //" and sqbm in (select name from t_dict where flm= 13 and tj_flag)"+ " and Status between (select url from t_dict where flm= 11 and bm = 4) and (select url from t_dict where flm= 11 and bm = 5)"; if (ddlist_cGroup.SelectedIndex != 0) { str_sql += " and ( cGroup3 = '" + ddlist_cGroup.SelectedValue + "') "; } str_sql += " order by sqbm,sqr " + " ) group by appNo,sqr "; DataTable dt = DBFun.dataTable(str_sql); DataTable dt1; int i = 0; int i_pm = 0; double i_zf; int[] i_zjpf = new int[7]; int i_tjps; string str_Group = ""; double dbl_pjf; string str_appNo; //把专家分数、投票数写入t_teacher_list表中 for (i = 0; i < dt.Rows.Count; i++) { str_appNo = dt.Rows[i]["appNo"].ToString(); str_sql = "exec Q_Para_LxpsFs_byappNo '" + str_appNo + "'"; dt1 = DBFun.dataTable(str_sql); i_tjps = 0; i_zf = 0; dbl_pjf = 0; Array.Clear(i_zjpf, 0, i_zjpf.Length); for (int j = 0; j < dt1.Rows.Count; j++) { i_zjpf[j] = Convert.ToInt16(dt1.Rows[j]["fs"]); if (Convert.ToBoolean(dt1.Rows[j]["sftj"])) { i_tjps++; } //if (j >= 1 && j < dt1.Rows.Count - 1) //{ // i_zf += Convert.ToInt16(dt1.Rows[j]["fs"]); //} } //s_pjf = i_zf / (dt1.Rows.Count - 2); //计算总分、平均分 str_sql = " select sqr ,iif(isnull(fs_pjys_sum),0,fs_pjys_sum) as fs,sftj " + " from t_teacher_list a,t_zjry1 b " + " where a.appNo = b.appNo " + " and a.appNo = '" + str_appNo + "'" + " order by sqbm,sqr,fs_pjys_sum"; dt1 = DBFun.dataTable(str_sql); //总分和平均分要去掉最高和最低分 for (int j = 0; j < dt1.Rows.Count; j++) { if (j >= 1 && j < dt1.Rows.Count - 1) { i_zf += Convert.ToInt16(dt1.Rows[j]["fs"]); } } dbl_pjf = Convert.ToDouble(i_zf / (dt1.Rows.Count - 2)); lbl_editflag.Text += dbl_pjf.ToString() + ";"; str_sql = string.Format("update t_teacher_list set zjpf1 = {0},zjpf2 = {1},zjpf3 = {2},zjpf4 = {3},zjpf5 = {4},zjpf6 = {5},zjpf7 = {6},zf={7},pjf={8},ps={9} " + " where appNo = '{10}'", i_zjpf[0], i_zjpf[1], i_zjpf[2], i_zjpf[3], i_zjpf[4], i_zjpf[5], i_zjpf[6], i_zf, dbl_pjf, i_tjps, str_appNo); DBFun.ExecuteUpdate(str_sql); } //计算排名 str_sql = " select appNo,cGroup3 " + " from t_teacher_list " + " where left(appNo,4)=year(date()) " + //" and sqbm in (select name from t_dict where flm= 13 and tj_flag)"+ " and Status between (select url from t_dict where flm= 11 and bm = 4) and (select url from t_dict where flm= 11 and bm = 5)"; if (ddlist_cGroup.SelectedIndex != 0) { str_sql += " and ( cGroup3 = '" + ddlist_cGroup.SelectedValue + "') "; } str_sql += " order by cGroup3,pjf desc ,ps desc"; dt = DBFun.dataTable(str_sql); for (i = 0; i < dt.Rows.Count; i++) { str_appNo = dt.Rows[i]["appNo"].ToString(); if (str_Group != dt.Rows[i]["cGroup3"].ToString()) { i_pm = 1; } else { i_pm += 1; } str_sql = string.Format("update t_teacher_list set pm = {0} " + " where appNo = '{1}'", i_pm, str_appNo); DBFun.ExecuteUpdate(str_sql); str_Group = dt.Rows[i]["cGroup3"].ToString(); } }
protected void Commit() { //判断申报人职称,如果是初级职称不允许提交 str_sql = "select zclb from t_teacher_list where appNo='" + Session["appNo"].ToString() + "'"; string str_zclb = DBFun.ExecuteScalar(str_sql).ToString(); if (str_zclb == "" || str_zclb == "初级") { Response.Write("<script>alert('初级职称不可以申报项目');</script>"); return; } //判断申报人是否有未结题项目,如有未结题项目,不可申报 str_sql = "select count(*) from t_teacher_list where left(appNo,4) < year(date()) and xmbh is not null and " + " Status <(select url from t_dict where flm = 11 and bm = 9 ) and " + "Status >=(select url from t_dict where flm = 11 and bm = 5 ) and mid(appNo,5)='" + Session["jsh"].ToString() + "'"; if (Convert.ToInt16(DBFun.ExecuteScalar(str_sql)) >= 1) { lbl_cjxm.Text = "您有尚未结题的项目,不能再申请项目了!"; Response.Write("<script>alert('" + lbl_cjxm.Text + "');</script>"); return; } //判断申报人是否参加本年度项目,参加一项可以申报,参加两项不能申报 string str_name = ""; str_sql = " exec 查询教师参加项目列表 '" + Session["jsh"].ToString() + "'"; DataTable dt = DBFun.dataTable(str_sql); DataTable dt1; if (dt != null) { if (dt.Rows.Count > 1) { str_name = ""; for (int i = 0; i < dt.Rows.Count; i++) { str_name += " [ " + dt.Rows[i]["sqr"].ToString() + " ] "; } lbl_cjxm.Text = "您已经参与了" + str_name + "的项目,不能再申请项目了!"; Response.Write("<script>alert('" + lbl_cjxm.Text + "');</script>"); return; } } ////判断项目组成员是否已申报项目 //str_qry = " select jsm from t_teacher ,t_teacher_list where t_teacher.jsh = t_teacher_list.jsh and t_teacher.jsh in " + // " (SELECT cyjsh AS num FROM t_cyqk WHERE jsh='" + Session["jsh"].ToString() + // "' ) and t_teacher_list.edit_flag = false "; //dt = DBFun.dataTable(str_qry); //if (dt.Rows.Count >= 1) //{ // str_name = ""; // for (int i = 0; i < dt.Rows.Count; i++) // { // str_name += " [ " + dt.Rows[i]["jsm"].ToString() + " ] "; // } // lbl_cjxm.Text = str_name + "已经申报项目,不能再参加您的项目了!"; // Response.Write("<script>alert('" + lbl_cjxm.Text + "');</script>"); // return; //} ////判断项目组成员参加项目数是否大于2 //str_sql = " select cyjsh,sqr,xmzt from t_cyqk a ,t_teacher_list b where a.cyjsh = b.jsh and a.appyear=year(date()) and b.appyear=year(date()) and a.jsh = '" + Session["jsh"].ToString() + "'"; ////str_sql = " select cyjsh,jsm from t_cyqk a ,t_teacher b where a.cyjsh = b.jsh and left(a.appNo,4)=year(date()) and a.jsh = '" + Session["jsh"].ToString() + "'"; //dt = DBFun.dataTable(str_sql); //if (dt != null) //{ // str_name = ""; // for (int i = 0; i < dt.Rows.Count; i++) // { // if (dt.Rows[i]["xmzt"].ToString() == "申报") // { // str_sql = " exec 查询教师参加项目数量 '" + dt.Rows[i]["cyjsh"].ToString() + "'"; // } // else if (dt.Rows[i]["xmzt"].ToString() == "在研") // { // str_sql = " exec 立项后查询教师参加项目数量 '" + dt.Rows[i]["cyjsh"].ToString() + "'"; // } // dt1 = DBFun.dataTable(str_sql); // if (dt1 != null) // { // if (Convert.ToInt16(dt1.Rows[0]["num"]) > 2) // { // str_name += " [ " + dt.Rows[i]["sqr"].ToString() + " ] "; // } // } // } // if (str_name != "") // { // lbl_cjxm.Text = str_name + "已经参加了两个项目,不能再参加您的项目了!"; // Response.Write("<script>alert('" + lbl_cjxm.Text + "');</script>"); // return; // } //} //判断所需字段是否填写内容 str_sql = " select email,ktmc,sqr,sqbm,lxdh,sqrq,zyfx,lxyjmb_1,lxyjmb_2,lxyjmb_3,lxyjmb_4,lxyjmb_5,yjffjj_1,yjffjj_2 from t_teacher_list " + " where appNo = '" + Session["appNo"].ToString() + "'"; dt = DBFun.dataTable(str_sql); string str_BlankColumn; for (int i = 0; i < dt.Columns.Count; i++) { if (dt.Rows[0][i].ToString() == "") { //获取数据列描述信息 str_BlankColumn = SqlBackObject.GetColumnDescription("t_teacher_list", dt.Columns[i].ColumnName); Response.Write("<script>alert('[" + str_BlankColumn + "] 数据尚未填写!');</script>"); return; } } //提交项目成员信息 CommitInfoxmcy(); str_sql = "update t_teacher_list set Status = 2 where appNo = '" + Session["appNo"].ToString() + "'"; if (DBFun.ExecuteUpdate(str_sql)) { Session.RemoveAll(); Response.Write("<script>alert('提交成功!');location.href = 'default.aspx';</script>"); } else { Response.Write("<script>alert('提交失败!');</script>"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["jsh"] == null) { Response.Redirect("../SessionTimeOut.aspx?type=top"); } if (!IsPostBack) { DataTable dt; string str_type = Request.QueryString["type"]; if (str_type == "0") { lbl_title.Text = "盲审专家建议"; str_sql = " select jypj " + " from t_zjry0 " + " where appNo='" + Session["appNo"].ToString() + "' " + " order by zjNo "; dt = DBFun.dataTable(str_sql); if (dt == null) { return; } string str_yjpj; for (int i = 0; i < dt.Rows.Count; i++) { str_yjpj = dt.Rows[i]["jypj"].ToString().Replace("'", "‘"); if (str_yjpj == "") { str_yjpj = "无"; } lbl_content.Text += "评委" + Convert.ToString(i + 1) + ":<br/>" + str_yjpj + "<br/><br/>"; } } else if (str_type == "1") { lbl_title.Text = "立项专家建议"; str_sql = " select jypj " + " from t_zjry1 " + " where appNo='" + Session["appNo"].ToString() + "' " + " order by zjNo "; dt = DBFun.dataTable(str_sql); if (dt == null) { return; } string str_yjpj; for (int i = 0; i < dt.Rows.Count; i++) { str_yjpj = dt.Rows[i]["jypj"].ToString().Replace("'", "‘"); if (str_yjpj == "") { str_yjpj = "无"; } lbl_content.Text += "评委" + Convert.ToString(i + 1) + ":<br/>" + str_yjpj + "<br/><br/>"; } } else if (str_type == "2") { lbl_title.Text = "中期专家建议"; str_sql = " select jypj " + " from t_zjry2 " + " where appNo='" + Session["appNo"].ToString() + "' " + " order by zjNo "; dt = DBFun.dataTable(str_sql); if (dt == null) { return; } string str_yjpj; for (int i = 0; i < dt.Rows.Count; i++) { str_yjpj = dt.Rows[i]["jypj"].ToString().Replace("'", "‘"); if (str_yjpj == "") { str_yjpj = "无"; } lbl_content.Text += "评委" + Convert.ToString(i + 1) + ":<br/>" + str_yjpj + "<br/><br/>"; } } else if (str_type == "3") { lbl_title.Text = "结题专家建议"; str_sql = " select jypj " + " from t_zjry3 " + " where appNo='" + Session["appNo"].ToString() + "' " + " order by zjNo "; dt = DBFun.dataTable(str_sql); if (dt == null) { return; } string str_yjpj; for (int i = 0; i < dt.Rows.Count; i++) { str_yjpj = dt.Rows[i]["jypj"].ToString().Replace("'", "‘"); if (str_yjpj == "") { str_yjpj = "无"; } lbl_content.Text += "评委" + Convert.ToString(i + 1) + ":<br/>" + str_yjpj + "<br/><br/>"; } } if (lbl_content.Text == "") { lbl_content.Text = "无"; } } }