/// <summary>
/// 描述：获取退班列表
/// <para>作 者：瞿琦</para>
/// <para>创建时间：2018-11-8</para>
/// </summary>
/// <param name="searcher">列表筛选条件</param>
/// <returns>退班课程明细列表分页</returns>
public PageResult <LeaveClassOrderListResponse> GetLeaveClassOrderList(LeaveClassOrderListSearchRequest searcher)
{
var result = new PageResult <LeaveClassOrderListResponse>();
var query = _viewLeaveClassDetailRepository.Value.GetLeaveClassByRefundOrder(searcher);
result.Data = Mapper.Map <List <LeaveClassOrderListResponse> >(query.Data);
result.CurrentPage = query.CurrentPage;
result.PageSize = query.PageSize;
result.TotalData = query.TotalData;
return(result);
}
/// <summary>
/// 描述：获取报班退费列表
/// <para>作 者：瞿琦</para>
/// <para>创建时间：2018-11-12</para>
/// </summary>
/// <param name="searcher">列表筛选条件</param>
/// <returns>报班退费明细</returns>
public PageResult <ViewLeaveClassDetail> GetLeaveClassByRefundOrder(LeaveClassOrderListSearchRequest searcher)
{
var querySql = $@"select a.RefundOrderId,
a.SchoolId,
a.StudentId,
a.CreateTime as OrderRefundTime,
a.OrderNo,
b.StudentNo,
b.StudentName,
b.LinkMobile,
a.Amount,
c.RefundType,
a.OrderStatus,
b.ContactPersonMobile
from [dbo].[TblOdrRefundOrder] a
left join TblCstStudent b on a.StudentId = b.StudentId
left join TblOdrRefundPay c on a.RefundOrderId = c.RefundOrderId
where a.OrderType=@OrderType
and a.OrderStatus!=@OrderStatus1
and a.OrderStatus!=@OrderStatus2
"; //order 作 者 a.CreateTime desc
var refundOrderListQuery = base.CurrentContext.ViewLeaveClassDetail.FromSql(querySql, new object[]
{
new SqlParameter("@OrderType", (int)OrderTradeType.LeaveClassOrder),
new SqlParameter("@OrderStatus1", (int)OrderStatus.Cancel),
new SqlParameter("@OrderStatus2", (int)OrderStatus.Finish),
});
var query = refundOrderListQuery.WhereIf(!string.IsNullOrWhiteSpace(searcher.SchoolId), x => x.SchoolId.Trim() == searcher.SchoolId.Trim()) //校区
.WhereIf(searcher.OrderStatus != null, x => x.OrderStatus == (int)searcher.OrderStatus) //订单状态
.WhereIf(searcher.RefundBeginDate != null, x => x.OrderRefundTime >= searcher.RefundBeginDate) //退费日期（开始）
.WhereIf(searcher.RefundEndDate != null, x => x.OrderRefundTime <= searcher.RefundEndDate.Value.AddDays(1)) //退费日期（结束）
.WhereIf(!string.IsNullOrWhiteSpace(searcher.KeyWord), x => x.StudentName.Contains(searcher.KeyWord) || x.LinkMobile.Contains(searcher.KeyWord)) //关键字（学生姓名/手机号）
.OrderByDescending(x => x.OrderRefundTime)
.ToPagerSource(searcher.PageIndex, searcher.PageSize);
return(query);
}
public PageResult <LeaveClassOrderListResponse> GetLeaveClassOrderList(long studentId, [FromQuery] LeaveClassOrderListSearchRequest request)
{
request.SchoolId = base.SchoolId;
var service = new LeaveClassOrderService(base.SchoolId, studentId);
var result = service.GetLeaveClassOrderList(request);
return(result);
}
