<?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.diagbot.mapper.StrIllCriticallyMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.diagbot.entity.StrIllCritically">
        <id column="rec_id" property="recId" />
        <result column="hospital_id" property="hospitalId" />
        <result column="behospital_code" property="behospitalCode" />
        <result column="name" property="name" />
        <result column="sex" property="sex" />
        <result column="record_date" property="recordDate" />
        <!--<result column="diagnosis" property="diagnosis" />-->
        <result column="critical_situation" property="criticalSituation" />
        <result column="patient_sign" property="patientSign" />
        <result column="patient_sign_date" property="patientSignDate" />
        <result column="doctor_sign" property="doctorSign" />
        <result column="doctor_sign_date" property="doctorSignDate" />
        <result column="whole_data" property="wholeData" />
        <result column="remark" property="remark" />
        <result column="is_deleted" property="isDeleted" />
        <result column="gmt_create" property="gmtCreate" />
        <result column="gmt_modified" property="gmtModified" />
        <result column="creator" property="creator" />
        <result column="modifier" property="modifier" />
    </resultMap>

    <update id="updateBatchByKey">
        <foreach collection="list" item="item"  separator=";">
            update str_ill_critically
            <set>
                name = #{item.name},
                sex = #{item.sex},
                record_date = #{item.recordDate},
                <!--diagnosis = #{item.diagnosis},-->
                critical_situation = #{item.criticalSituation},
                patient_sign = #{item.patientSign},
                patient_sign_date = #{item.patientSignDate},
                doctor_sign = #{item.doctorSign},
                doctor_sign_date = #{item.doctorSignDate},
                whole_data = #{item.wholeData},
                remark = #{item.remark},
                <if test="item.gmtModified != null">
                    gmt_modified = #{item.gmtModified},
                </if>
                <if test="item.modifier != null">
                    modifier = #{item.modifier},
                </if>
            </set>
            where rec_id = #{item.recId} and hospital_id = #{item.hospitalId} and behospital_code = #{item.behospitalCode}
        </foreach>
    </update>

    <select id="getColumnZhAndCh" resultType="com.diagbot.dto.data.ColumnZhAndChDTO">
        select COLUMN_NAME as en,column_comment as ch from INFORMATION_SCHEMA.Columns where table_name='str_ill_critically'
    </select>

</mapper>
