public void ExportToExcel(HttpContext context)
{
RefundApplyQuery refundApplyQuery = new RefundApplyQuery();
refundApplyQuery.OrderId = Globals.UrlDecode(context.Request["OrderId"]);
refundApplyQuery.HandleStatus = base.GetIntParam(context, "HandleStatus", true);
refundApplyQuery.RefundIds = context.Request["Ids"].ToNullString();
refundApplyQuery.SortBy = "ApplyForTime";
refundApplyQuery.SortOrder = SortAction.Desc;
IList <RefundModel> refundApplysNoPage = OrderHelper.GetRefundApplysNoPage(refundApplyQuery);
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.StoreId.HasValue && item.StoreId.Value > 0) ? DepotHelper.GetStoreNameByStoreId(item.StoreId.Value) : "平台店", 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(), "RefundApplys" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls");
stringWriter.Close();
context.Response.End();
}
public override void OnLoad(HttpContext context)
{
base.OnLoad(context);
if (context.Request["flag"] == "GetFinishedVerificationRecord")
{
int storeId = base.CurrentManager.StoreId;
int managerId = 0;
if (base.CurrentManager.RoleId == -3)
{
managerId = base.CurrentManager.ManagerId;
}
string keyword = context.Request["keyword"].ToNullString();
Pagination pagination = new Pagination();
int num = context.Request["PageIndex"].ToInt(0);
if (num < 1)
{
num = 1;
}
int num2 = context.Request["PageSize"].ToInt(0);
if (num2 < 1)
{
num2 = 10;
}
pagination.PageIndex = num;
pagination.PageSize = num2;
pagination.SortOrder = SortAction.Desc;
pagination.SortBy = "VerificationDate";
DbQueryResult finishedVerificationRecord = OrderHelper.GetFinishedVerificationRecord(pagination, storeId, keyword, managerId);
string s = JsonConvert.SerializeObject(new
{
Result = new
{
RecordCount = finishedVerificationRecord.TotalRecords,
List = from d in finishedVerificationRecord.Data.AsEnumerable()
select new
{
OrderId = d.Field <string>("OrderId"),
ProductName = d.Field <string>("ItemDescription"),
ThumbnailsUrl = Globals.FullPath(d.Field <string>("ThumbnailsUrl")),
Price = d.Field <decimal>("ItemAdjustedPrice").F2ToString("f2"),
num = d.Field <int>("num"),
UserName = d.Field <string>("UserName"),
VerificationDate = d.Field <DateTime>("VerificationDate").ToString("yyyy-MM-dd HH:mm:ss")
}
}
});
context.Response.Write(s);
context.Response.End();
}
DateTime value;
if (context.Request["flag"] == "CheckVerification")
{
int storeId2 = base.CurrentManager.StoreId;
string verificationPassword = context.Request["VerificationItems"];
OrderVerificationItemInfo verificationInfoByPassword = OrderHelper.GetVerificationInfoByPassword(verificationPassword);
if (verificationInfoByPassword == null)
{
context.Response.Write(this.GetErrorJosn(801, "该核销码无效，请重新输入"));
return;
}
if (verificationInfoByPassword.StoreId != storeId2)
{
context.Response.Write(this.GetErrorJosn(802, "非本门店核销码，请买家核对信息"));
return;
}
if (verificationInfoByPassword.VerificationStatus == 1)
{
HttpResponse response = context.Response;
value = verificationInfoByPassword.VerificationDate.Value;
response.Write(this.GetErrorJosn(801, "该核销码 于" + value.ToString("yyyy-MM-dd HH:mm:ss") + "已核销"));
return;
}
if (verificationInfoByPassword.VerificationStatus == 3)
{
context.Response.Write(this.GetErrorJosn(801, "核销码已过期，无法核销"));
return;
}
if (verificationInfoByPassword.VerificationStatus == 5)
{
context.Response.Write(this.GetErrorJosn(801, "此核销码已进行售后，无法核销"));
return;
}
if (verificationInfoByPassword.VerificationStatus == 4)
{
context.Response.Write(this.GetErrorJosn(801, "此核销码正在进行售后，无法核销"));
return;
}
string s2 = JsonConvert.SerializeObject(new
{
Result = new
{
Success = new
{
Status = true,
Msg = "核销码可用"
}
}
});
context.Response.Write(s2);
context.Response.End();
}
decimal num3 = default(decimal);
if (context.Request["flag"] == "OrderVerification")
{
int storeId3 = base.CurrentManager.StoreId;
string text = context.Request["VerificationItems"];
string[] array = text.Split(',');
DateTime now = DateTime.Now;
string text2 = "";
OrderVerificationItemInfo orderVerificationItemInfo = null;
for (int i = 0; i < array.Length; i++)
{
if (!string.IsNullOrEmpty(array[i]))
{
OrderVerificationItemInfo verificationInfoByPassword2 = OrderHelper.GetVerificationInfoByPassword(array[i]);
if (i == 0)
{
orderVerificationItemInfo = verificationInfoByPassword2;
orderVerificationItemInfo.VerificationDate = DateTime.Now;
}
if (verificationInfoByPassword2 == null)
{
context.Response.Write(this.GetErrorJosn(801, "该核销码无效，请重新输入"));
return;
}
if (verificationInfoByPassword2.StoreId != storeId3)
{
context.Response.Write(this.GetErrorJosn(802, "非本门店核销码，请买家核对信息"));
return;
}
if (verificationInfoByPassword2.VerificationStatus == 1)
{
HttpResponse response2 = context.Response;
value = verificationInfoByPassword2.VerificationDate.Value;
response2.Write(this.GetErrorJosn(801, "该核销码 于" + value.ToString("yyyy-MM-dd HH:mm:ss") + "已核销"));
return;
}
if (verificationInfoByPassword2.VerificationStatus == 3)
{
context.Response.Write(this.GetErrorJosn(801, "核销码已过期，无法核销"));
return;
}
if (verificationInfoByPassword2.VerificationStatus == 5)
{
context.Response.Write(this.GetErrorJosn(801, "此核销码已进行售后，无法核销"));
return;
}
if (verificationInfoByPassword2.VerificationStatus == 4)
{
context.Response.Write(this.GetErrorJosn(801, "此核销码正在进行售后，无法核销"));
return;
}
verificationInfoByPassword2.VerificationStatus = 1;
verificationInfoByPassword2.VerificationDate = now;
verificationInfoByPassword2.ManagerId = base.CurrentManager.ManagerId;
verificationInfoByPassword2.UserName = base.CurrentManager.UserName;
OrderHelper.UpdateVerificationItem(verificationInfoByPassword2);
text2 = verificationInfoByPassword2.OrderId;
}
WXAppletFormDataInfo wxFormData = WeChartAppletHelper.GetWxFormData(WXAppletEvent.ServiceProductValid, text2);
if (wxFormData != null)
{
wxFormData.EventValue += now.ToString("yyyyMMddHHmmss");
new WeChatAppletDao().Update(wxFormData, null);
}
}
OrderInfo serviceProductOrderInfo = OrderHelper.GetServiceProductOrderInfo(text2);
if (serviceProductOrderInfo != null)
{
num3 = serviceProductOrderInfo.GetTotal(false) / (decimal)serviceProductOrderInfo.GetBuyQuantity() * (decimal)array.Length;
MemberInfo user = Users.GetUser(serviceProductOrderInfo.UserId);
string storeName = "";
string productName = "";
if (serviceProductOrderInfo.StoreId > 0)
{
storeName = DepotHelper.GetStoreNameByStoreId(serviceProductOrderInfo.StoreId);
}
if (serviceProductOrderInfo.LineItems != null && serviceProductOrderInfo.LineItems.Count > 0)
{
productName = serviceProductOrderInfo.LineItems.Values.FirstOrDefault().ItemDescription;
}
Messenger.ServiceOrderValidSuccess(orderVerificationItemInfo, user, serviceProductOrderInfo, productName, storeName, text, num3);
if (OrderHelper.IsVerificationFinished(text2) && serviceProductOrderInfo.ItemStatus == OrderItemStatus.Nomarl)
{
serviceProductOrderInfo.OrderStatus = OrderStatus.Finished;
serviceProductOrderInfo.FinishDate = DateTime.Now;
TradeHelper.UpdateOrderInfo(serviceProductOrderInfo);
}
}
string s3 = JsonConvert.SerializeObject(new
{
Result = new
{
Status = "SUCCESS",
VerificationDate = now.ToString("yyyy-MM-dd HH:mm:ss")
}
});
context.Response.Write(s3);
context.Response.End();
}
}
