验收报告修改

whyclxw

2 天以前 cf9a5039e6db9d1d5963e3fe1a37d00169ec2ef7

 src/main/java/com/whyc/service/SOPProductService.java

@@ -1,5 +1,9 @@
package com.whyc.service;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
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.mapper.SOPProductMapper;
import com.whyc.pojo.SOPProduct;
import org.springframework.stereotype.Service;
@@ -16,4 +20,18 @@
    public void insertBatch(List<SOPProduct> sopProductList) {
        mapper.insertBatchSomeColumn(sopProductList);
    }

    public void updateBySid(List<SOPProduct> sopProductList,int sid) {
        QueryWrapper wrapper= Wrappers.query();
        wrapper.eq("sop_id",sid);
        List list=mapper.selectList(wrapper);
        if(list.size()>0) {
            //先删除
            UpdateWrapper delWrapp=Wrappers.update();
            delWrapp.eq("sop_id",sid);
            mapper.delete(delWrapp);
        }
        //再插入
        mapper.insertBatchSomeColumn(sopProductList);
    }
}