zjh20250523

zjh

2025-05-23 ea91e62004a5a86be6c7a5fda852995e1bf3e3a0

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java

@@ -471,24 +471,41 @@


    @DataSource(value = DataSourceType.SLAVE_PACS)
//    @Select("SELECT\n" +
//            "  trim(a.HIS_ID) tjh,\n" +
//            "  trim(a.HIS_ID) tmh,\n" +
//            "  a.JCLX jclx,\n" +
//            "  NULL jczlx,\n" +
//            "  a.BGYS bgys,\n" +
//            "  NULL bgysid,\n" +
//            "  a.SQRJ sqsj,\n" +
//            "  a.BGSJ jgsj,\n" +
//            "  REPLACE(a.JCMC,'tj_','') jcxmmc,\n" +
//            "  trim(a.JCMID) jcxmid,\n" +
//            "  a.JCBW bw,\n" +
//            "  TRIM(a.JCJL) jgzt,\n" +
//            "  TRIM(a.JCSJ) jgbx,\n" +
//            "  SYSDATE create_time\n" +
//            "   \n" +
//            "FROM\n" +
//            "  ris.V_TJ_JCBGXX_NEWTJ a  WHERE trim(a.HIS_ID)=#{tjNum} AND a.HOSTPITALID = #{hosp}")
    @Select("SELECT\n" +
            "  trim(a.HIS_ID) tjh,\n" +
            "  trim(a.HIS_ID) tmh,\n" +
            "  a.JCLX jclx,\n" +
            "  NULL jczlx,\n" +
            "  a.BGYS bgys,\n" +
            "  NULL bgysid,\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.BGSJ jgsj,\n" +
            "  REPLACE(a.JCMC,'tj_','') jcxmmc,\n" +
            "  trim(a.JCMID) jcxmid,\n" +
            "  a.JCBW bw,\n" +
            "  TRIM(a.JCJL) jgzt,\n" +
            "  TRIM(a.JCSJ) jgbx,\n" +
            "  a.JCBW jcbw,\n" +
            "  SYSDATE create_time\n" +
            "   \n" +
            "FROM\n" +
            "  ris.V_TJ_JCBGXX_NEWTJ a  WHERE trim(a.HIS_ID)=#{tjNum} AND a.HOSTPITALID = #{hosp}")
            "  ris.V_TJ_JCBGXX_NEWTJ a  WHERE a.HIS_ID=#{tjNum}  AND a.HOSTPITALID = #{hosp} ")
    List<LtkjExamJcbgd> getCcXZxYyPacsLtkjExamJcbgd(@Param("tjNum") String tjNum,@Param("hosp") String hosp);