Index: ssts-web/src/main/resources/config/zd5y/mybatis/syncFromHERP_Mapper.xml
===================================================================
diff -u -r16365 -r16513
--- ssts-web/src/main/resources/config/zd5y/mybatis/syncFromHERP_Mapper.xml	(.../syncFromHERP_Mapper.xml)	(revision 16365)
+++ ssts-web/src/main/resources/config/zd5y/mybatis/syncFromHERP_Mapper.xml	(.../syncFromHERP_Mapper.xml)	(revision 16513)
@@ -4,8 +4,8 @@
   "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 <mapper namespace="com.forgon.disinfectsystem.inventorymanagement.dao.InventoryDao">
   
-  <!-- 按物资编码查找物资信息 -->
-  <select id="getInventory" resultType="Inventory">
+  <!-- 按物资编码查找物资信息(原中间表方案,不再使用) -->
+  <!-- <select id="getInventoryOld" resultType="Inventory">
   	<![CDATA[
   	SELECT MD_MATERIAL_ID serialNumber
       ,MD_MATERIAL_NAME name
@@ -15,5 +15,17 @@
       ,MD_ISONE one
   FROM MD_MATERIAL WHERE MD_MATERIAL_ID = #{inventorySerialNumber}
 	]]>
+  </select> -->
+  
+  <!-- 按物资编码查找物资信息(现正式表方案) -->
+  <select id="getInventory" resultType="Inventory">
+  	<![CDATA[
+  	SELECT inventorySerialNumber serialNumber
+      ,name
+      ,specification
+      ,unit
+      ,cost
+  FROM MaterialDefinition WHERE inventorySerialNumber = #{inventorySerialNumber}
+	]]>
   </select>
 </mapper>
\ No newline at end of file
Index: ssts-web/src/main/resources/spring/projects/zd5y/applicationContext-inventory-zd5y.xml
===================================================================
diff -u -r16365 -r16513
--- ssts-web/src/main/resources/spring/projects/zd5y/applicationContext-inventory-zd5y.xml	(.../applicationContext-inventory-zd5y.xml)	(revision 16365)
+++ ssts-web/src/main/resources/spring/projects/zd5y/applicationContext-inventory-zd5y.xml	(.../applicationContext-inventory-zd5y.xml)	(revision 16513)
@@ -37,10 +37,16 @@
     
     <!-- 物资接口数据源,用于查询物资基础信息等 -->
     <bean id="inventoryDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
-        <property name="driverClass" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />  
-        <property name="jdbcUrl" value="jdbc:sqlserver://172.16.61.101:1433;databaseName=hisSyncData" />
+        <property name="driverClass" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
+        <!-- 之前的中间表方案 -->
+        <!-- <property name="jdbcUrl" value="jdbc:sqlserver://172.16.61.101:1433;databaseName=hisSyncData" />
         <property name="user" value="his" />  
-        <property name="password" value="his123" />
+        <property name="password" value="his123" /> -->
+        
+        <!-- 正式业务表方案 -->
+        <property name="jdbcUrl" value="jdbc:sqlserver://localhost:1433;databaseName=zdwySterile" />
+        <property name="user" value="sa" />  
+        <property name="password" value="Forgon1234" />
     </bean>
     
     <!-- InventoryDao接口的实现， 由MyBatis实现-->