From 92db9e7f8e1f79f5b61266382149843159907157 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期二, 12 八月 2025 18:03:00 +0800
Subject: [PATCH] zjh20250812
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java | 6 ++++++
1 files changed, 6 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 696482c..ccf3204 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
@@ -327,4 +327,10 @@
@Select("call newpacsJianChaData(#{tjnumber,mode=IN},0)")
List<TjOrderRemark> newpacsJianChaData(String tjnumber);
+
+
+ @Select(" SELECT b.pro_name 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")
+ List<String> getTjxm(String tjNumber);
}
--
Gitblit v1.8.0