From 3d665d84b1a4ffd6749ca9354247838ce0622f4b Mon Sep 17 00:00:00 2001
From: jinpengyong <jpy123456>
Date: Tue, 13 Dec 2022 13:47:53 +0800
Subject: [PATCH] 修改sql语句问题
---
screen-manage/src/main/java/com/moral/api/service/impl/ServicesScopeServiceImpl.java | 4 +++-
1 files changed, 3 insertions(+), 1 deletions(-)
diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/ServicesScopeServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/ServicesScopeServiceImpl.java
index 541f6f9..76658bb 100644
--- a/screen-manage/src/main/java/com/moral/api/service/impl/ServicesScopeServiceImpl.java
+++ b/screen-manage/src/main/java/com/moral/api/service/impl/ServicesScopeServiceImpl.java
@@ -175,7 +175,9 @@
insertList.add(deviceId);
}
}
- servicesScopeDeviceMapper.insertBatch(addBoundaryBindDevice.getServicesScope().getId(),insertList);
+ if (insertList.size()>0){
+ servicesScopeDeviceMapper.insertBatch(addBoundaryBindDevice.getServicesScope().getId(),insertList);
+ }
servicesScopeDeviceQueryWrapper.notIn("device_id",deviceIdList);
ServicesScopeDevice servicesScopeDevice = new ServicesScopeDevice();
servicesScopeDevice.setIsDelete(Constants.DELETE);
--
Gitblit v1.8.0