public QueryPageModel <DeliveryScopeInfo> GetShopDeliveryScopeAll(ShopDeliveryScopeQuery query)
{
return(new QueryPageModel <DeliveryScopeInfo>()
{
Models = ToWhereDeliveryScope(query).ToList()
});
}
private IQueryable <DeliveryScopeInfo> ToWhereDeliveryScope(ShopDeliveryScopeQuery query)
{
var shopBranchDeliveryScope = Context.DeliveryScopeInfo.Where(p => true);
if (query.ShopBranchId > 0)
{
shopBranchDeliveryScope = Context.DeliveryScopeInfo.Where(p => p.ShopBranchId == query.ShopBranchId);
}
return(shopBranchDeliveryScope);
}
/// <summary>
/// 分页查询门店配送范围
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public QueryPageModel <DeliveryScopeInfo> GetShopDeliveryScope(ShopDeliveryScopeQuery query)
{
int total = 0;
var shopDeliveryScope = ToWhereDeliveryScope(query);
shopDeliveryScope = shopDeliveryScope.GetPage(out total, query.PageNo, query.PageSize, s => s.OrderBy(e => e.Id));
return(new QueryPageModel <DeliveryScopeInfo>()
{
Models = shopDeliveryScope.ToList(), Total = total
});
}
/// <summary>
/// 根据条件删除门店配送范围
/// </summary>
/// <param name="query"></param>
public void DeleteShopDeliveryScope(ShopDeliveryScopeQuery query)
{
var deliveryScope = Context.DeliveryScopeInfo.Where(e => e.ShopBranchId == query.ShopBranchId);
if (deliveryScope == null)
{
throw new Himall.Core.HimallException("未找到门店配送范围，删除失败！");
}
if (query.RegionIdList != null && query.RegionIdList.Count > 0)
{
string deleteIds = string.Join(",", query.RegionIdList.ToArray());
deliveryScope = deliveryScope.Where(e => !deleteIds.Contains(e.RegionId.ToString()));
}
Context.DeliveryScopeInfo.RemoveRange(deliveryScope);
Context.SaveChanges();
}
public static QueryPageModel <DeliveryScope> GetShopDeliveryScopeAll(ShopDeliveryScopeQuery query)
{
var shopDeliveryScopeInfos = _shopBranchService.GetShopDeliveryScopeAll(query);
QueryPageModel <DeliveryScope> shopBranchs = new QueryPageModel <DeliveryScope>
{
Models = shopDeliveryScopeInfos.Models.Select(e => new DeliveryScope
{
FullRegionPath = e.FullRegionPath,
Id = e.Id,
RegionId = e.RegionId,
RegionName = e.RegionName,
ShopBranchId = e.ShopBranchId
}).ToList()
};
return(shopBranchs);
}
/// <summary>
/// 同一门店是否存在相同的区域标识
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public bool ExistsShopDeliveryScope(ShopDeliveryScopeQuery query)
{
return(Context.DeliveryScopeInfo.Any(e => e.ShopBranchId == query.ShopBranchId && e.RegionId == query.RegionId));
}
/// <summary>
/// 是否已存在相同的门店配送范围
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static bool ExistsShopDeliveryScope(ShopDeliveryScopeQuery query)
{
return(_shopBranchService.ExistsShopDeliveryScope(query));
}
/// <summary>
/// 删除门店配送范围
/// </summary>
/// <param name="branchId"></param>
public static void DeleteShopDeliveryScope(ShopDeliveryScopeQuery query)
{
_shopBranchService.DeleteShopDeliveryScope(query);
}
