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