Index: ssts-web/src/main/resources/config/zsyy/mybatis/syncFromHERP_Mapper.xml
===================================================================
diff -u
--- ssts-web/src/main/resources/config/zsyy/mybatis/syncFromHERP_Mapper.xml	(revision 0)
+++ ssts-web/src/main/resources/config/zsyy/mybatis/syncFromHERP_Mapper.xml	(revision 16819)
@@ -0,0 +1,117 @@
+<?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,time,remark
+	FROM apps.CSSD_GodownEntry
+	WHERE serialNumber = #{inEntrySerialNumber}
+	]]>
+  </select>
+  
+  <!-- 按时间查找入库单 -->
+  <select id="findInEntryByTime" resultType="StorageEntry">
+  	<![CDATA[
+	SELECT serialNumber,time,remark
+	FROM apps.CSSD_GodownEntry
+	WHERE type = 'J'
+	]]>
+	<if test="startDate != null">
+		and time >= to_date(#{startDate},'yyyy-mm-dd')
+	</if>
+	<if test="endDate != null">
+		<![CDATA[
+		and time <= to_date(#{endDate},'yyyy-mm-dd')
+		]]>
+	</if>
+	ORDER BY time
+  </select>
+  
+  <!-- 按单号查找入库单明细 -->
+  <!-- 中六的HERP不包含供应商信息 -->
+  <select id="findInEntryItem" resultType="StorageEntryItem">
+  	<![CDATA[
+	SELECT  inventorySerialNumber,
+
+	        
+	        amount,
+	        cost AS unitPrice
+	FROM apps.CSSD_GodownEntry t1
+	INNER JOIN apps.CSSD_GodownEntryItem t2 on t1.serialNumber = t2.serialNumber
+	WHERE t1.serialNumber = #{inEntrySerialNumber}
+	]]>
+  </select>
+  
+  <!-- 按物资编码查找物资信息 -->
+  <select id="getInventory" resultType="Inventory">
+  	<![CDATA[
+	SELECT InventorySerialNumber AS serialNumber,
+	       name,specification,unit,cost
+	FROM apps.CSSD_MaterialDefinition
+	WHERE InventorySerialNumber = #{inventorySerialNumber}
+	]]>
+  </select>
+  
+   <!-- 按名称规格查找物资信息 -->
+  <select id="findInventory" resultType="Inventory">
+	SELECT InventorySerialNumber AS serialNumber,
+	       name,specification,unit,cost
+	FROM apps.CSSD_MaterialDefinition
+	WHERE name = #{name}
+	<choose>
+		<when test="specification != null">
+			AND specification = #{specification}
+		</when >
+		<otherwise>
+			AND ((specification is null) OR (specification =''))
+		</otherwise>
+	</choose>
+  </select>
+  
+  <!-- 按单号查找退库单 -->
+  <!-- 中山眼科中心无需从物资系统同步退库单 -->
+  <select id="findOutEntryBySerialNumber" resultType="StorageEntry">
+  	<![CDATA[
+	SELECT serialNumber,time,remark
+	FROM apps.CSSD_GodownEntry
+	WHERE serialNumber = #{inEntrySerialNumber}
+	]]>
+  </select>
+  
+  <!-- 按时间查找退库单 -->
+  <!-- 中山眼科中心无需从物资系统同步退库单 -->
+  <select id="findOutEntryByTime" resultType="StorageEntry">
+  	<![CDATA[
+	SELECT serialNumber,time,remark
+	FROM apps.CSSD_GodownEntry
+	WHERE type = 'T'
+	]]>
+	<if test="startDate != null">
+		and time >= to_date(#{startDate},'yyyy-mm-dd')
+	</if>
+	<if test="endDate != null">
+		<![CDATA[
+		and time <= to_date(#{endDate},'yyyy-mm-dd')
+		]]>
+	</if>
+	ORDER BY time
+  </select>
+  
+  <!-- 按单号查找退库单明细 -->
+  <select id="findOutEntryItem" resultType="StorageEntryItem">
+  	<![CDATA[
+	SELECT  inventorySerialNumber,
+
+	        amount,
+	        cost AS unitPrice
+	FROM apps.CSSD_GodownEntry t1
+	INNER JOIN apps.CSSD_GodownEntryItem t2 on t1.serialNumber = t2.serialNumber
+	WHERE t1.serialNumber = #{entrySerialNumber}
+	]]>
+  </select>
+  
+</mapper>
\ No newline at end of file