From 52e7ec8afeb53727e4fde72fbade5e5ef8addff8 Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期二, 20 九月 2022 11:45:58 +0800
Subject: [PATCH] 删除台站下指定文件
---
src/main/java/com/whyc/service/StationInfoService.java | 28 ++++++++++++++++++++++++++++
1 files changed, 28 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/StationInfoService.java b/src/main/java/com/whyc/service/StationInfoService.java
index 48cfa65..70669ef 100644
--- a/src/main/java/com/whyc/service/StationInfoService.java
+++ b/src/main/java/com/whyc/service/StationInfoService.java
@@ -1,5 +1,6 @@
package com.whyc.service;
+import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.whyc.dto.FileOpreate;
@@ -212,6 +213,7 @@
return new Response().set(1,flag>0,"淇敼鎿嶄綔");
}
//鍒犻櫎鍙扮珯
+ @Transactional
public Response deleteStation(String stationName1, String stationName2, String stationName3) {
String stationName="";
UpdateWrapper wrapper=new UpdateWrapper();
@@ -225,7 +227,33 @@
stationName=stationName+"-"+stationName3;
}
wrapper.eq("station_name",stationName);
+ //鍏堝垹闄よ鍩虹珯鎸傝浇鐨勬墍鏈夋枃浠�
int flag=mapper.delete(wrapper);
return new Response().set(1,flag>0,"鍒犻櫎鎿嶄綔");
}
+ //绉婚櫎鍙扮珯涓嬫枃浠讹紙鍗曚釜鏂囦欢锛�
+ @Transactional
+ public Response delFileFromStation(String stationName, String filePath) {
+ //1.鍏堟煡鍑烘満鎴跨殑id
+ int stationId=mapper.selectIdByName(stationName);
+ if(stationId==0){
+ return new Response().set(1,false,"鏈烘埧涓嶅瓨鍦�");
+ }else{
+ //2.鏌ュ嚭鏂囦欢瀵瑰簲鐨勬枃浠秈d
+ int fileId=infoMapper.selectFileId(stationId,filePath);
+ if(fileId==0){
+ return new Response().set(1,false,"鏂囦欢涓嶅瓨鍦�");
+ }else{
+ //3.鍒犻櫎fileid瀵瑰簲鐨勬暟鎹�(stationId,fileId)
+ dataMapper.deleteDataAndInfo(stationId,fileId);
+
+ //4.鍒犻櫎fileid瀵瑰簲鐨勫弬鏁�
+ paramMapper.deleteParamByFileId(fileId);
+
+ //5.鍒犻櫎鏈烘埧涓嬫枃浠朵俊鎭�(stationId,fileId)
+ infoMapper.deleteFileInStation(stationId,fileId);
+ return new Response().set(1,true,"鍒犻櫎鎴愬姛");
+ }
+ }
+ }
}
--
Gitblit v1.9.1