# LotStepHistoryMapper.java

    package com.mycim.server.wip.dao.mapper;

    import com.mycim.framework.jdbc.mapper.RowMapper;
    import com.mycim.valueobject.wip.LotStepHistory;

    import java.sql.ResultSet;
    import java.sql.SQLException;

    /**
     * @author shijie.deng
     * @version 6.0.0
     * @date 2019/9/23
     **/
    public class LotStepHistoryMapper implements RowMapper<LotStepHistory> {
        @Override
        public LotStepHistory mapRow(ResultSet rs, int rowNum) throws SQLException {
            LotStepHistory lotStepHistory = new LotStepHistory();
            lotStepHistory.setLotRrn(new Long(rs.getLong("LOT_RRN")));
            lotStepHistory.setStepSequence(new Long(rs.getLong("STEP_SEQUENCE")));
            lotStepHistory.setFacilityRrn(new Long(rs.getLong("FACILITY_RRN")));
            lotStepHistory.setLotId(rs.getString("LOT_ID"));
            lotStepHistory.setProductRrn(new Long(rs.getLong("PRODUCT_RRN")));
            lotStepHistory.setProductVersion(rs.getInt("PRODUCT_VERSION"));
            lotStepHistory.setProcessRrn(new Long(rs.getLong("PROCESS_RRN")));
            lotStepHistory.setProcessVersion(new Integer(rs.getInt("PROCESS_VERSION")));
            lotStepHistory.setProcessStepVersion(rs.getString("PROCESS_STEP_VERSION"));
            lotStepHistory.setProcessStepIdVersion(rs.getString("PROCESS_STEP_ID_VERSION"));
            lotStepHistory.setOperationRrn(new Long(rs.getLong("OPERATION_RRN")));
            lotStepHistory.setOperationVersion(new Integer(rs.getInt("OPERATION_VERSION")));
            lotStepHistory.setSubcontractorRrn(new Long(rs.getLong("SUBCONTRACTOR_RRN")));
            lotStepHistory.setStageId(rs.getString("STAGE_ID"));
            lotStepHistory.setLayerId(rs.getString("LAYER_ID"));
            lotStepHistory.setCarrierRrn(new Long(rs.getLong("CARRIER_RRN")));
            lotStepHistory.setCarrierMapRrn(new Long(rs.getLong("CARRIER_MAP_RRN")));
            lotStepHistory.setRunRrn(new Long(rs.getLong("RUN_RRN")));
            lotStepHistory.setEqptRrn(new Long(rs.getLong("EQPT_RRN")));
            lotStepHistory.setRecipeString(rs.getString("RECIPE_STRING"));
            lotStepHistory.setReticleRrn(new Long(rs.getLong("RETICLE_RRN")));
            lotStepHistory.setBinRrn(new Long(rs.getLong("BIN_RRN")));
            lotStepHistory.setMoveInDcolRrn(new Long(rs.getLong("MOVE_IN_DCOL_RRN")));
            lotStepHistory.setMoveOutDcolRrn(new Long(rs.getLong("MOVE_OUT_DCOL_RRN")));
            lotStepHistory.setAdHocDcolRrn(new Long(rs.getLong("AD_HOC_DCOL_RRN")));
            lotStepHistory.setReworkFlag(rs.getString("REWORK_FLAG"));
            lotStepHistory.setSplitQty1((rs.getInt("SPLIT_QTY1")));
            lotStepHistory.setSplitQty2((rs.getInt("SPLIT_QTY2")));
            lotStepHistory.setMergeQty1((rs.getInt("MERGE_QTY1")));
            lotStepHistory.setMergeQty2((rs.getInt("MERGE_QTY2")));
            lotStepHistory.setLossQty1((rs.getInt("LOSS_QTY1")));
            lotStepHistory.setLossQty2((rs.getInt("LOSS_QTY2")));
            lotStepHistory.setBonusQty1((rs.getInt("BONUS_QTY1")));
            lotStepHistory.setBonusQty2((rs.getInt("BONUS_QTY2")));
            lotStepHistory.setScrapQty1((rs.getInt("SCRAP_QTY1")));
            lotStepHistory.setScrapQty2((rs.getInt("SCRAP_QTY2")));
            lotStepHistory.setDefectiveQty1((rs.getInt("DEFECTIVE_QTY1")));
            lotStepHistory.setDefectiveQty2((rs.getInt("DEFECTIVE_QTY2")));
            lotStepHistory.setInternalReworkQty1((rs.getInt("INTERNAL_REWORK_QTY1")));
            lotStepHistory.setInternalReworkQty2((rs.getInt("INTERNAL_REWORK_QTY2")));
            lotStepHistory.setTrackUnitFlag(rs.getString("TRACK_UNIT_FLAG"));
            lotStepHistory.setInQty1((rs.getInt("IN_QTY1")));
            lotStepHistory.setInQty2((rs.getInt("IN_QTY2")));
            lotStepHistory.setOutQty1((rs.getInt("OUT_QTY1")));
            lotStepHistory.setOutQty2((rs.getInt("OUT_QTY2")));
            lotStepHistory.setMoveInQty1((rs.getInt("MOVE_IN_QTY1")));
            lotStepHistory.setMoveInQty2((rs.getInt("MOVE_IN_QTY2")));
            lotStepHistory.setMoveOutQty1((rs.getInt("MOVE_OUT_QTY1")));
            lotStepHistory.setMoveOutQty2((rs.getInt("MOVE_OUT_QTY2")));
            lotStepHistory.setExternalReworkQty1((rs.getInt("EXTERNAL_REWORK_QTY1")));
            lotStepHistory.setExternalReworkQty2((rs.getInt("EXTERNAL_REWORK_QTY2")));
            //lotStepHistory.setLoadPosition(rs.getString("LOAD_POSITION"));
            lotStepHistory.setStepTransRrn(new Long(rs.getLong("STEP_TRANS_RRN")));
            lotStepHistory.setChamberType(rs.getString("CHAMBER_TYPE"));
            lotStepHistory.setOperationSeq(rs.getString("OPERATION_SEQ"));
            lotStepHistory.setPollutionLevel(rs.getString("POLLUTION_LEVEL"));
            lotStepHistory.setRouteSeq(rs.getString("ROUTE_SEQ"));
            lotStepHistory.setProductLayer(rs.getString("PRODUCT_LAYER"));
            lotStepHistory.setHotFlag(rs.getString("HOT_FLAG"));
            lotStepHistory.setCreateCategory(rs.getString("CREATE_CATEGORY"));
            lotStepHistory.setParameter(rs.getString("PARAMETER"));
            lotStepHistory.setParameterValue(rs.getString("PARAMETER_VALUE"));
            lotStepHistory.setOperationDesc(rs.getString("OPERATION_DESC"));
            lotStepHistory.setStepType(rs.getString("STEP_TYPE"));
            lotStepHistory.setWorkArea(rs.getString("WORK_AREA"));
            lotStepHistory.setFlowSeq(rs.getString("FLOW_SEQ"));
            lotStepHistory.setEqptGroup(rs.getString("EQPT_GROUP"));
            lotStepHistory.setEqptGroupRrn(rs.getLong("EQPT_GROUP_RRN"));
            lotStepHistory.setProcessLocation(rs.getString("PROCESS_LOCATION"));
            lotStepHistory.setCustomerId(rs.getString("CUSTOMER_ID"));
            lotStepHistory.setShippingCode(rs.getString("SHIPPING_CODE"));
            lotStepHistory.setOuterOrderNo(rs.getString("OUTER_ORDER_NO"));
            lotStepHistory.setOutOrderType(rs.getString("OUT_ORDER_TYPE"));
            lotStepHistory.setRecycleStepInfo(rs.getString("RECYCLE_STEP_INFO"));
            lotStepHistory.setRecycleStepIdInfo(rs.getString("RECYCLE_STEP_ID_INFO"));
            lotStepHistory.setRecipeLogicalRrn(new Long(rs.getLong("RECIPE_LOGICAL_RRN")));
            lotStepHistory.setRecipePhysicalId(rs.getString("RECIPE_PHYSICAL_ID"));
            return lotStepHistory;
        }

    }