Index: ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml	(revision 28112)
@@ -0,0 +1,48 @@
+<?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">
+  
+    <!-- 转换性别 -->
+  <sql id="patientSexField">
+  <![CDATA[
+    (case when (h.patientSex ='1') then '男'
+          when (h.patientSex ='2') then '女'
+          else null
+    end
+    ) as patientSex
+  ]]>
+  </sql>
+  
+  <!-- 按住院号查找病人信息:提供给使用记录页面的按住院号查询 -->
+  <select id="findPatientInfoByHospitalNum" resultType="PatientInfoVO">
+	SELECT h.clinicNumber as patientNumber,
+        	h.patientName as patientName,
+	        h.patientAge as patientAge,
+	        h.patientIDCard as patientIDCard,
+	        h.doctorName as doctorName,
+	        h.operation as operation,
+            <include refid="patientSexField"/>
+	FROM CSSD_HospitalNumber h
+	WHERE h.clinicNumber = #{hospitalNum}
+    ORDER BY h.serialNumber DESC
+  </select>
+  
+  <!-- 按住院号查找病人信息:提供给外来器械申请单页面的按住院号查询 -->
+  <select id="findPatientInfoByHospitalNumBeforeOperation" resultType="PatientInfoVO">
+  <![CDATA[
+	SELECT h.clinicNumber as patientNumber,
+        	h.patientName as patientName,
+	        h.patientAge as patientAge,
+	        h.patientIDCard as patientIDCard,
+	        h.doctorName as doctorName,
+	        h.operation as operation,
+            <include refid="patientSexField"/>
+	FROM CSSD_HospitalNumber h
+	WHERE h.clinicNumber = #{hospitalNum}
+    ORDER BY h.serialNumber DESC
+	]]>
+  </select>
+  
+</mapper>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper2.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper2.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper2.xml	(revision 28112)
@@ -0,0 +1,14 @@
+<?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">
+  
+  <!-- 按门诊号查找病人信息,patientNumber,patientName,patientAge,patientSex,patientIDCard,doctorName,operation -->
+  <select id="findPatientInfoByTreatmentNum" statementType="CALLABLE" resultType="PatientInfoVO">
+  <![CDATA[
+	{call ixs20.pGetOPPatientForXDGY(#{treatmentNum})}
+	]]>
+  </select>
+
+</mapper>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/syncInventoryBaseData_Mapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/syncInventoryBaseData_Mapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/syncInventoryBaseData_Mapper.xml	(revision 28112)
@@ -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.inventorymanagement.dao.InventoryDao">
+  <!-- 按物资编码查找物资信息 -->
+  <select id="getInventory" resultType="Inventory">
+  	<![CDATA[
+	SELECT serialNumber,
+	       name,
+	       specification,
+	       category,
+	       categoryCode,
+	       unit,
+	       cost
+	FROM InventoryTemporaryData
+	WHERE serialNumber = #{inventorySerialNumber}
+	]]>
+  </select>
+</mapper>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/updateHERP_Mapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/updateHERP_Mapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/updateHERP_Mapper.xml	(revision 28112)
@@ -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.inventorymanagement.dao.UpdateEntryDao">
+
+  <!-- 更新单的状态与处理错误信息 -->
+  <update id="updateEntryStateAndErrorMessage">
+  <![CDATA[
+  update HRP_DBA."mate_mov_main" set "record_state"=#{recordState},"error_message"=${errorMessage} where "iow_no"=${entrySerialNumber}
+  ]]>
+  </update>
+
+  <!-- 更新单的状态 -->
+  <update id="updateEntryState">
+  <![CDATA[
+  update HRP_DBA."mate_mov_main" set "record_state"=#{recordState} where "iow_no"=${entrySerialNumber}
+  ]]>
+  </update>
+
+  <!-- 更新单的处理错误信息 -->
+  <update id="updateEntryErrorMessage">
+  <![CDATA[
+  update HRP_DBA."mate_mov_main" set "error_message"=${errorMessage} where "iow_no"=${entrySerialNumber}
+  ]]>
+  </update>
+  
+</mapper>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/spring/applicationContext-path.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/spring/applicationContext-path.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/spring/applicationContext-path.xml	(revision 28112)
@@ -0,0 +1,52 @@
+<?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: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"
+	   default-autowire="byName" default-lazy-init="true">
+
+	<!-- 手麻系统使用记录接口的数据源 -->
+	<bean id="pathJdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
+        <property name="dataSource" ref="pathDataSource"/>
+    </bean>
+    
+    <bean id="pathDataSource" depends-on="initDataBaseManager"
+		class="com.mchange.v2.c3p0.ComboPooledDataSource"
+		destroy-method="close">
+		<property name="driverClass" value="oracle.jdbc.OracleDriver" />
+		<property name="jdbcUrl" value="jdbc:oracle:thin:SY/SY@//192.168.168.126:1521/DOCARE" />
+		<property name="user" value="SY" />
+		<property name="password" value="SY" />
+		<!-- <property name="jdbcUrl" value="jdbc:oracle:thin:@//192.168.2.145:1521/ORCL" />
+		<property name="user" value="ZSYKZXPATH" />
+		<property name="password" value="ZSYKZXPATH" /> -->
+		<property name="minPoolSize">
+			<value>5</value>
+		</property>
+		<property name="maxPoolSize" value="30" />
+		<property name="initialPoolSize" value="10" />
+		<property name="maxIdleTime" value="60" />
+		<property name="acquireIncrement" value="5" />
+		<property name="maxStatements" value="0" />
+		<property name="idleConnectionTestPeriod" value="60" />
+		<property name="acquireRetryAttempts" value="30" />
+		<property name="breakAfterAcquireFailure" value="false" />
+		<property name="testConnectionOnCheckout" value="false" />
+	</bean>
+	
+	<!-- 手麻系统使用记录接口对接的bean -->
+	<bean id="herpPathManager" parent="txProxyTemplate">
+		<property name="target">
+			<ref bean="herpPathManagerTarget" />
+		</property>
+	</bean>
+
+	<bean id="herpPathManagerTarget"
+		class="com.forgon.disinfectsystem.useRecord.hrepPath.zsykzx.HerpPathManagerImpl">
+	</bean>
+	
+</beans>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/writeBackTousseStatisticsMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/writeBackTousseStatisticsMapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/writeBackTousseStatisticsMapper.xml	(revision 28112)
@@ -0,0 +1,31 @@
+<?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.WriteBackTousseStatisticsDao">
+
+    <!-- 对方需要的月份格式为'yyyyMM'字符串 -->
+  <sql id="year_monthField">
+  <![CDATA[
+    (case when (#{startDate} is not null) then LEFT(CONVERT(varchar, #{startDate}, 112),6)
+    else null
+    end
+    )
+  ]]>
+  </sql>
+  
+  <!-- 回写器械包工作量统计 -->
+  <!-- 注：现HERP需要器械包的总价而不是数量，所以amount字段需填入总价 2015-06-02-->
+  <insert id="insertRecord">
+	INSERT INTO v_package_num
+	(year_month,server_dept,dept_code,amount)
+	VALUES
+	(
+    <include refid="year_monthField"/>
+		, #{producerCoding}
+		, #{consumerCoding}
+		, #{price}
+	)
+  </insert>
+  
+</mapper>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/dataSyncConfig.json
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/dataSyncConfig.json	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/dataSyncConfig.json	(revision 28112)
@@ -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/zsykzx/interfaces/writeBackInventoryConfig.json
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/writeBackInventoryConfig.json	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/writeBackInventoryConfig.json	(revision 28112)
@@ -0,0 +1,11 @@
+{
+    "发货一次性物品回写": true,
+    "退货一次性物品回写": true,
+    "一次性物品退库单回写": false,
+    "一次性物品盘盈入库单回写": true,
+    "一次性物品盘亏出库单回写": true,
+    "供应室领用一次性物品回写": false,
+    "器械材料补充回写" : true,
+    "一次性物品调拨回写" : true,
+    "器械材料调拨回写" : true
+}
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/syncFromHERP_Mapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/syncFromHERP_Mapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/syncFromHERP_Mapper.xml	(revision 28112)
@@ -0,0 +1,289 @@
+<?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 "iow_no" as serialNumber,
+        	"make_date" as time,
+	        "maker" as remark
+	FROM HRP_DBA."mate_mov_main"
+	WHERE "iow_no" = #{inEntrySerialNumber}
+	]]>
+  </select>
+  
+  <!-- 按时间查找入库单 -->
+  <select id="findInEntryByTime" resultType="StorageEntry">
+  	<![CDATA[
+	SELECT "iow_no" as serialNumber,
+        	"make_date" as time,
+	        "maker" as remark
+	FROM HRP_DBA."mate_mov_main"
+	WHERE "store_name" = '3'
+	and "exch_store_name" not in ('47','48','49','40','9')
+	]]>
+	<if test="startDate != null">
+		and "make_date" >= #{startDate}
+	</if>
+	<if test="endDate != null">
+		<![CDATA[
+		and "make_date" - 0.99999 <= #{endDate}
+		]]>
+	</if>
+	ORDER BY "make_date"
+  </select>
+  
+  <!-- 按时间范围、移入仓位、移出仓位查找入库单 -->
+  <select id="findInEntryByTimeAndTwoStoreCodeList" resultType="StorageEntry">
+  	<![CDATA[
+	SELECT "iow_no" as serialNumber,
+        	"make_date" as time,
+	        "maker" as remark
+	FROM HRP_DBA."mate_mov_main"
+	WHERE 1=1 
+	]]>
+	<if test="startDate != null">
+		and "make_date" >= #{startDate}
+	</if>
+	<if test="endDate != null">
+		<![CDATA[
+		and "make_date" - 0.99999 <= #{endDate}
+		]]>
+	</if>
+	<if test="storeCodeList != null and storeCodeList.size > 0"> 
+			and "store_name" in
+		    <foreach collection="storeCodeList"  item="storeCode" open="(" separator="," close=")">
+	             #{storeCode}       
+	       </foreach>     
+	 </if>
+	 <if test="exchStoreCodeList != null and exchStoreCodeList.size > 0"> 
+			and "exch_store_name" in
+		    <foreach collection="exchStoreCodeList"  item="exchStoreCode" open="(" separator="," close=")">
+	             #{exchStoreCode}       
+	       </foreach>     
+	 </if>
+	ORDER BY "make_date"
+  </select>
+  
+  <!-- 按单号查找入库单明细 -->
+  <!-- 中六的HERP不包含供应商信息 -->
+  <select id="findInEntryItem" resultType="StorageEntryItem">
+  	<![CDATA[
+	SELECT  "inv_code" AS inventorySerialNumber,
+			null AS supplierName,
+	        "batch_no" AS batchNumber,
+	        "inva_date" AS expDate,
+	        "amount" AS amount,
+	        "price" AS unitPrice
+	FROM HRP_DBA."mate_mov_detail"
+	WHERE "iow_no" = #{inEntrySerialNumber}
+	]]>
+  </select>
+  
+  <!-- 按物资编码查找物资信息 -->
+  <select id="getInventory" resultType="Inventory">
+  	<![CDATA[
+	SELECT serialNumber,
+	       name,
+	       specification,
+	       category,
+	       categoryCode,
+	       unit,
+	       cost
+	FROM InventoryTemporaryData
+	WHERE serialNumber = #{inventorySerialNumber}
+	]]>
+  </select>
+  
+   <!-- 按名称规格查找物资信息,可能已经不再使用:标注日期2018-07-04 shuyongfu -->
+  <select id="findInventory" resultType="Inventory">
+	SELECT inv_code AS serialNumber,
+	       inv_name AS name,
+	       inv_model AS specification,
+	       mate_type_name AS category,
+	       unit_name AS unit,
+	       price AS cost
+	FROM zsyk_dict_inv_v
+	WHERE inv_name = #{name}
+	<choose>
+		<when test="specification != null">
+			AND inv_model = #{specification}
+		</when >
+		<otherwise>
+			AND ((inv_model is null) OR (inv_model =''))
+		</otherwise>
+	</choose>
+  </select>
+  
+  <!-- 按单号查找退库单 -->
+  <!-- 中山眼科中心无需从物资系统同步退库单 -->
+  <select id="findOutEntryBySerialNumber" resultType="StorageEntry">
+  	<![CDATA[
+	SELECT "iow_no" as serialNumber,
+        	"make_date" as time,
+	        "maker" as remark
+	FROM HRP_DBA."mate_mov_main"
+	WHERE "iow_no" = #{inEntrySerialNumber}
+	]]>
+  </select>
+  
+  <!-- 按时间查找退库单 -->
+  <select id="findOutEntryByTime" resultType="StorageEntry">
+  	<![CDATA[
+	SELECT "iow_no" as serialNumber,
+        	"make_date" as time,
+	        "maker" as remark
+	FROM HRP_DBA."mate_mov_main"
+	WHERE "exch_store_name" = '3'
+	and "store_name" not in ('47','48','49','40','9')
+	]]>
+	<if test="startDate != null">
+		and "make_date" >= #{startDate}
+	</if>
+	<if test="endDate != null">
+		<![CDATA[
+		and "make_date" - 0.99999 <= #{endDate}
+		]]>
+	</if>
+	ORDER BY "make_date"
+  </select>
+  
+  <!-- 按时间、移入仓位、移出仓位查找退库单 -->
+  <select id="findOutEntryByTimeAndTwoStoreCodeList" resultType="StorageEntry">
+  	<![CDATA[
+	SELECT "iow_no" as serialNumber,
+        	"make_date" as time,
+	        "maker" as remark
+	FROM HRP_DBA."mate_mov_main"
+	WHERE 1=1 
+	]]>
+	<if test="startDate != null">
+		and "make_date" >= #{startDate}
+	</if>
+	<if test="endDate != null">
+		<![CDATA[
+		and "make_date" - 0.99999 <= #{endDate}
+		]]>
+	</if>
+	<if test="storeCodeList != null and storeCodeList.size > 0"> 
+			and "store_name" in
+		    <foreach collection="storeCodeList"  item="storeCode" open="(" separator=", " close=")">
+	             #{storeCode,jdbcType=VARCHAR}       
+	       </foreach>     
+	 </if>
+	 <if test="exchStoreCodeList != null and exchStoreCodeList.size > 0"> 
+			and "exch_store_name" in
+		    <foreach collection="exchStoreCodeList"  item="exchStoreCode" open="(" separator=", " close=")">
+	             #{exchStoreCode,jdbcType=VARCHAR}       
+	       </foreach>     
+	 </if>
+	ORDER BY "make_date"
+  </select>
+  
+  <!-- 按单号查找退库单明细 -->
+  <select id="findOutEntryItem" resultType="StorageEntryItem">
+  	<![CDATA[
+	SELECT  "inv_code" AS inventorySerialNumber,
+			null AS supplierName,
+	        "batch_no" AS batchNumber,
+	        "inva_date" AS expDate,
+	        "amount" AS amount,
+	        "price" AS unitPrice,
+	        "inv_code" AS invCode
+	FROM HRP_DBA."mate_mov_detail"
+	WHERE "iow_no" = #{entrySerialNumber}
+	]]>
+  </select>
+  
+  <!-- 按时间查找退货单(手术室(或麻醉科)退至供应室) -->
+  <select id="findReturnEntryByTime" resultType="StorageEntry">
+  	<![CDATA[
+	SELECT "iow_no" as serialNumber,
+        	"make_date" as time,
+	        "maker" as remark,
+	        "store_name" as storeName
+	FROM HRP_DBA."mate_mov_main"
+	WHERE "store_name" = '3'
+	and "exch_store_name" in ('47','48','49','40','9')
+	]]>
+	<if test="startDate != null">
+		and "make_date" >= #{startDate}
+	</if>
+	<if test="endDate != null">
+		<![CDATA[
+		and "make_date" - 0.99999 <= #{endDate}
+		]]>
+	</if>
+	ORDER BY "make_date"
+  </select>
+  
+  <!-- 按时间、移入仓位、移出仓位查找退货单(手术室(或麻醉科)退至供应室) -->
+  <select id="findReturnEntryByTimeAndTwoStoreCodeList" resultType="StorageEntry">
+  	<![CDATA[
+	SELECT "iow_no" as serialNumber,
+        	"make_date" as time,
+	        "maker" as remark,
+	        "store_name" as storeName
+	FROM HRP_DBA."mate_mov_main"
+	WHERE 1=1 
+	]]>
+	<if test="startDate != null">
+		and "make_date" >= #{startDate}
+	</if>
+	<if test="endDate != null">
+		<![CDATA[
+		and "make_date" - 0.99999 <= #{endDate}
+		]]>
+	</if>
+	<if test="storeCodeList != null and storeCodeList.size > 0"> 
+			and "store_name" in
+		    <foreach collection="storeCodeList"  item="storeCode" open="(" separator=", " close=")">
+	             #{storeCode,jdbcType=VARCHAR}       
+	       </foreach>     
+	 </if>
+	 <if test="exchStoreCodeList != null and exchStoreCodeList.size > 0"> 
+			and "exch_store_name" in
+		    <foreach collection="exchStoreCodeList"  item="exchStoreCode" open="(" separator=", " close=")">
+	             #{exchStoreCode,jdbcType=VARCHAR}       
+	       </foreach>     
+	 </if>
+	ORDER BY "make_date"
+  </select>
+  
+  <select id="findReturnEntryBySerialNumber" resultType="StorageEntry">
+  	<![CDATA[
+	SELECT "iow_no" as serialNumber,
+        	"make_date" as time,
+	        "maker" as remark,
+	        "store_name" as storeName
+	FROM HRP_DBA."mate_mov_main"
+	WHERE "iow_no" = #{inEntrySerialNumber}
+	]]>
+  </select>
+  
+  <!-- 按单号查找退货单明细(手术室退至供应室) -->
+  <select id="findReturnEntryItem" resultType="StorageEntryItem">
+  	<![CDATA[
+	SELECT  "inv_code" AS inventorySerialNumber,
+			null AS supplierName,
+	        "batch_no" AS batchNumber,
+	        "inva_date" AS expDate,
+	        "amount" AS amount,
+	        "price" AS unitPrice,
+	        "inv_code" AS invCode
+	FROM HRP_DBA."mate_mov_detail"
+	WHERE "iow_no" = #{entrySerialNumber}
+	]]>
+  </select>
+
+  <!-- 更新单的状态与处理错误信息 -->
+  <update id="updateEntryStateAndErrorMessage">
+  <![CDATA[
+  update HRP_DBA."mate_mov_main" set "record_state"=#{recordState,jdbcType=VARCHAR},"error_message"=#{errorMessage,jdbcType=VARCHAR} where "iow_no"=#{entrySerialNumber,jdbcType=VARCHAR}
+  ]]>
+  </update>
+
+</mapper>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/FindPatientInfoByHospitalNumMapper2.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/FindPatientInfoByHospitalNumMapper2.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/FindPatientInfoByHospitalNumMapper2.xml	(revision 28112)
@@ -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.FindPatientInfoByHospitalNumDao">
+  
+  <!-- 按住院号查找病人信息,patientNumber,patientName,patientAge,patientSex,patientIDCard,doctorName,operation -->
+  <select id="findPatientInfoByHospitalNum" statementType="CALLABLE" resultType="PatientInfoVO">
+  <![CDATA[
+	{call ixs20.pGetIPPatientForXDGY(#{hospitalNum})}
+	]]>
+  </select>
+  
+  <!-- 按住院号查找病人信息:提供给外来器械申请单页面的按住院号查询 -->
+  <select id="findPatientInfoByHospitalNumBeforeOperation" resultType="PatientInfoVO">
+  <![CDATA[
+	{call ixs20.pGetIPPatientForXDGY(#{hospitalNum})}
+	]]>
+  </select>
+</mapper>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/spring/timer.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/spring/timer.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/spring/timer.xml	(revision 28112)
@@ -0,0 +1,187 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN" "http://www.springframework.org/dtd/spring-beans-2.0.dtd">
+
+<beans>
+	<!-- 定时自动签收发货单 -->
+	<bean id="timingAutoSignInvoiceJob"
+		class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
+		<property name="targetObject">
+			<ref bean="invoiceManager" />
+		</property>
+		<property name="targetMethod">
+			<value>timingAutoSignInvoice</value>
+		</property>
+		<property name="concurrent" value="false"/> 
+	</bean>
+	<bean id="timingAutoSignInvoiceJobTrigger" class="org.springframework.scheduling.quartz.CronTriggerFactoryBean">
+		<property name="jobDetail">
+			<ref bean="timingAutoSignInvoiceJob" />
+		</property>
+		<property name="cronExpression">
+			<value>0 0 2 * * ?</value>
+		</property>
+	</bean>
+
+    <!-- 每月1号1点执行回写，把上月的各科室器械包发货情况回写到物资系统 -->
+    <bean id="HERP_WriteBackTousseStatisticsOfLastMonthJobTrigger" class="org.springframework.scheduling.quartz.CronTriggerFactoryBean">
+        <property name="jobDetail">
+            <bean class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
+                <property name="targetObject">
+                    <ref bean="writeBackInventoryMaintainManager" />
+                </property>
+                <property name="targetMethod">
+                    <value>writeBackTousseStatistics</value>
+                </property>
+                <property name="concurrent" value="false"/> 
+            </bean>
+        </property>
+        <property name="cronExpression">
+            <value>0 0 1 1 * ?</value>
+        </property>
+    </bean>
+
+	<!-- 每小时重新回写HERP本月及上月回写失败的记录 -->
+    <bean id="HERP_ReWriteFailedEntryJobTrigger" class="org.springframework.scheduling.quartz.CronTriggerFactoryBean">
+        <property name="jobDetail">
+            <bean class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
+                <property name="targetObject">
+                    <ref bean="writeBackInventoryMaintainManager" />
+                </property>
+                <property name="targetMethod">
+                    <value>reWriteFailedEntry</value>
+                </property>
+                <property name="concurrent" value="false"/> 
+            </bean>
+        </property>
+        <property name="cronExpression">
+            <value>0 0 * * * ?</value>
+        </property>
+    </bean>
+    
+    <!-- 定时自动结算一次性物品库-->
+	<bean id="autoCopyDisposableGoodsStockJob"
+		class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
+		<property name="targetObject">
+			<ref bean="stockTakeRecordManager" />
+		</property>
+		<property name="targetMethod">
+			<value>autoCopyDisposableGoodsStock</value>
+		</property>
+		<property name="concurrent" value="false"/> 
+	</bean>
+	<bean id="autoCopyDisposableGoodsStockJobTrigger" class="org.springframework.scheduling.quartz.CronTriggerFactoryBean">
+		<property name="jobDetail">
+			<ref bean="autoCopyDisposableGoodsStockJob" />
+		</property>
+		<property name="cronExpression">
+			<value>0 0 0 * * ?</value>
+		</property>
+	</bean>
+	
+    <!-- 回调失败的记录重新回调定义任务,暂定为每10分钟运行一次 -->
+    <bean id="HERP_ReSubmitFailedRecordByHospitalNoJobTrigger" class="org.springframework.scheduling.quartz.CronTriggerFactoryBean">
+        <property name="jobDetail">
+            <bean class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
+                <property name="targetObject">
+                    <ref bean="herpPathManager" />
+                </property>
+                <property name="targetMethod">
+                    <value>timingSubmitUseRecord</value>
+                </property>
+                <property name="concurrent" value="false"/> 
+            </bean>
+        </property>
+        <property name="cronExpression">
+            <value>0 0/10 * * * ?</value>
+        </property>
+    </bean>
+	
+    <!-- 定时同步还未同步或同步未成功的入库单\退库单\退货单,每天0点进行同步 -->
+    <!-- <bean id="HERP_TimingSyncEntryJobTrigger" class="org.springframework.scheduling.quartz.CronTriggerFactoryBean">
+        <property name="jobDetail">
+            <bean class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
+                <property name="targetObject">
+                    <ref bean="inventoryManager" />
+                </property>
+                <property name="targetMethod">
+                    <value>timingSyncEntry</value>
+                </property>
+                <property name="concurrent" value="false"/> 
+            </bean>
+        </property>
+        <property name="cronExpression">
+            <value>0 0 0 * * ?</value>
+        </property>
+    </bean> -->
+
+	<!-- 定时回写还未回写成功的记录(发货、退货、盘盈盘所产生的入/退库)、每小时处理一次 -->
+    <!-- <bean id="HERP_TimingWriteBackUnSuccessDataJobTrigger" class="org.springframework.scheduling.quartz.CronTriggerFactoryBean">
+        <property name="jobDetail">
+            <bean class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
+                <property name="targetObject">
+                    <ref bean="inventoryManager" />
+                </property>
+                <property name="targetMethod">
+                    <value>timingSyncEntry</value>
+                </property>
+                <property name="concurrent" value="false"/> 
+            </bean>
+        </property>
+        <property name="cronExpression">
+            <value>0 0 * * * ?</value>
+        </property>
+    </bean> -->
+
+	<!-- 定时读取MQ(队列)中的基础数据(科室、人员、耗材(即一次性物品))、每10分同步一次 -->
+    <bean id="HERP_TimingsyncAllBaseData" class="org.springframework.scheduling.quartz.CronTriggerFactoryBean">
+        <property name="jobDetail">
+            <bean class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
+                <property name="targetObject">
+                    <ref bean="dataSynchronizationManager" />
+                </property>
+                <property name="targetMethod">
+                    <value>syncAllBaseData</value>
+                </property>
+                <property name="concurrent" value="false"/> 
+            </bean>
+        </property>
+        <property name="cronExpression">
+            <value>0 0/10 * * * ?</value>
+        </property>
+    </bean>
+	
+	<!-- 任务调度配置 -->
+    <bean id="schedulerFactoryBean" class = "org.springframework.scheduling.quartz.SchedulerFactoryBean">
+        <property name="triggers">
+            <list>
+            	<!-- 定时自动签收发货单 -->
+                <ref bean="timingAutoSignInvoiceJobTrigger"/>
+
+            	<!-- 设备接口 -->
+                 <ref bean="deviceInterfaceDataProcessTimerTask"/>
+                
+                <!-- 器械包月度统计回写,眼科更新新的herp厂商(由东软望海更换为北大医信),注释掉不再回写 since 2017-11-01 -->
+                <!-- <ref bean="HERP_WriteBackTousseStatisticsOfLastMonthJobTrigger"/> -->
+                
+                <!-- 每小时重新回写HERP本月及上月回写失败的记录 -->
+                <!-- <ref bean="HERP_ReWriteFailedEntryJobTrigger"/> -->
+                
+                <!-- 定时自动结算一次性物品库-->
+                <!-- <ref bean="autoCopyDisposableGoodsStockJobTrigger"/> -->
+				
+				<!-- 手麻回调失败的记录定时重新回调 -->
+                <!-- <ref bean="HERP_ReSubmitFailedRecordByHospitalNoJobTrigger"/> -->
+                
+                <!-- 定时同步还未同步或同步未成功的入库单\退库单\退货单 -->
+                <!-- <ref bean="HERP_TimingSyncEntryJobTrigger"/> -->
+                
+                <!-- 定时回写还未回写成功的记录(发货、退货、盘盈盘所产生的入/退库/) -->
+                <!-- <ref bean="HERP_TimingWriteBackUnSuccessDataJobTrigger"/> -->
+                
+                <!-- 定时读取MQ(队列)中的基础数据(科室、人员、耗材(即一次性物品)) -->
+                <ref bean="HERP_TimingsyncAllBaseData"/>
+            </list>
+        </property>
+    </bean>
+    
+</beans>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml	(revision 28112)
@@ -0,0 +1,32 @@
+<?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">
+  
+      <!-- 转换性别 -->
+  <sql id="patientSexField">
+  <![CDATA[
+    (case when (h.patientSex ='1') then '男'
+          when (h.patientSex ='2') then '女'
+          else null
+    end
+    ) as patientSex
+  ]]>
+  </sql>
+  
+  <!-- 按门诊号查找病人信息 -->
+  <select id="findPatientInfoByTreatmentNum" resultType="PatientInfoVO">
+	SELECT h.clinicNumber as patientNumber,
+        	h.patientName as patientName,
+	        h.patientAge as patientAge,
+	        h.patientIDCard as patientIDCard,
+	        h.doctorName as doctorName,
+	        h.operation as operation,
+            <include refid="patientSexField"/>
+	FROM CSSD_ClinicNumber h
+	WHERE h.clinicNumber = #{treatmentNum}
+    ORDER BY h.serialNumber DESC
+  </select>
+
+</mapper>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/syncToHERP_Mapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/syncToHERP_Mapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/syncToHERP_Mapper.xml	(revision 28112)
@@ -0,0 +1,200 @@
+<?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">
+   ("year_month","iow_no","dept_code","make_date","maker","store_code","bus_type_code","proj_code","exch_store_code") 
+  </sql>
+  
+  <insert id="insertWriteBackEntryForInvoice">
+	INSERT INTO HRP_DBA."mate_whr_main" 
+	<include refid="writeBackEntryFields"/>
+	VALUES
+	(
+		to_number(to_char(#{time}, 'yyyyMM'))
+		, #{serialNumber}
+		, #{departCoding}
+		, #{time}
+		, #{operator,jdbcType=VARCHAR}
+		, #{storeCode,jdbcType=VARCHAR}
+		, #{type,jdbcType=VARCHAR}
+		, #{projCode,jdbcType=VARCHAR}
+		, #{exchStoreCode,jdbcType=VARCHAR}
+	)
+  </insert>
+  
+  <insert id="insertWriteBackEntryForReturnGoods">
+	INSERT INTO HRP_DBA."mate_whr_main" 
+	<include refid="writeBackEntryFields"/>
+	VALUES
+	(
+		to_number(to_char(#{time}, 'yyyyMM'))
+		, #{serialNumber}
+		, #{departCoding}
+		, #{time}
+		, #{operator,jdbcType=VARCHAR}
+		, #{storeCode,jdbcType=VARCHAR}
+		, #{type,jdbcType=VARCHAR}
+		, null
+		, #{exchStoreCode,jdbcType=VARCHAR}
+	)
+  </insert>
+  
+  <insert id="insertWriteBackEntryForStockTakeIn">
+	INSERT INTO HRP_DBA."mate_whr_main" 
+	<include refid="writeBackEntryFields"/>
+	VALUES
+	(
+		to_number(to_char(#{time}, 'yyyyMM'))
+		, #{serialNumber,jdbcType=VARCHAR}
+		, #{departCoding,jdbcType=VARCHAR}
+		, #{time}
+		, #{operator,jdbcType=VARCHAR}
+		, '3'
+		, '22'
+		, #{projCode,jdbcType=VARCHAR}
+		, '50'
+	)
+  </insert>
+  
+  <insert id="insertWriteBackEntryForStockTakeOut">
+	INSERT INTO HRP_DBA."mate_whr_main" 
+	<include refid="writeBackEntryFields"/>
+	VALUES
+	(
+		to_number(to_char(#{time}, 'yyyyMM'))
+		, #{serialNumber,jdbcType=VARCHAR}
+		, #{departCoding,jdbcType=VARCHAR}
+		, #{time}
+		, #{operator,jdbcType=VARCHAR}
+		, '50'
+		, '22'
+		, #{projCode,jdbcType=VARCHAR}
+		, '3'
+	)
+  </insert>
+
+  <!-- 和北大医信沟通了,今后系统会屏蔽一次性物品退库菜单 -->  
+  <insert id="insertWriteBackEntryForStorageOut" useGeneratedKeys="true" keyProperty="id">
+	INSERT INTO HRP_DBA."mate_whr_main" 
+	<include refid="writeBackEntryFields"/>
+	VALUES
+	(
+		to_number(to_char(#{time}, 'yyyyMM'))
+		, #{serialNumber}
+		, #{departCoding}
+		, #{time}
+		, #{operator}
+		, '03'
+		, '14'
+		, null
+		, #{exchStoreCode,jdbcType=VARCHAR}
+	)
+  </insert>
+  
+  <!-- 和北大医信沟通了,今后系统会屏蔽供应室领用菜单 -->
+   <insert id="insertWriteBackEntryForReceiverecord" useGeneratedKeys="true" keyProperty="id">
+	INSERT INTO HRP_DBA."mate_whr_main" 
+	<include refid="writeBackEntryFields"/>
+	VALUES
+	(
+		to_number(to_char(#{time}, 'yyyyMM'))
+		, #{serialNumber}
+		, #{departCoding}
+		, #{time}
+		, #{operator}
+		, '03'
+		, '2'
+		, null
+		, #{exchStoreCode,jdbcType=VARCHAR}
+	)
+  </insert>
+  
+  <sql id="insertWriteBackEntryItemCommon">
+	INSERT INTO HRP_DBA."mate_whr_detail" 
+	("iow_no","inv_code","batch_no","inva_date","amount","price","sell_price","expenditure_item_code")
+	<foreach collection="items" item="item" index="index" open="(" close=")" separator="union all">
+	    SELECT #{item.serialNumber}
+	   			, #{item.inventorySerialNumber}
+	   			, #{item.batchNumber,jdbcType=VARCHAR}
+	   			, #{item.expDate,jdbcType=TIMESTAMP}
+	   			, #{item.amount}
+	   			, #{item.unitPrice}
+	   			, #{item.fluctuationUnitPrice}
+	   			, #{item.expenditureItemCode,jdbcType=VARCHAR}
+	   			 from dual
+  	</foreach>
+  </sql>
+  
+  <insert id="insertWriteBackEntryItemForInvoice">
+  	<include refid="insertWriteBackEntryItemCommon"/>
+  </insert>
+  
+  <insert id="insertWriteBackEntryItemForReturnGoods">
+  	<include refid="insertWriteBackEntryItemCommon"/>
+  </insert>
+  
+  <insert id="insertWriteBackEntryItemForStockTakeIn">
+  	<include refid="insertWriteBackEntryItemCommon"/>
+  </insert>
+  
+  <insert id="insertWriteBackEntryItemForStockTakeOut">
+  	<include refid="insertWriteBackEntryItemCommon"/>
+  </insert>
+  
+  <insert id="insertWriteBackEntryItemForStorageOut">
+  	<include refid="insertWriteBackEntryItemCommon"/>
+  </insert>
+  
+  <insert id="insertWriteBackEntryItemForReceiverecord">
+  	<include refid="insertWriteBackEntryItemCommon"/>
+  </insert>
+
+	<!-- 和北大医信沟通了,系统屏蔽删除操作,通过逆向操作对误操作的数据进行冲平来解决,因为没有删除权限所以改为一个无实际意义的查询sql -->
+  <sql id="deleteWriteBackEntryCommon">
+  	<![CDATA[
+  	select 1 from dual
+  	]]>
+  </sql>
+  
+  <sql id="deleteWriteBackEntryItemCommon">
+  	<![CDATA[
+  	select 1 from dual
+  	]]>
+  </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/zsykzx/interfaces/mybatis/queryProject_Mapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/queryProject_Mapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/queryProject_Mapper.xml	(revision 28112)
@@ -0,0 +1,71 @@
+<?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.project.dao.ProjectDao">
+  
+  <!-- 查出所有的项目(原东软望海接口 截止日期 2018-03-15) -->
+  <select id="getAllProjectOld" resultType="ProjectDict">
+  	<![CDATA[
+		SELECT 项目编码 as projCode,项目名称 as projName,项目编码  + ' ' + 项目名称 as  projDisplayName FROM view_proj_dict
+	]]>
+	<if test="projectName != ''">
+		where 项目名称 like '%'+#{projectName}+'%' or 项目编码 = #{projectName}
+	</if>
+	<![CDATA[
+		order by projName
+	]]>
+  </select>
+
+  <!-- 获取所有的材料分类与支出项(科目)的对照关系,只取材料分类编码为1开头的 -->
+  <select id="getAllCategorySubject" resultType="CategorySubject">
+  <![CDATA[
+  	SELECT pcfh.category_code categoryCode,
+       pcfh.category_name categoryName,
+       pcfh.project_code subjectCode,
+       pcfh.project_name subjectName
+  FROM HRP_DBA.PROJECT_CATEGORY_FROM_HRP pcfh
+ where pcfh.category_code like '1%'
+ group by pcfh.category_code,
+          pcfh.category_name,
+          pcfh.project_code,
+          pcfh.project_name
+ order by pcfh.category_code,
+          pcfh.category_name,
+          pcfh.project_code,
+          pcfh.project_name
+  	]]>
+  </select>
+  <!-- 获取所有的材料分类与支出项(科目)的对照关系 -->
+  <!-- <select id="getAllCategorySubject" resultType="CategorySubject">
+  <![CDATA[
+  	select CATEGORY_CODE categoryCode,CATEGORY_NAME categoryName,PROJECT_CODE subjectCode,PROJECT_NAME subjectName from PROJECT_CATEGORY_FROM_HRP
+  	]]>
+  </select> -->
+  
+  <!-- 根据类别编码获取材料分类与支出项(科目)的对照关系 -->
+  <select id="getCategorySubjectByCategoryCode" resultType="CategorySubject">
+  <![CDATA[
+  	select CATEGORY_CODE categoryCode,CATEGORY_NAME categoryName,PROJECT_CODE subjectCode,PROJECT_NAME subjectName from HRP_DBA.PROJECT_CATEGORY_FROM_HRP
+  	where CATEGORY_CODE=#{categoryCode} and rownum < 2
+  	]]>
+  </select>
+  <!-- 根据类别编码获取材料分类与支出项(科目)的对照关系 -->
+  <!-- <select id="getCategorySubjectByCategoryCode" resultType="CategorySubject">
+  <![CDATA[
+  	select top 1 CATEGORY_CODE categoryCode,CATEGORY_NAME categoryName,PROJECT_CODE subjectCode,PROJECT_NAME subjectName from PROJECT_CATEGORY_FROM_HRP
+  	where CATEGORY_CODE=#{categoryCode}
+  	]]>
+  </select> -->
+  
+  <!-- 根据项目编号查出项目余额数据,类型为7时才查询其项目余额 -->
+  <select id="getProjectBalanceListByProjCode" resultType="ProjectBalance">
+  	<![CDATA[
+		SELECT vpd.项目编码 as projCode,vpd.项目名称 as projName,
+		材料分类编码   as inventorySerialNumber,总余额 as totalBalance,材料支出余额 as inventoryPayoutBalance
+		FROM view_proj_balance vpb join view_proj_dict vpd on vpb.项目编码=vpd.项目编码
+		WHERE vpd.类型=7 and vpd.项目编码=#{projCode} and 材料分类编码 is not null and 总余额 is not null and 材料支出余额 is not null
+	]]>
+  </select>
+
+</mapper>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/spring/HIS.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/spring/HIS.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/spring/HIS.xml	(revision 28112)
@@ -0,0 +1,109 @@
+<?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/zsykzx/interfaces/dataSyncConfig.json" />
+                <property name="charset" value="UTF-8" />
+            </bean>
+        </property>
+	</bean>
+    
+    <bean id="dataSynchronizationManager"
+         parent="txProxyTemplate">
+        <property name="target">
+            <ref local="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="oracle.jdbc.OracleDriver" />  
+        <property name="jdbcUrl" value="jdbc:oracle:thin:@192.168.168.242:1521:zsykdb2" />  
+        <property name="user" value="mp" />  
+        <property name="password" value="mp" />
+    </bean>
+    
+    <!-- 北大医信提供的his数据源 -->
+    <bean id="hisDataSource2"
+        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.171.138:1433;databaseName=DXS" />  
+        <property name="user" value="xdgy" />  
+        <property name="password" value="xdgy" /> 
+    </bean>
+    
+    <!-- 由MyBatis实现访问HIS数据读取病人信息的Dao接口-->
+    <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/zsykzx/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/zsykzx/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml" />
+                <property name="typeAliasesPackage" value="com.forgon.disinfectsystem.datasynchronization.model" />
+            </bean>
+       </property>
+    </bean>
+    
+    <!-- 由MyBatis实现访问HIS数据(第2个数据源)读取病人信息的Dao接口-->
+    <bean id="findPatientInfoByHospitalNumDao2" 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="hisDataSource2" />
+                <property name="mapperLocations" value="file:///#{T(com.forgon.tools.Path).webROOT}/disinfectsystem/config/zsykzx/interfaces/mybatis/FindPatientInfoByHospitalNumMapper2.xml" />
+                <property name="typeAliasesPackage" value="com.forgon.disinfectsystem.datasynchronization.model" />
+            </bean>
+       </property>
+    </bean>
+    
+    <bean id="findPatientInfoByTreatmentNumDao2" 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="hisDataSource2" />
+                <property name="mapperLocations" value="file:///#{T(com.forgon.tools.Path).webROOT}/disinfectsystem/config/zsykzx/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper2.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/zsykzx/spring/project.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/spring/project.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/spring/project.xml	(revision 28112)
@@ -0,0 +1,44 @@
+<?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">
+
+	<!-- 与物资系统的接口的相关Bean -->
+	<context:component-scan base-package="com.forgon.disinfectsystem.inventorymanagement.service.*" />
+	
+	<!-- 定义项目manager的bean start -->
+	<bean id="projectManager"
+		class="com.forgon.disinfectsystem.project.service.ProjectManagerImpl">
+	</bean>
+	<!-- 定义项目manager的bean end -->
+
+	<!-- 科研项目基本信息projectDao 接口的实现， 由MyBatis实现 start-->
+    <bean id="projectDaoMybatis" class="org.mybatis.spring.mapper.MapperFactoryBean">  
+       <property name="mapperInterface"  
+           value="com.forgon.disinfectsystem.project.dao.ProjectDao" />  
+       <property name="sqlSessionFactory" > 
+            <bean class="org.mybatis.spring.SqlSessionFactoryBean">
+                <property name="dataSource" ref="inventoryDataSource" />
+                <property name="mapperLocations" value="file:///#{T(com.forgon.tools.Path).webROOT}/disinfectsystem/config/zsykzx/interfaces/mybatis/queryProject_Mapper.xml" />
+                <property name="typeAliasesPackage" value="com.forgon.disinfectsystem.project.model" />
+            </bean>
+        </property>
+    </bean>
+
+	<!-- 科研项目基本信息projectDao 接口的实现， 由MyBatis实现 start-->
+    <bean id="projectDaoImpl" class="com.forgon.disinfectsystem.project.dao.zsykzx.ProjectDaoImpl">  
+    </bean>
+    <!-- 科研项目基本信息projectDao 接口的实现， 由MyBatis实现 end-->
+    
+    <!-- 科研项目经费信息projectDao 接口的实现,调用科研系统的webservice-->
+    <!-- <bean id="projectBalanceDao" class="org.mybatis.spring.mapper.MapperFactoryBean"></bean> -->
+    <!-- 科研项目经费信息projectDao 接口的实现 end-->
+
+</beans>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/spring/HERP.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/spring/HERP.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/spring/HERP.xml	(revision 28112)
@@ -0,0 +1,238 @@
+<?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">
+
+	<!-- 与物资系统的接口的相关Bean -->
+	<context:component-scan base-package="com.forgon.disinfectsystem.inventorymanagement.service.*" />
+
+<!--     <tx:annotation-driven transaction-manager="inventoryTransactionManager" /> -->
+    
+    <bean id="inventoryManagerTarget"
+		class="com.forgon.disinfectsystem.inventorymanagement.service.InventoryManagerImpl">
+	</bean>
+    
+    <bean id="inventoryManager"
+		 parent="txProxyTemplate">
+		<property name="target">
+			<ref bean="inventoryManagerTarget" />
+		</property>
+	</bean>
+    
+    <!-- 根据开发和生产环境需要，设置所用数据源的Bean id 为 inventoryDataSource,由东软望海提供,现已不用(until 2017-11-03) -->
+<!--     <bean id="inventoryDataSource"
+        class="com.mchange.v2.c3p0.ComboPooledDataSource"
+        destroy-method="close">
+        <property name="driverClass" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
+        <property name="jdbcUrl" value="jdbc:sqlserver://localhost:1433;databaseName=zsyk_herp" />
+        <property name="user" value="sa" />
+        <property name="password" value="p2ssword" />
+        <property name="jdbcUrl" value="jdbc:sqlserver://192.168.168.45:1433;databaseName=herp" />
+        <property name="user" value="sa" />
+        <property name="password" value="ZSyk1123" />
+    </bean> -->
+    
+    <!-- 根据开发和生产环境需要，设置所用数据源的Bean id 为 inventoryDataSource,改由北大医信提供,(since 2017-11-03) -->
+    <bean id="inventoryDataSource"
+        class="com.mchange.v2.c3p0.ComboPooledDataSource"
+        destroy-method="close">
+        <property name="driverClass" value="oracle.jdbc.OracleDriver" />
+        <!-- 正式环境(北大医信) -->
+        <property name="jdbcUrl" value="jdbc:oracle:thin:@//192.168.171.252/hrpdbintra" />
+        <property name="user" value="hrp_gx" />
+        <property name="password" value="hrp_gx_zoc" />
+        <!-- 北大医信测试环境 -->
+        <!-- <property name="jdbcUrl" value="jdbc:oracle:thin:@//172.168.35.233/herp_test" />
+        <property name="user" value="hrp_dba" />
+        <property name="password" value="hrp4321" /> -->
+
+        <!-- 本地测试环境(oracle) -->
+        <!-- <property name="jdbcUrl" value="jdbc:oracle:thin:@//192.168.2.19/ORCL" />
+        <property name="jdbcUrl" value="jdbc:oracle:thin:@//192.168.1.145/ORCL" />
+        <property name="jdbcUrl" value="jdbc:oracle:thin:@//172.168.31.222/ORCL" />
+        <property name="user" value="HRP_DBA" />
+        <property name="password" value="HRP_DBA" /> -->
+        
+        <!-- 本地测试环境(sqlserver) -->
+        <!-- <property name="driverClass" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
+        <property name="jdbcUrl" value="jdbc:sqlserver://localhost:1433;databaseName=testzsykzx" />
+        <property name="user" value="sa" />
+        <property name="password" value="p2ssword" /> -->
+    </bean>
+    
+    <!-- 根据开发和生产环境需要，设置所用数据源的Bean id 为 inventoryBaseDataSource,用于取基础数据 -->
+    <bean id="inventoryBaseDataSource"
+        class="com.mchange.v2.c3p0.ComboPooledDataSource"
+        destroy-method="close">
+        <property name="driverClass" value="oracle.jdbc.OracleDriver" />
+		<!-- 正式环境 -->
+        <property name="jdbcUrl" value="jdbc:oracle:thin:@//localhost/orcl" />
+        <property name="user" value="zsykzx" />
+        <property name="password" value="zsykzx" />
+        
+        <!-- 现场北大医信的测试环境 -->
+        <!-- <property name="jdbcUrl" value="jdbc:oracle:thin:@//172.168.35.233/gys_test" />
+        <property name="user" value="zsykzx" />
+        <property name="password" value="zsykzx" /> -->
+        
+        <!-- 本地测试环境sqlserver -->
+        <!-- <property name="driverClass" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
+        <property name="jdbcUrl" value="jdbc:sqlserver://localhost:1433;databaseName=testzsykzx" />
+        <property name="user" value="sa" />
+        <property name="password" value="p2ssword" /> -->
+        
+        <!-- 本地测试环境oracle -->
+        <!-- <property name="driverClass" value="oracle.jdbc.OracleDriver" />
+        <property name="jdbcUrl" value="jdbc:oracle:thin:@//192.168.2.19/ORCL" />
+        <property name="user" value="zsykzx" />
+        <property name="password" value="zsykzx" /> -->
+    </bean>
+    
+    <!-- inventoryDao不再基于mybatis,改为基于ibm mq的实现.since 2017-11-20-->
+    <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="file:///#{T(com.forgon.tools.Path).webROOT}/disinfectsystem/config/zsykzx/interfaces/mybatis/syncFromHERP_Mapper.xml" />
+                <property name="typeAliasesPackage" value="com.forgon.disinfectsystem.inventorymanagement.model" />
+            </bean>
+       </property>
+    </bean>
+    
+    <!-- baseDataDao接口的实现， 由实现类实现,用于读取MQ中的基础数据(含科室、人员、病人等)-->
+    <bean id="baseDataDao" class="com.forgon.disinfectsystem.mq.dao.zsykzx.WebsphereMqDaoImpl"></bean>
+    
+    <!-- updateEntryDao接口的实现， 由MyBatis实现-->
+    <bean id="updateEntryDao" class="org.mybatis.spring.mapper.MapperFactoryBean">  
+       <property name="mapperInterface"  
+           value="com.forgon.disinfectsystem.inventorymanagement.dao.UpdateEntryDao" />  
+       <property name="sqlSessionFactory">
+            <bean class="org.mybatis.spring.SqlSessionFactoryBean">
+                <property name="dataSource" ref="inventoryDataSource" />
+                <property name="mapperLocations" value="file:///#{T(com.forgon.tools.Path).webROOT}/disinfectsystem/config/zsykzx/interfaces/mybatis/updateHERP_Mapper.xml" />
+                <property name="typeAliasesPackage" value="com.forgon.disinfectsystem.inventorymanagement.model" />
+            </bean>
+       </property>
+    </bean>
+    
+    <!-- inventoryBaseDataDao接口的实现， 由MyBatis实现,查询基础数据时优先取此数据源,未配置时取上面的数据-->
+    <bean id="inventoryBaseDataDao" 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="inventoryBaseDataSource" />
+                <property name="mapperLocations" value="file:///#{T(com.forgon.tools.Path).webROOT}/disinfectsystem/config/zsykzx/interfaces/mybatis/syncInventoryBaseData_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="file:///#{T(com.forgon.tools.Path).webROOT}/disinfectsystem/config/zsykzx/interfaces/mybatis/syncToHERP_Mapper.xml" />
+                <property name="typeAliasesPackage" value="com.forgon.disinfectsystem.inventorymanagement.model" />
+            </bean>
+        </property>
+    </bean>
+    
+    <!-- WriteBackTousseStatisticsDao 接口的实现， 由MyBatis实现-->
+    <bean id="writeBackTousseStatisticsDao" class="org.mybatis.spring.mapper.MapperFactoryBean">  
+       <property name="mapperInterface"  
+           value="com.forgon.disinfectsystem.inventorymanagement.dao.WriteBackTousseStatisticsDao" />  
+       <property name="sqlSessionFactory" > 
+            <bean class="org.mybatis.spring.SqlSessionFactoryBean">
+                <property name="dataSource" ref="inventoryDataSource" />
+                <property name="mapperLocations" value="file:///#{T(com.forgon.tools.Path).webROOT}/disinfectsystem/config/zsykzx/interfaces/mybatis/writeBackTousseStatisticsMapper.xml" />
+                <property name="typeAliasesPackage" value="com.forgon.disinfectsystem.inventorymanagement.model" />
+            </bean>
+        </property>
+    </bean>
+
+	<!-- 科室人员接口的dao不再基于mybatis,改为基于ibm mq的实现.since 2017-11-20 -->
+    <!-- <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="inventoryDataSource" />
+                <property name="mapperLocations" value="file:///#{T(com.forgon.tools.Path).webROOT}/disinfectsystem/config/zsykzx/interfaces/mybatis/SyncOrgUnitAndUserMapper.xml" />
+                <property name="typeAliasesPackage" value="com.forgon.disinfectsystem.datasynchronization.model" />
+            </bean>
+       </property>
+    </bean> -->
+     
+    <!-- 回写物资接口-->
+    <bean id="writeBackInventoryManagerTarget"
+		class="com.forgon.disinfectsystem.inventorymanagement.service.WriteBackInventoryManagerImpl">
+		<property name="config">
+            <bean id="writeBackInventoryConfig" class="com.forgon.tools.json.JsonObjectFromResourceFactoryBean">
+                <property name="resource" value="file:///#{T(com.forgon.tools.Path).webROOT}/disinfectsystem/config/zsykzx/interfaces/writeBackInventoryConfig.json" />
+                <property name="charset" value="UTF-8" />
+            </bean>
+        </property>
+	</bean>
+    
+    <!-- 事务管理器 -->
+    <bean id="inventoryTransactionManager"
+        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
+        <property name="dataSource" ref="inventoryDataSource" />
+    </bean>
+    
+    <!-- 回写物资接口，事务管理器取inventoryTransactionManager-->
+    <bean id="writeBackInventoryManager"
+		 parent="txProxyTemplate">
+		<property name="target">
+			<ref bean="writeBackInventoryManagerTarget" />
+		</property>
+	</bean>
+	
+	<!-- 定义项目manager的bean start -->
+	<bean id="projectManagerTarget"
+		class="com.forgon.disinfectsystem.project.service.ProjectManagerImpl">
+	</bean>
+	
+	<bean id="projectManager"
+		 parent="txProxyTemplate">
+		<property name="target">
+			<ref local="projectManagerTarget" />
+		</property>
+	</bean>
+	<!-- 定义项目manager的bean end -->
+	
+	<!-- 项目projectDao 接口的实现， 由MyBatis实现 start-->
+    <bean id="projectDao" class="org.mybatis.spring.mapper.MapperFactoryBean">  
+       <property name="mapperInterface"  
+           value="com.forgon.disinfectsystem.project.dao.ProjectDao" />  
+       <property name="sqlSessionFactory" > 
+            <bean class="org.mybatis.spring.SqlSessionFactoryBean">
+                <property name="dataSource" ref="inventoryDataSource" />
+                <property name="mapperLocations" value="file:///#{T(com.forgon.tools.Path).webROOT}/disinfectsystem/config/zsykzx/interfaces/mybatis/queryProject_Mapper.xml" />
+                <property name="typeAliasesPackage" value="com.forgon.disinfectsystem.project.model" />
+            </bean>
+        </property>
+    </bean>
+    <!-- 项目projectDao 接口的实现， 由MyBatis实现 end-->
+	
+	<bean id="writeBackInventoryHelper"
+		class="com.forgon.disinfectsystem.inventorymanagement.service.WriteBackInventoryHelper">
+	</bean>
+    
+    <bean id="writeBackInventoryMaintainManager"
+		class="com.forgon.disinfectsystem.maintain.inventory.service.WriteBackInventoryMaintainManagerImpl">
+	</bean>
+</beans>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/SyncOrgUnitAndUserMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/SyncOrgUnitAndUserMapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/zsykzx/interfaces/mybatis/SyncOrgUnitAndUserMapper.xml	(revision 28112)
@@ -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.SyncOrgUnitAndUserDao">
+  
+  <!-- 获取所有部门 -->
+  <select id="getAllOrgUnit" resultType="OrgUnitVo">
+  <![CDATA[
+	SELECT dept_code as coding,
+        	dept_name as name,
+	        '' as parentCoding
+	FROM zsyk_dept_v
+    WHERE is_stop = 0
+	]]>
+  </select>
+  
+  <!-- 获取所有用户 -->
+  <select id="getAllUser" resultType="UserVo">
+  <![CDATA[
+	SELECT emp_code as coding,
+        	emp_name as name,
+	        dept_code as orgUnitCoding
+	FROM zsyk_user_v
+	ORDER BY dept_code
+	]]>
+  </select>
+</mapper>
\ No newline at end of file