private void btnCreateReport_Click(object sender, System.EventArgs e) { this.LoadParameters(); DbQueryResult countDownList = PromoteHelper.ExprtAdOrderInfoList(new GroupBuyQuery { OrderId = this.OrderId, starttime = this.StartTime.ToString(), endtime = this.EndTime.ToString(), keyword = this.KeyWord, PageIndex = this.pager.PageIndex, PageSize = this.pager.PageSize, SortBy = "Ordertime", SortOrder = SortAction.Desc }); DataTable dtResult = (DataTable)countDownList.Data; if (dtResult == null || dtResult.Rows.Count == 0) { this.ShowMsg("没有数据!", false); return; } foreach (DataColumn cl in dtResult.Columns) { switch (cl.ColumnName.ToLower()) { case "orderno": cl.ColumnName = "订单号"; break; case "ordertotal": cl.ColumnName = "订单总金额"; break; case "productname": cl.ColumnName = "商品名称"; break; case "barcode": cl.ColumnName = "商品条码"; break; case "sku": cl.ColumnName = "Sku编码"; break; case "itemadjustedprice": cl.ColumnName = "商品单价"; break; case "orderstatus": cl.ColumnName = "订单状态"; break; case "paymenttype": cl.ColumnName = "支付类型"; break; case "paymentstatus": cl.ColumnName = "付款状态"; break; case "ordertime": cl.ColumnName = "订单创建时间"; break; case "updatedate": cl.ColumnName = "订单修改时间"; break; } } MemoryStream ms = NPOIExcelHelper.ExportToExcel(dtResult, "广告订单"); this.Page.Response.Clear(); this.Page.Response.Buffer = false; this.Page.Response.Charset = "GB2312"; this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=广告订单.xlsx"); this.Page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); this.Page.Response.ContentType = "application/octet-stream"; this.Page.EnableViewState = false; this.Page.Response.BinaryWrite(ms.ToArray()); ms.Dispose(); ms.Close(); EventLogs.WriteOperationLog(Privilege.ReconciOrdersDetailsExcel, string.Format(CultureInfo.InvariantCulture, "用户{0}广告订单导出明细成功", new object[] { this.User.Identity.Name })); this.Page.Response.End(); }