From 65bedd623765cb52757fe842b888771767b349df Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期三, 21 六月 2023 11:56:51 +0800
Subject: [PATCH] sop查询
---
src/main/java/com/whyc/service/SOPService.java | 18 ++++++++++++++++++
1 files changed, 18 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/SOPService.java b/src/main/java/com/whyc/service/SOPService.java
index facb0ba..07e9b29 100644
--- a/src/main/java/com/whyc/service/SOPService.java
+++ b/src/main/java/com/whyc/service/SOPService.java
@@ -1,6 +1,7 @@
package com.whyc.service;
import com.whyc.dto.Response;
+import com.whyc.dto.SopDto;
import com.whyc.mapper.SOPMapper;
import com.whyc.pojo.SOP;
import com.whyc.pojo.SOPProduct;
@@ -17,6 +18,7 @@
import java.util.Date;
import java.util.LinkedList;
import java.util.List;
+import java.util.Map;
import java.util.stream.Collectors;
@Service
@@ -150,4 +152,20 @@
public Response add(SOP sop) {
return null;
}
+
+ //鏌ヨsop淇℃伅
+ public Response getSopInfo(List<SopDto> sqlList, String code, String model) {
+ String sqlStr=" ";
+ if(sqlList!=null&&sqlList.size()>0){
+ for (SopDto dto:sqlList) {
+ if(dto.getChileType().size()>0){
+ for (int i=0;i<dto.getChileType().size();i++){
+ sqlStr+=" and file_type like "+"'%"+dto.getParentType()+"%' ";
+ }
+ }
+ }
+ }
+ List<SOP> list=mapper.getSopInfo(sqlStr,code,model);
+ return new Response().setII(1,list.size()>0,list,"鏌ヨsop淇℃伅");
+ }
}
--
Gitblit v1.9.1