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 = "无";
}
}
}
