zjh20241202-4

zjh

2024-12-04 decc3b9ce027fe35152b8b387a056c175a9aa08f

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



@@ -284,4 +284,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" +
            "  a.JCMC jcxmmc,\n" +
            "  a.JCMCID jcxmid,\n" +
            "  a.JCBW bw,\n" +
            "  a.JCJL jgzt,\n" +
            "  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" +
            "  a.JCSJ bg_nr,\n" +
            "  a.SHYS shysdm,\n" +
            "  a.SHYS shysxm,\n" +
            "  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);
}