From 9ac01b48ef00a0855306d72e8c680b912a9a8d03 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期四, 07 八月 2025 08:44:50 +0800
Subject: [PATCH] zjh20250807

---
 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java |   10 ++++++++++
 1 files changed, 10 insertions(+), 0 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 182a3e4..f59e9e2 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
@@ -324,4 +324,14 @@
     void csymxmxzqtyybcjk(@Param("tjh")String tjNum,@Param("xmid") String proId,@Param("yy") String yy,
                           @Param("kslx") String orgType,@Param("czy") String czy,@Param("czydm") String czydm);
 
+
+    @Select("call newpacsJianChaData(#{tjnumber,mode=IN},0)")
+    List<TjOrderRemark> newpacsJianChaData(String tjnumber);
+
+
+    @Select(" SELECT CONCAT(CONCAT('鍏�',COUNT(*),'椤�'),': '," +
+            "TRIM(GROUP_CONCAT(b.pro_name ORDER BY b.pro_name SEPARATOR ' | '))) AS xmm" +
+            " FROM tj_order_remark a LEFT JOIN tj_project b ON b.pro_id=a.pro_id" +
+            " WHERE a.tj_number=#{tjNumber} AND a.type !=2 AND a.deleted=0")
+    String getTjxm(String tjNumber);
 }

--
Gitblit v1.8.0