private void ExportToExcelBalancedetail(HttpContext context)
{
BalanceDetailSupplierQuery balanceDetailSupplierQuery = this.GetBalanceDetailSupplierQuery(context);
DbQueryResult balanceDetails4Report = BalanceHelper.GetBalanceDetails4Report(balanceDetailSupplierQuery);
string empty = string.Empty;
empty += "时间";
empty += ",类型";
empty += ",订单号";
empty += ",收入";
empty += ",支出";
empty += ",账户余额";
empty += ",备注\r\n";
foreach (DataRow row in balanceDetails4Report.Data.Rows)
{
empty += row["TradeDate"];
empty = empty + "," + row["TradeTypeText"];
empty = empty + "," + row["OrderId"];
empty = empty + "," + row["Income"];
empty = empty + "," + row["Expenses"];
empty = empty + "," + row["Balance"];
empty = empty + "," + row["Remark"] + "\r\n";
}
context.Response.Clear();
context.Response.Buffer = false;
context.Response.Charset = "GB2312";
context.Response.AppendHeader("Content-Disposition", "attachment;filename=BalanceDetail.csv");
context.Response.ContentEncoding = Encoding.GetEncoding("GB2312");
context.Response.ContentType = "application/ms-excel";
context.Response.Write(empty);
context.Response.End();
}
public void ExportExcel(HttpContext context)
{
BalanceDetailSupplierQuery dataQuery = this.GetDataQuery(context);
SupplierInfo supplierById = SupplierHelper.GetSupplierById(dataQuery.SupplierId.Value);
DbQueryResult balanceDetails4Report = BalanceHelper.GetBalanceDetails4Report(dataQuery);
StringBuilder stringBuilder = new StringBuilder(300);
stringBuilder.Append("供应商");
stringBuilder.Append(",时间");
stringBuilder.Append(",提现帐户");
stringBuilder.Append(",类型");
stringBuilder.Append(",订单号");
stringBuilder.Append(",收入");
stringBuilder.Append(",支出");
stringBuilder.Append(",账户余额");
stringBuilder.Append(",备注\r\n");
foreach (DataRow row in balanceDetails4Report.Data.Rows)
{
int requestId = row["OrderId"].ToInt(0);
SupplierBalanceDrawRequestInfo balanceDrawRequestInfo = BalanceHelper.GetBalanceDrawRequestInfo(requestId);
stringBuilder.Append(supplierById.SupplierName);
stringBuilder.Append("," + row["TradeDate"]);
if (balanceDrawRequestInfo != null)
{
string text = "";
text = ((!balanceDrawRequestInfo.IsWeixin) ? ((!balanceDrawRequestInfo.IsAlipay) ? $"提现到银行卡(开户银行:{balanceDrawRequestInfo.BankName}，银行开户名:{balanceDrawRequestInfo.AccountName}，银行卡帐号:{balanceDrawRequestInfo.MerchantCode})" : ("提现到支付宝(支付宝帐号:" + balanceDrawRequestInfo.AlipayCode + "，支付宝姓名:" + balanceDrawRequestInfo.AlipayRealName + ")")) : "提现到微信");
stringBuilder.Append("," + text);
}
else
{
stringBuilder.Append(",");
}
stringBuilder.Append("," + row["TradeTypeText"]);
SupplierTradeTypes supplierTradeTypes = (SupplierTradeTypes)row["TradeType"].ToInt(0);
if (supplierTradeTypes == SupplierTradeTypes.OrderBalance)
{
stringBuilder.Append("," + row["OrderId"]);
}
else
{
stringBuilder.Append(",");
}
stringBuilder.Append("," + row["Income"]);
stringBuilder.Append("," + row["Expenses"]);
stringBuilder.Append("," + row["Balance"]);
stringBuilder.Append("," + row["Remark"] + "\r\n");
}
context.Response.Clear();
context.Response.Buffer = false;
context.Response.Charset = "GB2312";
context.Response.AppendHeader("Content-Disposition", "attachment;filename=BalanceDetail.csv");
context.Response.ContentEncoding = Encoding.GetEncoding("GB2312");
context.Response.ContentType = "application/octet-stream";
context.Response.Write(stringBuilder.ToString());
context.Response.End();
}
