| | |
| | | "FROM\n" + |
| | | " vi_his_patientresult a JOIN vi_his_patientinfo b ON b.SAMPLEID=a.SAMPLEID\n" + |
| | | "WHERE b.PATIENTTYPE=3 AND\n" + |
| | | " a.SAMPLEID = #{tmh}") |
| | | " a.SAMPLEID = #{tmh} ORDER BY a.PRINTORDER") |
| | | List<LtkjHybgd> getCcXZxYyLtkjHybgdByLisVi(String tmh); |
| | | |
| | | |
| | |
| | | " 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); |
| | | |