From 3620453ef3ebf3ba1542c180d942443a4a934d67 Mon Sep 17 00:00:00 2001 From: zjh <1084500556@qq.com> Date: 星期三, 25 六月 2025 18:05:04 +0800 Subject: [PATCH] zjh20250625 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java | 5 +++++ 1 files changed, 5 insertions(+), 0 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 9429211..294788c 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 @@ -208,4 +208,9 @@ List<TjProject> getProListByBwwh(String bw); + @Select("SELECT * FROM tj_project a WHERE a.deleted=0 AND a.pro_status=0 AND a.pro_parent_id=0 AND a.pro_id NOT IN (SELECT pro_id FROM tj_bz_pro )") + List<TjProject> selectTjProjectListByBz(); + + + } -- Gitblit v1.8.0