Index: ssts-web/src/main/resources/config/dgszyy/mybatis/FindPatientInfoByHospitalNumMapper.xml
===================================================================
diff -u -r15293 -r15624
--- ssts-web/src/main/resources/config/dgszyy/mybatis/FindPatientInfoByHospitalNumMapper.xml	(.../FindPatientInfoByHospitalNumMapper.xml)	(revision 15293)
+++ ssts-web/src/main/resources/config/dgszyy/mybatis/FindPatientInfoByHospitalNumMapper.xml	(.../FindPatientInfoByHospitalNumMapper.xml)	(revision 15624)
@@ -11,11 +11,19 @@
         	h.xm as patientName,
 	        h.nl as patientAge,
 	        h.xb as patientSex,
-	        '' as patientIDCard,
-	        h.syysxm as doctorName,
-	        h.jbzdmc as operation 
-	from rydj h
-	WHERE h.zyh = #{hospitalNum}
+	        h.sfzh as patientIDCard,
+	        i.[手术者] as doctorName,
+	        i.[手术名称] as operation,
+			i.[确定手术时间] as operationTime,
+			i.[手术间] as operationRoom, 
+			i.[床位] as bedNumber,
+			'' as roomNummber,
+			i.[科别] as patientArea
+
+	from rydj h, [手术通知与安排] i
+	where h.zyhcs = i.zyhcs
+	and  h.zyh = #{hospitalNum}
+	ORDER BY [通知时间]
 	]]>
   </select>
   
Index: ssts-web/src/main/resources/spring/projects/dgszyy/HIS.xml
===================================================================
diff -u -r15293 -r15624
--- ssts-web/src/main/resources/spring/projects/dgszyy/HIS.xml	(.../HIS.xml)	(revision 15293)
+++ ssts-web/src/main/resources/spring/projects/dgszyy/HIS.xml	(.../HIS.xml)	(revision 15624)
@@ -48,8 +48,8 @@
 		destroy-method="close">
         <property name="driverClass" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />  
         <property name="jdbcUrl" value="jdbc:sqlserver://10.12.0.19:1433;databaseName=WINZYGL" />
-        <property name="user" value="tmzs" />  
-        <property name="password" value="tmzs" />
+        <property name="user" value="sa" />  
+        <property name="password" value="sa" />
         
         <property name="minPoolSize">
 			<value>5</value>