<?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.ticket.WoearthlineMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.gyee.frame.model.ticket.Woearthline">
        <id column="ID" property="id" />
        <result column="WONUM" property="wonum" />
        <result column="LINENUM" property="linenum" />
        <result column="LINENAME" property="linename" />
        <result column="DESCRIPTION" property="description" />
        <result column="LOCATION" property="location" />
        <result column="EQUIPMENT" property="equipment" />
        <result column="STATE" property="state" />
        <result column="DDMS" property="ddms" />
        <result column="SBMS" property="sbms" />
        <result column="ADDRESS" property="address" />
        <result column="EQNAME" property="eqname" />
        <result column="ISEXECUTE" property="isexecute" />
        <result column="EXECUTOR" property="executor" />
        <result column="STATE1" property="state1" />
        <result column="DDMS1" property="ddms1" />
        <result column="SBMS1" property="sbms1" />
        <result column="ADDRESS1" property="address1" />
        <result column="EQNAME1" property="eqname1" />
        <result column="REMARK1" property="remark1" />
        <result column="REMARK2" property="remark2" />
        <result column="REMARK3" property="remark3" />
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        ID, WONUM, LINENUM, LINENAME, DESCRIPTION, LOCATION, EQUIPMENT, STATE, DDMS, SBMS, ADDRESS, EQNAME, ISEXECUTE, EXECUTOR, STATE1, DDMS1, SBMS1, ADDRESS1, EQNAME1, REMARK1, REMARK2, REMARK3
    </sql>

    <select id="selectMaxId" resultType="Integer">
        select max(id) from WOEARTHLINE
    </select>

</mapper>
