/// <summary>
/// 查询商品销售记录
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public async Task <Tuple <IEnumerable <SaleGoodsLogView>, int> > GetSaleGoodsLogPage(GetSaleGoodsLogPageRequest request)
{
return(await this.ExecutePageAsync <SaleGoodsLogView>(request.PageCurrent, request.PageSize, "d.shop_name as ShopName,e.goods_name as GoodsName,e.goods_spec as GoodsSpec,e.registration_number as RegistrationNumber, b.qty as Qty,c.member_name as MemberName,c.member_tel as MemberTel,a.bill_date as BillDate,a.bill_code as BillCode,c.identification as Identification,f.goods_category_name as GoodsCategoryName,g.unit_name as UnitName",
"so_retail a INNER JOIN so_retail_detail b on a.retail_id=b.bill_id INNER join cm_shop d on a.shop_id=d.shop_id INNER JOIN sys_goods e on b.goods_id=e.goods_id inner join sys_goods_category f on e.goods_class_id = f.goods_category_id inner join sys_unit g on b.unit_id = g.unit_id LEFT JOIN mb_member_info c on a.member_id=c.member_id",
request.GetQuerySql(), "a.bill_date desc"));
}
