<?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.emr.dao.Archive_MasterMapper">


    <select id="getInpNoAndVisitIdByBarCode" resultType="com.emr.vo.UpdateReturnVo">
        select inp_no,visit_id,discharge_date_time,name from archive_master where  bar_code=#{barCode}
    </select>
    <select id="getMasterID" resultType="com.emr.vo.ArchiveMasterVo">
        select * from archive_master where discharge_date_time between'2024-02-01 00:00:00' and '2024-03-31 23:59:59'
    </select>

</mapper>