<?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.WindturbineSqlMapper">
  <resultMap id="BaseResultMap" type="com.gyee.frame.model.auto.WindturbineSql">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <id column="ID" jdbcType="NUMERIC" property="id" />
    <result column="WTNUM" jdbcType="NUMERIC" property="wtnum" />
    <result column="OWNERWF" jdbcType="NUMERIC" property="ownerwf" />
    <result column="OWNERPROJECT" jdbcType="NUMERIC" property="ownerproject" />
    <result column="OWNERLINE" jdbcType="NUMERIC" property="ownerline" />
    <result column="ORDERNUM" jdbcType="NUMERIC" property="ordernum" />
    <result column="WTWFNUM" jdbcType="NVARCHAR" property="wtwfnum" />
    <result column="WTGRIDNUM" jdbcType="NVARCHAR" property="wtgridnum" />
    <result column="VENDOR" jdbcType="NVARCHAR" property="vendor" />
    <result column="MODEL" jdbcType="NVARCHAR" property="model" />
    <result column="RATEDPOWER" jdbcType="DECIMAL" property="ratedpower" />
    <result column="RATEDWINSPE" jdbcType="DECIMAL" property="ratedwinspe" />
    <result column="RATEDVOLTAGE" jdbcType="DECIMAL" property="ratedvoltage" />
    <result column="RATEDREV" jdbcType="DECIMAL" property="ratedrev" />
    <result column="CUTINWINSPE" jdbcType="DECIMAL" property="cutinwinspe" />
    <result column="CUTOUTWINSPE" jdbcType="DECIMAL" property="cutoutwinspe" />
    <result column="MAXWINSPE" jdbcType="DECIMAL" property="maxwinspe" />
    <result column="LOWERTEMP" jdbcType="DECIMAL" property="lowertemp" />
    <result column="HIGHTEMP" jdbcType="DECIMAL" property="hightemp" />
    <result column="LOWERREV" jdbcType="DECIMAL" property="lowerrev" />
    <result column="HIGHREV" jdbcType="DECIMAL" property="highrev" />
    <result column="ROTERDIAMETER" jdbcType="DECIMAL" property="roterdiameter" />
    <result column="HUBHEIGHT" jdbcType="DECIMAL" property="hubheight" />
    <result column="RELEASEDATE" jdbcType="TIMESTAMP" property="releasedate" />
    <result column="INSTALLDATE" jdbcType="TIMESTAMP" property="installdate" />
    <result column="TESTDATE" jdbcType="TIMESTAMP" property="testdate" />
    <result column="OPDATE" jdbcType="TIMESTAMP" property="opdate" />
    <result column="LOCATION" jdbcType="NVARCHAR" property="location" />
    <result column="WFLOCATION" jdbcType="NVARCHAR" property="wflocation" />
    <result column="WTID" jdbcType="NVARCHAR" property="wtid" />
  </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, WTNUM, OWNERWF, OWNERPROJECT, OWNERLINE, ORDERNUM, WTWFNUM, WTGRIDNUM, VENDOR, 
    MODEL, RATEDPOWER, RATEDWINSPE, RATEDVOLTAGE, RATEDREV, CUTINWINSPE, CUTOUTWINSPE, 
    MAXWINSPE, LOWERTEMP, HIGHTEMP, LOWERREV, HIGHREV, ROTERDIAMETER, HUBHEIGHT, RELEASEDATE, 
    INSTALLDATE, TESTDATE, OPDATE, LOCATION, WFLOCATION, WTID
  </sql>
  <select id="selectByExample" parameterType="com.gyee.frame.model.auto.WindturbineSqlExample" 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 WINDTURBINE
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null">
      order by ${orderByClause}
    </if>
  </select>
  <select id="selectByPrimaryKey" parameterType="java.math.BigDecimal" resultMap="BaseResultMap">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select 
    <include refid="Base_Column_List" />
    from WINDTURBINE
    where ID = #{id,jdbcType=NUMERIC}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.math.BigDecimal">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from WINDTURBINE
    where ID = #{id,jdbcType=NUMERIC}
  </delete>
  <delete id="deleteByExample" parameterType="com.gyee.frame.model.auto.WindturbineSqlExample">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from WINDTURBINE
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
  </delete>
  <insert id="insert" parameterType="com.gyee.frame.model.auto.WindturbineSql">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into WINDTURBINE (ID, WTNUM, OWNERWF, 
      OWNERPROJECT, OWNERLINE, ORDERNUM, 
      WTWFNUM, WTGRIDNUM, VENDOR, 
      MODEL, RATEDPOWER, RATEDWINSPE, 
      RATEDVOLTAGE, RATEDREV, CUTINWINSPE, 
      CUTOUTWINSPE, MAXWINSPE, LOWERTEMP, 
      HIGHTEMP, LOWERREV, HIGHREV, 
      ROTERDIAMETER, HUBHEIGHT, RELEASEDATE, 
      INSTALLDATE, TESTDATE, OPDATE, 
      LOCATION, WFLOCATION, WTID
      )
    values (#{id,jdbcType=NUMERIC}, #{wtnum,jdbcType=NUMERIC}, #{ownerwf,jdbcType=NUMERIC}, 
      #{ownerproject,jdbcType=NUMERIC}, #{ownerline,jdbcType=NUMERIC}, #{ordernum,jdbcType=NUMERIC}, 
      #{wtwfnum,jdbcType=NVARCHAR}, #{wtgridnum,jdbcType=NVARCHAR}, #{vendor,jdbcType=NVARCHAR}, 
      #{model,jdbcType=NVARCHAR}, #{ratedpower,jdbcType=DECIMAL}, #{ratedwinspe,jdbcType=DECIMAL}, 
      #{ratedvoltage,jdbcType=DECIMAL}, #{ratedrev,jdbcType=DECIMAL}, #{cutinwinspe,jdbcType=DECIMAL}, 
      #{cutoutwinspe,jdbcType=DECIMAL}, #{maxwinspe,jdbcType=DECIMAL}, #{lowertemp,jdbcType=DECIMAL}, 
      #{hightemp,jdbcType=DECIMAL}, #{lowerrev,jdbcType=DECIMAL}, #{highrev,jdbcType=DECIMAL}, 
      #{roterdiameter,jdbcType=DECIMAL}, #{hubheight,jdbcType=DECIMAL}, #{releasedate,jdbcType=TIMESTAMP}, 
      #{installdate,jdbcType=TIMESTAMP}, #{testdate,jdbcType=TIMESTAMP}, #{opdate,jdbcType=TIMESTAMP}, 
      #{location,jdbcType=NVARCHAR}, #{wflocation,jdbcType=NVARCHAR}, #{wtid,jdbcType=NVARCHAR}
      )
  </insert>
  <insert id="insertSelective" parameterType="com.gyee.frame.model.auto.WindturbineSql">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into WINDTURBINE
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        ID,
      </if>
      <if test="wtnum != null">
        WTNUM,
      </if>
      <if test="ownerwf != null">
        OWNERWF,
      </if>
      <if test="ownerproject != null">
        OWNERPROJECT,
      </if>
      <if test="ownerline != null">
        OWNERLINE,
      </if>
      <if test="ordernum != null">
        ORDERNUM,
      </if>
      <if test="wtwfnum != null">
        WTWFNUM,
      </if>
      <if test="wtgridnum != null">
        WTGRIDNUM,
      </if>
      <if test="vendor != null">
        VENDOR,
      </if>
      <if test="model != null">
        MODEL,
      </if>
      <if test="ratedpower != null">
        RATEDPOWER,
      </if>
      <if test="ratedwinspe != null">
        RATEDWINSPE,
      </if>
      <if test="ratedvoltage != null">
        RATEDVOLTAGE,
      </if>
      <if test="ratedrev != null">
        RATEDREV,
      </if>
      <if test="cutinwinspe != null">
        CUTINWINSPE,
      </if>
      <if test="cutoutwinspe != null">
        CUTOUTWINSPE,
      </if>
      <if test="maxwinspe != null">
        MAXWINSPE,
      </if>
      <if test="lowertemp != null">
        LOWERTEMP,
      </if>
      <if test="hightemp != null">
        HIGHTEMP,
      </if>
      <if test="lowerrev != null">
        LOWERREV,
      </if>
      <if test="highrev != null">
        HIGHREV,
      </if>
      <if test="roterdiameter != null">
        ROTERDIAMETER,
      </if>
      <if test="hubheight != null">
        HUBHEIGHT,
      </if>
      <if test="releasedate != null">
        RELEASEDATE,
      </if>
      <if test="installdate != null">
        INSTALLDATE,
      </if>
      <if test="testdate != null">
        TESTDATE,
      </if>
      <if test="opdate != null">
        OPDATE,
      </if>
      <if test="location != null">
        LOCATION,
      </if>
      <if test="wflocation != null">
        WFLOCATION,
      </if>
      <if test="wtid != null">
        WTID,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=NUMERIC},
      </if>
      <if test="wtnum != null">
        #{wtnum,jdbcType=NUMERIC},
      </if>
      <if test="ownerwf != null">
        #{ownerwf,jdbcType=NUMERIC},
      </if>
      <if test="ownerproject != null">
        #{ownerproject,jdbcType=NUMERIC},
      </if>
      <if test="ownerline != null">
        #{ownerline,jdbcType=NUMERIC},
      </if>
      <if test="ordernum != null">
        #{ordernum,jdbcType=NUMERIC},
      </if>
      <if test="wtwfnum != null">
        #{wtwfnum,jdbcType=NVARCHAR},
      </if>
      <if test="wtgridnum != null">
        #{wtgridnum,jdbcType=NVARCHAR},
      </if>
      <if test="vendor != null">
        #{vendor,jdbcType=NVARCHAR},
      </if>
      <if test="model != null">
        #{model,jdbcType=NVARCHAR},
      </if>
      <if test="ratedpower != null">
        #{ratedpower,jdbcType=DECIMAL},
      </if>
      <if test="ratedwinspe != null">
        #{ratedwinspe,jdbcType=DECIMAL},
      </if>
      <if test="ratedvoltage != null">
        #{ratedvoltage,jdbcType=DECIMAL},
      </if>
      <if test="ratedrev != null">
        #{ratedrev,jdbcType=DECIMAL},
      </if>
      <if test="cutinwinspe != null">
        #{cutinwinspe,jdbcType=DECIMAL},
      </if>
      <if test="cutoutwinspe != null">
        #{cutoutwinspe,jdbcType=DECIMAL},
      </if>
      <if test="maxwinspe != null">
        #{maxwinspe,jdbcType=DECIMAL},
      </if>
      <if test="lowertemp != null">
        #{lowertemp,jdbcType=DECIMAL},
      </if>
      <if test="hightemp != null">
        #{hightemp,jdbcType=DECIMAL},
      </if>
      <if test="lowerrev != null">
        #{lowerrev,jdbcType=DECIMAL},
      </if>
      <if test="highrev != null">
        #{highrev,jdbcType=DECIMAL},
      </if>
      <if test="roterdiameter != null">
        #{roterdiameter,jdbcType=DECIMAL},
      </if>
      <if test="hubheight != null">
        #{hubheight,jdbcType=DECIMAL},
      </if>
      <if test="releasedate != null">
        #{releasedate,jdbcType=TIMESTAMP},
      </if>
      <if test="installdate != null">
        #{installdate,jdbcType=TIMESTAMP},
      </if>
      <if test="testdate != null">
        #{testdate,jdbcType=TIMESTAMP},
      </if>
      <if test="opdate != null">
        #{opdate,jdbcType=TIMESTAMP},
      </if>
      <if test="location != null">
        #{location,jdbcType=NVARCHAR},
      </if>
      <if test="wflocation != null">
        #{wflocation,jdbcType=NVARCHAR},
      </if>
      <if test="wtid != null">
        #{wtid,jdbcType=NVARCHAR},
      </if>
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.gyee.frame.model.auto.WindturbineSqlExample" resultType="java.lang.Long">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select count(*) from WINDTURBINE
    <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 WINDTURBINE
    <set>
      <if test="record.id != null">
        ID = #{record.id,jdbcType=NUMERIC},
      </if>
      <if test="record.wtnum != null">
        WTNUM = #{record.wtnum,jdbcType=NUMERIC},
      </if>
      <if test="record.ownerwf != null">
        OWNERWF = #{record.ownerwf,jdbcType=NUMERIC},
      </if>
      <if test="record.ownerproject != null">
        OWNERPROJECT = #{record.ownerproject,jdbcType=NUMERIC},
      </if>
      <if test="record.ownerline != null">
        OWNERLINE = #{record.ownerline,jdbcType=NUMERIC},
      </if>
      <if test="record.ordernum != null">
        ORDERNUM = #{record.ordernum,jdbcType=NUMERIC},
      </if>
      <if test="record.wtwfnum != null">
        WTWFNUM = #{record.wtwfnum,jdbcType=NVARCHAR},
      </if>
      <if test="record.wtgridnum != null">
        WTGRIDNUM = #{record.wtgridnum,jdbcType=NVARCHAR},
      </if>
      <if test="record.vendor != null">
        VENDOR = #{record.vendor,jdbcType=NVARCHAR},
      </if>
      <if test="record.model != null">
        MODEL = #{record.model,jdbcType=NVARCHAR},
      </if>
      <if test="record.ratedpower != null">
        RATEDPOWER = #{record.ratedpower,jdbcType=DECIMAL},
      </if>
      <if test="record.ratedwinspe != null">
        RATEDWINSPE = #{record.ratedwinspe,jdbcType=DECIMAL},
      </if>
      <if test="record.ratedvoltage != null">
        RATEDVOLTAGE = #{record.ratedvoltage,jdbcType=DECIMAL},
      </if>
      <if test="record.ratedrev != null">
        RATEDREV = #{record.ratedrev,jdbcType=DECIMAL},
      </if>
      <if test="record.cutinwinspe != null">
        CUTINWINSPE = #{record.cutinwinspe,jdbcType=DECIMAL},
      </if>
      <if test="record.cutoutwinspe != null">
        CUTOUTWINSPE = #{record.cutoutwinspe,jdbcType=DECIMAL},
      </if>
      <if test="record.maxwinspe != null">
        MAXWINSPE = #{record.maxwinspe,jdbcType=DECIMAL},
      </if>
      <if test="record.lowertemp != null">
        LOWERTEMP = #{record.lowertemp,jdbcType=DECIMAL},
      </if>
      <if test="record.hightemp != null">
        HIGHTEMP = #{record.hightemp,jdbcType=DECIMAL},
      </if>
      <if test="record.lowerrev != null">
        LOWERREV = #{record.lowerrev,jdbcType=DECIMAL},
      </if>
      <if test="record.highrev != null">
        HIGHREV = #{record.highrev,jdbcType=DECIMAL},
      </if>
      <if test="record.roterdiameter != null">
        ROTERDIAMETER = #{record.roterdiameter,jdbcType=DECIMAL},
      </if>
      <if test="record.hubheight != null">
        HUBHEIGHT = #{record.hubheight,jdbcType=DECIMAL},
      </if>
      <if test="record.releasedate != null">
        RELEASEDATE = #{record.releasedate,jdbcType=TIMESTAMP},
      </if>
      <if test="record.installdate != null">
        INSTALLDATE = #{record.installdate,jdbcType=TIMESTAMP},
      </if>
      <if test="record.testdate != null">
        TESTDATE = #{record.testdate,jdbcType=TIMESTAMP},
      </if>
      <if test="record.opdate != null">
        OPDATE = #{record.opdate,jdbcType=TIMESTAMP},
      </if>
      <if test="record.location != null">
        LOCATION = #{record.location,jdbcType=NVARCHAR},
      </if>
      <if test="record.wflocation != null">
        WFLOCATION = #{record.wflocation,jdbcType=NVARCHAR},
      </if>
      <if test="record.wtid != null">
        WTID = #{record.wtid,jdbcType=NVARCHAR},
      </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 WINDTURBINE
    set ID = #{record.id,jdbcType=NUMERIC},
      WTNUM = #{record.wtnum,jdbcType=NUMERIC},
      OWNERWF = #{record.ownerwf,jdbcType=NUMERIC},
      OWNERPROJECT = #{record.ownerproject,jdbcType=NUMERIC},
      OWNERLINE = #{record.ownerline,jdbcType=NUMERIC},
      ORDERNUM = #{record.ordernum,jdbcType=NUMERIC},
      WTWFNUM = #{record.wtwfnum,jdbcType=NVARCHAR},
      WTGRIDNUM = #{record.wtgridnum,jdbcType=NVARCHAR},
      VENDOR = #{record.vendor,jdbcType=NVARCHAR},
      MODEL = #{record.model,jdbcType=NVARCHAR},
      RATEDPOWER = #{record.ratedpower,jdbcType=DECIMAL},
      RATEDWINSPE = #{record.ratedwinspe,jdbcType=DECIMAL},
      RATEDVOLTAGE = #{record.ratedvoltage,jdbcType=DECIMAL},
      RATEDREV = #{record.ratedrev,jdbcType=DECIMAL},
      CUTINWINSPE = #{record.cutinwinspe,jdbcType=DECIMAL},
      CUTOUTWINSPE = #{record.cutoutwinspe,jdbcType=DECIMAL},
      MAXWINSPE = #{record.maxwinspe,jdbcType=DECIMAL},
      LOWERTEMP = #{record.lowertemp,jdbcType=DECIMAL},
      HIGHTEMP = #{record.hightemp,jdbcType=DECIMAL},
      LOWERREV = #{record.lowerrev,jdbcType=DECIMAL},
      HIGHREV = #{record.highrev,jdbcType=DECIMAL},
      ROTERDIAMETER = #{record.roterdiameter,jdbcType=DECIMAL},
      HUBHEIGHT = #{record.hubheight,jdbcType=DECIMAL},
      RELEASEDATE = #{record.releasedate,jdbcType=TIMESTAMP},
      INSTALLDATE = #{record.installdate,jdbcType=TIMESTAMP},
      TESTDATE = #{record.testdate,jdbcType=TIMESTAMP},
      OPDATE = #{record.opdate,jdbcType=TIMESTAMP},
      LOCATION = #{record.location,jdbcType=NVARCHAR},
      WFLOCATION = #{record.wflocation,jdbcType=NVARCHAR},
      WTID = #{record.wtid,jdbcType=NVARCHAR}
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByPrimaryKeySelective" parameterType="com.gyee.frame.model.auto.WindturbineSql">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update WINDTURBINE
    <set>
      <if test="wtnum != null">
        WTNUM = #{wtnum,jdbcType=NUMERIC},
      </if>
      <if test="ownerwf != null">
        OWNERWF = #{ownerwf,jdbcType=NUMERIC},
      </if>
      <if test="ownerproject != null">
        OWNERPROJECT = #{ownerproject,jdbcType=NUMERIC},
      </if>
      <if test="ownerline != null">
        OWNERLINE = #{ownerline,jdbcType=NUMERIC},
      </if>
      <if test="ordernum != null">
        ORDERNUM = #{ordernum,jdbcType=NUMERIC},
      </if>
      <if test="wtwfnum != null">
        WTWFNUM = #{wtwfnum,jdbcType=NVARCHAR},
      </if>
      <if test="wtgridnum != null">
        WTGRIDNUM = #{wtgridnum,jdbcType=NVARCHAR},
      </if>
      <if test="vendor != null">
        VENDOR = #{vendor,jdbcType=NVARCHAR},
      </if>
      <if test="model != null">
        MODEL = #{model,jdbcType=NVARCHAR},
      </if>
      <if test="ratedpower != null">
        RATEDPOWER = #{ratedpower,jdbcType=DECIMAL},
      </if>
      <if test="ratedwinspe != null">
        RATEDWINSPE = #{ratedwinspe,jdbcType=DECIMAL},
      </if>
      <if test="ratedvoltage != null">
        RATEDVOLTAGE = #{ratedvoltage,jdbcType=DECIMAL},
      </if>
      <if test="ratedrev != null">
        RATEDREV = #{ratedrev,jdbcType=DECIMAL},
      </if>
      <if test="cutinwinspe != null">
        CUTINWINSPE = #{cutinwinspe,jdbcType=DECIMAL},
      </if>
      <if test="cutoutwinspe != null">
        CUTOUTWINSPE = #{cutoutwinspe,jdbcType=DECIMAL},
      </if>
      <if test="maxwinspe != null">
        MAXWINSPE = #{maxwinspe,jdbcType=DECIMAL},
      </if>
      <if test="lowertemp != null">
        LOWERTEMP = #{lowertemp,jdbcType=DECIMAL},
      </if>
      <if test="hightemp != null">
        HIGHTEMP = #{hightemp,jdbcType=DECIMAL},
      </if>
      <if test="lowerrev != null">
        LOWERREV = #{lowerrev,jdbcType=DECIMAL},
      </if>
      <if test="highrev != null">
        HIGHREV = #{highrev,jdbcType=DECIMAL},
      </if>
      <if test="roterdiameter != null">
        ROTERDIAMETER = #{roterdiameter,jdbcType=DECIMAL},
      </if>
      <if test="hubheight != null">
        HUBHEIGHT = #{hubheight,jdbcType=DECIMAL},
      </if>
      <if test="releasedate != null">
        RELEASEDATE = #{releasedate,jdbcType=TIMESTAMP},
      </if>
      <if test="installdate != null">
        INSTALLDATE = #{installdate,jdbcType=TIMESTAMP},
      </if>
      <if test="testdate != null">
        TESTDATE = #{testdate,jdbcType=TIMESTAMP},
      </if>
      <if test="opdate != null">
        OPDATE = #{opdate,jdbcType=TIMESTAMP},
      </if>
      <if test="location != null">
        LOCATION = #{location,jdbcType=NVARCHAR},
      </if>
      <if test="wflocation != null">
        WFLOCATION = #{wflocation,jdbcType=NVARCHAR},
      </if>
      <if test="wtid != null">
        WTID = #{wtid,jdbcType=NVARCHAR},
      </if>
    </set>
    where ID = #{id,jdbcType=NUMERIC}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.gyee.frame.model.auto.WindturbineSql">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update WINDTURBINE
    set WTNUM = #{wtnum,jdbcType=NUMERIC},
      OWNERWF = #{ownerwf,jdbcType=NUMERIC},
      OWNERPROJECT = #{ownerproject,jdbcType=NUMERIC},
      OWNERLINE = #{ownerline,jdbcType=NUMERIC},
      ORDERNUM = #{ordernum,jdbcType=NUMERIC},
      WTWFNUM = #{wtwfnum,jdbcType=NVARCHAR},
      WTGRIDNUM = #{wtgridnum,jdbcType=NVARCHAR},
      VENDOR = #{vendor,jdbcType=NVARCHAR},
      MODEL = #{model,jdbcType=NVARCHAR},
      RATEDPOWER = #{ratedpower,jdbcType=DECIMAL},
      RATEDWINSPE = #{ratedwinspe,jdbcType=DECIMAL},
      RATEDVOLTAGE = #{ratedvoltage,jdbcType=DECIMAL},
      RATEDREV = #{ratedrev,jdbcType=DECIMAL},
      CUTINWINSPE = #{cutinwinspe,jdbcType=DECIMAL},
      CUTOUTWINSPE = #{cutoutwinspe,jdbcType=DECIMAL},
      MAXWINSPE = #{maxwinspe,jdbcType=DECIMAL},
      LOWERTEMP = #{lowertemp,jdbcType=DECIMAL},
      HIGHTEMP = #{hightemp,jdbcType=DECIMAL},
      LOWERREV = #{lowerrev,jdbcType=DECIMAL},
      HIGHREV = #{highrev,jdbcType=DECIMAL},
      ROTERDIAMETER = #{roterdiameter,jdbcType=DECIMAL},
      HUBHEIGHT = #{hubheight,jdbcType=DECIMAL},
      RELEASEDATE = #{releasedate,jdbcType=TIMESTAMP},
      INSTALLDATE = #{installdate,jdbcType=TIMESTAMP},
      TESTDATE = #{testdate,jdbcType=TIMESTAMP},
      OPDATE = #{opdate,jdbcType=TIMESTAMP},
      LOCATION = #{location,jdbcType=NVARCHAR},
      WFLOCATION = #{wflocation,jdbcType=NVARCHAR},
      WTID = #{wtid,jdbcType=NVARCHAR}
    where ID = #{id,jdbcType=NUMERIC}
  </update>
</mapper>