/// <summary>
/// 批量导入
/// </summary>
/// <returns></returns>
public async Task <JsonResult> BatchImportExcel()
{
if (Request.Files.Count <= 0)
{
return(Json(new { Status = false, Msg = "没有查找到导入文件" }));
}
if (Request.Files.Count > 1)
{
return(Json(new { Status = false, Msg = "只允许导入单个文件" }));
}
var file = Request.Files[0];
if (file.ContentType != "application/vnd.ms-excel" &&
file.ContentType != "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
{
return(Json(new { Status = false, Msg = "请上传Excel文件" }, "text/html"));
}
if (file.InputStream.Length <= 0)
{
return(Json(new { Status = false, Msg = "文件中没有包含任何数据" }));
}
var workBook = new XSSFWorkbook(file.InputStream);
var sheet = workBook.GetSheetAt(0);
var manager = new BaoYangRecommendManager();
var result = await manager.BatchImportExcel(sheet, User.Identity.Name);
return(Json(new { Status = string.IsNullOrWhiteSpace(result), Msg = result }));
}
/// <summary>
/// 保存推荐排序
/// </summary>
/// <param name="settings"></param>
/// <returns></returns>
public ActionResult SaveBaoYangProductPriority(List <BaoYangProductPriorityModel> settings, string partName, string grade, string viscosity)
{
if (settings == null || !settings.Any() ||
string.IsNullOrWhiteSpace(partName) ||
(string.Equals(partName, "机油", StringComparison.OrdinalIgnoreCase) && (string.IsNullOrWhiteSpace(grade) || string.IsNullOrWhiteSpace(viscosity))))
{
return(Json(new { status = false, Msg = "参数验证失败" }, JsonRequestBehavior.AllowGet));
}
if (settings.Count() != settings.Select(x => x.Priority).Distinct().Count())
{
return(Json(new { status = false, Msg = "排序存在重复" }, JsonRequestBehavior.AllowGet));
}
var success = false;
var manager = new BaoYangRecommendManager();
if (!string.IsNullOrWhiteSpace(viscosity) && !string.IsNullOrWhiteSpace(grade) && string.Equals(partName, "机油", StringComparison.OrdinalIgnoreCase))
{
success = manager.SaveOilBaoYangProductPriority(settings, grade, viscosity, User.Identity.Name);
}
else
{
success = manager.SaveBaoYangProductPriority(settings, partName, User.Identity.Name);
}
return(Json(new { status = success }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取特殊车型配置地区模板
/// </summary>
/// <param name="partName"></param>
/// <returns></returns>
public async Task <JsonResult> GetPriorityAreaConfig(string partName)
{
if (string.IsNullOrWhiteSpace(partName))
{
return(Json(new { Status = false, Msg = "参数验证失败" }));
}
var manager = new BaoYangRecommendManager();
return(Json(new { Status = true, Data = await manager.GetProductPriorityArea(partName.Trim()) }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 修改车型排序配置状态
/// </summary>
/// <param name="pkid"></param>
/// <param name="isEnabled"></param>
/// <returns></returns>
public JsonResult UpdateAreaDetailEnabled(string vehicleId, bool isEnabled)
{
if (string.IsNullOrWhiteSpace(vehicleId))
{
return(Json(new { Status = false, Msg = "参数验证失败" }, JsonRequestBehavior.AllowGet));
}
var manager = new BaoYangRecommendManager();
return(Json(new { Status = manager.UpdateVehicleAreaDetailEnabledByPkid(vehicleId, isEnabled) }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 修改机油车型推荐排序配置状态
/// </summary>
/// <param name="pkid"></param>
/// <param name="isEnabled"></param>
/// <returns></returns>
public JsonResult UpdateOilAreaEnabled(int areaOilId, bool isEnabled)
{
if (areaOilId <= 0)
{
return(Json(new { Status = false, Msg = "参数验证失败" }, JsonRequestBehavior.AllowGet));
}
var manager = new BaoYangRecommendManager();
return(Json(new { Status = manager.UpdateVehicleOilAreaEnabledByPkid(areaOilId, isEnabled) }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取地区
/// </summary>
/// <param name="areaId"></param>
/// <param name="partName"></param>
/// <returns></returns>
public async Task <JsonResult> GetRegion(int areaId, string partName)
{
if (string.IsNullOrEmpty(partName))
{
return(Json(new { Status = false, Msg = "参数验证失败" }, JsonRequestBehavior.AllowGet));
}
var manager = new BaoYangRecommendManager();
var result = await manager.GetRegion(areaId, partName.Trim());
return(Json(new { Status = true, Data = result }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 停用/启用 地区配置模板
/// </summary>
/// <param name="areaId"></param>
/// <param name="IsEnabled"></param>
/// <param name="partName"></param>
/// <returns></returns>
public async Task <JsonResult> UpdatePriorityAreaIsEnabled(int areaId, bool isEnabled, string partName)
{
if (string.IsNullOrWhiteSpace(partName) || areaId <= 0)
{
return(Json(new { Status = false, Msg = "参数验证失败" }));
}
var manager = new BaoYangRecommendManager();
var result = await manager.UpdatePriorityAreaIsEnabled(areaId, isEnabled, partName.Trim());
return(Json(new { Status = result.Item1, Msg = result.Item2 }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 删除车型推荐排序
/// </summary>
/// <param name="pkids"></param>
/// <returns></returns>
public JsonResult DeleteProductPriorityAreaDetail(IEnumerable <string> vehicleIds)
{
if (vehicleIds == null || !vehicleIds.Any())
{
return(Json(new { Status = false, Msg = "参数验证失败" }, JsonRequestBehavior.AllowGet));
}
var manager = new BaoYangRecommendManager();
string result = manager.DeleteProductPriorityAreaDetailByvehicleIds(vehicleIds, User.Identity.Name);
return(Json(new { Status = string.IsNullOrWhiteSpace(result), Msg = result }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 保存机油车型推荐排序
/// </summary>
/// <param name="views"></param>
/// <param name="areaId"></param>
/// <returns></returns>
public async Task <JsonResult> SaveVehicleOilProductPriority(VehicleOilProductPriorityRequest request)
{
var manager = new BaoYangRecommendManager();
var cehckResult = await manager.BatchAddOilCheckAsync(new List <VehicleOilProductPriorityRequest>() { request });
if (!string.IsNullOrWhiteSpace(cehckResult))
{
return(Json(new { Status = false, Msg = cehckResult }, JsonRequestBehavior.AllowGet));
}
var result = manager.SaveVehicleOilProductPriorityView(request.Views.ToList(), request.AreaId, User.Identity.Name);
return(Json(new { Status = string.IsNullOrWhiteSpace(result.Item2), Msg = result.Item2, Data = result.Item1 }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取机油车型推荐排序
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public JsonResult GetVehicleOilProductPriority(OilVehicleProductPriorityRequst request)
{
if (request == null)
{
return(Json(new { Status = false, Msg = "参数验证失败" }, JsonRequestBehavior.AllowGet));
}
request.PageIndex = request.PageIndex > 0 ? request.PageIndex : 1;
request.PageSize = request.PageSize > 0 ? request.PageSize : 100;
var manager = new BaoYangRecommendManager();
var data = manager.GetVehicleOilProductPriorityView(request);
return(Json(new { Status = true, Msg = string.Empty, Data = data.Item2, Total = data.Item1 }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取车型推荐排序
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public JsonResult GetVehicleProductPriority(VehicleProductPriorityRequest request)
{
if (request == null || string.IsNullOrWhiteSpace(request.PartName))
{
return(Json(new { Status = false, Msg = "参数验证失败" }));
}
request.PageIndex = request.PageIndex > 0 ? request.PageIndex : 1;
request.PageSize = request.PageSize > 0 ? request.PageSize : 100;
var manager = new BaoYangRecommendManager();
var result = manager.GetVehicleProductPriorityView(request);
return(Json(new { Status = true, Data = result.Item2, Total = result.Item1 }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取产品推荐排序
/// </summary>
/// <param name="partName"></param>
/// <param name="category"></param>
/// <returns></returns>
public JsonResult GetBaoYangProductPriority(string partName, string category)
{
if (string.IsNullOrWhiteSpace(partName) || string.IsNullOrWhiteSpace(category))
{
return(Json(new { status = false, Msg = "参数验证失败" }, JsonRequestBehavior.AllowGet));
}
var manager = new BaoYangRecommendManager();
if (string.Equals(partName, "机油", StringComparison.OrdinalIgnoreCase) && string.Equals(category, "Oil", StringComparison.OrdinalIgnoreCase))
{
var data = manager.GetOilBaoYangProductPriority();
return(Json(new { status = true, Msg = "成功", Data = data }, JsonRequestBehavior.AllowGet));
}
else
{
var data = manager.GetBaoYangProductPriority(partName, category);
return(Json(new { status = true, Msg = "成功", Data = data }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 保存车型推荐排序
/// </summary>
/// <param name="views"></param>
/// <param name="partName"></param>
/// <returns></returns>
public async Task <JsonResult> SaveVehicleProductPriority(VehicleProductPriorityRequst request)
{
if (request == null || request.views == null || !request.views.Any() ||
request.Details == null || !request.Details.Any() || request.Details.Any(x => string.IsNullOrWhiteSpace(x.Brand) || string.IsNullOrWhiteSpace(x.Series)) ||
string.IsNullOrWhiteSpace(request.partName))
{
return(Json(new { Status = false, Msg = "参数验证失败" }));
}
var manager = new BaoYangRecommendManager();
var checkResult = await manager.BatchAddCheckAsync(new List <VehicleProductPriorityRequst>() { request });
if (!string.IsNullOrWhiteSpace(checkResult))
{
return(Json(new { Status = false, Msg = checkResult }, JsonRequestBehavior.AllowGet));
}
var views = request.views;
views.ForEach(x => x.Details.AddRange(request.Details));
var result = manager.SaveVehicleProductPriorityView(views, request.partName, request.AreaId, User.Identity.Name);
return(Json(new { Status = string.IsNullOrWhiteSpace(result.Item2), Msg = result.Item2, Data = result.Item1 }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取车身类别
/// </summary>
/// <returns></returns>
public JsonResult GetVehicleBodyType()
{
var manager = new BaoYangRecommendManager();
return(Json(new { Status = true, Data = manager.GetVehicleBodyType() }, JsonRequestBehavior.AllowGet));
}
