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