<?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.ApsCraftRouteStepDao">

    <resultMap id="BaseResultMap" type="com.rongwei.bsentity.domain.ApsCraftRouteStepDo">
        <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="ownedfactory" column="OWNEDFACTORY" jdbcType="VARCHAR"/>
        <result property="craftstepid" column="CRAFTSTEPID" jdbcType="VARCHAR"/>
        <result property="craftrouteid" column="CRAFTROUTEID" jdbcType="VARCHAR"/>
        <result property="stepnum" column="STEPNUM" jdbcType="VARCHAR"/>
        <result property="process" column="PROCESS" jdbcType="VARCHAR"/>
        <result property="processname" column="PROCESSNAME" jdbcType="VARCHAR"/>
        <result property="processway" column="PROCESSWAY" jdbcType="VARCHAR"/>
        <result property="numunit" column="NUMUNIT" jdbcType="VARCHAR"/>
        <result property="onceprocessval" column="ONCEPROCESSVAL" jdbcType="DECIMAL"/>
        <result property="onceprocessmin" column="ONCEPROCESSMIN" jdbcType="DECIMAL"/>
        <result property="pertimecapacity" column="PERTIMECAPACITY" jdbcType="DECIMAL"/>
        <result property="timeunit" column="TIMEUNIT" jdbcType="VARCHAR"/>
        <result property="prepressworkmin" column="PREPRESSWORKMIN" jdbcType="DECIMAL"/>
        <result property="loadingmin" column="LOADINGMIN" jdbcType="DECIMAL"/>
        <result property="cuttingmin" column="CUTTINGMIN" jdbcType="DECIMAL"/>
        <result property="cutfinishmin" column="CUTFINISHMIN" jdbcType="DECIMAL"/>
        <result property="minflowbatch" column="MINFLOWBATCH" jdbcType="DECIMAL"/>
        <result property="minflowwaitmin" column="MINFLOWWAITMIN" jdbcType="DECIMAL"/>
        <result property="maxflowwaitmin" column="MAXFLOWWAITMIN" jdbcType="DECIMAL"/>
        <result property="ifblankprocess" column="IFBLANKPROCESS" jdbcType="VARCHAR"/>
        <result property="materialcode" column="MATERIALCODE" jdbcType="VARCHAR"/>
        <result property="materialname" column="MATERIALNAME" jdbcType="VARCHAR"/>
        <result property="producttypeid" column="PRODUCTTYPEID" jdbcType="VARCHAR"/>
        <result property="producttype" column="PRODUCTTYPE" jdbcType="VARCHAR"/>
        <result property="metal" column="METAL" jdbcType="VARCHAR"/>
        <result property="metalstate" column="METALSTATE" jdbcType="VARCHAR"/>
        <result property="thickstr" column="THICKSTR" jdbcType="DECIMAL"/>
        <result property="thickend" column="THICKEND" jdbcType="DECIMAL"/>
        <result property="widthstr" column="WIDTHSTR" jdbcType="DECIMAL"/>
        <result property="widthend" column="WIDTHEND" jdbcType="DECIMAL"/>
        <result property="lengthstr" column="LENGTHSTR" jdbcType="DECIMAL"/>
        <result property="lengthend" column="LENGTHEND" jdbcType="DECIMAL"/>
        <result property="inmatercondition" column="INMATERCONDITION" jdbcType="VARCHAR"/>
        <result property="outmaterrequest" column="OUTMATERREQUEST" jdbcType="VARCHAR"/>
        <result property="chooseequ" column="CHOOSEEQU" jdbcType="VARCHAR"/>
        <result property="previousstepid" column="PREVIOUSSTEPID" jdbcType="VARCHAR"/>
        <result property="nextstepid" column="NEXTSTEPID" jdbcType="VARCHAR"/>
        <result property="previousstepname" column="PREVIOUSSTEPNAME" jdbcType="VARCHAR"/>
        <result property="nextstepname" column="NEXTSTEPNAME" jdbcType="VARCHAR"/>
        <result property="level" column="LEVEL" jdbcType="INTEGER"/>

    </resultMap>

    <sql id="Base_Column_List">
        ID,TENANTID,ROPTION,
        DELETED,REMARK,CREATEDATE,
        CREATEUSERID,MODIFYDATE,MODIFYUSERID,
        CREATEUSERNAME,MODIFYUSERNAME,OWNEDFACTORY,
        CRAFTSTEPID,CRAFTROUTEID,STEPNUM,
        PROCESS,PROCESSNAME,PROCESSWAY,
        NUMUNIT,ONCEPROCESSVAL,ONCEPROCESSMIN,
        PERTIMECAPACITY,TIMEUNIT,PREPRESSWORKMIN,
        LOADINGMIN,CUTTINGMIN,CUTFINISHMIN,
        MINFLOWBATCH,MINFLOWWAITMIN,MAXFLOWWAITMIN,
        IFBLANKPROCESS,MATERIALCODE,MATERIALNAME,
        PRODUCTTYPEID,PRODUCTTYPE,METAL,
        METALSTATE,THICKSTR,THICKEND,
        WIDTHSTR,WIDTHEND,LENGTHSTR,
        LENGTHEND,INMATERCONDITION,OUTMATERREQUEST,
        CHOOSEEQU,PREVIOUSSTEPID,NEXTSTEPID,
        PREVIOUSSTEPNAME,NEXTSTEPNAME,LEVEL
    </sql>

</mapper>
