From 0f658843b92eb41a87cb113c9eb6416e25e76a2e Mon Sep 17 00:00:00 2001 From: zjh <1084500556@qq.com> Date: 星期五, 14 三月 2025 08:42:10 +0800 Subject: [PATCH] zjh20250314 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java | 8 ++++---- 1 files changed, 4 insertions(+), 4 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 5f4306b..a6846ab 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 @@ -260,8 +260,8 @@ " \n" + "FROM\n" + " vi_his_patientinfo a\n" + - "WHERE a.PATIENTTYPE=3 AND a.GH_PATIENTNO =#{tjNum}") - List<LtkjHysqd> getCcXZxYyLtkjHysqdByLisVi(String tjNum); + "WHERE a.PATIENTTYPE=3 AND a.GH_PATIENTNO =#{tjNum} AND a.HOSPITALID =#{dqyyyqbm}") + List<LtkjHysqd> getCcXZxYyLtkjHysqdByLisVi(@Param("tjNum") String tjNum,@Param("dqyyyqbm") String dqyyyqbm); @@ -365,8 +365,8 @@ " SYSDATE create_time\n" + " \n" + "FROM\n" + - " ris.V_TJ_JCBGXX_NEWTJ a WHERE trim(a.HIS_ID)=#{tjNum}") - List<LtkjExamJcsqd> getCcXZxYyPacsLtkjExamJcsqd(String tjNum); + " ris.V_TJ_JCBGXX_NEWTJ a WHERE trim(a.HIS_ID)=#{tjNum} AND a.HOSTPITALID =#{dqyyyqbm} ") + List<LtkjExamJcsqd> getCcXZxYyPacsLtkjExamJcsqd(@Param("tjNum") String tjNum,@Param("dqyyyqbm") String dqyyyqbm); @DataSource(value = DataSourceType.SLAVE_PACS) -- Gitblit v1.8.0