From 2b20f8284d8c59549ebcb9dabca36b5bd5b35702 Mon Sep 17 00:00:00 2001 From: cy <1664593601@qq.com> Date: 星期三, 29 十一月 2023 13:17:14 +0800 Subject: [PATCH] feat: 首页统计预警条数;部门台账物品查询导出 --- consum-base/src/main/java/com/consum/base/core/service/LWhWarningCoreServiceImpl.java | 6 ++++-- 1 files changed, 4 insertions(+), 2 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/core/service/LWhWarningCoreServiceImpl.java b/consum-base/src/main/java/com/consum/base/core/service/LWhWarningCoreServiceImpl.java index 7abdabd..9e8a73d 100644 --- a/consum-base/src/main/java/com/consum/base/core/service/LWhWarningCoreServiceImpl.java +++ b/consum-base/src/main/java/com/consum/base/core/service/LWhWarningCoreServiceImpl.java @@ -10,6 +10,8 @@ import com.walker.infrastructure.utils.NumberGenerator; import org.apache.commons.collections4.CollectionUtils; import org.springframework.stereotype.Service; +import org.springframework.transaction.annotation.Propagation; +import org.springframework.transaction.annotation.Transactional; import javax.annotation.Resource; import java.util.ArrayList; @@ -26,6 +28,7 @@ * @Version 1.0 **/ @Service +@Transactional(rollbackFor = Exception.class, propagation = Propagation.REQUIRED) public class LWhWarningCoreServiceImpl { @Resource @@ -129,8 +132,7 @@ StringBuilder sql = new StringBuilder(KU_CUN_NORMAL_MODEL); if (!org.springframework.util.CollectionUtils.isEmpty(normalBaseModelIdList)) { - sql.append(" and BASE_GOODS_MODELS_ID in(?)"); - params.add(org.apache.commons.lang3.StringUtils.join(normalBaseModelIdList, ",")); + sql.append(" and BASE_GOODS_MODELS_ID in(").append( org.apache.commons.lang3.StringUtils.join(normalBaseModelIdList, ",")).append(")"); } return lWhWarningService.update(sql.toString(), params.toArray()); } -- Gitblit v1.9.1