Index: ssts-web/src/main/resources/config/kpszxyy/mybatis/syncToHERP_Mapper.xml
===================================================================
diff -u
--- ssts-web/src/main/resources/config/kpszxyy/mybatis/syncToHERP_Mapper.xml	(revision 0)
+++ ssts-web/src/main/resources/config/kpszxyy/mybatis/syncToHERP_Mapper.xml	(revision 21298)
@@ -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/resources/config/kpszxyy/writeBackInventoryConfig.json
===================================================================
diff -u
--- ssts-web/src/main/resources/config/kpszxyy/writeBackInventoryConfig.json	(revision 0)
+++ ssts-web/src/main/resources/config/kpszxyy/writeBackInventoryConfig.json	(revision 21298)
@@ -0,0 +1,6 @@
+{
+    "发货一次性物品回写": false,
+    "退货一次性物品回写": false,
+    "一次性物品退库单回写": false,
+    "供应室领用一次性物品回写": false
+}
\ No newline at end of file
Index: ssts-web/src/main/resources/config/kpszxyy/mybatis/FindPatientInfoByHospitalNumMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/resources/config/kpszxyy/mybatis/FindPatientInfoByHospitalNumMapper.xml	(revision 0)
+++ ssts-web/src/main/resources/config/kpszxyy/mybatis/FindPatientInfoByHospitalNumMapper.xml	(revision 21298)
@@ -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/resources/config/kpszxyy/mybatis/SyncOrgUnitAndUserMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/resources/config/kpszxyy/mybatis/SyncOrgUnitAndUserMapper.xml	(revision 0)
+++ ssts-web/src/main/resources/config/kpszxyy/mybatis/SyncOrgUnitAndUserMapper.xml	(revision 21298)
@@ -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/resources/spring/projects/kpszxyy/applicationContext-his.xml
===================================================================
diff -u
--- ssts-web/src/main/resources/spring/projects/kpszxyy/applicationContext-his.xml	(revision 0)
+++ ssts-web/src/main/resources/spring/projects/kpszxyy/applicationContext-his.xml	(revision 21298)
@@ -0,0 +1,139 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<beans xmlns="http://www.springframework.org/schema/beans"
+	   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+	   xmlns:context="http://www.springframework.org/schema/context"
+	   xmlns:aop="http://www.springframework.org/schema/aop"
+	   xmlns:tx="http://www.springframework.org/schema/tx"
+	   xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
+           http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd
+           http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd
+           http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd"
+	   default-autowire="byName" default-lazy-init="true">
+
+	<!-- his系统数据库相关注入 -->
+	
+	<context:component-scan base-package="com.forgon.disinfectsystem.datasynchronization.service.*" />
+	 
+    <bean id="dataSynchronizationManagerTarget"
+        class="com.forgon.disinfectsystem.datasynchronization.service.DataSynchronizationManagerImpl" >
+		<property name="config" >
+            <bean class="com.forgon.tools.json.JsonObjectFromResourceFactoryBean">
+                <property name="resource" value="config/kpszxyy/dataSyncConfig.json" />
+                <property name="charset" value="UTF-8" />
+            </bean>
+        </property>
+	</bean>
+    
+    <bean id="dataSynchronizationManager"
+        class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
+        <property name="transactionManager" ref="transactionManager" />
+        <property name="target">
+            <ref local="dataSynchronizationManagerTarget" />
+        </property>
+        <property name="transactionAttributes">
+            <props>
+                <prop key="*">PROPAGATION_REQUIRED,-Exception</prop>
+            </props>
+        </property>
+    </bean>
+    
+    <bean id="dataSynchronizationTableManager"
+        class="com.forgon.disinfectsystem.datasynchronization.dwr.DataSynchronizationTableManager">
+    </bean>
+    
+    <bean id="inventoryManagerTarget"
+		class="com.forgon.disinfectsystem.inventorymanagement.service.InventoryManagerImpl">
+	</bean>
+    
+    <bean id="inventoryManager"
+		class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
+		<property name="transactionManager" ref="transactionManager" />
+		<property name="target">
+			<ref bean="inventoryManagerTarget" />
+		</property>
+		<property name="transactionAttributes">
+			<props>
+				<prop key="*">PROPAGATION_REQUIRED</prop>
+			</props>
+		</property>
+	</bean>
+    
+    <!-- his接口数据源,用于同步组织机构、人员、住院患者、门诊病人等 -->
+    <bean id="hisDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
+        <property name="driverClass" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />  
+        <property name="jdbcUrl" value="jdbc:sqlserver://192.168.0.137:1433;databaseName=krhis" />
+        <property name="user" value="gys" />  
+        <property name="password" value="gys2017" />
+    </bean>
+    
+    <!-- 物资接口数据源,用于同步入库单、回写(发货、退货、领用、调拨、盘盈盘亏、退库)等 -->
+    <bean id="inventoryDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
+        <property name="driverClass" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />  
+        <property name="jdbcUrl" value="jdbc:sqlserver://localhost:1433;databaseName=HERP" />
+        <property name="user" value="sa" />  
+        <property name="password" value="p2ssword" />
+    </bean>
+    
+    <!-- 由MyBatis实现访问HIS数据的Dao接口-->
+    <bean id="syncOrgUnitAndUserDao" class="org.mybatis.spring.mapper.MapperFactoryBean">  
+       <property name="mapperInterface"  
+           value="com.forgon.disinfectsystem.datasynchronization.dao.SyncOrgUnitAndUserDao" />  
+       <property name="sqlSessionFactory">
+            <bean class="org.mybatis.spring.SqlSessionFactoryBean">
+                <property name="dataSource" ref="hisDataSource" />
+                <property name="mapperLocations" value="classpath:config/kpszxyy/mybatis/SyncOrgUnitAndUserMapper.xml" />
+                <property name="typeAliasesPackage" value="com.forgon.disinfectsystem.datasynchronization.model" />
+            </bean>
+       </property>
+    </bean>
+    
+    <bean id="findPatientInfoByHospitalNumDao" class="org.mybatis.spring.mapper.MapperFactoryBean">  
+       <property name="mapperInterface"  
+           value="com.forgon.disinfectsystem.datasynchronization.dao.FindPatientInfoByHospitalNumDao" />  
+       <property name="sqlSessionFactory">
+            <bean class="org.mybatis.spring.SqlSessionFactoryBean">
+                <property name="dataSource" ref="hisDataSource" />
+                <property name="mapperLocations" value="classpath:config/kpszxyy/mybatis/FindPatientInfoByHospitalNumMapper.xml" />
+                <property name="typeAliasesPackage" value="com.forgon.disinfectsystem.datasynchronization.model" />
+            </bean>
+       </property>
+    </bean>
+    
+    <bean id="findPatientInfoByTreatmentNumDao" class="org.mybatis.spring.mapper.MapperFactoryBean">  
+       <property name="mapperInterface"  
+           value="com.forgon.disinfectsystem.datasynchronization.dao.FindPatientInfoByTreatmentNumDao" />  
+       <property name="sqlSessionFactory">
+            <bean class="org.mybatis.spring.SqlSessionFactoryBean">
+                <property name="dataSource" ref="hisDataSource" />
+                <property name="mapperLocations" value="classpath:config/kpszxyy/mybatis/FindPatientInfoByTreatmentNumMapper.xml" />
+                <property name="typeAliasesPackage" value="com.forgon.disinfectsystem.datasynchronization.model" />
+            </bean>
+       </property>
+    </bean>
+    
+        <!-- InventoryDao接口的实现， 由MyBatis实现-->
+    <bean id="inventoryDao" class="org.mybatis.spring.mapper.MapperFactoryBean">  
+       <property name="mapperInterface"  
+           value="com.forgon.disinfectsystem.inventorymanagement.dao.InventoryDao" />  
+       <property name="sqlSessionFactory">
+            <bean class="org.mybatis.spring.SqlSessionFactoryBean">
+                <property name="dataSource" ref="inventoryDataSource" />
+                <property name="mapperLocations" value="classpath:config/kpszxyy/mybatis/syncFromHERP_Mapper.xml" />
+                <property name="typeAliasesPackage" value="com.forgon.disinfectsystem.inventorymanagement.model" />
+            </bean>
+       </property>
+    </bean>
+    
+     	<!-- WriteBackInventoryDao 接口的实现， 由MyBatis实现-->
+    <bean id="writeBackInventoryDao" class="org.mybatis.spring.mapper.MapperFactoryBean">  
+       <property name="mapperInterface"  
+           value="com.forgon.disinfectsystem.inventorymanagement.dao.WriteBackInventoryDao" />  
+       <property name="sqlSessionFactory" > 
+            <bean class="org.mybatis.spring.SqlSessionFactoryBean">
+                <property name="dataSource" ref="inventoryDataSource" />
+                <property name="mapperLocations" value="classpath:config/kpszxyy/mybatis/syncToHERP_Mapper.xml" />
+                <property name="typeAliasesPackage" value="com.forgon.disinfectsystem.inventorymanagement.model" />
+            </bean>
+        </property>
+    </bean>
+</beans>
\ No newline at end of file
Index: ssts-web/src/main/resources/config/kpszxyy/mybatis/FindPatientInfoByTreatmentNumMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/resources/config/kpszxyy/mybatis/FindPatientInfoByTreatmentNumMapper.xml	(revision 0)
+++ ssts-web/src/main/resources/config/kpszxyy/mybatis/FindPatientInfoByTreatmentNumMapper.xml	(revision 21298)
@@ -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
Index: ssts-web/src/main/resources/config/kpszxyy/mybatis/syncFromHERP_Mapper.xml
===================================================================
diff -u
--- ssts-web/src/main/resources/config/kpszxyy/mybatis/syncFromHERP_Mapper.xml	(revision 0)
+++ ssts-web/src/main/resources/config/kpszxyy/mybatis/syncFromHERP_Mapper.xml	(revision 21298)
@@ -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/resources/config/kpszxyy/dataSyncConfig.json
===================================================================
diff -u
--- ssts-web/src/main/resources/config/kpszxyy/dataSyncConfig.json	(revision 0)
+++ ssts-web/src/main/resources/config/kpszxyy/dataSyncConfig.json	(revision 21298)
@@ -0,0 +1,15 @@
+{
+	"同步组织机构":{
+		"默认父节点的编码" : "0",
+		"更新交集数据" : true,
+		"移除差集数据" : false
+	},
+	"同步用户":{
+		"默认父节点的编码" : "0",
+		"更新交集数据" : true,
+		"移除差集数据" : false,
+		"默认角色ID":[
+			"ROLE_sqry_0"
+		]
+	}
+}
\ No newline at end of file