Index: ssts-web/src/main/webapp/disinfectsystem/config/qifuyy/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml
===================================================================
diff -u -r27988 -r28576
--- ssts-web/src/main/webapp/disinfectsystem/config/qifuyy/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml	(.../FindPatientInfoByHospitalNumMapper.xml)	(revision 27988)
+++ ssts-web/src/main/webapp/disinfectsystem/config/qifuyy/interfaces/mybatis/FindPatientInfoByHospitalNumMapper.xml	(.../FindPatientInfoByHospitalNumMapper.xml)	(revision 28576)
@@ -9,7 +9,7 @@
   <![CDATA[
 	SELECT  hospitalNumber as patientNumber,
         	patientName,
-	       	convert(varchar,patientAge) patientAge,
+	       	 to_char(patientAge) patientAge,
 	        patientSex,
 	        patientIDCard,
 	        doctorName,
@@ -19,7 +19,7 @@
 	   		ROOMNUMBER,
 	        patientArea,
 	        REMARK
- 	FROM V_MEDINFOTABLEHIS
+ 	FROM V_SICK_VISIT_INFO
 	WHERE hospitalNumber = #{hospitalNum}
 	order by operationTime desc
 	]]>
@@ -30,7 +30,7 @@
   <![CDATA[
 	SELECT  hospitalNumber as patientNumber,
         	patientName,
-	       	convert(varchar,patientAge) patientAge,
+	       	 to_char(patientAge) patientAge,
 	        patientSex,
 	        patientIDCard,
 	        doctorName,
@@ -40,7 +40,7 @@
 	   		ROOMNUMBER,
 	        patientArea,
 	        REMARK
- 	FROM V_MEDINFOTABLEHIS
+ 	FROM V_SICK_VISIT_INFO
 	WHERE hospitalNumber = #{hospitalNum}
 	order by operationTime desc
 	]]>
Index: ssts-web/src/main/webapp/disinfectsystem/config/qifuyy/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml
===================================================================
diff -u -r27988 -r28576
--- ssts-web/src/main/webapp/disinfectsystem/config/qifuyy/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml	(.../FindPatientInfoByTreatmentNumMapper.xml)	(revision 27988)
+++ ssts-web/src/main/webapp/disinfectsystem/config/qifuyy/interfaces/mybatis/FindPatientInfoByTreatmentNumMapper.xml	(.../FindPatientInfoByTreatmentNumMapper.xml)	(revision 28576)
@@ -9,7 +9,7 @@
   <![CDATA[
 	SELECT  clinicNumber as patientNumber,
         	patientName,
-	        convert(varchar,patientAge) patientAge,
+	        to_char(patientAge) patientAge,
 	        case when patientSex='0' then '男' when patientSex='1' then '女' end patientSex,
 	        patientIDCard,
 	        doctorName,
@@ -19,7 +19,7 @@
 	   		ROOMNUMBER,
 	        patientArea,
 	        REMARK
-	FROM V_SICK_VISIT_INFO
+	FROM V_DISPENSARY_SICK_CURE_INFO
 	WHERE clinicNumber = #{treatmentNum}
 	]]>
   </select>