| | |
| | | " \n" + |
| | | "FROM\n" + |
| | | " vi_his_patientinfo a\n" + |
| | | "WHERE a.HOSPITALID='chkwyy' AND a.PATIENTTYPE=3 AND a.GH_PATIENTNO =#{tjNum}") |
| | | "WHERE a.PATIENTTYPE=3 AND a.GH_PATIENTNO =#{tjNum}") |
| | | List<LtkjHysqd> getCcXZxYyLtkjHysqdByLisVi(String tjNum); |
| | | |
| | | |
| | |
| | | " SYSDATE() create_time\n" + |
| | | "FROM\n" + |
| | | " vi_his_patientresult a JOIN vi_his_patientinfo b ON b.SAMPLEID=a.SAMPLEID\n" + |
| | | "WHERE b.HOSPITALID='chkwyy' AND b.PATIENTTYPE=3 AND\n" + |
| | | "WHERE b.PATIENTTYPE=3 AND\n" + |
| | | " a.SAMPLEID = #{tmh}") |
| | | List<LtkjHybgd> getCcXZxYyLtkjHybgdByLisVi(String tmh); |
| | | |