public JsonResult GetBatteryBrands()
{
var manager = new BaoYangManager();
var result = _batteryManager.GetBatteryBrands();
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult AddOrEditOilBrandRegionPriority(OilBrandRegionPriorityModel model)
{
if (model.ProvinceId < 0 || model.RegionId < 0)
{
return(Json(new { Status = false, Msg = "请填写城市信息" }));
}
else if (string.IsNullOrWhiteSpace(model.ProvinceName) || string.IsNullOrWhiteSpace(model.CityName))
{
return(Json(new { Status = false, Msg = "请填写城市信息" }));
}
var manager = new BaoYangManager();
bool?isExistVehicle = DALBaoyang.IsRepeatOilBrandRegionPriority(model);
if (isExistVehicle == true)
{
return(Json(new { Status = false, Msg = "存在重复数据" }));
}
bool?Result = model.PKID > 0 ? manager.EditOilBrandRegionPriority(model, User.Identity.Name)
: manager.AddOilBrandRegionPriority(model, User.Identity.Name);
if (Result == null)
{
return(Json(new { Status = false, Msg = "出现未知错误，请查看错误日志" }));
}
else if (Result == true)
{
return(Json(new { Status = true, Msg = model.PKID > 0 ? "修改" : "添加" + "成功" }));
}
else
{
return(Json(new { Status = false, Msg = model.PKID > 0 ? "修改" : "添加" + "失败" }));
}
}
public JsonResult AddOrEditOilBrandPhonePriority(OilBrandPhonePriorityModel model)
{
if (string.IsNullOrWhiteSpace(model.PhoneNumber) || string.IsNullOrWhiteSpace(model.Brand))
{
return(Json(new { Status = false, Msg = "请填写推荐信息" }));
}
var manager = new BaoYangManager();
bool?isExistVehicle = DALBaoyang.IsRepeatOilBrandPhonePriority(model);
if (isExistVehicle == true)
{
return(Json(new { Status = false, Msg = model.PhoneNumber + "存在重复数据" }));
}
bool?Result = model.PKID > 0 ? manager.EditOilBrandPhonePriority(model, User.Identity.Name) : manager.AddOilBrandPhonePriority(new List <OilBrandPhonePriorityModel> {
model
}, User.Identity.Name);
if (Result == null)
{
return(Json(new { Status = false, Msg = "出现未知错误，请查看错误日志" }));
}
else if (Result == true)
{
return(Json(new { Status = true, Msg = "修改成功" }));
}
else
{
return(Json(new { Status = false, Msg = "修改失败" }));
}
}
public JsonResult DeleteOilBrandPriorityByPKID(string type, int pkid)
{
if (pkid < 1)
{
return(Json(new { Status = false, Msg = "不明白要删除什么" }));
}
var manager = new BaoYangManager();
bool?deleteResult = null;
if (type.ToLower() == "phone")
{
deleteResult = manager.DeleteOilBrandPhonePriorityByPKID(pkid, User.Identity.Name);
}
else if (type.ToLower() == "region")
{
deleteResult = manager.DeleteOilBrandRegionPriorityByPKID(pkid, User.Identity.Name);
}
else
{
return(Json(new { Status = false, Msg = "不明白要删除什么" }));
}
if (deleteResult == null)
{
return(Json(new { Status = false, Msg = "出现未知错误，请查看错误日志" }));
}
else if (deleteResult == true)
{
return(Json(new { Status = true, Msg = "删除成功" }));
}
else
{
return(Json(new { Status = false, Msg = "删除失败" }));
}
}
public JsonResult GetOilBrands()
{
BaoYangManager manager = new BaoYangManager();
var result = manager.SelectAllFuelBrand().Item2;
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult GetAllBrands()
{
string PrimaryParentCategory = "Oil";//类目
var Branddt = BaoYangManager.GetBaoYangCP_Brand(PrimaryParentCategory);
return(Json(new { Status = Branddt != null, Data = Branddt },
JsonRequestBehavior.AllowGet));
}
public JsonResult SelectOilBrandPhonePriority(string phoneNumber, string brand, int pageIndex = 1, int pageSize = 20)
{
var manager = new BaoYangManager();
var result = manager.SelectOilBrandPhonePriority(phoneNumber, brand, pageIndex, pageSize);
var totalPage = (result.Item2 % pageSize == 0) ? ((int)result.Item2 / pageSize) : ((int)result.Item2 / pageSize + 1);
return(Json(new { Status = result.Item1 != null, Data = result.Item1, TotalCount = result.Item2, TotalPage = totalPage },
JsonRequestBehavior.AllowGet));
}
public VendorProductCoverAreaManager()
{
_dbScopeManagerConfig = new DBScopeManager(configConnRo);
_dbScopeManagerConfigRead = new DBScopeManager(configReadConnRo);
_dal = new DalVendorProductCoverArea();
_baoYangManager = new BaoYangManager();
_regionService = new RegionService();
_logger = LogManager.GetLogger(typeof(VendorProductCoverAreaManager));
_vendorProductService = new VendorProductService();
}
/// <summary>
/// 查看操作日志
/// </summary>
/// <param name="mainPackageType"></param>
/// <returns></returns>
public ActionResult GetOprLog(string mainPackageType)
{
if (string.IsNullOrWhiteSpace(mainPackageType))
{
return(Json(new { Status = false, Msg = "未知的查询对象" }, JsonRequestBehavior.AllowGet));
}
var totalCount = 0;
var logType = "BaoYangPackageTypeRelation";
var result = new BaoYangManager().SelectBaoYangOprLog(logType, mainPackageType, string.Empty, (DateTime?)null, (DateTime?)null, 1, 20, out totalCount);
return(Json(new { Status = result.Item1, Data = result.Item2, TotalCount = totalCount }, behavior: JsonRequestBehavior.AllowGet));
}
public JsonResult GetVehicleOprLog(string logType, string identityID, DateTime?startTime, DateTime?endTime, int pageIndex = 1, int pageSize = 20)
{
string operateUser = null;
var totalCount = 0;
if (string.IsNullOrWhiteSpace(logType))
{
return(Json(new { Status = false, Msg = "日志类型不能为空" }, JsonRequestBehavior.AllowGet));
}
var result = new BaoYangManager().SelectBaoYangOprLog(logType, identityID, operateUser, startTime, endTime, pageIndex, pageSize, out totalCount);
return(Json(new { Status = result.Item1, Data = result.Item2, TotalCount = totalCount }, behavior: JsonRequestBehavior.AllowGet));
}
public JsonResult GetBaoYangOprLogByPKID(int pkid)
{
var manager = new BaoYangManager();
var Result = manager.GetBaoYangOprLogByPKID(pkid);
if (Result == null)
{
return(Json(new { Status = false, Msg = "出现未知错误，请查看错误日志" }));
}
else
{
return(Json(new { Status = true, Data = Result }));
}
}
public JsonResult CleanOilBrandPriorityCache(string oilBrandPriorityType)
{
var manager = new BaoYangManager();
var Result = manager.CleanOilBrandPriorityCache(oilBrandPriorityType);
if (Result)
{
return(Json(new { Status = Result, Msg = "缓存清理成功" }));
}
else
{
return(Json(new { Status = Result, Msg = "缓存清理失败" }));
}
}
public JsonResult SelectOilBrandRegionPriority(string brand, int provinceId = -1, int regionId = -1, int pageIndex = 1, int pageSize = 20)
{
#region 直辖市处理
List <int> directCity = new List <int> {
1, 2, 19, 20
};
if (directCity.Contains(provinceId))
{
regionId = (provinceId == regionId) ? regionId : provinceId;
provinceId = 0;
}
#endregion
var manager = new BaoYangManager();
var result = manager.SelectOilBrandRegionPriority(provinceId, regionId, brand, pageIndex, pageSize);
var totalPage = (result.Item2 % pageSize == 0) ? ((int)result.Item2 / pageSize) : ((int)result.Item2 / pageSize + 1);
return(Json(new { Status = result.Item1 != null, Data = result.Item1, TotalCount = result.Item2, TotalPage = totalPage },
JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取用户购买过的机油
/// </summary>
/// <param name="phoneNumber"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public ActionResult SelectOilBrandUserOrder(string phoneNumber, int pageIndex = 1, int pageSize = 20)
{
if (string.IsNullOrWhiteSpace(phoneNumber))
{
return(Json(new { Status = false, Msg = "未知的对象" }, JsonRequestBehavior.AllowGet));
}
var userId = VipBaoYangPackageService.GetUserByMobile(phoneNumber)?.UserId ?? Guid.Empty;
if (userId == Guid.Empty)
{
return(Json(new { Status = false, Msg = "未能找到该手机号对应的用户" }, JsonRequestBehavior.AllowGet));
}
var manager = new BaoYangManager();
var result = manager.SelectOilBrandUserOrder(phoneNumber, userId, pageIndex, pageSize);
return(Json(new { Status = result.Item1 != null, Data = result.Item1, TotalCount = result.Item2 },
JsonRequestBehavior.AllowGet));
}
public JsonResult MultAddOilBrandPhonePriority(List <string> phones, string brand)
{
if (phones == null || !phones.Any() || string.IsNullOrWhiteSpace(brand))
{
return(Json(new { Status = false, Msg = "请填写推荐信息" }));
}
var manager = new BaoYangManager();
List <OilBrandPhonePriorityModel> models = new List <OilBrandPhonePriorityModel>();
var phoneList = phones.Distinct().ToList();
foreach (var phone in phoneList)
{
if (!string.IsNullOrWhiteSpace(phone))
{
OilBrandPhonePriorityModel model = new OilBrandPhonePriorityModel
{
PKID = 0,
PhoneNumber = phone,
Brand = brand
};
bool?isExistVehicle = DALBaoyang.IsRepeatOilBrandPhonePriority(model);
if (isExistVehicle == true)
{
return(Json(new { Status = false, Msg = model.PhoneNumber + "存在重复数据" }));
}
models.Add(model);
}
}
bool?Result = manager.AddOilBrandPhonePriority(models, User.Identity.Name);
if (Result == null)
{
return(Json(new { Status = false, Msg = "出现未知错误，请查看错误日志" }));
}
else if (Result == true)
{
return(Json(new { Status = true, Msg = "添加成功" }));
}
else
{
return(Json(new { Status = false, Msg = "添加失败" }));
}
}
public JsonResult GetAllBrandAndSeries(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 baoYangmanager = new BaoYangManager();
var data = baoYangmanager.GetOilBrandAndSeries();
return(Json(new { status = true, Msg = "成功", Data = data }, JsonRequestBehavior.AllowGet));
}
else
{
var data = manager.GetAllBrandAndSeries(partName, category);
return(Json(new { status = true, Msg = "成功", Data = data }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 清除保养活动地区配置服务缓存
/// </summary>
/// <param name="regionIds"></param>
/// <returns></returns>
public bool CleanBaoYangActivityRegionCache(List <int> regionIds)
{
var result = true;
try
{
if (regionIds != null && regionIds.Any())
{
var keyPrefix = "BaoYangActivityIdForRegion/";
var manager = new BaoYangManager();
var keys = regionIds.Select(s => $"{keyPrefix}{s}").ToList();
result = manager.CleanBaoYangCaches(keys);
}
}
catch (Exception ex)
{
result = false;
Logger.Error("CleanBaoYangActivityRegionCache", ex);
}
return(result);
}
/// <summary>
/// 清除保养活动车型配置服务缓存
/// </summary>
/// <param name="vehicleIds"></param>
/// <returns></returns>
public bool CleanBaoYangActivityVehicleCache(List <string> vehicleIds)
{
var result = true;
try
{
if (vehicleIds != null && vehicleIds.Any())
{
var keyPrefix = "BaoYangActivityIdForVehicle/";
var manager = new BaoYangManager();
var keys = vehicleIds.Select(s => $"{keyPrefix}{s}").ToList();
result = manager.CleanBaoYangCaches(keys);
}
}
catch (Exception ex)
{
result = false;
Logger.Error("CleanBaoYangActivityVehicleCache", ex);
}
return(result);
}
/// <summary>
/// 清除机油粘度优先级配置服务缓存
/// </summary>
/// <param name="regionIds"></param>
/// <returns></returns>
public bool RemoveOilViscosityPriorityConfigCache(string configType, string originViscosity)
{
var result = false;
try
{
if (!string.IsNullOrWhiteSpace(configType) && !string.IsNullOrWhiteSpace(originViscosity))
{
var cacheKey = "BaoYangOilViscosityPriorityConfig/{0}/{1}";
var manager = new BaoYangManager();
var key = string.Format(cacheKey, configType, originViscosity);
result = manager.CleanBaoYangCaches(new List <string> {
key
});
}
}
catch (Exception ex)
{
result = false;
Logger.Error("RemoveOilViscosityPriorityConfigCache", ex);
}
return(result);
}
/// <summary>
/// 清除保养活动配置缓存
/// </summary>
/// <param name="activityNum"></param>
/// <returns></returns>
public bool CleanBaoYangActivitySettingCache(string activityNum)
{
var result = true;
try
{
if (!string.IsNullOrWhiteSpace(activityNum))
{
var keyPrefix = "BaoYangActivitySetting/";
var manager = new BaoYangManager();
var keys = new List <string>()
{
$"{keyPrefix}{activityNum}"
};
result = manager.CleanBaoYangCaches(keys);
}
}
catch (Exception ex)
{
result = false;
Logger.Error("CleanBaoYangActivitySettingCache", ex);
}
return(result);
}
/// <summary>
/// 获取保养关联项目配置
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult GetBaoYangActivitySettingItemById(int id = 0)
{
if (id < 1)
{
return(Json(new { Status = false, Msg = "未知的对象" }, JsonRequestBehavior.AllowGet));
}
var result = BaoYangActivitySettingManager.GetBaoYangActivitySettingItemById(id);
List <BaoYangActivityRelevance> brandList = null;
List <BaoYangActivityRelevance> seriesList = null;
Dictionary <string, List <string> > brandWithSeries = null;
if (result != null && !string.IsNullOrEmpty(result.ServicePackagesType) &&
!string.IsNullOrEmpty(result.ServiceCatalog))
{
switch (result.ServicePackagesType)
{
case "ffdyn":
brandList = BaoYangActivitySettingManager.GetRelevanceBrand("Dynamo");
seriesList = BaoYangActivitySettingManager.GetRelevanceSeries("Dynamo");
break;
case "dyn":
brandList = BaoYangActivitySettingManager.GetRelevanceBrand("Dynamo");
seriesList = BaoYangActivitySettingManager.GetRelevanceSeries("Dynamo");
break;
case "ys":
brandList = BaoYangActivitySettingManager.GetRelevanceBrand("Wiper");
seriesList = BaoYangActivitySettingManager.GetRelevanceSeries("Wiper");
break;
case "scp":
brandList = BaoYangActivitySettingManager.GetRelevanceBrand("BrakePad");
seriesList = BaoYangActivitySettingManager.GetRelevanceSeries("BrakePad");
break;
case "scpan":
brandList = BaoYangActivitySettingManager.GetRelevanceBrand("BrakeDisc");
seriesList = BaoYangActivitySettingManager.GetRelevanceSeries("BrakeDisc");
break;
default:
if (string.Equals(result.ServiceCatalog, "Oil", StringComparison.OrdinalIgnoreCase))
{
brandWithSeries = new BaoYangManager().GetOilBrandAndSeries();
}
else
{
brandList = BaoYangActivitySettingManager.GetRelevanceBrand(result.ServiceCatalog);
seriesList = BaoYangActivitySettingManager.GetRelevanceSeries(result.ServiceCatalog);
}
break;
}
}
return(Json(new
{
Status = result != null,
Data = result,
BrandList = brandList?.Select(s => s.Brand)?.Distinct()?.ToList(),
SeriesList = seriesList?.Select(s => s.Series)?.Distinct()?.ToList(),
BrandWithSeries = brandWithSeries
}, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取机油品牌系列
/// </summary>
/// <returns></returns>
public ActionResult GetOilBrandAndSeries()
{
var result = new BaoYangManager().GetOilBrandAndSeries();
return(Json(new { Status = result != null, Data = result }, JsonRequestBehavior.AllowGet));
}
public ActionResult WebSiteHomeIndex()
{
var r = WebSiteHomeAdManager.SelectAllAdDetail("Home_");
return(View(Tuple.Create(r, BaoYangManager.GetBaoyangIndexConfigItemList())));
}
/// <summary>
/// 导入数据
/// </summary>
/// <returns></returns>
public ActionResult ImportBaoYangBatteryCoverArea()
{
var list = new List <BaoYangBatteryCoverArea>();
#region 验证文件
var files = Request.Files;
if (files == null || files.Count <= 0)
{
return(Json(new { status = false, msg = "请先选择文件上传" }));
}
var file = files[0];
if (file.ContentLength > 200 * 1024)
{
return(Json(new { Status = false, Msg = "文件大小不得超过200KB(不同品牌分批上传)" }));
}
if (file.ContentType != "application/vnd.ms-excel" &&
file.ContentType != "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
{
return(Json(new { status = false, msg = "文件格式不正确, 请上传Excel文件" }));
}
#endregion
var stream = file.InputStream;
var buffer = new byte[stream.Length];
stream.Read(buffer, 0, buffer.Length);
var workBook = new XSSFWorkbook(new MemoryStream(buffer));
var sheet = workBook.GetSheetAt(0);
#region 读取验证excel信息
var titleRow = sheet.GetRow(sheet.FirstRowNum);
var cellNum = titleRow.FirstCellNum;
if (titleRow.GetCell(cellNum++)?.StringCellValue != "品牌" ||
titleRow.GetCell(cellNum++)?.StringCellValue != "省份" ||
titleRow.GetCell(cellNum++)?.StringCellValue != "城市" ||
titleRow.GetCell(cellNum++)?.StringCellValue != "线上展示" ||
titleRow.GetCell(cellNum++)?.StringCellValue != "线下展示" ||
titleRow.GetCell(cellNum++)?.StringCellValue != "是否隐藏")
{
return(Json(new { status = false, msg = "导入模板不正确，请用正确的模板导入!" }));
}
Func <ICell, string> getStringValueFunc = cell =>
{
if (cell != null)
{
if (cell.CellType == CellType.Numeric)
{
return(DateUtil.IsCellDateFormatted(cell) ?
cell.DateCellValue.ToString("yyyy-MM-dd HH:mm:ss.fff") :
cell.NumericCellValue.ToString());
}
return(cell.StringCellValue?.Trim());
}
return(null);
};
Func <string, bool> getBooleanFunc = input =>
{
return("1".Equals(input) || "是".Equals(input) || "true".Equals(input, StringComparison.OrdinalIgnoreCase));
};
var msgs = new List <string>();
for (var rowIndex = sheet.FirstRowNum + 1; rowIndex <= sheet.LastRowNum; rowIndex++)
{
var row = sheet.GetRow(rowIndex);
if (row != null)
{
var cellIndex = row.FirstCellNum;
var brand = getStringValueFunc(row.GetCell(cellIndex++));
var province = getStringValueFunc(row.GetCell(cellIndex++));
var city = getStringValueFunc(row.GetCell(cellIndex++));
var online = getStringValueFunc(row.GetCell(cellIndex++));
var uShop = getStringValueFunc(row.GetCell(cellIndex++));
var disabled = getStringValueFunc(row.GetCell(cellIndex++));
if (!string.IsNullOrEmpty(brand) && !string.IsNullOrEmpty(city) && !string.IsNullOrEmpty(province))
{
var onlineChannel = getBooleanFunc(online) ? OnlineChannel : string.Empty;
var uShopChannel = getBooleanFunc(uShop) ? UShopChannel : string.Empty;
var channels = $"{OnlineChannel},{uShopChannel}".Trim(',');
var item = new BaoYangBatteryCoverArea
{
PKID = rowIndex,
Brand = brand,
ProvinceName = province,
CityName = city,
IsEnabled = !getBooleanFunc(disabled),
Channels = channels,
};
var existsItem = list.FirstOrDefault(x =>
x.Brand == item.Brand &&
x.ProvinceName == item.ProvinceName &&
x.CityName == item.CityName
);
if (existsItem != null)
{
msgs.Add($"第{existsItem.PKID}和{item.PKID}行数据重复");
}
else
{
list.Add(item);
}
}
}
}
if (!list.Any())
{
return(Json(new { status = false, msg = "导入数据不能为空!" }));
}
if (msgs.Any())
{
return(Json(new { status = false, msg = string.Join(Environment.NewLine, msgs) }));
}
#endregion
#region 填充核对地区信息
var provinceNames = list.Select(x => x.ProvinceName).Distinct().ToList();
var regions = provinceNames.Select(p => _batteryManager.GetRegionByRegionName(p)).ToList();
list.ForEach(x =>
{
var region = regions.FirstOrDefault(r => r.ProvinceName == x.ProvinceName);
if (region != null)
{
//直辖市
var city = region.IsMunicipality ? region : region.ChildRegions?.FirstOrDefault(cr => cr.CityName == x.CityName);
if (city != null && city.RegionName == x.CityName)
{
x.CityId = city.RegionId;
x.ProvinceId = city.ProvinceId;
}
}
});
var indexs = list.Where(x => x.ProvinceId <= 0 || x.CityId <= 0).Select(x => x.PKID).ToList();
if (indexs.Any())
{
return(Json(new { status = false, msg = $"第{string.Join(",", indexs)}行地区信息有误(直辖市只支持到市), 请核对" }));
}
#endregion
#region 蓄电池品牌验证
var byManager = new BaoYangManager();
var brands = _batteryManager.GetBatteryBrands();
var ids = list.Where(x => !brands.Contains(x.Brand)).Select(x => x.PKID);
if (ids.Any())
{
return(Json(new { status = false, msg = $"第{string.Join(",", ids)}行蓄电池品牌不合法" }));
}
#endregion
bool result = _batteryManager.BatchUpdateBaoYangBatteryCoverArea(list);
return(Json(new { status = result }));
}
