public List <Bus_Scan_Record> SearchInfoByBusScanRecordWhereNum(BusScanRecordSearchViewModel busScanRecordSearchViewModel) { //查询条件 var predicate = SearchBusWhere(busScanRecordSearchViewModel); var result = DbSet.Where(predicate) .OrderBy(o => o.AddDate).ToList(); return(result); }
public List <Bus_Scan_Record> SearchInfoByBusScanRecordWhere(BusScanRecordSearchViewModel busScanRecordSearchViewModel) { int SkipNum = busScanRecordSearchViewModel.pageViewModel.CurrentPageNum * busScanRecordSearchViewModel.pageViewModel.PageSize; //查询条件 var predicate = SearchBusWhere(busScanRecordSearchViewModel); var result = DbSet.Where(predicate).OrderBy(o => o.AddDate) .Skip(SkipNum) .Take(busScanRecordSearchViewModel.pageViewModel.PageSize) .ToList(); return(result); }
//根据条件查询班车扫码记录 private Expression <Func <Bus_Scan_Record, bool> > SearchBusWhere(BusScanRecordSearchViewModel busScanRecordSearchViewModel) { var predicate = WhereExtension.True <Bus_Scan_Record>();//初始化where表达式 predicate = predicate.And(p => p.UserName.Contains(busScanRecordSearchViewModel.UserName)); predicate = predicate.And(p => p.LineName.Contains(busScanRecordSearchViewModel.LineName)); predicate = predicate.And(p => p.DeptName.Contains(busScanRecordSearchViewModel.DeptName)); if (busScanRecordSearchViewModel.status != "") { predicate = predicate.And(p => p.status == busScanRecordSearchViewModel.status); } if (busScanRecordSearchViewModel.startdate != null && busScanRecordSearchViewModel.enddate != null) { predicate = predicate.And(p => p.AddDate >= busScanRecordSearchViewModel.startdate); predicate = predicate.And(p => p.AddDate <= busScanRecordSearchViewModel.enddate); } return(predicate); }