From ed6339989c79028b8d336283ce9ab457792445f5 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期二, 10 十二月 2024 00:59:37 +0800
Subject: [PATCH] 增加pacs检查数据获取

---
 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java
index 49a6624..4150ea3 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java
@@ -246,7 +246,7 @@
             "  NULL bbbh,\n" +
             "  NULL bbmc,\n" +
             "  a.SFXMID xmid,\n" +
-            "  a.SFXMNAME xmmc,\n" +
+            "  REPLACE(a.SFXMNAME,'tj_','') xmmc,\n" +
             "  a.SENDDATE sqsj,\n" +
             "  a.SENDDOCTOR sqys,\n" +
             "  a.CHECKDATE jgsj,\n" +
@@ -302,7 +302,7 @@
             "  NULL bgysid,\n" +
             "  a.SQRJ sqsj,\n" +
             "  a.BGSJ jgsj,\n" +
-            "  a.JCMC jcxmmc,\n" +
+            "  REPLACE(a.JCMC,'tj_','') jcxmmc,\n" +
             "  a.JCMCID jcxmid,\n" +
             "  a.JCBW bw,\n" +
             "  TRIM(a.JCJL) jgzt,\n" +

--
Gitblit v1.8.0