<?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.gyee.frame.mapper.auto.WindturbinewindyawMapper">
  <resultMap id="BaseResultMap" type="com.gyee.frame.model.auto.Windturbinewindyaw">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <id column="ID" jdbcType="DECIMAL" property="id" />
    <result column="WINDTURBINEID" jdbcType="VARCHAR" property="windturbineid" />
    <result column="RECORDDATE" jdbcType="TIMESTAMP" property="recorddate" />
    <result column="SPEED" jdbcType="DECIMAL" property="speed" />
    <result column="QUALIFIED" jdbcType="DECIMAL" property="qualified" />
    <result column="UNQUALIFIED" jdbcType="DECIMAL" property="unqualified" />
    <result column="R-50" jdbcType="DECIMAL" property="r_50" />
    <result column="R-49" jdbcType="DECIMAL" property="r_49" />
    <result column="R-48" jdbcType="DECIMAL" property="r_48" />
    <result column="R-47" jdbcType="DECIMAL" property="r_47" />
    <result column="R-46" jdbcType="DECIMAL" property="r_46" />
    <result column="R-45" jdbcType="DECIMAL" property="r_45" />
    <result column="R-44" jdbcType="DECIMAL" property="r_44" />
    <result column="R-43" jdbcType="DECIMAL" property="r_43" />
    <result column="R-42" jdbcType="DECIMAL" property="r_42" />
    <result column="R-41" jdbcType="DECIMAL" property="r_41" />
    <result column="R-40" jdbcType="DECIMAL" property="r_40" />
    <result column="R-39" jdbcType="DECIMAL" property="r_39" />
    <result column="R-38" jdbcType="DECIMAL" property="r_38" />
    <result column="R-37" jdbcType="DECIMAL" property="r_37" />
    <result column="R-36" jdbcType="DECIMAL" property="r_36" />
    <result column="R-35" jdbcType="DECIMAL" property="r_35" />
    <result column="R-34" jdbcType="DECIMAL" property="r_34" />
    <result column="R-33" jdbcType="DECIMAL" property="r_33" />
    <result column="R-32" jdbcType="DECIMAL" property="r_32" />
    <result column="R-31" jdbcType="DECIMAL" property="r_31" />
    <result column="R-30" jdbcType="DECIMAL" property="r_30" />
    <result column="R-29" jdbcType="DECIMAL" property="r_29" />
    <result column="R-28" jdbcType="DECIMAL" property="r_28" />
    <result column="R-27" jdbcType="DECIMAL" property="r_27" />
    <result column="R-26" jdbcType="DECIMAL" property="r_26" />
    <result column="R-25" jdbcType="DECIMAL" property="r_25" />
    <result column="R-24" jdbcType="DECIMAL" property="r_24" />
    <result column="R-23" jdbcType="DECIMAL" property="r_23" />
    <result column="R-22" jdbcType="DECIMAL" property="r_22" />
    <result column="R-21" jdbcType="DECIMAL" property="r_21" />
    <result column="R-20" jdbcType="DECIMAL" property="r_20" />
    <result column="R-19" jdbcType="DECIMAL" property="r_19" />
    <result column="R-18" jdbcType="DECIMAL" property="r_18" />
    <result column="R-17" jdbcType="DECIMAL" property="r_17" />
    <result column="R-16" jdbcType="DECIMAL" property="r_16" />
    <result column="R-15" jdbcType="DECIMAL" property="r_15" />
    <result column="R-14" jdbcType="DECIMAL" property="r_14" />
    <result column="R-13" jdbcType="DECIMAL" property="r_13" />
    <result column="R-12" jdbcType="DECIMAL" property="r_12" />
    <result column="R-11" jdbcType="DECIMAL" property="r_11" />
    <result column="R-10" jdbcType="DECIMAL" property="r_10" />
    <result column="R-9" jdbcType="DECIMAL" property="r_9" />
    <result column="R-8" jdbcType="DECIMAL" property="r_8" />
    <result column="R-7" jdbcType="DECIMAL" property="r_7" />
    <result column="R-6" jdbcType="DECIMAL" property="r_6" />
    <result column="R-5" jdbcType="DECIMAL" property="r_5" />
    <result column="R-4" jdbcType="DECIMAL" property="r_4" />
    <result column="R-3" jdbcType="DECIMAL" property="r_3" />
    <result column="R-2" jdbcType="DECIMAL" property="r_2" />
    <result column="R-1" jdbcType="DECIMAL" property="r_1" />
    <result column="R0" jdbcType="DECIMAL" property="r0" />
    <result column="R1" jdbcType="DECIMAL" property="r1" />
    <result column="R2" jdbcType="DECIMAL" property="r2" />
    <result column="R3" jdbcType="DECIMAL" property="r3" />
    <result column="R4" jdbcType="DECIMAL" property="r4" />
    <result column="R5" jdbcType="DECIMAL" property="r5" />
    <result column="R6" jdbcType="DECIMAL" property="r6" />
    <result column="R7" jdbcType="DECIMAL" property="r7" />
    <result column="R8" jdbcType="DECIMAL" property="r8" />
    <result column="R9" jdbcType="DECIMAL" property="r9" />
    <result column="R10" jdbcType="DECIMAL" property="r10" />
    <result column="R11" jdbcType="DECIMAL" property="r11" />
    <result column="R12" jdbcType="DECIMAL" property="r12" />
    <result column="R13" jdbcType="DECIMAL" property="r13" />
    <result column="R14" jdbcType="DECIMAL" property="r14" />
    <result column="R15" jdbcType="DECIMAL" property="r15" />
    <result column="R16" jdbcType="DECIMAL" property="r16" />
    <result column="R17" jdbcType="DECIMAL" property="r17" />
    <result column="R18" jdbcType="DECIMAL" property="r18" />
    <result column="R19" jdbcType="DECIMAL" property="r19" />
    <result column="R20" jdbcType="DECIMAL" property="r20" />
    <result column="R21" jdbcType="DECIMAL" property="r21" />
    <result column="R22" jdbcType="DECIMAL" property="r22" />
    <result column="R23" jdbcType="DECIMAL" property="r23" />
    <result column="R24" jdbcType="DECIMAL" property="r24" />
    <result column="R25" jdbcType="DECIMAL" property="r25" />
    <result column="R26" jdbcType="DECIMAL" property="r26" />
    <result column="R27" jdbcType="DECIMAL" property="r27" />
    <result column="R28" jdbcType="DECIMAL" property="r28" />
    <result column="R29" jdbcType="DECIMAL" property="r29" />
    <result column="R30" jdbcType="DECIMAL" property="r30" />
    <result column="R31" jdbcType="DECIMAL" property="r31" />
    <result column="R32" jdbcType="DECIMAL" property="r32" />
    <result column="R33" jdbcType="DECIMAL" property="r33" />
    <result column="R34" jdbcType="DECIMAL" property="r34" />
    <result column="R35" jdbcType="DECIMAL" property="r35" />
    <result column="R36" jdbcType="DECIMAL" property="r36" />
    <result column="R37" jdbcType="DECIMAL" property="r37" />
    <result column="R38" jdbcType="DECIMAL" property="r38" />
    <result column="R39" jdbcType="DECIMAL" property="r39" />
    <result column="R40" jdbcType="DECIMAL" property="r40" />
    <result column="R41" jdbcType="DECIMAL" property="r41" />
    <result column="R42" jdbcType="DECIMAL" property="r42" />
    <result column="R43" jdbcType="DECIMAL" property="r43" />
    <result column="R44" jdbcType="DECIMAL" property="r44" />
    <result column="R45" jdbcType="DECIMAL" property="r45" />
    <result column="R46" jdbcType="DECIMAL" property="r46" />
    <result column="R47" jdbcType="DECIMAL" property="r47" />
    <result column="R48" jdbcType="DECIMAL" property="r48" />
    <result column="R49" jdbcType="DECIMAL" property="r49" />
    <result column="R50" jdbcType="DECIMAL" property="r50" />
  </resultMap>
  <sql id="Example_Where_Clause">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <where>
      <foreach collection="oredCriteria" item="criteria" separator="or">
        <if test="criteria.valid">
          <trim prefix="(" prefixOverrides="and" suffix=")">
            <foreach collection="criteria.criteria" item="criterion">
              <choose>
                <when test="criterion.noValue">
                  and ${criterion.condition}
                </when>
                <when test="criterion.singleValue">
                  and ${criterion.condition} #{criterion.value}
                </when>
                <when test="criterion.betweenValue">
                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
                </when>
                <when test="criterion.listValue">
                  and ${criterion.condition}
                  <foreach close=")" collection="criterion.value" item="listItem" open="(" separator=",">
                    #{listItem}
                  </foreach>
                </when>
              </choose>
            </foreach>
          </trim>
        </if>
      </foreach>
    </where>
  </sql>
  <sql id="Update_By_Example_Where_Clause">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <where>
      <foreach collection="example.oredCriteria" item="criteria" separator="or">
        <if test="criteria.valid">
          <trim prefix="(" prefixOverrides="and" suffix=")">
            <foreach collection="criteria.criteria" item="criterion">
              <choose>
                <when test="criterion.noValue">
                  and ${criterion.condition}
                </when>
                <when test="criterion.singleValue">
                  and ${criterion.condition} #{criterion.value}
                </when>
                <when test="criterion.betweenValue">
                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
                </when>
                <when test="criterion.listValue">
                  and ${criterion.condition}
                  <foreach close=")" collection="criterion.value" item="listItem" open="(" separator=",">
                    #{listItem}
                  </foreach>
                </when>
              </choose>
            </foreach>
          </trim>
        </if>
      </foreach>
    </where>
  </sql>
  <sql id="Base_Column_List">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    ID, WINDTURBINEID, RECORDDATE, SPEED, QUALIFIED, UNQUALIFIED, R-50, R-49, R-48, R-47, 
    R-46, R-45, R-44, R-43, R-42, R-41, R-40, R-39, R-38, R-37, R-36, R-35, R-34, R-33, 
    R-32, R-31, R-30, R-29, R-28, R-27, R-26, R-25, R-24, R-23, R-22, R-21, R-20, R-19, 
    R-18, R-17, R-16, R-15, R-14, R-13, R-12, R-11, R-10, R-9, R-8, R-7, R-6, R-5, R-4, 
    R-3, R-2, R-1, R0, R1, R2, R3, R4, R5, R6, R7, R8, R9, R10, R11, R12, R13, R14, R15, 
    R16, R17, R18, R19, R20, R21, R22, R23, R24, R25, R26, R27, R28, R29, R30, R31, R32, 
    R33, R34, R35, R36, R37, R38, R39, R40, R41, R42, R43, R44, R45, R46, R47, R48, R49, 
    R50
  </sql>
  <select id="selectByExample" parameterType="com.gyee.frame.model.auto.WindturbinewindyawExample" resultMap="BaseResultMap">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select
    <if test="distinct">
      distinct
    </if>
    <include refid="Base_Column_List" />
    from WINDTURBINEWINDYAW
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null">
      order by ${orderByClause}
    </if>
  </select>
  <select id="selectByPrimaryKey" parameterType="java.lang.Short" resultMap="BaseResultMap">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select 
    <include refid="Base_Column_List" />
    from WINDTURBINEWINDYAW
    where ID = #{id,jdbcType=DECIMAL}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Short">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from WINDTURBINEWINDYAW
    where ID = #{id,jdbcType=DECIMAL}
  </delete>
  <delete id="deleteByExample" parameterType="com.gyee.frame.model.auto.WindturbinewindyawExample">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from WINDTURBINEWINDYAW
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
  </delete>
  <insert id="insert" parameterType="com.gyee.frame.model.auto.Windturbinewindyaw">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into WINDTURBINEWINDYAW (ID, WINDTURBINEID, RECORDDATE, 
      SPEED, QUALIFIED, UNQUALIFIED, 
      R-50, R-49, R-48, R-47, 
      R-46, R-45, R-44, R-43, 
      R-42, R-41, R-40, R-39, 
      R-38, R-37, R-36, R-35, 
      R-34, R-33, R-32, R-31, 
      R-30, R-29, R-28, R-27, 
      R-26, R-25, R-24, R-23, 
      R-22, R-21, R-20, R-19, 
      R-18, R-17, R-16, R-15, 
      R-14, R-13, R-12, R-11, 
      R-10, R-9, R-8, R-7, 
      R-6, R-5, R-4, R-3, 
      R-2, R-1, R0, R1, 
      R2, R3, R4, R5, 
      R6, R7, R8, R9, 
      R10, R11, R12, R13, 
      R14, R15, R16, R17, 
      R18, R19, R20, R21, 
      R22, R23, R24, R25, 
      R26, R27, R28, R29, 
      R30, R31, R32, R33, 
      R34, R35, R36, R37, 
      R38, R39, R40, R41, 
      R42, R43, R44, R45, 
      R46, R47, R48, R49, 
      R50)
    values (#{id,jdbcType=DECIMAL}, #{windturbineid,jdbcType=VARCHAR}, #{recorddate,jdbcType=TIMESTAMP}, 
      #{speed,jdbcType=DECIMAL}, #{qualified,jdbcType=DECIMAL}, #{unqualified,jdbcType=DECIMAL}, 
      #{r50,jdbcType=DECIMAL}, #{r49,jdbcType=DECIMAL}, #{r48,jdbcType=DECIMAL}, #{r47,jdbcType=DECIMAL}, 
      #{r46,jdbcType=DECIMAL}, #{r45,jdbcType=DECIMAL}, #{r44,jdbcType=DECIMAL}, #{r43,jdbcType=DECIMAL}, 
      #{r42,jdbcType=DECIMAL}, #{r41,jdbcType=DECIMAL}, #{r40,jdbcType=DECIMAL}, #{r39,jdbcType=DECIMAL}, 
      #{r38,jdbcType=DECIMAL}, #{r37,jdbcType=DECIMAL}, #{r36,jdbcType=DECIMAL}, #{r35,jdbcType=DECIMAL}, 
      #{r34,jdbcType=DECIMAL}, #{r33,jdbcType=DECIMAL}, #{r32,jdbcType=DECIMAL}, #{r31,jdbcType=DECIMAL}, 
      #{r30,jdbcType=DECIMAL}, #{r29,jdbcType=DECIMAL}, #{r28,jdbcType=DECIMAL}, #{r27,jdbcType=DECIMAL}, 
      #{r26,jdbcType=DECIMAL}, #{r25,jdbcType=DECIMAL}, #{r24,jdbcType=DECIMAL}, #{r23,jdbcType=DECIMAL}, 
      #{r22,jdbcType=DECIMAL}, #{r21,jdbcType=DECIMAL}, #{r20,jdbcType=DECIMAL}, #{r19,jdbcType=DECIMAL}, 
      #{r18,jdbcType=DECIMAL}, #{r17,jdbcType=DECIMAL}, #{r16,jdbcType=DECIMAL}, #{r15,jdbcType=DECIMAL}, 
      #{r14,jdbcType=DECIMAL}, #{r13,jdbcType=DECIMAL}, #{r12,jdbcType=DECIMAL}, #{r11,jdbcType=DECIMAL}, 
      #{r10,jdbcType=DECIMAL}, #{r9,jdbcType=DECIMAL}, #{r8,jdbcType=DECIMAL}, #{r7,jdbcType=DECIMAL}, 
      #{r6,jdbcType=DECIMAL}, #{r5,jdbcType=DECIMAL}, #{r4,jdbcType=DECIMAL}, #{r3,jdbcType=DECIMAL}, 
      #{r2,jdbcType=DECIMAL}, #{r1,jdbcType=DECIMAL}, #{r0,jdbcType=DECIMAL}, #{r1,jdbcType=DECIMAL}, 
      #{r2,jdbcType=DECIMAL}, #{r3,jdbcType=DECIMAL}, #{r4,jdbcType=DECIMAL}, #{r5,jdbcType=DECIMAL}, 
      #{r6,jdbcType=DECIMAL}, #{r7,jdbcType=DECIMAL}, #{r8,jdbcType=DECIMAL}, #{r9,jdbcType=DECIMAL}, 
      #{r10,jdbcType=DECIMAL}, #{r11,jdbcType=DECIMAL}, #{r12,jdbcType=DECIMAL}, #{r13,jdbcType=DECIMAL}, 
      #{r14,jdbcType=DECIMAL}, #{r15,jdbcType=DECIMAL}, #{r16,jdbcType=DECIMAL}, #{r17,jdbcType=DECIMAL}, 
      #{r18,jdbcType=DECIMAL}, #{r19,jdbcType=DECIMAL}, #{r20,jdbcType=DECIMAL}, #{r21,jdbcType=DECIMAL}, 
      #{r22,jdbcType=DECIMAL}, #{r23,jdbcType=DECIMAL}, #{r24,jdbcType=DECIMAL}, #{r25,jdbcType=DECIMAL}, 
      #{r26,jdbcType=DECIMAL}, #{r27,jdbcType=DECIMAL}, #{r28,jdbcType=DECIMAL}, #{r29,jdbcType=DECIMAL}, 
      #{r30,jdbcType=DECIMAL}, #{r31,jdbcType=DECIMAL}, #{r32,jdbcType=DECIMAL}, #{r33,jdbcType=DECIMAL}, 
      #{r34,jdbcType=DECIMAL}, #{r35,jdbcType=DECIMAL}, #{r36,jdbcType=DECIMAL}, #{r37,jdbcType=DECIMAL}, 
      #{r38,jdbcType=DECIMAL}, #{r39,jdbcType=DECIMAL}, #{r40,jdbcType=DECIMAL}, #{r41,jdbcType=DECIMAL}, 
      #{r42,jdbcType=DECIMAL}, #{r43,jdbcType=DECIMAL}, #{r44,jdbcType=DECIMAL}, #{r45,jdbcType=DECIMAL}, 
      #{r46,jdbcType=DECIMAL}, #{r47,jdbcType=DECIMAL}, #{r48,jdbcType=DECIMAL}, #{r49,jdbcType=DECIMAL}, 
      #{r50,jdbcType=DECIMAL})
  </insert>
  <insert id="insertSelective" parameterType="com.gyee.frame.model.auto.Windturbinewindyaw">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into WINDTURBINEWINDYAW
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        ID,
      </if>
      <if test="windturbineid != null">
        WINDTURBINEID,
      </if>
      <if test="recorddate != null">
        RECORDDATE,
      </if>
      <if test="speed != null">
        SPEED,
      </if>
      <if test="qualified != null">
        QUALIFIED,
      </if>
      <if test="unqualified != null">
        UNQUALIFIED,
      </if>
      <if test="r50 != null">
        R-50,
      </if>
      <if test="r49 != null">
        R-49,
      </if>
      <if test="r48 != null">
        R-48,
      </if>
      <if test="r47 != null">
        R-47,
      </if>
      <if test="r46 != null">
        R-46,
      </if>
      <if test="r45 != null">
        R-45,
      </if>
      <if test="r44 != null">
        R-44,
      </if>
      <if test="r43 != null">
        R-43,
      </if>
      <if test="r42 != null">
        R-42,
      </if>
      <if test="r41 != null">
        R-41,
      </if>
      <if test="r40 != null">
        R-40,
      </if>
      <if test="r39 != null">
        R-39,
      </if>
      <if test="r38 != null">
        R-38,
      </if>
      <if test="r37 != null">
        R-37,
      </if>
      <if test="r36 != null">
        R-36,
      </if>
      <if test="r35 != null">
        R-35,
      </if>
      <if test="r34 != null">
        R-34,
      </if>
      <if test="r33 != null">
        R-33,
      </if>
      <if test="r32 != null">
        R-32,
      </if>
      <if test="r31 != null">
        R-31,
      </if>
      <if test="r30 != null">
        R-30,
      </if>
      <if test="r29 != null">
        R-29,
      </if>
      <if test="r28 != null">
        R-28,
      </if>
      <if test="r27 != null">
        R-27,
      </if>
      <if test="r26 != null">
        R-26,
      </if>
      <if test="r25 != null">
        R-25,
      </if>
      <if test="r24 != null">
        R-24,
      </if>
      <if test="r23 != null">
        R-23,
      </if>
      <if test="r22 != null">
        R-22,
      </if>
      <if test="r21 != null">
        R-21,
      </if>
      <if test="r20 != null">
        R-20,
      </if>
      <if test="r19 != null">
        R-19,
      </if>
      <if test="r18 != null">
        R-18,
      </if>
      <if test="r17 != null">
        R-17,
      </if>
      <if test="r16 != null">
        R-16,
      </if>
      <if test="r15 != null">
        R-15,
      </if>
      <if test="r14 != null">
        R-14,
      </if>
      <if test="r13 != null">
        R-13,
      </if>
      <if test="r12 != null">
        R-12,
      </if>
      <if test="r11 != null">
        R-11,
      </if>
      <if test="r10 != null">
        R-10,
      </if>
      <if test="r9 != null">
        R-9,
      </if>
      <if test="r8 != null">
        R-8,
      </if>
      <if test="r7 != null">
        R-7,
      </if>
      <if test="r6 != null">
        R-6,
      </if>
      <if test="r5 != null">
        R-5,
      </if>
      <if test="r4 != null">
        R-4,
      </if>
      <if test="r3 != null">
        R-3,
      </if>
      <if test="r2 != null">
        R-2,
      </if>
      <if test="r1 != null">
        R-1,
      </if>
      <if test="r0 != null">
        R0,
      </if>
      <if test="r1 != null">
        R1,
      </if>
      <if test="r2 != null">
        R2,
      </if>
      <if test="r3 != null">
        R3,
      </if>
      <if test="r4 != null">
        R4,
      </if>
      <if test="r5 != null">
        R5,
      </if>
      <if test="r6 != null">
        R6,
      </if>
      <if test="r7 != null">
        R7,
      </if>
      <if test="r8 != null">
        R8,
      </if>
      <if test="r9 != null">
        R9,
      </if>
      <if test="r10 != null">
        R10,
      </if>
      <if test="r11 != null">
        R11,
      </if>
      <if test="r12 != null">
        R12,
      </if>
      <if test="r13 != null">
        R13,
      </if>
      <if test="r14 != null">
        R14,
      </if>
      <if test="r15 != null">
        R15,
      </if>
      <if test="r16 != null">
        R16,
      </if>
      <if test="r17 != null">
        R17,
      </if>
      <if test="r18 != null">
        R18,
      </if>
      <if test="r19 != null">
        R19,
      </if>
      <if test="r20 != null">
        R20,
      </if>
      <if test="r21 != null">
        R21,
      </if>
      <if test="r22 != null">
        R22,
      </if>
      <if test="r23 != null">
        R23,
      </if>
      <if test="r24 != null">
        R24,
      </if>
      <if test="r25 != null">
        R25,
      </if>
      <if test="r26 != null">
        R26,
      </if>
      <if test="r27 != null">
        R27,
      </if>
      <if test="r28 != null">
        R28,
      </if>
      <if test="r29 != null">
        R29,
      </if>
      <if test="r30 != null">
        R30,
      </if>
      <if test="r31 != null">
        R31,
      </if>
      <if test="r32 != null">
        R32,
      </if>
      <if test="r33 != null">
        R33,
      </if>
      <if test="r34 != null">
        R34,
      </if>
      <if test="r35 != null">
        R35,
      </if>
      <if test="r36 != null">
        R36,
      </if>
      <if test="r37 != null">
        R37,
      </if>
      <if test="r38 != null">
        R38,
      </if>
      <if test="r39 != null">
        R39,
      </if>
      <if test="r40 != null">
        R40,
      </if>
      <if test="r41 != null">
        R41,
      </if>
      <if test="r42 != null">
        R42,
      </if>
      <if test="r43 != null">
        R43,
      </if>
      <if test="r44 != null">
        R44,
      </if>
      <if test="r45 != null">
        R45,
      </if>
      <if test="r46 != null">
        R46,
      </if>
      <if test="r47 != null">
        R47,
      </if>
      <if test="r48 != null">
        R48,
      </if>
      <if test="r49 != null">
        R49,
      </if>
      <if test="r50 != null">
        R50,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=DECIMAL},
      </if>
      <if test="windturbineid != null">
        #{windturbineid,jdbcType=VARCHAR},
      </if>
      <if test="recorddate != null">
        #{recorddate,jdbcType=TIMESTAMP},
      </if>
      <if test="speed != null">
        #{speed,jdbcType=DECIMAL},
      </if>
      <if test="qualified != null">
        #{qualified,jdbcType=DECIMAL},
      </if>
      <if test="unqualified != null">
        #{unqualified,jdbcType=DECIMAL},
      </if>
      <if test="r50 != null">
        #{r50,jdbcType=DECIMAL},
      </if>
      <if test="r49 != null">
        #{r49,jdbcType=DECIMAL},
      </if>
      <if test="r48 != null">
        #{r48,jdbcType=DECIMAL},
      </if>
      <if test="r47 != null">
        #{r47,jdbcType=DECIMAL},
      </if>
      <if test="r46 != null">
        #{r46,jdbcType=DECIMAL},
      </if>
      <if test="r45 != null">
        #{r45,jdbcType=DECIMAL},
      </if>
      <if test="r44 != null">
        #{r44,jdbcType=DECIMAL},
      </if>
      <if test="r43 != null">
        #{r43,jdbcType=DECIMAL},
      </if>
      <if test="r42 != null">
        #{r42,jdbcType=DECIMAL},
      </if>
      <if test="r41 != null">
        #{r41,jdbcType=DECIMAL},
      </if>
      <if test="r40 != null">
        #{r40,jdbcType=DECIMAL},
      </if>
      <if test="r39 != null">
        #{r39,jdbcType=DECIMAL},
      </if>
      <if test="r38 != null">
        #{r38,jdbcType=DECIMAL},
      </if>
      <if test="r37 != null">
        #{r37,jdbcType=DECIMAL},
      </if>
      <if test="r36 != null">
        #{r36,jdbcType=DECIMAL},
      </if>
      <if test="r35 != null">
        #{r35,jdbcType=DECIMAL},
      </if>
      <if test="r34 != null">
        #{r34,jdbcType=DECIMAL},
      </if>
      <if test="r33 != null">
        #{r33,jdbcType=DECIMAL},
      </if>
      <if test="r32 != null">
        #{r32,jdbcType=DECIMAL},
      </if>
      <if test="r31 != null">
        #{r31,jdbcType=DECIMAL},
      </if>
      <if test="r30 != null">
        #{r30,jdbcType=DECIMAL},
      </if>
      <if test="r29 != null">
        #{r29,jdbcType=DECIMAL},
      </if>
      <if test="r28 != null">
        #{r28,jdbcType=DECIMAL},
      </if>
      <if test="r27 != null">
        #{r27,jdbcType=DECIMAL},
      </if>
      <if test="r26 != null">
        #{r26,jdbcType=DECIMAL},
      </if>
      <if test="r25 != null">
        #{r25,jdbcType=DECIMAL},
      </if>
      <if test="r24 != null">
        #{r24,jdbcType=DECIMAL},
      </if>
      <if test="r23 != null">
        #{r23,jdbcType=DECIMAL},
      </if>
      <if test="r22 != null">
        #{r22,jdbcType=DECIMAL},
      </if>
      <if test="r21 != null">
        #{r21,jdbcType=DECIMAL},
      </if>
      <if test="r20 != null">
        #{r20,jdbcType=DECIMAL},
      </if>
      <if test="r19 != null">
        #{r19,jdbcType=DECIMAL},
      </if>
      <if test="r18 != null">
        #{r18,jdbcType=DECIMAL},
      </if>
      <if test="r17 != null">
        #{r17,jdbcType=DECIMAL},
      </if>
      <if test="r16 != null">
        #{r16,jdbcType=DECIMAL},
      </if>
      <if test="r15 != null">
        #{r15,jdbcType=DECIMAL},
      </if>
      <if test="r14 != null">
        #{r14,jdbcType=DECIMAL},
      </if>
      <if test="r13 != null">
        #{r13,jdbcType=DECIMAL},
      </if>
      <if test="r12 != null">
        #{r12,jdbcType=DECIMAL},
      </if>
      <if test="r11 != null">
        #{r11,jdbcType=DECIMAL},
      </if>
      <if test="r10 != null">
        #{r10,jdbcType=DECIMAL},
      </if>
      <if test="r9 != null">
        #{r9,jdbcType=DECIMAL},
      </if>
      <if test="r8 != null">
        #{r8,jdbcType=DECIMAL},
      </if>
      <if test="r7 != null">
        #{r7,jdbcType=DECIMAL},
      </if>
      <if test="r6 != null">
        #{r6,jdbcType=DECIMAL},
      </if>
      <if test="r5 != null">
        #{r5,jdbcType=DECIMAL},
      </if>
      <if test="r4 != null">
        #{r4,jdbcType=DECIMAL},
      </if>
      <if test="r3 != null">
        #{r3,jdbcType=DECIMAL},
      </if>
      <if test="r2 != null">
        #{r2,jdbcType=DECIMAL},
      </if>
      <if test="r1 != null">
        #{r1,jdbcType=DECIMAL},
      </if>
      <if test="r0 != null">
        #{r0,jdbcType=DECIMAL},
      </if>
      <if test="r1 != null">
        #{r1,jdbcType=DECIMAL},
      </if>
      <if test="r2 != null">
        #{r2,jdbcType=DECIMAL},
      </if>
      <if test="r3 != null">
        #{r3,jdbcType=DECIMAL},
      </if>
      <if test="r4 != null">
        #{r4,jdbcType=DECIMAL},
      </if>
      <if test="r5 != null">
        #{r5,jdbcType=DECIMAL},
      </if>
      <if test="r6 != null">
        #{r6,jdbcType=DECIMAL},
      </if>
      <if test="r7 != null">
        #{r7,jdbcType=DECIMAL},
      </if>
      <if test="r8 != null">
        #{r8,jdbcType=DECIMAL},
      </if>
      <if test="r9 != null">
        #{r9,jdbcType=DECIMAL},
      </if>
      <if test="r10 != null">
        #{r10,jdbcType=DECIMAL},
      </if>
      <if test="r11 != null">
        #{r11,jdbcType=DECIMAL},
      </if>
      <if test="r12 != null">
        #{r12,jdbcType=DECIMAL},
      </if>
      <if test="r13 != null">
        #{r13,jdbcType=DECIMAL},
      </if>
      <if test="r14 != null">
        #{r14,jdbcType=DECIMAL},
      </if>
      <if test="r15 != null">
        #{r15,jdbcType=DECIMAL},
      </if>
      <if test="r16 != null">
        #{r16,jdbcType=DECIMAL},
      </if>
      <if test="r17 != null">
        #{r17,jdbcType=DECIMAL},
      </if>
      <if test="r18 != null">
        #{r18,jdbcType=DECIMAL},
      </if>
      <if test="r19 != null">
        #{r19,jdbcType=DECIMAL},
      </if>
      <if test="r20 != null">
        #{r20,jdbcType=DECIMAL},
      </if>
      <if test="r21 != null">
        #{r21,jdbcType=DECIMAL},
      </if>
      <if test="r22 != null">
        #{r22,jdbcType=DECIMAL},
      </if>
      <if test="r23 != null">
        #{r23,jdbcType=DECIMAL},
      </if>
      <if test="r24 != null">
        #{r24,jdbcType=DECIMAL},
      </if>
      <if test="r25 != null">
        #{r25,jdbcType=DECIMAL},
      </if>
      <if test="r26 != null">
        #{r26,jdbcType=DECIMAL},
      </if>
      <if test="r27 != null">
        #{r27,jdbcType=DECIMAL},
      </if>
      <if test="r28 != null">
        #{r28,jdbcType=DECIMAL},
      </if>
      <if test="r29 != null">
        #{r29,jdbcType=DECIMAL},
      </if>
      <if test="r30 != null">
        #{r30,jdbcType=DECIMAL},
      </if>
      <if test="r31 != null">
        #{r31,jdbcType=DECIMAL},
      </if>
      <if test="r32 != null">
        #{r32,jdbcType=DECIMAL},
      </if>
      <if test="r33 != null">
        #{r33,jdbcType=DECIMAL},
      </if>
      <if test="r34 != null">
        #{r34,jdbcType=DECIMAL},
      </if>
      <if test="r35 != null">
        #{r35,jdbcType=DECIMAL},
      </if>
      <if test="r36 != null">
        #{r36,jdbcType=DECIMAL},
      </if>
      <if test="r37 != null">
        #{r37,jdbcType=DECIMAL},
      </if>
      <if test="r38 != null">
        #{r38,jdbcType=DECIMAL},
      </if>
      <if test="r39 != null">
        #{r39,jdbcType=DECIMAL},
      </if>
      <if test="r40 != null">
        #{r40,jdbcType=DECIMAL},
      </if>
      <if test="r41 != null">
        #{r41,jdbcType=DECIMAL},
      </if>
      <if test="r42 != null">
        #{r42,jdbcType=DECIMAL},
      </if>
      <if test="r43 != null">
        #{r43,jdbcType=DECIMAL},
      </if>
      <if test="r44 != null">
        #{r44,jdbcType=DECIMAL},
      </if>
      <if test="r45 != null">
        #{r45,jdbcType=DECIMAL},
      </if>
      <if test="r46 != null">
        #{r46,jdbcType=DECIMAL},
      </if>
      <if test="r47 != null">
        #{r47,jdbcType=DECIMAL},
      </if>
      <if test="r48 != null">
        #{r48,jdbcType=DECIMAL},
      </if>
      <if test="r49 != null">
        #{r49,jdbcType=DECIMAL},
      </if>
      <if test="r50 != null">
        #{r50,jdbcType=DECIMAL},
      </if>
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.gyee.frame.model.auto.WindturbinewindyawExample" resultType="java.lang.Long">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select count(*) from WINDTURBINEWINDYAW
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
  </select>
  <update id="updateByExampleSelective" parameterType="map">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update WINDTURBINEWINDYAW
    <set>
      <if test="record.id != null">
        ID = #{record.id,jdbcType=DECIMAL},
      </if>
      <if test="record.windturbineid != null">
        WINDTURBINEID = #{record.windturbineid,jdbcType=VARCHAR},
      </if>
      <if test="record.recorddate != null">
        RECORDDATE = #{record.recorddate,jdbcType=TIMESTAMP},
      </if>
      <if test="record.speed != null">
        SPEED = #{record.speed,jdbcType=DECIMAL},
      </if>
      <if test="record.qualified != null">
        QUALIFIED = #{record.qualified,jdbcType=DECIMAL},
      </if>
      <if test="record.unqualified != null">
        UNQUALIFIED = #{record.unqualified,jdbcType=DECIMAL},
      </if>
      <if test="record.r50 != null">
        R-50 = #{record.r50,jdbcType=DECIMAL},
      </if>
      <if test="record.r49 != null">
        R-49 = #{record.r49,jdbcType=DECIMAL},
      </if>
      <if test="record.r48 != null">
        R-48 = #{record.r48,jdbcType=DECIMAL},
      </if>
      <if test="record.r47 != null">
        R-47 = #{record.r47,jdbcType=DECIMAL},
      </if>
      <if test="record.r46 != null">
        R-46 = #{record.r46,jdbcType=DECIMAL},
      </if>
      <if test="record.r45 != null">
        R-45 = #{record.r45,jdbcType=DECIMAL},
      </if>
      <if test="record.r44 != null">
        R-44 = #{record.r44,jdbcType=DECIMAL},
      </if>
      <if test="record.r43 != null">
        R-43 = #{record.r43,jdbcType=DECIMAL},
      </if>
      <if test="record.r42 != null">
        R-42 = #{record.r42,jdbcType=DECIMAL},
      </if>
      <if test="record.r41 != null">
        R-41 = #{record.r41,jdbcType=DECIMAL},
      </if>
      <if test="record.r40 != null">
        R-40 = #{record.r40,jdbcType=DECIMAL},
      </if>
      <if test="record.r39 != null">
        R-39 = #{record.r39,jdbcType=DECIMAL},
      </if>
      <if test="record.r38 != null">
        R-38 = #{record.r38,jdbcType=DECIMAL},
      </if>
      <if test="record.r37 != null">
        R-37 = #{record.r37,jdbcType=DECIMAL},
      </if>
      <if test="record.r36 != null">
        R-36 = #{record.r36,jdbcType=DECIMAL},
      </if>
      <if test="record.r35 != null">
        R-35 = #{record.r35,jdbcType=DECIMAL},
      </if>
      <if test="record.r34 != null">
        R-34 = #{record.r34,jdbcType=DECIMAL},
      </if>
      <if test="record.r33 != null">
        R-33 = #{record.r33,jdbcType=DECIMAL},
      </if>
      <if test="record.r32 != null">
        R-32 = #{record.r32,jdbcType=DECIMAL},
      </if>
      <if test="record.r31 != null">
        R-31 = #{record.r31,jdbcType=DECIMAL},
      </if>
      <if test="record.r30 != null">
        R-30 = #{record.r30,jdbcType=DECIMAL},
      </if>
      <if test="record.r29 != null">
        R-29 = #{record.r29,jdbcType=DECIMAL},
      </if>
      <if test="record.r28 != null">
        R-28 = #{record.r28,jdbcType=DECIMAL},
      </if>
      <if test="record.r27 != null">
        R-27 = #{record.r27,jdbcType=DECIMAL},
      </if>
      <if test="record.r26 != null">
        R-26 = #{record.r26,jdbcType=DECIMAL},
      </if>
      <if test="record.r25 != null">
        R-25 = #{record.r25,jdbcType=DECIMAL},
      </if>
      <if test="record.r24 != null">
        R-24 = #{record.r24,jdbcType=DECIMAL},
      </if>
      <if test="record.r23 != null">
        R-23 = #{record.r23,jdbcType=DECIMAL},
      </if>
      <if test="record.r22 != null">
        R-22 = #{record.r22,jdbcType=DECIMAL},
      </if>
      <if test="record.r21 != null">
        R-21 = #{record.r21,jdbcType=DECIMAL},
      </if>
      <if test="record.r20 != null">
        R-20 = #{record.r20,jdbcType=DECIMAL},
      </if>
      <if test="record.r19 != null">
        R-19 = #{record.r19,jdbcType=DECIMAL},
      </if>
      <if test="record.r18 != null">
        R-18 = #{record.r18,jdbcType=DECIMAL},
      </if>
      <if test="record.r17 != null">
        R-17 = #{record.r17,jdbcType=DECIMAL},
      </if>
      <if test="record.r16 != null">
        R-16 = #{record.r16,jdbcType=DECIMAL},
      </if>
      <if test="record.r15 != null">
        R-15 = #{record.r15,jdbcType=DECIMAL},
      </if>
      <if test="record.r14 != null">
        R-14 = #{record.r14,jdbcType=DECIMAL},
      </if>
      <if test="record.r13 != null">
        R-13 = #{record.r13,jdbcType=DECIMAL},
      </if>
      <if test="record.r12 != null">
        R-12 = #{record.r12,jdbcType=DECIMAL},
      </if>
      <if test="record.r11 != null">
        R-11 = #{record.r11,jdbcType=DECIMAL},
      </if>
      <if test="record.r10 != null">
        R-10 = #{record.r10,jdbcType=DECIMAL},
      </if>
      <if test="record.r9 != null">
        R-9 = #{record.r9,jdbcType=DECIMAL},
      </if>
      <if test="record.r8 != null">
        R-8 = #{record.r8,jdbcType=DECIMAL},
      </if>
      <if test="record.r7 != null">
        R-7 = #{record.r7,jdbcType=DECIMAL},
      </if>
      <if test="record.r6 != null">
        R-6 = #{record.r6,jdbcType=DECIMAL},
      </if>
      <if test="record.r5 != null">
        R-5 = #{record.r5,jdbcType=DECIMAL},
      </if>
      <if test="record.r4 != null">
        R-4 = #{record.r4,jdbcType=DECIMAL},
      </if>
      <if test="record.r3 != null">
        R-3 = #{record.r3,jdbcType=DECIMAL},
      </if>
      <if test="record.r2 != null">
        R-2 = #{record.r2,jdbcType=DECIMAL},
      </if>
      <if test="record.r1 != null">
        R-1 = #{record.r1,jdbcType=DECIMAL},
      </if>
      <if test="record.r0 != null">
        R0 = #{record.r0,jdbcType=DECIMAL},
      </if>
      <if test="record.r1 != null">
        R1 = #{record.r1,jdbcType=DECIMAL},
      </if>
      <if test="record.r2 != null">
        R2 = #{record.r2,jdbcType=DECIMAL},
      </if>
      <if test="record.r3 != null">
        R3 = #{record.r3,jdbcType=DECIMAL},
      </if>
      <if test="record.r4 != null">
        R4 = #{record.r4,jdbcType=DECIMAL},
      </if>
      <if test="record.r5 != null">
        R5 = #{record.r5,jdbcType=DECIMAL},
      </if>
      <if test="record.r6 != null">
        R6 = #{record.r6,jdbcType=DECIMAL},
      </if>
      <if test="record.r7 != null">
        R7 = #{record.r7,jdbcType=DECIMAL},
      </if>
      <if test="record.r8 != null">
        R8 = #{record.r8,jdbcType=DECIMAL},
      </if>
      <if test="record.r9 != null">
        R9 = #{record.r9,jdbcType=DECIMAL},
      </if>
      <if test="record.r10 != null">
        R10 = #{record.r10,jdbcType=DECIMAL},
      </if>
      <if test="record.r11 != null">
        R11 = #{record.r11,jdbcType=DECIMAL},
      </if>
      <if test="record.r12 != null">
        R12 = #{record.r12,jdbcType=DECIMAL},
      </if>
      <if test="record.r13 != null">
        R13 = #{record.r13,jdbcType=DECIMAL},
      </if>
      <if test="record.r14 != null">
        R14 = #{record.r14,jdbcType=DECIMAL},
      </if>
      <if test="record.r15 != null">
        R15 = #{record.r15,jdbcType=DECIMAL},
      </if>
      <if test="record.r16 != null">
        R16 = #{record.r16,jdbcType=DECIMAL},
      </if>
      <if test="record.r17 != null">
        R17 = #{record.r17,jdbcType=DECIMAL},
      </if>
      <if test="record.r18 != null">
        R18 = #{record.r18,jdbcType=DECIMAL},
      </if>
      <if test="record.r19 != null">
        R19 = #{record.r19,jdbcType=DECIMAL},
      </if>
      <if test="record.r20 != null">
        R20 = #{record.r20,jdbcType=DECIMAL},
      </if>
      <if test="record.r21 != null">
        R21 = #{record.r21,jdbcType=DECIMAL},
      </if>
      <if test="record.r22 != null">
        R22 = #{record.r22,jdbcType=DECIMAL},
      </if>
      <if test="record.r23 != null">
        R23 = #{record.r23,jdbcType=DECIMAL},
      </if>
      <if test="record.r24 != null">
        R24 = #{record.r24,jdbcType=DECIMAL},
      </if>
      <if test="record.r25 != null">
        R25 = #{record.r25,jdbcType=DECIMAL},
      </if>
      <if test="record.r26 != null">
        R26 = #{record.r26,jdbcType=DECIMAL},
      </if>
      <if test="record.r27 != null">
        R27 = #{record.r27,jdbcType=DECIMAL},
      </if>
      <if test="record.r28 != null">
        R28 = #{record.r28,jdbcType=DECIMAL},
      </if>
      <if test="record.r29 != null">
        R29 = #{record.r29,jdbcType=DECIMAL},
      </if>
      <if test="record.r30 != null">
        R30 = #{record.r30,jdbcType=DECIMAL},
      </if>
      <if test="record.r31 != null">
        R31 = #{record.r31,jdbcType=DECIMAL},
      </if>
      <if test="record.r32 != null">
        R32 = #{record.r32,jdbcType=DECIMAL},
      </if>
      <if test="record.r33 != null">
        R33 = #{record.r33,jdbcType=DECIMAL},
      </if>
      <if test="record.r34 != null">
        R34 = #{record.r34,jdbcType=DECIMAL},
      </if>
      <if test="record.r35 != null">
        R35 = #{record.r35,jdbcType=DECIMAL},
      </if>
      <if test="record.r36 != null">
        R36 = #{record.r36,jdbcType=DECIMAL},
      </if>
      <if test="record.r37 != null">
        R37 = #{record.r37,jdbcType=DECIMAL},
      </if>
      <if test="record.r38 != null">
        R38 = #{record.r38,jdbcType=DECIMAL},
      </if>
      <if test="record.r39 != null">
        R39 = #{record.r39,jdbcType=DECIMAL},
      </if>
      <if test="record.r40 != null">
        R40 = #{record.r40,jdbcType=DECIMAL},
      </if>
      <if test="record.r41 != null">
        R41 = #{record.r41,jdbcType=DECIMAL},
      </if>
      <if test="record.r42 != null">
        R42 = #{record.r42,jdbcType=DECIMAL},
      </if>
      <if test="record.r43 != null">
        R43 = #{record.r43,jdbcType=DECIMAL},
      </if>
      <if test="record.r44 != null">
        R44 = #{record.r44,jdbcType=DECIMAL},
      </if>
      <if test="record.r45 != null">
        R45 = #{record.r45,jdbcType=DECIMAL},
      </if>
      <if test="record.r46 != null">
        R46 = #{record.r46,jdbcType=DECIMAL},
      </if>
      <if test="record.r47 != null">
        R47 = #{record.r47,jdbcType=DECIMAL},
      </if>
      <if test="record.r48 != null">
        R48 = #{record.r48,jdbcType=DECIMAL},
      </if>
      <if test="record.r49 != null">
        R49 = #{record.r49,jdbcType=DECIMAL},
      </if>
      <if test="record.r50 != null">
        R50 = #{record.r50,jdbcType=DECIMAL},
      </if>
    </set>
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByExample" parameterType="map">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update WINDTURBINEWINDYAW
    set ID = #{record.id,jdbcType=DECIMAL},
      WINDTURBINEID = #{record.windturbineid,jdbcType=VARCHAR},
      RECORDDATE = #{record.recorddate,jdbcType=TIMESTAMP},
      SPEED = #{record.speed,jdbcType=DECIMAL},
      QUALIFIED = #{record.qualified,jdbcType=DECIMAL},
      UNQUALIFIED = #{record.unqualified,jdbcType=DECIMAL},
      R-50 = #{record.r50,jdbcType=DECIMAL},
      R-49 = #{record.r49,jdbcType=DECIMAL},
      R-48 = #{record.r48,jdbcType=DECIMAL},
      R-47 = #{record.r47,jdbcType=DECIMAL},
      R-46 = #{record.r46,jdbcType=DECIMAL},
      R-45 = #{record.r45,jdbcType=DECIMAL},
      R-44 = #{record.r44,jdbcType=DECIMAL},
      R-43 = #{record.r43,jdbcType=DECIMAL},
      R-42 = #{record.r42,jdbcType=DECIMAL},
      R-41 = #{record.r41,jdbcType=DECIMAL},
      R-40 = #{record.r40,jdbcType=DECIMAL},
      R-39 = #{record.r39,jdbcType=DECIMAL},
      R-38 = #{record.r38,jdbcType=DECIMAL},
      R-37 = #{record.r37,jdbcType=DECIMAL},
      R-36 = #{record.r36,jdbcType=DECIMAL},
      R-35 = #{record.r35,jdbcType=DECIMAL},
      R-34 = #{record.r34,jdbcType=DECIMAL},
      R-33 = #{record.r33,jdbcType=DECIMAL},
      R-32 = #{record.r32,jdbcType=DECIMAL},
      R-31 = #{record.r31,jdbcType=DECIMAL},
      R-30 = #{record.r30,jdbcType=DECIMAL},
      R-29 = #{record.r29,jdbcType=DECIMAL},
      R-28 = #{record.r28,jdbcType=DECIMAL},
      R-27 = #{record.r27,jdbcType=DECIMAL},
      R-26 = #{record.r26,jdbcType=DECIMAL},
      R-25 = #{record.r25,jdbcType=DECIMAL},
      R-24 = #{record.r24,jdbcType=DECIMAL},
      R-23 = #{record.r23,jdbcType=DECIMAL},
      R-22 = #{record.r22,jdbcType=DECIMAL},
      R-21 = #{record.r21,jdbcType=DECIMAL},
      R-20 = #{record.r20,jdbcType=DECIMAL},
      R-19 = #{record.r19,jdbcType=DECIMAL},
      R-18 = #{record.r18,jdbcType=DECIMAL},
      R-17 = #{record.r17,jdbcType=DECIMAL},
      R-16 = #{record.r16,jdbcType=DECIMAL},
      R-15 = #{record.r15,jdbcType=DECIMAL},
      R-14 = #{record.r14,jdbcType=DECIMAL},
      R-13 = #{record.r13,jdbcType=DECIMAL},
      R-12 = #{record.r12,jdbcType=DECIMAL},
      R-11 = #{record.r11,jdbcType=DECIMAL},
      R-10 = #{record.r10,jdbcType=DECIMAL},
      R-9 = #{record.r9,jdbcType=DECIMAL},
      R-8 = #{record.r8,jdbcType=DECIMAL},
      R-7 = #{record.r7,jdbcType=DECIMAL},
      R-6 = #{record.r6,jdbcType=DECIMAL},
      R-5 = #{record.r5,jdbcType=DECIMAL},
      R-4 = #{record.r4,jdbcType=DECIMAL},
      R-3 = #{record.r3,jdbcType=DECIMAL},
      R-2 = #{record.r2,jdbcType=DECIMAL},
      R-1 = #{record.r1,jdbcType=DECIMAL},
      R0 = #{record.r0,jdbcType=DECIMAL},
      R1 = #{record.r1,jdbcType=DECIMAL},
      R2 = #{record.r2,jdbcType=DECIMAL},
      R3 = #{record.r3,jdbcType=DECIMAL},
      R4 = #{record.r4,jdbcType=DECIMAL},
      R5 = #{record.r5,jdbcType=DECIMAL},
      R6 = #{record.r6,jdbcType=DECIMAL},
      R7 = #{record.r7,jdbcType=DECIMAL},
      R8 = #{record.r8,jdbcType=DECIMAL},
      R9 = #{record.r9,jdbcType=DECIMAL},
      R10 = #{record.r10,jdbcType=DECIMAL},
      R11 = #{record.r11,jdbcType=DECIMAL},
      R12 = #{record.r12,jdbcType=DECIMAL},
      R13 = #{record.r13,jdbcType=DECIMAL},
      R14 = #{record.r14,jdbcType=DECIMAL},
      R15 = #{record.r15,jdbcType=DECIMAL},
      R16 = #{record.r16,jdbcType=DECIMAL},
      R17 = #{record.r17,jdbcType=DECIMAL},
      R18 = #{record.r18,jdbcType=DECIMAL},
      R19 = #{record.r19,jdbcType=DECIMAL},
      R20 = #{record.r20,jdbcType=DECIMAL},
      R21 = #{record.r21,jdbcType=DECIMAL},
      R22 = #{record.r22,jdbcType=DECIMAL},
      R23 = #{record.r23,jdbcType=DECIMAL},
      R24 = #{record.r24,jdbcType=DECIMAL},
      R25 = #{record.r25,jdbcType=DECIMAL},
      R26 = #{record.r26,jdbcType=DECIMAL},
      R27 = #{record.r27,jdbcType=DECIMAL},
      R28 = #{record.r28,jdbcType=DECIMAL},
      R29 = #{record.r29,jdbcType=DECIMAL},
      R30 = #{record.r30,jdbcType=DECIMAL},
      R31 = #{record.r31,jdbcType=DECIMAL},
      R32 = #{record.r32,jdbcType=DECIMAL},
      R33 = #{record.r33,jdbcType=DECIMAL},
      R34 = #{record.r34,jdbcType=DECIMAL},
      R35 = #{record.r35,jdbcType=DECIMAL},
      R36 = #{record.r36,jdbcType=DECIMAL},
      R37 = #{record.r37,jdbcType=DECIMAL},
      R38 = #{record.r38,jdbcType=DECIMAL},
      R39 = #{record.r39,jdbcType=DECIMAL},
      R40 = #{record.r40,jdbcType=DECIMAL},
      R41 = #{record.r41,jdbcType=DECIMAL},
      R42 = #{record.r42,jdbcType=DECIMAL},
      R43 = #{record.r43,jdbcType=DECIMAL},
      R44 = #{record.r44,jdbcType=DECIMAL},
      R45 = #{record.r45,jdbcType=DECIMAL},
      R46 = #{record.r46,jdbcType=DECIMAL},
      R47 = #{record.r47,jdbcType=DECIMAL},
      R48 = #{record.r48,jdbcType=DECIMAL},
      R49 = #{record.r49,jdbcType=DECIMAL},
      R50 = #{record.r50,jdbcType=DECIMAL}
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByPrimaryKeySelective" parameterType="com.gyee.frame.model.auto.Windturbinewindyaw">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update WINDTURBINEWINDYAW
    <set>
      <if test="windturbineid != null">
        WINDTURBINEID = #{windturbineid,jdbcType=VARCHAR},
      </if>
      <if test="recorddate != null">
        RECORDDATE = #{recorddate,jdbcType=TIMESTAMP},
      </if>
      <if test="speed != null">
        SPEED = #{speed,jdbcType=DECIMAL},
      </if>
      <if test="qualified != null">
        QUALIFIED = #{qualified,jdbcType=DECIMAL},
      </if>
      <if test="unqualified != null">
        UNQUALIFIED = #{unqualified,jdbcType=DECIMAL},
      </if>
      <if test="r50 != null">
        R-50 = #{r50,jdbcType=DECIMAL},
      </if>
      <if test="r49 != null">
        R-49 = #{r49,jdbcType=DECIMAL},
      </if>
      <if test="r48 != null">
        R-48 = #{r48,jdbcType=DECIMAL},
      </if>
      <if test="r47 != null">
        R-47 = #{r47,jdbcType=DECIMAL},
      </if>
      <if test="r46 != null">
        R-46 = #{r46,jdbcType=DECIMAL},
      </if>
      <if test="r45 != null">
        R-45 = #{r45,jdbcType=DECIMAL},
      </if>
      <if test="r44 != null">
        R-44 = #{r44,jdbcType=DECIMAL},
      </if>
      <if test="r43 != null">
        R-43 = #{r43,jdbcType=DECIMAL},
      </if>
      <if test="r42 != null">
        R-42 = #{r42,jdbcType=DECIMAL},
      </if>
      <if test="r41 != null">
        R-41 = #{r41,jdbcType=DECIMAL},
      </if>
      <if test="r40 != null">
        R-40 = #{r40,jdbcType=DECIMAL},
      </if>
      <if test="r39 != null">
        R-39 = #{r39,jdbcType=DECIMAL},
      </if>
      <if test="r38 != null">
        R-38 = #{r38,jdbcType=DECIMAL},
      </if>
      <if test="r37 != null">
        R-37 = #{r37,jdbcType=DECIMAL},
      </if>
      <if test="r36 != null">
        R-36 = #{r36,jdbcType=DECIMAL},
      </if>
      <if test="r35 != null">
        R-35 = #{r35,jdbcType=DECIMAL},
      </if>
      <if test="r34 != null">
        R-34 = #{r34,jdbcType=DECIMAL},
      </if>
      <if test="r33 != null">
        R-33 = #{r33,jdbcType=DECIMAL},
      </if>
      <if test="r32 != null">
        R-32 = #{r32,jdbcType=DECIMAL},
      </if>
      <if test="r31 != null">
        R-31 = #{r31,jdbcType=DECIMAL},
      </if>
      <if test="r30 != null">
        R-30 = #{r30,jdbcType=DECIMAL},
      </if>
      <if test="r29 != null">
        R-29 = #{r29,jdbcType=DECIMAL},
      </if>
      <if test="r28 != null">
        R-28 = #{r28,jdbcType=DECIMAL},
      </if>
      <if test="r27 != null">
        R-27 = #{r27,jdbcType=DECIMAL},
      </if>
      <if test="r26 != null">
        R-26 = #{r26,jdbcType=DECIMAL},
      </if>
      <if test="r25 != null">
        R-25 = #{r25,jdbcType=DECIMAL},
      </if>
      <if test="r24 != null">
        R-24 = #{r24,jdbcType=DECIMAL},
      </if>
      <if test="r23 != null">
        R-23 = #{r23,jdbcType=DECIMAL},
      </if>
      <if test="r22 != null">
        R-22 = #{r22,jdbcType=DECIMAL},
      </if>
      <if test="r21 != null">
        R-21 = #{r21,jdbcType=DECIMAL},
      </if>
      <if test="r20 != null">
        R-20 = #{r20,jdbcType=DECIMAL},
      </if>
      <if test="r19 != null">
        R-19 = #{r19,jdbcType=DECIMAL},
      </if>
      <if test="r18 != null">
        R-18 = #{r18,jdbcType=DECIMAL},
      </if>
      <if test="r17 != null">
        R-17 = #{r17,jdbcType=DECIMAL},
      </if>
      <if test="r16 != null">
        R-16 = #{r16,jdbcType=DECIMAL},
      </if>
      <if test="r15 != null">
        R-15 = #{r15,jdbcType=DECIMAL},
      </if>
      <if test="r14 != null">
        R-14 = #{r14,jdbcType=DECIMAL},
      </if>
      <if test="r13 != null">
        R-13 = #{r13,jdbcType=DECIMAL},
      </if>
      <if test="r12 != null">
        R-12 = #{r12,jdbcType=DECIMAL},
      </if>
      <if test="r11 != null">
        R-11 = #{r11,jdbcType=DECIMAL},
      </if>
      <if test="r10 != null">
        R-10 = #{r10,jdbcType=DECIMAL},
      </if>
      <if test="r9 != null">
        R-9 = #{r9,jdbcType=DECIMAL},
      </if>
      <if test="r8 != null">
        R-8 = #{r8,jdbcType=DECIMAL},
      </if>
      <if test="r7 != null">
        R-7 = #{r7,jdbcType=DECIMAL},
      </if>
      <if test="r6 != null">
        R-6 = #{r6,jdbcType=DECIMAL},
      </if>
      <if test="r5 != null">
        R-5 = #{r5,jdbcType=DECIMAL},
      </if>
      <if test="r4 != null">
        R-4 = #{r4,jdbcType=DECIMAL},
      </if>
      <if test="r3 != null">
        R-3 = #{r3,jdbcType=DECIMAL},
      </if>
      <if test="r2 != null">
        R-2 = #{r2,jdbcType=DECIMAL},
      </if>
      <if test="r1 != null">
        R-1 = #{r1,jdbcType=DECIMAL},
      </if>
      <if test="r0 != null">
        R0 = #{r0,jdbcType=DECIMAL},
      </if>
      <if test="r1 != null">
        R1 = #{r1,jdbcType=DECIMAL},
      </if>
      <if test="r2 != null">
        R2 = #{r2,jdbcType=DECIMAL},
      </if>
      <if test="r3 != null">
        R3 = #{r3,jdbcType=DECIMAL},
      </if>
      <if test="r4 != null">
        R4 = #{r4,jdbcType=DECIMAL},
      </if>
      <if test="r5 != null">
        R5 = #{r5,jdbcType=DECIMAL},
      </if>
      <if test="r6 != null">
        R6 = #{r6,jdbcType=DECIMAL},
      </if>
      <if test="r7 != null">
        R7 = #{r7,jdbcType=DECIMAL},
      </if>
      <if test="r8 != null">
        R8 = #{r8,jdbcType=DECIMAL},
      </if>
      <if test="r9 != null">
        R9 = #{r9,jdbcType=DECIMAL},
      </if>
      <if test="r10 != null">
        R10 = #{r10,jdbcType=DECIMAL},
      </if>
      <if test="r11 != null">
        R11 = #{r11,jdbcType=DECIMAL},
      </if>
      <if test="r12 != null">
        R12 = #{r12,jdbcType=DECIMAL},
      </if>
      <if test="r13 != null">
        R13 = #{r13,jdbcType=DECIMAL},
      </if>
      <if test="r14 != null">
        R14 = #{r14,jdbcType=DECIMAL},
      </if>
      <if test="r15 != null">
        R15 = #{r15,jdbcType=DECIMAL},
      </if>
      <if test="r16 != null">
        R16 = #{r16,jdbcType=DECIMAL},
      </if>
      <if test="r17 != null">
        R17 = #{r17,jdbcType=DECIMAL},
      </if>
      <if test="r18 != null">
        R18 = #{r18,jdbcType=DECIMAL},
      </if>
      <if test="r19 != null">
        R19 = #{r19,jdbcType=DECIMAL},
      </if>
      <if test="r20 != null">
        R20 = #{r20,jdbcType=DECIMAL},
      </if>
      <if test="r21 != null">
        R21 = #{r21,jdbcType=DECIMAL},
      </if>
      <if test="r22 != null">
        R22 = #{r22,jdbcType=DECIMAL},
      </if>
      <if test="r23 != null">
        R23 = #{r23,jdbcType=DECIMAL},
      </if>
      <if test="r24 != null">
        R24 = #{r24,jdbcType=DECIMAL},
      </if>
      <if test="r25 != null">
        R25 = #{r25,jdbcType=DECIMAL},
      </if>
      <if test="r26 != null">
        R26 = #{r26,jdbcType=DECIMAL},
      </if>
      <if test="r27 != null">
        R27 = #{r27,jdbcType=DECIMAL},
      </if>
      <if test="r28 != null">
        R28 = #{r28,jdbcType=DECIMAL},
      </if>
      <if test="r29 != null">
        R29 = #{r29,jdbcType=DECIMAL},
      </if>
      <if test="r30 != null">
        R30 = #{r30,jdbcType=DECIMAL},
      </if>
      <if test="r31 != null">
        R31 = #{r31,jdbcType=DECIMAL},
      </if>
      <if test="r32 != null">
        R32 = #{r32,jdbcType=DECIMAL},
      </if>
      <if test="r33 != null">
        R33 = #{r33,jdbcType=DECIMAL},
      </if>
      <if test="r34 != null">
        R34 = #{r34,jdbcType=DECIMAL},
      </if>
      <if test="r35 != null">
        R35 = #{r35,jdbcType=DECIMAL},
      </if>
      <if test="r36 != null">
        R36 = #{r36,jdbcType=DECIMAL},
      </if>
      <if test="r37 != null">
        R37 = #{r37,jdbcType=DECIMAL},
      </if>
      <if test="r38 != null">
        R38 = #{r38,jdbcType=DECIMAL},
      </if>
      <if test="r39 != null">
        R39 = #{r39,jdbcType=DECIMAL},
      </if>
      <if test="r40 != null">
        R40 = #{r40,jdbcType=DECIMAL},
      </if>
      <if test="r41 != null">
        R41 = #{r41,jdbcType=DECIMAL},
      </if>
      <if test="r42 != null">
        R42 = #{r42,jdbcType=DECIMAL},
      </if>
      <if test="r43 != null">
        R43 = #{r43,jdbcType=DECIMAL},
      </if>
      <if test="r44 != null">
        R44 = #{r44,jdbcType=DECIMAL},
      </if>
      <if test="r45 != null">
        R45 = #{r45,jdbcType=DECIMAL},
      </if>
      <if test="r46 != null">
        R46 = #{r46,jdbcType=DECIMAL},
      </if>
      <if test="r47 != null">
        R47 = #{r47,jdbcType=DECIMAL},
      </if>
      <if test="r48 != null">
        R48 = #{r48,jdbcType=DECIMAL},
      </if>
      <if test="r49 != null">
        R49 = #{r49,jdbcType=DECIMAL},
      </if>
      <if test="r50 != null">
        R50 = #{r50,jdbcType=DECIMAL},
      </if>
    </set>
    where ID = #{id,jdbcType=DECIMAL}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.gyee.frame.model.auto.Windturbinewindyaw">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update WINDTURBINEWINDYAW
    set WINDTURBINEID = #{windturbineid,jdbcType=VARCHAR},
      RECORDDATE = #{recorddate,jdbcType=TIMESTAMP},
      SPEED = #{speed,jdbcType=DECIMAL},
      QUALIFIED = #{qualified,jdbcType=DECIMAL},
      UNQUALIFIED = #{unqualified,jdbcType=DECIMAL},
      R-50 = #{r50,jdbcType=DECIMAL},
      R-49 = #{r49,jdbcType=DECIMAL},
      R-48 = #{r48,jdbcType=DECIMAL},
      R-47 = #{r47,jdbcType=DECIMAL},
      R-46 = #{r46,jdbcType=DECIMAL},
      R-45 = #{r45,jdbcType=DECIMAL},
      R-44 = #{r44,jdbcType=DECIMAL},
      R-43 = #{r43,jdbcType=DECIMAL},
      R-42 = #{r42,jdbcType=DECIMAL},
      R-41 = #{r41,jdbcType=DECIMAL},
      R-40 = #{r40,jdbcType=DECIMAL},
      R-39 = #{r39,jdbcType=DECIMAL},
      R-38 = #{r38,jdbcType=DECIMAL},
      R-37 = #{r37,jdbcType=DECIMAL},
      R-36 = #{r36,jdbcType=DECIMAL},
      R-35 = #{r35,jdbcType=DECIMAL},
      R-34 = #{r34,jdbcType=DECIMAL},
      R-33 = #{r33,jdbcType=DECIMAL},
      R-32 = #{r32,jdbcType=DECIMAL},
      R-31 = #{r31,jdbcType=DECIMAL},
      R-30 = #{r30,jdbcType=DECIMAL},
      R-29 = #{r29,jdbcType=DECIMAL},
      R-28 = #{r28,jdbcType=DECIMAL},
      R-27 = #{r27,jdbcType=DECIMAL},
      R-26 = #{r26,jdbcType=DECIMAL},
      R-25 = #{r25,jdbcType=DECIMAL},
      R-24 = #{r24,jdbcType=DECIMAL},
      R-23 = #{r23,jdbcType=DECIMAL},
      R-22 = #{r22,jdbcType=DECIMAL},
      R-21 = #{r21,jdbcType=DECIMAL},
      R-20 = #{r20,jdbcType=DECIMAL},
      R-19 = #{r19,jdbcType=DECIMAL},
      R-18 = #{r18,jdbcType=DECIMAL},
      R-17 = #{r17,jdbcType=DECIMAL},
      R-16 = #{r16,jdbcType=DECIMAL},
      R-15 = #{r15,jdbcType=DECIMAL},
      R-14 = #{r14,jdbcType=DECIMAL},
      R-13 = #{r13,jdbcType=DECIMAL},
      R-12 = #{r12,jdbcType=DECIMAL},
      R-11 = #{r11,jdbcType=DECIMAL},
      R-10 = #{r10,jdbcType=DECIMAL},
      R-9 = #{r9,jdbcType=DECIMAL},
      R-8 = #{r8,jdbcType=DECIMAL},
      R-7 = #{r7,jdbcType=DECIMAL},
      R-6 = #{r6,jdbcType=DECIMAL},
      R-5 = #{r5,jdbcType=DECIMAL},
      R-4 = #{r4,jdbcType=DECIMAL},
      R-3 = #{r3,jdbcType=DECIMAL},
      R-2 = #{r2,jdbcType=DECIMAL},
      R-1 = #{r1,jdbcType=DECIMAL},
      R0 = #{r0,jdbcType=DECIMAL},
      R1 = #{r1,jdbcType=DECIMAL},
      R2 = #{r2,jdbcType=DECIMAL},
      R3 = #{r3,jdbcType=DECIMAL},
      R4 = #{r4,jdbcType=DECIMAL},
      R5 = #{r5,jdbcType=DECIMAL},
      R6 = #{r6,jdbcType=DECIMAL},
      R7 = #{r7,jdbcType=DECIMAL},
      R8 = #{r8,jdbcType=DECIMAL},
      R9 = #{r9,jdbcType=DECIMAL},
      R10 = #{r10,jdbcType=DECIMAL},
      R11 = #{r11,jdbcType=DECIMAL},
      R12 = #{r12,jdbcType=DECIMAL},
      R13 = #{r13,jdbcType=DECIMAL},
      R14 = #{r14,jdbcType=DECIMAL},
      R15 = #{r15,jdbcType=DECIMAL},
      R16 = #{r16,jdbcType=DECIMAL},
      R17 = #{r17,jdbcType=DECIMAL},
      R18 = #{r18,jdbcType=DECIMAL},
      R19 = #{r19,jdbcType=DECIMAL},
      R20 = #{r20,jdbcType=DECIMAL},
      R21 = #{r21,jdbcType=DECIMAL},
      R22 = #{r22,jdbcType=DECIMAL},
      R23 = #{r23,jdbcType=DECIMAL},
      R24 = #{r24,jdbcType=DECIMAL},
      R25 = #{r25,jdbcType=DECIMAL},
      R26 = #{r26,jdbcType=DECIMAL},
      R27 = #{r27,jdbcType=DECIMAL},
      R28 = #{r28,jdbcType=DECIMAL},
      R29 = #{r29,jdbcType=DECIMAL},
      R30 = #{r30,jdbcType=DECIMAL},
      R31 = #{r31,jdbcType=DECIMAL},
      R32 = #{r32,jdbcType=DECIMAL},
      R33 = #{r33,jdbcType=DECIMAL},
      R34 = #{r34,jdbcType=DECIMAL},
      R35 = #{r35,jdbcType=DECIMAL},
      R36 = #{r36,jdbcType=DECIMAL},
      R37 = #{r37,jdbcType=DECIMAL},
      R38 = #{r38,jdbcType=DECIMAL},
      R39 = #{r39,jdbcType=DECIMAL},
      R40 = #{r40,jdbcType=DECIMAL},
      R41 = #{r41,jdbcType=DECIMAL},
      R42 = #{r42,jdbcType=DECIMAL},
      R43 = #{r43,jdbcType=DECIMAL},
      R44 = #{r44,jdbcType=DECIMAL},
      R45 = #{r45,jdbcType=DECIMAL},
      R46 = #{r46,jdbcType=DECIMAL},
      R47 = #{r47,jdbcType=DECIMAL},
      R48 = #{r48,jdbcType=DECIMAL},
      R49 = #{r49,jdbcType=DECIMAL},
      R50 = #{r50,jdbcType=DECIMAL}
    where ID = #{id,jdbcType=DECIMAL}
  </update>

  <select id="getYawTotal"  resultType="com.gyee.frame.model.custom.YawVo">
    select windturbineid wtId,speed,sum(qualified) qualified,sum(unqualified) unqualified
    from windturbinewindyaw
    where windturbineid=#{wtId} and recorddate >= #{beginDate} and recorddate &lt; #{endDate}
    group by windturbineid,speed order by speed
  </select>

  <select id="getYawValuesTotal"  resultType="com.gyee.frame.model.custom.YawValuesVo">
        select windturbineid wtId,
        sum("R-50") R_50,
        sum("R-49") R_49,
        sum("R-48") R_48,
        sum("R-47") R_47,
        sum("R-46") R_46,
        sum("R-45") R_45,
        sum("R-44") R_44,
        sum("R-43") R_43,
        sum("R-42") R_42,
        sum("R-41") R_41,
        sum("R-40") R_40,
        sum("R-39") R_39,
        sum("R-38") R_38,
        sum("R-37") R_37,
        sum("R-36") R_36,
        sum("R-35") R_35,
        sum("R-34") R_34,
        sum("R-33") R_33,
        sum("R-32") R_32,
        sum("R-31") R_31,
        sum("R-30") R_30,
        sum("R-29") R_29,
        sum("R-28") R_28,
        sum("R-27") R_27,
        sum("R-26") R_26,
        sum("R-25") R_25,
        sum("R-24") R_24,
        sum("R-23") R_23,
        sum("R-22") R_22,
        sum("R-21") R_21,
        sum("R-20") R_20,
        sum("R-19") R_19,
        sum("R-18") R_18,
        sum("R-17") R_17,
        sum("R-16") R_16,
        sum("R-15") R_15,
        sum("R-14") R_14,
        sum("R-13") R_13,
        sum("R-12") R_12,
        sum("R-11") R_11,
        sum("R-10") R_10,
        sum("R-9") R_9,
        sum("R-8") R_8,
        sum("R-7") R_7,
        sum("R-6") R_6,
        sum("R-5") R_5,
        sum("R-4") R_4,
        sum("R-3") R_3,
        sum("R-2") R_2,
        sum("R-1") R_1,
        sum(R0) R0,
        sum(R1) R1,
        sum(R2) R2,
        sum(R3) R3,
        sum(R4) R4,
        sum(R5) R5,
        sum(R6) R6,
        sum(R7) R7,
        sum(R8) R8,
        sum(R9) R9,
        sum(R10) R10,
        sum(R11) R11,
        sum(R12) R12,
        sum(R13) R13,
        sum(R14) R14,
        sum(R15) R15,
        sum(R16) R16,
        sum(R17) R17,
        sum(R18) R18,
        sum(R19) R19,
        sum(R20) R20,
        sum(R21) R21,
        sum(R22) R22,
        sum(R23) R23,
        sum(R24) R24,
        sum(R25) R25,
        sum(R26) R26,
        sum(R27) R27,
        sum(R28) R28,
        sum(R29) R29,
        sum(R30) R30,
        sum(R31) R31,
        sum(R32) R32,
        sum(R33) R33,
        sum(R34) R34,
        sum(R35) R35,
        sum(R36) R36,
        sum(R37) R37,
        sum(R38) R38,
        sum(R39) R39,
        sum(R40) R40,
        sum(R41) R41,
        sum(R42) R42,
        sum(R43) R43,
        sum(R44) R44,
        sum(R45) R45,
        sum(R46) R46,
        sum(R47) R47,
        sum(R48) R48,
        sum(R49) R49,
        sum(R50) R50
    from windturbinewindyaw
    where windturbineid=#{wtId} and recorddate >= #{beginDate} and recorddate &lt; #{endDate} and  speed=#{value}
    group by windturbineid,speed
  </select>


  <select id="getYawTotalAll"  resultType="com.gyee.frame.model.custom.YawValuesVo">
        select windturbineid wtId,
        sum("R-50") R_50,
        sum("R-49") R_49,
        sum("R-48") R_48,
        sum("R-47") R_47,
        sum("R-46") R_46,
        sum("R-45") R_45,
        sum("R-44") R_44,
        sum("R-43") R_43,
        sum("R-42") R_42,
        sum("R-41") R_41,
        sum("R-40") R_40,
        sum("R-39") R_39,
        sum("R-38") R_38,
        sum("R-37") R_37,
        sum("R-36") R_36,
        sum("R-35") R_35,
        sum("R-34") R_34,
        sum("R-33") R_33,
        sum("R-32") R_32,
        sum("R-31") R_31,
        sum("R-30") R_30,
        sum("R-29") R_29,
        sum("R-28") R_28,
        sum("R-27") R_27,
        sum("R-26") R_26,
        sum("R-25") R_25,
        sum("R-24") R_24,
        sum("R-23") R_23,
        sum("R-22") R_22,
        sum("R-21") R_21,
        sum("R-20") R_20,
        sum("R-19") R_19,
        sum("R-18") R_18,
        sum("R-17") R_17,
        sum("R-16") R_16,
        sum("R-15") R_15,
        sum("R-14") R_14,
        sum("R-13") R_13,
        sum("R-12") R_12,
        sum("R-11") R_11,
        sum("R-10") R_10,
        sum("R-9") R_9,
        sum("R-8") R_8,
        sum("R-7") R_7,
        sum("R-6") R_6,
        sum("R-5") R_5,
        sum("R-4") R_4,
        sum("R-3") R_3,
        sum("R-2") R_2,
        sum("R-1") R_1,
        sum(R0) R0,
        sum(R1) R1,
        sum(R2) R2,
        sum(R3) R3,
        sum(R4) R4,
        sum(R5) R5,
        sum(R6) R6,
        sum(R7) R7,
        sum(R8) R8,
        sum(R9) R9,
        sum(R10) R10,
        sum(R11) R11,
        sum(R12) R12,
        sum(R13) R13,
        sum(R14) R14,
        sum(R15) R15,
        sum(R16) R16,
        sum(R17) R17,
        sum(R18) R18,
        sum(R19) R19,
        sum(R20) R20,
        sum(R21) R21,
        sum(R22) R22,
        sum(R23) R23,
        sum(R24) R24,
        sum(R25) R25,
        sum(R26) R26,
        sum(R27) R27,
        sum(R28) R28,
        sum(R29) R29,
        sum(R30) R30,
        sum(R31) R31,
        sum(R32) R32,
        sum(R33) R33,
        sum(R34) R34,
        sum(R35) R35,
        sum(R36) R36,
        sum(R37) R37,
        sum(R38) R38,
        sum(R39) R39,
        sum(R40) R40,
        sum(R41) R41,
        sum(R42) R42,
        sum(R43) R43,
        sum(R44) R44,
        sum(R45) R45,
        sum(R46) R46,
        sum(R47) R47,
        sum(R48) R48,
        sum(R49) R49,
        sum(R50) R50
    from windturbinewindyaw
    where windturbineid=#{wtId} and recorddate >= #{beginDate} and recorddate &lt; #{endDate}
    group by windturbineid
  </select>
</mapper>