工单同步表基础代码类

zhanghl

2025-04-17 19f65cce1297bee2ed4f5be518532a55de98f589

工单同步表基础代码类

 aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateProcessStatMapper.xml

@@ -48,6 +48,7 @@
            <if test="designTimes != null "> and design_times = #{designTimes}</if>
            <if test="batchNumber != null  and batchNumber != ''"> and batch_number = #{batchNumber}</if>
        </where>
        order by work_order_no asc,num desc
    </select>
    
    <select id="selectApsPlateProcessStatById" parameterType="String" resultMap="ApsPlateProcessStatResult">

 aps-modules/aps-job/src/main/java/com/aps/job/domain/ApsWorkOrderJob.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,417 @@
package com.aps.job.domain;

import java.math.BigDecimal;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.aps.common.core.annotation.Excel;
import com.aps.common.core.web.domain.BaseEntity;

/**
 * å·¥å•åŒæ­¥å¯¹è±¡ aps_work_order_job
 * 
 * @author zhl
 * @date 2025-04-17
 */
public class ApsWorkOrderJob extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** ä¸»é”®id */
    private Long id;

    /** åŒæ­¥ä¸»é”® */
    @Excel(name = "同步主键")
    private String orderId;

    /** å•æ®å· */
    @Excel(name = "单据号")
    private String docNo;

    /** ä¸»ä»¶æ–™å· */
    @Excel(name = "主件料号")
    private String mainitemCode;

    /** ä¸»ä»¶å›¾å· */
    @Excel(name = "主件图号")
    private String mainitemFigure;

    /** å®¢æˆ·åç§° */
    @Excel(name = "客户名称")
    private String customerName;

    /** ä¸šåŠ¡ç±»åž‹ 0：计划订单  1：生产订单 */
    @Excel(name = "业务类型 0：计划订单  1：生产订单")
    private Integer businessType;

    /** éœ€æ±‚分类 */
    @Excel(name = "需求分类")
    private String demandType;

    /** å•æ®çŠ¶æ€( 0：开立 1：已核准 2：开工 3：完工 4：核准中 5：作废 ) */
    @Excel(name = "单据状态( 0：开立 1：已核准 2：开工 3：完工 4：核准中 5：作废 )")
    private Long docStatus;

    /** æ–™å· */
    @Excel(name = "料号")
    private String itemCode;

    /** å›¾å· */
    @Excel(name = "图号")
    private String itemFigure;

    /** ç‰ˆæœ¬å· */
    @Excel(name = "版本号")
    private String itemFigureVersion;

    /** ç”Ÿäº§æ•°é‡ */
    @Excel(name = "生产数量")
    private BigDecimal pruductQty;

    /** è‰¯å“æ•°é‡ */
    @Excel(name = "良品数量")
    private BigDecimal workQty;

    /** å·¥åºå· */
    @Excel(name = "工序号")
    private String opNum;

    /** å·¥ä½œä¸­å¿ƒ å½“前在制的工序 */
    @Excel(name = "工作中心 å½“前在制的工序")
    private Integer workCenter;

    /** æ‰€å±žéƒ¨é—¨ */
    @Excel(name = "所属部门")
    private String dept;

    /** è®¡åˆ’开工日 */
    @Excel(name = "计划开工日")
    private String startDate;

    /** è®¡åˆ’完工日 */
    @Excel(name = "计划完工日")
    private String completeDate;

    /** ä¸‹é“工序所属部门 */
    @Excel(name = "下道工序所属部门")
    private String nextDept;

    /** æ˜¯å¦æŒ‚èµ· 1：是     0:否 */
    @Excel(name = "是否挂起 1：是     0:否")
    private Integer isHoldRelease;

    /** å¤–协标识 */
    @Excel(name = "外协标识")
    private String isOutSource;

    /** è´¦å¥—( æžšä¸¾ã€Žå—通/沈阳』) */
    @Excel(name = "账套( æžšä¸¾ã€Žå—通/沈阳』)")
    private String org;

    /** é¡µç  */
    @Excel(name = "页码")
    private Integer pageNum;

    /** é¡µé¢ç¬¬å‡ æ¡æ•°æ® */
    @Excel(name = "页面第几条数据")
    private Integer pageIndex;

    /** åˆ é™¤æ ‡å¿—（0代表存在 2代表删除） */
    @Excel(name = "删除标志", readConverterExp = "0=代表存在,2=代表删除")
    private String delFlag;

    public void setId(Long id) 
    {
        this.id = id;
    }

    public Long getId() 
    {
        return id;
    }

    public void setOrderId(String orderId) 
    {
        this.orderId = orderId;
    }

    public String getOrderId() 
    {
        return orderId;
    }

    public void setDocNo(String docNo) 
    {
        this.docNo = docNo;
    }

    public String getDocNo() 
    {
        return docNo;
    }

    public void setMainitemCode(String mainitemCode) 
    {
        this.mainitemCode = mainitemCode;
    }

    public String getMainitemCode() 
    {
        return mainitemCode;
    }

    public void setMainitemFigure(String mainitemFigure) 
    {
        this.mainitemFigure = mainitemFigure;
    }

    public String getMainitemFigure() 
    {
        return mainitemFigure;
    }

    public void setCustomerName(String customerName) 
    {
        this.customerName = customerName;
    }

    public String getCustomerName() 
    {
        return customerName;
    }

    public void setBusinessType(Integer businessType) 
    {
        this.businessType = businessType;
    }

    public Integer getBusinessType() 
    {
        return businessType;
    }

    public void setDemandType(String demandType) 
    {
        this.demandType = demandType;
    }

    public String getDemandType() 
    {
        return demandType;
    }

    public void setDocStatus(Long docStatus) 
    {
        this.docStatus = docStatus;
    }

    public Long getDocStatus() 
    {
        return docStatus;
    }

    public void setItemCode(String itemCode) 
    {
        this.itemCode = itemCode;
    }

    public String getItemCode() 
    {
        return itemCode;
    }

    public void setItemFigure(String itemFigure) 
    {
        this.itemFigure = itemFigure;
    }

    public String getItemFigure() 
    {
        return itemFigure;
    }

    public void setItemFigureVersion(String itemFigureVersion) 
    {
        this.itemFigureVersion = itemFigureVersion;
    }

    public String getItemFigureVersion() 
    {
        return itemFigureVersion;
    }

    public void setPruductQty(BigDecimal pruductQty) 
    {
        this.pruductQty = pruductQty;
    }

    public BigDecimal getPruductQty() 
    {
        return pruductQty;
    }

    public void setWorkQty(BigDecimal workQty) 
    {
        this.workQty = workQty;
    }

    public BigDecimal getWorkQty() 
    {
        return workQty;
    }

    public void setOpNum(String opNum) 
    {
        this.opNum = opNum;
    }

    public String getOpNum() 
    {
        return opNum;
    }

    public void setWorkCenter(Integer workCenter) 
    {
        this.workCenter = workCenter;
    }

    public Integer getWorkCenter() 
    {
        return workCenter;
    }

    public void setDept(String dept) 
    {
        this.dept = dept;
    }

    public String getDept() 
    {
        return dept;
    }

    public void setStartDate(String startDate) 
    {
        this.startDate = startDate;
    }

    public String getStartDate() 
    {
        return startDate;
    }

    public void setCompleteDate(String completeDate) 
    {
        this.completeDate = completeDate;
    }

    public String getCompleteDate() 
    {
        return completeDate;
    }

    public void setNextDept(String nextDept) 
    {
        this.nextDept = nextDept;
    }

    public String getNextDept() 
    {
        return nextDept;
    }

    public void setIsHoldRelease(Integer isHoldRelease) 
    {
        this.isHoldRelease = isHoldRelease;
    }

    public Integer getIsHoldRelease() 
    {
        return isHoldRelease;
    }

    public void setIsOutSource(String isOutSource) 
    {
        this.isOutSource = isOutSource;
    }

    public String getIsOutSource() 
    {
        return isOutSource;
    }

    public void setOrg(String org) 
    {
        this.org = org;
    }

    public String getOrg() 
    {
        return org;
    }

    public void setPageNum(Integer pageNum) 
    {
        this.pageNum = pageNum;
    }

    public Integer getPageNum() 
    {
        return pageNum;
    }

    public void setPageIndex(Integer pageIndex) 
    {
        this.pageIndex = pageIndex;
    }

    public Integer getPageIndex() 
    {
        return pageIndex;
    }

    public void setDelFlag(String delFlag) 
    {
        this.delFlag = delFlag;
    }

    public String getDelFlag() 
    {
        return delFlag;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("orderId", getOrderId())
            .append("docNo", getDocNo())
            .append("mainitemCode", getMainitemCode())
            .append("mainitemFigure", getMainitemFigure())
            .append("customerName", getCustomerName())
            .append("businessType", getBusinessType())
            .append("demandType", getDemandType())
            .append("docStatus", getDocStatus())
            .append("itemCode", getItemCode())
            .append("itemFigure", getItemFigure())
            .append("itemFigureVersion", getItemFigureVersion())
            .append("pruductQty", getPruductQty())
            .append("workQty", getWorkQty())
            .append("opNum", getOpNum())
            .append("workCenter", getWorkCenter())
            .append("dept", getDept())
            .append("startDate", getStartDate())
            .append("completeDate", getCompleteDate())
            .append("nextDept", getNextDept())
            .append("isHoldRelease", getIsHoldRelease())
            .append("isOutSource", getIsOutSource())
            .append("org", getOrg())
            .append("pageNum", getPageNum())
            .append("pageIndex", getPageIndex())
            .append("delFlag", getDelFlag())
            .append("createBy", getCreateBy())
            .append("createTime", getCreateTime())
            .append("updateBy", getUpdateBy())
            .append("updateTime", getUpdateTime())
            .toString();
    }
}

 aps-modules/aps-job/src/main/java/com/aps/job/mapper/ApsWorkOrderJobMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,66 @@
package com.aps.job.mapper;

import java.util.List;
import com.aps.job.domain.ApsWorkOrderJob;
import org.apache.ibatis.annotations.Mapper;

/**
 * å·¥å•åŒæ­¥Mapper接口
 * 
 * @author zhl
 * @date 2025-04-17
 */
@Mapper
public interface ApsWorkOrderJobMapper 
{
    /**
     * æŸ¥è¯¢å·¥å•åŒæ­¥
     * 
     * @param id å·¥å•åŒæ­¥ä¸»é”®
     * @return å·¥å•åŒæ­¥
     */
    public ApsWorkOrderJob selectApsWorkOrderJobById(Long id);

    /**
     * æŸ¥è¯¢å·¥å•åŒæ­¥åˆ—表
     * 
     * @param apsWorkOrderJob å·¥å•åŒæ­¥
     * @return å·¥å•åŒæ­¥é›†åˆ
     */
    public List<ApsWorkOrderJob> selectApsWorkOrderJobList(ApsWorkOrderJob apsWorkOrderJob);

    /**
     * æ–°å¢žå·¥å•åŒæ­¥
     * 
     * @param apsWorkOrderJob å·¥å•åŒæ­¥
     * @return ç»“æžœ
     */
    public int insertApsWorkOrderJob(ApsWorkOrderJob apsWorkOrderJob);

    /**
     * ä¿®æ”¹å·¥å•åŒæ­¥
     * 
     * @param apsWorkOrderJob å·¥å•åŒæ­¥
     * @return ç»“æžœ
     */
    public int updateApsWorkOrderJob(ApsWorkOrderJob apsWorkOrderJob);

    /**
     * åˆ é™¤å·¥å•åŒæ­¥
     * 
     * @param id å·¥å•åŒæ­¥ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteApsWorkOrderJobById(Long id);

    /**
     * æ‰¹é‡åˆ é™¤å·¥å•åŒæ­¥
     * 
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteApsWorkOrderJobByIds(Long[] ids);

    void batchInsertApsWorkOrderJob(List<ApsWorkOrderJob> jobs);

}

 aps-modules/aps-job/src/main/java/com/aps/job/service/IApsWorkOrderJobService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,61 @@
package com.aps.job.service;

import java.util.List;
import com.aps.job.domain.ApsWorkOrderJob;

/**
 * å·¥å•åŒæ­¥Service接口
 * 
 * @author zhl
 * @date 2025-04-17
 */
public interface IApsWorkOrderJobService 
{
    /**
     * æŸ¥è¯¢å·¥å•åŒæ­¥
     * 
     * @param id å·¥å•åŒæ­¥ä¸»é”®
     * @return å·¥å•åŒæ­¥
     */
    public ApsWorkOrderJob selectApsWorkOrderJobById(Long id);

    /**
     * æŸ¥è¯¢å·¥å•åŒæ­¥åˆ—表
     * 
     * @param apsWorkOrderJob å·¥å•åŒæ­¥
     * @return å·¥å•åŒæ­¥é›†åˆ
     */
    public List<ApsWorkOrderJob> selectApsWorkOrderJobList(ApsWorkOrderJob apsWorkOrderJob);

    /**
     * æ–°å¢žå·¥å•åŒæ­¥
     * 
     * @param apsWorkOrderJob å·¥å•åŒæ­¥
     * @return ç»“æžœ
     */
    public int insertApsWorkOrderJob(ApsWorkOrderJob apsWorkOrderJob);

    /**
     * ä¿®æ”¹å·¥å•åŒæ­¥
     * 
     * @param apsWorkOrderJob å·¥å•åŒæ­¥
     * @return ç»“æžœ
     */
    public int updateApsWorkOrderJob(ApsWorkOrderJob apsWorkOrderJob);

    /**
     * æ‰¹é‡åˆ é™¤å·¥å•åŒæ­¥
     * 
     * @param ids éœ€è¦åˆ é™¤çš„工单同步主键集合
     * @return ç»“æžœ
     */
    public int deleteApsWorkOrderJobByIds(Long[] ids);

    /**
     * åˆ é™¤å·¥å•åŒæ­¥ä¿¡æ¯
     * 
     * @param id å·¥å•åŒæ­¥ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteApsWorkOrderJobById(Long id);
}

 aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,96 @@
package com.aps.job.service.impl;

import java.util.List;
import com.aps.common.core.utils.DateUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.aps.job.mapper.ApsWorkOrderJobMapper;
import com.aps.job.domain.ApsWorkOrderJob;
import com.aps.job.service.IApsWorkOrderJobService;

/**
 * å·¥å•åŒæ­¥Service业务层处理
 * 
 * @author zhl
 * @date 2025-04-17
 */
@Service
public class ApsWorkOrderJobServiceImpl implements IApsWorkOrderJobService 
{
    @Autowired
    private ApsWorkOrderJobMapper apsWorkOrderJobMapper;

    /**
     * æŸ¥è¯¢å·¥å•åŒæ­¥
     * 
     * @param id å·¥å•åŒæ­¥ä¸»é”®
     * @return å·¥å•åŒæ­¥
     */
    @Override
    public ApsWorkOrderJob selectApsWorkOrderJobById(Long id)
    {
        return apsWorkOrderJobMapper.selectApsWorkOrderJobById(id);
    }

    /**
     * æŸ¥è¯¢å·¥å•åŒæ­¥åˆ—表
     * 
     * @param apsWorkOrderJob å·¥å•åŒæ­¥
     * @return å·¥å•åŒæ­¥
     */
    @Override
    public List<ApsWorkOrderJob> selectApsWorkOrderJobList(ApsWorkOrderJob apsWorkOrderJob)
    {
        return apsWorkOrderJobMapper.selectApsWorkOrderJobList(apsWorkOrderJob);
    }

    /**
     * æ–°å¢žå·¥å•åŒæ­¥
     * 
     * @param apsWorkOrderJob å·¥å•åŒæ­¥
     * @return ç»“æžœ
     */
    @Override
    public int insertApsWorkOrderJob(ApsWorkOrderJob apsWorkOrderJob)
    {
        apsWorkOrderJob.setCreateTime(DateUtils.getNowDate());
        return apsWorkOrderJobMapper.insertApsWorkOrderJob(apsWorkOrderJob);
    }

    /**
     * ä¿®æ”¹å·¥å•åŒæ­¥
     * 
     * @param apsWorkOrderJob å·¥å•åŒæ­¥
     * @return ç»“æžœ
     */
    @Override
    public int updateApsWorkOrderJob(ApsWorkOrderJob apsWorkOrderJob)
    {
        apsWorkOrderJob.setUpdateTime(DateUtils.getNowDate());
        return apsWorkOrderJobMapper.updateApsWorkOrderJob(apsWorkOrderJob);
    }

    /**
     * æ‰¹é‡åˆ é™¤å·¥å•åŒæ­¥
     * 
     * @param ids éœ€è¦åˆ é™¤çš„工单同步主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsWorkOrderJobByIds(Long[] ids)
    {
        return apsWorkOrderJobMapper.deleteApsWorkOrderJobByIds(ids);
    }

    /**
     * åˆ é™¤å·¥å•åŒæ­¥ä¿¡æ¯
     * 
     * @param id å·¥å•åŒæ­¥ä¸»é”®
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsWorkOrderJobById(Long id)
    {
        return apsWorkOrderJobMapper.deleteApsWorkOrderJobById(id);
    }
}

 aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,262 @@
<?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.aps.job.mapper.ApsWorkOrderJobMapper">
    
    <resultMap type="ApsWorkOrderJob" id="ApsWorkOrderJobResult">
        <result property="id"    column="id"    />
        <result property="orderId"    column="order_id"    />
        <result property="docNo"    column="doc_no"    />
        <result property="mainitemCode"    column="mainitem_code"    />
        <result property="mainitemFigure"    column="mainitem_figure"    />
        <result property="customerName"    column="customer_name"    />
        <result property="businessType"    column="business_type"    />
        <result property="demandType"    column="demand_type"    />
        <result property="docStatus"    column="doc_status"    />
        <result property="itemCode"    column="item_code"    />
        <result property="itemFigure"    column="item_figure"    />
        <result property="itemFigureVersion"    column="item_figure_version"    />
        <result property="pruductQty"    column="pruduct_qty"    />
        <result property="workQty"    column="work_qty"    />
        <result property="opNum"    column="op_num"    />
        <result property="workCenter"    column="work_center"    />
        <result property="dept"    column="dept"    />
        <result property="startDate"    column="start_date"    />
        <result property="completeDate"    column="complete_date"    />
        <result property="nextDept"    column="next_dept"    />
        <result property="isHoldRelease"    column="is_hold_release"    />
        <result property="isOutSource"    column="is_out_source"    />
        <result property="org"    column="org"    />
        <result property="pageNum"    column="page_num"    />
        <result property="pageIndex"    column="page_index"    />
        <result property="delFlag"    column="del_flag"    />
        <result property="createBy"    column="create_by"    />
        <result property="createTime"    column="create_time"    />
        <result property="updateBy"    column="update_by"    />
        <result property="updateTime"    column="update_time"    />
    </resultMap>

    <sql id="selectApsWorkOrderJobVo">
        select id, order_id, doc_no, mainitem_code, mainitem_figure, customer_name, business_type, demand_type, doc_status, item_code, item_figure, item_figure_version, pruduct_qty, work_qty, op_num, work_center, dept, start_date, complete_date, next_dept, is_hold_release, is_out_source, org, page_num, page_index, del_flag, create_by, create_time, update_by, update_time from aps_work_order_job
    </sql>

    <select id="selectApsWorkOrderJobList" parameterType="ApsWorkOrderJob" resultMap="ApsWorkOrderJobResult">
        <include refid="selectApsWorkOrderJobVo"/>
        <where>  
            <if test="orderId != null  and orderId != ''"> and order_id = #{orderId}</if>
            <if test="docNo != null  and docNo != ''"> and doc_no = #{docNo}</if>
            <if test="mainitemCode != null  and mainitemCode != ''"> and mainitem_code = #{mainitemCode}</if>
            <if test="mainitemFigure != null  and mainitemFigure != ''"> and mainitem_figure = #{mainitemFigure}</if>
            <if test="customerName != null  and customerName != ''"> and customer_name like concat('%', #{customerName}, '%')</if>
            <if test="businessType != null "> and business_type = #{businessType}</if>
            <if test="demandType != null  and demandType != ''"> and demand_type = #{demandType}</if>
            <if test="docStatus != null "> and doc_status = #{docStatus}</if>
            <if test="itemCode != null  and itemCode != ''"> and item_code = #{itemCode}</if>
            <if test="itemFigure != null  and itemFigure != ''"> and item_figure = #{itemFigure}</if>
            <if test="itemFigureVersion != null  and itemFigureVersion != ''"> and item_figure_version = #{itemFigureVersion}</if>
            <if test="pruductQty != null "> and pruduct_qty = #{pruductQty}</if>
            <if test="workQty != null "> and work_qty = #{workQty}</if>
            <if test="opNum != null  and opNum != ''"> and op_num = #{opNum}</if>
            <if test="workCenter != null "> and work_center = #{workCenter}</if>
            <if test="dept != null  and dept != ''"> and dept = #{dept}</if>
            <if test="startDate != null  and startDate != ''"> and start_date = #{startDate}</if>
            <if test="completeDate != null  and completeDate != ''"> and complete_date = #{completeDate}</if>
            <if test="nextDept != null  and nextDept != ''"> and next_dept = #{nextDept}</if>
            <if test="isHoldRelease != null "> and is_hold_release = #{isHoldRelease}</if>
            <if test="isOutSource != null  and isOutSource != ''"> and is_out_source = #{isOutSource}</if>
            <if test="org != null  and org != ''"> and org = #{org}</if>
            <if test="pageNum != null "> and page_num = #{pageNum}</if>
            <if test="pageIndex != null "> and page_index = #{pageIndex}</if>
            <if test="delFlag != null  and delFlag != ''"> and del_flag = #{delFlag}</if>
        </where>
    </select>
    
    <select id="selectApsWorkOrderJobById" parameterType="Long" resultMap="ApsWorkOrderJobResult">
        <include refid="selectApsWorkOrderJobVo"/>
        where id = #{id}
    </select>

    <insert id="insertApsWorkOrderJob" parameterType="ApsWorkOrderJob" useGeneratedKeys="true" keyProperty="id">
        insert into aps_work_order_job
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="orderId != null">order_id,</if>
            <if test="docNo != null">doc_no,</if>
            <if test="mainitemCode != null">mainitem_code,</if>
            <if test="mainitemFigure != null">mainitem_figure,</if>
            <if test="customerName != null">customer_name,</if>
            <if test="businessType != null">business_type,</if>
            <if test="demandType != null">demand_type,</if>
            <if test="docStatus != null">doc_status,</if>
            <if test="itemCode != null">item_code,</if>
            <if test="itemFigure != null">item_figure,</if>
            <if test="itemFigureVersion != null">item_figure_version,</if>
            <if test="pruductQty != null">pruduct_qty,</if>
            <if test="workQty != null">work_qty,</if>
            <if test="opNum != null">op_num,</if>
            <if test="workCenter != null">work_center,</if>
            <if test="dept != null">dept,</if>
            <if test="startDate != null">start_date,</if>
            <if test="completeDate != null">complete_date,</if>
            <if test="nextDept != null">next_dept,</if>
            <if test="isHoldRelease != null">is_hold_release,</if>
            <if test="isOutSource != null">is_out_source,</if>
            <if test="org != null">org,</if>
            <if test="pageNum != null">page_num,</if>
            <if test="pageIndex != null">page_index,</if>
            <if test="delFlag != null">del_flag,</if>
            <if test="createBy != null">create_by,</if>
            <if test="createTime != null">create_time,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="orderId != null">#{orderId},</if>
            <if test="docNo != null">#{docNo},</if>
            <if test="mainitemCode != null">#{mainitemCode},</if>
            <if test="mainitemFigure != null">#{mainitemFigure},</if>
            <if test="customerName != null">#{customerName},</if>
            <if test="businessType != null">#{businessType},</if>
            <if test="demandType != null">#{demandType},</if>
            <if test="docStatus != null">#{docStatus},</if>
            <if test="itemCode != null">#{itemCode},</if>
            <if test="itemFigure != null">#{itemFigure},</if>
            <if test="itemFigureVersion != null">#{itemFigureVersion},</if>
            <if test="pruductQty != null">#{pruductQty},</if>
            <if test="workQty != null">#{workQty},</if>
            <if test="opNum != null">#{opNum},</if>
            <if test="workCenter != null">#{workCenter},</if>
            <if test="dept != null">#{dept},</if>
            <if test="startDate != null">#{startDate},</if>
            <if test="completeDate != null">#{completeDate},</if>
            <if test="nextDept != null">#{nextDept},</if>
            <if test="isHoldRelease != null">#{isHoldRelease},</if>
            <if test="isOutSource != null">#{isOutSource},</if>
            <if test="org != null">#{org},</if>
            <if test="pageNum != null">#{pageNum},</if>
            <if test="pageIndex != null">#{pageIndex},</if>
            <if test="delFlag != null">#{delFlag},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
         </trim>
    </insert>

    <update id="updateApsWorkOrderJob" parameterType="ApsWorkOrderJob">
        update aps_work_order_job
        <trim prefix="SET" suffixOverrides=",">
            <if test="orderId != null">order_id = #{orderId},</if>
            <if test="docNo != null">doc_no = #{docNo},</if>
            <if test="mainitemCode != null">mainitem_code = #{mainitemCode},</if>
            <if test="mainitemFigure != null">mainitem_figure = #{mainitemFigure},</if>
            <if test="customerName != null">customer_name = #{customerName},</if>
            <if test="businessType != null">business_type = #{businessType},</if>
            <if test="demandType != null">demand_type = #{demandType},</if>
            <if test="docStatus != null">doc_status = #{docStatus},</if>
            <if test="itemCode != null">item_code = #{itemCode},</if>
            <if test="itemFigure != null">item_figure = #{itemFigure},</if>
            <if test="itemFigureVersion != null">item_figure_version = #{itemFigureVersion},</if>
            <if test="pruductQty != null">pruduct_qty = #{pruductQty},</if>
            <if test="workQty != null">work_qty = #{workQty},</if>
            <if test="opNum != null">op_num = #{opNum},</if>
            <if test="workCenter != null">work_center = #{workCenter},</if>
            <if test="dept != null">dept = #{dept},</if>
            <if test="startDate != null">start_date = #{startDate},</if>
            <if test="completeDate != null">complete_date = #{completeDate},</if>
            <if test="nextDept != null">next_dept = #{nextDept},</if>
            <if test="isHoldRelease != null">is_hold_release = #{isHoldRelease},</if>
            <if test="isOutSource != null">is_out_source = #{isOutSource},</if>
            <if test="org != null">org = #{org},</if>
            <if test="pageNum != null">page_num = #{pageNum},</if>
            <if test="pageIndex != null">page_index = #{pageIndex},</if>
            <if test="delFlag != null">del_flag = #{delFlag},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteApsWorkOrderJobById" parameterType="Long">
        delete from aps_work_order_job where id = #{id}
    </delete>

    <delete id="deleteApsWorkOrderJobByIds" parameterType="String">
        delete from aps_work_order_job where id in 
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>

    <insert id="batchInsertApsWorkOrderJob" parameterType="java.util.List">
        insert into aps_work_order_job
        <trim prefix="(" suffix=")" suffixOverrides=",">
            order_id,
            doc_no,
            mainitem_code,
            mainitem_figure,
            customer_name,
            business_type,
            demand_type,
            doc_status,
            item_code,
            item_figure,
            item_figure_version,
            pruduct_qty,
            work_qty,
            op_num,
            work_center,
            dept,
            start_date,
            complete_date,
            next_dept,
            is_hold_release,
            is_out_source,
            org,
            page_num,
            page_index,
            del_flag,
            create_by,
            create_time,
            update_by,
            update_time
        </trim>
        values
        <foreach collection="list" item="job" separator=",">
            (
            #{job.orderId},
            #{job.docNo},
            #{job.mainitemCode},
            #{job.mainitemFigure},
            #{job.customerName},
            #{job.businessType},
            #{job.demandType},
            #{job.docStatus},
            #{job.itemCode},
            #{job.itemFigure},
            #{job.itemFigureVersion},
            #{job.pruductQty},
            #{job.workQty},
            #{job.opNum},
            #{job.workCenter},
            #{job.dept},
            #{job.startDate},
            #{job.completeDate},
            #{job.nextDept},
            #{job.isHoldRelease},
            #{job.isOutSource},
            #{job.org},
            #{job.pageNum},
            #{job.pageIndex},
            #{job.delFlag},
            #{job.createBy},
            #{job.createTime},
            #{job.updateBy},
            #{job.updateTime}
            )
        </foreach>
    </insert>

</mapper>