From 191ef9d695c421e8a1347cdfae312b6b633dfdc8 Mon Sep 17 00:00:00 2001
From: wuzeyu <1223318623@qq.com>
Date: 星期二, 06 八月 2024 15:26:28 +0800
Subject: [PATCH] 查询指定时间段内用水量超过指定值的取水口

---
 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeVirtualCardMapper.java |   37 +++++++++++++++++++++++++++++++++++++
 1 files changed, 37 insertions(+), 0 deletions(-)

diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeVirtualCardMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeVirtualCardMapper.java
index 0efdb8a..5f456fc 100644
--- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeVirtualCardMapper.java
+++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeVirtualCardMapper.java
@@ -2,11 +2,13 @@
 
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 import com.dy.pipIrrGlobal.pojoSe.SeVirtualCard;
+import com.dy.pipIrrGlobal.voSe.VoVcRecharge;
 import com.dy.pipIrrGlobal.voSe.VoVirtualCard;
 import org.apache.ibatis.annotations.Mapper;
 import org.apache.ibatis.annotations.Param;
 
 import java.util.List;
+import java.util.Map;
 
 /**
  * @author ZhuBaoMin
@@ -51,6 +53,21 @@
     VoVirtualCard getVcById(@Param("vcId") Long vcId);
 
     /**
+     * 鏍规嵁铏氭嫙鍗$紪鍙疯幏鍙栬櫄鎷熷崱
+     * @param vcNum
+     * @return
+     */
+    SeVirtualCard getVcCardByNum(@Param("vcNum") String vcNum);
+
+    /**
+     * 鏍规嵁铏氭嫙姘村崱缂栧彿鑾峰彇瀵瑰簲鐨勫啘鎴穒d鍜屽鍚�
+     * @param vcNum
+     * @return
+     */
+    Map getClientIdAndNameByVsCardNo(@Param("vcNum") Long vcNum);
+
+
+    /**
      * 鏍规嵁铏氭嫙鍗$紪鍙疯幏鍙栬櫄鎷熷崱ID
      * @param vcNum
      * @return
@@ -63,4 +80,24 @@
      * @return
      */
     String getVcCardNumOfMax(@Param("areaCode") String areaCode);
+
+    /**
+     * 涓�涓彇姘村彛涓婂崰鐢ㄧ殑铏氭嫙鍗$姸鎬佸彉鎴愪笉鍗犵敤
+     * @param intakeId
+     * @return
+     */
+    void updateVcCardNoUseStateByIntakeId(@Param("intakeId")Long intakeId) ;
+
+    /**
+     * 鑾峰彇铏氭嫙鍗″厖鍊艰褰�
+     * @return
+     */
+    List<VoVcRecharge> getVcRechargeRecords(Map<?, ?> params);
+
+    /**
+     * 鑾峰彇铏氭嫙鍗″厖鍊艰褰曟暟
+     * @param params
+     * @return
+     */
+    Long getRechargeRecordCount(Map<?, ?> params);
 }
\ No newline at end of file

--
Gitblit v1.8.0