From 23830e352b874e2a27dc8023e2dfca11edb2a6cc Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期四, 02 三月 2023 17:20:49 +0800 Subject: [PATCH] 1 --- src/main/java/com/lf/server/service/data/MetaService.java | 18 ++++++++++++++++++ 1 files changed, 18 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/lf/server/service/data/MetaService.java b/src/main/java/com/lf/server/service/data/MetaService.java index 27633e0..03ae908 100644 --- a/src/main/java/com/lf/server/service/data/MetaService.java +++ b/src/main/java/com/lf/server/service/data/MetaService.java @@ -6,6 +6,7 @@ import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; +import java.util.ArrayList; import java.util.List; /** @@ -134,8 +135,25 @@ */ public Integer deletes(List<Integer> list) { String ids = StringHelper.join(list, ","); + String sql = null; + List<MetaEntity> metas = selectByIdsForTab(ids); + if (null != metas && metas.size() > 0) { + sql = getDelTabsSql(metas); + } return deletes(sql, ids); } + + /** + * 鑾峰彇鍒犻櫎琛ㄨ褰昐QL + */ + private String getDelTabsSql(List<MetaEntity> metas) { + List<String> list = new ArrayList<>(); + for (MetaEntity me : metas) { + list.add(String.format("delete from %s where parentid='%s'", me.getTab(), me.getEventid())); + } + + return StringHelper.join(list, ";"); + } } -- Gitblit v1.9.3