From 540b3f4dbfd9eaed86b5f843be12a06b912de5ef Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期二, 11 六月 2024 20:11:34 +0800
Subject: [PATCH] 1、完善靳总协议的控制器报警及状态处理; 2、报警及状态数据库表(最新+历史)增加字段电池电压报警、阀门报警。

---
 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeVirtualCardMapper.java |   56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 54 insertions(+), 2 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 8bac3d7..5680485 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,12 +2,16 @@
 
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 import com.dy.pipIrrGlobal.pojoSe.SeVirtualCard;
+import com.dy.pipIrrGlobal.voSe.VoVirtualCard;
 import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
 
 /**
  * @author ZhuBaoMin
- * @date 2024-03-05 20:45
- * @LastEditTime 2024-03-05 20:45
+ * @date 2024-05-23 16:44
+ * @LastEditTime 2024-05-23 16:44
  * @Description
  */
 
@@ -25,4 +29,52 @@
 
     int updateByPrimaryKey(SeVirtualCard record);
 
+    /** 搴熷純
+     * 楠岃瘉鍐滄埛鏄惁鎷ユ湁鎸囧畾鍚嶇О鐨勮櫄鎷熷崱
+     * @param clientId 鍐滄埛缂栧彿
+     * @param vcName 铏氭嫙鍗″悕绉�
+     * @return 绗﹀悎鏉′欢璁板綍鏁�
+     */
+    //int getRecordCountByName(@Param("clientId") Long clientId, @Param("vcName") String vcName);
+
+    /**
+     * 鑾峰彇鍐滄埛鍏ㄩ儴铏氭嫙鍗�
+     * @return
+     */
+    List<VoVirtualCard> getVCs(@Param("clientId") Long clientId);
+
+    /**
+     * 鏍规嵁铏氭嫙鍗D鑾峰彇铏氭嫙鍗″璞�
+     * @param vcId
+     * @return
+     */
+    VoVirtualCard getVcById(@Param("vcId") Long vcId);
+
+    /**
+     * 鏍规嵁铏氭嫙鍗$紪鍙疯幏鍙栬櫄鎷熷崱
+     * @param vcNum
+     * @return
+     */
+    SeVirtualCard getVcCardByNum(@Param("vcNum") String vcNum);
+
+    /**
+     * 鏍规嵁铏氭嫙鍗$紪鍙疯幏鍙栬櫄鎷熷崱ID
+     * @param vcNum
+     * @return
+     */
+    Long getVcIdByNum(@Param("vcNum") String vcNum);
+
+    /**
+     * 鏍规嵁琛屾斂鍖哄垝涓叉ā绯婃煡璇㈣櫄鎷熷崱缂栧彿
+     * @param areaCode
+     * @return
+     */
+    String getVcCardNumOfMax(@Param("areaCode") String areaCode);
+
+    /**
+     * 涓�涓彇姘村彛涓婂崰鐢ㄧ殑铏氭嫙鍗$姸鎬佸彉鎴愪笉鍗犵敤
+     * @param intakeId
+     * @return
+     */
+    void updateVcCardNoUseStateByIntakeId(@Param("intakeId")Long intakeId) ;
 }
\ No newline at end of file

--
Gitblit v1.8.0