<!-- 根据状态和姓名、病历号取得当天患者信息（分页、查询） -->
   <select id="getPatientByState" resultType="java.util.Map">
       SELECT *
       FROM register
       WHERE date(visit_date) = date(now())
       <if test="employee_id!=null and employee_id!=''">
           AND employee_id = #{employee_id}
       </if>
       <if test="case_number!=null and case_number!=''">
           AND case_number = #{case_number}
       </if>
       <if test="real_name!=null and real_name!=''">
           AND real_name = #{real_name}
       </if>
       <if test="visit_state!=null and visit_state!=''">
           AND visit_state = #{visit_state}
       </if>
       ORDER BY visit_date
       LIMIT ${(nowPageNumber-1) * pageSize} ,#{pageSize}
   </select>