From e49292cc68c85f839524e3521d912e24cf15eccc Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期一, 10 四月 2023 13:55:46 +0800 Subject: [PATCH] 1 --- src/main/java/com/terra/coal/mapper/MainMapper.java | 2 +- src/main/java/com/terra/coal/controller/MainController.java | 2 +- src/main/java/com/terra/coal/service/MainService.java | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) diff --git a/src/main/java/com/terra/coal/controller/MainController.java b/src/main/java/com/terra/coal/controller/MainController.java index e41c8a8..87329a1 100644 --- a/src/main/java/com/terra/coal/controller/MainController.java +++ b/src/main/java/com/terra/coal/controller/MainController.java @@ -93,7 +93,7 @@ return fail("寮�鎸栨繁搴﹁繃灏�", null); } - List<CountEntity> rs = mainService.countByRange(BigDecimal.valueOf(z), BigDecimal.valueOf(z + deep), wkt); + List<CountEntity> rs = mainService.countByRange(z, z + deep, wkt); return success("鎴愬姛", null == rs ? 0 : rs.size(), rs); } catch (Exception ex) { diff --git a/src/main/java/com/terra/coal/mapper/MainMapper.java b/src/main/java/com/terra/coal/mapper/MainMapper.java index 907ba89..68e0ccb 100644 --- a/src/main/java/com/terra/coal/mapper/MainMapper.java +++ b/src/main/java/com/terra/coal/mapper/MainMapper.java @@ -28,5 +28,5 @@ @Select("select ctype, sum(volume) \"volume\", sum(coal_prod) \"coal_prod\", sum(gangue_prod) \"gangue_prod\", 0 \"soil_prod\" from public.coal2000 " + "where (top between #{top} and #{bottom} or bottom between #{top} and #{bottom}) and ST_Intersects(geom, ST_PolygonFromText(#{wkt}, 4490))" + "group by ctype order by ctype") - public List<CountEntity> countByRange(@Param("top") BigDecimal top, @Param("bottom") BigDecimal bottom, @Param("wkt") String wkt); + public List<CountEntity> countByRange(@Param("top") Double top, @Param("bottom") Double bottom, @Param("wkt") String wkt); } diff --git a/src/main/java/com/terra/coal/service/MainService.java b/src/main/java/com/terra/coal/service/MainService.java index c573c4c..e5c8c06 100644 --- a/src/main/java/com/terra/coal/service/MainService.java +++ b/src/main/java/com/terra/coal/service/MainService.java @@ -30,7 +30,7 @@ Coal54Mapper coal54Mapper; @Override - public List<CountEntity> countByRange(BigDecimal top, BigDecimal bottom, String wkt) { + public List<CountEntity> countByRange(Double top, Double bottom, String wkt) { return mainMapper.countByRange(top, bottom, wkt); } -- Gitblit v1.9.3