public JsonResult UpdateStatusForComplete(int pkid)
{
RebateConfigManager manager = new RebateConfigManager();
var result = manager.UpdateStatusForComplete(pkid, User.Identity.Name);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult InsertRebateApplyPageConfig(RebateApplyPageConfig data)
{
RebateConfigManager manager = new RebateConfigManager();
var result = manager.InsertRebateApplyPageConfig(data, User.Identity.Name);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateRemarks(int pkid, string remarks)
{
RebateConfigManager manager = new RebateConfigManager();
var result = manager.UpdateRemarks(pkid, remarks, User.Identity.Name);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateStatus(int pkid, Status status, int refusalReasonId = 0)
{
RebateConfigManager manager = new RebateConfigManager();
var refusalReason = string.Empty;
switch (refusalReasonId)
{
case 3384:
refusalReason = "您好，您的朋友圈截图未满20个赞 ，请重新提交信息！";
break;
case 3385:
refusalReason = "您的订单还是已发货状态，请联系门店或客服更改订单状态为“已安装”，更改后请重新提交信息！";
break;
case 3386:
refusalReason = "您好，您上传的截图不符，请您重新提交信息，朋友圈截图需满足文字40个字，6张图，20个赞！";
break;
case 3450:
refusalReason = "您好，您的朋友圈文字不足40个字，请在评论里加上40字文字说明且包含有“途虎养车购买安装”等字样，添加完成后重新截图并提交信息哦！";
break;
default:
break;
}
var result = manager.UpdateStatus(pkid, status, refusalReason, refusalReasonId, User.Identity.Name);
return(Json(new { status = result.Item1, msg = result.Item2 }, JsonRequestBehavior.AllowGet));
}
public JsonResult SelectRebateConfigByPKID(int pkid)
{
RebateConfigManager manager = new RebateConfigManager();
var result = manager.SelectRebateConfigByPKID(pkid);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult UpsertRebateApplyConfig(RebateConfigModel data)
{
RebateConfigManager manager = new RebateConfigManager();
var result = manager.InsertRebateConfig(data, User.Identity.Name);
return(Json(new { status = result.Item1, msg = result.Item2 }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 更新门店
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public JsonResult UpdateRebateRecordInstallShopId(int pageIndex = 1, int pageSize = 10)
{
RebateConfigManager manager = new RebateConfigManager();
var result = manager.UpdateRebateRecordInstallShopId(pageIndex, pageSize);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult UpsertRebateApplyConfig(RebateConfigModel data)
{
RebateConfigManager manager = new RebateConfigManager();
var result = manager.UpdateRebateApplyRemarks(data, User.Identity.Name);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult SelectRebatePageConfig(int pageIndex = 1, int pageSize = 10)
{
RebateConfigManager manager = new RebateConfigManager();
var result = manager.SelectRebateApplyPageConfig(pageIndex, pageSize);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult SearchRebateConfigLog(string pkid)
{
RebateConfigManager manager = new RebateConfigManager();
var result = manager.SearchRebateConfigLog(pkid);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult SelectRebateConfig(Status status, string orderId, string phone,
string wxId, string remarks, string wxName, string timeType, DateTime?startTime,
DateTime?endTime, string principalPerson, string rebateMoney, string source,
int?installShopId, int pageIndex = 1, int pageSize = 10)
{
RebateConfigManager manager = new RebateConfigManager();
var result = manager.SelectRebateConfig(status, orderId, phone,
wxId, remarks, timeType, startTime, endTime, wxName, principalPerson, rebateMoney,
source, installShopId, pageIndex, pageSize);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult DeleteRebateApplyConfig(string pkidStr, bool isDelete = true)
{
RebateConfigManager manager = new RebateConfigManager();
var user = User.Identity.Name;
var result = false;
if (UserPower.Contains(User.Identity.Name))
{
result = manager.DeleteRebateApplyConfig(pkidStr.Split(',').ToList(), isDelete, user);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult WxPayManualRetry(int pkid)
{
RebateConfigManager manager = new RebateConfigManager();
var user = User.Identity.Name;
if (WxPayRetryUserPower.Contains(user))
{
var result = manager.WxPayManualRetry(pkid, user);
return(Json(result, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
public JsonResult UploadFile()
{
var files = Request.Files;
RebateConfigManager manager = new RebateConfigManager();
if (files.Count <= 0)
{
return(Json(new { status = true, msg = "请上传文件" }, JsonRequestBehavior.AllowGet));
}
var result = ConvertExcelToList(files);
if (result.Item1 != null && result.Item1.Any())
{
var data = manager.UpsertOldRebateApply(result.Item1, User.Identity.Name);
return(Json(data, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new List <RebateConfigModel>(), JsonRequestBehavior.AllowGet));
}
}
public JsonResult UpdateStatus(int pkid, Status status, int refusalReasonId = 0)
{
RebateConfigManager manager = new RebateConfigManager();
var refusalReason = string.Empty;
switch (refusalReasonId)
{
case 3384:
refusalReason = "您好，您的朋友圈截图点赞数不够或保留时间不足，请重新提交！";
break;
case 3385:
refusalReason = "您好，取消关注途虎养车公众号无法完成支付，请您重新关注公众号后，再次提交截图信息，谢谢！";
break;
case 3386:
refusalReason = "您好，您上传的截图不符，请您重新提交信息，朋友圈截图需满足文字40个，6张图，20个赞！";
break;
case 3450:
refusalReason = "您好，您的朋友圈截图未提及途虎养车，请在评论里加上“途虎养车购买安装”等字样，添加完成后重新截图并提交信息哦！";
break;
case 4677:
refusalReason = "您好，检测到您的订单信息与朋友圈不符，请上传真实的朋友圈截图，谢谢！";
break;
case 3333:
refusalReason = "";
break;
default:
break;
}
var result = manager.UpdateStatus(pkid, status, refusalReason, refusalReasonId, User.Identity.Name);
return(Json(new { status = result.Item1, msg = result.Item2 }, JsonRequestBehavior.AllowGet));
}
public JsonResult InsertSearchLog(string pkid, string phone, string type)
{
RebateConfigManager.InsertLog(pkid, "SearchUserInfo", type == "phone" ? "查看手机号" : "查看微信号", phone, string.Empty, string.Empty, User.Identity.Name);
return(Json(true, JsonRequestBehavior.AllowGet));
}
//public JsonResult UpdateRebateTimeToComplete()
//{
// RebateConfigManager manager = new RebateConfigManager();
// if (UserPower.Contains(User.Identity.Name))
// {
// var result = manager.UpdateRebateTimeToComplete();
// return Json(JsonConvert.SerializeObject(result), JsonRequestBehavior.AllowGet);
// }
// else
// {
// return Json(false, JsonRequestBehavior.AllowGet);
// }
//}
//public JsonResult UpdateWxName(string pkidStr)
//{
// var result = false;
// var msg = string.Empty;
// RebateConfigManager manager = new RebateConfigManager();
// if (UserPower.Contains(User.Identity.Name))
// {
// var data = manager.UpdateWxName(pkidStr.Split(',').ToList());
// result = data.Item1;
// msg = data.Item2;
// }
// return Json(new { result = result, msg = msg }, JsonRequestBehavior.AllowGet);
//}
public FileResult ExportRebateConfigInfo(Status status, string orderId, string phone,
string wxId, string remarks, string timeType, DateTime?startTime, string wxName,
DateTime?endTime, string principalPerson, string rebateMoney, string source,
int?installShopId, int pageIndex = 1, int pageSize = 10)
{
var workBook = new XSSFWorkbook();
var sheet = workBook.CreateSheet();
var row = sheet.CreateRow(0);
var cellNum = 0;
row.CreateCell(cellNum++).SetCellValue("返现编号");
row.CreateCell(cellNum++).SetCellValue("订单号");
//row.CreateCell(cellNum++).SetCellValue("手机号");
//row.CreateCell(cellNum++).SetCellValue("微信号");
row.CreateCell(cellNum++).SetCellValue("微信昵称");
row.CreateCell(cellNum++).SetCellValue("状态");
row.CreateCell(cellNum++).SetCellValue("百度ID");
row.CreateCell(cellNum++).SetCellValue("百度吧名");
row.CreateCell(cellNum++).SetCellValue("红包专员");
row.CreateCell(cellNum++).SetCellValue("用户名称");
row.CreateCell(cellNum++).SetCellValue("车牌号");
row.CreateCell(cellNum++).SetCellValue("来源");
row.CreateCell(cellNum++).SetCellValue("内容链接");
row.CreateCell(cellNum++).SetCellValue("返现金额");
row.CreateCell(cellNum++).SetCellValue("返现时间");
row.CreateCell(cellNum++).SetCellValue("备注");
row.CreateCell(cellNum++).SetCellValue("申请时间");
row.CreateCell(cellNum++).SetCellValue("审核时间");
row.CreateCell(cellNum++).SetCellValue("拒绝原因");
row.CreateCell(cellNum++).SetCellValue("新老数据");
cellNum = 0;
sheet.SetColumnWidth(cellNum++, 18 * 256);
sheet.SetColumnWidth(cellNum++, 18 * 256);
sheet.SetColumnWidth(cellNum++, 18 * 256);
sheet.SetColumnWidth(cellNum++, 18 * 256);
sheet.SetColumnWidth(cellNum++, 18 * 256);
sheet.SetColumnWidth(cellNum++, 18 * 256);
sheet.SetColumnWidth(cellNum++, 18 * 256);
sheet.SetColumnWidth(cellNum++, 18 * 256);
sheet.SetColumnWidth(cellNum++, 18 * 256);
sheet.SetColumnWidth(cellNum++, 18 * 256);
sheet.SetColumnWidth(cellNum++, 18 * 256);
sheet.SetColumnWidth(cellNum++, 18 * 256);
sheet.SetColumnWidth(cellNum++, 18 * 256);
RebateConfigManager manager = new RebateConfigManager();
List <RebateConfigModel> result = new List <RebateConfigModel>();
result = manager.SelectRebateConfig(status, orderId, phone, wxId, remarks, timeType,
startTime, endTime, wxName, principalPerson, rebateMoney, source, installShopId,
pageIndex, 9999999);
if (result != null && result.Any())
{
for (var i = 0; i < result.Count(); i++)
{
cellNum = 0;
NPOI.SS.UserModel.IRow rowTemp = sheet.CreateRow(i + 1);
rowTemp.CreateCell(cellNum++).SetCellValue(result[i].PKID);
rowTemp.CreateCell(cellNum++).SetCellValue(result[i].OrderId);
//rowTemp.CreateCell(cellNum++).SetCellValue(result[i].UserPhone);
//rowTemp.CreateCell(cellNum++).SetCellValue(result[i].WXId);
rowTemp.CreateCell(cellNum++).SetCellValue(result[i].WXName);
rowTemp.CreateCell(cellNum++).SetCellValue(ConvertStatus(result[i].Status));
rowTemp.CreateCell(cellNum++).SetCellValue(result[i].BaiDuId);
rowTemp.CreateCell(cellNum++).SetCellValue(result[i].BaiDuName);
rowTemp.CreateCell(cellNum++).SetCellValue(result[i].PrincipalPerson);
rowTemp.CreateCell(cellNum++).SetCellValue(result[i].UserName);
rowTemp.CreateCell(cellNum++).SetCellValue(result[i].CarNumber);
rowTemp.CreateCell(cellNum++).SetCellValue(result[i].Source);
rowTemp.CreateCell(cellNum++).SetCellValue(result[i].ContentUrl);
rowTemp.CreateCell(cellNum++).SetCellValue(result[i].RebateMoney.ToString("f2"));
rowTemp.CreateCell(cellNum++).SetCellValue(result[i].RebateTime?.ToString() ?? string.Empty);
rowTemp.CreateCell(cellNum++).SetCellValue(result[i].Remarks);
rowTemp.CreateCell(cellNum++).SetCellValue(result[i].CreateTime.ToString());
rowTemp.CreateCell(cellNum++).SetCellValue(result[i].CheckTime.ToString());
rowTemp.CreateCell(cellNum++).SetCellValue(result[i].RefusalReason?.ToString() ?? string.Empty);
rowTemp.CreateCell(cellNum++).SetCellValue(!string.IsNullOrEmpty(result[i].OpenId) ? "新" : "老");
}
}
var ms = new MemoryStream();
workBook.Write(ms);
return(File(ms.ToArray(), "application/x-xls", $"{DateTime.Now.ToString("yyyy年MM月dd日HH时mm分ss秒")}.xlsx"));
}
