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