zjh20241205-3

zjh

2024-12-06 dcd7d62c2bf627d22dfa042b7d92a913af6378c3

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

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


@@ -304,8 +305,8 @@
            "  a.JCMC jcxmmc,\n" +
            "  a.JCMCID jcxmid,\n" +
            "  a.JCBW bw,\n" +
            "  a.JCJL jgzt,\n" +
            "  a.JCSJ jgbx\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}")
@@ -320,10 +321,10 @@
            "  a.JCMC xmmc,\n" +
            "  NULL bg_mig,\n" +
            "  NULL bg_url,\n" +
            "  a.JCSJ bg_nr,\n" +
            "  TRIM(a.JCSJ) bg_nr,\n" +
            "  a.SHYS shysdm,\n" +
            "  a.SHYS shysxm,\n" +
            "  a.JCJL yxbx,\n" +
            "  TRIM(a.JCJL) yxbx,\n" +
            "  a.BGSJ zdsj,\n" +
            "  a.SQRJ sqsj,\n" +
            "  a.JCBW jcbw\n" +