public async Task <QueryResultDto <VehicleDto> > GetVehicles(VehicleQueryDto filterDto) { var filter = mapper.Map <VehicleQueryDto, VehicleQuery>(filterDto); var queryResult = await repository.GetVehicles(filter); return(mapper.Map <QueryResult <Vehicle>, QueryResultDto <VehicleDto> >(queryResult)); }
public async Task <ActionResult <QueryResultDto <VehicleDto> > > GetVehicles(VehicleQueryDto queryDto) { var queryObj = _mapper.Map <VehicleQueryDto, VehicleQuery>(queryDto); var queryResult = await _repository.GetVehiclesAsync(queryObj); return(Ok(_mapper.Map <QueryResultDto <VehicleDto> >(queryResult))); }
public async Task <ActionResult <QueryResultDto <VehicleDto> > > GetVehicles([FromQuery] VehicleQueryDto filterDto) { var filter = _mapper.Map <VehicleQuery>(filterDto); var vehicles = await _repo.GetVehicles(filter);//_context.Vehicles.Include(x => x.Features); return(Ok(vehicles)); }
/// <summary> /// 多表连接,动态查询条件 /// </summary> public void ManyTableDynamicCondition() { var query = new VehicleQueryDto(); query.CarNo = "9"; var filter = QueryExpression.CreateExpression <VehicleInfoDto, VehicleQueryDto>(query); var rep = (IVehicleRegistRepository)this.uw.GetRepository(typeof(IVehicleRegistRepository)); int count; var lst = rep.GetInfoList(filter, 10, 1, out count); }
public async Task <PopularResult <byte[]> > GetBytesAsync(VehicleQueryDto dto) { var result = new PopularResult <byte[]>(); var queryable = _vehicleRepository.Where(x => x.IsDelete == dto.IsDelete) .WhereIf(!dto.License.IsNullOrWhiteSpace(), vehicle => vehicle.License.Contains(dto.License)) .WhereIf(!dto.Vin.IsNullOrWhiteSpace(), vehicle => vehicle.Vin.Contains(dto.Vin)) .WhereIf(dto.UnitId.HasValue, vehicle => vehicle.UnitId == dto.UnitId); var query = from v in queryable.PageBy(dto.SkipCount, dto.MaxResultCount) join u in _unitRepository.WhereIf(dto.UnitId.HasValue, unit => unit.Id == dto.UnitId) on v.UnitId equals u.Id into cls from c in cls.DefaultIfEmpty() select new VehicleEntity(v.Id) { License = v.License, //IsDelete = v.IsDelete, InteriorCode = v.InteriorCode, EngineNo = v.EngineNo, ActivationTime = v.ActivationTime, Color = v.Color, CreateTime = v.CreateTime, Creator = v.Creator, Displacement = v.Displacement, Price = v.Price, PurchaseDate = v.PurchaseDate, Purpose = v.Purpose, Remark = v.Remark, UnitId = v.UnitId, VehicleType = v.VehicleType, Vin = v.Vin, Unit = c }; var vehicles = await Task.FromResult(query.ToList()); //转换为导出对象 var dtos = ObjectMapper.Map <List <VehicleEntity>, List <VehicleDto> >(vehicles); var stream = EPPlusHelper.GetMemoryStream(dtos); result.Success(stream.ToArray()); return(result); }