Index: ssts-web/src/main/resources/config/gyey/mybatis/FindPatientInfoByHospitalNumMapper.xml
===================================================================
diff -u -r20003 -r23457
--- ssts-web/src/main/resources/config/gyey/mybatis/FindPatientInfoByHospitalNumMapper.xml	(.../FindPatientInfoByHospitalNumMapper.xml)	(revision 20003)
+++ ssts-web/src/main/resources/config/gyey/mybatis/FindPatientInfoByHospitalNumMapper.xml	(.../FindPatientInfoByHospitalNumMapper.xml)	(revision 23457)
@@ -4,7 +4,7 @@
   "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 <mapper namespace="com.forgon.disinfectsystem.datasynchronization.dao.FindPatientInfoByHospitalNumDao">
   
-  <!-- 按住院号查找病人信息:提供给使用记录页面的按住院号查询  -->
+  <!-- 按住院号查找病人信息:提供给使用记录页面的按住院号查询 -->
   <select id="findPatientInfoByHospitalNum" resultType="PatientInfoVO">
   <![CDATA[
 	SELECT h.hospitalNumber as patientNumber,
@@ -13,17 +13,12 @@
 	        h.patientSex as patientSex,
 	        h.patientIDCard as patientIDCard,
 	        h.doctorName as doctorName,
-	        h.roomNumber as roomNumber,
-	        h.bedNumber as bedNumber,
-	        h.patientArea as patientArea,
-	        h.visitAmount as visitId
-	        
-	FROM PatientAdmissionInfo as h
+	        h.operation as operation
+	FROM CSSD_HospitalNumber h
 	WHERE h.hospitalNumber = #{hospitalNum}
-  	]]>
+    ORDER BY h.serialNumber DESC, h.operationTime DESC
+	]]>
   </select>
-  <!--    ORDER BY h.serialNumber DESC, h.operationTime DESC-->
-     <!-- h.operation as operation-->
   
   <!-- 按住院号查找病人信息:提供给外来器械申请单页面的按住院号查询 -->
   <select id="findPatientInfoByHospitalNumBeforeOperation" resultType="PatientInfoVO">
@@ -34,14 +29,10 @@
 	        h.patientSex as patientSex,
 	        h.patientIDCard as patientIDCard,
 	        h.doctorName as doctorName,
-	        h.roomNumber as roomNumber,
-	        h.bedNumber as bedNumber,
-	        h.patientArea as patientArea,
-	        h.visitAmount as visitId
-	        
-	FROM PatientAdmissionInfo as h
+	        h.operation as operation
+	FROM CSSD_HospitalNumber h
 	WHERE h.hospitalNumber = #{hospitalNum}
+    ORDER BY h.serialNumber DESC, h.operationTime DESC
 	]]>
   </select>
-  
 </mapper>
\ No newline at end of file
Index: ssts-web/src/main/resources/config/gyey/mybatis/FindPatientInfoByHospitalNumLocalDataMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/resources/config/gyey/mybatis/FindPatientInfoByHospitalNumLocalDataMapper.xml	(revision 0)
+++ ssts-web/src/main/resources/config/gyey/mybatis/FindPatientInfoByHospitalNumLocalDataMapper.xml	(revision 23457)
@@ -0,0 +1,50 @@
+<?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 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.roomNumber as roomNumber,
+	        h.bedNumber as bedNumber,
+	        h.patientArea as patientArea,
+	        h.visitAmount as visitId,
+	        h.surgeryName as operation
+	FROM PatientAdmissionInfo as h
+	WHERE h.hospitalNumber = #{hospitalNum}
+	and h.surgeryName is not null
+	order by h.id 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.roomNumber as roomNumber,
+	        h.bedNumber as bedNumber,
+	        h.patientArea as patientArea,
+	        h.visitAmount as visitId,
+	        h.surgeryName as operation
+	FROM PatientAdmissionInfo as h
+	WHERE h.hospitalNumber = #{hospitalNum}
+	and h.surgeryName is not null
+	order by h.id desc
+  	]]>
+  </select>
+  
+</mapper>
\ No newline at end of file