/// <summary> /// 根据条件查询车辆基本信息 /// </summary> /// <param name="busLocationInformationSearchViewModel"></param> /// <returns></returns> public BusBasicSearchMiddle BusBasic_Search(BusLocationInformationSearchViewModel busLocationInformationSearchViewModel) { Bus_Info bus_Info = _IBusInfoRepository.SearchBusInfoSingleByLineWhere(busLocationInformationSearchViewModel.LineId);//根据线路Id查班车 var result = _IMapper.Map <Bus_Info, BusBasicSearchMiddle>(bus_Info); return(result); }
//根据条件查询班车扫码记录 private Expression <Func <Bus_Location_Information, bool> > SearchBusWhere(BusLocationInformationSearchViewModel busLocationInformationSearchViewModel) { var predicate = WhereExtension.True <Bus_Location_Information>();//初始化where表达式 predicate = predicate.And(p => p.LineId == busLocationInformationSearchViewModel.LineId); if (busLocationInformationSearchViewModel.AddDate != null) { predicate = predicate.And(a => a.AddDate.Year == busLocationInformationSearchViewModel.AddDate.Value.Year && a.AddDate.Month == busLocationInformationSearchViewModel.AddDate.Value.Month); } return(predicate); }
/// <summary> /// 根据条件查询车辆经纬度 /// </summary> /// <param name="busLocationInformationSearchViewModel"></param> /// <returns></returns> public BusLocationInformationSearchMiddle BusLocationInformation_Search(BusLocationInformationSearchViewModel busLocationInformationSearchViewModel) { List <Bus_Location_Information> bus_Location_Information = _BusLocationInformationRepository. SearchInfoByBusLocationInformationWhere(busLocationInformationSearchViewModel); var result = _IMapper.Map <List <Bus_Location_Information>, List <BusLocationInformationSearchMiddle> >(bus_Location_Information); if (result.Count == 0) { return(null); } return(result[0]); }
public List <Bus_Location_Information> SearchInfoByBusLocationInformationWhere(BusLocationInformationSearchViewModel busLocationInformationSearchViewModel) { //查询条件 var predicate = SearchBusWhere(busLocationInformationSearchViewModel); var result = DbSet.Where(predicate) .OrderByDescending(o => o.AddDate).ToList(); return(result); }