Index: ssts-web/src/main/webapp/disinfectsystem/config/cssdsyy/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml
===================================================================
diff -u -r28163 -r33479
--- ssts-web/src/main/webapp/disinfectsystem/config/cssdsyy/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml	(.../FindPatientInfoByHospitalNumMapper.xml)	(revision 28163)
+++ ssts-web/src/main/webapp/disinfectsystem/config/cssdsyy/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml	(.../FindPatientInfoByHospitalNumMapper.xml)	(revision 33479)
@@ -1,4 +1,4 @@
-<?xml version="1.0" encoding="UTF-8"?>
+<?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">
@@ -7,32 +7,42 @@
   <!-- 按住院号查找病人信息:提供给使用记录页面的按住院号查询 -->
   <select id="findPatientInfoByHospitalNum" resultType="PatientInfoVO">
   <![CDATA[
-	SELECT h.hospitalNumber as patientNumber,
-        	h.patientName as patientName,
-	        h.patientAge as patientAge,
-	        h.patientSex as patientSex,
-	        h.patientIDCard as patientIDCard,
-	        h.doctorName as doctorName,
-	        h.operation as operation
-	FROM CSSD_HospitalNumber h
-	WHERE h.hospitalNumber = #{hospitalNum}
-    ORDER BY h.serialNumber DESC, h.operationTime DESC
+	SELECT hospitalNumber,
+           searialNumber,
+           patientName,
+           patientAge,
+           patientSex,
+           patientIDCard,
+           doctorName,
+           operation,
+           operationTime,
+           patientArea,
+           roomNumber,
+           bedNumber
+	FROM CSSD_HospitalNumber
+	WHERE hospitalNumber = #{hospitalNum}
+    ORDER BY bedNumber DESC
 	]]>
   </select>
   
   <!-- 按住院号查找病人信息:提供给外来器械申请单页面的按住院号查询 -->
   <select id="findPatientInfoByHospitalNumBeforeOperation" resultType="PatientInfoVO">
   <![CDATA[
-	SELECT h.hospitalNumber as patientNumber,
-        	h.patientName as patientName,
-	        h.patientAge as patientAge,
-	        h.patientSex as patientSex,
-	        h.patientIDCard as patientIDCard,
-	        h.doctorName as doctorName,
-	        h.operation as operation
-	FROM CSSD_HospitalNumber h
-	WHERE h.hospitalNumber = #{hospitalNum}
-    ORDER BY h.serialNumber DESC, h.operationTime DESC
+	SELECT hospitalNumber,
+           searialNumber,
+           patientName,
+           patientAge,
+           patientSex,
+           patientIDCard,
+           doctorName,
+           operation,
+           operationTime,
+           patientArea,
+           roomNumber,
+           bedNumber
+	FROM CSSD_HospitalNumber
+	WHERE hospitalNumber = #{hospitalNum}
+    ORDER BY bedNumber DESC
 	]]>
   </select>
 </mapper>
\ No newline at end of file