From 88455df02d78b850df5a73c6fe3795c0dddaa3c4 Mon Sep 17 00:00:00 2001
From: zjh <zjh@888>
Date: 星期四, 01 二月 2024 14:39:01 +0800
Subject: [PATCH] zjh 本地 2024/02/2 -1
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java
index 6cfa9ed..00c6fae 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java
@@ -118,7 +118,8 @@
"\tand (case WHEN #{checkType} is NOt NULL THEN a.pro_check_type=#{checkType} ELSE 1=1 END)\n" +
"\tand (case WHEN #{deptId} is NOt NULL THEN a.dept_id=#{deptId} ELSE 1=1 END)\n" +
") c\n" +
- "on c.pro_parent_id=b.pro_id\n" +
+ "on c.pro_parent_id=b.pro_id WHERE c.pro_parent_id=b.pro_id AND " +
+ "(case WHEN #{deptId} is NOt NULL THEN b.dept_id=#{deptId} ELSE 1=1 END)\n" +
") d\n")
List<TjProject> getProBySqlAndName(@Param("proName")String proName,@Param("checkType")String checkType,@Param("deptId")String deptId);
--
Gitblit v1.8.0