Index: ssts-web/src/main/webapp/disinfectsystem/config/cszxyy/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/cszxyy/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/cszxyy/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml	(revision 28170)
@@ -0,0 +1,39 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper
+  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
+  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.forgon.disinfectsystem.datasynchronization.dao.FindPatientInfoByHospitalNumDao">
+  
+  <!-- 按住院号查找病人信息:提供给使用记录页面的按住院号查询 -->
+  <select id="findPatientInfoByHospitalNum" resultType="PatientInfoVO">
+  <![CDATA[
+	SELECT 病人ID as patientNumber,
+        	姓名 as patientName,
+	        年龄 as patientAge,
+	        性别 as patientSex,
+	        '' as patientIDCard,
+	        主刀医生 as doctorName,
+	        手术名称 as operation
+	FROM v_emr_sm_info
+	WHERE 病人ID = #{hospitalNum}
+    ORDER BY 手术日期及时间 DESC
+	]]>
+  </select>
+  
+  <!-- 按住院号查找病人信息:提供给外来器械申请单页面的按住院号查询 -->
+  <select id="findPatientInfoByHospitalNumBeforeOperation" resultType="PatientInfoVO">
+  <![CDATA[
+	SELECT 病人ID as patientNumber,
+        	姓名 as patientName,
+	        年龄 as patientAge,
+	        性别 as patientSex,
+	        '' as patientIDCard,
+	        主刀医生 as doctorName,
+	        手术名称 as operation
+	FROM v_emr_sm_info
+	WHERE 病人ID = #{hospitalNum}
+    ORDER BY 手术日期及时间 DESC
+	]]>
+  </select>
+  
+</mapper>
\ No newline at end of file