<?xml version="1.0" encoding="GBK"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.hzjt.mapper.TraffdeviceconfigMapper">
    <resultMap id="BaseResultMap" type="com.hzjt.domain.Traffdeviceconfig">
        <id column="FDID" jdbcType="VARCHAR" property="fdid" />
        <id column="CHANNELID" jdbcType="DECIMAL" property="channelid" />
        <result column="DEVICELOCATIONTYPE" jdbcType="DECIMAL" property="devicelocationtype" />
        <result column="DEVICECHECKTYPE" jdbcType="DECIMAL" property="devicechecktype" />
        <result column="STAKEKILOMETER" jdbcType="DECIMAL" property="stakekilometer" />
        <result column="STAKEMETER" jdbcType="DECIMAL" property="stakemeter" />
        <result column="LOCATIONDIRECTION" jdbcType="DECIMAL" property="locationdirection" />
        <result column="CREATOR" jdbcType="VARCHAR" property="creator" />
        <result column="CREATETIME" jdbcType="TIMESTAMP" property="createtime" />
        <result column="UPDATETIME" jdbcType="TIMESTAMP" property="updatetime" />
        <result column="REMARK1" jdbcType="VARCHAR" property="remark1" />
        <result column="REMARK2" jdbcType="DECIMAL" property="remark2" />
        <result column="REMARK3" jdbcType="VARCHAR" property="remark3" />
        <result column="REMARK4" jdbcType="DECIMAL" property="remark4" />
    </resultMap>
    <!--[reference]example by String
        <if test="col != null and col!=''">
            AND col = #{col}
        </if>
        [reference]example by other
        <if test="col != null">
            AND col = #{col}
        </if>-->

    <!--    <insert id="insertTraffdeviceconfig">
            insert into TRAFFDEVICECONFIG(
                <if test="channelid != null">CHANNELID,</if>
                <if test="createtime != null">CREATETIME,</if>
                <if test="creator != null and creator!=''">CREATOR,</if>
                <if test="devicechecktype != null">DEVICECHECKTYPE,</if>
                <if test="devicelocationtype != null">DEVICELOCATIONTYPE,</if>
                <if test="fdid != null and fdid!=''">FDID,</if>
                <if test="locationdirection != null">LOCATIONDIRECTION,</if>
                <if test="remark1 != null and remark1!=''">REMARK1,</if>
                <if test="remark2 != null">REMARK2,</if>
                <if test="remark3 != null and remark3!=''">REMARK3,</if>
                <if test="remark4 != null">REMARK4,</if>
                <if test="stakekilometer != null">STAKEKILOMETER,</if>
                <if test="stakemeter != null">STAKEMETER,</if>
                <if test="updatetime != null">UPDATETIME</if>
                )
            values(
                <if test="channelid != null">#{channelid},</if>
                <if test="createtime != null">#{createtime},</if>
                <if test="creator != null and creator!=''">#{creator},</if>
                <if test="devicechecktype != null">#{devicechecktype},</if>
                <if test="devicelocationtype != null">#{devicelocationtype},</if>
                <if test="fdid != null and fdid!=''">#{fdid},</if>
                <if test="locationdirection != null">#{locationdirection},</if>
                <if test="remark1 != null and remark1!=''">#{remark1},</if>
                <if test="remark2 != null">#{remark2},</if>
                <if test="remark3 != null and remark3!=''">#{remark3},</if>
                <if test="remark4 != null">#{remark4},</if>
                <if test="stakekilometer != null">#{stakekilometer},</if>
                <if test="stakemeter != null">#{stakemeter},</if>
                <if test="updatetime != null">#{updatetime}</if>
                )
        </insert>-->

    <!--    <update id="updateTraffdeviceconfig">
            update TRAFFDEVICECONFIG
               set
            <if test="channelid != null">CHANNELID = #{channelid},</if>
            <if test="createtime != null">CREATETIME = #{createtime},</if>
            <if test="creator != null and creator!=''">CREATOR = #{creator},</if>
            <if test="devicechecktype != null">DEVICECHECKTYPE = #{devicechecktype},</if>
            <if test="devicelocationtype != null">DEVICELOCATIONTYPE = #{devicelocationtype},</if>
            <if test="fdid != null and fdid!=''">FDID = #{fdid},</if>
            <if test="locationdirection != null">LOCATIONDIRECTION = #{locationdirection},</if>
            <if test="remark1 != null and remark1!=''">REMARK1 = #{remark1},</if>
            <if test="remark2 != null">REMARK2 = #{remark2},</if>
            <if test="remark3 != null and remark3!=''">REMARK3 = #{remark3},</if>
            <if test="remark4 != null">REMARK4 = #{remark4},</if>
            <if test="stakekilometer != null">STAKEKILOMETER = #{stakekilometer},</if>
            <if test="stakemeter != null">STAKEMETER = #{stakemeter},</if>
            <if test="updatetime != null">UPDATETIME = #{updatetime}</if>
               <where>
            <if test="channelid != null">AND CHANNELID = #{channelid}</if>
            <if test="createtime != null">AND CREATETIME = #{createtime}</if>
            <if test="creator != null and creator!=''">AND CREATOR = #{creator}</if>
            <if test="devicechecktype != null">AND DEVICECHECKTYPE = #{devicechecktype}</if>
            <if test="devicelocationtype != null">AND DEVICELOCATIONTYPE = #{devicelocationtype}</if>
            <if test="fdid != null and fdid!=''">AND FDID = #{fdid}</if>
            <if test="locationdirection != null">AND LOCATIONDIRECTION = #{locationdirection}</if>
            <if test="remark1 != null and remark1!=''">AND REMARK1 = #{remark1}</if>
            <if test="remark2 != null">AND REMARK2 = #{remark2}</if>
            <if test="remark3 != null and remark3!=''">AND REMARK3 = #{remark3}</if>
            <if test="remark4 != null">AND REMARK4 = #{remark4}</if>
            <if test="stakekilometer != null">AND STAKEKILOMETER = #{stakekilometer}</if>
            <if test="stakemeter != null">AND STAKEMETER = #{stakemeter}</if>
            <if test="updatetime != null">AND UPDATETIME = #{updatetime}</if>
               </where>
        </update>-->

</mapper>