protected void Button1_Click(object sender, EventArgs e)
{
string nf = DropDownList1.Text.Trim();
string js = "<script language=javascript>alert('{0}');</script>";
string message = "导出成功，请点击下载文件";
string sqlstr = "";
DataTable dt = null, dt_yjmc = null;
sqlstr = " select YJMC,EJMC,sum(ISNULL(ZZRYFY,0)) as ZZRYFYHJ,sum(ISNULL(TXRYFY,0)) as TXRYFYHJ,sum(ISNULL(QTRYFY,0)) as QTRYFYHJ,sum(ISNULL(FLF,0)) as FLFHJ,sum(ISNULL(SBHCF,0)) as SBHCFHJ,sum(ISNULL(YWF,0)) as YWFHJ,sum(ISNULL(QT,0)) as QTHJ,(sum(ISNULL(ZZRYFY,0))+sum(ISNULL(TXRYFY,0))+sum(ISNULL(QTRYFY,0))+sum(ISNULL(FLF,0))+sum(ISNULL(SBHCF,0))+sum(ISNULL(YWF,0))+sum(ISNULL(QT,0))) AS HJ from [JFYSSBB] where SFSC!=1 and ZT=3 and SUBSTRING([CZSJ],1,4)='" + nf + "' group by YJMC,EJMC";
dt = DbHelperSQL.Query(sqlstr).Tables[0];
sqlstr = " select YJMC from [JFYSSBB] where SFSC!=1 and ZT=3 group by YJMC";
dt_yjmc = DbHelperSQL.Query(sqlstr).Tables[0];
if (dt.Rows.Count > 0)
{
ReadOrWriteExcel rd = new ReadOrWriteExcel(Server.MapPath(@"..\admin\mb\") + "\\汇总统计表.xls");
rd.DataWrite_SetSheetStyle(dt, dt_yjmc, "Sheet1");
string file = Server.MapPath(@"..\admin\down\") + "\\汇总统计表.xls";
rd.SavePath(file);
HyperLink1.Text = "点击下载：汇总统计表.xls";
HyperLink1.NavigateUrl = "down/汇总统计表.xls";
message = "导出成功，请点击下载文件";
HttpContext.Current.Response.Write(string.Format(js, message));
}
else
{
message = "没有可导出的数据";
HttpContext.Current.Response.Write(string.Format(js, message));
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sqlstr = "";
DataTable dt = null,dt_yjmc=null;
sqlstr = " select YJMC,EJMC,sum(ISNULL(ZZRYFY,0)) as ZZRYFYHJ,sum(ISNULL(TXRYFY,0)) as TXRYFYHJ,sum(ISNULL(QTRYFY,0)) as QTRYFYHJ,sum(ISNULL(FLF,0)) as FLFHJ,sum(ISNULL(SBHCF,0)) as SBHCFHJ,sum(ISNULL(YWF,0)) as YWFHJ,sum(ISNULL(QT,0)) as QTHJ,(sum(ISNULL(ZZRYFY,0))+sum(ISNULL(TXRYFY,0))+sum(ISNULL(QTRYFY,0))+sum(ISNULL(FLF,0))+sum(ISNULL(SBHCF,0))+sum(ISNULL(YWF,0))+sum(ISNULL(QT,0))) AS HJ from [JFYSSBB] group by YJMC,EJMC";
dt = DbHelperSQL.Query(sqlstr).Tables[0];
sqlstr = " select YJMC from [JFYSSBB] group by YJMC";
dt_yjmc = DbHelperSQL.Query(sqlstr).Tables[0];
DataRow[] drs = null;
ReadOrWriteExcel rd = new ReadOrWriteExcel(Server.MapPath(@"..\admin\mb\") + "\\汇总统计表.xls");
rd.DataWrite_SetSheetStyle(dt, dt_yjmc, "Sheet1");
string file = Server.MapPath(@"..\admin\mb\") + "\\1.xls";
rd.SavePath(file);
}
protected void Button3_Click(object sender, EventArgs e)
{
List<string> ids = null;
SyncSelectedRowIndexArrayToHiddenField(hfSelectedIDS1, Grid1);
ids = pb.GetSelectedIDsFromHiddenField(hfSelectedIDS1);
string sqlstr = "",sqlstr1="select ROW_NUMBER() OVER(order by JFZL,CZSJ desc) as xh, NDXH,YJMC,EJMC,SJMC,ZZRYFY,TXRYFY,QTRYFY,FLF,SBHCF,YWF,QT,YSJE,JFZL,BZ from JFYSSBB where ";
SqlDataReader sdr = null;
int flag = 1, ysh = 0;
if (ids != null)
{
if (ids.Count > 0)
{
for (int i = 0; i < ids.Count; i++)
{
//str = str + ids[i]+",";
sqlstr = "select ID from JFYSSBB where ZT<=2 and ID=" + int.Parse(ids[i]);
sdr = DbHelperSQL.ExecuteReader(sqlstr);
if (sdr.Read())
{
flag = 1;
}
else
{
flag = 0;
ysh = 1;
}
if (flag == 1)
{
//sqlstr = "update JFYSSBB set ZT=3 where ID=" + int.Parse(ids[i]);
sqlstr1 = sqlstr1 + " ID=" + int.Parse(ids[i]) + " or ";
}
}
sqlstr1 = sqlstr1.Trim();
sqlstr1 = sqlstr1.Remove(sqlstr1.Length - 2, 2);
if (sqlstr1.Contains("where"))
{
DataTable dt = DbHelperSQL.Query(sqlstr1).Tables[0];
if (dt.Rows.Count > 0)
{
ReadOrWriteExcel rd = new ReadOrWriteExcel(Server.MapPath(@"..\admin\mb\") + "\\工作经费预算表.xls");
rd.DataWrite_SetSheetStyle(dt, "Sheet1", ViewState["zrbm"].ToString(), ViewState["name"].ToString());
string file = Server.MapPath(@"..\admin\down\") + "\\工作经费预算表.xls";
rd.SavePath(file);
if (ysh == 0)
{
Alert.Show("操作成功,请点击直接下载文件");
}
else
{
Alert.Show("操作成功,但已审核的预算不会被导出，请点击直接下载文件");
}
HyperLink1.Text = "点击下载：工作经费预算表.xls";
HyperLink1.NavigateUrl = "down/工作经费预算表.xls";
}
else
{
Alert.Show("没有数据可导出");
}
}
else
{
Alert.Show("没有数据可导出");
}
}
else
{
Alert.Show("请至少勾选一条数据");
}
}
else
{
Alert.Show("请至少勾选一条数据");
}
}
