public LeaveSchoolOrderListResponse GetOrderList([FromQuery] LeaveSchoolOrderListSearchRequest iRequest) { var service = new LeaveSchoolOrderService(base.SchoolId); var leaveSchoolQuery = service.GetOrderList(iRequest); return(leaveSchoolQuery); }
/// <summary> /// 描述:获取休学订单分页列表 /// <para>作者;瞿琦</para> /// <para>创建时间:2019-3-6</para> /// </summary> /// <param name="schoolId">校区Id</param> /// <param name="searcher">列表筛选条件</param> /// <returns>休学订单列表</returns> public PageResult <ViewLeaveSchoolOrder> GetLeaveSchoolOrderList(string schoolId, LeaveSchoolOrderListSearchRequest searcher) { var leaveSchoolQuery = this.QueryLeaveSchoolList(schoolId, searcher) //.WhereIf(searcher.CreateStart.HasValue, x => x.CreateTime >= searcher.CreateStart) //提交时间 开始 //.WhereIf(searcher.CreateEnd.HasValue, x => x.CreateTime <= searcher.CreateEnd.Value.AddDays(1)) //提交时间 结束 //.WhereIf(!string.IsNullOrWhiteSpace(searcher.StudentName),x=>x.StudentName.Contains(searcher.StudentName)) //学生姓名 //.OrderByDescending(x => x.CreateTime) .OrderByDescending(x => x.CreateTime) .ToPagerSource(searcher.PageIndex, searcher.PageSize); return(leaveSchoolQuery); }
/// <summary> /// 描述:基础查询,获取校区的休学信息 /// <para>作者:瞿琦</para> /// <para>创建时间:2019-3-21</para> /// </summary> /// <param name="schoolId">校区Id</param> /// <param name="searcher">列表筛选条件</param> /// <returns>休学列表</returns> private IQueryable <ViewLeaveSchoolOrder> QueryLeaveSchoolList(string schoolId, LeaveSchoolOrderListSearchRequest searcher) { var querySql = $@"select a.RefundOrderId, b.StudentId, StudentNo, StudentName, b.CreateTime, LeaveTime, ResumeTime, TotalRefundLessonCount, b.Amount, Reason from (select * from [TblOdrLeaveSchoolOrder] where SchoolId=@SchoolId ) as a left join TblOdrRefundOrder as b on a.RefundOrderId = b.RefundOrderId left join[TblCstStudent] as c on b.StudentId = c.StudentId"; var leaveSchoolList = base.CurrentContext.ViewLeaveSchoolOrder.FromSql(querySql, new object[] { new SqlParameter("@SchoolId", schoolId.Trim()), }); var leaveSchoolQuery = leaveSchoolList .WhereIf(searcher.CreateStart.HasValue, x => x.CreateTime >= searcher.CreateStart) //提交时间 开始 .WhereIf(searcher.CreateEnd.HasValue, x => x.CreateTime <= searcher.CreateEnd.Value.AddDays(1)) //提交时间 结束 .WhereIf(!string.IsNullOrWhiteSpace(searcher.StudentName), x => x.StudentName.Contains(searcher.StudentName)) //学生姓名 ; return(leaveSchoolQuery); }
/// <summary> /// 描述:获取休学的退费总金额 /// <para>作者:瞿琦</para> /// <para>创建时间:2019-3-21</para> /// </summary> /// <returns></returns> public decimal QueryLeaveSchoolAmount(string schoolId, LeaveSchoolOrderListSearchRequest searcher) { var leaveSchoolAmount = this.QueryLeaveSchoolList(schoolId, searcher).Sum(x => x.Amount); return(leaveSchoolAmount); }
/// <summary> /// 描述:获取休学人数 /// <para>作者:瞿琦</para> /// <para>创建时间:2019-3-21</para> /// </summary> /// <param name="schoolId"></param> /// <param name="searcher">列表筛选条件</param> /// <returns></returns> public int QueryLeaveSchoolCount(string schoolId, LeaveSchoolOrderListSearchRequest searcher) { var leaveSchoolCount = this.QueryLeaveSchoolList(schoolId, searcher).Count(); return(leaveSchoolCount); }