From 5460c97d61ecea5818b97a6c6c59334b9dd1c49f Mon Sep 17 00:00:00 2001
From: whycxzp <glperry@163.com>
Date: 星期五, 22 十二月 2023 15:35:28 +0800
Subject: [PATCH] 0108、0109开头的物料BOM清单上传的时候覆盖之前相同编码的物料,保留之前的附件及附件状态

---
 src/main/java/com/whyc/service/AttachLockService.java |   15 +++++++++++++++
 1 files changed, 15 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/whyc/service/AttachLockService.java b/src/main/java/com/whyc/service/AttachLockService.java
index ac10de1..23268bf 100644
--- a/src/main/java/com/whyc/service/AttachLockService.java
+++ b/src/main/java/com/whyc/service/AttachLockService.java
@@ -2,6 +2,7 @@
 
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
 import com.whyc.dto.Response;
 import com.whyc.mapper.AttachLockMapper;
 import com.whyc.pojo.AttachLock;
@@ -63,4 +64,18 @@
         });
         return new Response().set(1,true,"");
     }
+
+    public void getAndInsert(Integer materialIdInDB, Integer materialId) {
+        QueryWrapper<AttachLock> query = Wrappers.query();
+        query.eq("material_id",materialIdInDB).eq("lock_flag",1).eq("product_id",0);
+        List<AttachLock> attachLocksInDB = mapper.selectList(query);
+
+        attachLocksInDB.forEach(attachLock -> {
+            attachLock.setId(null);
+            attachLock.setMaterialId(materialId);
+        });
+        if(attachLocksInDB.size()!=0) {
+            mapper.insertBatchSomeColumn(attachLocksInDB);
+        }
+    }
 }

--
Gitblit v1.9.1