From 1950b0635a0db2c5286f8330e064879e020a7303 Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期五, 22 十一月 2024 14:02:11 +0800
Subject: [PATCH] 1、通信中间件核心模块线程工作由Thread实现改为Timer实现; 2、完善通信中间件远程升级模块及webRemote模块; 3、优化代码。

---
 pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/dbSv/DbSv.java |   91 ++++++++++++++++++++++++++++++++++++++-------
 1 files changed, 76 insertions(+), 15 deletions(-)

diff --git a/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/dbSv/DbSv.java b/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/dbSv/DbSv.java
index 97bada3..fd7c0df 100644
--- a/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/dbSv/DbSv.java
+++ b/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/dbSv/DbSv.java
@@ -10,6 +10,7 @@
 import com.dy.pipIrrGlobal.pojoPr.PrControllerTramp;
 import com.dy.pipIrrGlobal.pojoRm.*;
 import com.dy.pipIrrGlobal.pojoSe.SeClient;
+import com.dy.pipIrrGlobal.voSe.VoCardInfo1;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
@@ -27,9 +28,9 @@
 @Service()
 public class DbSv {
     @Autowired
-    private SeClientCardMapper seClientCardMapperDao;//鍐滄埛姘村崱DAO
+    private SeClientCardMapper seClientCardDao;//鍐滄埛姘村崱DAO
     @Autowired
-    private SeVirtualCardMapper seVirtualCardMapper;//鍐滄埛铏氭嫙姘村崱DAO
+    private SeVirtualCardMapper seVirtualCardDao ;//铏氭嫙鍗$浉鍏矰AO
     @Autowired
     private PrControllerTrampMapper prControllerTrampMapperDao;//娴佹氮鎺у埗鍣―AO
     @Autowired
@@ -60,8 +61,6 @@
     private RmLossDayMapper rmLossHistoryMapperDao ;//鎺у埗鍣ㄦ紡鎹熸按閲忕粺璁″巻鍙叉暟鎹瓺AO
     @Autowired
     private RmCommandHistoryMapper rmCommandHistoryDao ;//杩滅▼鍛戒护鏃ュ織鐩稿叧
-    @Autowired
-    private SeVirtualCardMapper seVirtualCardDao ;//铏氭嫙鍗$浉鍏�
 
     @Autowired
     private RmTimingReportHistoryMapper rmTimingReportHistoryDao; // 瀹氱偣涓婃姤鍘嗗彶鏁版嵁DAO
@@ -69,9 +68,10 @@
     private RmTimingReportLastMapper rmTimingReportLastDao; // 瀹氱偣涓婃姤鏈�鏂版暟鎹瓺AO
 
     @Autowired
-    private RmOnHourReportHistoryMapper rmOnHourReportHistoryDao; // 鏁寸偣涓婃姤鍘嗗彶鏁版嵁DAO
+    private RmOnHourReportHistoryMapper rmOnHourReportHistoryDao; // 瀹氱偣涓婃姤鍘嗗彶鏁版嵁DAO
     @Autowired
-    private RmOnHourReportLastMapper rmOnHourReportLastDao; // 鏁寸偣涓婃姤鏈�鏂版暟鎹瓺AO
+    private RmOnHourReportLastMapper rmOnHourReportLastDao; // 瀹氱偣涓婃姤鏈�鏂版暟鎹瓺AO
+
 
     //@Autowired
     //@Lazy
@@ -93,7 +93,7 @@
         SeClient vo = null ;
         if(NumUtil.isPlusIntNumber(icCardNo)){
             Long icCardNoLong = Long.parseLong(icCardNo) ;
-            Map<String, Object> map = seClientCardMapperDao.getClientIdAndNameByCardAddrAndCardNo(icCardAddr, icCardNoLong) ;
+            Map<String, Object> map = seClientCardDao.getClientIdAndNameByCardAddrAndCardNo(icCardAddr, icCardNoLong) ;
             if(map != null && map.size() > 0) {
                 vo = new SeClient() ;
                 vo.setId(Long.parseLong(map.get("clientId").toString()));
@@ -111,7 +111,7 @@
         SeClient vo = null ;
         if(NumUtil.isPlusIntNumber(icCardNo)){
             Long icCardNoLong = Long.parseLong(icCardNo) ;
-            Map<String, Object> map = seVirtualCardMapper.getClientIdAndNameByVsCardNo(icCardNoLong) ;
+            Map<String, Object> map = seVirtualCardDao.getClientIdAndNameByVsCardNo(icCardNoLong) ;
             if(map != null && map.size() > 0) {
                 vo = new SeClient() ;
                 vo.setId(Long.parseLong(map.get("clientId").toString()));
@@ -152,6 +152,9 @@
      */
     @Transactional(rollbackFor = Exception.class)
     public void savePrConctrollerTramp(PrControllerTramp po){
+        if(po.getOrgTag().trim().length() > 2) {
+            po.setOrgTag("DY");
+        }
         this.prControllerTrampMapperDao.insert(po) ;
     }
    /**
@@ -211,8 +214,8 @@
      * @param intakeId
      */
     @Transactional(rollbackFor = Exception.class)
-    public void updateVirCardNoUseState(Long intakeId){
-        this.seVirtualCardDao.updateVcCardNoUseStateByIntakeId(intakeId); ;
+    public void updateVirCardNoUseState(Long intakeId, Date now){
+        this.seVirtualCardDao.updateVcCardNoUseStateByIntakeId(intakeId, now) ;
     }
 
 
@@ -265,12 +268,12 @@
 
     /////////////////////////////////////////////////
     //
-    // 鏁寸偣涓婃姤瀹炴椂鏁版嵁鍔熻兘(鍙湪闈虫�荤殑鍗忚鏈夋鏁版嵁)
+    // 瀹氱偣涓婃姤瀹炴椂鏁版嵁鍔熻兘(鍙湪闈虫�荤殑鍗忚鏈夋鏁版嵁)
     //
     ////////////////////////////////////////////////
 
     /**
-     * 淇濆瓨鎺у埗鍣ㄦ暣鐐逛笂鎶ュ巻鍙叉暟鎹�
+     * 淇濆瓨鎺у埗鍣ㄥ畾鐐逛笂鎶ュ巻鍙叉暟鎹�
      * @param po
      */
     @Transactional(rollbackFor = Exception.class)
@@ -279,7 +282,7 @@
     }
 
     /**
-     * 鏍规嵁闃�鎺у櫒鍦板潃鑾峰彇鏁寸偣涓婃姤鏈�鏂版暟鎹�
+     * 鏍规嵁闃�鎺у櫒鍦板潃鑾峰彇瀹氱偣涓婃姤鏈�鏂版暟鎹�
      * @param intakeId
      * @return
      */
@@ -293,7 +296,7 @@
     }
 
     /**
-     * 淇濆瓨鎺у埗鍣ㄦ暣鐐逛笂鎶ユ渶鏂版暟鎹�
+     * 淇濆瓨鎺у埗鍣ㄥ畾鐐逛笂鎶ユ渶鏂版暟鎹�
      * @param po
      */
     @Transactional(rollbackFor = Exception.class)
@@ -302,7 +305,7 @@
     }
 
     /**
-     * 淇濆瓨鎺у埗鍣ㄦ暣鐐逛笂鎶ョ姜琛屾暟鎹�
+     * 淇濆瓨鎺у埗鍣ㄥ畾鐐逛笂鎶ョ姜琛屾暟鎹�
      * @param po
      */
     @Transactional(rollbackFor = Exception.class)
@@ -634,12 +637,70 @@
 
     //////////////////////////////////////////////////////
     //
+    // IC鍗$浉鍏�
+    //
+    //////////////////////////////////////////////////////
+    /**
+     * 寰楀埌鍐滄埛鍗�
+     * @param cardAddr
+     * @param cardNo
+     * @return
+     */
+    public VoCardInfo1 getIcCard(String cardAddr, String cardNo){
+        if(NumUtil.isPlusIntNumber(cardNo)){
+            Long icCardNoLong = Long.parseLong(cardNo) ;
+            List<VoCardInfo1> list = seClientCardDao.getCardsByAddrAndNum(cardAddr, icCardNoLong) ;
+            if(list != null && list.size() > 0){
+                return list.get(0) ;
+            }
+        }
+        return null ;
+    }
+    /**
+     * 寰楀埌鍐滄埛铏氭嫙鍗�
+     * @param cardNo
+     * @return
+     */
+    public VoCardInfo1 getVirIcCard(String cardNo){
+        if(NumUtil.isPlusIntNumber(cardNo)){
+            Long icCardNoLong = Long.parseLong(cardNo) ;
+            List<VoCardInfo1> list = seVirtualCardDao.getCardsByNum(icCardNoLong) ;
+            if(list != null && list.size() > 0){
+                return list.get(0) ;
+            }
+        }
+        return null ;
+    }
+
+    /**
+     * 鏇存柊瀹炰綋鍗″墿浣欓噾棰�
+     * @param id
+     * @param remainMoney
+     */
+    @Transactional(rollbackFor = Exception.class)
+    public void updateIcCardRemainMoney(Long id , Double remainMoney){
+        seClientCardDao.updateMoney(id,remainMoney);
+    }
+
+    /**
+     * 鏇存柊铏氭嫙鍗″墿浣欓噾棰�
+     * @param id
+     * @param remainMoney
+     */
+    @Transactional(rollbackFor = Exception.class)
+    public void updateVirIcCardRemainMoney(Long id , Double remainMoney){
+        seVirtualCardDao.updateMoney(id,remainMoney);
+    }
+
+    //////////////////////////////////////////////////////
+    //
     // 鍛戒护鏃ュ織鐩稿叧
     //
     //////////////////////////////////////////////////////
     public RmCommandHistory getCommandLog(String commandId){
         return rmCommandHistoryDao.selectByPrimaryKey(Long.parseLong(commandId)) ;
     }
+    @Transactional(rollbackFor = Exception.class)
     public void updateCommandLog(RmCommandHistory po){
         rmCommandHistoryDao.updateByPrimaryKey(po) ;
     }

--
Gitblit v1.8.0