From d34ddd4ca7b88abe732c1701150f2eac2f7ccbd5 Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期一, 26 六月 2023 14:02:34 +0800
Subject: [PATCH] sop修改查询和更新sop说明
---
src/main/java/com/whyc/service/SOPProductService.java | 18 ++++++++++++++++++
1 files changed, 18 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/SOPProductService.java b/src/main/java/com/whyc/service/SOPProductService.java
index cc18ed2..429992f 100644
--- a/src/main/java/com/whyc/service/SOPProductService.java
+++ b/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);
+ }
}
--
Gitblit v1.9.1