public static List <LimitAreaSaleModel> GetProductByPid(string keyWord)
{
List <LimitAreaSaleModel> result = null;
try
{
result = DalLimitAreaSale.GetProductByPid(keyWord).ToList();
}
catch (Exception ex)
{
logger.Error(ex.Message, ex);
}
return(result);
}
public static List <LimitAreaSaleModel> GetLimitAreaSalePidList(int pageIndex, int pageSize, string keyWord, int isLimit)
{
List <LimitAreaSaleModel> result = null;
try
{
result = DalLimitAreaSale.GetLimitAreaSalePidList(pageIndex, pageSize, keyWord, isLimit).ToList();
}
catch (Exception ex)
{
logger.Error(ex.Message, ex);
}
return(result);
}
public static bool SaveLimitAreaSaleCity(int productConfigId, int cityId, string cityName, int isAllowSale, int?warehouseId, string warehouseName, int?supplierId, string supplierName, string user = null)
{
bool result = false;
try
{
var beforvalue = DalLimitAreaSale.GetLimitAreaSaleCityConfigLimit(productConfigId, cityId);
var dbresult = DalLimitAreaSale.SaveLimitAreaSaleCity(productConfigId, cityId, cityName, isAllowSale,
warehouseId, warehouseName, supplierId, supplierName);
result = dbresult > 0;
var oprLog = new FlashSaleProductOprLog
{
OperateUser = ThreadIdentity.Operator.Name,
CreateDateTime = DateTime.Now,
BeforeValue = JsonConvert.SerializeObject(beforvalue),
AfterValue = JsonConvert.SerializeObject(new SimpleLimitAreaSaleCityModel()
{
CityId = cityId,
CityName = cityName,
IsAllowSale = isAllowSale,
WarehouseId = warehouseId,
WarehouseName = warehouseName,
SupplierId = supplierId,
SupplierName = supplierName
}),
LogType = "LimitAreaCity",
LogId = productConfigId + "|" + cityId,
Operation = "修改地区限售"
};
LoggerManager.InsertLog("LimitAreaOprLog", oprLog);
}
catch (Exception ex)
{
logger.Error(ex.Message, ex);
}
return(result);
}
public static bool SaveLimitAreaSalePid(string pid, int isLimit, string user)
{
var bResult = true;
try
{
var beforvalue = DalLimitAreaSale.GetLimitAreaSaleProductConfigLimit(pid);
var result1 = DalLimitAreaSale.SaveLimitAreaSalePid(pid, isLimit);
if (result1 <= 0)
{
return(false);
}
var oprLog = new FlashSaleProductOprLog
{
OperateUser = ThreadIdentity.Operator.Name,
CreateDateTime = DateTime.Now,
BeforeValue = beforvalue == null?JsonConvert.SerializeObject(null) :
JsonConvert.SerializeObject(new SimpleLimitAreaSaleModel()
{
Pid = pid,
IsLimit = beforvalue.Value,
}),
AfterValue = JsonConvert.SerializeObject(new SimpleLimitAreaSaleModel()
{
Pid = pid,
IsLimit = isLimit,
}),
LogType = "LimitAreaPid",
LogId = pid,
Operation = beforvalue == null? "新增产品限售": "修改产品限售"
};
LoggerManager.InsertLog("LimitAreaOprLog", oprLog);
var tableData = SelectLimitAreaSaleCityInfo();
if (!tableData.Any())
{
var municipalit = new[] { "上海市", "北京市", "天津市", "重庆市" };
var dbresult = LimitAreaSaleManager.SelectRegions();
var result = new List <LimitAreaSaleCityModel>();
foreach (var province in dbresult)
{
if (municipalit.Contains(province.RegionName))
{
var regionModel = new LimitAreaSaleCityModel()
{
ProvinceId = province.PKID,
ProvinceName = province.RegionName,
CityId = province.PKID,
CityName = province.RegionName
};
result.Add(regionModel);
}
else
{
foreach (var city in province.ChildrenRegion)
{
var regionModel = new LimitAreaSaleCityModel()
{
ProvinceId = province.PKID,
ProvinceName = province.RegionName,
CityId = city.PKID,
CityName = city.RegionName
};
result.Add(regionModel);
}
}
}
var tempdata = (from a in result
join b in tableData on a.CityId equals b.CityId into temp
from b in temp.DefaultIfEmpty()
select new LimitAreaSaleCityModel
{
ProductConfigId = 0,
ProvinceId = a.ProvinceId,
ProvinceName = a.ProvinceName,
CityId = a.CityId,
CityName = a.CityName,
IsAllowSale = b?.IsAllowSale ?? 0,
WarehouseId = b?.WarehouseId,
WarehouseName = b?.WarehouseName,
SupplierId = b?.SupplierId,
SupplierName = b?.SupplierName,
Pid = pid,
}).ToList();
tempdata.ForEach(r =>
{
bResult = bResult &&
SaveLimitAreaSaleCity(r.ProductConfigId, r.CityId, r.CityName, r.IsAllowSale,
r.WarehouseId, r.WarehouseName, r.SupplierId, r.SupplierName);
});
}
}
catch (Exception ex)
{
logger.Error(ex.Message, ex);
}
return(bResult);
}
public static List <LimitAreaSaleCityModel> SelectLimitAreaSaleCityInfo()
{
return(DalLimitAreaSale.SelectLimitAreaSaleCityInfo());
}
public static List <LimitAreaSaleCityModel> SelectLimitAreaSaleCityInfoByPid(string pid)
{
return(DalLimitAreaSale.SelectLimitAreaSaleCityInfoByPid(pid));
}
public static int SelectLimitAreaSaleByPid(string pid)
{
return(DalLimitAreaSale.SelectLimitAreaSaleByPid(pid));
}
public static IEnumerable <SimpleRegionModel> SelectRegions()
{
return(SimpleRegionModel.Parse(DalLimitAreaSale.SelectRegions()));
}
