From 0892d843cd394f383ff50f480f7f22f2ec3829bc Mon Sep 17 00:00:00 2001 From: zhaowenxuan <chacca165@163.com> Date: 星期五, 27 六月 2025 20:24:45 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java | 14 ++++++++++++++ 1 files changed, 14 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 8dd0c2f..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 @@ -199,4 +199,18 @@ 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); + + + @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