/// <summary>
/// 获取余额退费明细列表
/// <para>作 者：郭伟佳</para>
/// <para>创建时间：2018-11-17</para>
/// </summary>
/// <param name="request">余额退费请求对象</param>
/// <returns>余额退费信息列表</returns>
public PageResult <ViewBalanceRefundOrder> GetBalanceRefundList(BalanceRefundListSearchRequest request)
{
var result = from a in CurrentContext.TblOdrRefundOrder
join b in CurrentContext.TblOdrRefundPay on a.RefundOrderId equals b.RefundOrderId
join c in CurrentContext.TblCstStudent on a.StudentId equals c.StudentId
let mobile = (c.ContactPersonMobile.IndexOf(",") >= 0 ? c.ContactPersonMobile.Remove(c.ContactPersonMobile.IndexOf(",")) : c.ContactPersonMobile)
where a.SchoolId == request.SchoolId && a.OrderType == (int)OrderTradeType.BalanceOrder &&
(!request.RefundBeginDate.HasValue || a.CreateTime.Date >= request.RefundBeginDate.Value.Date) &&
(!request.RefundEndDate.HasValue || a.CreateTime.Date <= request.RefundEndDate.Value.Date) &&
(string.IsNullOrEmpty(request.Keyword) || (c.StudentName.Contains(request.Keyword) || (mobile.Contains(request.Keyword))))
select new ViewBalanceRefundOrder
{
OrderId = a.RefundOrderId,
OrderNo = a.OrderNo,
StudentId = a.StudentId,
StudentNo = c.StudentNo,
StudentName = c.StudentName,
RefundType = b.RefundType,
Amount = a.Amount,
TotalDeductAmount = a.TotalDeductAmount,
RealRefundAmount = (a.Amount - a.TotalDeductAmount),
GuardianMobile = mobile,
BankCardNo = b.BankCardNo,
BankName = b.BankName,
BankUserName = b.BankUserName,
Remark = b.Remark,
RefundDate = a.CreateTime,
CreatorName = a.CreatorName
};
var resultList = result.ToList();
return(result.OrderByDescending(a => a.RefundDate).ToPagerSource(request.PageIndex, request.PageSize));
}
/// <summary>
/// 获取余额退费列表
/// <para>作 者：郭伟佳</para>
/// <para>创建时间：2018-11-17</para>
/// </summary>
/// <param name="request">余额退费请求对象</param>
/// <returns></returns>
public static PageResult <BalanceRefundOrderListResponse> GetBalanceRefundList(BalanceRefundListSearchRequest request)
{
ViewBalanceRefundOrderRepository repository = new ViewBalanceRefundOrderRepository();
var result = new PageResult <BalanceRefundOrderListResponse>()
{
Data = new List <BalanceRefundOrderListResponse>()
};
//获取余额退费列表
var query = repository.GetBalanceRefundList(request);
if (query != null && query.Data != null && query.Data.Count > 0)
{
result.Data = Mapper.Map <List <BalanceRefundOrderListResponse> >(query.Data);
result.CurrentPage = query.CurrentPage;
result.PageSize = query.PageSize;
result.TotalData = query.TotalData;
}
return(result);
}
public PageResult <BalanceRefundOrderListResponse> GetBalanceRefundList([FromQuery] BalanceRefundListSearchRequest request)
{
request.SchoolId = base.SchoolId;
return(BalanceRefundOrderServices.GetBalanceRefundList(request));
}
