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;

import javax.annotation.Resource;
import java.util.List;

@Service
public class SOPProductService {

    @Resource
    private SOPProductMapper mapper;

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