Index: ssts-web/src/main/resources/config/hdqrmyy/mybatis/FindPatientInfoByTreatmentNumMapper.xml
===================================================================
diff -u -r14676 -r15340
--- ssts-web/src/main/resources/config/hdqrmyy/mybatis/FindPatientInfoByTreatmentNumMapper.xml	(.../FindPatientInfoByTreatmentNumMapper.xml)	(revision 14676)
+++ ssts-web/src/main/resources/config/hdqrmyy/mybatis/FindPatientInfoByTreatmentNumMapper.xml	(.../FindPatientInfoByTreatmentNumMapper.xml)	(revision 15340)
@@ -7,14 +7,14 @@
   <!-- 按门诊号查找病人信息 -->
   <select id="findPatientInfoByTreatmentNum" resultType="PatientInfoVO">
   <![CDATA[
-	SELECT h.clinicNumber as patientNumber,
-        	h.patientName as patientName,
-	        h.patientAge as patientAge,
-	        h.patientSex as patientSex,
-	        h.patientIDCard as patientIDCard,
-	        '' as doctorName,
-	        '' as operation
-	FROM CSSD_ClinicNumber h
+	SELECT h.clinicNumber patientNumber,
+          h.patientName patientName,
+          h.patientAge patientAge,
+          h.patientSex patientSex,
+          h.patientIDCard patientIDCard,
+          h.doctorName doctorName,
+          h.patientArea patientArea
+  FROM v_cssd_clinicnumber h
 	WHERE h.clinicNumber = #{treatmentNum}
 	]]>
   </select>
Index: ssts-web/src/main/resources/spring/projects/hdqrmyy/applicationContext-his.xml
===================================================================
diff -u -r14676 -r15340
--- ssts-web/src/main/resources/spring/projects/hdqrmyy/applicationContext-his.xml	(.../applicationContext-his.xml)	(revision 14676)
+++ ssts-web/src/main/resources/spring/projects/hdqrmyy/applicationContext-his.xml	(.../applicationContext-his.xml)	(revision 15340)
@@ -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:@//172.16.4.1:1521/orc1" />  
+        <property name="user" value="JK" />  
+        <property name="password" value="JK" />
     </bean>
     
     
Index: ssts-web/src/main/resources/config/hdqrmyy/mybatis/FindPatientInfoByHospitalNumMapper.xml
===================================================================
diff -u -r14676 -r15340
--- ssts-web/src/main/resources/config/hdqrmyy/mybatis/FindPatientInfoByHospitalNumMapper.xml	(.../FindPatientInfoByHospitalNumMapper.xml)	(revision 14676)
+++ ssts-web/src/main/resources/config/hdqrmyy/mybatis/FindPatientInfoByHospitalNumMapper.xml	(.../FindPatientInfoByHospitalNumMapper.xml)	(revision 15340)
@@ -7,14 +7,15 @@
   <!-- 按住院号查找病人信息 -->
   <select id="findPatientInfoByHospitalNum" resultType="PatientInfoVO">
   <![CDATA[
-	SELECT h.hospitalNumber as patientNumber,
-        	h.patientName as patientName,
-	        h.patientAge as patientAge,
-	        h.patientSex as patientSex,
-	        h.patientIDCard as patientIDCard,
-	        h.doctorName as doctorName,
-	        h.operation as operation
-	FROM CSSD_HospitalNumber h
+		SELECT h.hospitalNumber patientNumber,
+          h.patientName patientName,
+          h.patientAge patientAge,
+          h.patientSex patientSex,
+          h.patientIDCard patientIDCard,
+          h.doctorName doctorName,
+          h.patientArea patientArea,
+      h.bedNumber bedNumber
+  FROM v_cssd_hospitalnumber h
 	WHERE h.hospitalNumber = #{hospitalNum}
 	]]>
   </select>
Index: ssts-web/src/main/resources/config/hdqrmyy/mybatis/SyncOrgUnitAndUserMapper.xml
===================================================================
diff -u -r14676 -r15340
--- ssts-web/src/main/resources/config/hdqrmyy/mybatis/SyncOrgUnitAndUserMapper.xml	(.../SyncOrgUnitAndUserMapper.xml)	(revision 14676)
+++ ssts-web/src/main/resources/config/hdqrmyy/mybatis/SyncOrgUnitAndUserMapper.xml	(.../SyncOrgUnitAndUserMapper.xml)	(revision 15340)
@@ -7,22 +7,18 @@
   <!-- 获取所有部门 -->
   <select id="getAllOrgUnit" resultType="OrgUnitVo">
   <![CDATA[
-	SELECT deptcode as coding,
-        	deptname as name,
-	        parentCoding as parentCoding
-	FROM cssd_department
-	where deptcode != 0
+	SELECT coding,name,	'' as parentCoding
+	FROM v_cssd_department
+	where coding != '0'
 	]]>
   </select>
   
   <!-- 获取所有用户 -->
   <select id="getAllUser" resultType="UserVo">
   <![CDATA[
-	SELECT usercode as coding,
-        	username as name,
-	        deptcode as orgUnitCoding
-	FROM CSSD_User
-	ORDER BY deptcode
+	SELECT coding, name,orgUnitCoding
+	FROM v_cssd_user
+	ORDER BY orgUnitCoding
 	]]>
   </select>
 </mapper>
\ No newline at end of file