public IQueryable <Bus_Payment_Order> SearchInfoByBusPaymentOrderWhere2(BusOrderSearchViewModel busOrderSearchViewModel)
{
int SkipNum = busOrderSearchViewModel.pageViewModel.CurrentPageNum * busOrderSearchViewModel.pageViewModel.PageSize;
var predicate = SearchBusPaymentOrderWhere2(busOrderSearchViewModel);
var result = DbSet.Where(predicate).OrderByDescending(o => o.AddDate)
.Skip(SkipNum)
.Take(busOrderSearchViewModel.pageViewModel.PageSize);
return(result);
}
//根据条件查询订单信息
private Expression <Func <Bus_Payment_Order, bool> > SearchBusPaymentOrderWhere2(BusOrderSearchViewModel busOrderSearchViewModel)
{
var predicate = WhereExtension.True <Bus_Payment_Order>();//初始化where表达式
predicate = predicate.And(a => a.orderNo.Contains(busOrderSearchViewModel.OrderId));
predicate = predicate.And(a => a.paymentStatus.Contains(busOrderSearchViewModel.paymentStatus));
predicate = predicate.And(a => a.isDelete == "0");
predicate = predicate.And(a => a.departName.Contains(busOrderSearchViewModel.departName));
if (busOrderSearchViewModel.AddDate != null)
{
predicate = predicate.And(a => a.AddDate.Value.Year == busOrderSearchViewModel.AddDate.Value.Year &&
a.AddDate.Value.Month == busOrderSearchViewModel.AddDate.Value.Month);
}
return(predicate);
}
