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