工序级产能数据管理后台代码提交

dy

2025-04-21 64026632c7873a0314bbbe224a57e0053cf18cd7

工序级产能数据管理后台代码提交

 aps-modules/aps-core/src/main/java/com/aps/core/controller/basicData/ApsProcessCapacityManagementController.java

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

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.ApsProcessCapacityManagement;
import com.aps.core.service.IApsProcessCapacityManagementService;
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 dingYang
 * @date 2025-04-21
 */
@RestController
@RequestMapping("/processCapacityManagement")
public class ApsProcessCapacityManagementController extends BaseController
{
    @Autowired
    private IApsProcessCapacityManagementService apsProcessCapacityManagementService;

    /**
     * æŸ¥è¯¢å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†åˆ—表
     */
    @RequiresPermissions("processCapacityManagement:processCapacityManagement:list")
    @GetMapping("/list")
    public TableDataInfo list(ApsProcessCapacityManagement apsProcessCapacityManagement)
    {
        startPage();
        List<ApsProcessCapacityManagement> list = apsProcessCapacityManagementService.selectApsProcessCapacityManagementList(apsProcessCapacityManagement);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºå·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†åˆ—表
     */
    @RequiresPermissions("processCapacityManagement:processCapacityManagement:export")
    @Log(title = "工序级产能数据管理", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, ApsProcessCapacityManagement apsProcessCapacityManagement)
    {
        List<ApsProcessCapacityManagement> list = apsProcessCapacityManagementService.selectApsProcessCapacityManagementList(apsProcessCapacityManagement);
        ExcelUtil<ApsProcessCapacityManagement> util = new ExcelUtil<ApsProcessCapacityManagement>(ApsProcessCapacityManagement.class);
        util.exportExcel(response, list, "工序级产能数据管理数据");
    }

    /**
     * èŽ·å–工序级产能数据管理详细信息
     */
    @RequiresPermissions("processCapacityManagement:processCapacityManagement:query")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") String id)
    {
        return success(apsProcessCapacityManagementService.selectApsProcessCapacityManagementById(id));
    }

    /**
     * æ–°å¢žå·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     */
    @RequiresPermissions("processCapacityManagement:processCapacityManagement:add")
    @Log(title = "工序级产能数据管理", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody ApsProcessCapacityManagement apsProcessCapacityManagement)
    {
        return toAjax(apsProcessCapacityManagementService.insertApsProcessCapacityManagement(apsProcessCapacityManagement));
    }

    /**
     * ä¿®æ”¹å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     */
    @RequiresPermissions("processCapacityManagement:processCapacityManagement:edit")
    @Log(title = "工序级产能数据管理", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody ApsProcessCapacityManagement apsProcessCapacityManagement)
    {
        return toAjax(apsProcessCapacityManagementService.updateApsProcessCapacityManagement(apsProcessCapacityManagement));
    }

    /**
     * åˆ é™¤å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     */
    @RequiresPermissions("processCapacityManagement:processCapacityManagement:remove")
    @Log(title = "工序级产能数据管理", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable String[] ids)
    {
        return toAjax(apsProcessCapacityManagementService.deleteApsProcessCapacityManagementByIds(ids));
    }
}

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

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

import java.math.BigDecimal;
import java.util.Date;
import com.fasterxml.jackson.annotation.JsonFormat;
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_process_capacity_management
 * 
 * @author dingYang
 * @date 2025-04-21
 */
public class ApsProcessCapacityManagement extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** id */
    private String id;

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

    /** äº§èƒ½ç±»åž‹ */
    @Excel(name = "产能类型")
    private String capacityType;

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

    /** å·¥åºåç§° */
    @Excel(name = "工序名称")
    private String processName;

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

    /** å·¥æ—¶ */
    @Excel(name = "工时")
    private BigDecimal workTime;

    /** ç”Ÿæ•ˆæ—¥æœŸ */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "生效日期", width = 30, dateFormat = "yyyy-MM-dd")
    private Date effectiveDate;

    /** å¤±æ•ˆæ—¥æœŸ */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "失效日期", width = 30, dateFormat = "yyyy-MM-dd")
    private Date expiringDate;

    /** é›†æˆæ—¥æœŸ */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = "集成日期", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
    private Date integrationDate;

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

    public String getId() 
    {
        return id;
    }

    public void setItemNumber(String itemNumber) 
    {
        this.itemNumber = itemNumber;
    }

    public String getItemNumber() 
    {
        return itemNumber;
    }

    public void setCapacityType(String capacityType) 
    {
        this.capacityType = capacityType;
    }

    public String getCapacityType() 
    {
        return capacityType;
    }

    public void setProcessNumber(String processNumber) 
    {
        this.processNumber = processNumber;
    }

    public String getProcessNumber() 
    {
        return processNumber;
    }

    public void setProcessName(String processName) 
    {
        this.processName = processName;
    }

    public String getProcessName() 
    {
        return processName;
    }

    public void setProcessRouteId(String processRouteId) 
    {
        this.processRouteId = processRouteId;
    }

    public String getProcessRouteId() 
    {
        return processRouteId;
    }

    public void setWorkTime(BigDecimal workTime)
    {
        this.workTime = workTime;
    }

    public BigDecimal getWorkTime()
    {
        return workTime;
    }

    public void setEffectiveDate(Date effectiveDate) 
    {
        this.effectiveDate = effectiveDate;
    }

    public Date getEffectiveDate() 
    {
        return effectiveDate;
    }

    public void setExpiringDate(Date expiringDate) 
    {
        this.expiringDate = expiringDate;
    }

    public Date getExpiringDate() 
    {
        return expiringDate;
    }

    public void setIntegrationDate(Date integrationDate) 
    {
        this.integrationDate = integrationDate;
    }

    public Date getIntegrationDate() 
    {
        return integrationDate;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("itemNumber", getItemNumber())
            .append("capacityType", getCapacityType())
            .append("processNumber", getProcessNumber())
            .append("processName", getProcessName())
            .append("processRouteId", getProcessRouteId())
            .append("workTime", getWorkTime())
            .append("effectiveDate", getEffectiveDate())
            .append("expiringDate", getExpiringDate())
            .append("integrationDate", getIntegrationDate())
            .append("createBy", getCreateBy())
            .append("createTime", getCreateTime())
            .append("updateBy", getUpdateBy())
            .append("updateTime", getUpdateTime())
            .toString();
    }
}

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

@@ -1,5 +1,6 @@
package com.aps.core.domain;

import com.fasterxml.jackson.annotation.JsonFormat;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.aps.common.core.annotation.Excel;
@@ -37,7 +38,8 @@
    private String professionalFixedCycle;

    /** é›†æˆæ—¥æœŸ */
    @Excel(name = "集成日期")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = "集成日期", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
    private Date integrationDate;

    /** é€‚用工厂 */

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

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

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

/**
 * å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†Mapper接口
 * 
 * @author dingYang
 * @date 2025-04-21
 */
@Mapper
public interface ApsProcessCapacityManagementMapper 
{
    /**
     * æŸ¥è¯¢å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * 
     * @param id å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†ä¸»é”®
     * @return å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     */
    public ApsProcessCapacityManagement selectApsProcessCapacityManagementById(String id);

    /**
     * æŸ¥è¯¢å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†åˆ—表
     * 
     * @param apsProcessCapacityManagement å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * @return å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†é›†åˆ
     */
    public List<ApsProcessCapacityManagement> selectApsProcessCapacityManagementList(ApsProcessCapacityManagement apsProcessCapacityManagement);

    /**
     * æ–°å¢žå·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * 
     * @param apsProcessCapacityManagement å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * @return ç»“æžœ
     */
    public int insertApsProcessCapacityManagement(ApsProcessCapacityManagement apsProcessCapacityManagement);

    /**
     * ä¿®æ”¹å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * 
     * @param apsProcessCapacityManagement å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * @return ç»“æžœ
     */
    public int updateApsProcessCapacityManagement(ApsProcessCapacityManagement apsProcessCapacityManagement);

    /**
     * åˆ é™¤å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * 
     * @param id å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteApsProcessCapacityManagementById(String id);

    /**
     * æ‰¹é‡åˆ é™¤å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * 
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteApsProcessCapacityManagementByIds(String[] ids);
}

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

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

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

/**
 * å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†Service接口
 * 
 * @author dingYang
 * @date 2025-04-21
 */
public interface IApsProcessCapacityManagementService 
{
    /**
     * æŸ¥è¯¢å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * 
     * @param id å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†ä¸»é”®
     * @return å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     */
    public ApsProcessCapacityManagement selectApsProcessCapacityManagementById(String id);

    /**
     * æŸ¥è¯¢å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†åˆ—表
     * 
     * @param apsProcessCapacityManagement å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * @return å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†é›†åˆ
     */
    public List<ApsProcessCapacityManagement> selectApsProcessCapacityManagementList(ApsProcessCapacityManagement apsProcessCapacityManagement);

    /**
     * æ–°å¢žå·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * 
     * @param apsProcessCapacityManagement å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * @return ç»“æžœ
     */
    public int insertApsProcessCapacityManagement(ApsProcessCapacityManagement apsProcessCapacityManagement);

    /**
     * ä¿®æ”¹å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * 
     * @param apsProcessCapacityManagement å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * @return ç»“æžœ
     */
    public int updateApsProcessCapacityManagement(ApsProcessCapacityManagement apsProcessCapacityManagement);

    /**
     * æ‰¹é‡åˆ é™¤å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * 
     * @param ids éœ€è¦åˆ é™¤çš„工序级产能数据管理主键集合
     * @return ç»“æžœ
     */
    public int deleteApsProcessCapacityManagementByIds(String[] ids);

    /**
     * åˆ é™¤å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†ä¿¡æ¯
     * 
     * @param id å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†ä¸»é”®
     * @return ç»“æžœ
     */
    public int deleteApsProcessCapacityManagementById(String id);
}

 aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsProcessCapacityManagementServiceImpl.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.ApsProcessCapacityManagementMapper;
import com.aps.core.domain.ApsProcessCapacityManagement;
import com.aps.core.service.IApsProcessCapacityManagementService;

/**
 * å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†Service业务层处理
 * 
 * @author dingYang
 * @date 2025-04-21
 */
@Service
public class ApsProcessCapacityManagementServiceImpl implements IApsProcessCapacityManagementService 
{
    @Autowired
    private ApsProcessCapacityManagementMapper apsProcessCapacityManagementMapper;

    /**
     * æŸ¥è¯¢å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * 
     * @param id å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†ä¸»é”®
     * @return å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     */
    @Override
    public ApsProcessCapacityManagement selectApsProcessCapacityManagementById(String id)
    {
        return apsProcessCapacityManagementMapper.selectApsProcessCapacityManagementById(id);
    }

    /**
     * æŸ¥è¯¢å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†åˆ—表
     * 
     * @param apsProcessCapacityManagement å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * @return å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     */
    @Override
    public List<ApsProcessCapacityManagement> selectApsProcessCapacityManagementList(ApsProcessCapacityManagement apsProcessCapacityManagement)
    {
        return apsProcessCapacityManagementMapper.selectApsProcessCapacityManagementList(apsProcessCapacityManagement);
    }

    /**
     * æ–°å¢žå·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * 
     * @param apsProcessCapacityManagement å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * @return ç»“æžœ
     */
    @Override
    public int insertApsProcessCapacityManagement(ApsProcessCapacityManagement apsProcessCapacityManagement)
    {
        apsProcessCapacityManagement.setCreateTime(DateUtils.getNowDate());
        return apsProcessCapacityManagementMapper.insertApsProcessCapacityManagement(apsProcessCapacityManagement);
    }

    /**
     * ä¿®æ”¹å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * 
     * @param apsProcessCapacityManagement å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * @return ç»“æžœ
     */
    @Override
    public int updateApsProcessCapacityManagement(ApsProcessCapacityManagement apsProcessCapacityManagement)
    {
        apsProcessCapacityManagement.setUpdateTime(DateUtils.getNowDate());
        return apsProcessCapacityManagementMapper.updateApsProcessCapacityManagement(apsProcessCapacityManagement);
    }

    /**
     * æ‰¹é‡åˆ é™¤å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†
     * 
     * @param ids éœ€è¦åˆ é™¤çš„工序级产能数据管理主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsProcessCapacityManagementByIds(String[] ids)
    {
        return apsProcessCapacityManagementMapper.deleteApsProcessCapacityManagementByIds(ids);
    }

    /**
     * åˆ é™¤å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†ä¿¡æ¯
     * 
     * @param id å·¥åºçº§äº§èƒ½æ•°æ®ç®¡ç†ä¸»é”®
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsProcessCapacityManagementById(String id)
    {
        return apsProcessCapacityManagementMapper.deleteApsProcessCapacityManagementById(id);
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,106 @@
<?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.ApsProcessCapacityManagementMapper">
    
    <resultMap type="ApsProcessCapacityManagement" id="ApsProcessCapacityManagementResult">
        <result property="id"    column="id"    />
        <result property="itemNumber"    column="item_number"    />
        <result property="capacityType"    column="capacity_type"    />
        <result property="processNumber"    column="process_number"    />
        <result property="processName"    column="process_name"    />
        <result property="processRouteId"    column="process_route_id"    />
        <result property="workTime"    column="work_time"    />
        <result property="effectiveDate"    column="effective_date"    />
        <result property="expiringDate"    column="expiring_date"    />
        <result property="integrationDate"    column="integration_date"    />
        <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="selectApsProcessCapacityManagementVo">
        select id, item_number, capacity_type, process_number, process_name, process_route_id, work_time, effective_date, expiring_date, integration_date, create_by, create_time, update_by, update_time from aps_process_capacity_management
    </sql>

    <select id="selectApsProcessCapacityManagementList" parameterType="ApsProcessCapacityManagement" resultMap="ApsProcessCapacityManagementResult">
        <include refid="selectApsProcessCapacityManagementVo"/>
        <where>  
            <if test="itemNumber != null  and itemNumber != ''"> and item_number = #{itemNumber}</if>
        </where>
    </select>
    
    <select id="selectApsProcessCapacityManagementById" parameterType="String" resultMap="ApsProcessCapacityManagementResult">
        <include refid="selectApsProcessCapacityManagementVo"/>
        where id = #{id}
    </select>

    <insert id="insertApsProcessCapacityManagement" parameterType="ApsProcessCapacityManagement">
        insert into aps_process_capacity_management
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
            <if test="itemNumber != null and itemNumber != ''">item_number,</if>
            <if test="capacityType != null">capacity_type,</if>
            <if test="processNumber != null">process_number,</if>
            <if test="processName != null">process_name,</if>
            <if test="processRouteId != null">process_route_id,</if>
            <if test="workTime != null">work_time,</if>
            <if test="effectiveDate != null">effective_date,</if>
            <if test="expiringDate != null">expiring_date,</if>
            <if test="integrationDate != null">integration_date,</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="id != null">#{id},</if>
            <if test="itemNumber != null and itemNumber != ''">#{itemNumber},</if>
            <if test="capacityType != null">#{capacityType},</if>
            <if test="processNumber != null">#{processNumber},</if>
            <if test="processName != null">#{processName},</if>
            <if test="processRouteId != null">#{processRouteId},</if>
            <if test="workTime != null">#{workTime},</if>
            <if test="effectiveDate != null">#{effectiveDate},</if>
            <if test="expiringDate != null">#{expiringDate},</if>
            <if test="integrationDate != null">#{integrationDate},</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="updateApsProcessCapacityManagement" parameterType="ApsProcessCapacityManagement">
        update aps_process_capacity_management
        <trim prefix="SET" suffixOverrides=",">
            <if test="itemNumber != null and itemNumber != ''">item_number = #{itemNumber},</if>
            <if test="capacityType != null">capacity_type = #{capacityType},</if>
            <if test="processNumber != null">process_number = #{processNumber},</if>
            <if test="processName != null">process_name = #{processName},</if>
            <if test="processRouteId != null">process_route_id = #{processRouteId},</if>
            <if test="workTime != null">work_time = #{workTime},</if>
            <if test="effectiveDate != null">effective_date = #{effectiveDate},</if>
            <if test="expiringDate != null">expiring_date = #{expiringDate},</if>
            <if test="integrationDate != null">integration_date = #{integrationDate},</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="deleteApsProcessCapacityManagementById" parameterType="String">
        delete from aps_process_capacity_management where id = #{id}
    </delete>

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