From dfaf2ae84b72d62d896c029f91c87816b696ec06 Mon Sep 17 00:00:00 2001 From: cy <1664593601@qq.com> Date: 星期六, 09 十二月 2023 11:48:59 +0800 Subject: [PATCH] feat: 部门A类物品报废时 更新L_WH_PROCURE_MODEL_USER中可用数量 --- consum-base/src/main/java/com/consum/base/service/LGoodsUserRecordServiceImpl.java | 27 ++------------------------- 1 files changed, 2 insertions(+), 25 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 5cd97eb..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,11 +1,11 @@ package com.consum.base.service; import com.walker.jdbc.service.BaseServiceImpl; -import java.util.ArrayList; -import java.util.List; import org.apache.commons.lang3.StringUtils; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; + +import java.util.List; /** * @ClassName LGoodsUserRecordServiceImpl @@ -26,28 +26,5 @@ public int updSetNotLast(List<Long> outGoodsIds) { 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