using System;
|
using System.Linq.Expressions;
|
using System.Threading.Tasks;
|
using RiskControl.NewService.Entity.RiskControlRR;
|
using RiskControl.NewService.Extension;
|
using SqlSugar;
|
|
namespace RiskControl.NewService.Service
|
{
|
/// <summary>
|
/// 支付订单
|
/// </summary>
|
public class UseOrderService :BaseService<UseOrder>
|
{
|
public async Task<Page<UseOrder>> GetPages(int pageIndex, int pageSize, string orderNo, int CreateUserId
|
, DateTime? startTime, DateTime? endTime)
|
{
|
var whereExp = Expressionable.Create<UseOrder>()
|
.AndIF(!string.IsNullOrWhiteSpace(orderNo), a => a.OrderNo == orderNo)
|
.AndIF(CreateUserId > 0, a => a.CreateUserId == CreateUserId)
|
.AndIF(startTime != null, a => a.CreateTime >= startTime)
|
.AndIF(endTime != null, a => a.CreateTime <= endTime)
|
.ToExpression();
|
|
var res = await RiskControlRRDb.Queryable<UseOrder>()
|
.Includes(a => a.CreateUser)
|
.Where(whereExp)
|
.OrderBy(a=>a.CreateTime,OrderByType.Desc)
|
.ToPageAsync(pageIndex, pageSize);
|
return res;
|
}
|
|
|
}
|
|
|
}
|
