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 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));
}
