zjh20241205-3

zjh

2024-12-06 c42f62b32bac302a7ac9fcde7489f7c5fc6e11aa

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

@@ -84,8 +84,8 @@
                                   @Param("dockerId")String dockerId);

    @DataSource(value = DataSourceType.MASTER)
    @Select("call tj_update_detatil_by_vi(#{tjnum,mode=IN}")
    public void tjUpdateDetatilByVi(@Param("tjnum")String tjnum);
//    @Select("call tj_update_detatil_by_vi(#{tjnum,mode=IN}")
    public void tjUpdateDetatilByVi(Map<String,Object> map);



@@ -234,7 +234,8 @@


    @DataSource(value = DataSourceType.SLAVE_LIS)
    @Select("SELECT * FROM vi_his_patientresult ")
    @Select("select t.* from vi_his_patientresult t \n" +
            "\tjoin(select * from vi_his_patientinfo t where t.HOSPITALID='chkwyy' and t.PATIENTNO like '800%') b on b.SAMPLEID = t.SAMPLEID")
    List<Map<String, Object>> getCcXZxYyLisJgSt();


@@ -245,7 +246,7 @@
            "  NULL bbbh,\n" +
            "  NULL bbmc,\n" +
            "  a.SFXMID xmid,\n" +
            "  a.SFXMNAME xmmc,\n" +
            "  REPLACE(a.SFXMNAME,'tj_','') xmmc,\n" +
            "  a.SENDDATE sqsj,\n" +
            "  a.SENDDOCTOR sqys,\n" +
            "  a.CHECKDATE jgsj,\n" +
@@ -284,4 +285,50 @@
            "WHERE b.HOSPITALID='chkwyy' AND b.PATIENTTYPE=3 AND\n" +
            "  a.SAMPLEID = #{tmh}")
    List<LtkjHybgd> getCcXZxYyLtkjHybgdByLisVi(String tmh);



    @DataSource(value = DataSourceType.SLAVE_PACS)
    @Select("SELECT * FROM ris.V_TJ_JCBGXX_NEWTJ")
    List<Map<String, Object>> getCcXZxYyPacsJgSt();

    @DataSource(value = DataSourceType.SLAVE_PACS)
    @Select("SELECT\n" +
            "  a.HIS_ID tjh,\n" +
            "  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" +
            "  a.JCMCID jcxmid,\n" +
            "  a.JCBW bw,\n" +
            "  TRIM(a.JCJL) jgzt,\n" +
            "  TRIM(a.JCSJ) jgbx\n" +
            "   \n" +
            "FROM\n" +
            "  ris.V_TJ_JCBGXX_NEWTJ a  WHERE a.HIS_ID=#{tjNum}")
    List<LtkjExamJcsqd> getCcXZxYyPacsLtkjExamJcsqd(String tjNum);


    @DataSource(value = DataSourceType.SLAVE_PACS)
    @Select(" SELECT\n" +
            "  a.HIS_ID tjh,\n" +
            "  a.HIS_ID tmh,\n" +
            "  a.JCMCID 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" +
            "FROM\n" +
            "  ris.V_TJ_JCBGXX_NEWTJ a  WHERE a.HIS_ID=#{tjNum}")
    List<LtkjExamJcbgd> getCcXZxYyPacsLtkjExamJcbgd(String tjNum);
}