From f2162e182405184e14bfa8d628150ccc49318fc3 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期一, 19 五月 2025 17:11:54 +0800
Subject: [PATCH] 总检页面增加体检类型搜索调整了存储过程

---
 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java |   16 +++++++++-------
 1 files changed, 9 insertions(+), 7 deletions(-)

diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java
index b670d01..a51db9f 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java
@@ -172,15 +172,17 @@
 
 
 
-    @Select("SELECT a.* FROM tj_order_remark a LEFT JOIN sys_dept b ON b.dept_id=a.dept_id LEFT JOIN tj_project c ON c.pro_id=a.pro_id\n" +
-            "\n" +
-            "WHERE a.deleted=0 AND b.org_type = 3  AND c.need_report='Y' AND a.tj_number=#{tjnumber}")
+//    @Select("SELECT a.* FROM tj_order_remark a LEFT JOIN sys_dept b ON b.dept_id=a.dept_id LEFT JOIN tj_project c ON c.pro_id=a.pro_id\n" +
+//            "\n" +
+//            "WHERE a.deleted=0 AND b.org_type = 3 AND c.need_report='Y' AND a.tj_number=#{tjnumber}")
+
+    @Select("call notHuaYanData(#{tjnumber,mode=IN})")
     List<TjOrderRemark> notHuaYanData(String tjnumber);
 
-    @Select("SELECT a.* FROM tj_order_remark a LEFT JOIN sys_dept b ON b.dept_id=a.dept_id LEFT JOIN tj_project c ON c.pro_id=a.pro_id\n" +
-            "\n" +
-            "WHERE a.deleted=0 AND  b.org_type = 2 AND c.need_report='Y' AND a.tj_number=#{tjnumber}")
-//    AND c.need_report='Y' guo
+    //    @Select("SELECT a.* FROM tj_order_remark a LEFT JOIN sys_dept b ON b.dept_id=a.dept_id LEFT JOIN tj_project c ON c.pro_id=a.pro_id\n" +
+//            "\n" +
+//            "WHERE a.deleted=0 AND b.org_type = 2 AND c.need_report='Y' AND a.tj_number=#{tjnumber}")
+    @Select("call pacsJianChaData(#{tjnumber,mode=IN})")
     List<TjOrderRemark> pacsJianChaData(String tjnumber);
 
 

--
Gitblit v1.8.0