public void ExportToExcel(HttpContext context)
{
RefundApplyQuery dataQuery = this.GetDataQuery(context);
dataQuery.RefundIds = context.Request["Ids"].ToNullString();
IList <RefundModel> refundApplysNoPage = OrderHelper.GetRefundApplysNoPage(dataQuery);
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("<table border='1'>");
stringBuilder.Append("<thead><tr>");
stringBuilder.Append("<th>编号</th>");
stringBuilder.Append("<th>会员名</th>");
stringBuilder.Append("<th>订单编号</th>");
stringBuilder.Append("<th>申请时间</th>");
stringBuilder.Append("<th>供应商</th>");
stringBuilder.Append("<th>处理状态</th>");
stringBuilder.Append("<th>退款原因</th>");
stringBuilder.Append("<th>退款金额</th>");
stringBuilder.Append("<th>处理时间</th>");
stringBuilder.Append("<th>退款途径</th>");
stringBuilder.Append("</tr></thead>");
StringBuilder stringBuilder2 = new StringBuilder();
foreach (RefundModel item in refundApplysNoPage)
{
stringBuilder2.Append("<tr>");
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.RefundId, true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.UserName, true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.OrderId, true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.ApplyForTime, true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD((item.SupplierId > 0) ? SupplierHelper.GetSupplierName(item.SupplierId) : "平台店", true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(EnumDescription.GetEnumDescription((Enum)(object)item.HandleStatus, 0), true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.RefundReason, true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.RefundAmount, false));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.GetDealTime, false));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(EnumDescription.GetEnumDescription((Enum)(object)item.RefundType, 0), true));
stringBuilder2.Append("</tr>");
}
stringBuilder.AppendFormat("<tbody>{0}</tbody></table>", stringBuilder2.ToString());
StringWriter stringWriter = new StringWriter();
stringWriter.Write(stringBuilder);
DownloadHelper.DownloadFile(context.Response, stringWriter.GetStringBuilder(), "SupplierRefundApplys" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls");
stringWriter.Close();
context.Response.End();
}
public void ExportToExcel(HttpContext context)
{
ReturnsApplyQuery dataQuery = this.GetDataQuery(context);
dataQuery.ReturnIds = context.Request["Ids"].ToNullString();
IList <ReturnInfo> returnApplysNoPage = OrderHelper.GetReturnApplysNoPage(dataQuery);
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("<table border='1'>");
stringBuilder.Append("<thead><tr>");
stringBuilder.Append("<th>编号</th>");
stringBuilder.Append("<th>会员名</th>");
stringBuilder.Append("<th>订单编号</th>");
stringBuilder.Append("<th>申请时间</th>");
stringBuilder.Append("<th>供应商</th>");
stringBuilder.Append("<th>处理状态</th>");
stringBuilder.Append("<th>退款/退货原因</th>");
stringBuilder.Append("<th>退款商品</th>");
stringBuilder.Append("<th>退款金额</th>");
stringBuilder.Append("<th>处理时间</th>");
stringBuilder.Append("<th>退款途径</th>");
stringBuilder.Append("</tr></thead>");
StringBuilder stringBuilder2 = new StringBuilder();
DateTime dateTime;
foreach (ReturnInfo item in returnApplysNoPage)
{
DateTime?handleTime = this.GetHandleTime(item);
stringBuilder2.Append("<tr>");
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.ReturnId, true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.UserName, true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.OrderId, true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.ApplyForTime, true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD((item.SupplierId > 0) ? SupplierHelper.GetSupplierName(item.SupplierId) : "平台店", true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(EnumDescription.GetEnumDescription((Enum)(object)item.HandleStatus, 0), true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.ReturnReason, true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.ShopName + "(" + item.Quantity + ")", true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.RefundAmount, false));
StringBuilder stringBuilder3 = stringBuilder2;
object argFields;
if (!handleTime.HasValue)
{
dateTime = handleTime.Value;
argFields = dateTime.ToString("yyyy-MM-dd HH:mm:ss");
}
else
{
argFields = "";
}
stringBuilder3.Append(ExcelHelper.GetXLSFieldsTD(argFields, true));
stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(EnumDescription.GetEnumDescription((Enum)(object)item.RefundType, 0), true));
stringBuilder2.Append("</tr>");
}
stringBuilder.AppendFormat("<tbody>{0}</tbody></table>", stringBuilder2.ToString());
StringWriter stringWriter = new StringWriter();
stringWriter.Write(stringBuilder);
HttpResponse response = context.Response;
StringBuilder stringBuilder4 = stringWriter.GetStringBuilder();
dateTime = DateTime.Now;
DownloadHelper.DownloadFile(response, stringBuilder4, "ReturnApplys" + dateTime.ToString("yyyyMMddhhmmss") + ".xls");
stringWriter.Close();
context.Response.End();
}