/// <summary> /// 处理请求参数 /// </summary> /// <param name="httpContext"></param> /// <param name="request"></param> private bool HandleRequest(HttpContext httpContext, ReceiptInLogPageRequest request) { if (request.StartTime != null) { request.StartTimeStamp = request.StartTime.Value.ToTimestamp(); } if (request.EndTime != null) { request.EndTimeStamp = request.EndTime.Value.Date.AddDays(1).AddSeconds(-1).ToTimestamp(); } return(ComLib.HandleRequest(httpContext, request)); }
public async Task <ResponsePagingBase> GetReceiptInLog([FromBody] ReceiptInLogPageRequest request) { try { var action = new GetReceiptInLogAction(_goodsBll); return(await action.ProcessAction(HttpContext, 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 <Tuple <IEnumerable <ReceiptInLogView>, int> > GetReceiptInLogPage(ReceiptInLogPageRequest request) { return(await this.ExecutePageAsync <ReceiptInLogView>(request.PageCurrent, request.PageSize, "h.shop_name as ShopName,g.supplier_name as SupplierName,c.brand_name as BrandName,b.goods_name as GoodsName,b.goods_spec as GoodsSpec,d.goods_category_name as GoodsCategoryName,a.qty as Qty,e.unit_name as UnitName,f.in_date as InDate,f.in_code as InCode" , "po_in_receipt_detail a inner join sys_goods b on a.goods_id = b.goods_id inner join base_brand c on b.brand_id = c.brand_id inner join sys_goods_category d on b.goods_class_id = d.goods_category_id inner join sys_unit e on a.unit_id = e.unit_id inner join po_in_receipt f on a.in_id = f.in_id inner join base_supplier g on f.in_offer_id = g.supplier_id inner join cm_shop h on f.user_shop_id = h.shop_id", request.GetQuerySql(), " f.in_date desc")); }
/// <summary> /// 分页获取商品销售记录信息 /// </summary> /// <param name="httpContext"></param> /// <param name="request"></param> /// <returns></returns> public async Task <ResponsePagingBase> ProcessAction(HttpContext httpContext, ReceiptInLogPageRequest request) { if (!HandleRequest(httpContext, request)) { return(ResponsePagingBase.Success(new List <ReceiptInLogView>(), 0)); } var result = await _goodsBll.GetReceiptInLogPage(request); result.Item1.ToList().ForEach(p => p.CreateTime = p.InDate.ToDateTimeFromTimeStamp()); return(ResponsePagingBase.Success(result.Item1, result.Item2)); }
/// <summary> /// 查询商品采购记录 /// </summary> /// <param name="request"></param> /// <returns></returns> public async Task <Tuple <IEnumerable <ReceiptInLogView>, int> > GetReceiptInLogPage(ReceiptInLogPageRequest request) { return(await _goodsDal.GetReceiptInLogPage(request)); }