From 4c6fcde6404479dc00e14733c37efe4fd3799cf5 Mon Sep 17 00:00:00 2001 From: wuzeyu <1223318623@qq.com> Date: 星期一, 16 十二月 2024 10:24:53 +0800 Subject: [PATCH] 优化接口 获得全部取水口 重构返回结构,增加片区名称字段、增加县镇村名称字段 --- pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoPr/PrControllerMapper.java | 56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 54 insertions(+), 2 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoPr/PrControllerMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoPr/PrControllerMapper.java index c1ab03e..7b1a76b 100644 --- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoPr/PrControllerMapper.java +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoPr/PrControllerMapper.java @@ -4,14 +4,15 @@ import com.dy.pipIrrGlobal.pojoPr.PrController; import com.dy.pipIrrGlobal.voPr.VoController; import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Param; import java.util.List; import java.util.Map; /** * @author ZhuBaoMin - * @date 2023-12-29 9:59 - * @LastEditTime 2024-01-02 16:22 + * @date 2024-01-15 16:51 + * @LastEditTime 2024-01-15 16:51 * @Description */ @@ -42,4 +43,55 @@ * @return */ List<VoController> getControllers(Map<?, ?> params); + + /** + * 鏍规嵁鎺у埗鍣ㄧ紪鍙疯幏鍙栨帶鍒跺櫒鍒楄〃 + * @param rtuAddr + * @return + */ + List<Map<String, Object>> getControllersByAddr(@Param("rtuAddr") String rtuAddr); + + /** + * 鏍规嵁鎺у埗鍣ㄧ紪鍙疯幏鍙栨帶鍒跺櫒鍒楄〃 + * @param rtuAddr + * @return + */ + List<PrController> getControllersByRtuAddrAndIntakeNotNull(@Param("rtuAddr") String rtuAddr); + + + /** + * 鏍规嵁鎺у埗鍣ㄧ紪鍙烽�昏緫鍒犻櫎鎺у埗 + * @param controllerId + * @return + */ + Integer deleteControllerById(@Param("controllerId") Long controllerId); + + /** + * 鏍规嵁鎺у埗鍣ㄧ紪鍙疯幏鍙栨湭鍒犻櫎鐨勬帶鍒跺櫒鏁伴噺 + * @param controllerId + * @return + */ + Integer getRecordCountOfController(@Param("controllerId") Long controllerId); + + /** + * 鏍规嵁鎺у埗鍣ㄧ紪鍙疯幏鍙栧凡缁戝畾璁板綍鏁� + * @param controllerId + * @return + */ + Integer getBindedCount(@Param("controllerId") Long controllerId); + + /** + * 鏍规嵁鎺у埗鍣ㄧ紪鍙峰垹闄ゅ彇姘村彛缂栧彿 + * @param controllerId + * @return + */ + Integer deleteIntakeId(@Param("controllerId") Long controllerId); + + /** + * 鏍规嵁鍙栨按鍙D鎴栭榾鎺у櫒鍦板潃鑾峰彇闃�鎺у櫒瀵硅薄 + * @param intakeId + * @param rtuAddr + * @return + */ + PrController getRtu(@Param("intakeId") Long intakeId, @Param("rtuAddr") String rtuAddr); } \ No newline at end of file -- Gitblit v1.8.0