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);
}
