生成钣金工单计划：准备基础代码

zhanghl

2025-05-06 a51811707c31393a32fa65d973297f4e302fbd66

生成钣金工单计划：准备基础代码

 aps-modules/aps-core/src/main/java/com/aps/core/controller/mainPlan/ApsPlateStandardRequireController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,113 @@
package com.aps.core.controller.mainPlan;

import java.util.List;

import jakarta.servlet.http.HttpServletResponse;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.aps.common.log.annotation.Log;
import com.aps.common.log.enums.BusinessType;
import com.aps.common.security.annotation.RequiresPermissions;
import com.aps.core.domain.ApsPlateStandardRequire;
import com.aps.core.service.IApsPlateStandardRequireService;
import com.aps.common.core.web.controller.BaseController;
import com.aps.common.core.web.domain.AjaxResult;
import com.aps.common.core.utils.poi.ExcelUtil;
import com.aps.common.core.web.page.TableDataInfo;

/**
 * é’£é‡‘工单标准需求Controller
 * 
 * @author zhl
 * @date 2025-05-06
 */


@RestController
@RequestMapping("/ApsPlateStandardRequire")
public class ApsPlateStandardRequireController extends BaseController
{
    @Autowired
    private IApsPlateStandardRequireService apsPlateStandardRequireService;

    /**
     * æŸ¥è¯¢é’£é‡‘工单标准需求列表
     */

    @RequiresPermissions("ApsPlateStandardRequire:ApsPlateStandardRequire:list")
    @GetMapping("/list")
    public TableDataInfo list(ApsPlateStandardRequire apsPlateStandardRequire)
    {
        startPage();
        List<ApsPlateStandardRequire> list = apsPlateStandardRequireService.selectApsPlateStandardRequireList(apsPlateStandardRequire);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºé’£é‡‘工单标准需求列表
     */

    @RequiresPermissions("ApsPlateStandardRequire:ApsPlateStandardRequire:export")
    @Log(title = "钣金工单标准需求", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, ApsPlateStandardRequire apsPlateStandardRequire)
    {
        List<ApsPlateStandardRequire> list = apsPlateStandardRequireService.selectApsPlateStandardRequireList(apsPlateStandardRequire);
        ExcelUtil<ApsPlateStandardRequire> util = new ExcelUtil<ApsPlateStandardRequire>(ApsPlateStandardRequire.class);
        util.exportExcel(response, list, "钣金工单标准需求数据");
    }

    /**
     * èŽ·å–钣金工单标准需求详细信息
     */

    @RequiresPermissions("ApsPlateStandardRequire:ApsPlateStandardRequire:query")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id)
    {
        return success(apsPlateStandardRequireService.selectApsPlateStandardRequireById(id));
    }

    /**
     * æ–°å¢žé’£é‡‘工单标准需求
     */

    @RequiresPermissions("ApsPlateStandardRequire:ApsPlateStandardRequire:add")
    @Log(title = "钣金工单标准需求", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody ApsPlateStandardRequire apsPlateStandardRequire)
    {
        return toAjax(apsPlateStandardRequireService.insertApsPlateStandardRequire(apsPlateStandardRequire));
    }

    /**
     * ä¿®æ”¹é’£é‡‘工单标准需求
     */

    @RequiresPermissions("ApsPlateStandardRequire:ApsPlateStandardRequire:edit")
    @Log(title = "钣金工单标准需求", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody ApsPlateStandardRequire apsPlateStandardRequire)
    {
        return toAjax(apsPlateStandardRequireService.updateApsPlateStandardRequire(apsPlateStandardRequire));
    }

    /**
     * åˆ é™¤é’£é‡‘工单标准需求
     */

    @RequiresPermissions("ApsPlateStandardRequire:ApsPlateStandardRequire:remove")
    @Log(title = "钣金工单标准需求", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids)
    {
        return toAjax(apsPlateStandardRequireService.deleteApsPlateStandardRequireByIds(ids));
    }
}

 aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateStandardRequire.java

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

import com.aps.common.core.annotation.Excel;
import com.aps.common.core.web.domain.BaseEntity;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.io.Serial;

/**
 * é’£é‡‘工单标准需求对象 aps_plate_standard_require
 * 
 * @author zhl
 * @date 2025-05-06
 */
@EqualsAndHashCode(callSuper = true)
@Data
public class ApsPlateStandardRequire extends BaseEntity
{
    @Serial
    private static final long serialVersionUID = 1L;

    /** éœ€æ±‚ID */
    private Long id;

    /** éœ€æ±‚追溯ID */
    @Excel(name = "需求追溯ID")
    private String requireId;

    /** bom_line_id */
    @Excel(name = "bom_line_id")
    private String bomLineId;

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

    /** BOM低阶码 */
    @Excel(name = "BOM低阶码")
    private Long bomLineLevel;

    /** BOM用量 */
    @Excel(name = "BOM用量")
    private String bomUseAmount;

    /** å·¥è‰ºè·¯çº¿ID */
    @Excel(name = "工艺路线ID")
    private String processRouteId;

    /** å·¥è‰ºè·¯çº¿å·¥æ—¶ */
    @Excel(name = "工艺路线工时")
    private String processRouteHours;

    /** éœ€æ±‚数量 */
    @Excel(name = "需求数量")
    private String requireAmount;

    /** å‡€éœ€æ±‚量 */
    @Excel(name = "净需求量")
    private String netRequirement;

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

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

    /** éœ€æ±‚日期 */
    @Excel(name = "需求日期")
    private String demandDate;

    /** é€‚用工厂 */
    @Excel(name = "适用工厂")
    private String orgCode;

    /** ç”Ÿäº§åŸºåœ° */
    @Excel(name = "生产基地")

    private String productionBase;

    /** åŒ¹é…çŠ¶æ€ */
    @Excel(name = "匹配状态")

    private String matchState;

    /** åŒ¹é…æ¨¡å¼ */
    @Excel(name = "匹配模式")

    private String matchMode;

    /** æœªåŒ¹é…éœ€æ±‚数量 */
    @Excel(name = "未匹配需求数量")
    private String unmatchedDemandAmount;

    /** å»ºè®®å®Œæˆæ—¥æœŸ */
    @Excel(name = "建议完成日期")
    private String suggestedCompletionDate;

    /** å»¶è¿Ÿé£Žé™©æ ‡è¯† */
    @Excel(name = "延迟风险标识")
    private String hasDelayRisk;

    /** $column.columnComment */

    private String batchNumber;

    /** $column.columnComment */
    private String delFlag;

}

 aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateStandardRequireBatch.java

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

import com.aps.common.core.web.domain.BaseEntity;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.io.Serial;

/**
 * é’£é‡‘计划标准需求计划批次表对象 aps_plate_standard_require_batch
 * 
 * @author zhl
 * @date 2025-05-06
 */
@EqualsAndHashCode(callSuper = true)
@Data
public class ApsPlateStandardRequireBatch extends BaseEntity
{
    @Serial
    private static final long serialVersionUID = 1L;
    private Long id;
    private String batchNumber;
    private String delFlag;

}

 aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateStandardRequireBomOrderDetail.java

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

import com.aps.common.core.annotation.Excel;
import com.aps.common.core.web.domain.BaseEntity;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.io.Serial;

/**
 * ApsPlateStandardRequireBomOrderDetail对象 aps_plate_standard_require_bom_order_detail
 * 
 * @author zhl
 * &#064;date  2025-05-06
 */
@EqualsAndHashCode(callSuper = true)
@Data
public class ApsPlateStandardRequireBomOrderDetail extends BaseEntity
{
    @Serial
    private static final long serialVersionUID = 1L;


    private Long id;

    /** éœ€æ±‚追溯ID */
    @Excel(name = "需求追溯ID")

    private String requireId;

    /** bom_line_id */
    @Excel(name = "bom_line_id")

    private String bomLineId;

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

    private String bomLineCode;

    /** è®¢å•å· */
    @Excel(name = "订单号")

    private String docNo;

    /** æ‰£å‡å‰æ•°é‡ */
    @Excel(name = "扣减前数量")

    private String beforeProdAmount;

    /** åŒ¹é…æ•°é‡ */
    @Excel(name = "匹配数量")

    private String deductionAmount;

    /** æ‰£å‡åŽæ•°é‡ */
    @Excel(name = "扣减后数量")

    private String afterProdAmount;


    private String orgCode;


    private String batchNumber;


    private String delFlag;

}

 aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateStandardRequireBomStockDetail.java

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

import com.aps.common.core.annotation.Excel;
import com.aps.common.core.web.domain.BaseEntity;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.io.Serial;

/**
 * ApsPlateStandardRequireBomStockDetail对象 aps_plate_standard_require_bom_stock_detail
 * 
 * @author zhl
 * &#064;date  2025-05-06
 */
@EqualsAndHashCode(callSuper = true)
@Data
public class ApsPlateStandardRequireBomStockDetail extends BaseEntity
{
    @Serial
    private static final long serialVersionUID = 1L;

    /** $column.columnComment */

    private Long id;

    /** éœ€æ±‚追溯ID */
    @Excel(name = "需求追溯ID")
    private String requireId;

    /** bom_line_id */
    @Excel(name = "bom_line_id")
    private String bomLineId;

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

    /** æ‰£å‡å‰åº“存量 */
    @Excel(name = "扣减前库存量")
    private String beforeStockAmount;

    /** æ‰£å‡åº“存量 */
    @Excel(name = "扣减库存量")
    private String deductionAmount;

    /** æ‰£å‡åŽåº“存量 */
    @Excel(name = "扣减后库存量")
    private String afterStockAmount;

    private String orgCode;
    private String batchNumber;
    private String delFlag;

}

 aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsPlateStandardRequireBatchMapper.java

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

import java.util.List;
import com.aps.core.domain.ApsPlateStandardRequireBatch;
import org.apache.ibatis.annotations.Mapper;

/**
 * é’£é‡‘计划标准需求计划批次表Mapper接口
 * 
 * @author zhl
 * @date 2025-05-06
 */
@Mapper
public interface ApsPlateStandardRequireBatchMapper 
{
    /**
     * æŸ¥è¯¢é’£é‡‘计划标准需求计划批次表
     * 
     * @param id é’£é‡‘计划标准需求计划批次表主键
     * @return é’£é‡‘计划标准需求计划批次表
     */
    public ApsPlateStandardRequireBatch selectApsPlateStandardRequireBatchById(Long id);

    /**
     * æŸ¥è¯¢é’£é‡‘计划标准需求计划批次表列表
     * 
     * @param apsPlateStandardRequireBatch é’£é‡‘计划标准需求计划批次表
     * @return é’£é‡‘计划标准需求计划批次表集合
     */
    public List<ApsPlateStandardRequireBatch> selectApsPlateStandardRequireBatchList(ApsPlateStandardRequireBatch apsPlateStandardRequireBatch);

    /**
     * æ–°å¢žé’£é‡‘计划标准需求计划批次表
     * 
     * @param apsPlateStandardRequireBatch é’£é‡‘计划标准需求计划批次表
     * @return ç»“æžœ
     */
    public int insertApsPlateStandardRequireBatch(ApsPlateStandardRequireBatch apsPlateStandardRequireBatch);

    /**
     * ä¿®æ”¹é’£é‡‘计划标准需求计划批次表
     * 
     * @param apsPlateStandardRequireBatch é’£é‡‘计划标准需求计划批次表
     * @return ç»“æžœ
     */
    public int updateApsPlateStandardRequireBatch(ApsPlateStandardRequireBatch apsPlateStandardRequireBatch);

    /**
     * åˆ é™¤é’£é‡‘计划标准需求计划批次表
     * 
     * @param id é’£é‡‘计划标准需求计划批次表主键
     * @return ç»“æžœ
     */
    public int deleteApsPlateStandardRequireBatchById(Long id);

    /**
     * æ‰¹é‡åˆ é™¤é’£é‡‘计划标准需求计划批次表
     * 
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteApsPlateStandardRequireBatchByIds(Long[] ids);
}

 aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsPlateStandardRequireBomOrderDetailMapper.java

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

import com.aps.core.domain.ApsPlateStandardRequireBomOrderDetail;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * ApsPlateStandardRequireBomOrderDetailMapper接口
 * 
 * @author zhl
 * @date 2025-05-06
 */
@Mapper
public interface ApsPlateStandardRequireBomOrderDetailMapper 
{
    /**
     * æŸ¥è¯¢ApsPlateStandardRequireBomOrderDetail
     * 
     * @param id ApsPlateStandardRequireBomOrderDetail主键
     * @return ApsPlateStandardRequireBomOrderDetail
     */
    public ApsPlateStandardRequireBomOrderDetail selectApsPlateStandardRequireBomOrderDetailById(Long id);

    /**
     * æŸ¥è¯¢ApsPlateStandardRequireBomOrderDetail列表
     * 
     * @param apsPlateStandardRequireBomOrderDetail ApsPlateStandardRequireBomOrderDetail
     * @return ApsPlateStandardRequireBomOrderDetail集合
     */
    public List<ApsPlateStandardRequireBomOrderDetail> selectApsPlateStandardRequireBomOrderDetailList(ApsPlateStandardRequireBomOrderDetail apsPlateStandardRequireBomOrderDetail);

    /**
     * æ–°å¢žApsPlateStandardRequireBomOrderDetail
     * 
     * @param apsPlateStandardRequireBomOrderDetail ApsPlateStandardRequireBomOrderDetail
     * @return ç»“æžœ
     */
    public int insertApsPlateStandardRequireBomOrderDetail(ApsPlateStandardRequireBomOrderDetail apsPlateStandardRequireBomOrderDetail);

    /**
     * ä¿®æ”¹ApsPlateStandardRequireBomOrderDetail
     * 
     * @param apsPlateStandardRequireBomOrderDetail ApsPlateStandardRequireBomOrderDetail
     * @return ç»“æžœ
     */
    public int updateApsPlateStandardRequireBomOrderDetail(ApsPlateStandardRequireBomOrderDetail apsPlateStandardRequireBomOrderDetail);

    /**
     * åˆ é™¤ApsPlateStandardRequireBomOrderDetail
     * 
     * @param id ApsPlateStandardRequireBomOrderDetail主键
     * @return ç»“æžœ
     */
    public int deleteApsPlateStandardRequireBomOrderDetailById(Long id);

    /**
     * æ‰¹é‡åˆ é™¤ApsPlateStandardRequireBomOrderDetail
     * 
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteApsPlateStandardRequireBomOrderDetailByIds(Long[] ids);
}

 aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsPlateStandardRequireBomStockDetailMapper.java

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

import java.util.List;
import com.aps.core.domain.ApsPlateStandardRequireBomStockDetail;
import org.apache.ibatis.annotations.Mapper;

/**
 * ApsPlateStandardRequireBomStockDetailMapper接口
 * 
 * @author zhl
 * &#064;date  2025-05-06
 */
@Mapper
public interface ApsPlateStandardRequireBomStockDetailMapper 
{
    /**
     * æŸ¥è¯¢ApsPlateStandardRequireBomStockDetail
     * 
     * @param id ApsPlateStandardRequireBomStockDetail主键
     * @return ApsPlateStandardRequireBomStockDetail
     */
    public ApsPlateStandardRequireBomStockDetail selectApsPlateStandardRequireBomStockDetailById(Long id);

    /**
     * æŸ¥è¯¢ApsPlateStandardRequireBomStockDetail列表
     * 
     * @param apsPlateStandardRequireBomStockDetail ApsPlateStandardRequireBomStockDetail
     * @return ApsPlateStandardRequireBomStockDetail集合
     */
    public List<ApsPlateStandardRequireBomStockDetail> selectApsPlateStandardRequireBomStockDetailList(ApsPlateStandardRequireBomStockDetail apsPlateStandardRequireBomStockDetail);

    /**
     * æ–°å¢žApsPlateStandardRequireBomStockDetail
     * 
     * @param apsPlateStandardRequireBomStockDetail ApsPlateStandardRequireBomStockDetail
     * @return ç»“æžœ
     */
    public int insertApsPlateStandardRequireBomStockDetail(ApsPlateStandardRequireBomStockDetail apsPlateStandardRequireBomStockDetail);

    /**
     * ä¿®æ”¹ApsPlateStandardRequireBomStockDetail
     * 
     * @param apsPlateStandardRequireBomStockDetail ApsPlateStandardRequireBomStockDetail
     * @return ç»“æžœ
     */
    public int updateApsPlateStandardRequireBomStockDetail(ApsPlateStandardRequireBomStockDetail apsPlateStandardRequireBomStockDetail);

    /**
     * åˆ é™¤ApsPlateStandardRequireBomStockDetail
     * 
     * @param id ApsPlateStandardRequireBomStockDetail主键
     * @return ç»“æžœ
     */
    public int deleteApsPlateStandardRequireBomStockDetailById(Long id);

    /**
     * æ‰¹é‡åˆ é™¤ApsPlateStandardRequireBomStockDetail
     * 
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteApsPlateStandardRequireBomStockDetailByIds(Long[] ids);
}

 aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsPlateStandardRequireMapper.java

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

import java.util.List;
import com.aps.core.domain.ApsPlateStandardRequire;
import org.apache.ibatis.annotations.Mapper;

/**
 * é’£é‡‘工单标准需求Mapper接口
 * 
 * @author zhl
 * @date 2025-05-06
 */
@Mapper
public interface ApsPlateStandardRequireMapper 
{
    /**
     * æŸ¥è¯¢é’£é‡‘工单标准需求
     * 
     * @param id é’£é‡‘工单标准需求主键
     * @return é’£é‡‘工单标准需求
     */
    public ApsPlateStandardRequire selectApsPlateStandardRequireById(Long id);

    /**
     * æŸ¥è¯¢é’£é‡‘工单标准需求列表
     * 
     * @param apsPlateStandardRequire é’£é‡‘工单标准需求
     * @return é’£é‡‘工单标准需求集合
     */
    public List<ApsPlateStandardRequire> selectApsPlateStandardRequireList(ApsPlateStandardRequire apsPlateStandardRequire);

    /**
     * æ–°å¢žé’£é‡‘工单标准需求
     * 
     * @param apsPlateStandardRequire é’£é‡‘工单标准需求
     * @return ç»“æžœ
     */
    public int insertApsPlateStandardRequire(ApsPlateStandardRequire apsPlateStandardRequire);

    /**
     * ä¿®æ”¹é’£é‡‘工单标准需求
     * 
     * @param apsPlateStandardRequire é’£é‡‘工单标准需求
     * @return ç»“æžœ
     */
    public int updateApsPlateStandardRequire(ApsPlateStandardRequire apsPlateStandardRequire);

    /**
     * åˆ é™¤é’£é‡‘工单标准需求
     * 
     * @param id é’£é‡‘工单标准需求主键
     * @return ç»“æžœ
     */
    public int deleteApsPlateStandardRequireById(Long id);

    /**
     * æ‰¹é‡åˆ é™¤é’£é‡‘工单标准需求
     * 
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteApsPlateStandardRequireByIds(Long[] ids);
}

 aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPlateStandardRequireBatchService.java

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

import java.util.List;
import com.aps.core.domain.ApsPlateStandardRequireBatch;

/**
 * é’£é‡‘计划标准需求计划批次表Service接口
 * 
 * @author zhl
 * @date 2025-05-06
 */
public interface IApsPlateStandardRequireBatchService 
{
    /**
     * æŸ¥è¯¢é’£é‡‘计划标准需求计划批次表
     * 
     * @param id é’£é‡‘计划标准需求计划批次表主键
     * @return é’£é‡‘计划标准需求计划批次表
     */
    public ApsPlateStandardRequireBatch selectApsPlateStandardRequireBatchById(Long id);

    /**
     * æŸ¥è¯¢é’£é‡‘计划标准需求计划批次表列表
     * 
     * @param apsPlateStandardRequireBatch é’£é‡‘计划标准需求计划批次表
     * @return é’£é‡‘计划标准需求计划批次表集合
     */
    public List<ApsPlateStandardRequireBatch> selectApsPlateStandardRequireBatchList(ApsPlateStandardRequireBatch apsPlateStandardRequireBatch);

    /**
     * æ–°å¢žé’£é‡‘计划标准需求计划批次表
     * 
     * @param apsPlateStandardRequireBatch é’£é‡‘计划标准需求计划批次表
     * @return ç»“æžœ
     */
    public int insertApsPlateStandardRequireBatch(ApsPlateStandardRequireBatch apsPlateStandardRequireBatch);

    /**
     * ä¿®æ”¹é’£é‡‘计划标准需求计划批次表
     * 
     * @param apsPlateStandardRequireBatch é’£é‡‘计划标准需求计划批次表
     * @return ç»“æžœ
     */
    public int updateApsPlateStandardRequireBatch(ApsPlateStandardRequireBatch apsPlateStandardRequireBatch);

    /**
     * æ‰¹é‡åˆ é™¤é’£é‡‘计划标准需求计划批次表
     * 
     * @param ids éœ€è¦åˆ é™¤çš„钣金计划标准需求计划批次表主键集合
     * @return ç»“æžœ
     */
    public int deleteApsPlateStandardRequireBatchByIds(Long[] ids);

    /**
     * åˆ é™¤é’£é‡‘计划标准需求计划批次表信息
     * 
     * @param id é’£é‡‘计划标准需求计划批次表主键
     * @return ç»“æžœ
     */
    public int deleteApsPlateStandardRequireBatchById(Long id);
}

 aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPlateStandardRequireBomOrderDetailService.java

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

import java.util.List;
import com.aps.core.domain.ApsPlateStandardRequireBomOrderDetail;

/**
 * ApsPlateStandardRequireBomOrderDetailService接口
 * 
 * @author zhl
 * @date 2025-05-06
 */
public interface IApsPlateStandardRequireBomOrderDetailService 
{
    /**
     * æŸ¥è¯¢ApsPlateStandardRequireBomOrderDetail
     * 
     * @param id ApsPlateStandardRequireBomOrderDetail主键
     * @return ApsPlateStandardRequireBomOrderDetail
     */
    public ApsPlateStandardRequireBomOrderDetail selectApsPlateStandardRequireBomOrderDetailById(Long id);

    /**
     * æŸ¥è¯¢ApsPlateStandardRequireBomOrderDetail列表
     * 
     * @param apsPlateStandardRequireBomOrderDetail ApsPlateStandardRequireBomOrderDetail
     * @return ApsPlateStandardRequireBomOrderDetail集合
     */
    public List<ApsPlateStandardRequireBomOrderDetail> selectApsPlateStandardRequireBomOrderDetailList(ApsPlateStandardRequireBomOrderDetail apsPlateStandardRequireBomOrderDetail);

    /**
     * æ–°å¢žApsPlateStandardRequireBomOrderDetail
     * 
     * @param apsPlateStandardRequireBomOrderDetail ApsPlateStandardRequireBomOrderDetail
     * @return ç»“æžœ
     */
    public int insertApsPlateStandardRequireBomOrderDetail(ApsPlateStandardRequireBomOrderDetail apsPlateStandardRequireBomOrderDetail);

    /**
     * ä¿®æ”¹ApsPlateStandardRequireBomOrderDetail
     * 
     * @param apsPlateStandardRequireBomOrderDetail ApsPlateStandardRequireBomOrderDetail
     * @return ç»“æžœ
     */
    public int updateApsPlateStandardRequireBomOrderDetail(ApsPlateStandardRequireBomOrderDetail apsPlateStandardRequireBomOrderDetail);

    /**
     * æ‰¹é‡åˆ é™¤ApsPlateStandardRequireBomOrderDetail
     * 
     * @param ids éœ€è¦åˆ é™¤çš„ApsPlateStandardRequireBomOrderDetail主键集合
     * @return ç»“æžœ
     */
    public int deleteApsPlateStandardRequireBomOrderDetailByIds(Long[] ids);

    /**
     * åˆ é™¤ApsPlateStandardRequireBomOrderDetail信息
     * 
     * @param id ApsPlateStandardRequireBomOrderDetail主键
     * @return ç»“æžœ
     */
    public int deleteApsPlateStandardRequireBomOrderDetailById(Long id);
}

 aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPlateStandardRequireBomStockDetailService.java

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

import java.util.List;
import com.aps.core.domain.ApsPlateStandardRequireBomStockDetail;

/**
 * ApsPlateStandardRequireBomStockDetailService接口
 * 
 * @author zhl
 * @date 2025-05-06
 */
public interface IApsPlateStandardRequireBomStockDetailService 
{
    /**
     * æŸ¥è¯¢ApsPlateStandardRequireBomStockDetail
     * 
     * @param id ApsPlateStandardRequireBomStockDetail主键
     * @return ApsPlateStandardRequireBomStockDetail
     */
    public ApsPlateStandardRequireBomStockDetail selectApsPlateStandardRequireBomStockDetailById(Long id);

    /**
     * æŸ¥è¯¢ApsPlateStandardRequireBomStockDetail列表
     * 
     * @param apsPlateStandardRequireBomStockDetail ApsPlateStandardRequireBomStockDetail
     * @return ApsPlateStandardRequireBomStockDetail集合
     */
    public List<ApsPlateStandardRequireBomStockDetail> selectApsPlateStandardRequireBomStockDetailList(ApsPlateStandardRequireBomStockDetail apsPlateStandardRequireBomStockDetail);

    /**
     * æ–°å¢žApsPlateStandardRequireBomStockDetail
     * 
     * @param apsPlateStandardRequireBomStockDetail ApsPlateStandardRequireBomStockDetail
     * @return ç»“æžœ
     */
    public int insertApsPlateStandardRequireBomStockDetail(ApsPlateStandardRequireBomStockDetail apsPlateStandardRequireBomStockDetail);

    /**
     * ä¿®æ”¹ApsPlateStandardRequireBomStockDetail
     * 
     * @param apsPlateStandardRequireBomStockDetail ApsPlateStandardRequireBomStockDetail
     * @return ç»“æžœ
     */
    public int updateApsPlateStandardRequireBomStockDetail(ApsPlateStandardRequireBomStockDetail apsPlateStandardRequireBomStockDetail);

    /**
     * æ‰¹é‡åˆ é™¤ApsPlateStandardRequireBomStockDetail
     * 
     * @param ids éœ€è¦åˆ é™¤çš„ApsPlateStandardRequireBomStockDetail主键集合
     * @return ç»“æžœ
     */
    public int deleteApsPlateStandardRequireBomStockDetailByIds(Long[] ids);

    /**
     * åˆ é™¤ApsPlateStandardRequireBomStockDetail信息
     * 
     * @param id ApsPlateStandardRequireBomStockDetail主键
     * @return ç»“æžœ
     */
    public int deleteApsPlateStandardRequireBomStockDetailById(Long id);
}

 aps-modules/aps-core/src/main/java/com/aps/core/service/IApsPlateStandardRequireService.java

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

import java.util.List;
import com.aps.core.domain.ApsPlateStandardRequire;

/**
 * é’£é‡‘工单标准需求Service接口
 * 
 * @author zhl
 * @date 2025-05-06
 */
public interface IApsPlateStandardRequireService 
{
    /**
     * æŸ¥è¯¢é’£é‡‘工单标准需求
     * 
     * @param id é’£é‡‘工单标准需求主键
     * @return é’£é‡‘工单标准需求
     */
    public ApsPlateStandardRequire selectApsPlateStandardRequireById(Long id);

    /**
     * æŸ¥è¯¢é’£é‡‘工单标准需求列表
     * 
     * @param apsPlateStandardRequire é’£é‡‘工单标准需求
     * @return é’£é‡‘工单标准需求集合
     */
    public List<ApsPlateStandardRequire> selectApsPlateStandardRequireList(ApsPlateStandardRequire apsPlateStandardRequire);

    /**
     * æ–°å¢žé’£é‡‘工单标准需求
     * 
     * @param apsPlateStandardRequire é’£é‡‘工单标准需求
     * @return ç»“æžœ
     */
    public int insertApsPlateStandardRequire(ApsPlateStandardRequire apsPlateStandardRequire);

    /**
     * ä¿®æ”¹é’£é‡‘工单标准需求
     * 
     * @param apsPlateStandardRequire é’£é‡‘工单标准需求
     * @return ç»“æžœ
     */
    public int updateApsPlateStandardRequire(ApsPlateStandardRequire apsPlateStandardRequire);

    /**
     * æ‰¹é‡åˆ é™¤é’£é‡‘工单标准需求
     * 
     * @param ids éœ€è¦åˆ é™¤çš„钣金工单标准需求主键集合
     * @return ç»“æžœ
     */
    public int deleteApsPlateStandardRequireByIds(Long[] ids);

    /**
     * åˆ é™¤é’£é‡‘工单标准需求信息
     * 
     * @param id é’£é‡‘工单标准需求主键
     * @return ç»“æžœ
     */
    public int deleteApsPlateStandardRequireById(Long id);
}

 aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlateStandardRequireBatchServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,96 @@
package com.aps.core.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.core.mapper.ApsPlateStandardRequireBatchMapper;
import com.aps.core.domain.ApsPlateStandardRequireBatch;
import com.aps.core.service.IApsPlateStandardRequireBatchService;

/**
 * é’£é‡‘计划标准需求计划批次表Service业务层处理
 * 
 * @author zhl
 * @date 2025-05-06
 */
@Service
public class ApsPlateStandardRequireBatchServiceImpl implements IApsPlateStandardRequireBatchService 
{
    @Autowired
    private ApsPlateStandardRequireBatchMapper apsPlateStandardRequireBatchMapper;

    /**
     * æŸ¥è¯¢é’£é‡‘计划标准需求计划批次表
     * 
     * @param id é’£é‡‘计划标准需求计划批次表主键
     * @return é’£é‡‘计划标准需求计划批次表
     */
    @Override
    public ApsPlateStandardRequireBatch selectApsPlateStandardRequireBatchById(Long id)
    {
        return apsPlateStandardRequireBatchMapper.selectApsPlateStandardRequireBatchById(id);
    }

    /**
     * æŸ¥è¯¢é’£é‡‘计划标准需求计划批次表列表
     * 
     * @param apsPlateStandardRequireBatch é’£é‡‘计划标准需求计划批次表
     * @return é’£é‡‘计划标准需求计划批次表
     */
    @Override
    public List<ApsPlateStandardRequireBatch> selectApsPlateStandardRequireBatchList(ApsPlateStandardRequireBatch apsPlateStandardRequireBatch)
    {
        return apsPlateStandardRequireBatchMapper.selectApsPlateStandardRequireBatchList(apsPlateStandardRequireBatch);
    }

    /**
     * æ–°å¢žé’£é‡‘计划标准需求计划批次表
     * 
     * @param apsPlateStandardRequireBatch é’£é‡‘计划标准需求计划批次表
     * @return ç»“æžœ
     */
    @Override
    public int insertApsPlateStandardRequireBatch(ApsPlateStandardRequireBatch apsPlateStandardRequireBatch)
    {
        apsPlateStandardRequireBatch.setCreateTime(DateUtils.getNowDate());
        return apsPlateStandardRequireBatchMapper.insertApsPlateStandardRequireBatch(apsPlateStandardRequireBatch);
    }

    /**
     * ä¿®æ”¹é’£é‡‘计划标准需求计划批次表
     * 
     * @param apsPlateStandardRequireBatch é’£é‡‘计划标准需求计划批次表
     * @return ç»“æžœ
     */
    @Override
    public int updateApsPlateStandardRequireBatch(ApsPlateStandardRequireBatch apsPlateStandardRequireBatch)
    {
        apsPlateStandardRequireBatch.setUpdateTime(DateUtils.getNowDate());
        return apsPlateStandardRequireBatchMapper.updateApsPlateStandardRequireBatch(apsPlateStandardRequireBatch);
    }

    /**
     * æ‰¹é‡åˆ é™¤é’£é‡‘计划标准需求计划批次表
     * 
     * @param ids éœ€è¦åˆ é™¤çš„钣金计划标准需求计划批次表主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsPlateStandardRequireBatchByIds(Long[] ids)
    {
        return apsPlateStandardRequireBatchMapper.deleteApsPlateStandardRequireBatchByIds(ids);
    }

    /**
     * åˆ é™¤é’£é‡‘计划标准需求计划批次表信息
     * 
     * @param id é’£é‡‘计划标准需求计划批次表主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsPlateStandardRequireBatchById(Long id)
    {
        return apsPlateStandardRequireBatchMapper.deleteApsPlateStandardRequireBatchById(id);
    }
}

 aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlateStandardRequireBomOrderDetailServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,96 @@
package com.aps.core.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.core.mapper.ApsPlateStandardRequireBomOrderDetailMapper;
import com.aps.core.domain.ApsPlateStandardRequireBomOrderDetail;
import com.aps.core.service.IApsPlateStandardRequireBomOrderDetailService;

/**
 * ApsPlateStandardRequireBomOrderDetailService业务层处理
 * 
 * @author zhl
 * @date 2025-05-06
 */
@Service
public class ApsPlateStandardRequireBomOrderDetailServiceImpl implements IApsPlateStandardRequireBomOrderDetailService 
{
    @Autowired
    private ApsPlateStandardRequireBomOrderDetailMapper apsPlateStandardRequireBomOrderDetailMapper;

    /**
     * æŸ¥è¯¢ApsPlateStandardRequireBomOrderDetail
     * 
     * @param id ApsPlateStandardRequireBomOrderDetail主键
     * @return ApsPlateStandardRequireBomOrderDetail
     */
    @Override
    public ApsPlateStandardRequireBomOrderDetail selectApsPlateStandardRequireBomOrderDetailById(Long id)
    {
        return apsPlateStandardRequireBomOrderDetailMapper.selectApsPlateStandardRequireBomOrderDetailById(id);
    }

    /**
     * æŸ¥è¯¢ApsPlateStandardRequireBomOrderDetail列表
     * 
     * @param apsPlateStandardRequireBomOrderDetail ApsPlateStandardRequireBomOrderDetail
     * @return ApsPlateStandardRequireBomOrderDetail
     */
    @Override
    public List<ApsPlateStandardRequireBomOrderDetail> selectApsPlateStandardRequireBomOrderDetailList(ApsPlateStandardRequireBomOrderDetail apsPlateStandardRequireBomOrderDetail)
    {
        return apsPlateStandardRequireBomOrderDetailMapper.selectApsPlateStandardRequireBomOrderDetailList(apsPlateStandardRequireBomOrderDetail);
    }

    /**
     * æ–°å¢žApsPlateStandardRequireBomOrderDetail
     * 
     * @param apsPlateStandardRequireBomOrderDetail ApsPlateStandardRequireBomOrderDetail
     * @return ç»“æžœ
     */
    @Override
    public int insertApsPlateStandardRequireBomOrderDetail(ApsPlateStandardRequireBomOrderDetail apsPlateStandardRequireBomOrderDetail)
    {
        apsPlateStandardRequireBomOrderDetail.setCreateTime(DateUtils.getNowDate());
        return apsPlateStandardRequireBomOrderDetailMapper.insertApsPlateStandardRequireBomOrderDetail(apsPlateStandardRequireBomOrderDetail);
    }

    /**
     * ä¿®æ”¹ApsPlateStandardRequireBomOrderDetail
     * 
     * @param apsPlateStandardRequireBomOrderDetail ApsPlateStandardRequireBomOrderDetail
     * @return ç»“æžœ
     */
    @Override
    public int updateApsPlateStandardRequireBomOrderDetail(ApsPlateStandardRequireBomOrderDetail apsPlateStandardRequireBomOrderDetail)
    {
        apsPlateStandardRequireBomOrderDetail.setUpdateTime(DateUtils.getNowDate());
        return apsPlateStandardRequireBomOrderDetailMapper.updateApsPlateStandardRequireBomOrderDetail(apsPlateStandardRequireBomOrderDetail);
    }

    /**
     * æ‰¹é‡åˆ é™¤ApsPlateStandardRequireBomOrderDetail
     * 
     * @param ids éœ€è¦åˆ é™¤çš„ApsPlateStandardRequireBomOrderDetail主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsPlateStandardRequireBomOrderDetailByIds(Long[] ids)
    {
        return apsPlateStandardRequireBomOrderDetailMapper.deleteApsPlateStandardRequireBomOrderDetailByIds(ids);
    }

    /**
     * åˆ é™¤ApsPlateStandardRequireBomOrderDetail信息
     * 
     * @param id ApsPlateStandardRequireBomOrderDetail主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsPlateStandardRequireBomOrderDetailById(Long id)
    {
        return apsPlateStandardRequireBomOrderDetailMapper.deleteApsPlateStandardRequireBomOrderDetailById(id);
    }
}

 aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlateStandardRequireBomStockDetailServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,96 @@
package com.aps.core.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.core.mapper.ApsPlateStandardRequireBomStockDetailMapper;
import com.aps.core.domain.ApsPlateStandardRequireBomStockDetail;
import com.aps.core.service.IApsPlateStandardRequireBomStockDetailService;

/**
 * ApsPlateStandardRequireBomStockDetailService业务层处理
 * 
 * @author zhl
 * @date 2025-05-06
 */
@Service
public class ApsPlateStandardRequireBomStockDetailServiceImpl implements IApsPlateStandardRequireBomStockDetailService 
{
    @Autowired
    private ApsPlateStandardRequireBomStockDetailMapper apsPlateStandardRequireBomStockDetailMapper;

    /**
     * æŸ¥è¯¢ApsPlateStandardRequireBomStockDetail
     * 
     * @param id ApsPlateStandardRequireBomStockDetail主键
     * @return ApsPlateStandardRequireBomStockDetail
     */
    @Override
    public ApsPlateStandardRequireBomStockDetail selectApsPlateStandardRequireBomStockDetailById(Long id)
    {
        return apsPlateStandardRequireBomStockDetailMapper.selectApsPlateStandardRequireBomStockDetailById(id);
    }

    /**
     * æŸ¥è¯¢ApsPlateStandardRequireBomStockDetail列表
     * 
     * @param apsPlateStandardRequireBomStockDetail ApsPlateStandardRequireBomStockDetail
     * @return ApsPlateStandardRequireBomStockDetail
     */
    @Override
    public List<ApsPlateStandardRequireBomStockDetail> selectApsPlateStandardRequireBomStockDetailList(ApsPlateStandardRequireBomStockDetail apsPlateStandardRequireBomStockDetail)
    {
        return apsPlateStandardRequireBomStockDetailMapper.selectApsPlateStandardRequireBomStockDetailList(apsPlateStandardRequireBomStockDetail);
    }

    /**
     * æ–°å¢žApsPlateStandardRequireBomStockDetail
     * 
     * @param apsPlateStandardRequireBomStockDetail ApsPlateStandardRequireBomStockDetail
     * @return ç»“æžœ
     */
    @Override
    public int insertApsPlateStandardRequireBomStockDetail(ApsPlateStandardRequireBomStockDetail apsPlateStandardRequireBomStockDetail)
    {
        apsPlateStandardRequireBomStockDetail.setCreateTime(DateUtils.getNowDate());
        return apsPlateStandardRequireBomStockDetailMapper.insertApsPlateStandardRequireBomStockDetail(apsPlateStandardRequireBomStockDetail);
    }

    /**
     * ä¿®æ”¹ApsPlateStandardRequireBomStockDetail
     * 
     * @param apsPlateStandardRequireBomStockDetail ApsPlateStandardRequireBomStockDetail
     * @return ç»“æžœ
     */
    @Override
    public int updateApsPlateStandardRequireBomStockDetail(ApsPlateStandardRequireBomStockDetail apsPlateStandardRequireBomStockDetail)
    {
        apsPlateStandardRequireBomStockDetail.setUpdateTime(DateUtils.getNowDate());
        return apsPlateStandardRequireBomStockDetailMapper.updateApsPlateStandardRequireBomStockDetail(apsPlateStandardRequireBomStockDetail);
    }

    /**
     * æ‰¹é‡åˆ é™¤ApsPlateStandardRequireBomStockDetail
     * 
     * @param ids éœ€è¦åˆ é™¤çš„ApsPlateStandardRequireBomStockDetail主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsPlateStandardRequireBomStockDetailByIds(Long[] ids)
    {
        return apsPlateStandardRequireBomStockDetailMapper.deleteApsPlateStandardRequireBomStockDetailByIds(ids);
    }

    /**
     * åˆ é™¤ApsPlateStandardRequireBomStockDetail信息
     * 
     * @param id ApsPlateStandardRequireBomStockDetail主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsPlateStandardRequireBomStockDetailById(Long id)
    {
        return apsPlateStandardRequireBomStockDetailMapper.deleteApsPlateStandardRequireBomStockDetailById(id);
    }
}

 aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlateStandardRequireServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,96 @@
package com.aps.core.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.core.mapper.ApsPlateStandardRequireMapper;
import com.aps.core.domain.ApsPlateStandardRequire;
import com.aps.core.service.IApsPlateStandardRequireService;

/**
 * é’£é‡‘工单标准需求Service业务层处理
 * 
 * @author zhl
 * @date 2025-05-06
 */
@Service
public class ApsPlateStandardRequireServiceImpl implements IApsPlateStandardRequireService 
{
    @Autowired
    private ApsPlateStandardRequireMapper apsPlateStandardRequireMapper;

    /**
     * æŸ¥è¯¢é’£é‡‘工单标准需求
     * 
     * @param id é’£é‡‘工单标准需求主键
     * @return é’£é‡‘工单标准需求
     */
    @Override
    public ApsPlateStandardRequire selectApsPlateStandardRequireById(Long id)
    {
        return apsPlateStandardRequireMapper.selectApsPlateStandardRequireById(id);
    }

    /**
     * æŸ¥è¯¢é’£é‡‘工单标准需求列表
     * 
     * @param apsPlateStandardRequire é’£é‡‘工单标准需求
     * @return é’£é‡‘工单标准需求
     */
    @Override
    public List<ApsPlateStandardRequire> selectApsPlateStandardRequireList(ApsPlateStandardRequire apsPlateStandardRequire)
    {
        return apsPlateStandardRequireMapper.selectApsPlateStandardRequireList(apsPlateStandardRequire);
    }

    /**
     * æ–°å¢žé’£é‡‘工单标准需求
     * 
     * @param apsPlateStandardRequire é’£é‡‘工单标准需求
     * @return ç»“æžœ
     */
    @Override
    public int insertApsPlateStandardRequire(ApsPlateStandardRequire apsPlateStandardRequire)
    {
        apsPlateStandardRequire.setCreateTime(DateUtils.getNowDate());
        return apsPlateStandardRequireMapper.insertApsPlateStandardRequire(apsPlateStandardRequire);
    }

    /**
     * ä¿®æ”¹é’£é‡‘工单标准需求
     * 
     * @param apsPlateStandardRequire é’£é‡‘工单标准需求
     * @return ç»“æžœ
     */
    @Override
    public int updateApsPlateStandardRequire(ApsPlateStandardRequire apsPlateStandardRequire)
    {
        apsPlateStandardRequire.setUpdateTime(DateUtils.getNowDate());
        return apsPlateStandardRequireMapper.updateApsPlateStandardRequire(apsPlateStandardRequire);
    }

    /**
     * æ‰¹é‡åˆ é™¤é’£é‡‘工单标准需求
     * 
     * @param ids éœ€è¦åˆ é™¤çš„钣金工单标准需求主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsPlateStandardRequireByIds(Long[] ids)
    {
        return apsPlateStandardRequireMapper.deleteApsPlateStandardRequireByIds(ids);
    }

    /**
     * åˆ é™¤é’£é‡‘工单标准需求信息
     * 
     * @param id é’£é‡‘工单标准需求主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsPlateStandardRequireById(Long id)
    {
        return apsPlateStandardRequireMapper.deleteApsPlateStandardRequireById(id);
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,78 @@
<?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.core.mapper.ApsPlateStandardRequireBatchMapper">
    
    <resultMap type="ApsPlateStandardRequireBatch" id="ApsPlateStandardRequireBatchResult">
        <result property="id"    column="id"    />
        <result property="batchNumber"    column="batch_number"    />
        <result property="delFlag"    column="del_flag"    />
        <result property="createTime"    column="create_time"    />
        <result property="createBy"    column="create_by"    />
        <result property="updateBy"    column="update_by"    />
        <result property="updateTime"    column="update_time"    />
    </resultMap>

    <sql id="selectApsPlateStandardRequireBatchVo">
        select id, batch_number, del_flag, create_time, create_by, update_by, update_time from aps_plate_standard_require_batch
    </sql>

    <select id="selectApsPlateStandardRequireBatchList" parameterType="ApsPlateStandardRequireBatch" resultMap="ApsPlateStandardRequireBatchResult">
        <include refid="selectApsPlateStandardRequireBatchVo"/>
        <where>  
            <if test="batchNumber != null  and batchNumber != ''"> and batch_number = #{batchNumber}</if>
        </where>
    </select>
    
    <select id="selectApsPlateStandardRequireBatchById" parameterType="Long" resultMap="ApsPlateStandardRequireBatchResult">
        <include refid="selectApsPlateStandardRequireBatchVo"/>
        where id = #{id}
    </select>

    <insert id="insertApsPlateStandardRequireBatch" parameterType="ApsPlateStandardRequireBatch">
        insert into aps_plate_standard_require_batch
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
            <if test="batchNumber != null">batch_number,</if>
            <if test="delFlag != null">del_flag,</if>
            <if test="createTime != null">create_time,</if>
            <if test="createBy != null">create_by,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="batchNumber != null">#{batchNumber},</if>
            <if test="delFlag != null">#{delFlag},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
         </trim>
    </insert>

    <update id="updateApsPlateStandardRequireBatch" parameterType="ApsPlateStandardRequireBatch">
        update aps_plate_standard_require_batch
        <trim prefix="SET" suffixOverrides=",">
            <if test="batchNumber != null">batch_number = #{batchNumber},</if>
            <if test="delFlag != null">del_flag = #{delFlag},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteApsPlateStandardRequireBatchById" parameterType="Long">
        delete from aps_plate_standard_require_batch where id = #{id}
    </delete>

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

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,118 @@
<?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.core.mapper.ApsPlateStandardRequireBomOrderDetailMapper">
    
    <resultMap type="ApsPlateStandardRequireBomOrderDetail" id="ApsPlateStandardRequireBomOrderDetailResult">
        <result property="id"    column="id"    />
        <result property="requireId"    column="require_id"    />
        <result property="bomLineId"    column="bom_line_id"    />
        <result property="bomLineCode"    column="bom_line_code"    />
        <result property="docNo"    column="doc_no"    />
        <result property="beforeProdAmount"    column="before_prod_amount"    />
        <result property="deductionAmount"    column="deduction_amount"    />
        <result property="afterProdAmount"    column="after_prod_amount"    />
        <result property="orgCode"    column="org_code"    />
        <result property="batchNumber"    column="batch_number"    />
        <result property="delFlag"    column="del_flag"    />
        <result property="createTime"    column="create_time"    />
        <result property="createBy"    column="create_by"    />
        <result property="updateBy"    column="update_by"    />
        <result property="updateTime"    column="update_time"    />
    </resultMap>

    <sql id="selectApsPlateStandardRequireBomOrderDetailVo">
        select id, require_id, bom_line_id, bom_line_code, doc_no, before_prod_amount, deduction_amount, after_prod_amount, org_code, batch_number, del_flag, create_time, create_by, update_by, update_time from aps_plate_standard_require_bom_order_detail
    </sql>

    <select id="selectApsPlateStandardRequireBomOrderDetailList" parameterType="ApsPlateStandardRequireBomOrderDetail" resultMap="ApsPlateStandardRequireBomOrderDetailResult">
        <include refid="selectApsPlateStandardRequireBomOrderDetailVo"/>
        <where>  
            <if test="requireId != null  and requireId != ''"> and require_id = #{requireId}</if>
            <if test="bomLineId != null  and bomLineId != ''"> and bom_line_id = #{bomLineId}</if>
            <if test="bomLineCode != null  and bomLineCode != ''"> and bom_line_code = #{bomLineCode}</if>
            <if test="docNo != null  and docNo != ''"> and doc_no = #{docNo}</if>
            <if test="beforeProdAmount != null  and beforeProdAmount != ''"> and before_prod_amount = #{beforeProdAmount}</if>
            <if test="deductionAmount != null  and deductionAmount != ''"> and deduction_amount = #{deductionAmount}</if>
            <if test="afterProdAmount != null  and afterProdAmount != ''"> and after_prod_amount = #{afterProdAmount}</if>
            <if test="orgCode != null  and orgCode != ''"> and org_code = #{orgCode}</if>
            <if test="batchNumber != null  and batchNumber != ''"> and batch_number = #{batchNumber}</if>
        </where>
    </select>
    
    <select id="selectApsPlateStandardRequireBomOrderDetailById" parameterType="Long" resultMap="ApsPlateStandardRequireBomOrderDetailResult">
        <include refid="selectApsPlateStandardRequireBomOrderDetailVo"/>
        where id = #{id}
    </select>

    <insert id="insertApsPlateStandardRequireBomOrderDetail" parameterType="ApsPlateStandardRequireBomOrderDetail">
        insert into aps_plate_standard_require_bom_order_detail
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
            <if test="requireId != null">require_id,</if>
            <if test="bomLineId != null">bom_line_id,</if>
            <if test="bomLineCode != null">bom_line_code,</if>
            <if test="docNo != null">doc_no,</if>
            <if test="beforeProdAmount != null">before_prod_amount,</if>
            <if test="deductionAmount != null">deduction_amount,</if>
            <if test="afterProdAmount != null">after_prod_amount,</if>
            <if test="orgCode != null">org_code,</if>
            <if test="batchNumber != null">batch_number,</if>
            <if test="delFlag != null">del_flag,</if>
            <if test="createTime != null">create_time,</if>
            <if test="createBy != null">create_by,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="requireId != null">#{requireId},</if>
            <if test="bomLineId != null">#{bomLineId},</if>
            <if test="bomLineCode != null">#{bomLineCode},</if>
            <if test="docNo != null">#{docNo},</if>
            <if test="beforeProdAmount != null">#{beforeProdAmount},</if>
            <if test="deductionAmount != null">#{deductionAmount},</if>
            <if test="afterProdAmount != null">#{afterProdAmount},</if>
            <if test="orgCode != null">#{orgCode},</if>
            <if test="batchNumber != null">#{batchNumber},</if>
            <if test="delFlag != null">#{delFlag},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
         </trim>
    </insert>

    <update id="updateApsPlateStandardRequireBomOrderDetail" parameterType="ApsPlateStandardRequireBomOrderDetail">
        update aps_plate_standard_require_bom_order_detail
        <trim prefix="SET" suffixOverrides=",">
            <if test="requireId != null">require_id = #{requireId},</if>
            <if test="bomLineId != null">bom_line_id = #{bomLineId},</if>
            <if test="bomLineCode != null">bom_line_code = #{bomLineCode},</if>
            <if test="docNo != null">doc_no = #{docNo},</if>
            <if test="beforeProdAmount != null">before_prod_amount = #{beforeProdAmount},</if>
            <if test="deductionAmount != null">deduction_amount = #{deductionAmount},</if>
            <if test="afterProdAmount != null">after_prod_amount = #{afterProdAmount},</if>
            <if test="orgCode != null">org_code = #{orgCode},</if>
            <if test="batchNumber != null">batch_number = #{batchNumber},</if>
            <if test="delFlag != null">del_flag = #{delFlag},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteApsPlateStandardRequireBomOrderDetailById" parameterType="Long">
        delete from aps_plate_standard_require_bom_order_detail where id = #{id}
    </delete>

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

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,113 @@
<?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.core.mapper.ApsPlateStandardRequireBomStockDetailMapper">
    
    <resultMap type="ApsPlateStandardRequireBomStockDetail" id="ApsPlateStandardRequireBomStockDetailResult">
        <result property="id"    column="id"    />
        <result property="requireId"    column="require_id"    />
        <result property="bomLineId"    column="bom_line_id"    />
        <result property="bomLineCode"    column="bom_line_code"    />
        <result property="beforeStockAmount"    column="before_stock_amount"    />
        <result property="deductionAmount"    column="deduction_amount"    />
        <result property="afterStockAmount"    column="after_stock_amount"    />
        <result property="orgCode"    column="org_code"    />
        <result property="batchNumber"    column="batch_number"    />
        <result property="delFlag"    column="del_flag"    />
        <result property="createTime"    column="create_time"    />
        <result property="createBy"    column="create_by"    />
        <result property="updateBy"    column="update_by"    />
        <result property="updateTime"    column="update_time"    />
    </resultMap>

    <sql id="selectApsPlateStandardRequireBomStockDetailVo">
        select id, require_id, bom_line_id, bom_line_code, before_stock_amount, deduction_amount, after_stock_amount, org_code, batch_number, del_flag, create_time, create_by, update_by, update_time from aps_plate_standard_require_bom_stock_detail
    </sql>

    <select id="selectApsPlateStandardRequireBomStockDetailList" parameterType="ApsPlateStandardRequireBomStockDetail" resultMap="ApsPlateStandardRequireBomStockDetailResult">
        <include refid="selectApsPlateStandardRequireBomStockDetailVo"/>
        <where>  
            <if test="requireId != null  and requireId != ''"> and require_id = #{requireId}</if>
            <if test="bomLineId != null  and bomLineId != ''"> and bom_line_id = #{bomLineId}</if>
            <if test="bomLineCode != null  and bomLineCode != ''"> and bom_line_code = #{bomLineCode}</if>
            <if test="beforeStockAmount != null  and beforeStockAmount != ''"> and before_stock_amount = #{beforeStockAmount}</if>
            <if test="deductionAmount != null  and deductionAmount != ''"> and deduction_amount = #{deductionAmount}</if>
            <if test="afterStockAmount != null  and afterStockAmount != ''"> and after_stock_amount = #{afterStockAmount}</if>
            <if test="orgCode != null  and orgCode != ''"> and org_code = #{orgCode}</if>
            <if test="batchNumber != null  and batchNumber != ''"> and batch_number = #{batchNumber}</if>
        </where>
    </select>
    
    <select id="selectApsPlateStandardRequireBomStockDetailById" parameterType="Long" resultMap="ApsPlateStandardRequireBomStockDetailResult">
        <include refid="selectApsPlateStandardRequireBomStockDetailVo"/>
        where id = #{id}
    </select>

    <insert id="insertApsPlateStandardRequireBomStockDetail" parameterType="ApsPlateStandardRequireBomStockDetail">
        insert into aps_plate_standard_require_bom_stock_detail
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
            <if test="requireId != null">require_id,</if>
            <if test="bomLineId != null">bom_line_id,</if>
            <if test="bomLineCode != null">bom_line_code,</if>
            <if test="beforeStockAmount != null">before_stock_amount,</if>
            <if test="deductionAmount != null">deduction_amount,</if>
            <if test="afterStockAmount != null">after_stock_amount,</if>
            <if test="orgCode != null">org_code,</if>
            <if test="batchNumber != null">batch_number,</if>
            <if test="delFlag != null">del_flag,</if>
            <if test="createTime != null">create_time,</if>
            <if test="createBy != null">create_by,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="requireId != null">#{requireId},</if>
            <if test="bomLineId != null">#{bomLineId},</if>
            <if test="bomLineCode != null">#{bomLineCode},</if>
            <if test="beforeStockAmount != null">#{beforeStockAmount},</if>
            <if test="deductionAmount != null">#{deductionAmount},</if>
            <if test="afterStockAmount != null">#{afterStockAmount},</if>
            <if test="orgCode != null">#{orgCode},</if>
            <if test="batchNumber != null">#{batchNumber},</if>
            <if test="delFlag != null">#{delFlag},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
         </trim>
    </insert>

    <update id="updateApsPlateStandardRequireBomStockDetail" parameterType="ApsPlateStandardRequireBomStockDetail">
        update aps_plate_standard_require_bom_stock_detail
        <trim prefix="SET" suffixOverrides=",">
            <if test="requireId != null">require_id = #{requireId},</if>
            <if test="bomLineId != null">bom_line_id = #{bomLineId},</if>
            <if test="bomLineCode != null">bom_line_code = #{bomLineCode},</if>
            <if test="beforeStockAmount != null">before_stock_amount = #{beforeStockAmount},</if>
            <if test="deductionAmount != null">deduction_amount = #{deductionAmount},</if>
            <if test="afterStockAmount != null">after_stock_amount = #{afterStockAmount},</if>
            <if test="orgCode != null">org_code = #{orgCode},</if>
            <if test="batchNumber != null">batch_number = #{batchNumber},</if>
            <if test="delFlag != null">del_flag = #{delFlag},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteApsPlateStandardRequireBomStockDetailById" parameterType="Long">
        delete from aps_plate_standard_require_bom_stock_detail where id = #{id}
    </delete>

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

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,173 @@
<?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.core.mapper.ApsPlateStandardRequireMapper">
    
    <resultMap type="ApsPlateStandardRequire" id="ApsPlateStandardRequireResult">
        <result property="id"    column="id"    />
        <result property="requireId"    column="require_id"    />
        <result property="bomLineId"    column="bom_line_id"    />
        <result property="bomLineCode"    column="bom_line_code"    />
        <result property="bomLineLevel"    column="bom_line_level"    />
        <result property="bomUseAmount"    column="bom_use_amount"    />
        <result property="processRouteId"    column="process_route_id"    />
        <result property="processRouteHours"    column="process_route_hours"    />
        <result property="requireAmount"    column="require_amount"    />
        <result property="netRequirement"    column="net_requirement"    />
        <result property="startDate"    column="start_date"    />
        <result property="completeDate"    column="complete_date"    />
        <result property="demandDate"    column="demand_date"    />
        <result property="orgCode"    column="org_code"    />
        <result property="productionBase"    column="production_base"    />
        <result property="matchState"    column="match_state"    />
        <result property="matchMode"    column="match_mode"    />
        <result property="unmatchedDemandAmount"    column="unmatched_demand_amount"    />
        <result property="suggestedCompletionDate"    column="suggested_completion_date"    />
        <result property="hasDelayRisk"    column="has_delay_risk"    />
        <result property="batchNumber"    column="batch_number"    />
        <result property="delFlag"    column="del_flag"    />
        <result property="createTime"    column="create_time"    />
        <result property="createBy"    column="create_by"    />
        <result property="updateBy"    column="update_by"    />
        <result property="updateTime"    column="update_time"    />
    </resultMap>

    <sql id="selectApsPlateStandardRequireVo">
        select id, require_id, bom_line_id, bom_line_code, bom_line_level, bom_use_amount, process_route_id, process_route_hours, require_amount, net_requirement, start_date, complete_date, demand_date, org_code, production_base, match_state, match_mode, unmatched_demand_amount, suggested_completion_date, has_delay_risk, batch_number, del_flag, create_time, create_by, update_by, update_time from aps_plate_standard_require
    </sql>

    <select id="selectApsPlateStandardRequireList" parameterType="ApsPlateStandardRequire" resultMap="ApsPlateStandardRequireResult">
        <include refid="selectApsPlateStandardRequireVo"/>
        <where>  
            <if test="requireId != null  and requireId != ''"> and require_id = #{requireId}</if>
            <if test="bomLineId != null  and bomLineId != ''"> and bom_line_id = #{bomLineId}</if>
            <if test="bomLineCode != null  and bomLineCode != ''"> and bom_line_code = #{bomLineCode}</if>
            <if test="bomLineLevel != null "> and bom_line_level = #{bomLineLevel}</if>
            <if test="bomUseAmount != null  and bomUseAmount != ''"> and bom_use_amount = #{bomUseAmount}</if>
            <if test="processRouteId != null  and processRouteId != ''"> and process_route_id = #{processRouteId}</if>
            <if test="processRouteHours != null  and processRouteHours != ''"> and process_route_hours = #{processRouteHours}</if>
            <if test="requireAmount != null  and requireAmount != ''"> and require_amount = #{requireAmount}</if>
            <if test="netRequirement != null  and netRequirement != ''"> and net_requirement = #{netRequirement}</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="demandDate != null  and demandDate != ''"> and demand_date = #{demandDate}</if>
            <if test="orgCode != null  and orgCode != ''"> and org_code = #{orgCode}</if>
            <if test="productionBase != null  and productionBase != ''"> and production_base = #{productionBase}</if>
            <if test="matchState != null  and matchState != ''"> and match_state = #{matchState}</if>
            <if test="matchMode != null  and matchMode != ''"> and match_mode = #{matchMode}</if>
            <if test="unmatchedDemandAmount != null  and unmatchedDemandAmount != ''"> and unmatched_demand_amount = #{unmatchedDemandAmount}</if>
            <if test="suggestedCompletionDate != null  and suggestedCompletionDate != ''"> and suggested_completion_date = #{suggestedCompletionDate}</if>
            <if test="hasDelayRisk != null  and hasDelayRisk != ''"> and has_delay_risk = #{hasDelayRisk}</if>
            <if test="batchNumber != null  and batchNumber != ''"> and batch_number = #{batchNumber}</if>
        </where>
    </select>
    
    <select id="selectApsPlateStandardRequireById" parameterType="Long" resultMap="ApsPlateStandardRequireResult">
        <include refid="selectApsPlateStandardRequireVo"/>
        where id = #{id}
    </select>

    <insert id="insertApsPlateStandardRequire" parameterType="ApsPlateStandardRequire">
        insert into aps_plate_standard_require
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
            <if test="requireId != null">require_id,</if>
            <if test="bomLineId != null">bom_line_id,</if>
            <if test="bomLineCode != null">bom_line_code,</if>
            <if test="bomLineLevel != null">bom_line_level,</if>
            <if test="bomUseAmount != null">bom_use_amount,</if>
            <if test="processRouteId != null">process_route_id,</if>
            <if test="processRouteHours != null">process_route_hours,</if>
            <if test="requireAmount != null">require_amount,</if>
            <if test="netRequirement != null">net_requirement,</if>
            <if test="startDate != null">start_date,</if>
            <if test="completeDate != null">complete_date,</if>
            <if test="demandDate != null">demand_date,</if>
            <if test="orgCode != null">org_code,</if>
            <if test="productionBase != null">production_base,</if>
            <if test="matchState != null">match_state,</if>
            <if test="matchMode != null">match_mode,</if>
            <if test="unmatchedDemandAmount != null">unmatched_demand_amount,</if>
            <if test="suggestedCompletionDate != null">suggested_completion_date,</if>
            <if test="hasDelayRisk != null">has_delay_risk,</if>
            <if test="batchNumber != null">batch_number,</if>
            <if test="delFlag != null">del_flag,</if>
            <if test="createTime != null">create_time,</if>
            <if test="createBy != null">create_by,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="requireId != null">#{requireId},</if>
            <if test="bomLineId != null">#{bomLineId},</if>
            <if test="bomLineCode != null">#{bomLineCode},</if>
            <if test="bomLineLevel != null">#{bomLineLevel},</if>
            <if test="bomUseAmount != null">#{bomUseAmount},</if>
            <if test="processRouteId != null">#{processRouteId},</if>
            <if test="processRouteHours != null">#{processRouteHours},</if>
            <if test="requireAmount != null">#{requireAmount},</if>
            <if test="netRequirement != null">#{netRequirement},</if>
            <if test="startDate != null">#{startDate},</if>
            <if test="completeDate != null">#{completeDate},</if>
            <if test="demandDate != null">#{demandDate},</if>
            <if test="orgCode != null">#{orgCode},</if>
            <if test="productionBase != null">#{productionBase},</if>
            <if test="matchState != null">#{matchState},</if>
            <if test="matchMode != null">#{matchMode},</if>
            <if test="unmatchedDemandAmount != null">#{unmatchedDemandAmount},</if>
            <if test="suggestedCompletionDate != null">#{suggestedCompletionDate},</if>
            <if test="hasDelayRisk != null">#{hasDelayRisk},</if>
            <if test="batchNumber != null">#{batchNumber},</if>
            <if test="delFlag != null">#{delFlag},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
         </trim>
    </insert>

    <update id="updateApsPlateStandardRequire" parameterType="ApsPlateStandardRequire">
        update aps_plate_standard_require
        <trim prefix="SET" suffixOverrides=",">
            <if test="requireId != null">require_id = #{requireId},</if>
            <if test="bomLineId != null">bom_line_id = #{bomLineId},</if>
            <if test="bomLineCode != null">bom_line_code = #{bomLineCode},</if>
            <if test="bomLineLevel != null">bom_line_level = #{bomLineLevel},</if>
            <if test="bomUseAmount != null">bom_use_amount = #{bomUseAmount},</if>
            <if test="processRouteId != null">process_route_id = #{processRouteId},</if>
            <if test="processRouteHours != null">process_route_hours = #{processRouteHours},</if>
            <if test="requireAmount != null">require_amount = #{requireAmount},</if>
            <if test="netRequirement != null">net_requirement = #{netRequirement},</if>
            <if test="startDate != null">start_date = #{startDate},</if>
            <if test="completeDate != null">complete_date = #{completeDate},</if>
            <if test="demandDate != null">demand_date = #{demandDate},</if>
            <if test="orgCode != null">org_code = #{orgCode},</if>
            <if test="productionBase != null">production_base = #{productionBase},</if>
            <if test="matchState != null">match_state = #{matchState},</if>
            <if test="matchMode != null">match_mode = #{matchMode},</if>
            <if test="unmatchedDemandAmount != null">unmatched_demand_amount = #{unmatchedDemandAmount},</if>
            <if test="suggestedCompletionDate != null">suggested_completion_date = #{suggestedCompletionDate},</if>
            <if test="hasDelayRisk != null">has_delay_risk = #{hasDelayRisk},</if>
            <if test="batchNumber != null">batch_number = #{batchNumber},</if>
            <if test="delFlag != null">del_flag = #{delFlag},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteApsPlateStandardRequireById" parameterType="Long">
        delete from aps_plate_standard_require where id = #{id}
    </delete>

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