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