<?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.njcn.mapper.data.LimitRateMapper">
	<resultMap type="com.njcn.pojo.data.LimitRate" id="limitRate"
		autoMapping="true">
	</resultMap>
	<select id="sumlimitRate" resultType="java.lang.Long">
		select t.freq_dev_overtime+
		t.voltage_dev_overtime+
		t.ubalance_overtime+
		t.flicker_overtime+
		t.uaberrance_overtime+
		t.uharm_2_overtime+
		t.uharm_3_overtime+
		t.uharm_4_overtime+
		t.uharm_5_overtime+
		t.uharm_6_overtime+
		t.uharm_7_overtime+
		t.uharm_8_overtime+
		t.uharm_9_overtime+
		t.uharm_10_overtime+
		t.uharm_11_overtime+
		t.uharm_12_overtime+
		t.uharm_13_overtime+
		t.uharm_14_overtime+
		t.uharm_15_overtime+
		t.uharm_16_overtime+
		t.uharm_17_overtime+
		t.uharm_18_overtime+
		t.uharm_19_overtime+
		t.uharm_20_overtime+
		t.uharm_21_overtime+
		t.uharm_22_overtime+
		t.uharm_23_overtime+
		t.uharm_24_overtime+
		t.uharm_25_overtime+
		t.iharm_2_overtime+
		t.iharm_3_overtime+
		t.iharm_4_overtime+
		t.iharm_5_overtime+
		t.iharm_6_overtime+
		t.iharm_7_overtime+
		t.iharm_8_overtime+
		t.iharm_9_overtime+
		t.iharm_10_overtime+
		t.iharm_11_overtime+
		t.iharm_12_overtime+
		t.iharm_13_overtime+
		t.iharm_14_overtime+
		t.iharm_15_overtime+
		t.iharm_16_overtime+
		t.iharm_17_overtime+
		t.iharm_18_overtime+
		t.iharm_19_overtime+
		t.iharm_20_overtime+
		t.iharm_21_overtime+
		t.iharm_22_overtime+
		t.iharm_23_overtime+
		t.iharm_24_overtime+
		t.iharm_25_overtime
		from LIMIT_RATE t
		where TIMEID = #{timeId}
		and MYINDEX = #{lineIndex}
		and PHASIC_TYPE = 'T'
	</select>

	<select id="selectLimitRate" resultType="limitRate">
		select * from LIMIT_RATE
		where TIMEID = #{timeId}
		and MYINDEX = #{lineIndex}
		and PHASIC_TYPE = 'T'
	</select>
</mapper>