Index: ssts-web/src/main/resources/config/gzs12rmyy/mybatis/FindPatientInfoByHospitalNumMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/resources/config/gzs12rmyy/mybatis/FindPatientInfoByHospitalNumMapper.xml	(revision 0)
+++ ssts-web/src/main/resources/config/gzs12rmyy/mybatis/FindPatientInfoByHospitalNumMapper.xml	(revision 17591)
@@ -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">
+  
+ 
+ <!-- 按住院号查找病人信息 -->
+  <select id="findPatientInfoByHospitalNum" resultType="PatientInfoVO">
+  <![CDATA[
+	select f.PATIENT_NO   hospitalNumber,
+ f.inpatient_no searialNumber,
+ f.name patientName,
+ floor(months_between(SYSDATE, birthday) / 12)   patientAge,
+ f.SEX_CODE  patientSex,
+ f.IDENNO      patientIDCard,
+ f.HOUSE_DOC_NAME     doctorName,
+ null as operation,
+ null as operationTime,
+  f.NURSE_CELL_NAME patientArea,
+   f.DEPT_NAME roomNumber,
+  null as  bedNumber, 
+  f.memo  	remark
+from  FIN_IPR_INMAININFO   f
+	]]>
+  </select>
+
+  <!-- 按门诊号查找病人信息 -->
+  <select id="findPatientInfoByTreatmentNum" resultType="PatientInfoVO">
+  <![CDATA[
+	select t.card_no clinicNumber, ---诊疗号（门诊）
+t.clinic_code serialNumber, ---当前诊疗流水号
+t.name patientName, --病人姓名
+(select floor(MONTHS_BETWEEN(sysdate,c.birthday)/12)  from com_patientinfo c where c.card_no=t.card_no) patientAge,---病人年龄
+t.SEX_CODE patientSex, ---病人性别
+(select c.IDENNO  from com_patientinfo c where c.card_no=t.card_no)  patientIDCard, ---病人身份证号
+DOCT_NAME doctorName, --医生
+null as operation,
+null as operationTime,
+DEPT_NAME as patientArea,
+null as roomNumber,
+null as bedNumber,
+null as remark
+from  fin_opr_register  t 
+
+]]>
+  </select>
+</mapper>
\ No newline at end of file
Index: ssts-web/src/main/resources/spring/projects/gzs12rmyy/applicationContext-his-gzs12rmyy.xml
===================================================================
diff -u -r16814 -r17591
--- ssts-web/src/main/resources/spring/projects/gzs12rmyy/applicationContext-his-gzs12rmyy.xml	(.../applicationContext-his-gzs12rmyy.xml)	(revision 16814)
+++ ssts-web/src/main/resources/spring/projects/gzs12rmyy/applicationContext-his-gzs12rmyy.xml	(.../applicationContext-his-gzs12rmyy.xml)	(revision 17591)
@@ -18,7 +18,7 @@
         class="com.forgon.disinfectsystem.datasynchronization.service.DataSynchronizationManagerImpl" >
 		<property name="config" >
             <bean class="com.forgon.tools.json.JsonObjectFromResourceFactoryBean">
-                <property name="resource" value="config/gzfdzl/dataSyncConfig.json" />
+                <property name="resource" value="config/gzs12rmyy/dataSyncConfig.json" />
                 <property name="charset" value="UTF-8" />
             </bean>
         </property>
@@ -42,10 +42,10 @@
     </bean>
     
     <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.1.254:1433;databaseName=fdyyhis" />  
-        <property name="user" value="his" />  
-        <property name="password" value="manager" />
+        <property name="driverClass" value="oracle.jdbc.OracleDriver" />  
+        <property name="jdbcUrl" value="jdbc:oracle:thin:@//192.168.2.32:1521/his" />  
+        <property name="user" value="mediexam" />  
+        <property name="password" value="system1901" />
     </bean>
     
     
@@ -57,7 +57,7 @@
        <property name="sqlSessionFactory">
             <bean class="org.mybatis.spring.SqlSessionFactoryBean">
                 <property name="dataSource" ref="hisDataSource" />
-                <property name="mapperLocations" value="classpath:config/gzfdzl/mybatis/SyncOrgUnitAndUserMapper.xml" />
+                <property name="mapperLocations" value="classpath*:config/gzs12rmyy/mybatis/SyncOrgUnitAndUserMapper.xml" />
                 <property name="typeAliasesPackage" value="com.forgon.disinfectsystem.datasynchronization.model" />
             </bean>
        </property>
@@ -69,7 +69,7 @@
        <property name="sqlSessionFactory">
             <bean class="org.mybatis.spring.SqlSessionFactoryBean">
                 <property name="dataSource" ref="hisDataSource" />
-                <property name="mapperLocations" value="classpath:config/gzfdzl/mybatis/FindPatientInfoByHospitalNumMapper.xml" />
+                <property name="mapperLocations" value="classpath*:config/gzs12rmyy/mybatis/FindPatientInfoByHospitalNumMapper.xml" />
                 <property name="typeAliasesPackage" value="com.forgon.disinfectsystem.datasynchronization.model" />
             </bean>
        </property>
@@ -81,7 +81,7 @@
        <property name="sqlSessionFactory">
             <bean class="org.mybatis.spring.SqlSessionFactoryBean">
                 <property name="dataSource" ref="hisDataSource" />
-                <property name="mapperLocations" value="classpath:config/gzfdzl/mybatis/FindPatientInfoByTreatmentNumMapper.xml" />
+                <property name="mapperLocations" value="classpath*:config/gzs12rmyy/mybatis/FindPatientInfoByHospitalNumMapper.xml" />
                 <property name="typeAliasesPackage" value="com.forgon.disinfectsystem.datasynchronization.model" />
             </bean>
        </property>
Index: ssts-web/src/main/resources/config/gzs12rmyy/mybatis/SyncOrgUnitAndUserMapper.xml
===================================================================
diff -u
--- ssts-web/src/main/resources/config/gzs12rmyy/mybatis/SyncOrgUnitAndUserMapper.xml	(revision 0)
+++ ssts-web/src/main/resources/config/gzs12rmyy/mybatis/SyncOrgUnitAndUserMapper.xml	(revision 17591)
@@ -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.SyncOrgUnitAndUserDao">
+  
+  <!-- 获取所有部门 -->
+  <select id="getAllOrgUnit" resultType="OrgUnitVo">
+  <![CDATA[
+	select name,coding,parentCoding 
+from srhis.VIEW_CSSD_DEPARTMENT
+	]]>
+  </select>
+  
+  <!-- 获取所有用户 -->
+  <select id="getAllUser" resultType="UserVo">
+  <![CDATA[
+  select name,coding,orgunitcoding
+from srhis.VIEW_CSSD_USER
+	]]>
+  </select>
+</mapper>