/// <summary> /// 获取订单交接列表信息 /// <para>作 者:郭伟佳</para> /// <para>创建时间:2018-11-16</para> /// </summary> /// <param name="request">订单已交接查询条件</param> /// <returns>交接记录分页列表</returns> public PageResult <ViewFinOrderHandover> GetOrderHandoverList(OrderHandoverListSearchRequest request) { var result = from a in CurrentContext.TblFinOrderHandover join b in (from d in CurrentContext.TblFinOrderHandoverDetail group d by new { d.OrderHandoverId } into g select new { g.Key.OrderHandoverId, HandoverNumber = g.Count(), HandoverAmount = g.Sum(p => p.PayAmount) }) on a.OrderHandoverId equals b.OrderHandoverId where a.SchoolId == request.SchoolId && (string.IsNullOrEmpty(request.PersonalName) || a.PersonalName.Contains(request.PersonalName)) && (!request.HandoverBeginDate.HasValue || a.HandoverDate.Date >= request.HandoverBeginDate.Value.Date) && (!request.HandoverEndDate.HasValue || a.HandoverDate.Date <= request.HandoverEndDate.Value.Date) orderby a.HandoverDate descending select new ViewFinOrderHandover { OrderHandoverId = a.OrderHandoverId, SchoolId = a.SchoolId, PersonalId = a.PersonalId, Remark = a.Remark, HandoverDate = a.HandoverDate, CreatorId = a.CreatorId, CreatorName = a.CreatorName, PersonalName = a.PersonalName, HandoverAmount = b.HandoverAmount, HandoverNumber = b.HandoverNumber }; return(result.ToPagerSource(request.PageIndex, request.PageSize)); }
/// <summary> /// 获取校区已交接订单列表 /// 只允许查询最多一个月时间段 /// <para>作 者:郭伟佳</para> /// <para>创建时间:2018-11-26</para> /// </summary> /// <param name="request">订单已交接查询条件</param> /// <returns>订单已交接分页列表</returns> public PageResult <OrderHandoverListResponse> GetHandList(OrderHandoverListSearchRequest request) { var result = new PageResult <OrderHandoverListResponse>() { Data = new List <OrderHandoverListResponse>() }; var query = _viewHandoverReqpository.Value.GetOrderHandoverList(request); if (query != null && query.Data != null && query.Data.Count > 0) { result.CurrentPage = query.CurrentPage; result.PageSize = query.PageSize; result.TotalData = query.TotalData; result.Data = Mapper.Map <List <OrderHandoverListResponse> >(query.Data); } return(result); }
public PageResult <OrderHandoverListResponse> GetHandList([FromQuery] OrderHandoverListSearchRequest request) { request.SchoolId = base.SchoolId; return(new OrderHandoverService(base.SchoolId).GetHandList(request)); }