private void bindData()
{
string strqry = "SELECT ID,sfzh, yourname,xingbie, " +
"iif(DateDiff('YYYY', CDate(iif(isnull(birth),now,iif(birth='',now(),birth))),Format(Now(),'yyyy-mm-dd'))=0,'',DateDiff('YYYY', CDate(iif(isnull(birth),now,iif(birth='',now(),birth))),Format(Now(),'yyyy-mm-dd'))) AS nianling," +
"xrgw, gwxl, iif(isnull(tj_flag),'未审核',tj_flag) as tuijian,edit_flag,fenlei FROM ej_cpry where dw = '" + Session["admin_id"].ToString() + "' ";
if (RadioButtonList1.SelectedValue != "all")
{
strqry = strqry + " and iif(isnull(tj_flag),'未审核',tj_flag) = '" + RadioButtonList1.SelectedValue + "'";
}
strqry = strqry + " ORDER BY ID;";
Session["dv_detail"] = DBFun.GetDataView(strqry);
DataView dv = (DataView)Session["dv_detail"];
GridView1.DataSource = dv;
GridView1.DataBind();
string str_sfzh;
RadioButtonList rbtnList_1;
for (int i = 0; i < this.GridView1.Rows.Count; i++)
{
str_sfzh = dv.Table.Rows[i + GridView1.PageIndex * GridView1.PageSize]["sfzh"].ToString();
rbtnList_1 = (RadioButtonList)this.GridView1.Rows[i].FindControl("rbtnList_xg");
rbtnList_1.SelectedValue = dv.Table.Rows[i + GridView1.PageIndex * GridView1.PageSize]["edit_flag"].ToString();
}
//strqry = " SELECT iif(isnull(csgz),'未填写',csgz), count(csgz) AS num " +
// " FROM cpry " +
// " WHERE gzdw = '" + Session["admin_id"].ToString() + "'";
//if (RadioButtonList1.SelectedValue != "all") strqry += " and iif(isnull(tj_flag),'未审核',tj_flag) = '" + RadioButtonList1.SelectedValue + "'";
//strqry += " GROUP BY csgz;";
//OleDbDataReader reader = DBFun.dataReader(strqry);
//lbl_tongji.Text = "";
//if (reader != null)
//{
// try
// {
// while (reader.Read())
// {
// lbl_tongji.Text = lbl_tongji.Text + reader.GetString(0).ToString() + ":" + reader.GetInt32(1).ToString() + "<br/>";
// }
// }
// catch { }
//}
//DBFun.closeDataReader(ref reader);
}
protected void bindData()
{
//str_sql = " SELECT a.appNo,a.jsh, appyear, a.ktmc, a.sqbm, a.sqr, xmzt,edit_flag, iif(edit_flag,'否','是') as tj, c.tj_flag AS bmtj " +
// " FROM t_teacher_list as a, t_teacher as b, t_dict as c "+
// " WHERE a.jsh = b.jsh and a.sqbm = c.name and flm=13 and not edit_flag and sh1 and c.tj_flag ";
str_sql = "SELECT appNo, a.ktmc, Status,a.sqbm, a.sqr,c.name as xmzt," +
" cGroup1, a.id, pm, a.xmbh, zzlb, " +
" mid(appNo,5) as jsh, " +
" left(appNo,4) as appYear " +
"FROM t_teacher_list a,t_teacher b, t_dict c " +
"WHERE mid(a.appNo,5) = b.jsh and flm=11 and status = bm " +
//" and left(appNo,4) = year(date()) " +
//" and a.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_year.SelectedValue != "")
{
str_sql += " and ( left(appNo,4) = " + ddlist_year.SelectedValue + ") ";
}
if (ddlist_xmzt0.SelectedIndex != 0)
{
str_sql += " and ( Status = " + ddlist_xmzt0.SelectedValue + ") ";
}
if (ddlist_sqbm.SelectedIndex != 0)
{
str_sql += " and ( a.sqbm = '" + ddlist_sqbm.SelectedValue + "') ";
}
if (tbx_spm.Text.Trim() != "")
{
str_sql += " and (( spm LIKE '%" + tbx_spm.Text.Trim() + "%') " +
" or ( a.sqr LIKE '%" + tbx_spm.Text.Trim() + "%') " +
" or ( mid(appNo,5) LIKE '%" + tbx_spm.Text.Trim() + "%')) ";
}
str_sql += " order by sqbm,sqr";
ViewState["sql"] = str_sql;
dv = DBFun.GetDataView(str_sql);
PagedDataSource pds = new PagedDataSource();
pds.AllowPaging = true;
pds.PageSize = AspNetPager1.PageSize;
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
pds.DataSource = dv;
GridView1.DataSource = pds;
GridView1.DataBind();
AspNetPager1.RecordCount = dv.Table.Rows.Count;
TD_AddUser.Visible = false;
}
protected void bindData()
{
string str_sql = "select * from t_pszj where appyear=year(date()) ";
DataView dv = DBFun.GetDataView(str_sql);
GridView1.DataSource = dv;
GridView1.DataBind();
Session["dv_detail"] = dv;
CommFun.Add_ConfirmAttrib(GridView1, "lbtn_del");
RadioButtonList rbl_fnd;
for (int i = 0; i < this.GridView1.Rows.Count; i++)
{
rbl_fnd = (RadioButtonList)this.GridView1.Rows[i].FindControl("rbl_tj");
rbl_fnd.SelectedValue = dv.Table.Rows[i + GridView1.PageIndex * GridView1.PageSize]["tj_flag"].ToString();
}
}
protected void btn_Ok_Click(object sender, EventArgs e)
{
//操作
string strOpid = "";
string strsql;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox ckb = (CheckBox)GridView1.Rows[i].FindControl("sle");
string id = GridView1.Rows[i].Cells[0].Text;
if (ckb.Checked)
{
if (strOpid == "")
{
strOpid += ("(" + id);
}
else
{
strOpid += ("," + id);
}
}
}
strOpid += ")";
if (strOpid == ")")
{
Response.Write("<script>alert('没有选中任何记录！');history.go(-1);</script>");
}
else
{
if (dw_Operation.Text == "0")
{
//删除
strsql = string.Format("delete from T_films where id in {0}", strOpid);
if (DBFun.ExecuteUpdate(strsql))
{
strsql = string.Format("Delete From T_film_Detail where filmid in {0}", strOpid);
DBFun.ExecuteSql(strsql); //删除实际文件路径
ltl_Msg.Text = "删除成功！";
dvlist = DBFun.GetDataView(Session["strqry"].ToString());
AspNetPager1.RecordCount = dvlist.Table.Rows.Count;
Cache["dvlist"] = dvlist;
bindData();
}
}
}
}
protected void btn_commit_Click(object sender, EventArgs e)
{
str_sql = ViewState["sql"].ToString();
dv = DBFun.GetDataView(str_sql);
string str_appNo;
bool b_vote;
RadioButtonList rbl_find;
for (int i = 0; i < dv.Table.Rows.Count; i++)
{
str_appNo = dv.Table.Rows[i]["appNo"].ToString();
rbl_find = (RadioButtonList)GridView1.Rows[i].FindControl("rbl_vote");
b_vote = Convert.ToBoolean(rbl_find.SelectedValue);
str_sql = "update t_zjry2 set sftj = " + b_vote + " where appNo = '" + str_appNo + "' and zjNO = '" + Session["admin_id"].ToString() + "'";
if (!DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('保存失败！');</script>");
return;
}
}
//str_sql = " SELECT count(*) "
// + " FROM t_teacher_list a,t_zjry2 b"
// + " WHERE a.appNo = b.appNo"
// + " AND left(a.appNo,4)= year(date()) "
// + " and zjNo ='" + Session["admin_id"].ToString() + "'"
// + " and fs_pjys_sum is null";
//if (Convert.ToInt16( DBFun.ExecuteScalar(str_sql)) > 0)
//{
// Response.Write("<script>alert('您还有尚未评分的项目，请对所有项目评分后再提交！');</script>");
// return;
//}
str_sql = " update t_ExpertList2 set tj_flag = true "
+ " where appyear= year(date()) "
+ " and LoginName = '" + Session["admin_id"].ToString() + "'";
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('提交成功！');location.replace(location.href);</script>");
}
else
{
Response.Write("<script>alert('提交失败！');</script>");
return;
}
}
protected void GridViewEdit(int RowIndex)
{
imgbtn_save.ImageUrl = "./img/save.gif";
if (Table3.Visible)
{
str_sql = ViewState["sql3"].ToString();
dv = DBFun.GetDataView(str_sql);
lbl_id.Text = dv.Table.Rows[RowIndex]["id"].ToString();
tbx3_rksj.Focus();
tbx3_rksj.Text = dv.Table.Rows[RowIndex]["rksj"].ToString();
tbx3_kcmc.Text = dv.Table.Rows[RowIndex]["kcmc"].ToString();
tbx3_skdx.Text = dv.Table.Rows[RowIndex]["skdx"].ToString();
tbx3_xs.Text = dv.Table.Rows[RowIndex]["xs"].ToString();
tbx3_szdw.Text = dv.Table.Rows[RowIndex]["szdw"].ToString();
//try { ddlist3_zccy.SelectedValue = dv.Table.Rows[RowIndex]["zccy"].ToString(); }
//catch { }
//try { ddlist3_sfjt.SelectedValue = dv.Table.Rows[RowIndex]["sfjt"].ToString(); }
//catch { }
}
else if (Table4.Visible)
{
str_sql = ViewState["sql4"].ToString();
dv = DBFun.GetDataView(str_sql);
lbl_id.Text = dv.Table.Rows[RowIndex]["id"].ToString();
tbx4_qzsj.Focus();
tbx4_qzsj.Text = dv.Table.Rows[RowIndex]["qzsj"].ToString();
tbx4_xmmc.Text = dv.Table.Rows[RowIndex]["xmmc"].ToString();
tbx4_lxdw.Text = dv.Table.Rows[RowIndex]["lxdw"].ToString();
tbx4_hjqk.Text = dv.Table.Rows[RowIndex]["hjqk"].ToString();
}
else if (Table5.Visible)
{
str_sql = ViewState["sql5"].ToString();
dv = DBFun.GetDataView(str_sql);
lbl_id.Text = dv.Table.Rows[RowIndex]["id"].ToString();
tbx5_xm.Focus();
tbx5_jsh.Text = dv.Table.Rows[RowIndex]["cyjsh"].ToString();
tbx5_xm.Text = dv.Table.Rows[RowIndex]["xm"].ToString();
tbx5_zc.Text = dv.Table.Rows[RowIndex]["zc"].ToString();
tbx5_zy.Text = dv.Table.Rows[RowIndex]["zy"].ToString();
tbx5_fg.Text = dv.Table.Rows[RowIndex]["fg"].ToString();
try { ddlist5_xw.SelectedValue = dv.Table.Rows[RowIndex]["xw"].ToString(); }
catch { }
}
}
private void bindData()
{
string strqry = "SELECT ID,sfzh, yourname,name, " +
" cplb,lw_ctitle,ejxk_mc,zdjs_xm,edit_flag,sh_flag" +
" FROM yxxwlw_cpry,t_dict" +
" where url = tjdw and t_dict.tj_flag = true and edit_flag = false and yxxwlw_cpry.tj_flag = '推荐' ";
if (RadioButtonList1.SelectedValue != "all")
{
strqry = strqry + " and sh_flag = '" + RadioButtonList1.SelectedValue + "'";
}
strqry = strqry + " ORDER BY name asc , ID asc;";
Session["dv_detail"] = DBFun.GetDataView(strqry);
DataView dv = (DataView)Session["dv_detail"];
GridView1.DataSource = dv;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string strqry = "select url From t_dict where flm=8 and bm=11";
if (Convert.ToDateTime(DBFun.ExecuteScalar(strqry)) <= DateTime.Now)
{
Response.Write(@"<script>alert('评审截止日期已到！');window.history.go(-1);</script>");
return;
}
string str_sql;
str_sql = "SELECT top 10 hot,leixing,id,iif(len(title)>23,left(title,22)+'…',title)+'('+format(shijian,'mm-dd')+')' as biaoti FROM news where leibie = '新闻' and leixing='2' order by shijian asc,id asc";
DataView dv = DBFun.GetDataView(str_sql);
GV_news.DataSource = dv;
GV_news.DataBind();
Session["dv_news"] = dv;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
CommFun.IsAdmin();
string strqry = "select * From T_HotSearch order by scount desc";
GridView1.DataSource = DBFun.GetDataView(strqry);
GridView1.DataBind();
}
catch (Exception ex)
{
Response.Write("执行时出错！" + ex.Message);
}
}
}
protected void CommitInfoxmcy()
{
str_sql = "exec Q_Para_Cyqk_By_appNo '" + Session["appNo"].ToString() + "'";
dv = DBFun.GetDataView(str_sql);
if (dv == null || dv.Table.Rows.Count == 0)
{
return;
}
string str_xmcy = "";
for (int i = 0; i < dv.Table.Rows.Count; i++)
{
str_xmcy += "," + dv.Table.Rows[i]["xm"].ToString();
}
str_sql = "update t_teacher_list set xmcy = '" + str_xmcy.Substring(1) + "' where appNo = '" + Session["appNo"].ToString() + "'";
DBFun.ExecuteSql(str_sql);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["admin_name"] == null)
{
Response.Redirect("../SessionTimeOut.aspx?type=top");
}
if (!CommFun.IsAdmin(Session["admin_name"].ToString()))
{
Response.Redirect("../SessionTimeOut.aspx?type=isnotadmin");
}
if (!IsPostBack)
{
DataView dv = DBFun.GetDataView("select * from master;");
GridView1.DataSource = dv;
GridView1.DataBind();
Session["dv_detail"] = dv;
}
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
str_sql = ViewState["sql"].ToString();
dv = DBFun.GetDataView(str_sql);
int i_rownum = e.NewEditIndex + (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize;
string str_xmbh = dv.Table.Rows[i_rownum]["xmbh"].ToString();
str_sql = "select * from t_jf where xmbh = '" + str_xmbh + "'";
ViewState["sql1"] = str_sql;
ViewState["xmbh"] = str_xmbh;
//使选中行颜色与其他行颜色不同
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridView1.Rows[i].BackColor = System.Drawing.Color.White;
}
GridView1.Rows[e.NewEditIndex].BackColor = System.Drawing.Color.RosyBrown;
bindData1();
}
protected void btn_Hand_Click(object sender, EventArgs e)
{
string strOpid = "";
string strsql;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox ckb = (CheckBox)GridView1.Rows[i].FindControl("cbx_select");
string id = GridView1.Rows[i].Cells[1].Text;
if (ckb.Checked)
{
if (strOpid == "")
{
strOpid += ("('" + id);
}
else
{
strOpid += ("','" + id);
}
}
}
strOpid += "')";
if (strOpid == "')")
{
Response.Write("<script>alert('没有选中任何记录！');history.go(-1);</script>");
return;
}
else
{
for (int i = 0; i < GridView1.Rows.Count; i++)
{
str_sql = ViewState["sql"].ToString();
dv = DBFun.GetDataView(str_sql);
str_sql = string.Format("update t_ExpertList3 set tj_flag = " + true + " where appyear=year(date()) and LoginName in {0}", strOpid);
if (DBFun.ExecuteUpdate(str_sql))
{
bindData();
}
}
Response.Write("<script>alert('修改成功！');</script>");
bindData();
}
}
protected void bindData()
{
str_sql = "select a.LoginName,UserName,szbm,zc,zy,jb,tj_flag,cGroup from t_Expert as a,t_ExpertList3 as b " +
" where a.LoginName=b.LoginName and appyear=year(date()) ";
if (ddlist_Group.SelectedIndex != 0)
{
str_sql += " and cGroup = '" + ddlist_Group.SelectedValue + "'";
}
if (ddlist_type.SelectedIndex != 0)
{
str_sql += " and " + ddlist_type.SelectedValue + " like '%" + tbx_search.Text.Trim() + "%'";
}
str_sql += " order by a.LoginName";
ViewState["sql"] = str_sql;
dv = DBFun.GetDataView(str_sql);
PagedDataSource pds = new PagedDataSource();
pds.AllowPaging = true;
pds.PageSize = AspNetPager1.PageSize;
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
pds.DataSource = dv;
GridView1.DataSource = pds;
GridView1.DataBind();
AspNetPager1.RecordCount = dv.Table.Rows.Count;
//CommFun.Add_ConfirmAttrib(GridView1, "lbtn_del");
CheckBox cbx_fnd;
Label lbl;
for (int i = 0; i < this.GridView1.Rows.Count; i++)
{
lbl = (Label)this.GridView1.Rows[i].FindControl("lbl_Flag");
if ((bool)dv.Table.Rows[i + GridView1.PageIndex * GridView1.PageSize]["tj_flag"])
{
lbl.Text = "已提交";
lbl.ForeColor = System.Drawing.Color.Green;
}
else
{
lbl.Text = "未提交";
lbl.ForeColor = System.Drawing.Color.Red;
}
}
}
protected void bindData()
{
str_sql = " select appNo,sqr,ktmc ,iif(zjtp0_1,'是','否') as tp1," +
" iif(zjtp0_2,'是','否') as tp2," +
" iif(zjtp0_3,'是','否') as tp3," +
" iif(zjtp0_4,'是','否') as tp4," +
" iif(zjtp0_5,'是','否') as tp5," +
" pm0,ps0,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_year.SelectedValue != "")
{
str_sql += " and ( left(appNo,4) = " + ddlist_year.SelectedValue + ") ";
}
if (ddlist_xmzt0.SelectedIndex != 0)
{
str_sql += " and ( Status = " + ddlist_xmzt0.SelectedValue + ") ";
}
if (ddlist_cGroup.SelectedIndex != 0)
{
str_sql += " and ( cGroup0 = '" + ddlist_cGroup.SelectedValue + "') ";
}
if (tbx_spm.Text.Trim() != "")
{
str_sql += " and (( spm LIKE '%" + tbx_spm.Text.Trim() + "%') " +
" or ( sqr LIKE '%" + tbx_spm.Text.Trim() + "%') " +
" or ( mid(appNo,5) LIKE '%" + tbx_spm.Text.Trim() + "%')) ";
}
str_sql += " order by sqbm,sqr ";
ViewState["sql"] = str_sql;
dv = DBFun.GetDataView(str_sql);
PagedDataSource pds = new PagedDataSource();
pds.AllowPaging = true;
pds.PageSize = AspNetPager1.PageSize;
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
pds.DataSource = dv;
GridView1.DataSource = pds;
GridView1.DataBind();
AspNetPager1.RecordCount = dv.Table.Rows.Count;
}
protected void btn_calc_Click(object sender, EventArgs e)
{
string str_sql = "alter table cpry add column score_xmrw numeric,score_lzbg numeric,score_yjcg numeric";
try { DBFun.ExecuteSql(str_sql); }
catch { }
str_sql = "select sfzh,sbzw from cpry,t_dict " +
"where url=gzdw and edit_flag=false and cpry.tj_flag='推荐' and sh_flag='通过' and t_dict.tj_flag=true order by gzdw asc, ID asc;";
DataView dv = DBFun.dataView(str_sql);
DataView dv_zj;
for (int i = 0; i < dv.Table.Rows.Count; i++)
{
Session["sfzh"] = dv.Table.Rows[i]["sfzh"].ToString();
string str_score = "";
if (dv.Table.Rows[i]["sbzw"].ToString() == "研究员")
{
str_score = GetScore_yjy();
}
else
{
str_score = GetScore_gg();
}
string str_s1, str_s2, str_s3, str_s4;
str_s1 = str_score.Substring(0, str_score.IndexOf(","));
str_s2 = str_score.Substring(str_score.IndexOf(",") + 1, str_score.LastIndexOf(",") - str_score.IndexOf(",") - 1);
str_s3 = str_score.Substring(str_score.LastIndexOf(",") + 1);
//计算专家评分
string strqry = "select iif(isnull(fs_pjys_sum),'0',fs_pjys_sum) as fs_sum,zj_sfzh,cpry_sfzh,jypj,UserName,zjdm,iif(isnull(fs_pjys_sum),'否','是') as sfpj from zjry,pszj where sfzh = zj_sfzh and pszj.flag = 1 ";
strqry = strqry + " and cpry_sfzh = '" + dv.Table.Rows[i]["sfzh"].ToString() + "'";
dv_zj = DBFun.GetDataView(strqry);
str_s4 = PrivateFun.Get_Score_zj(dv_zj);
str_sql = "update cpry set score_xmrw = " + str_s1 + ",score_lzbg=" + str_s2 + ",score_yjcg=" + str_s3 + ",score_zj=" + str_s4 + " where sfzh = '" + Session["sfzh"].ToString() + "';";
if (!DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('计算分数失败，请重新计算！');</script>");
return;
}
}
Response.Write("<script>alert('计算分数成功！');</script>");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
CommFun.IsAdmin();
DBFun.FillDwList(dw_class, "select ID,caption From T_Class");
string strqry = "select * From T_IndexPage";
GridView1.DataSource = DBFun.GetDataView(strqry);
GridView1.DataBind();
}
catch (Exception ex)
{
Response.Write("执行时出错！" + ex.Message);
}
}
}
private void bindData()
{
string strqry = "SELECT ID,sfzh, yourname,xingbie, DateDiff('YYYY', CDate(birth),Format(Now(),'yyyy-mm-dd')) AS nianling, xrzw, sbzw, tj_flag,edit_flag,fenlei FROM cpry where edit_flag = false and gzdw = '" + Session["admin_id"].ToString() + "' ";
if (Session["admin_type"].ToString() == "zhuanjia")
{
strqry = "SELECT cpry.id,cpry.sfzh ,yourname,xingbie, DateDiff('YYYY', CDate(birth),Format(Now(),'yyyy-mm-dd')) AS nianling,xrzw,sbzw,tj_flag from cpry,zjry where edit_flag = false and zjid = " + Session["admin_id"].ToString() + " and cpry.sfzh=zjry.sfzh";
}
if (RadioButtonList1.SelectedValue != "all")
{
strqry = strqry + " and tj_flag = '" + RadioButtonList1.SelectedValue + "'";
}
strqry = strqry + " ORDER BY ID;";
DataView dv = DBFun.GetDataView(strqry);//dv null 为什么
Session["dv_detail"] = dv;
GridView1.DataSource = dv;
GridView1.DataBind();
//for (int i = 0; i < GridView1.Rows.Count; i++)
//{
// CheckBox ckb = (CheckBox)GridView1.Rows[i].FindControl("ckb_Sle");
// ckb.Checked = Convert.ToBoolean(dv.Table.Rows[i + GridView1.PageIndex * GridView1.PageSize]["edit_flag"].ToString());
//}
strqry = " SELECT csgz, count(csgz) AS num " +
" FROM cpry " +
" WHERE gzdw = '" + Session["admin_id"].ToString() + "' ";
if (RadioButtonList1.SelectedValue != "all")
{
strqry += " and tj_flag = '" + RadioButtonList1.SelectedValue + "'";
}
strqry += " GROUP BY csgz;";
OleDbDataReader reader = DBFun.dataReader(strqry);
lbl_tongji.Text = "";
while (reader.Read())
{
lbl_tongji.Text = lbl_tongji.Text + reader.GetString(0).ToString() + ":" + reader.GetInt32(1).ToString() + "<br/>";
}
DBFun.closeDataReader(ref reader);
}
protected void btn_expAllInfo_Click(object sender, EventArgs e)
{
HttpResponse resp;
resp = Page.Response;
resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
resp.AppendHeader("Content-Disposition", "attachment;filename=1.xls");
string colHeaders = "";
string str_sql = "select sfzh from yxxwlw_cpry where sh_flag='通过' and edit_flag = false and tj_flag='推荐' order by tjdw asc, ID asc";
DataView dv = DBFun.GetDataView(str_sql);
for (int i = 0; i < dv.Table.Rows.Count; i++)
{
colHeaders += GetPersonInfo(dv.Table.Rows[i]["sfzh"].ToString()) + "\n\n";
}
resp.Write(colHeaders);
//写缓冲区中的数据到HTTP头文件中
resp.End();
}
/// <summary>
/// 填充GridView FillGridView
/// </summary>
/// <param name="str_sql">得到数据的SQL语句</param>
/// <param name="gv_bind">要绑定的Gridview</param>
/// <param name="b_lbtn"> 是否包含删除按钮</param>
/// <returns>包含数据的DataView</returns>
#region 填充GridView
public static DataView FillGridView(string str_sql, GridView gv_bind, bool b_lbtn)
{
DataView dv = DBFun.GetDataView(str_sql);
gv_bind.DataSource = dv;
gv_bind.DataBind();
if (b_lbtn && dv != null)
{
LinkButton lbtn;
for (int i = 0; i < gv_bind.Rows.Count; i++)//dv.Table
{
lbtn = (LinkButton)gv_bind.Rows[i].FindControl("lbtn_del");
if (lbtn != null)
{
lbtn.Attributes.Add("onclick", "return confirm (\"确定要删除吗？\");");
}
}
}
return(dv);
}
protected void bindData_zj()
{
string str_sql = "select zjid,ryid from zjry where ryid = " + lbl_zjid.Text;
OleDbDataReader reader = DBFun.dataReader(str_sql);
string str_zjid = "0,";
while (reader.Read())
{
str_zjid = str_zjid + reader["zjid"].ToString() + ",";
}
DBFun.closeDataReader(ref reader);
str_sql = "";
str_sql = str_sql + " where id in (" + str_zjid + ") ORDER BY ID;";
Session["dv_zhuanjia"] = DBFun.GetDataView(str_sql);
DataView dv = (DataView)Session["dv_zhuanjia"];
gv_zhuanjia.DataSource = dv;
gv_zhuanjia.DataBind();
gv_zhuanjia.Visible = true;
}
protected void NewRow()
{
str_sql = ViewState["sql1"].ToString();
dv = DBFun.GetDataView(str_sql);
DataRow dr = dv.Table.NewRow();
dr["je"] = 0;
dr["rq"] = string.Format(DateTime.Today.ToString(), "yyyy-MM-dd");
dv.Table.Rows.Add(dr);
PagedDataSource pds = new PagedDataSource();
pds.AllowPaging = true;
pds.PageSize = AspNetPager2.PageSize;
pds.CurrentPageIndex = AspNetPager2.CurrentPageIndex - 1;
pds.DataSource = dv;
GridView2.DataSource = pds;
GridView2.DataKeyNames = new string[] { "ID" };
GridView2.DataBind();
AspNetPager2.RecordCount = dv.Table.Rows.Count;
}
protected void btn_confirm1_Click(object sender, EventArgs e)
{
string str_pwd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(tbx_pwd_new.Text, "MD5");
string str_sql = string.Format("Insert Into Master (admin_name,Username,admin_pwd,flag) Values ('{0}','{1}','{2}',{3})",
tbx_admin_name.Text.Trim(), tbx_user_name.Text.Trim(), str_pwd, 1);
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('用户添加成功！');</script>");
DataView dv = DBFun.GetDataView("select * from master;");
GridView1.DataSource = dv;
GridView1.DataBind();
Session["dv_detail"] = dv;
TD_AddUser.Visible = false;
}
else
{
Response.Write("<script>alert('用户添加失败！');</script>");
}
}
private void bindData()
{
string strqry = "exec Q_Para_CommitList_By_sqbm '" + Session["dept_name"].ToString() + "' ";
Session["dv_detail"] = DBFun.GetDataView(strqry);
DataView dv = (DataView)Session["dv_detail"];
GridView1.DataSource = dv;
GridView1.DataBind();
string str_sfzh;
RadioButtonList rbtnList_1;
for (int i = 0; i < this.GridView1.Rows.Count; i++)
{
str_sfzh = dv.Table.Rows[i + GridView1.PageIndex * GridView1.PageSize]["jsh"].ToString();
rbtnList_1 = (RadioButtonList)this.GridView1.Rows[i].FindControl("rbtnList_xg");
rbtnList_1.SelectedValue = dv.Table.Rows[i + GridView1.PageIndex * GridView1.PageSize]["edit_flag"].ToString();
}
}
//参评组 数据绑定 传入参数 参评组ID
protected void bindData_cpry(string str_cpzid)
{
//string str_sql = "select zjid,ryid from zjry where zjid = " + lbl_zjid.Text;
//OleDbDataReader reader = DBFun.dataReader(str_sql);
//string str_ryid = "0,";
//while (reader.Read())
//{
// str_ryid = str_ryid + reader["ryid"].ToString() + ",";
//}
//DBFun.closeDataReader(ref reader);
string str_sql = "SELECT ID,sfzh, yourname,xingbie, " +
"iif(DateDiff('YYYY', CDate(iif(isnull(birth),now,birth)),Format(Now(),'yyyy-mm-dd'))=0,'',DateDiff('YYYY', CDate(iif(isnull(birth),now,birth)),Format(Now(),'yyyy-mm-dd'))) AS nianling, " +
"xrzw, sbzw, sh_flag,edit_flag,fenlei FROM cpry ";
str_sql = str_sql + " where fenlei = '" + str_cpzid + "';";
Session["dv_cpry"] = DBFun.GetDataView(str_sql);
DataView dv = (DataView)Session["dv_cpry"];
gv_chengyuan.DataSource = dv;
gv_chengyuan.DataBind();
}
protected void bindData()
{
string str_sql = "exec Q_Para_CommitList_By_sqbm '" + Session["dept_name"].ToString() + "'";
dv = DBFun.GetDataView(str_sql);
GridView1.DataSource = dv;
GridView1.DataBind();
Session["dv_detail"] = dv;
CommFun.Add_ConfirmAttrib(GridView1, "lbtn_del");
str_sql = "select InitPwd from t_dict where flm = 1 and url = '" + Session["dept_id"].ToString() + "'";
if (DBFun.ExecuteScalar(str_sql) == null)
{
tbx_InitPwd.Text = "";
}
else
{
tbx_InitPwd.Text = DBFun.ExecuteScalar(str_sql).ToString();
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
str_sql = ViewState["sql"].ToString();
dv = DBFun.GetDataView(str_sql);
CheckBox ckb;
ckb = (CheckBox)this.GridView1.Rows[e.RowIndex].FindControl("cbx_HandOn");
if (ckb.Checked)
{
str_sql = "update t_ExpertList3 set tj_flag = " + true + " where appyear=year(date()) and LoginName = '" + dv.Table.Rows[e.RowIndex + GridView1.PageIndex * GridView1.PageSize]["LoginName"].ToString() + "'";
}
else
{
str_sql = "update t_ExpertList3 set tj_flag = " + false + " where appyear=year(date()) and LoginName = '" + dv.Table.Rows[e.RowIndex + GridView1.PageIndex * GridView1.PageSize]["LoginName"].ToString() + "'";
}
if (DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('修改成功！');</script>");
bindData();
}
}
protected void bindData()
{
str_sql = " SELECT appNo, a.ktmc, a.sqbm, a.sqr,c.name AS xmzt," +
" mid(appNo,5) as jsh, left(appNo,4) as appyear," +
" cGroup1, a.id, pm, a.xmbh, zzlb " +
" FROM t_teacher_list AS a, t_teacher AS b ,t_dict c " +
" WHERE mid(a.appNo,5) = b.jsh and flm=11 and status = bm " +
" and left(a.appNo,4) =year(date()) " +
//" and a.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 = 5)";
if (ddlist_Group.SelectedIndex != 0)
{
str_sql += " and cGroup1 = '" + ddlist_Group.SelectedValue + "' ";
}
if (ddlist_type.SelectedIndex != 0)
{
str_sql += " and " + ddlist_type.SelectedValue + " like '%" + tbx_search.Text.Trim() + "%' ";
}
if (rbl_order.SelectedIndex == 0)
{
str_sql += " order by cGroup1,pm";
}
else
{
str_sql += " order by sqbm,sqr";
}
dv = DBFun.GetDataView(str_sql);
ViewState["sql"] = str_sql;
PagedDataSource pds = new PagedDataSource();
pds.AllowPaging = true;
pds.PageSize = AspNetPager1.PageSize;
AspNetPager1.PageSize = Convert.ToInt16(ddl_PageSize.SelectedValue);
pds.PageSize = Convert.ToInt16(ddl_PageSize.SelectedValue);
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
pds.DataSource = dv;
GridView1.DataSource = pds;
GridView1.DataBind();
AspNetPager1.RecordCount = dv.Table.Rows.Count;
}
private void bindData()
{
string strqry = "SELECT ID,sfzh, yourname,xingbie, " +
" iif(DateDiff('YYYY', CDate(iif(isnull(birth),now,birth)),Format(Now(),'yyyy-mm-dd'))=0,'',DateDiff('YYYY', CDate(iif(isnull(birth),now,birth)),Format(Now(),'yyyy-mm-dd'))) AS nianling," +
" xrgw, gwxl, sh_flag,edit_flag,fenlei,ej_cpry.tj_flag,t_dict.ej_tj_flag,t_dict.name as gzdw FROM ej_cpry,t_dict" +
" where url = dw and t_dict.ej_tj_flag = true and edit_flag = false and ej_cpry.tj_flag = '推荐' ";
if (RadioButtonList1.SelectedValue != "all")
{
strqry = strqry + " and sh_flag = '" + RadioButtonList1.SelectedValue + "'";
}
strqry = strqry + " ORDER BY dw asc , ID asc;";
Session["dv_detail"] = DBFun.GetDataView(strqry);
DataView dv = (DataView)Session["dv_detail"];
GridView1.DataSource = dv;
GridView1.DataBind();
//for (int i = 0; i < GridView1.Rows.Count; i++)
//{
// CheckBox ckb = (CheckBox)GridView1.Rows[i].FindControl("ckb_Sle");
// ckb.Checked = Convert.ToBoolean(dv.Table.Rows[i + GridView1.PageIndex * GridView1.PageSize]["edit_flag"].ToString());
//}
//strqry = " select gz,count(gz) as num from " +
// " (SELECT iif(isnull(csgz),'未填写',csgz) as gz" +
// " FROM cpry ,t_dict" +
// " WHERE url = gzdw and t_dict.tj_flag = true and edit_flag = false and cpry.tj_flag = '推荐'";
//if (RadioButtonList1.SelectedValue != "all")
// strqry = strqry + " and sh_flag = '" + RadioButtonList1.SelectedValue + "'";
//strqry = strqry + ") group by gz";
//OleDbDataReader reader = DBFun.dataReader(strqry);
//lbl_tongji.Text = "";
//while (reader.Read())
//{
// lbl_tongji.Text = lbl_tongji.Text + reader.GetString(0).ToString() + ":" + reader.GetInt32(1).ToString() + "<br/>";
//}
//DBFun.closeDataReader(ref reader);
}
protected void btn_Ok_Click(object sender, EventArgs e)
{
string strOpid = "";
string strsql;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox ckb = (CheckBox)GridView1.Rows[i].FindControl("ckb_Sle");
string id = GridView1.Rows[i].Cells[0].Text;
if (ckb.Checked)
{
if (strOpid == "")
{
strOpid += ("(" + id);
}
else
{
strOpid += ("," + id);
}
}
}
strOpid += ")";
if (strOpid == ")")
{
Response.Write("<script>alert('没有选中任何记录！');history.go(-1);</script>");
}
else
{
//删除
strsql = string.Format("update news set leibie = '" + dw_class.SelectedValue + "' where id in {0}", strOpid);
if (DBFun.ExecuteUpdate(strsql))
{
Response.Write("<script>alert('移动成功！');</script>");
string strqry = "select id,title,shijian ,admin,hits,leibie,iif(leixing='0','正高级',iif(leixing='1','专业技术二级',iif(leixing='2','特殊津贴人员',iif(leixing='3','优秀论文')))) as lx from news where leibie = '" + lbl_leibie.Text + "' and leixing='0' order by shijian desc ";
Session["dv_detail"] = DBFun.GetDataView(strqry);
bindData();
}
}
}
