private StoerBalanceModel <Dictionary <string, object> > GetDataList(StoreBalanceQuery query)
{
StoerBalanceModel <Dictionary <string, object> > stoerBalanceModel = new StoerBalanceModel <Dictionary <string, object> >();
DbQueryResult storeBalanceOverOrders = StoresHelper.GetStoreBalanceOverOrders(query);
stoerBalanceModel.rows = DataHelper.DataTableToDictionary(storeBalanceOverOrders.Data);
List <Dictionary <string, object> > rows = DataHelper.DataTableToDictionary(storeBalanceOverOrders.Data);
int storeId = query.StoreId;
DateTime value = query.StartDate.Value;
DateTime?endDate = query.EndDate;
decimal num = stoerBalanceModel.totalAmount = StoresHelper.GetStoreBalanceOrderTotal(storeId, value, endDate.Value, query.IsStoreCollect);
stoerBalanceModel.rows = rows;
stoerBalanceModel.total = storeBalanceOverOrders.TotalRecords;
return(stoerBalanceModel);
}
private void ExportToExcel(HttpContext context)
{
StoreBalanceQuery query = this.GetQuery(context);
query.PageIndex = 1;
query.PageSize = 2147483647;
DbQueryResult storeBalanceOverOrders = StoresHelper.GetStoreBalanceOverOrders(query);
decimal storeBalanceOrderTotal = StoresHelper.GetStoreBalanceOrderTotal(query.StoreId, query.StartDate.Value, query.EndDate.Value, query.IsStoreCollect);
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendLine("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">");
stringBuilder.AppendLine("<tr style=\"font-weight: bold; white-space: nowrap;\">");
stringBuilder.AppendLine("<td>结算时间</td>");
stringBuilder.AppendLine("<td>订单编号</td>");
stringBuilder.AppendLine("<td>订单实付</td>");
stringBuilder.AppendLine("<td>退款金额</td>");
stringBuilder.AppendLine("<td>平台佣金</td>");
stringBuilder.AppendLine("<td>结算金额</td>");
stringBuilder.AppendLine("<td>收款方</td>");
stringBuilder.AppendLine("<td>运费</td>");
stringBuilder.AppendLine("<td>积分抵扣</td>");
stringBuilder.AppendLine("<td>优惠券抵扣</td>");
stringBuilder.AppendLine("</tr>");
DataTable data = storeBalanceOverOrders.Data;
DateTime dateTime;
foreach (DataRow row in data.Rows)
{
stringBuilder.AppendLine("<tr>");
StringBuilder stringBuilder2 = stringBuilder;
dateTime = row.Field <DateTime>("CreateTime");
stringBuilder2.AppendLine("<td>" + dateTime.ToString("yyyy-MM-dd HH:mm:ss") + "</td>");
stringBuilder.AppendLine("<td style=\"vnd.ms-excel.numberformat:@\">" + row.Field <string>("TradeNo") + "</td>");
stringBuilder.AppendLine("<td>" + row["OrderTotal"].ToDecimal(0).F2ToString("f2") + "</td>");
stringBuilder.AppendLine("<td>" + row["RefundAmount"].ToDecimal(0).F2ToString("f2") + "</td>");
stringBuilder.AppendLine("<td>" + row["PlatCommission"].ToDecimal(0).F2ToString("f2") + "</td>");
stringBuilder.AppendLine("<td>" + row["Income"].ToDecimal(0).F2ToString("f2") + "</td>");
if (row["CollectByStore"].ToString() == "1")
{
stringBuilder.AppendLine("<td>门店</td>");
}
else
{
stringBuilder.AppendLine("<td>平台</td>");
}
stringBuilder.AppendLine("<td>" + row["Freight"].ToDecimal(0).F2ToString("f2") + "</td>");
stringBuilder.AppendLine("<td>" + row["DeductionMoney"].ToDecimal(0).F2ToString("f2") + "</td>");
stringBuilder.AppendLine("<td>" + row["CouponValue"].ToDecimal(0).F2ToString("f2") + "</td>");
stringBuilder.AppendLine("</tr>");
}
stringBuilder.AppendLine("<tr>");
stringBuilder.AppendLine("<td>总结算金额：" + storeBalanceOrderTotal.F2ToString("f2") + "</td>");
stringBuilder.AppendLine("<td></td>");
stringBuilder.AppendLine("</tr>");
stringBuilder.AppendLine("</table>");
context.Response.Clear();
context.Response.Buffer = false;
context.Response.Charset = "GB2312";
HttpResponse response = context.Response;
dateTime = DateTime.Now;
response.AppendHeader("Content-Disposition", "attachment;filename=StoreBalance_" + dateTime.ToString("yyyyMMddHHmmss") + ".xls");
context.Response.ContentEncoding = Encoding.GetEncoding("GB2312");
context.Response.ContentType = "application/ms-excel";
context.Response.Write(stringBuilder.ToString());
context.Response.End();
}