zjh20250407

zjh

2025-04-07 cdfd0e963d66721dfb0410598002273f7d26bc89

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

@@ -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" +
@@ -495,6 +478,6 @@
    @Select("SELECT * FROM v_ws_sqd WHERE tjh = #{tjh}")
    List<LtkjHysqd> getWsHySqdByView(@Param("tjh") String tjh);

    @Select("SELECT * FROM v_ws_bgd WHERE tmh = #{tjh}")
    @Select("SELECT * FROM v_ws_bgd WHERE tmh = #{tmh}")
    List<LtkjHybgd> getWsHyBgdByView(@Param("tmh") String tmh);
}