From c4f1fcc51989a014f9737689c123b3266f13ccda Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期二, 20 二月 2024 18:07:44 +0800
Subject: [PATCH] zjh 2024/02/20--1
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java | 7 +++++++
1 files changed, 7 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 3fa8c3d..d9ca84c 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
@@ -134,4 +134,11 @@
@Select("SELECT * FROM `tj_project` where pro_parent_id=#{proId}")
List<TjProject> getAllChildListById(String proId);
+
+ @Select("SELECT * FROM `tj_project` where pro_parent_id=0 and pro_status=0")
+ List<TjProject> getTjProjectList();
+
+
+ @Select("SELECT * FROM `tj_project` where pro_parent_id=0 and pro_status=0 and LOCATE( '浣撴',pro_name) ")
+ List<TjProject> getDxTjProjectList();
}
--
Gitblit v1.8.0