From 5e6c61b8753870ef2f8cde60eef47e3eeefe89e6 Mon Sep 17 00:00:00 2001
From: luqingyang <lqy5492@163.com>
Date: 星期四, 02 十一月 2023 17:35:48 +0800
Subject: [PATCH] 报废单 相关代码
---
consum-base/src/main/java/com/consum/base/service/BaseGoodsModelsServiceImpl.java | 39 +++++++++++++++++++++++++++++++++++++++
1 files changed, 39 insertions(+), 0 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/BaseGoodsModelsServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/BaseGoodsModelsServiceImpl.java
index d0513ee..4558e52 100644
--- a/consum-base/src/main/java/com/consum/base/service/BaseGoodsModelsServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/BaseGoodsModelsServiceImpl.java
@@ -10,8 +10,10 @@
import com.walker.infrastructure.utils.StringUtils;
import com.walker.jdbc.service.BaseServiceImpl;
import org.springframework.stereotype.Service;
+import org.springframework.util.CollectionUtils;
import java.util.HashMap;
+import java.util.List;
/**
* @Description 鐗╁搧妯℃澘
@@ -86,4 +88,41 @@
models.setStates(Constants.STATES_DELETED);
return this.update(models);
}
+
+ /**
+ * @Description 鏍规嵁瑙勬牸鍨嬪彿id鏌ヨ瑙勬牸鍨嬪彿
+ * @Author 鍗㈠簡闃�
+ * @Date 2023/11/2
+ * @param idList
+ */
+ public List<BaseGoodsModels> selectByModelsIdList(List<Long> idList) {
+ if (CollectionUtils.isEmpty(idList)) {
+ log.error("鍙傛暟閿欒");
+ return null;
+ }
+ StringBuilder sql = new StringBuilder("SELECT * FROM base_goods_models WHERE 1 = 1 ");
+ HashMap<String, Object> paramts = new HashMap<>();
+
+ sql.append(" and id in ( ");
+ for (int i = 0; i < idList.size(); i++) {
+ sql.append(idList.get(i));
+ if (i < idList.size() - 1) {
+ sql.append(",");
+ }
+ }
+ sql.append(" ) ");
+
+ return this.select(sql.toString(), paramts, new BaseGoodsModels());
+ }
+
+ /**
+ * @Description 鏍规嵁鐗╁搧id鏌ヨ瑙勬牸鍨嬪彿
+ * @Author 鍗㈠簡闃�
+ * @Date 2023/10/30
+ */
+ public List<BaseGoodsModels> queryByGoodsTemplatesId(Long goodsTemplatesId) {
+ BaseGoodsModels baseGoodsModels = new BaseGoodsModels();
+ baseGoodsModels.setGoodsTemplatesId(goodsTemplatesId);
+ return this.select(baseGoodsModels);
+ }
}
--
Gitblit v1.9.1