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