/// <summary> /// 取得不動產實價 /// </summary> public async Task <Response <List <RealEstatePriceResponse> > > GetRealEstatePrice(RealEstatePriceRequest request) { using (IUnitOfWork uow = _unitOfWorkManager.Begin()) { string sql = "SELECT * FROM Prices WHERE TransactionDate BETWEEN @BeginDate AND @EndDate"; object param = new { request.BeginDate, request.EndDate }; List <RealEstatePriceResponse> response = uow.PricesRepository .Query <Prices>(sql, param) .Select(price => new RealEstatePriceResponse { PriceID = price.PriceID, District = price.District, TransactionSign = price.TransactionSign, HouseNumberPlate = price.HouseNumberPlate, AreaSquareMeter = price.AreaSquareMeter, TransactionDate = price.TransactionDate, TransactionNumber = price.TransactionNumber, TotalFlorNumber = price.TotalFlorNumber, BuildingState = price.BuildingState, MainUse = price.MainUse, MainBuildingMaterials = price.MainBuildingMaterials, CompleteDate = price.CompleteDate, ShiftingTotalArea = price.ShiftingTotalArea, Room = price.Room, Hall = price.Hall, Health = price.Health, Compartmented = price.Compartmented, ManageOrganization = price.ManageOrganization, TotalPrices = price.TotalPrices, UnitPrices = price.UnitPrices, BerthCategory = price.BerthCategory, BerthAreaSquareMeter = price.BerthAreaSquareMeter, BerthTotalPrices = price.BerthTotalPrices, Note = price.Note, MainBuildingArea = price.MainBuildingArea, OutbuildingArea = price.OutbuildingArea, BalconyArea = price.BalconyArea, Elevator = price.Elevator }) .ToList(); return(new Response <List <RealEstatePriceResponse> >(response, "success")); } }
public async Task <IActionResult> GetRealEstatePrices([FromQuery] RealEstatePriceRequest request) { return(Ok(await _realEstatePrice.GetRealEstatePrice(request))); }