Index: ssts-web/src/main/webapp/disinfectsystem/config/szsdsrmyy/interfaces/mybatis/SyncOperationReservation_Mapper.xml
===================================================================
diff -u
--- ssts-web/src/main/webapp/disinfectsystem/config/szsdsrmyy/interfaces/mybatis/SyncOperationReservation_Mapper.xml	(revision 0)
+++ ssts-web/src/main/webapp/disinfectsystem/config/szsdsrmyy/interfaces/mybatis/SyncOperationReservation_Mapper.xml	(revision 28104)
@@ -0,0 +1,61 @@
+<?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.inventorymanagement.dao.InvoicePlanDao">
+	<!-- 结果集 -->
+	<resultMap id="queryForListMap" type="com.forgon.disinfectsystem.inventorymanagement.model.HrpInvoicePlan">
+		<result  column="ID" property="serialNumber" jdbcType="VARCHAR"/>
+		<result  column="OPERATION1" property="operationName" jdbcType="VARCHAR"/>
+		<result  column="OPROOMID" property="operatingRoom" jdbcType="VARCHAR"/>
+		<result  column="SURGEON" property="doctors" jdbcType="VARCHAR"/>
+		<result  column="SCHEDULED_DATE_TIME" property="operationTime" jdbcType="TIMESTAMP"/>
+		<result  column="SCHEDULE_ID" property="scheduleId" jdbcType="VARCHAR"/>
+		<result  column="DEPT_NAME" property="deptName" jdbcType="VARCHAR"/>
+		<result  column="NAME" property="patientName" jdbcType="VARCHAR"/>
+		<result  column="PATIENT_ID" property="hospitalNumber" jdbcType="VARCHAR"/>
+		<result  column="FIRST_OPERATION_NURSE" property="washHandNurse" jdbcType="VARCHAR"/>
+		<result  column="FIRST_SUPPLY_NURSE" property="circuitNurse" jdbcType="VARCHAR"/>
+		<result  column="CONSOLE_NAME" property="consoleName" jdbcType="VARCHAR"/>
+		<result  column="needTranscoding" property="needTranscoding" jdbcType="VARCHAR"/>
+		<result  column="PATIENTAGE" property="patientAge" jdbcType="VARCHAR"/>
+	</resultMap>
+	
+<!-- 按手术时间查找手术预约单-->
+ <select id="findSyncOperationReservationByTimes" resultMap="queryForListMap">
+  	<![CDATA[
+	SELECT  po.*,'' needTranscoding
+	FROM v_gys_OperationPatientInfo po 
+	WHERE 1=1
+	]]>
+	<if test="startDate != null">
+		and po.SCHEDULED_DATE_TIME >= #{startDate}
+	</if>
+	<if test="endDate != null">
+		<![CDATA[
+		and po.SCHEDULED_DATE_TIME <= #{endDate}
+		]]>
+	</if>
+	<![CDATA[
+	ORDER BY po.ID
+	]]>
+  </select>
+  
+	<!-- 按申请单单号集合查找申请单-->
+   <select id="findSyncOperationReservationBySerialNumbers" resultMap="queryForListMap">
+  	<![CDATA[
+	SELECT  po.*,'' needTranscoding
+	FROM v_gys_OperationPatientInfo po
+	WHERE 1=1
+	]]>
+	<if test="serialNumbers != null and serialNumbers.size>0"> 
+			and po.ID in
+		    <foreach collection="serialNumbers"  item="serialNumber" open="(" separator=", " close=")">
+	             #{serialNumber}       
+	       </foreach>     
+	 </if>
+	<![CDATA[
+	ORDER BY po.SCHEDULED_DATE_TIME
+	]]>
+   </select>
+</mapper>
\ No newline at end of file