From 5f4847d23506f10f76bc5ba493880bb3b87df12c Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期四, 12 十二月 2024 18:55:15 +0800
Subject: [PATCH] zjh202412012

---
 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