/// <summary>
/// 获取地区门店采购统计
/// </summary>
/// <param name="request"></param>
/// <param name="shops"></param>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <returns></returns>
public async Task <Tuple <IEnumerable <DbStatisticsPurchaseShopView>, int> > GetStatisticsPurchaseShopByShop(
RequestPagingBase request, string shops,
DateTime startTime, DateTime endTime)
{
return(await this._statisticsPurchaseGoodsDal.GetStatisticsPurchaseShopByShop(request, shops, startTime,
endTime));
}
/// <summary>
/// 获取门店零售统计
/// </summary>
/// <param name="request"></param>
/// <param name="shops"></param>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <returns></returns>
public async Task <Tuple <IEnumerable <DbStatisticsRetailViewShop>, int> > GetStatisticsRetailShopByShop(
RequestPagingBase request, string shops,
DateTime startTime, DateTime endTime)
{
return(await this.ExecutePageAsync <DbStatisticsRetailViewShop>(request.PageCurrent, request.PageSize,
$"ShopId,ShopName,Street AS AreaId,sum(TotalWeight) AS TotalWeight,sum(TotalContentsWeight) AS TotalContentsWeight",
"statisticsretailgoods",
$"ShopId IN ({shops}) AND StartTime >= '{startTime.ToString("yyyy-MM-dd HH:mm:ss")}' AND EndTime <= '{endTime.ToString("yyyy-MM-dd HH:mm:ss")}' GROUP BY Street,ShopId,ShopName",
"ShopId desc"));
}
/// <summary>
/// 获取地区门店的库存统计
/// </summary>
/// <param name="request"></param>
/// <param name="shops"></param>
/// <returns></returns>
public async Task <Tuple <IEnumerable <DbStatisticsStockViewShop>, int> > GetStatisticsStockShopByShop(RequestPagingBase request,
string shops)
{
return(await this._statisticsStockGoodsDal.GetStatisticsStockShopByShop(request, shops));
}
/// <summary>
/// 获取地区门店零售统计
/// </summary>
/// <param name="request"></param>
/// <param name="areaIds"></param>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <param name="level"></param>
/// <returns></returns>
public async Task <Tuple <IEnumerable <DbStatisticsRetailViewShop>, int> > GetStatisticsRetailShop(RequestPagingBase request,
string areaIds,
DateTime startTime,
DateTime endTime, string level)
{
return(await this._statisticsRetailGoodsDal.GetStatisticsRetailShop(request, areaIds, startTime, endTime, level));
}
/// <summary>
/// 获取地区门店零售统计
/// </summary>
/// <param name="request"></param>
/// <param name="areaIds"></param>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <param name="level"></param>
/// <returns></returns>
public async Task <Tuple <IEnumerable <DbStatisticsRetailViewShop>, int> > GetStatisticsRetailShop(RequestPagingBase request, string areaIds, DateTime startTime,
DateTime endTime, string level)
{
var areaLevelName = CommonLib.GetAreaLevelFieldName(level);
return(await this.ExecutePageAsync <DbStatisticsRetailViewShop>(request.PageCurrent, request.PageSize,
$"ShopId,ShopName,{areaLevelName} AS AreaId,sum(TotalWeight) AS TotalWeight,sum(TotalContentsWeight) AS TotalContentsWeight",
"statisticsretailgoods",
$"{areaLevelName} IN ({areaIds}) AND StartTime >= '{startTime.ToString("yyyy-MM-dd HH:mm:ss")}' AND EndTime <= '{endTime.ToString("yyyy-MM-dd HH:mm:ss")}' GROUP BY {areaLevelName},ShopId,ShopName",
"ShopId desc"));
}
/// <summary>
/// 获取地区门店的库存统计
/// </summary>
/// <param name="request"></param>
/// <param name="shops"></param>
/// <returns></returns>
public async Task <Tuple <IEnumerable <DbStatisticsStockViewShop>, int> > GetStatisticsStockShopByShop(RequestPagingBase request,
string shops)
{
return(await this.ExecutePageAsync <DbStatisticsStockViewShop>(request.PageCurrent, request.PageSize,
$"ShopId,ShopName,Street AS AreaId,sum(TotalWeight) AS TotalWeight,sum(TotalContentsWeight) AS TotalContentsWeight",
"statisticsstockgoods",
$"ShopId IN ({shops}) and TotalCount < 5000 GROUP BY Street,ShopId,ShopName",
"ShopId desc"));
}
/// <summary>
/// 获取地区门店的库存统计
/// </summary>
/// <param name="request"></param>
/// <param name="areaIds"></param>
/// <param name="level"></param>
/// <returns></returns>
public async Task <Tuple <IEnumerable <DbStatisticsStockViewShop>, int> > GetStatisticsStockShop(RequestPagingBase request,
string areaIds, string level)
{
var areaLevelName = CommonLib.GetAreaLevelFieldName(level);
return(await this.ExecutePageAsync <DbStatisticsStockViewShop>(request.PageCurrent, request.PageSize,
$"ShopId,ShopName,{areaLevelName} AS AreaId,sum(TotalWeight) AS TotalWeight,sum(TotalContentsWeight) AS TotalContentsWeight",
"statisticsstockgoods",
$"{areaLevelName} IN ({areaIds}) and TotalCount < 5000 GROUP BY {areaLevelName},ShopId,ShopName",
"ShopId desc"));
}
