public ActionResult TireCouponManage()
{
var dat = ThirdShopManager.TireCouponManage();
var ShopList = new List <string>
{
"自有平台",
"途虎淘宝",
"途虎淘宝2",
"途虎天猫1",
"途虎天猫2",
"途虎天猫3",
"途虎天猫4",
"途虎京东2",
"途虎京东旗舰"
};
var result = new List <TireCouponResultModel>();
ShopList.ForEach(g =>
{
result.Add(dat.FirstOrDefault(t => t.ShopName == g) ?? new TireCouponResultModel
{
ShopName = g
});
});
return(View(result));
}
public int DeleteTireCoupon(int PKID)
{
if (PKID < 1)
{
return(0);
}
return(ThirdShopManager.DeleteTireCoupon(PKID, ThreadIdentity.Operator.Name));
}
public int AddTireCoupon(TireCouponModel request)
{
if (string.IsNullOrWhiteSpace(request.ShopName) || request.QualifiedPrice < request.Reduce || request.Reduce < 0 || request.EndTime < DateTime.Now || request.EndTime < request.StartTime || request.CouponType > 3 || request.CouponType < 0 || request.CouponUseRule < 0 || request.CouponUseRule > 1)
{
return(0);
}
return(ThirdShopManager.AddTireCoupon(request, ThreadIdentity.Operator.Name));
}
public JsonResult TireCouponList(string ShopName)
{
var data = ThirdShopManager.TireCouponManage(ShopName).FirstOrDefault();
var result = new List <TireCouponModel>();
if (data != null)
{
result.AddRange(data.CouponA);
result.AddRange(data.CouponB);
result.AddRange(data.CouponC);
}
return(Json(result));
}
public PartialViewResult MiaoShaProductList(PriceSelectModel selectModel, int PriceDifStatus, string shopCode, int pageIndex = 1, int pageSize = 10)
{
PagerModel pager = new PagerModel(pageIndex, pageSize);
var model = ThirdShopManager.FetchThirdPartyMiaoShaItems(selectModel, pager, shopCode, PriceDifStatus);
ViewBag.PriceDifStatus = PriceDifStatus;
ViewBag.SelectModel = selectModel;
ViewBag.shopCode = shopCode;
return(PartialView(new ListModel <ThirdPartyMiaoShaModel>()
{
Pager = pager, Source = model
}));
}
public JsonResult GetLowestLimitLog(string PID, string type)
{
if (string.IsNullOrWhiteSpace(PID))
{
return(Json(new { Code = 0, Info = "参数错误" }));
}
var result = ThirdShopManager.GetLowestLimitLog(PID, type);
return(Json(new
{
Code = 1,
Data = result
}));
}
public JsonResult FetchCouponLogByShopName(string ShopName)
{
if (string.IsNullOrWhiteSpace(ShopName))
{
return(Json(new
{
Code = 0
}));
}
return(Json(new
{
Code = 1,
Data = ThirdShopManager.FetchCouponLogByShopName(ShopName)
}));
}
public PartialViewResult ProductList(ProductListRequest request)
{
PagerModel pager = new PagerModel(request.PageIndex, request.PageSize);
var result = ThirdShopManager.ForProductListAsync(request, pager, true);
if (result.Any())
{
pager.TotalItem = result.Count;
result = result.Skip((request.PageIndex - 1) * request.PageSize).Take(request.PageSize).ToList();
}
ViewBag.Request = request;
return(PartialView(new ListModel <ProductPriceModel>()
{
Pager = pager, Source = result
}));
}
public JsonResult FetchPurchaseRestriction()
{
var Value = ThirdShopManager.FetchPurchaseRestriction();
if (Value > 0)
{
return(Json(new
{
Code = 1,
Data = Value
}));
}
return(Json(new
{
Code = 0,
Info = "无法读取到PurchaseRestriction的值"
}));
}
public JsonResult SetLowestLimitPrice(string PID, decimal?OldPrice, decimal LowestLimitPrice, string type)
{
if (string.IsNullOrWhiteSpace(PID))
{
return(Json(new
{
Code = 0,
Info = "参数错误"
}));
}
var result = ThirdShopManager.SetLowestLimitPrice(PID, OldPrice, LowestLimitPrice, ThreadIdentity.Operator.Name, type);
return(Json(new
{
Code = result,
Info = result > 0 ? "修改成功" : "修改失败"
}));
}
public JsonResult FetchLowestPrice(string ShopName, decimal Price, int MaxTireCount)
{
var result = ThirdShopManager.FetchLowestPrice(ShopName, Price, MaxTireCount);
if (result == null)
{
return(Json(new
{
Code = 0,
Info = "无可用优惠券"
}));
}
return(Json(new
{
Code = 1,
Count = result.Item3,
FinalPrice = result.Item1,
CouponDetail = string.Join(",", result.Item2.OrderBy(g => g.CouponType).Select(g => $"{(char)('A' + g.CouponType - 1)}类优惠券-{g.Description}"))
}, JsonRequestBehavior.AllowGet));
}
public async System.Threading.Tasks.Task <JsonResult> EditCanUseCoupon(IEnumerable <string> pids, bool canUseCoupon)
{
JsonResult jr = new JsonResult();
var checkresults = ThirdShopManager.SelectProductCouponPrice(pids);
var exists = pids.Where(x => checkresults.ContainsKey(x));
if (exists.Any())
{
jr.Data = new { code = 0, msg = $"已配置券后价.pid:{string.Join(" , ", exists)}" };
return(jr);
}
Dictionary <string, bool> beforvalues = new Dictionary <string, bool>();
List <ProductExtraProperties> models = new List <ProductExtraProperties>();
using (var client = new Tuhu.Service.Product.ProductConfigClient())
{
var getresult = client.SelectProductExtraPropertiesByPids(pids);
getresult.ThrowIfException(true);
foreach (var pid in pids)
{
var item = getresult.Result.FirstOrDefault(x => x.PID == pid) ??
new ProductExtraProperties()
{
PID = pid, CanUseCoupon = true
};
beforvalues[pid] = item.CanUseCoupon;
item.CanUseCoupon = canUseCoupon;
models.Add(item);
}
if (models.Any())
{
var updateresult = client.BatchCreateOrUpdateProductExtraProperties(models);
updateresult.ThrowIfException(true);
jr.Data = new
{
code = updateresult.Result > 0 ? 1 : 0,
msg = updateresult.Result > 0 ? "保存成功" : "保存失败"
};
var logs = pids.Select(x => new TireModifyConfigLog()
{
Pid = x,
Type = "CanUseCoupon",
UserId = HttpContext.User.Identity.Name,
Before = (beforvalues.ContainsKey(x) ? beforvalues[x] : true).ToString(),
After = canUseCoupon.ToString()
});
await TireInsuranceYearsManager.WriteLogsAsync(logs);
return(jr);
}
else
{
jr.Data = new
{
code = 0,
msg = "数据错误"
};
return(jr);
}
}
}
public FileResult ExportExcel(ProductListRequest request)
{
PagerModel pager = new PagerModel(request.PageIndex, request.PageSize);
var result = ThirdShopManager.ForProductListAsync(request, pager, true);
var pagesize = int.Parse(System.Configuration.ConfigurationManager.AppSettings["ExportSize"]);
var book = new HSSFWorkbook();
NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1");
NPOI.SS.UserModel.IRow row = sheet1.CreateRow(0);
var fileName = $"第三方平台{ThreadIdentity.Operator.Name.Split('@')[0]}.xls";
row.CreateCell(0).SetCellValue("品牌");
row.CreateCell(1).SetCellValue("PID");
row.CreateCell(2).SetCellValue("产品名称");
row.CreateCell(3).SetCellValue("进货价");
row.CreateCell(4).SetCellValue("最小毛利");
row.CreateCell(5).SetCellValue("可用券");
row.CreateCell(6).SetCellValue("官网价格");
row.CreateCell(7).SetCellValue("自有平台最低价");
row.CreateCell(8).SetCellValue("途虎淘宝");
row.CreateCell(9).SetCellValue("途虎淘宝最低价");
row.CreateCell(10).SetCellValue("途虎淘宝2");
row.CreateCell(11).SetCellValue("途虎淘宝2最低价");
row.CreateCell(12).SetCellValue("途虎天猫1");
row.CreateCell(13).SetCellValue("途虎天猫1最低价");
row.CreateCell(14).SetCellValue("途虎天猫2");
row.CreateCell(15).SetCellValue("途虎天猫2最低价");
row.CreateCell(16).SetCellValue("途虎天猫3");
row.CreateCell(17).SetCellValue("途虎天猫3最低价");
row.CreateCell(18).SetCellValue("途虎天猫4");
row.CreateCell(19).SetCellValue("途虎天猫4最低价");
row.CreateCell(20).SetCellValue("途虎京东2");
row.CreateCell(21).SetCellValue("途虎京东2最低价");
row.CreateCell(22).SetCellValue("途虎京东旗舰");
row.CreateCell(23).SetCellValue("途虎京东旗舰最低价");
row.CreateCell(24).SetCellValue("最低面价(平时)");
row.CreateCell(25).SetCellValue("最低面价(大促)");
row.CreateCell(26).SetCellValue("最低券后价(平时)");
row.CreateCell(27).SetCellValue("最低券后价(大促)");
var i = 0;
foreach (var item in result)
{
NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(++i);
rowtemp.CreateCell(0).SetCellValue(item.Brand);
rowtemp.CreateCell(1).SetCellValue(item.PID);
rowtemp.CreateCell(2).SetCellValue(item.ProductName);
rowtemp.CreateCell(3).SetCellValue(item.Cost == null ? "" : item.Cost.Value.ToString("0.00"));
rowtemp.CreateCell(4).SetCellValue(item.Min_maoliValue == null ? "" : item.Min_maoliValue.Value.ToString("0.00"));
rowtemp.CreateCell(5).SetCellValue(item.CanUseCoupon.HasValue ? (item.CanUseCoupon.Value ? "是" : "否") : "是");
rowtemp.CreateCell(6).SetCellValue(item.Price == null ? "" : item.Price.Value.ToString("0.00"));
rowtemp.CreateCell(7).SetCellValue(item.LowestPrice == null ? "" : item.LowestPrice.Value.ToString("0.00"));
rowtemp.CreateCell(8).SetCellValue(item.TBPrice == null ? "" : item.TBPrice.Value.ToString("0.00"));
rowtemp.CreateCell(9).SetCellValue(item.TBLowestPrice == null ? "" : item.TBLowestPrice.Value.ToString("0.00"));
rowtemp.CreateCell(10).SetCellValue(item.TB2Price == null ? "" : item.TB2Price.Value.ToString("0.00"));
rowtemp.CreateCell(11).SetCellValue(item.TB2LowestPrice == null ? "" : item.TB2LowestPrice.Value.ToString("0.00"));
rowtemp.CreateCell(12).SetCellValue(item.TM1Price == null ? "" : item.TM1Price.Value.ToString("0.00"));
rowtemp.CreateCell(13).SetCellValue(item.TM1LowestPrice == null ? "" : item.TM1LowestPrice.Value.ToString("0.00"));
rowtemp.CreateCell(14).SetCellValue(item.TM2Price == null ? "" : item.TM2Price.Value.ToString("0.00"));
rowtemp.CreateCell(15).SetCellValue(item.TM2LowestPrice == null ? "" : item.TM2LowestPrice.Value.ToString("0.00"));
rowtemp.CreateCell(16).SetCellValue(item.TM3Price == null ? "" : item.TM3Price.Value.ToString("0.00"));
rowtemp.CreateCell(17).SetCellValue(item.TM3LowestPrice == null ? "" : item.TM3LowestPrice.Value.ToString("0.00"));
rowtemp.CreateCell(18).SetCellValue(item.TM4Price == null ? "" : item.TM4Price.Value.ToString("0.00"));
rowtemp.CreateCell(19).SetCellValue(item.TM4LowestPrice == null ? "" : item.TM4LowestPrice.Value.ToString("0.00"));
rowtemp.CreateCell(20).SetCellValue(item.JDPrice == null ? "" : item.JDPrice.Value.ToString("0.00"));
rowtemp.CreateCell(21).SetCellValue(item.JDLowestPrice == null ? "" : item.JDLowestPrice.Value.ToString("0.00"));
rowtemp.CreateCell(22).SetCellValue(item.JDFlagShipPrice == null ? "" : item.JDFlagShipPrice.Value.ToString("0.00"));
rowtemp.CreateCell(23).SetCellValue(item.JDFlagShipLowestPrice == null ? "" : item.JDFlagShipLowestPrice.Value.ToString("0.00"));
rowtemp.CreateCell(24).SetCellValue(item.LowestPrice_Normal.HasValue ? item.LowestPrice_Normal.Value.ToString("0.00") : "");
rowtemp.CreateCell(25).SetCellValue(item.LowestPrice_Promotion.HasValue ? item.LowestPrice_Promotion.Value.ToString("0.00") : "");
rowtemp.CreateCell(26).SetCellValue(item.CouponPrice_Normal.HasValue ? item.CouponPrice_Normal.Value.ToString("0.00") : "");
rowtemp.CreateCell(27).SetCellValue(item.CouponPrice_Promotion.HasValue ? item.CouponPrice_Promotion.Value.ToString("0.00") : "");
}
var ms = new MemoryStream();
book.Write(ms);
ms.Seek(0, SeekOrigin.Begin);
return(File(ms, "application/vnd.ms-excel", fileName));
}
