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();
}
