| | |
| | | "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); |
| | | |
| | | |
| | |
| | | " a.SQRJ 申请时间,\n" + |
| | | " a.JCBW 检查部位\n" + |
| | | "FROM\n" + |
| | | "V_TJ_JCBGXX_NEWTJ a WHERE a.HIS_ID=#{tjNum} AND a.HOSTPITALID = #{hosp}") |
| | | "ris.V_TJ_JCBGXX_NEWTJ a WHERE a.HIS_ID=#{tjNum} AND a.HOSTPITALID = #{hosp}") |
| | | List<Map<String, Object>> sysgetCcXZxYyPacsLtkjExamJcsqd(@Param("tjNum") String tjNum,@Param("hosp") String hosp); |
| | | |
| | | |
| | |
| | | " 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); |
| | | |