//根据条件查询班车 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)); }