要导出页的前台： <asp:Button runat="server" ID="btnExport" Text="导出" CssClass="button_sm7" onclick="btnExport_Click" /> 后台： protected void btnSearch_Click(object sender, EventArgs e) { Response.Redirect("Export.aspx?uname=" + txtUNameS.Text + "&dep=" + this.ddlDepS.SelectedValue + "&class=" + this.ddlClassS.SelectedValue + "&iyear=" + this.ddlYearS.SelectedValue); }
Export.aspx (显示数据): <title>哎哎哎导出</title> <meta http-equiv="content-type" content="application/ms-excel; charset=UTF-8" /> </head> <body> <form id="form1"> <% string fileName = "哎哎哎.xls"; //导出后的文件名 Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(fileName)); %> <table border="1" cellpadding="0" cellspacing="0"> <tr align="center" style="font-weight: bold;"> <td style="width: 60px" rowspan="2"> 序号 </td> <td rowspan="2"> 。。 </td> <td rowspan="2"> 。。 </td> <td rowspan="2"> 。。 </td> <td rowspan="2"> 。。 </td> <td rowspan="2"> 。。 </td> <td rowspan="2"> 。。 </td> <td rowspan="2"> 。。 </td> <td colspan="4" style="text-align: center;"> 。。 </td> </tr> <tr> <td> 。。 </td> <td> 。。 </td> <td> 。。 </td> <td> 。。 </td> </tr> <asp:Repeater ID="rptStudentFee" runat="server"> <ItemTemplate> <tr> <td> <%#Eval("r_n") %> </td> <td> <%#Eval("Department") %> </td> <td> <%#Eval("CName") %> </td> <td> '<%#Eval("TTCard") %> </td> <td> <%#Eval("UName") %> </td> <td> <%#DigitalCampus.Web.Common.pfunction.getPBCName(DigitalCampus.Web.Common.clsDictionaryData.Gender.ToString(),Eval("Gender").ToString()) %> </td> <td> <%#DigitalCampus.Web.Common.pfunction.GetStrToShortDate(Eval("AdmissionDate").ToString())%> </td> <td> <%#Eval("UName") %> </td> <td> <%#Eval("SubYear")%> </td> <td> <%#Eval("ShouldPayment")%> </td> <td> <%#Eval("ActualPayment")%> </td> <td> <%#Decimal.Parse(Eval("ShouldPayment").ToString()) - Decimal.Parse(Eval("ActualPayment").ToString())%> </td> </tr> </ItemTemplate> </asp:Repeater> <asp:Repeater runat="server" ID="rptCount"> <ItemTemplate> <tr style="font-weight: bold;"> <td> 合计 </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> ￥ <%#Eval("ShouldPayment") %> </td> <td> ￥ <%#Eval("ActualPayment")%> </td> <td> ￥ <%#Decimal.Parse(Eval("ShouldPayment").ToString()) - Decimal.Parse(Eval("ActualPayment").ToString())%> </td> </tr> </ItemTemplate> </asp:Repeater> </table> </form> </body> </html> Export.aspx.cs(查数据): protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { GetFilesList(); } }
private void GetFilesList() { string sort = ""; string strWhere = " where 1=1 "; if (!string.IsNullOrEmpty(Request["uname"]) && Request["uname"] != "TT卡号/身份证/姓名") { strWhere += " and (vw.UName like '%" + Request["uname"] + "%' or vw.IdentityCard like '%" + Request["uname"] + "%' or vw.TTCard like '%" + Request["uname"] + "%')"; } if (Request["dep"] != "-1") { strWhere += " and vw.DepName='" + Request["dep"] + "'"; } if (Request["class"] != "-1") { strWhere += " and vw.ClassName='" + Request["class"] + "'"; } if (Request["iyear"] != "-1") { strWhere += " and sp.SubYear='" + Request["iyear"] + "'"; }
string strSql = @"select row_number() over(order by sp.SubYear,vw.DepName,vw.ClassName,vw.UName) as r_n,sp.*,vw.* from (select StuID,SubYear,isnull(sum(ShouldPayment),0) ShouldPayment,isnull(sum(ActualPayment),0) ActualPayment from StudentShouldpay group by StuID,SubYear) sp inner join dbo.vw_StudentInfo vw on sp.StuID=vw.ID " + strWhere; DataTable dt = DbHelperSQL.Query(strSql).Tables[0]; if (dt.Rows.Count == 0) { Response.Write("<script>alert('数据不存在，导出失败！');history.back();</script>"); Response.End(); } rptStudentFee.DataSource = dt; rptStudentFee.DataBind(); if (dt.Rows.Count > 0) { DataTable dt2 = new DataTable(); dt2 = DbHelperSQL.Query(@"select isnull(sum(ShouldPayment),0) ShouldPayment,isnull(sum(ActualPayment),0) ActualPayment from (select StuID,SubYear,isnull(sum(ShouldPayment),0) ShouldPayment,isnull(sum(ActualPayment),0) ActualPayment from StudentShouldpay group by StuID,SubYear) sp inner join dbo.vw_StudentInfo vw on sp.StuID=vw.ID " + strWhere).Tables[0]; rptCount.DataSource = dt2; rptCount.DataBind(); }
}
