From d8f9c8b8cc744ddaefe7144beafc68c8fb8906c3 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期二, 22 四月 2025 17:35:46 +0800
Subject: [PATCH] zjh20250422
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java | 27 ++++++++-------------------
1 files changed, 8 insertions(+), 19 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 009d37f..e8d18e9 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
@@ -311,8 +311,8 @@
" NULL tdh,\n" +
" a.RESULT jyjg,\n" +
" a.UNIT jgdw,\n" +
- " a.RANGEDOWN fwzdz,\n" +
- " a.RANGEUP fwzgz,\n" +
+ " a.RANGEDOWN fwzgz,\n" +
+ " a.RANGEUP fwzdz,\n" +
" CONCAT(a.RANGEDOWN,'-',a.RANGEUP) fwz,\n" +
" b.CHECKDATE jysj,\n" +
" b.CHECKER jyys,\n" +
@@ -406,23 +406,6 @@
@DataSource(value = DataSourceType.SLAVE_PACS)
-// @Select(" SELECT\n" +
-// " trim(a.HIS_ID) tjh,\n" +
-// " trim(a.HIS_ID) tmh,\n" +
-// " trim(a.JCMID) xmdm,\n" +
-// " a.JCMC xmmc,\n" +
-// " NULL bg_mig,\n" +
-// " NULL bg_url,\n" +
-// " TRIM(a.JCSJ) bg_nr,\n" +
-// " a.SHYS shysdm,\n" +
-// " a.SHYS shysxm,\n" +
-// " TRIM(a.JCJL) yxbx,\n" +
-// " a.BGSJ zdsj,\n" +
-// " a.SQRJ sqsj,\n" +
-// " a.JCBW jcbw,\n" +
-// " SYSDATE create_time\n" +
-// "FROM\n" +
-// " ris.V_TJ_JCBGXX_NEWTJ a WHERE a.HIS_ID=#{tjNum}")
@Select(" SELECT\n" +
" trim(a.HIS_ID) tjh,\n" +
" trim(a.HIS_ID) tmh,\n" +
@@ -491,4 +474,10 @@
@DataSource(value = DataSourceType.MASTER)
@Select("call tj_bingzhongtongji(#{p_start,mode=IN},#{p_end,mode=IN})")
List<Map<String ,Object>> getBingZhongInfo(@Param("p_start") String start,@Param("p_end") String end);
+
+ @Select("SELECT * FROM v_ws_sqd WHERE tjh = #{tjh}")
+ List<LtkjHysqd> getWsHySqdByView(@Param("tjh") String tjh);
+
+ @Select("SELECT * FROM v_ws_bgd WHERE tmh = #{tmh}")
+ List<LtkjHybgd> getWsHyBgdByView(@Param("tmh") String tmh);
}
--
Gitblit v1.8.0