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