Index: ssts-web/src/main/webapp/disinfectsystem/config/cssdsyy/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/cssdsyy/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/cssdsyy/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml	(revision 28163)
@@ -0,0 +1,22 @@
+<?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.FindPatientInfoByTreatmentNumDao">
+  
+  <!-- 按门诊号查找病人信息 -->
+  <select id="findPatientInfoByTreatmentNum" resultType="PatientInfoVO">
+  <![CDATA[
+	SELECT h.clinicNumber as patientNumber,
+        	h.patientName as patientName,
+	        h.patientAge as patientAge,
+	        h.patientSex as patientSex,
+	        h.patientIDCard as patientIDCard,
+	        '' as doctorName,
+	        '' as operation
+	FROM CSSD_ClinicNumber h
+	WHERE h.clinicNumber = #{treatmentNum}
+	]]>
+  </select>
+
+</mapper>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/cssdsyy/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/cssdsyy/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/cssdsyy/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml	(revision 28163)
@@ -0,0 +1,38 @@
+<?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.operation as operation
+	FROM CSSD_HospitalNumber h
+	WHERE h.hospitalNumber = #{hospitalNum}
+    ORDER BY h.serialNumber DESC, h.operationTime 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>
+</mapper>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/cssdsyy/interfaces/mybatis/SyncOrgUnitAndUserMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/cssdsyy/interfaces/mybatis/SyncOrgUnitAndUserMapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/cssdsyy/interfaces/mybatis/SyncOrgUnitAndUserMapper.xml	(revision 28163)
@@ -0,0 +1,27 @@
+<?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.SyncOrgUnitAndUserDao">
+  
+  <!-- 获取所有部门 -->
+  <select id="getAllOrgUnit" resultType="OrgUnitVo">
+  <![CDATA[
+	SELECT deptcode as coding,
+        	deptname as name,
+	        '' as parentCoding
+	FROM cssd_department
+	]]>
+  </select>
+  
+  <!-- 获取所有用户 -->
+  <select id="getAllUser" resultType="UserVo">
+  <![CDATA[
+	SELECT usercode as coding,
+        	username as name,
+	        deptcode as orgUnitCoding
+	FROM CSSD_User
+	ORDER BY deptcode
+	]]>
+  </select>
+</mapper>
\ No newline at end of file