zjh20250205

zjh

2025-02-05 c176d20e59d15d137ab783e260d704b864b6ced0

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

@@ -3,6 +3,7 @@
import com.ltkj.common.annotation.DataSource;
import com.ltkj.common.enums.DataSourceType;
import com.ltkj.hosp.sqlDomain.*;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
@@ -342,6 +343,16 @@



        @DataSource(value = DataSourceType.SLAVE_WS)
    @Select("SELECT * from  lis_result a where  a.brid=#{tjNum}")
    List<Aws> getWsxmLtkjHysqdByLisViBySLAVEWS(String tjNum);


//    @Delete("delete from  aws  where  brid=#{tjNum}")
    @Delete("DELETE FROM aws WHERE brid=#{tjNum}")
    void delWsxmjg(String tjNum);


    @DataSource(value = DataSourceType.SLAVE_PACS)
    @Select("SELECT * FROM ris.V_TJ_JCBGXX_NEWTJ")
    List<Map<String, Object>> getCcXZxYyPacsJgSt();
@@ -433,8 +444,4 @@
            "FROM\n" +
            "  LTEMR.V_TJ_JCBGXX_NEWTJ a  WHERE trim(a.HIS_ID)=#{tjNum}")
    List<LtkjExamJcbgd> getCcXZxYyPacsLtkjExamJcbgd1(String tjNum);

    @DataSource(value = DataSourceType.MASTER)
    @Select("call tj_bingzhongtongji(#{p_start,mode=IN},#{p_end,mode=IN})")
    List<Map<String ,Object>> getBingZhongInfo(@Param("p_start") String start,@Param("p_end") String end);
}