Index: ssts-web/src/main/webapp/disinfectsystem/config/kpszxyy/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/kpszxyy/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/kpszxyy/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml	(revision 28215)
@@ -0,0 +1,41 @@
+<?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 [hospitalNumber] AS patientNumber
+    
+      ,[patientName]AS patientName
+      ,[patientAge] patientAge
+      ,[patientSex] patientSex
+      ,[patientIDCard] patientIDCard
+      ,[doctorName]  doctorName
+      ,[operation] operation
+	       
+	FROM V_IP_PATIENT
+	WHERE hospitalNumber = #{hospitalNum}
+	]]>
+  </select>
+  
+  <!-- 按住院号查找病人信息:提供给外来器械申请单页面的按住院号查询 -->
+  <select id="findPatientInfoByHospitalNumBeforeOperation" resultType="PatientInfoVO">
+  <![CDATA[
+	  SELECT [hospitalNumber] AS patientNumber
+    
+      ,[patientName]AS patientName
+      ,[patientAge] patientAge
+      ,[patientSex] patientSex
+      ,[patientIDCard] patientIDCard
+      ,[doctorName]  doctorName
+      ,[operation] operation
+	       
+	FROM V_IP_PATIENT
+	WHERE hospitalNumber = #{hospitalNum}
+	]]>
+  </select>
+  
+</mapper>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/kpszxyy/interfaces/mybatis/syncToHERP_Mapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/kpszxyy/interfaces/mybatis/syncToHERP_Mapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/kpszxyy/interfaces/mybatis/syncToHERP_Mapper.xml	(revision 28215)
@@ -0,0 +1,140 @@
+<?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.inventorymanagement.dao.WriteBackInventoryDao">
+
+  <sql id="writeBackEntryFields">
+   (serialNumber,departCoding,time,operator,type) 
+  </sql>
+  
+  <insert id="insertWriteBackEntryForInvoice" useGeneratedKeys="true" keyProperty="id">
+	INSERT INTO Write_Back 
+	<include refid="writeBackEntryFields"/>
+	VALUES
+	(
+		#{serialNumber}
+		, #{departCoding}
+		, #{time}
+		, #{operator}
+		, #{type}
+	)
+  </insert>
+  
+  <insert id="insertWriteBackEntryForReturnGoods" useGeneratedKeys="true" keyProperty="id">
+	INSERT INTO Write_Back 
+	<include refid="writeBackEntryFields"/>
+	VALUES
+	(
+		#{serialNumber}
+		, #{departCoding}
+		, #{time}
+		, #{operator}
+		, '22'
+	)
+  </insert>
+  
+  <insert id="insertWriteBackEntryForStorageOut" useGeneratedKeys="true" keyProperty="id">
+	INSERT INTO Write_Back 
+	<include refid="writeBackEntryFields"/>
+	VALUES
+	(
+		#{serialNumber}
+		, #{departCoding}
+		, #{time}
+		, #{operator}
+		, '14'
+	)
+  </insert>
+  
+  
+   <insert id="insertWriteBackEntryForReceiverecord" useGeneratedKeys="true" keyProperty="id">
+	INSERT INTO Write_Back 
+	<include refid="writeBackEntryFields"/>
+	VALUES
+	(
+		#{serialNumber}
+		, #{departCoding}
+		, #{time}
+		, #{operator}
+		, '2'
+	)
+  </insert>
+  
+  <sql id="insertWriteBackEntryItemCommon">
+	INSERT INTO Write_Back_Item
+	(writeBackEntryId,inventorySerialNumber,batchNumber,expDate,amount,unitPrice,fluctuationUnitPrice)
+	<foreach collection="items" item="item" index="index" open="(" close=")" separator="union all">
+	    SELECT #{item.writeBackEntryId}
+	   			, #{item.inventorySerialNumber}
+	   			, #{item.batchNumber}
+	   			, #{item.expDate}
+	   			, #{item.amount}
+	   			, #{item.unitPrice}
+	   			, #{item.fluctuationUnitPrice}
+  	</foreach>
+  </sql>
+  
+  <insert id="insertWriteBackEntryItemForInvoice">
+  	<include refid="insertWriteBackEntryItemCommon"/>
+  </insert>
+  
+  <insert id="insertWriteBackEntryItemForReturnGoods">
+  	<include refid="insertWriteBackEntryItemCommon"/>
+  </insert>
+  
+  <insert id="insertWriteBackEntryItemForStorageOut">
+  	<include refid="insertWriteBackEntryItemCommon"/>
+  </insert>
+  
+  <insert id="insertWriteBackEntryItemForReceiverecord">
+  	<include refid="insertWriteBackEntryItemCommon"/>
+  </insert>
+  
+  <sql id="deleteWriteBackEntryCommon">
+  	<![CDATA[
+  	DELETE FROM Write_Back
+  	WHERE id = #{entryId}
+  	]]>
+  </sql>
+  
+  <sql id="deleteWriteBackEntryItemCommon">
+  	<![CDATA[
+  	DELETE FROM Write_Back_Item
+  	WHERE writeBackEntryId = #{entryId}
+  	]]>
+  </sql>
+  
+  <delete id="deleteWriteBackEntryForInvoice">
+  	<include refid="deleteWriteBackEntryCommon"/>
+  </delete>
+  
+  <delete id="deleteWriteBackEntryItemForInvoice">
+  	<include refid="deleteWriteBackEntryItemCommon"/>
+  </delete>
+  
+  <delete id="deleteWriteBackEntryForReturnGoods">
+  	<include refid="deleteWriteBackEntryCommon"/>
+  </delete>
+  
+  <delete id="deleteWriteBackEntryItemForReturnGoods">
+  	<include refid="deleteWriteBackEntryItemCommon"/>
+  </delete>
+  
+  <delete id="deleteWriteBackEntryForStorageOut">
+  	<include refid="deleteWriteBackEntryCommon"/>
+  </delete>
+  
+  <delete id="deleteWriteBackEntryItemForStorageOut">
+  	<include refid="deleteWriteBackEntryItemCommon"/>
+  </delete>
+  
+  <delete id="deleteWriteBackEntryForReceiverecord">
+  	<include refid="deleteWriteBackEntryCommon"/>
+  </delete>
+  
+  <delete id="deleteWriteBackEntryItemForReceiverecord">
+  	<include refid="deleteWriteBackEntryItemCommon"/>
+  </delete>
+  
+</mapper>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/kpszxyy/interfaces/mybatis/syncFromHERP_Mapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/kpszxyy/interfaces/mybatis/syncFromHERP_Mapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/kpszxyy/interfaces/mybatis/syncFromHERP_Mapper.xml	(revision 28215)
@@ -0,0 +1,95 @@
+<?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.inventorymanagement.dao.InventoryDao">
+  
+  <!-- 按时间查找入库单 -->
+  <select id="findInEntryByTime" resultType="StorageEntry">
+  	<![CDATA[
+	SELECT serialNumber,
+        	time,
+	        remark
+	FROM CSSD_MaterialEntry where 1=1
+	]]>
+	<if test="startDate != null">
+		and time >= #{startDate}
+	</if>
+	<if test="endDate != null">
+		<![CDATA[
+		and time <= #{endDate}
+		]]>
+	</if>
+	ORDER BY time
+  </select>
+  
+  <!-- 按单号查找入库单明细 -->
+  <select id="findInEntryItem" resultType="StorageEntryItem">
+  	<![CDATA[
+	SELECT inventorySerialNumber,
+	       batchNumber,
+	       expDate,
+	       amount,
+	       cost,
+	       manufacturer,
+	       name,
+	       specification,
+	       category
+	FROM CSSD_MaterialEntryItem t1
+	WHERE t1.serialNumber = #{inEntrySerialNumber}
+	]]>
+  </select>
+  
+  <!-- 按物资编码查找物资信息 -->
+  <select id="getInventory" resultType="Inventory">
+  	<![CDATA[
+	SELECT serialNumber,
+	       name,
+	       specification,
+	       category,
+	       unit,
+	       cost
+	FROM CSSD_MaterialDefinition
+	WHERE serialNumber = #{inventorySerialNumber}
+	]]>
+  </select>
+  
+  <!-- 按时间查找退库单 -->
+  <!-- 中山眼科中心无需从物资系统同步退库单 -->
+  <select id="findOutEntryByTime" resultType="StorageEntry">
+  	<![CDATA[
+	SELECT serialNumber,
+        	time,
+	        remark
+	FROM CSSD_GodownEntry
+	]]>
+	<if test="startDate != null">
+		and time >= #{startDate}
+	</if>
+	<if test="endDate != null">
+		<![CDATA[
+		and time <= #{endDate}
+		]]>
+	</if>
+	ORDER BY time
+  </select>
+  
+  <!-- 按单号查找退库单明细 -->
+  <!-- 中山眼科中心无需从物资系统同步退库单 -->
+  <select id="findOutEntryItem" resultType="StorageEntryItem">
+  	<![CDATA[
+	SELECT inventorySerialNumber,
+	       name,
+	       specification,
+	       batchNumber,
+	       expDate,
+	       category,
+	       cost,
+	       amount,
+	       manufacturer
+	FROM CSSD_GodownEntryItem
+	WHERE serialNumber = #{inventorySerialNumber}
+	]]>
+  </select>
+  
+</mapper>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/kpszxyy/interfaces/mybatis/SyncOrgUnitAndUserMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/kpszxyy/interfaces/mybatis/SyncOrgUnitAndUserMapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/kpszxyy/interfaces/mybatis/SyncOrgUnitAndUserMapper.xml	(revision 28215)
@@ -0,0 +1,26 @@
+<?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 coding,name,parentCoding
+	FROM V_DEPARTMENT where coding is not null and len(coding) > 0
+	and name is not null and len(name) > 0
+	and coding != '0'
+	]]>
+  </select>
+  
+  <!-- 获取所有用户 -->
+  <select id="getAllUser" resultType="UserVo">
+  <![CDATA[
+	SELECT coding,name,orgUnitCoding
+	FROM V_USER where coding is not null and len(coding) > 0
+	and name is not null and len(name) > 0
+	ORDER BY coding
+	]]>
+  </select>
+</mapper>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/kpszxyy/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/kpszxyy/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/kpszxyy/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml	(revision 28215)
@@ -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 patientNumber,
+        	h.patientName patientName,
+	        h.patientAge patientAge,
+	        h.patientSex patientSex,
+	        h.patientIDCard patientIDCard,
+	        '' doctorName,
+	        '' operation
+	FROM V_MZ_PATIENT H
+	WHERE h.clinicNumber = #{treatmentNum}
+	]]>
+  </select>
+
+</mapper>
\ No newline at end of file