/// <summary> /// 根据条件获取报班列表 /// <para>作 者: Huang GaoLiang</para> /// <para>创建时间: 2018-11-23</para> /// </summary> /// <param name="searcher">查询条件</param> /// <returns>返回分页列表</returns> public PageResult <ViewOdrEnrollOrder> GetOrderList(EnrollOrderListSearchRequest searcher) { var querySql = $@"SELECT o.EnrollOrderId, o.OrderNo, o.OrderNewType, o.PayType as PayTypeId, o.CreateName, o.PayAmount, o.OrderStatus as OrderStatusId, s.StudentId, s.StudentName, s.ContactPersonMobile, o.SchoolId, o.UseBalance, o.TotalTradeAmount, o.CreateTime FROM dbo.TblOdrEnrollOrder o LEFT JOIN dbo.TblCstStudent s ON s.StudentId = o.StudentId WHERE o.SchoolId = @SchoolId"; var orderListQuery = base.CurrentContext.ViewOdrEnrollOrder.FromSql(querySql, new object[] { new SqlParameter("@SchoolId", searcher.SchoolId), }); var query = orderListQuery .WhereIf(searcher.OrderStatus != null, x => x.OrderStatusId == (int)searcher.OrderStatus) .WhereIf(searcher.PayType != null && searcher.PayType.Value != PayType.UseBalance, x => x.PayTypeId == (int)searcher.PayType) .WhereIf(searcher.PayType != null && searcher.PayType.Value == PayType.UseBalance, x => x.UseBalance > 0) .WhereIf(searcher.OrderNewType != null, x => x.OrderNewType == (int)searcher.OrderNewType) .WhereIf(searcher.StartTime != null, x => x.CreateTime >= searcher.StartTime) .WhereIf(searcher.EndtTime != null, x => x.CreateTime.AddDays(-1) < searcher.EndtTime) .WhereIf(!string.IsNullOrWhiteSpace(searcher.StudentInfo), x => x.StudentName.Contains(searcher.StudentInfo) || x.ContactPersonMobile.Contains(searcher.StudentInfo)) .WhereIf(!string.IsNullOrWhiteSpace(searcher.Cashier), x => x.CreateName.Contains(searcher.Cashier)) .OrderByDescending(x => x.CreateTime) .ToPagerSource(searcher.PageIndex, searcher.PageSize); return(query); }
public PageResult <EnrollOrderListResponse> GetPageList([FromQuery] EnrollOrderListSearchRequest dto) { dto.SchoolId = base.SchoolId; return(new EnrollOrderService(base.SchoolId).GetPageList(dto)); }