public async Task <ResponsePagingBase> GetSaleGoods([FromBody] GetSaleGoodsPageRequest request)
{
try
{
var action = new GetSaleGoodsAction(_shopBll, _goodsBll);
return(await action.ProcessAction(request));
}
catch (Exception ex)
{
Log.Error(request, ex, this.GetType());
return(new ResponsePagingBase().GetResponseCodeError());
}
}
/// <summary>
/// 分页获取销售商品信息
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public async Task <ResponsePagingBase> ProcessAction(GetSaleGoodsPageRequest request)
{
var shop = await _shopBll.GetShop(request.ShopId);
if (shop == null)
{
return(new ResponsePagingBase().GetResponseError(StatusCode.Shop50001, "门店不存在"));
}
request.OrgId = shop.OrgId;
request.StockId = shop.StockId;
var result = await _goodsBll.GetSaleGoodsPage(request);
return(ResponsePagingBase.Success(await HandleQty(result.Item1.ToList(), shop.StockId), result.Item2));
}
/// <summary>
/// 查询销售商品
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public async Task <Tuple <IEnumerable <SaleGoodsView>, int> > GetSaleGoodsPage(GetSaleGoodsPageRequest request)
{
return(await this.ExecutePageAsync <SaleGoodsView>(request.PageCurrent, request.PageSize, "a.goods_id AS GoodsId,b.goods_category_name as CategoryName,c.brand_name as BrandName,a.goods_name as GoodsName,a.goods_spec as GoodsSpec,a.registration_number as RegistrationNumber,a.registration_holder as RegistrationHolder,u.unit_name as UnitName,0 as Qty",
$"sys_goods a INNER JOIN sys_goods_category b on a.goods_class_id=b.goods_category_id inner join base_brand c on a.brand_id=c.brand_id LEFT join sys_unit u on a.base_unit_id = u.unit_id ", request.GetQuerySql(), "a.created_time desc"));
}
/// <summary>
/// 查询销售商品
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public async Task <Tuple <IEnumerable <SaleGoodsView>, int> > GetSaleGoodsPage(GetSaleGoodsPageRequest request)
{
return(await _goodsDal.GetSaleGoodsPage(request));
}
