zjh20250120

zjh

2025-01-20 73a816fd2b1e29c25d615c85ce34b12b55c16ccf

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

@@ -34,10 +34,14 @@

    @Insert("INSERT INTO  ltkj_exam_jcsqd \n" +
            "SELECT a.tjh,a.tmh,NULL jclx,NULL jczlx,a.shysxm bgys,a.shysdm bgysid,a.sqsj,a.zdsj jgsj, a.xmmc jcxmmc,a.xmdm jcxmid,a.jcbw bw,\n" +
            "a.yxzd jgzt,a.yxbx jgbx\n" +
            "a.yxzd jgzt,a.yxbx jgbx,sysdate()\n" +
            "FROM ltkj_exam_jcbgd a WHERE a.tjh=#{tjh} GROUP BY a.xmmc")
    void saveLtkjExamJcsqd(String tjh);

    @Select("SELECT a.tjh,a.tmh,NULL jclx,NULL jczlx,a.shysxm bgys,a.shysdm bgysid,a.sqsj,a.zdsj jgsj, a.xmmc jcxmmc,a.xmdm jcxmid,a.jcbw bw," +
            "a.yxzd jgzt,a.yxbx jgbx FROM ltkj_exam_jcbgd a WHERE a.tjh=#{tjh} GROUP BY a.xmmc")
    List<LtkjExamJcbgd> queryLtkjExamJcsqdByTjh(String tjh);


    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Qualifier (value = "slaveHisDataSource")