Index: ssts-web/src/main/resources/spring/projects/gdsrmyyzhyy/FindPatientInfoByHospitalNumMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/resources/spring/projects/gdsrmyyzhyy/FindPatientInfoByHospitalNumMapper.xml	(revision 0)
+++ ssts-web/src/main/resources/spring/projects/gdsrmyyzhyy/FindPatientInfoByHospitalNumMapper.xml	(revision 27295)
@@ -0,0 +1,49 @@
+<?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.patientidcard as patientidcard,
+	h.patientname as patientname,
+	h.bednumber as bednumber,
+	h.patientsex as patientsex,
+	concat(sick_id,SEARIALNUMBER) as patientID,
+	h.hospitalNumber as hospitalNumber,
+	h.operation as operation,
+	h.patientage as patientage,
+	h.doctorname as doctorname,
+	h.OPROOMID as OPROOMID,
+	h.patientarea as patientarea
+	FROM zhiydba.cssd_hospitalnumber h
+	WHERE (h.hospitalNumber = #{hospitalNum} or  concat(sick_id,SEARIALNUMBER)= #{hospitalNum})
+	order by SEARIALNUMBER desc
+	]]>
+  </select>
+  
+  <!-- 按住院号查找病人信息:提供给外来器械申请单页面的按住院号查询 -->
+  <select id="findPatientInfoByHospitalNumBeforeOperation" resultType="PatientInfoVO">
+  <![CDATA[
+	SELECT 
+    h.patientidcard as patientidcard,
+	h.patientname as patientname,
+	h.bednumber as bednumber,
+	h.patientsex as patientsex,
+	concat(sick_id,SEARIALNUMBER) as patientID,
+	h.hospitalNumber as hospitalNumber,
+	h.operation as operation,
+	h.patientage as patientage,
+	h.doctorname as doctorname,
+	h.OPROOMID as OPROOMID,
+	h.patientarea as patientarea
+	FROM zhiydba.cssd_hospitalnumber h
+	WHERE (h.hospitalNumber = #{hospitalNum} or  concat(sick_id,SEARIALNUMBER)= #{hospitalNum})
+	order by SEARIALNUMBER desc
+	]]>
+  </select>
+  
+</mapper>
\ No newline at end of file