Index: ssts-web/src/main/webapp/disinfectsystem/config/fjsssyy/interfaces/mybatis/SyncOrgUnitAndUserMapper.xml
===================================================================
diff -u -r27991 -r28099
--- ssts-web/src/main/webapp/disinfectsystem/config/fjsssyy/interfaces/mybatis/SyncOrgUnitAndUserMapper.xml	(.../SyncOrgUnitAndUserMapper.xml)	(revision 27991)
+++ ssts-web/src/main/webapp/disinfectsystem/config/fjsssyy/interfaces/mybatis/SyncOrgUnitAndUserMapper.xml	(.../SyncOrgUnitAndUserMapper.xml)	(revision 28099)
@@ -7,20 +7,22 @@
   <!-- 获取所有部门 -->
   <select id="getAllOrgUnit" resultType="OrgUnitVo">
   <![CDATA[
-	SELECT LTRIM(RTRIM(coding)) coding,LTRIM(RTRIM(name)) name,LTRIM(RTRIM(parentCoding)) parentCoding
-	FROM  dbo.CSSD_Department where coding is not null and len(LTRIM(RTRIM(coding))) > 0
-	and name is not null and len(LTRIM(RTRIM(name))) > 0
-	and coding != '0'
+	SELECT k.coding coding,
+	       k.name name,
+           '' parentCoding		   
+	FROM  v_gys_ksxx k
 	]]>
   </select>
   
   <!-- 获取所有用户 -->
   <select id="getAllUser" resultType="UserVo">
   <![CDATA[
-	SELECT LTRIM(RTRIM(coding)) coding,LTRIM(RTRIM(name)) name,LTRIM(RTRIM(orgUnitCoding)) orgUnitCoding
-	FROM dbo.CSSD_User where coding is not null and len(LTRIM(RTRIM(coding))) > 0
-	and name is not null and len(LTRIM(RTRIM(name))) > 0
-	ORDER BY coding
+	SELECT y.coding coding,
+	       y.name name,
+		   y.orgUnitCoding orgUnitCoding  
+	FROM v_gys_ygxx y 
+
+
 	]]>
   </select>
 </mapper>
\ No newline at end of file
Index: ssts-web/src/main/webapp/disinfectsystem/config/fjsssyy/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml
===================================================================
diff -u -r27991 -r28099
--- ssts-web/src/main/webapp/disinfectsystem/config/fjsssyy/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml	(.../FindPatientInfoByTreatmentNumMapper.xml)	(revision 27991)
+++ ssts-web/src/main/webapp/disinfectsystem/config/fjsssyy/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml	(.../FindPatientInfoByTreatmentNumMapper.xml)	(revision 28099)
@@ -12,9 +12,9 @@
 	        h.patientAge patientAge,
 	        h.patientSex patientSex,
 	        h.patientIDCard patientIDCard,
-	        '' doctorName,
+	        h.doctorName doctorName,
 	        '' operation
-	FROM CSSD_ClinicNumber h
+	FROM v_gys_mzbrxx h
 	WHERE h.clinicNumber = #{treatmentNum}
 	]]>
   </select>
Index: ssts-web/src/main/webapp/disinfectsystem/config/fjsssyy/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml
===================================================================
diff -u -r27991 -r28099
--- ssts-web/src/main/webapp/disinfectsystem/config/fjsssyy/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml	(.../FindPatientInfoByHospitalNumMapper.xml)	(revision 27991)
+++ ssts-web/src/main/webapp/disinfectsystem/config/fjsssyy/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml	(.../FindPatientInfoByHospitalNumMapper.xml)	(revision 28099)
@@ -13,9 +13,8 @@
 	        h.patientSex patientSex,
 	        h.patientIDCard patientIDCard,
 	        h.doctorName doctorName,
-	        h.operation operation,
-	        convert(varchar,h.operationTime,120) operationTime
-	FROM CSSD_HospitalNumber h
+	        '' operation
+	FROM v_gys_zybrxx h
 	WHERE h.hospitalNumber = #{hospitalNum}
 	]]>
   </select>
@@ -29,9 +28,8 @@
 	        h.patientSex patientSex,
 	        h.patientIDCard patientIDCard,
 	        h.doctorName doctorName,
-	        h.operation operation,
-	        convert(varchar,h.operationTime,120) operationTime
-	FROM CSSD_HospitalNumber h
+	        '' operation
+	FROM v_gys_zybrxx h
 	WHERE h.hospitalNumber = #{hospitalNum}
 	]]>
   </select>