检查申请单插入前查询判断

zhaowenxuan

2024-07-25 22915f206dae518b291762d7b5ef3c4143cd79b8

检查申请单插入前查询判断

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

@@ -38,6 +38,10 @@
            "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")

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcsqdService.java

@@ -26,4 +26,6 @@
    void saveLtkjExamJcsqd(String tjh);

    AjaxResult getTjJcProByHisCall(String ksmc,String strIn,String brid,int pagecount,int page,String status);

    List<LtkjExamJcbgd> queryLtkjExamJcsqdByTjh(String tjh);
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java

@@ -4,6 +4,7 @@
import com.ltkj.common.core.domain.AjaxResult;
import com.ltkj.hosp.mapper.LtkjExamJcsqdMapper;
import com.ltkj.hosp.service.LtkjExamJcsqdService;
import com.ltkj.hosp.sqlDomain.LtkjExamJcbgd;
import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
@@ -56,6 +57,11 @@
    }

    @Override
    public List<LtkjExamJcbgd> queryLtkjExamJcsqdByTjh(String tjh) {
        return mapper.queryLtkjExamJcsqdByTjh(tjh);
    }

    @Override
    public void saveLtkjExamJcsqd(String tjh) {
        mapper.saveLtkjExamJcsqd(tjh);
    }