1

lige

2023-12-13 55656cdf4c311d1e6a138173ba5e5bd09c23d340

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

@@ -88,4 +88,36 @@
    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Select("SELECT * FROM tjv_Ltkj_hysqd  where tmh=#{id}")
    public LtkjHysqd getHysqdById(String id);


    //体检登记接口  调用后  查询收费单据和详情
    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Select("SELECT * FROM tjv_Ltkj_middle_head where pat_bar_code=#{id}")
    public List<LtkjMiddleHead> saveMiddleHeadByPatId(String id);

    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Select("SELECT * FROM tjv_Ltkj_middle_detail where fead_id=#{id}")
    public List<LtkjMiddleDetail> getMiddleDetailByHeadId(String id);


    //根据体检号  对应的   化验项目    +“血清”标本
    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Select("SELECT * FROM tjv_Ltkj_hysqd where tjh=#{id}")
    public List<LtkjHysqd> getHysqdByTmh(String id);
    //化验项目下的子项    传上面的接口的tmh
    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Select("SELECT * FROM tjv_Ltkj_hybgd where tmh=#{id}")
    public  List<LtkjHybgd> getHybgdByTmh(String id);


    //根据体检号  对应的  检查项目
    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Select("SELECT * FROM tjv_exam_jcsqd where tjh=#{id}")
    public List<LtkjExamJcsqd> getExamJcsqdTmh(String id);

    //检查项目对应的检查结果  传上面的接口的结果tmh
    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Select("SELECT * FROM tjv_exam_jcbgd where tmh=#{id}")
    public List<LtkjExamJcbgd> getExamJcbgdByTjh(String id);

}