<?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="cn.cecep.talroad.mapper.analysis.SRaLowMonitoringGasMapper">
    <resultMap id="BaseResultMap" type="cn.cecep.talroad.domain.analysis.SRaLowMonitoringGas">
        <!--@mbg.generated-->
        <!--@Table s_ra_low_monitoring_gas-->
        <id column="data_id" jdbcType="OTHER" property="dataId"/>
        <result column="factory_id" jdbcType="VARCHAR" property="factoryId"/>
        <result column="factory_name" jdbcType="VARCHAR" property="factoryName"/>
        <result column="industry_category_name" jdbcType="VARCHAR" property="industryCategoryName"/>
        <result column="industry_category_code" jdbcType="VARCHAR" property="industryCategoryCode"/>
        <result column="district_name" jdbcType="VARCHAR" property="districtName"/>
        <result column="district_code" jdbcType="VARCHAR" property="districtCode"/>
        <result column="pollutants_name" jdbcType="VARCHAR" property="pollutantsName"/>
        <result column="pollutants_code" jdbcType="VARCHAR" property="pollutantsCode"/>
        <result column="monitor_time" jdbcType="TIMESTAMP" property="monitorTime"/>
        <result column="moitor_name" jdbcType="VARCHAR" property="moitorName"/>
        <result column="monitor_value" jdbcType="NUMERIC" property="monitorValue"/>
        <result column="create_time" jdbcType="TIMESTAMP" property="createTime"/>
        <result column="monitor_id" jdbcType="VARCHAR" property="monitorId"/>
        <result column="monitoring_unit" jdbcType="VARCHAR" property="monitoringUnit"/>
        <result column="emission_standard_name" jdbcType="VARCHAR" property="emissionStandardName"/>
        <result column="standard_num" jdbcType="VARCHAR" property="standardNum"/>
        <result column="flow" jdbcType="VARCHAR" property="flow"/>
        <result column="humidity" jdbcType="VARCHAR" property="humidity"/>
        <result column="oxygen_content" jdbcType="VARCHAR" property="oxygenContent"/>
        <result column="velocity" jdbcType="VARCHAR" property="velocity"/>
        <result column="production_load" jdbcType="VARCHAR" property="productionLoad"/>
        <result column="monitoring_class" jdbcType="VARCHAR" property="monitoringClass"/>
        <result column="actual_concentration" jdbcType="VARCHAR" property="actualConcentration"/>
        <result column="obversion_concentration" jdbcType="VARCHAR" property="obversionConcentration"/>
        <result column="concentration" jdbcType="VARCHAR" property="concentration"/>
        <result column="upper_value" jdbcType="VARCHAR" property="upperValue"/>
        <result column="lower_value" jdbcType="VARCHAR" property="lowerValue"/>
        <result column="unit" jdbcType="VARCHAR" property="unit"/>
        <result column="exceeding_standard" jdbcType="VARCHAR" property="exceedingStandard"/>
        <result column="exceeding_multiple" jdbcType="VARCHAR" property="exceedingMultiple"/>
        <result column="temperature" jdbcType="VARCHAR" property="temperature"/>
    </resultMap>
    <sql id="Base_Column_List">
        <!--@mbg.generated-->
        data_id, factory_id, factory_name, industry_category_name, industry_category_code,
        district_name, district_code, pollutants_name, pollutants_code, monitor_time, moitor_name,
        monitor_value, create_time, monitor_id, monitoring_unit, emission_standard_name,
        standard_num, flow, humidity, oxygen_content, velocity, production_load, monitoring_class,
        actual_concentration, obversion_concentration, concentration, upper_value, lower_value,
        unit, exceeding_standard, exceeding_multiple, temperature
    </sql>
    <update id="updateBatch" parameterType="java.util.List">
        <!--@mbg.generated-->
        update s_ra_low_monitoring_gas
        <trim prefix="set" suffixOverrides=",">
            <trim prefix="factory_id = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.factoryId,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="factory_name = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.factoryName,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="industry_category_name = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.industryCategoryName,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="industry_category_code = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.industryCategoryCode,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="district_name = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.districtName,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="district_code = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.districtCode,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="pollutants_name = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.pollutantsName,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="pollutants_code = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.pollutantsCode,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="monitor_time = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.monitorTime,jdbcType=TIMESTAMP}
                </foreach>
            </trim>
            <trim prefix="moitor_name = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.moitorName,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="monitor_value = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.monitorValue,jdbcType=NUMERIC}
                </foreach>
            </trim>
            <trim prefix="create_time = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.createTime,jdbcType=TIMESTAMP}
                </foreach>
            </trim>
            <trim prefix="monitor_id = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.monitorId,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="monitoring_unit = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.monitoringUnit,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="emission_standard_name = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.emissionStandardName,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="standard_num = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.standardNum,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="flow = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.flow,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="humidity = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.humidity,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="oxygen_content = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.oxygenContent,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="velocity = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.velocity,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="production_load = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.productionLoad,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="monitoring_class = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.monitoringClass,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="actual_concentration = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.actualConcentration,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="obversion_concentration = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.obversionConcentration,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="concentration = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.concentration,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="upper_value = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.upperValue,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="lower_value = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.lowerValue,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="unit = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.unit,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="exceeding_standard = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.exceedingStandard,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="exceeding_multiple = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.exceedingMultiple,jdbcType=VARCHAR}
                </foreach>
            </trim>
            <trim prefix="temperature = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    when data_id = #{item.dataId,jdbcType=OTHER} then #{item.temperature,jdbcType=VARCHAR}
                </foreach>
            </trim>
        </trim>
        where data_id in
        <foreach close=")" collection="list" item="item" open="(" separator=", ">
            #{item.dataId,jdbcType=OTHER}
        </foreach>
    </update>
    <update id="updateBatchSelective" parameterType="java.util.List">
        <!--@mbg.generated-->
        update s_ra_low_monitoring_gas
        <trim prefix="set" suffixOverrides=",">
            <trim prefix="factory_id = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.factoryId != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.factoryId,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="factory_name = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.factoryName != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.factoryName,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="industry_category_name = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.industryCategoryName != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.industryCategoryName,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="industry_category_code = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.industryCategoryCode != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.industryCategoryCode,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="district_name = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.districtName != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.districtName,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="district_code = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.districtCode != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.districtCode,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="pollutants_name = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.pollutantsName != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.pollutantsName,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="pollutants_code = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.pollutantsCode != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.pollutantsCode,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="monitor_time = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.monitorTime != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.monitorTime,jdbcType=TIMESTAMP}
                    </if>
                </foreach>
            </trim>
            <trim prefix="moitor_name = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.moitorName != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.moitorName,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="monitor_value = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.monitorValue != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.monitorValue,jdbcType=NUMERIC}
                    </if>
                </foreach>
            </trim>
            <trim prefix="create_time = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.createTime != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.createTime,jdbcType=TIMESTAMP}
                    </if>
                </foreach>
            </trim>
            <trim prefix="monitor_id = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.monitorId != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.monitorId,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="monitoring_unit = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.monitoringUnit != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.monitoringUnit,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="emission_standard_name = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.emissionStandardName != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.emissionStandardName,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="standard_num = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.standardNum != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.standardNum,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="flow = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.flow != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.flow,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="humidity = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.humidity != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.humidity,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="oxygen_content = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.oxygenContent != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.oxygenContent,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="velocity = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.velocity != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.velocity,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="production_load = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.productionLoad != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.productionLoad,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="monitoring_class = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.monitoringClass != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.monitoringClass,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="actual_concentration = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.actualConcentration != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.actualConcentration,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="obversion_concentration = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.obversionConcentration != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.obversionConcentration,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="concentration = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.concentration != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.concentration,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="upper_value = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.upperValue != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.upperValue,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="lower_value = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.lowerValue != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.lowerValue,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="unit = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.unit != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.unit,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="exceeding_standard = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.exceedingStandard != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.exceedingStandard,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="exceeding_multiple = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.exceedingMultiple != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.exceedingMultiple,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
            <trim prefix="temperature = case" suffix="end,">
                <foreach collection="list" index="index" item="item">
                    <if test="item.temperature != null">
                        when data_id = #{item.dataId,jdbcType=OTHER} then #{item.temperature,jdbcType=VARCHAR}
                    </if>
                </foreach>
            </trim>
        </trim>
        where data_id in
        <foreach close=")" collection="list" item="item" open="(" separator=", ">
            #{item.dataId,jdbcType=OTHER}
        </foreach>
    </update>
    <select id="selectHourDataByTime" resultMap="BaseResultMap">
      <![CDATA[
        select sd.factory_id,
               po.id as monitor_id,
               sd.monitor_time,
               sd.pollutants_code,
               sd.pollutants_name,
               "replace"(sd.actual_concentration, '<', '') as actual_concentration
        from s_ra_low_monitoring_gas sd
                 inner join pc_outlet po on sd.factory_id = po.factory_id and sd.moitor_name = po.monitoring_point_name
        where po.pollutant_type = '4'
          and po.pollutant_outlet_type = '1'
          and sd.monitor_time between #{startDate} and #{endDate}
        order by sd.monitor_time
        ]]>
    </select>


    <insert id="batchInsert" parameterType="map">
        <!--@mbg.generated-->
        insert into s_ra_low_monitoring_gas
        (data_id, factory_id, factory_name, industry_category_name, industry_category_code,
        district_name, district_code, pollutants_name, pollutants_code, monitor_time, moitor_name,
        monitor_value, create_time, monitor_id, monitoring_unit, emission_standard_name,
        standard_num, flow, humidity, oxygen_content, velocity, production_load, monitoring_class,
        actual_concentration, obversion_concentration, concentration, upper_value, lower_value,
        unit, exceeding_standard, exceeding_multiple, temperature)
        values
        <foreach collection="list" item="item" separator=",">
            (#{item.dataId,jdbcType=OTHER}, #{item.factoryId,jdbcType=VARCHAR}, #{item.factoryName,jdbcType=VARCHAR},
            #{item.industryCategoryName,jdbcType=VARCHAR}, #{item.industryCategoryCode,jdbcType=VARCHAR},
            #{item.districtName,jdbcType=VARCHAR}, #{item.districtCode,jdbcType=VARCHAR}, #{item.pollutantsName,jdbcType=VARCHAR},
            #{item.pollutantsCode,jdbcType=VARCHAR}, #{item.monitorTime,jdbcType=TIMESTAMP},
            #{item.moitorName,jdbcType=VARCHAR}, #{item.monitorValue,jdbcType=NUMERIC}, #{item.createTime,jdbcType=TIMESTAMP},
            #{item.monitorId,jdbcType=VARCHAR}, #{item.monitoringUnit,jdbcType=VARCHAR}, #{item.emissionStandardName,jdbcType=VARCHAR},
            #{item.standardNum,jdbcType=VARCHAR}, #{item.flow,jdbcType=VARCHAR}, #{item.humidity,jdbcType=VARCHAR},
            #{item.oxygenContent,jdbcType=VARCHAR}, #{item.velocity,jdbcType=VARCHAR}, #{item.productionLoad,jdbcType=VARCHAR},
            #{item.monitoringClass,jdbcType=VARCHAR}, #{item.actualConcentration,jdbcType=VARCHAR},
            #{item.obversionConcentration,jdbcType=VARCHAR}, #{item.concentration,jdbcType=VARCHAR},
            #{item.upperValue,jdbcType=VARCHAR}, #{item.lowerValue,jdbcType=VARCHAR}, #{item.unit,jdbcType=VARCHAR},
            #{item.exceedingStandard,jdbcType=VARCHAR}, #{item.exceedingMultiple,jdbcType=VARCHAR},
            #{item.temperature,jdbcType=VARCHAR})
        </foreach>
    </insert>
</mapper>
