0108、0109开头的物料BOM清单上传的时候覆盖之前相同编码的物料，保留之前的附件及附件状态

whycxzp

2023-12-22 5460c97d61ecea5818b97a6c6c59334b9dd1c49f

 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);
        }
    }
}