<?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.rongwei.bscommon.sys.dao.ApsReportYearAndMonthDao">

    <resultMap id="BaseResultMap" type="com.rongwei.bsentity.domain.ApsReportYearAndMonth">
            <id property="id" column="ID" jdbcType="VARCHAR"/>
            <result property="tenantid" column="TENANTID" jdbcType="VARCHAR"/>
            <result property="roption" column="ROPTION" jdbcType="VARCHAR"/>
            <result property="deleted" column="DELETED" jdbcType="VARCHAR"/>
            <result property="remark" column="REMARK" jdbcType="VARCHAR"/>
            <result property="createdate" column="CREATEDATE" jdbcType="TIMESTAMP"/>
            <result property="createuserid" column="CREATEUSERID" jdbcType="VARCHAR"/>
            <result property="modifydate" column="MODIFYDATE" jdbcType="TIMESTAMP"/>
            <result property="modifyuserid" column="MODIFYUSERID" jdbcType="VARCHAR"/>
            <result property="createusername" column="CREATEUSERNAME" jdbcType="VARCHAR"/>
            <result property="modifyusername" column="MODIFYUSERNAME" jdbcType="VARCHAR"/>
            <result property="tenantname" column="TENANTNAME" jdbcType="VARCHAR"/>
            <result property="planordernumyear" column="PLANORDERNUMYEAR" jdbcType="VARCHAR"/>
            <result property="actualordernumyear" column="ACTUALORDERNUMYEAR" jdbcType="VARCHAR"/>
            <result property="actualfinishnumyear" column="ACTUALFINISHNUMYEAR" jdbcType="VARCHAR"/>
            <result property="planordernumyearpercent" column="PLANORDERNUMYEARPERCENT" jdbcType="VARCHAR"/>
            <result property="actualfinishnumyearpercent" column="ACTUALFINISHNUMYEARPERCENT" jdbcType="VARCHAR"/>
            <result property="planordernummonth" column="PLANORDERNUMMONTH" jdbcType="VARCHAR"/>
            <result property="actualordernummonth" column="ACTUALORDERNUMMONTH" jdbcType="VARCHAR"/>
            <result property="actualfinishnummonth" column="ACTUALFINISHNUMMONTH" jdbcType="VARCHAR"/>
            <result property="planordernummonthpercent" column="PLANORDERNUMMONTHPERCENT" jdbcType="VARCHAR"/>
            <result property="actualfinishnummonthpercent" column="ACTUALFINISHNUMMONTHPERCENT" jdbcType="VARCHAR"/>
            <result property="actualordernumyearshow" column="ACTUALORDERNUMYEARSHOW" jdbcType="VARCHAR"/>
            <result property="actualfinishnumyearshow" column="ACTUALFINISHNUMYEARSHOW" jdbcType="VARCHAR"/>
            <result property="actualordernummonthshow" column="ACTUALORDERNUMMONTHSHOW" jdbcType="VARCHAR"/>
            <result property="actualfinishnummonthshow" column="ACTUALFINISHNUMMONTHSHOW" jdbcType="VARCHAR"/>
    </resultMap>

    <sql id="Base_Column_List">
        ID,TENANTID,ROPTION,
        DELETED,REMARK,CREATEDATE,
        CREATEUSERID,MODIFYDATE,MODIFYUSERID,
        CREATEUSERNAME,MODIFYUSERNAME,TENANTNAME,
        PLANORDERNUMYEAR,ACTUALORDERNUMYEAR,ACTUALFINISHNUMYEAR,
        PLANORDERNUMYEARPERCENT,ACTUALFINISHNUMYEARPERCENT,PLANORDERNUMMONTH,
        ACTUALORDERNUMMONTH,ACTUALFINISHNUMMONTH,PLANORDERNUMMONTHPERCENT,
        ACTUALFINISHNUMMONTHPERCENT,ACTUALORDERNUMYEARSHOW,ACTUALFINISHNUMYEARSHOW,
        ACTUALORDERNUMMONTHSHOW,ACTUALFINISHNUMMONTHSHOW
    </sql>
</mapper>
