<?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.WtReportMainMapper">
  <resultMap id="BaseResultMap" type="com.gyee.frame.model.auto.WtReportMain">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <id column="ID" jdbcType="VARCHAR" property="id" />
    <result column="RECODEDATE" jdbcType="DATE" property="recodedate" />
    <result column="WTID" jdbcType="VARCHAR" property="wtid" />
    <result column="MAINREASON" jdbcType="VARCHAR" property="mainreason" />
    <result column="MAINDATE" jdbcType="DATE" property="maindate" />
    <result column="SPEED" jdbcType="DECIMAL" property="speed" />
    <result column="MAINMETHOD" jdbcType="VARCHAR" property="mainmethod" />
    <result column="APPROACH" jdbcType="VARCHAR" property="approach" />
    <result column="TOOLS" jdbcType="VARCHAR" property="tools" />
    <result column="MAINHOUR" jdbcType="DECIMAL" property="mainhour" />
    <result column="GZTOP1" jdbcType="DECIMAL" property="gztop1" />
    <result column="GZTOP1NAME" jdbcType="VARCHAR" property="gztop1name" />
    <result column="GZTOP2" jdbcType="DECIMAL" property="gztop2" />
    <result column="GZTOP2NAME" jdbcType="VARCHAR" property="gztop2name" />
    <result column="GZTOP3" jdbcType="DECIMAL" property="gztop3" />
    <result column="GZTOP3NAME" jdbcType="VARCHAR" property="gztop3name" />
    <result column="YJTOP1" jdbcType="DECIMAL" property="yjtop1" />
    <result column="YJTOP1NAME" jdbcType="VARCHAR" property="yjtop1name" />
    <result column="YJTOP2" jdbcType="DECIMAL" property="yjtop2" />
    <result column="YJTOP2NAME" jdbcType="VARCHAR" property="yjtop2name" />
    <result column="YJTOP3" jdbcType="DECIMAL" property="yjtop3" />
    <result column="YJTOP3NAME" jdbcType="VARCHAR" property="yjtop3name" />
    <result column="TOP1TYPE" jdbcType="VARCHAR" property="top1type" />
    <result column="TOP2TYPE" jdbcType="VARCHAR" property="top2type" />
    <result column="TOP3TYPE" jdbcType="VARCHAR" property="top3type" />
  </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, RECODEDATE, WTID, MAINREASON, MAINDATE, SPEED, MAINMETHOD, APPROACH, TOOLS, MAINHOUR, 
    GZTOP1, GZTOP1NAME, GZTOP2, GZTOP2NAME, GZTOP3, GZTOP3NAME, YJTOP1, YJTOP1NAME, YJTOP2, 
    YJTOP2NAME, YJTOP3, YJTOP3NAME, TOP1TYPE, TOP2TYPE, TOP3TYPE
  </sql>
  <select id="selectByExample" parameterType="com.gyee.frame.model.auto.WtReportMainExample" 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 wtreportmain
    <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.String" resultMap="BaseResultMap">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select 
    <include refid="Base_Column_List" />
    from wtreportmain
    where ID = #{id,jdbcType=VARCHAR}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.String">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from wtreportmain
    where ID = #{id,jdbcType=VARCHAR}
  </delete>
  <delete id="deleteByExample" parameterType="com.gyee.frame.model.auto.WtReportMainExample">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from wtreportmain
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
  </delete>
  <insert id="insert" parameterType="com.gyee.frame.model.auto.WtReportMain">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into wtreportmain (ID, RECODEDATE, WTID, 
      MAINREASON, MAINDATE, SPEED, 
      MAINMETHOD, APPROACH, TOOLS, 
      MAINHOUR, GZTOP1, GZTOP1NAME, 
      GZTOP2, GZTOP2NAME, GZTOP3, 
      GZTOP3NAME, YJTOP1, YJTOP1NAME, 
      YJTOP2, YJTOP2NAME, YJTOP3, 
      YJTOP3NAME, TOP1TYPE, TOP2TYPE, 
      TOP3TYPE)
    values (#{id,jdbcType=VARCHAR}, #{recodedate,jdbcType=DATE}, #{wtid,jdbcType=VARCHAR}, 
      #{mainreason,jdbcType=VARCHAR}, #{maindate,jdbcType=DATE}, #{speed,jdbcType=DECIMAL}, 
      #{mainmethod,jdbcType=VARCHAR}, #{approach,jdbcType=VARCHAR}, #{tools,jdbcType=VARCHAR}, 
      #{mainhour,jdbcType=DECIMAL}, #{gztop1,jdbcType=DECIMAL}, #{gztop1name,jdbcType=VARCHAR}, 
      #{gztop2,jdbcType=DECIMAL}, #{gztop2name,jdbcType=VARCHAR}, #{gztop3,jdbcType=DECIMAL}, 
      #{gztop3name,jdbcType=VARCHAR}, #{yjtop1,jdbcType=DECIMAL}, #{yjtop1name,jdbcType=VARCHAR}, 
      #{yjtop2,jdbcType=DECIMAL}, #{yjtop2name,jdbcType=VARCHAR}, #{yjtop3,jdbcType=DECIMAL}, 
      #{yjtop3name,jdbcType=VARCHAR}, #{top1type,jdbcType=VARCHAR}, #{top2type,jdbcType=VARCHAR}, 
      #{top3type,jdbcType=VARCHAR})
  </insert>
  <insert id="insertSelective" parameterType="com.gyee.frame.model.auto.WtReportMain">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into wtreportmain
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        ID,
      </if>
      <if test="recodedate != null">
        RECODEDATE,
      </if>
      <if test="wtid != null">
        WTID,
      </if>
      <if test="mainreason != null">
        MAINREASON,
      </if>
      <if test="maindate != null">
        MAINDATE,
      </if>
      <if test="speed != null">
        SPEED,
      </if>
      <if test="mainmethod != null">
        MAINMETHOD,
      </if>
      <if test="approach != null">
        APPROACH,
      </if>
      <if test="tools != null">
        TOOLS,
      </if>
      <if test="mainhour != null">
        MAINHOUR,
      </if>
      <if test="gztop1 != null">
        GZTOP1,
      </if>
      <if test="gztop1name != null">
        GZTOP1NAME,
      </if>
      <if test="gztop2 != null">
        GZTOP2,
      </if>
      <if test="gztop2name != null">
        GZTOP2NAME,
      </if>
      <if test="gztop3 != null">
        GZTOP3,
      </if>
      <if test="gztop3name != null">
        GZTOP3NAME,
      </if>
      <if test="yjtop1 != null">
        YJTOP1,
      </if>
      <if test="yjtop1name != null">
        YJTOP1NAME,
      </if>
      <if test="yjtop2 != null">
        YJTOP2,
      </if>
      <if test="yjtop2name != null">
        YJTOP2NAME,
      </if>
      <if test="yjtop3 != null">
        YJTOP3,
      </if>
      <if test="yjtop3name != null">
        YJTOP3NAME,
      </if>
      <if test="top1type != null">
        TOP1TYPE,
      </if>
      <if test="top2type != null">
        TOP2TYPE,
      </if>
      <if test="top3type != null">
        TOP3TYPE,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=VARCHAR},
      </if>
      <if test="recodedate != null">
        #{recodedate,jdbcType=DATE},
      </if>
      <if test="wtid != null">
        #{wtid,jdbcType=VARCHAR},
      </if>
      <if test="mainreason != null">
        #{mainreason,jdbcType=VARCHAR},
      </if>
      <if test="maindate != null">
        #{maindate,jdbcType=DATE},
      </if>
      <if test="speed != null">
        #{speed,jdbcType=DECIMAL},
      </if>
      <if test="mainmethod != null">
        #{mainmethod,jdbcType=VARCHAR},
      </if>
      <if test="approach != null">
        #{approach,jdbcType=VARCHAR},
      </if>
      <if test="tools != null">
        #{tools,jdbcType=VARCHAR},
      </if>
      <if test="mainhour != null">
        #{mainhour,jdbcType=DECIMAL},
      </if>
      <if test="gztop1 != null">
        #{gztop1,jdbcType=DECIMAL},
      </if>
      <if test="gztop1name != null">
        #{gztop1name,jdbcType=VARCHAR},
      </if>
      <if test="gztop2 != null">
        #{gztop2,jdbcType=DECIMAL},
      </if>
      <if test="gztop2name != null">
        #{gztop2name,jdbcType=VARCHAR},
      </if>
      <if test="gztop3 != null">
        #{gztop3,jdbcType=DECIMAL},
      </if>
      <if test="gztop3name != null">
        #{gztop3name,jdbcType=VARCHAR},
      </if>
      <if test="yjtop1 != null">
        #{yjtop1,jdbcType=DECIMAL},
      </if>
      <if test="yjtop1name != null">
        #{yjtop1name,jdbcType=VARCHAR},
      </if>
      <if test="yjtop2 != null">
        #{yjtop2,jdbcType=DECIMAL},
      </if>
      <if test="yjtop2name != null">
        #{yjtop2name,jdbcType=VARCHAR},
      </if>
      <if test="yjtop3 != null">
        #{yjtop3,jdbcType=DECIMAL},
      </if>
      <if test="yjtop3name != null">
        #{yjtop3name,jdbcType=VARCHAR},
      </if>
      <if test="top1type != null">
        #{top1type,jdbcType=VARCHAR},
      </if>
      <if test="top2type != null">
        #{top2type,jdbcType=VARCHAR},
      </if>
      <if test="top3type != null">
        #{top3type,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.gyee.frame.model.auto.WtReportMainExample" resultType="java.lang.Long">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select count(*) from wtreportmain
    <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 wtreportmain
    <set>
      <if test="record.id != null">
        ID = #{record.id,jdbcType=VARCHAR},
      </if>
      <if test="record.recodedate != null">
        RECODEDATE = #{record.recodedate,jdbcType=DATE},
      </if>
      <if test="record.wtid != null">
        WTID = #{record.wtid,jdbcType=VARCHAR},
      </if>
      <if test="record.mainreason != null">
        MAINREASON = #{record.mainreason,jdbcType=VARCHAR},
      </if>
      <if test="record.maindate != null">
        MAINDATE = #{record.maindate,jdbcType=DATE},
      </if>
      <if test="record.speed != null">
        SPEED = #{record.speed,jdbcType=DECIMAL},
      </if>
      <if test="record.mainmethod != null">
        MAINMETHOD = #{record.mainmethod,jdbcType=VARCHAR},
      </if>
      <if test="record.approach != null">
        APPROACH = #{record.approach,jdbcType=VARCHAR},
      </if>
      <if test="record.tools != null">
        TOOLS = #{record.tools,jdbcType=VARCHAR},
      </if>
      <if test="record.mainhour != null">
        MAINHOUR = #{record.mainhour,jdbcType=DECIMAL},
      </if>
      <if test="record.gztop1 != null">
        GZTOP1 = #{record.gztop1,jdbcType=DECIMAL},
      </if>
      <if test="record.gztop1name != null">
        GZTOP1NAME = #{record.gztop1name,jdbcType=VARCHAR},
      </if>
      <if test="record.gztop2 != null">
        GZTOP2 = #{record.gztop2,jdbcType=DECIMAL},
      </if>
      <if test="record.gztop2name != null">
        GZTOP2NAME = #{record.gztop2name,jdbcType=VARCHAR},
      </if>
      <if test="record.gztop3 != null">
        GZTOP3 = #{record.gztop3,jdbcType=DECIMAL},
      </if>
      <if test="record.gztop3name != null">
        GZTOP3NAME = #{record.gztop3name,jdbcType=VARCHAR},
      </if>
      <if test="record.yjtop1 != null">
        YJTOP1 = #{record.yjtop1,jdbcType=DECIMAL},
      </if>
      <if test="record.yjtop1name != null">
        YJTOP1NAME = #{record.yjtop1name,jdbcType=VARCHAR},
      </if>
      <if test="record.yjtop2 != null">
        YJTOP2 = #{record.yjtop2,jdbcType=DECIMAL},
      </if>
      <if test="record.yjtop2name != null">
        YJTOP2NAME = #{record.yjtop2name,jdbcType=VARCHAR},
      </if>
      <if test="record.yjtop3 != null">
        YJTOP3 = #{record.yjtop3,jdbcType=DECIMAL},
      </if>
      <if test="record.yjtop3name != null">
        YJTOP3NAME = #{record.yjtop3name,jdbcType=VARCHAR},
      </if>
      <if test="record.top1type != null">
        TOP1TYPE = #{record.top1type,jdbcType=VARCHAR},
      </if>
      <if test="record.top2type != null">
        TOP2TYPE = #{record.top2type,jdbcType=VARCHAR},
      </if>
      <if test="record.top3type != null">
        TOP3TYPE = #{record.top3type,jdbcType=VARCHAR},
      </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 wtreportmain
    set ID = #{record.id,jdbcType=VARCHAR},
      RECODEDATE = #{record.recodedate,jdbcType=DATE},
      WTID = #{record.wtid,jdbcType=VARCHAR},
      MAINREASON = #{record.mainreason,jdbcType=VARCHAR},
      MAINDATE = #{record.maindate,jdbcType=DATE},
      SPEED = #{record.speed,jdbcType=DECIMAL},
      MAINMETHOD = #{record.mainmethod,jdbcType=VARCHAR},
      APPROACH = #{record.approach,jdbcType=VARCHAR},
      TOOLS = #{record.tools,jdbcType=VARCHAR},
      MAINHOUR = #{record.mainhour,jdbcType=DECIMAL},
      GZTOP1 = #{record.gztop1,jdbcType=DECIMAL},
      GZTOP1NAME = #{record.gztop1name,jdbcType=VARCHAR},
      GZTOP2 = #{record.gztop2,jdbcType=DECIMAL},
      GZTOP2NAME = #{record.gztop2name,jdbcType=VARCHAR},
      GZTOP3 = #{record.gztop3,jdbcType=DECIMAL},
      GZTOP3NAME = #{record.gztop3name,jdbcType=VARCHAR},
      YJTOP1 = #{record.yjtop1,jdbcType=DECIMAL},
      YJTOP1NAME = #{record.yjtop1name,jdbcType=VARCHAR},
      YJTOP2 = #{record.yjtop2,jdbcType=DECIMAL},
      YJTOP2NAME = #{record.yjtop2name,jdbcType=VARCHAR},
      YJTOP3 = #{record.yjtop3,jdbcType=DECIMAL},
      YJTOP3NAME = #{record.yjtop3name,jdbcType=VARCHAR},
      TOP1TYPE = #{record.top1type,jdbcType=VARCHAR},
      TOP2TYPE = #{record.top2type,jdbcType=VARCHAR},
      TOP3TYPE = #{record.top3type,jdbcType=VARCHAR}
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByPrimaryKeySelective" parameterType="com.gyee.frame.model.auto.WtReportMain">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update wtreportmain
    <set>
      <if test="recodedate != null">
        RECODEDATE = #{recodedate,jdbcType=DATE},
      </if>
      <if test="wtid != null">
        WTID = #{wtid,jdbcType=VARCHAR},
      </if>
      <if test="mainreason != null">
        MAINREASON = #{mainreason,jdbcType=VARCHAR},
      </if>
      <if test="maindate != null">
        MAINDATE = #{maindate,jdbcType=DATE},
      </if>
      <if test="speed != null">
        SPEED = #{speed,jdbcType=DECIMAL},
      </if>
      <if test="mainmethod != null">
        MAINMETHOD = #{mainmethod,jdbcType=VARCHAR},
      </if>
      <if test="approach != null">
        APPROACH = #{approach,jdbcType=VARCHAR},
      </if>
      <if test="tools != null">
        TOOLS = #{tools,jdbcType=VARCHAR},
      </if>
      <if test="mainhour != null">
        MAINHOUR = #{mainhour,jdbcType=DECIMAL},
      </if>
      <if test="gztop1 != null">
        GZTOP1 = #{gztop1,jdbcType=DECIMAL},
      </if>
      <if test="gztop1name != null">
        GZTOP1NAME = #{gztop1name,jdbcType=VARCHAR},
      </if>
      <if test="gztop2 != null">
        GZTOP2 = #{gztop2,jdbcType=DECIMAL},
      </if>
      <if test="gztop2name != null">
        GZTOP2NAME = #{gztop2name,jdbcType=VARCHAR},
      </if>
      <if test="gztop3 != null">
        GZTOP3 = #{gztop3,jdbcType=DECIMAL},
      </if>
      <if test="gztop3name != null">
        GZTOP3NAME = #{gztop3name,jdbcType=VARCHAR},
      </if>
      <if test="yjtop1 != null">
        YJTOP1 = #{yjtop1,jdbcType=DECIMAL},
      </if>
      <if test="yjtop1name != null">
        YJTOP1NAME = #{yjtop1name,jdbcType=VARCHAR},
      </if>
      <if test="yjtop2 != null">
        YJTOP2 = #{yjtop2,jdbcType=DECIMAL},
      </if>
      <if test="yjtop2name != null">
        YJTOP2NAME = #{yjtop2name,jdbcType=VARCHAR},
      </if>
      <if test="yjtop3 != null">
        YJTOP3 = #{yjtop3,jdbcType=DECIMAL},
      </if>
      <if test="yjtop3name != null">
        YJTOP3NAME = #{yjtop3name,jdbcType=VARCHAR},
      </if>
      <if test="top1type != null">
        TOP1TYPE = #{top1type,jdbcType=VARCHAR},
      </if>
      <if test="top2type != null">
        TOP2TYPE = #{top2type,jdbcType=VARCHAR},
      </if>
      <if test="top3type != null">
        TOP3TYPE = #{top3type,jdbcType=VARCHAR},
      </if>
    </set>
    where ID = #{id,jdbcType=VARCHAR}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.gyee.frame.model.auto.WtReportMain">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update wtreportmain
    set RECODEDATE = #{recodedate,jdbcType=DATE},
      WTID = #{wtid,jdbcType=VARCHAR},
      MAINREASON = #{mainreason,jdbcType=VARCHAR},
      MAINDATE = #{maindate,jdbcType=DATE},
      SPEED = #{speed,jdbcType=DECIMAL},
      MAINMETHOD = #{mainmethod,jdbcType=VARCHAR},
      APPROACH = #{approach,jdbcType=VARCHAR},
      TOOLS = #{tools,jdbcType=VARCHAR},
      MAINHOUR = #{mainhour,jdbcType=DECIMAL},
      GZTOP1 = #{gztop1,jdbcType=DECIMAL},
      GZTOP1NAME = #{gztop1name,jdbcType=VARCHAR},
      GZTOP2 = #{gztop2,jdbcType=DECIMAL},
      GZTOP2NAME = #{gztop2name,jdbcType=VARCHAR},
      GZTOP3 = #{gztop3,jdbcType=DECIMAL},
      GZTOP3NAME = #{gztop3name,jdbcType=VARCHAR},
      YJTOP1 = #{yjtop1,jdbcType=DECIMAL},
      YJTOP1NAME = #{yjtop1name,jdbcType=VARCHAR},
      YJTOP2 = #{yjtop2,jdbcType=DECIMAL},
      YJTOP2NAME = #{yjtop2name,jdbcType=VARCHAR},
      YJTOP3 = #{yjtop3,jdbcType=DECIMAL},
      YJTOP3NAME = #{yjtop3name,jdbcType=VARCHAR},
      TOP1TYPE = #{top1type,jdbcType=VARCHAR},
      TOP2TYPE = #{top2type,jdbcType=VARCHAR},
      TOP3TYPE = #{top3type,jdbcType=VARCHAR}
    where ID = #{id,jdbcType=VARCHAR}
  </update>
</mapper>