From 208df7a2b6b8ef283217ab89020a6ad410090f13 Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期三, 26 十月 2022 13:28:38 +0800
Subject: [PATCH] 修改台站管理

---
 src/main/java/com/whyc/service/FileParamService.java |   32 +++++++++++++++++++++++++++-----
 1 files changed, 27 insertions(+), 5 deletions(-)

diff --git a/src/main/java/com/whyc/service/FileParamService.java b/src/main/java/com/whyc/service/FileParamService.java
index b3cce0f..965b54d 100644
--- a/src/main/java/com/whyc/service/FileParamService.java
+++ b/src/main/java/com/whyc/service/FileParamService.java
@@ -1,14 +1,12 @@
 package com.whyc.service;
 
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
 import com.baomidou.mybatisplus.core.toolkit.Wrappers;
 import com.github.pagehelper.PageHelper;
 import com.github.pagehelper.PageInfo;
 import com.whyc.dto.*;
-import com.whyc.mapper.BattGroupDataMapper;
-import com.whyc.mapper.FileInfoMapper;
-import com.whyc.mapper.FileParamMapper;
-import com.whyc.mapper.TestParamMapper;
+import com.whyc.mapper.*;
 import com.whyc.pojo.*;
 import com.whyc.util.MathUtil;
 import org.springframework.beans.factory.annotation.Autowired;
@@ -35,6 +33,9 @@
 
     @Autowired(required = false)
     private TestParamMapper testParamMapper;
+
+    @Autowired(required = false)
+    private BattgroupInfoMapper groupInfoMapper;
 
     //瑙f瀽xml鏂囦欢(浼犲弬涓�涓枃浠�)
     public Response getXmlValue(String filePath) {
@@ -186,11 +187,32 @@
     //鍒犻櫎鍩虹珯涓嬫暟鎹�
     public Response deleteDataById(int stationId, int fileId) {
         //鍒犻櫎鎵�鏈夋枃浠舵暟鎹�(鎸囧畾鏈烘埧id鍜屾枃浠秈d)
-        dataMapper.deleteDataAndInfo(stationId,fileId);
+        //dataMapper.deleteDataAndInfo(stationId,fileId);
+        deleteDataAndInfo(stationId,fileId);
         //鍒犻櫎鎵�鏈夋枃浠跺弬鏁�
         paramMapper.deleteParamByFileId(fileId);
         //绉婚櫎鏈烘埧涓嬫寕鍦ㄧ殑鏂囦欢
         infoMapper.deleteFileInStation(stationId,fileId);
         return new Response().set(1,"鍒犻櫎鎴愬姛!");
     }
+    //3鏍规嵁(stationId,fileId)鍒犻櫎groupinfo鍜実roupdata鏁版嵁
+    public void deleteDataAndInfo(int stationId,int fileId){
+        //鍏堟煡璇㈠嚭瀵瑰簲鐨勭數姹犵粍id鐒跺悗鍒犻櫎
+        QueryWrapper wrapper=new QueryWrapper();
+        wrapper.eq("station_id",stationId);
+        wrapper.eq("file_id",fileId);
+        List<BattgroupInfo> list=groupInfoMapper.selectList(wrapper);
+        if(list!=null&&list.size()>0){
+            for (BattgroupInfo ginfo:list) {
+                UpdateWrapper dataWrapper=new UpdateWrapper();
+                dataWrapper.eq("battGroup_id",ginfo.getBattgroupId());
+                dataMapper.delete(dataWrapper);
+            }
+        }
+        //鍐嶅垹闄roupinfo
+        UpdateWrapper infoWrapper=new UpdateWrapper();
+        infoWrapper.eq("station_id",stationId);
+        infoWrapper.eq("file_id",fileId);
+        groupInfoMapper.delete(infoWrapper);
+    }
 }

--
Gitblit v1.9.1