Index: ssts-web/src/main/webapp/disinfectsystem/config/standardProjectTemplate/interfaces/mybatis/syncFromHERP_Mapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/standardProjectTemplate/interfaces/mybatis/syncFromHERP_Mapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/standardProjectTemplate/interfaces/mybatis/syncFromHERP_Mapper.xml	(revision 32745)
@@ -0,0 +1,118 @@
+<?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="findInEntryBySerialNumber" resultType="StorageEntry">
+  	<![CDATA[
+	SELECT serialNumber,TO_CHAR(time,'YYYY-MM-DD') time,remark
+	FROM thirdparts.cssd_materialentry
+	WHERE serialNumber = #{inEntrySerialNumber}
+	]]>
+ </select>
+<!-- 按时间查找入库单 -->
+ <select id="findInEntryByTime" resultType="StorageEntry">
+  	<![CDATA[
+	SELECT serialNumber,TO_CHAR(time,'YYYY-MM-DD') time,remark
+	FROM thirdparts.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 a.serialNumber，
+a.name,
+a.specification,
+a.certification,
+a.supplierName,
+a.batchNumber,
+TO_CHAR(a.expDate,'YYYY-MM-DD') expDate,
+a.amount,
+a.unit,
+a.cost/a.amount as unitPrice,
+a.manufacturer,
+a.producingArea,
+a.inventorySerialNumber 
+	FROM  thirdparts.cssd_materialentryitem a
+	inner JOIN thirdparts.cssd_materialentry b on a.serialNumber = b.serialNumber
+	WHERE a.SERIALNUMBER = #{inEntrySerialNumber}
+	]]>
+</select> 
+<!-- 按物资编码查找物资信息 -->
+<select id="getInventory" resultType="Inventory">
+	<![CDATA[
+		SELECT InventorySerialNumber AS serialNumber,
+	    name,specification,unit,cost
+		FROM CSSD_MATERIALDEFINITION 
+		WHERE InventorySerialNumber = #{inventorySerialNumber}
+	]]>
+</select> 
+<!-- 按名称规格查找物资信息 -->
+<select id="findInventory" resultType="Inventory">
+	<![CDATA[
+		SELECT InventorySerialNumber AS serialNumber,
+	    name,specification,unit,cost
+		FROM CSSD_MATERIALDEFINITION
+	WHERE name = #{name}
+	<choose>
+		<when test="specification != null">
+			AND specification = #{specification}
+		</when >
+		<otherwise>
+			AND ((specification is null) OR (specification =''))
+		</otherwise>
+	</choose>
+	]]<name />
+</select> 
+
+<!-- 按单号查找退库单 -->
+<select id="findOutEntryBySerialNumber" resultType="StorageEntry">
+	<![CDATA[
+	SELECT serialNumber,time,remark
+	FROM CSSD_MaterialEntry
+	WHERE serialNumber = #{inEntrySerialNumber}
+	]]>
+</select> 
+<!-- 按时间查找退库单 -->
+<select id="findOutEntryByTime" resultType="StorageEntry">
+  	<![CDATA[
+	SELECT serialNumber,time,remark
+	FROM CSSD_GodownEntry
+	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="findOutEntryItem" resultType="StorageEntryItem">
+	<![CDATA[
+	SELECT   INVENTORYSERIALNUMBER,
+			BATCHNUMBER,
+	        SUPPLIERNAME,
+	        amount,
+	        EXPDATE,
+	        cost AS unitPrice
+	FROM  CSSD_GodownEntry t1
+	INNER JOIN CSSD_MaterialEntryItem t2 on t1.id = t2.materialEntryId
+	WHERE t1.SERIALNUMBER = #{inEntrySerialNumber}
+	]]>
+</select> 
+</mapper> 
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/standardProjectTemplate/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/standardProjectTemplate/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/standardProjectTemplate/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml	(revision 32745)
@@ -0,0 +1,53 @@
+<?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,
+	       	patientAge,
+	        patientSex,
+	        patientIDCard,
+	        doctorName,
+	        operation,
+	        operationTime,
+	   		bedNumber,
+	   		operationRoom as opRoomId,
+	   		ROOMNUMBER,
+	        patientArea,
+			ascriptionDepartment,
+	        REMARK
+ 	FROM CSSD_HospitalNumber
+	WHERE hospitalNumber = #{hospitalNum}
+	order by operationTime desc
+	]]>
+  </select>
+  
+  <!-- 按住院号查找病人信息:提供给外来器械申请单页面的按住院号查询 -->
+  <select id="findPatientInfoByHospitalNumBeforeOperation" resultType="PatientInfoVO">
+  <![CDATA[
+	SELECT  hospitalNumber as patientNumber,
+        	patientName,
+	       	patientAge,
+	        patientSex,
+	        patientIDCard,
+	        doctorName,
+	        operation,
+	        operationTime,
+	   		bedNumber,
+	   		operationRoom as opRoomId,
+	   		ROOMNUMBER,
+	        patientArea,
+			ascriptionDepartment,
+	        REMARK
+ 	FROM CSSD_HospitalNumber
+	WHERE hospitalNumber = #{hospitalNum}
+	order by operationTime desc
+	]]>
+  </select>
+  
+</mapper>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/standardProjectTemplate/interfaces/dataSyncConfig.json
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/standardProjectTemplate/interfaces/dataSyncConfig.json	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/standardProjectTemplate/interfaces/dataSyncConfig.json	(revision 32745)
@@ -0,0 +1,15 @@
+{
+	"同步组织机构":{
+		"默认父节点的编码" : "0",
+		"更新交集数据" : true,
+		"移除差集数据" : false
+	},
+	"同步用户":{
+		"默认父节点的编码" : "0",
+		"更新交集数据" : true,
+		"移除差集数据" : false,
+		"默认角色ID":[
+			"ROLE_1_0"
+		]
+	}
+}
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/standardProjectTemplate/interfaces/mybatis/SyncOrgUnitAndUserMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/standardProjectTemplate/interfaces/mybatis/SyncOrgUnitAndUserMapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/standardProjectTemplate/interfaces/mybatis/SyncOrgUnitAndUserMapper.xml	(revision 32745)
@@ -0,0 +1,20 @@
+<?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 CSSD_Department where coding != '0'
+	]]>
+  </select>
+  
+  <!-- 获取所有用户 -->
+  <select id="getAllUser" resultType="UserVo">
+  <![CDATA[
+	SELECT CODING,REGEXP_REPLACE(ORGUNITCODING, '[^0-9]'),NAME FROM CSSD_User where coding != '0'
+	]]>
+  </select>
+</mapper>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/standardProjectTemplate/spring/HIS.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/standardProjectTemplate/spring/HIS.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/standardProjectTemplate/spring/HIS.xml	(revision 32745)
@@ -0,0 +1,86 @@
+<?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="file:///#{T(com.forgon.tools.Path).webROOT}/disinfectsystem/config/standardProjectTemplate/interfaces/dataSyncConfig.json" />
+                <property name="charset" value="UTF-8" />
+            </bean>
+        </property>
+	</bean>
+    
+    <bean id="dataSynchronizationManager"
+        parent="txProxyTemplate">
+        <property name="target">
+            <ref bean="dataSynchronizationManagerTarget" />
+        </property>
+    </bean>
+    
+    <bean id="dataSynchronizationTableManager"
+        class="com.forgon.disinfectsystem.datasynchronization.dwr.DataSynchronizationTableManager">
+    </bean>
+    
+    
+    <!-- 定义数据源。根据开发和生产环境需要，设置所用数据源的Bean id 为 hisDataSource -->
+    <bean id="hisDataSource"
+        class="com.mchange.v2.c3p0.ComboPooledDataSource"
+        destroy-method="close">
+        <property name="driverClass" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />  
+        <property name="jdbcUrl" value="jdbc:sqlserver://192.168.2.20:1433;databaseName=HISTEST" />
+        <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="file:///#{T(com.forgon.tools.Path).webROOT}/disinfectsystem/config/standardProjectTemplate/interfaces/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="file:///#{T(com.forgon.tools.Path).webROOT}/disinfectsystem/config/standardProjectTemplate/interfaces/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="file:///#{T(com.forgon.tools.Path).webROOT}/disinfectsystem/config/standardProjectTemplate/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml" />
+                <property name="typeAliasesPackage" value="com.forgon.disinfectsystem.datasynchronization.model" />
+            </bean>
+       </property>
+    </bean>
+
+</beans>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/standardProjectTemplate/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/standardProjectTemplate/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/standardProjectTemplate/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml	(revision 32745)
@@ -0,0 +1,28 @@
+<?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  clinicNumber as patientNumber,
+        	patientName,
+	        patientAge,
+	        patientSex,
+	        patientIDCard,
+	        doctorName,
+	        operation,
+	        operationTime,
+	   		bedNumber,
+	   		ROOMNUMBER,
+	        patientArea,
+			ascriptionDepartment,
+	        REMARK
+	FROM CSSD_ClinicNumber
+	WHERE clinicNumber = #{treatmentNum}
+	]]>
+  </select>
+
+</mapper>
\ No newline at end of file