/// <summary> /// 获取转校订单信息 /// <para>作 者:zhiwei.Tang</para> /// <para>创建时间:2018-11-13</para> /// </summary> /// <param name="schoolId">校区Id</param> /// <param name="request">查询参数</param> /// <param name="studentIds">一组学生Id</param> /// <returns>转校订单信息列表</returns> public PageResult <TblOdrRefundOrder> GetPageResult(string schoolId, ChangeSchoolOrderListSearchRequest request, List <long> studentIds) { var queryable = base.LoadQueryable().Where(x => x.SchoolId == schoolId); if (request.OrderStatus.HasValue) { int orderStatus = (int)request.OrderStatus.Value; queryable = queryable.Where(x => x.OrderStatus == orderStatus); } if (request.STime.HasValue) { queryable = queryable.Where(x => x.CreateTime >= request.STime.Value); } if (request.ETime.HasValue) { request.ETime = request.ETime.Value.AddDays(1); queryable = queryable.Where(x => x.CreateTime <= request.ETime.Value); } if (studentIds.Any()) { queryable = queryable.Where(x => studentIds.Contains(x.StudentId)); } queryable = queryable.OrderByDescending(x => x.CreateTime); return(queryable.ToPagerSource(request.PageIndex, request.PageSize)); }
/// <summary> /// 条件组合查询器 /// <para>作 者:zhiwei.Tang</para> /// <para>创建时间:2019-02-20</para> /// </summary> /// <param name="request">转校列表查询条件</param> /// <param name="studentIds">学生Id</param> /// <param name="queryable">订单列表</param> /// <returns>转校订单列表</returns> private static IQueryable <ViewChangeSchooolOrder> ViewChangeSchooolOrders( ChangeSchoolOrderListSearchRequest request, ICollection <long> studentIds, IQueryable <ViewChangeSchooolOrder> queryable) { if (request.OrderStatus.HasValue) { int orderStatus = (int)request.OrderStatus.Value; queryable = queryable.Where(x => x.OrderStatus == orderStatus); } if (request.STime.HasValue) { queryable = queryable.Where(x => x.CreateTime >= request.STime.Value); } if (request.ETime.HasValue) { request.ETime = request.ETime.Value.AddDays(1); queryable = queryable.Where(x => x.CreateTime <= request.ETime.Value); } if (!string.IsNullOrWhiteSpace(request.Key)) { queryable = queryable.Where(x => studentIds.Contains(x.StudentId)); } queryable = queryable.OrderByDescending(x => x.CreateTime); return(queryable); }
/// <summary> /// 转出列表 /// <para>作 者:zhiwei.Tang</para> /// <para>创建时间:2019-02-20</para> /// </summary> /// <returns>转校订单信息列表</returns> public PageResult <ViewChangeSchooolOrder> GetChangeOutList(string schoolId, ChangeSchoolOrderListSearchRequest request, List <long> studentIds) { var queryable = this.GetTransferOrderQueryable().Where(x => x.OutSchoolId == schoolId); queryable = ViewChangeSchooolOrders(request, studentIds, queryable); return(queryable.ToPagerSource(request.PageIndex, request.PageSize)); }
/// <summary> /// 转入列表 /// <para>作 者:zhiwei.Tang</para> /// <para>创建时间:2019-02-20</para> /// </summary> /// <returns>转校订单信息列表</returns> public PageResult <ViewChangeSchooolOrder> GetChangeInList(string schoolId, ChangeSchoolOrderListSearchRequest request, List <long> studentIds) { int confirm = (int)OrderStatus.Confirm; //待接收 int refuse = (int)OrderStatus.Refuse; //已拒绝 int paid = (int)OrderStatus.Paid; //已接收 var queryable = this.GetTransferOrderQueryable() .Where(x => x.InSchoolId == schoolId) .Where(x => x.OrderStatus == confirm || x.OrderStatus == refuse || x.OrderStatus == paid); queryable = ViewChangeSchooolOrders(request, studentIds, queryable); return(queryable.ToPagerSource(request.PageIndex, request.PageSize)); }
public PageResult <ChangeSchoolOrderListResponse> GetChangeInList([FromQuery] ChangeSchoolOrderListSearchRequest request) { return(ChangeSchoolOrderService.GetChangeInList(base.SchoolId, request)); }