public void ExportExcel(HttpContext context) { BalanceDrawRequestSupplierQuery dataQuery = this.GetDataQuery(context); DbQueryResult balanceDrawRequest4Report = BalanceHelper.GetBalanceDrawRequest4Report(dataQuery, true); string empty = string.Empty; empty += "用户名"; empty += ",供应商"; empty += ",申请时间"; empty += ",业务摘要"; empty += ",提现金额"; empty += ",备注\r\n"; foreach (DataRow row in balanceDrawRequest4Report.Data.Rows) { empty += row["UserName"]; empty = empty + "," + row["SupplierName"]; empty = empty + "," + row["RequestTime"]; empty += ",银行卡提现"; empty = empty + "," + row["Amount"]; empty = empty + "," + row["Remark"] + "\r\n"; } context.Response.Clear(); context.Response.Buffer = false; context.Response.Charset = "GB2312"; context.Response.AppendHeader("Content-Disposition", "attachment;filename=DrawRequest.csv"); context.Response.ContentEncoding = Encoding.GetEncoding("GB2312"); context.Response.ContentType = "application/octet-stream"; context.Response.Write(empty); context.Response.End(); }
private void ExportToExcelBalance(HttpContext context) { BalanceDrawRequestSupplierQuery listBalanceqQuery = this.getListBalanceqQuery(context); listBalanceqQuery.PageIndex = 1; listBalanceqQuery.PageSize = 2147483647; DbQueryResult balanceDrawRequest4Report = BalanceHelper.GetBalanceDrawRequest4Report(listBalanceqQuery, false); string empty = string.Empty; empty += "申请时间"; empty += ",提现金额"; empty += ",提现方式"; empty += ",收款人"; empty += ",收款账号"; empty += ",状态"; empty += ",拒绝理由"; empty += ",放款时间\r\n"; foreach (DataRow row in balanceDrawRequest4Report.Data.Rows) { empty += row["RequestTime"]; empty = empty + "," + row["Amount"]; empty = empty + "," + ((row["IsAlipay"].ToString() == "False") ? "银行卡转账" : "支付宝支付"); empty = empty + "," + ((row["IsAlipay"].ToString() == "False") ? row["AccountName"] : row["AlipayRealName"]); empty = empty + "," + ((row["IsAlipay"].ToString() == "False") ? row["MerchantCode"] : row["AlipayCode"]); empty = empty + "," + this.ParseDrawStatus(row["IsPass"]); empty = empty + "," + row["ManagerRemark"]; empty = empty + "," + ((row["IsPass"] != null && row["IsPass"].ToString() == "True") ? row["AccountDate"].ToString() : "--") + "\r\n"; } context.Response.Clear(); context.Response.Buffer = false; context.Response.Charset = "GB2312"; context.Response.AppendHeader("Content-Disposition", "attachment;filename=MyBalance.csv"); context.Response.ContentEncoding = Encoding.GetEncoding("GB2312"); context.Response.ContentType = "application/ms-excel"; context.Response.Write(empty); context.Response.End(); }