From 533eb5e77b6e0f1df382a77f0a06917f3ba78bb9 Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期三, 21 六月 2023 12:08:27 +0800
Subject: [PATCH] sop查询

---
 src/main/java/com/whyc/service/SOPService.java |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/src/main/java/com/whyc/service/SOPService.java b/src/main/java/com/whyc/service/SOPService.java
index 07e9b29..a0fdb3f 100644
--- a/src/main/java/com/whyc/service/SOPService.java
+++ b/src/main/java/com/whyc/service/SOPService.java
@@ -155,12 +155,12 @@
 
     //鏌ヨsop淇℃伅
     public Response getSopInfo(List<SopDto> sqlList, String code, String model) {
-        String sqlStr=" ";
+        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()+"%' ";
+                        sqlStr+=" and file_type like "+"'%"+dto.getParentType()+"-"+dto.getChileType().get(i)+"%' ";
                     }
                 }
             }

--
Gitblit v1.9.1