From 01107e8aadfaf1e84a971d8eeb9ab37e1c5569f3 Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期五, 01 十二月 2023 09:38:56 +0800
Subject: [PATCH] feat: 部门退回/报废公用接口
---
consum-base/src/main/java/com/consum/base/service/LGoodsUserRecordServiceImpl.java | 31 +++----------------------------
1 files changed, 3 insertions(+), 28 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/LGoodsUserRecordServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/LGoodsUserRecordServiceImpl.java
index bfa9cca..db01bda 100644
--- a/consum-base/src/main/java/com/consum/base/service/LGoodsUserRecordServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/LGoodsUserRecordServiceImpl.java
@@ -1,10 +1,10 @@
package com.consum.base.service;
import com.walker.jdbc.service.BaseServiceImpl;
+import org.apache.commons.lang3.StringUtils;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
-import java.util.ArrayList;
import java.util.List;
/**
@@ -21,35 +21,10 @@
/**
* 璁剧疆涓洪潪鏈�鏂�
*/
- private static String updSetNotLast = "update L_GOODS_USER_RECORD set LAST_RECORD = 0 where WH_GOODS_ID in(?) and LAST_RECORD=1";
+ private static String updSetNotLast = "update L_GOODS_USER_RECORD set LAST_RECORD = 0 where LAST_RECORD=1 and WH_GOODS_ID in( ";
public int updSetNotLast(List<Long> outGoodsIds) {
- ArrayList<Object> params = new ArrayList<>();
- params.add(outGoodsIds);
- return this.update(updSetNotLast, params.toArray());
+ return this.update(updSetNotLast + StringUtils.join(outGoodsIds, ",") + ")", new String[]{});
}
-
- /**
- * 閫氳繃 璋冩嫧鍗旾D 鎴栬�� 鍒嗗彂璁板綍琛╥d 鍒犻櫎
- */
- private static String DEL_BY_TRANDS_AND_RECORDID = "delete from L_GOODS_USER_RECORD where 1=1";
-
- public int delByTrandsAndRecordId(Long transBusinessId, Long procureModelUserRecordId) {
- if (transBusinessId == null && procureModelUserRecordId == null) {
- return 0;
- }
- ArrayList<Object> params = new ArrayList<>();
- StringBuilder sql = new StringBuilder(DEL_BY_TRANDS_AND_RECORDID);
- if (transBusinessId != null) {
- sql.append(" and TRANS_BUSINESS_ID =?");
- params.add(transBusinessId);
- }
- if (procureModelUserRecordId != null) {
- sql.append(" and PROCURE_MODEL_USER_RECORD_ID =?");
- params.add(procureModelUserRecordId);
- }
- return update(sql.toString(), params.toArray());
- }
-
}
--
Gitblit v1.9.1