zjh20241205-3

zjh

2024-12-06 c42f62b32bac302a7ac9fcde7489f7c5fc6e11aa

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

@@ -246,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" +
@@ -302,11 +302,11 @@
            "  NULL bgysid,\n" +
            "  a.SQRJ sqsj,\n" +
            "  a.BGSJ jgsj,\n" +
            "  a.JCMC jcxmmc,\n" +
            "  REPLACE(a.JCMC,'tj_','') 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}")
@@ -321,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" +