//根据条件查询班车
private Expression <Func <Bus_Payment, bool> > SearchBusUser2Where(BusUserSearch2ViewModel busUserSearch2ViewModel)
{
var predicate = WhereExtension.True <Bus_Payment>();//初始化where表达式
predicate = predicate.And(a => a.Bus_Payment_Order.orderNo.Contains(busUserSearch2ViewModel.orderNo));
predicate = predicate.And(a => a.UserName.Contains(busUserSearch2ViewModel.UserName));
predicate = predicate.And(a => a.Name.Contains(busUserSearch2ViewModel.User_DepartName));
if (busUserSearch2ViewModel.Bus_LineId != null)
{
predicate = predicate.And(a => a.Bus_LineId == busUserSearch2ViewModel.Bus_LineId);
}
if (busUserSearch2ViewModel.User_DepartId != null)
{
predicate = predicate.And(a => a.User_DepartId == busUserSearch2ViewModel.User_DepartId);
}
// predicate = predicate.And(a => a.LineName.Contains(busUserSearch2ViewModel.Bus_LineName));
predicate = predicate.And(a => a.status == (busUserSearch2ViewModel.status));
if (busUserSearch2ViewModel.Expense != "")
{
predicate = predicate.And(a => a.Expense == (busUserSearch2ViewModel.Expense));
}
if (busUserSearch2ViewModel.carDate != null)
{
predicate = predicate.And(a => a.carDate.Value.Year == busUserSearch2ViewModel.carDate.Value.Year &&
a.carDate.Value.Month == busUserSearch2ViewModel.carDate.Value.Month);
}
predicate = predicate.And(a => a.Code != null);
return(predicate);
}
/// <summary>
/// 查询人员缴费信息（重载,最普通的查询）
/// </summary>
/// <param name="busUserSearchViewModel"></param>
/// <returns></returns>
public IQueryable <Bus_Payment> SearchInfoByBusWhere2(BusUserSearch2ViewModel busUserSearch2ViewModel)
{
int SkipNum = busUserSearch2ViewModel.pageViewModel.CurrentPageNum * busUserSearch2ViewModel.pageViewModel.PageSize;
var predicate = SearchBusUser2Where(busUserSearch2ViewModel);
var result = DbSet.Where(predicate).Include(b => b.Bus_Payment_Order).OrderBy(o => o.Id)
.Skip(SkipNum)
.Take(busUserSearch2ViewModel.pageViewModel.PageSize);
return(result);
}
public IQueryable <Bus_Payment> GetInfoByBusAll2(BusUserSearch2ViewModel busUserSearch2ViewModel)
{
var predicate = SearchBusUser2Where(busUserSearch2ViewModel);
return(DbSet.Where(predicate));
}
