public JsonResult GetLimitAreaSaleCity()
{
Tuple <int, List <LimitSaleRegionModel> > result2;
var municipalit = new[] { "上海市", "北京市", "天津市", "重庆市" };
var dbresult = LimitAreaSaleManager.SelectRegions();
var result = new List <LimitSaleRegionModel>();
foreach (var province in dbresult)
{
if (municipalit.Contains(province.RegionName))
{
var regionModel = new LimitSaleRegionModel()
{
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 LimitSaleRegionModel()
{
ProvinceId = province.PKID,
ProvinceName = province.RegionName,
CityId = city.PKID,
CityName = city.RegionName
};
result.Add(regionModel);
}
}
}
var tableData = LimitAreaSaleManager.SelectLimitAreaSaleCityInfo();
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 LimitSaleRegionModel
{
Pkid = b.Pkid,
//ProductConfigId = limitPkid,
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= KeyWord,
}).Where(r => (r.IsAllowSale == IsAllowSale || IsAllowSale == 2) && (r.ProvinceId == ProvinceId || ProvinceId == 0) && (r.CityId == CityId || CityId == 0)).OrderBy(r => r.Pkid).ToList();
result2 = new Tuple <int, List <LimitSaleRegionModel> >(tempdata.Count, tempdata.Skip(PageSize * (PageIndex - 1)).Take(PageSize).ToList());
return(Json(result2));
// }
}
public JsonResult CityAgingSearch()
{
Tuple <int, List <CityAreaAgingModel> > result2;
var municipalit = new[] { "上海市", "北京市", "天津市", "重庆市" }; //4个直辖市
var dbresult = LimitAreaSaleManager.SelectRegions();
var result = new List <LimitSaleRegionModel>();
foreach (var province in dbresult)
{
if (municipalit.Contains(province.RegionName))
{
var regionModel = new LimitSaleRegionModel()
{
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 LimitSaleRegionModel()
{
ProvinceId = province.PKID,
ProvinceName = province.RegionName,
CityId = city.PKID,
CityName = city.RegionName
};
result.Add(regionModel);
}
}
}
var tableData = CityAgingManage.SelectCityAgingInfo();
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 CityAreaAgingModel
{
PKid = b?.PKid ?? -1, //PKid
ProvinceId = a.ProvinceId,
ProvinceName = a.ProvinceName,
CityId = a.CityId,
CityName = a.CityName,
IsShow = b?.IsShow ?? 1, // 1 时效性 默认打开
Title = b?.Title ?? "",
Content = b?.Content ?? ""
}).Where(
r => (r.ProvinceId == ProvinceId || ProvinceId == 0) && (r.CityId == CityId || CityId == 0))
.OrderBy(r => r.CityId).ToList();
result2 = new Tuple <int, List <CityAreaAgingModel> >(tempdata.Count,
tempdata.Skip(PageSize * (PageIndex - 1)).Take(PageSize).ToList());
return(Json(result2));
}
public JsonResult GetLimitAreaSalePid()
{
Tuple <int, List <LimitAreaSaleModel> > result;
if (!string.IsNullOrEmpty(KeyWord))
{
result = new Tuple <int, List <LimitAreaSaleModel> >(1, LimitAreaSaleManager.GetProductByPid(KeyWord));
}
else
{
var db = LimitAreaSaleManager.GetLimitAreaSalePidList(PageSize, PageIndex, KeyWord, IsLimit);
result = new Tuple <int, List <LimitAreaSaleModel> >(db.Select(r => r.TotalCount).FirstOrDefault(), db);
}
return(Json(result));
}
public JsonResult SelectAllProvince()
{
var result = new List <LimitSaleRegionModel>();
var dbresult = LimitAreaSaleManager.SelectRegions();
foreach (var province in dbresult)
{
var regionModel = new LimitSaleRegionModel()
{
ProvinceId = province.PKID,
ProvinceName = province.RegionName,
CityId = province.PKID,
CityName = province.RegionName
};
result.Add(regionModel);
}
return(Json(result));
}
public JsonResult SaveLimitAreaSalePid(string pid, int isLimit)
{
var result = LimitAreaSaleManager.SaveLimitAreaSalePid(pid, isLimit, User.Identity.Name);
if (result)
{
return(Json(new
{
status = 1
}));
}
else
{
return(Json(new
{
status = 0
}));
}
}
public JsonResult SaveLimitAreaSaleCity(int productConfigId, int cityId, string cityName, int isAllowSale, int warehouseId, string warehouseName, int supplierId, string supplierName, string muticityCheckedIds)
{
bool result = true;
var warehouses = LimitAreaSaleManager.SelectWarehouse();
warehouseName = warehouses.Where(r => r.WarehouseId == warehouseId).Select(r => r.WarehouseName).FirstOrDefault();
var suppliers = LimitAreaSaleManager.SelectSupplier();
supplierName = suppliers.Where(r => r.SupplierId == supplierId).Select(r => r.SupplierName).FirstOrDefault();
if (string.IsNullOrEmpty(muticityCheckedIds))
{
result = LimitAreaSaleManager.SaveLimitAreaSaleCity(productConfigId, cityId, cityName, isAllowSale,
warehouseId, warehouseName, supplierId, supplierName, User.Identity.Name);
}
else
{
//批量新增
var list = muticityCheckedIds.Split(',').ToList();
foreach (var item in list)
{
cityId = Convert.ToInt32(item.Split(';')[0]);
cityName = item.Split(';')[1];
result = result && LimitAreaSaleManager.SaveLimitAreaSaleCity(productConfigId, cityId, cityName, isAllowSale,
warehouseId, warehouseName, supplierId, supplierName, User.Identity.Name);
}
}
if (result)
{
return(Json(new
{
status = 1
}));
}
else
{
return(Json(new
{
status = 0
}));
}
}
public JsonResult Refreshcache(string pid)
{
var result = LimitAreaSaleManager.Refreshcache(new List <string> {
pid
});
if (result)
{
return(Json(new
{
status = 1
}, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new
{
status = 0
}, JsonRequestBehavior.AllowGet));
}
}
public ActionResult SelectWarehouse()
{
var result = LimitAreaSaleManager.SelectWarehouse();
return(Json(result));
}
public ActionResult SelectSupplier()
{
var result = LimitAreaSaleManager.SelectSupplier();
return(Json(result));
}