zjh20250407

zjh

2025-04-07 cdfd0e963d66721dfb0410598002273f7d26bc89

 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);
}