From 05af9bff8288d3052fff67a6e6d63857110fee37 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期一, 26 五月 2025 14:54:06 +0800
Subject: [PATCH] zjh20250526
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java | 10 +++++++++-
1 files changed, 9 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 8dd0c2f..6720d5a 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
@@ -153,7 +153,7 @@
List<TjProject> getPacTjProjectList();
- @Select("SELECT a.pro_id FROM tj_project a JOIN sys_dept b ON a.dept_id=b.dept_id WHERE a.deleted=0 AND b.parent_org_code='A30' AND a.need_report='Y' and a.pro_status=0")
+ @Select("SELECT a.pro_id FROM tj_project a JOIN sys_dept b ON a.dept_id=b.dept_id WHERE a.deleted=0 AND b.org_type=1 AND a.need_report='Y' and a.pro_status=0")
List<Long> getHuaYanProId();
@Select("SELECT a.pro_id FROM tj_project a JOIN sys_dept b ON a.dept_id=b.dept_id WHERE a.deleted=0 AND b.parent_org_code='A32' AND a.need_report='Y' and a.pro_status=0")
@@ -199,4 +199,12 @@
List<Map<String ,Object>> getLisViewList();
+
+@Select("call getProListByBblx(#{bblx,mode=IN}) ")
+ List<TjProject> getProListByBblx(@Param(value ="bblx")String bblx);
+
+
+ @Select("call getProListByBwwh(#{bw,mode=IN}) ")
+ List<TjProject> getProListByBwwh(String bw);
+
}
--
Gitblit v1.8.0