零件计划管理基础代码和部分代码调整

wenwj

2025-04-08 7dac4deb10374dc33ca562eb1d7b7c9cc67dc04c

零件计划管理基础代码和部分代码调整

 aps-modules/aps-core/pom.xml

@@ -41,25 +41,35 @@
            <artifactId>spring-boot-starter-actuator</artifactId>
        </dependency>
        
        <!-- SpringBoot Web -->
        <!-- Mysql Connector -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
        </dependency>
        
        <!-- Minio -->
        <dependency>
            <groupId>io.minio</groupId>
            <artifactId>minio</artifactId>
            <version>${minio.version}</version>
        </dependency>
        
        <!-- RuoYi Api System -->
        <!-- RuoYi Common DataSource -->
        <dependency>
            <groupId>com.aps</groupId>
            <artifactId>aps-api-system</artifactId>
            <artifactId>aps-common-datasource</artifactId>
        </dependency>
        
        <!-- RuoYi Common DataScope -->
        <dependency>
            <groupId>com.aps</groupId>
            <artifactId>aps-common-datascope</artifactId>
        </dependency>

        <!-- RuoYi Common Log -->
        <dependency>
            <groupId>com.aps</groupId>
            <artifactId>aps-common-log</artifactId>
        </dependency>

        <!-- RuoYi Common Swagger -->
        <dependency>
            <groupId>com.aps</groupId>
            <artifactId>aps-common-swagger</artifactId>
        </dependency>
    </dependencies>

    <build>

 aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsPartPlanController.java

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

import java.util.List;
import java.io.IOException;

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.ApsPartPlan;
import com.aps.core.service.IApsPartPlanService;
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 wwj
 * @date 2025-04-08
 */
@RestController
@RequestMapping("/plan")
public class ApsPartPlanController extends BaseController
{
    @Autowired
    private IApsPartPlanService apsPartPlanService;

    /**
     * æŸ¥è¯¢é›¶ä»¶è®¡åˆ’管理列表
     */
    @RequiresPermissions("partPlan:plan:list")
    @GetMapping("/list")
    public TableDataInfo list(ApsPartPlan apsPartPlan)
    {
        startPage();
        List<ApsPartPlan> list = apsPartPlanService.selectApsPartPlanList(apsPartPlan);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºé›¶ä»¶è®¡åˆ’管理列表
     */
    @RequiresPermissions("partPlan:plan:export")
    @Log(title = "零件计划管理", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, ApsPartPlan apsPartPlan)
    {
        List<ApsPartPlan> list = apsPartPlanService.selectApsPartPlanList(apsPartPlan);
        ExcelUtil<ApsPartPlan> util = new ExcelUtil<ApsPartPlan>(ApsPartPlan.class);
        util.exportExcel(response, list, "零件计划管理数据");
    }

    /**
     * èŽ·å–零件计划管理详细信息
     */
    @RequiresPermissions("partPlan:plan:query")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") String id)
    {
        return success(apsPartPlanService.selectApsPartPlanById(id));
    }

    /**
     * æ–°å¢žé›¶ä»¶è®¡åˆ’管理
     */
    @RequiresPermissions("partPlan:plan:add")
    @Log(title = "零件计划管理", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody ApsPartPlan apsPartPlan)
    {
        return toAjax(apsPartPlanService.insertApsPartPlan(apsPartPlan));
    }

    /**
     * ä¿®æ”¹é›¶ä»¶è®¡åˆ’管理
     */
    @RequiresPermissions("partPlan:plan:edit")
    @Log(title = "零件计划管理", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody ApsPartPlan apsPartPlan)
    {
        return toAjax(apsPartPlanService.updateApsPartPlan(apsPartPlan));
    }

    /**
     * åˆ é™¤é›¶ä»¶è®¡åˆ’管理
     */
    @RequiresPermissions("partPlan:plan:remove")
    @Log(title = "零件计划管理", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable String[] ids)
    {
        return toAjax(apsPartPlanService.deleteApsPartPlanByIds(ids));
    }
}

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

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

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_part_plan
 * 
 * @author wwj
 * @date 2025-04-08
 */
public class ApsPartPlan extends BaseEntity
{
    private static final long serialVersionUID = 1L;

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

    /** ä¸»è®¡åˆ’员 */
    @Excel(name = "主计划员")
    private String masterPlanner;

    /** å‘¨æ—¥ */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "周日", width = 30, dateFormat = "yyyy-MM-dd")
    private Date weekDay;

    /** å‘¨åº¦ */
    @Excel(name = "周度")
    private String weekCycle;

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

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

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

    /** ä¸šåŠ¡ç±»åž‹ */
    @Excel(name = "业务类型")
    private String businessType;

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

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

    /** å•æ®çŠ¶æ€ */
    @Excel(name = "单据状态")
    private String documentStatus;

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

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

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

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

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

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

    /** å·¥ä½œä¸­å¿ƒ */
    @Excel(name = "工作中心")
    private String workCenter;

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

    /** è®¡åˆ’开工日 */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "计划开工日", width = 30, dateFormat = "yyyy-MM-dd")
    private Date planStartDay;

    /** è®¡åˆ’完工日 */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "计划完工日", width = 30, dateFormat = "yyyy-MM-dd")
    private Date planEndDay;

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

    /** å¤‡æ–™åç§° */
    @Excel(name = "备料名称")
    private String standbyName;

    /** å¤‡æ–™åº“å­˜ */
    @Excel(name = "备料库存")
    private Long standbyStock;

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

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

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

    /** è´¦å¥— */
    @Excel(name = "账套")
    private String account;

    /** ä¸Šé˜¶ç‰©æ–™ */
    @Excel(name = "上阶物料")
    private String advancedMaterials;

    /** ä¸Šé˜¶å•æ®å· */
    @Excel(name = "上阶单据号")
    private String advancedDocumentNumber;

    /** ä¸Šé˜¶éœ€æ±‚日期 */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @Excel(name = "上阶需求日期", width = 30, dateFormat = "yyyy-MM-dd")
    private Date advancedRequirementDay;

    /** è®¡åˆ’齐套 */
    @Excel(name = "计划齐套")
    private Integer isPlanComplete;

    /** åº“存齐套 */
    @Excel(name = "库存齐套")
    private Integer isStockComplete;

    /** æ˜¯å¦æœ‰æŠ˜è¿”工序 */
    @Excel(name = "是否有折返工序")
    private Integer hasTurnback;

    /** é£Žé™©æ ‡è¯† */
    @Excel(name = "风险标识")
    private Integer hasRisk;

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

    public String getId() 
    {
        return id;
    }

    public void setMasterPlanner(String masterPlanner) 
    {
        this.masterPlanner = masterPlanner;
    }

    public String getMasterPlanner() 
    {
        return masterPlanner;
    }

    public void setWeekDay(Date weekDay) 
    {
        this.weekDay = weekDay;
    }

    public Date getWeekDay() 
    {
        return weekDay;
    }

    public void setWeekCycle(String weekCycle) 
    {
        this.weekCycle = weekCycle;
    }

    public String getWeekCycle() 
    {
        return weekCycle;
    }

    public void setMainPartNumber(String mainPartNumber) 
    {
        this.mainPartNumber = mainPartNumber;
    }

    public String getMainPartNumber() 
    {
        return mainPartNumber;
    }

    public void setMainPartDrawingNumber(String mainPartDrawingNumber) 
    {
        this.mainPartDrawingNumber = mainPartDrawingNumber;
    }

    public String getMainPartDrawingNumber() 
    {
        return mainPartDrawingNumber;
    }

    public void setCustomer(String customer) 
    {
        this.customer = customer;
    }

    public String getCustomer() 
    {
        return customer;
    }

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

    public String getBusinessType() 
    {
        return businessType;
    }

    public void setDocumentNumber(String documentNumber) 
    {
        this.documentNumber = documentNumber;
    }

    public String getDocumentNumber() 
    {
        return documentNumber;
    }

    public void setRequirementType(String requirementType) 
    {
        this.requirementType = requirementType;
    }

    public String getRequirementType() 
    {
        return requirementType;
    }

    public void setDocumentStatus(String documentStatus) 
    {
        this.documentStatus = documentStatus;
    }

    public String getDocumentStatus() 
    {
        return documentStatus;
    }

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

    public String getItemNumber() 
    {
        return itemNumber;
    }

    public void setDrawingNo(String drawingNo) 
    {
        this.drawingNo = drawingNo;
    }

    public String getDrawingNo() 
    {
        return drawingNo;
    }

    public void setVersionNumber(String versionNumber) 
    {
        this.versionNumber = versionNumber;
    }

    public String getVersionNumber() 
    {
        return versionNumber;
    }

    public void setProductionQuantity(Long productionQuantity) 
    {
        this.productionQuantity = productionQuantity;
    }

    public Long getProductionQuantity() 
    {
        return productionQuantity;
    }

    public void setGoodProductsQuantity(Long goodProductsQuantity) 
    {
        this.goodProductsQuantity = goodProductsQuantity;
    }

    public Long getGoodProductsQuantity() 
    {
        return goodProductsQuantity;
    }

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

    public String getProcessNumber() 
    {
        return processNumber;
    }

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

    public String getWorkCenter() 
    {
        return workCenter;
    }

    public void setDepartment(String department) 
    {
        this.department = department;
    }

    public String getDepartment() 
    {
        return department;
    }

    public void setPlanStartDay(Date planStartDay) 
    {
        this.planStartDay = planStartDay;
    }

    public Date getPlanStartDay() 
    {
        return planStartDay;
    }

    public void setPlanEndDay(Date planEndDay) 
    {
        this.planEndDay = planEndDay;
    }

    public Date getPlanEndDay() 
    {
        return planEndDay;
    }

    public void setStandbyNumber(String standbyNumber) 
    {
        this.standbyNumber = standbyNumber;
    }

    public String getStandbyNumber() 
    {
        return standbyNumber;
    }

    public void setStandbyName(String standbyName) 
    {
        this.standbyName = standbyName;
    }

    public String getStandbyName() 
    {
        return standbyName;
    }

    public void setStandbyStock(Long standbyStock) 
    {
        this.standbyStock = standbyStock;
    }

    public Long getStandbyStock() 
    {
        return standbyStock;
    }

    public void setNextProcessDeparment(String nextProcessDeparment) 
    {
        this.nextProcessDeparment = nextProcessDeparment;
    }

    public String getNextProcessDeparment() 
    {
        return nextProcessDeparment;
    }

    public void setIsSuspended(Integer isSuspended) 
    {
        this.isSuspended = isSuspended;
    }

    public Integer getIsSuspended() 
    {
        return isSuspended;
    }

    public void setIsOutsourcing(Integer isOutsourcing) 
    {
        this.isOutsourcing = isOutsourcing;
    }

    public Integer getIsOutsourcing() 
    {
        return isOutsourcing;
    }

    public void setAccount(String account) 
    {
        this.account = account;
    }

    public String getAccount() 
    {
        return account;
    }

    public void setAdvancedMaterials(String advancedMaterials) 
    {
        this.advancedMaterials = advancedMaterials;
    }

    public String getAdvancedMaterials() 
    {
        return advancedMaterials;
    }

    public void setAdvancedDocumentNumber(String advancedDocumentNumber) 
    {
        this.advancedDocumentNumber = advancedDocumentNumber;
    }

    public String getAdvancedDocumentNumber() 
    {
        return advancedDocumentNumber;
    }

    public void setAdvancedRequirementDay(Date advancedRequirementDay) 
    {
        this.advancedRequirementDay = advancedRequirementDay;
    }

    public Date getAdvancedRequirementDay() 
    {
        return advancedRequirementDay;
    }

    public void setIsPlanComplete(Integer isPlanComplete) 
    {
        this.isPlanComplete = isPlanComplete;
    }

    public Integer getIsPlanComplete() 
    {
        return isPlanComplete;
    }

    public void setIsStockComplete(Integer isStockComplete) 
    {
        this.isStockComplete = isStockComplete;
    }

    public Integer getIsStockComplete() 
    {
        return isStockComplete;
    }

    public void setHasTurnback(Integer hasTurnback) 
    {
        this.hasTurnback = hasTurnback;
    }

    public Integer getHasTurnback() 
    {
        return hasTurnback;
    }

    public void setHasRisk(Integer hasRisk) 
    {
        this.hasRisk = hasRisk;
    }

    public Integer getHasRisk() 
    {
        return hasRisk;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("masterPlanner", getMasterPlanner())
            .append("weekDay", getWeekDay())
            .append("weekCycle", getWeekCycle())
            .append("mainPartNumber", getMainPartNumber())
            .append("mainPartDrawingNumber", getMainPartDrawingNumber())
            .append("customer", getCustomer())
            .append("businessType", getBusinessType())
            .append("documentNumber", getDocumentNumber())
            .append("requirementType", getRequirementType())
            .append("documentStatus", getDocumentStatus())
            .append("itemNumber", getItemNumber())
            .append("drawingNo", getDrawingNo())
            .append("versionNumber", getVersionNumber())
            .append("productionQuantity", getProductionQuantity())
            .append("goodProductsQuantity", getGoodProductsQuantity())
            .append("processNumber", getProcessNumber())
            .append("workCenter", getWorkCenter())
            .append("department", getDepartment())
            .append("planStartDay", getPlanStartDay())
            .append("planEndDay", getPlanEndDay())
            .append("standbyNumber", getStandbyNumber())
            .append("standbyName", getStandbyName())
            .append("standbyStock", getStandbyStock())
            .append("nextProcessDeparment", getNextProcessDeparment())
            .append("isSuspended", getIsSuspended())
            .append("isOutsourcing", getIsOutsourcing())
            .append("account", getAccount())
            .append("advancedMaterials", getAdvancedMaterials())
            .append("advancedDocumentNumber", getAdvancedDocumentNumber())
            .append("advancedRequirementDay", getAdvancedRequirementDay())
            .append("isPlanComplete", getIsPlanComplete())
            .append("isStockComplete", getIsStockComplete())
            .append("hasTurnback", getHasTurnback())
            .append("hasRisk", getHasRisk())
            .toString();
    }
}

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

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

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

/**
 * é›¶ä»¶è®¡åˆ’管理Mapper接口
 * 
 * @author wwj
 * @date 2025-04-08
 */
@Mapper
public interface ApsPartPlanMapper 
{
    /**
     * æŸ¥è¯¢é›¶ä»¶è®¡åˆ’管理
     * 
     * @param id é›¶ä»¶è®¡åˆ’管理主键
     * @return é›¶ä»¶è®¡åˆ’管理
     */
    public ApsPartPlan selectApsPartPlanById(String id);

    /**
     * æŸ¥è¯¢é›¶ä»¶è®¡åˆ’管理列表
     * 
     * @param apsPartPlan é›¶ä»¶è®¡åˆ’管理
     * @return é›¶ä»¶è®¡åˆ’管理集合
     */
    public List<ApsPartPlan> selectApsPartPlanList(ApsPartPlan apsPartPlan);

    /**
     * æ–°å¢žé›¶ä»¶è®¡åˆ’管理
     * 
     * @param apsPartPlan é›¶ä»¶è®¡åˆ’管理
     * @return ç»“æžœ
     */
    public int insertApsPartPlan(ApsPartPlan apsPartPlan);

    /**
     * ä¿®æ”¹é›¶ä»¶è®¡åˆ’管理
     * 
     * @param apsPartPlan é›¶ä»¶è®¡åˆ’管理
     * @return ç»“æžœ
     */
    public int updateApsPartPlan(ApsPartPlan apsPartPlan);

    /**
     * åˆ é™¤é›¶ä»¶è®¡åˆ’管理
     * 
     * @param id é›¶ä»¶è®¡åˆ’管理主键
     * @return ç»“æžœ
     */
    public int deleteApsPartPlanById(String id);

    /**
     * æ‰¹é‡åˆ é™¤é›¶ä»¶è®¡åˆ’管理
     * 
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteApsPartPlanByIds(String[] ids);
}

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

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

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

/**
 * é›¶ä»¶è®¡åˆ’管理Service接口
 * 
 * @author wwj
 * @date 2025-04-08
 */
public interface IApsPartPlanService 
{
    /**
     * æŸ¥è¯¢é›¶ä»¶è®¡åˆ’管理
     * 
     * @param id é›¶ä»¶è®¡åˆ’管理主键
     * @return é›¶ä»¶è®¡åˆ’管理
     */
    public ApsPartPlan selectApsPartPlanById(String id);

    /**
     * æŸ¥è¯¢é›¶ä»¶è®¡åˆ’管理列表
     * 
     * @param apsPartPlan é›¶ä»¶è®¡åˆ’管理
     * @return é›¶ä»¶è®¡åˆ’管理集合
     */
    public List<ApsPartPlan> selectApsPartPlanList(ApsPartPlan apsPartPlan);

    /**
     * æ–°å¢žé›¶ä»¶è®¡åˆ’管理
     * 
     * @param apsPartPlan é›¶ä»¶è®¡åˆ’管理
     * @return ç»“æžœ
     */
    public int insertApsPartPlan(ApsPartPlan apsPartPlan);

    /**
     * ä¿®æ”¹é›¶ä»¶è®¡åˆ’管理
     * 
     * @param apsPartPlan é›¶ä»¶è®¡åˆ’管理
     * @return ç»“æžœ
     */
    public int updateApsPartPlan(ApsPartPlan apsPartPlan);

    /**
     * æ‰¹é‡åˆ é™¤é›¶ä»¶è®¡åˆ’管理
     * 
     * @param ids éœ€è¦åˆ é™¤çš„零件计划管理主键集合
     * @return ç»“æžœ
     */
    public int deleteApsPartPlanByIds(String[] ids);

    /**
     * åˆ é™¤é›¶ä»¶è®¡åˆ’管理信息
     * 
     * @param id é›¶ä»¶è®¡åˆ’管理主键
     * @return ç»“æžœ
     */
    public int deleteApsPartPlanById(String id);
}

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

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

import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.aps.core.mapper.ApsPartPlanMapper;
import com.aps.core.domain.ApsPartPlan;
import com.aps.core.service.IApsPartPlanService;

/**
 * é›¶ä»¶è®¡åˆ’管理Service业务层处理
 * 
 * @author wwj
 * @date 2025-04-08
 */
@Service
public class ApsPartPlanServiceImpl implements IApsPartPlanService 
{
    @Autowired
    private ApsPartPlanMapper apsPartPlanMapper;

    /**
     * æŸ¥è¯¢é›¶ä»¶è®¡åˆ’管理
     * 
     * @param id é›¶ä»¶è®¡åˆ’管理主键
     * @return é›¶ä»¶è®¡åˆ’管理
     */
    @Override
    public ApsPartPlan selectApsPartPlanById(String id)
    {
        return apsPartPlanMapper.selectApsPartPlanById(id);
    }

    /**
     * æŸ¥è¯¢é›¶ä»¶è®¡åˆ’管理列表
     * 
     * @param apsPartPlan é›¶ä»¶è®¡åˆ’管理
     * @return é›¶ä»¶è®¡åˆ’管理
     */
    @Override
    public List<ApsPartPlan> selectApsPartPlanList(ApsPartPlan apsPartPlan)
    {
        return apsPartPlanMapper.selectApsPartPlanList(apsPartPlan);
    }

    /**
     * æ–°å¢žé›¶ä»¶è®¡åˆ’管理
     * 
     * @param apsPartPlan é›¶ä»¶è®¡åˆ’管理
     * @return ç»“æžœ
     */
    @Override
    public int insertApsPartPlan(ApsPartPlan apsPartPlan)
    {
        return apsPartPlanMapper.insertApsPartPlan(apsPartPlan);
    }

    /**
     * ä¿®æ”¹é›¶ä»¶è®¡åˆ’管理
     * 
     * @param apsPartPlan é›¶ä»¶è®¡åˆ’管理
     * @return ç»“æžœ
     */
    @Override
    public int updateApsPartPlan(ApsPartPlan apsPartPlan)
    {
        return apsPartPlanMapper.updateApsPartPlan(apsPartPlan);
    }

    /**
     * æ‰¹é‡åˆ é™¤é›¶ä»¶è®¡åˆ’管理
     * 
     * @param ids éœ€è¦åˆ é™¤çš„零件计划管理主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsPartPlanByIds(String[] ids)
    {
        return apsPartPlanMapper.deleteApsPartPlanByIds(ids);
    }

    /**
     * åˆ é™¤é›¶ä»¶è®¡åˆ’管理信息
     * 
     * @param id é›¶ä»¶è®¡åˆ’管理主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteApsPartPlanById(String id)
    {
        return apsPartPlanMapper.deleteApsPartPlanById(id);
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,223 @@
<?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.ApsPartPlanMapper">
    
    <resultMap type="com.aps.core.domain.ApsPartPlan" id="ApsPartPlanResult">
        <result property="id"    column="id"    />
        <result property="masterPlanner"    column="master_planner"    />
        <result property="weekDay"    column="week_day"    />
        <result property="weekCycle"    column="week_cycle"    />
        <result property="mainPartNumber"    column="main_part_number"    />
        <result property="mainPartDrawingNumber"    column="main_part_drawing_number"    />
        <result property="customer"    column="customer"    />
        <result property="businessType"    column="business_type"    />
        <result property="documentNumber"    column="document_number"    />
        <result property="requirementType"    column="requirement_type"    />
        <result property="documentStatus"    column="document_status"    />
        <result property="itemNumber"    column="item_number"    />
        <result property="drawingNo"    column="drawing_no"    />
        <result property="versionNumber"    column="version_number"    />
        <result property="productionQuantity"    column="production_quantity"    />
        <result property="goodProductsQuantity"    column="good_products_quantity"    />
        <result property="processNumber"    column="process_number"    />
        <result property="workCenter"    column="work_center"    />
        <result property="department"    column="department"    />
        <result property="planStartDay"    column="plan_start_day"    />
        <result property="planEndDay"    column="plan_end_day"    />
        <result property="standbyNumber"    column="standby_number"    />
        <result property="standbyName"    column="standby_name"    />
        <result property="standbyStock"    column="standby_stock"    />
        <result property="nextProcessDeparment"    column="next_process_deparment"    />
        <result property="isSuspended"    column="is_suspended"    />
        <result property="isOutsourcing"    column="is_outsourcing"    />
        <result property="account"    column="account"    />
        <result property="advancedMaterials"    column="advanced_materials"    />
        <result property="advancedDocumentNumber"    column="advanced_document_number"    />
        <result property="advancedRequirementDay"    column="advanced_requirement_day"    />
        <result property="isPlanComplete"    column="is_plan_complete"    />
        <result property="isStockComplete"    column="is_stock_complete"    />
        <result property="hasTurnback"    column="has_turnback"    />
        <result property="hasRisk"    column="has_risk"    />
    </resultMap>

    <sql id="selectApsPartPlanVo">
        select id, master_planner, week_day, week_cycle, main_part_number, main_part_drawing_number, customer, business_type, document_number, requirement_type, document_status, item_number, drawing_no, version_number, production_quantity, good_products_quantity, process_number, work_center, department, plan_start_day, plan_end_day, standby_number, standby_name, standby_stock, next_process_deparment, is_suspended, is_outsourcing, account, advanced_materials, advanced_document_number, advanced_requirement_day, is_plan_complete, is_stock_complete, has_turnback, has_risk from aps_part_plan
    </sql>

    <select id="selectApsPartPlanList" parameterType="com.aps.core.domain.ApsPartPlan" resultMap="ApsPartPlanResult">
        <include refid="selectApsPartPlanVo"/>
        <where>  
            <if test="masterPlanner != null  and masterPlanner != ''"> and master_planner like concat('%', #{masterPlanner}, '%')</if>
            <if test="weekDay != null "> and week_day = #{weekDay}</if>
            <if test="weekCycle != null  and weekCycle != ''"> and week_cycle = #{weekCycle}</if>
            <if test="mainPartNumber != null  and mainPartNumber != ''"> and main_part_number = #{mainPartNumber}</if>
            <if test="mainPartDrawingNumber != null  and mainPartDrawingNumber != ''"> and main_part_drawing_number = #{mainPartDrawingNumber}</if>
            <if test="customer != null  and customer != ''"> and customer like concat('%', #{customer}, '%')</if>
            <if test="businessType != null  and businessType != ''"> and business_type = #{businessType}</if>
            <if test="documentNumber != null  and documentNumber != ''"> and document_number = #{documentNumber}</if>
            <if test="requirementType != null  and requirementType != ''"> and requirement_type = #{requirementType}</if>
            <if test="documentStatus != null  and documentStatus != ''"> and document_status = #{documentStatus}</if>
            <if test="itemNumber != null  and itemNumber != ''"> and item_number = #{itemNumber}</if>
            <if test="drawingNo != null  and drawingNo != ''"> and drawing_no = #{drawingNo}</if>
            <if test="versionNumber != null  and versionNumber != ''"> and version_number = #{versionNumber}</if>
            <if test="productionQuantity != null "> and production_quantity = #{productionQuantity}</if>
            <if test="goodProductsQuantity != null "> and good_products_quantity = #{goodProductsQuantity}</if>
            <if test="processNumber != null  and processNumber != ''"> and process_number = #{processNumber}</if>
            <if test="workCenter != null  and workCenter != ''"> and work_center = #{workCenter}</if>
            <if test="department != null  and department != ''"> and department = #{department}</if>
            <if test="params.beginPlanStartDay != null and params.beginPlanStartDay != '' and params.endPlanStartDay != null and params.endPlanStartDay != ''"> and plan_start_day between #{params.beginPlanStartDay} and #{params.endPlanStartDay}</if>
            <if test="params.beginPlanEndDay != null and params.beginPlanEndDay != '' and params.endPlanEndDay != null and params.endPlanEndDay != ''"> and plan_end_day between #{params.beginPlanEndDay} and #{params.endPlanEndDay}</if>
            <if test="standbyNumber != null  and standbyNumber != ''"> and standby_number = #{standbyNumber}</if>
            <if test="standbyName != null  and standbyName != ''"> and standby_name like concat('%', #{standbyName}, '%')</if>
            <if test="standbyStock != null "> and standby_stock = #{standbyStock}</if>
            <if test="nextProcessDeparment != null  and nextProcessDeparment != ''"> and next_process_deparment = #{nextProcessDeparment}</if>
            <if test="isSuspended != null "> and is_suspended = #{isSuspended}</if>
            <if test="isOutsourcing != null "> and is_outsourcing = #{isOutsourcing}</if>
            <if test="account != null  and account != ''"> and account = #{account}</if>
            <if test="advancedMaterials != null  and advancedMaterials != ''"> and advanced_materials = #{advancedMaterials}</if>
            <if test="advancedDocumentNumber != null  and advancedDocumentNumber != ''"> and advanced_document_number = #{advancedDocumentNumber}</if>
            <if test="advancedRequirementDay != null "> and advanced_requirement_day = #{advancedRequirementDay}</if>
            <if test="isPlanComplete != null "> and is_plan_complete = #{isPlanComplete}</if>
            <if test="isStockComplete != null "> and is_stock_complete = #{isStockComplete}</if>
            <if test="hasTurnback != null "> and has_turnback = #{hasTurnback}</if>
            <if test="hasRisk != null "> and has_risk = #{hasRisk}</if>
        </where>
    </select>
    
    <select id="selectApsPartPlanById" parameterType="String" resultMap="ApsPartPlanResult">
        <include refid="selectApsPartPlanVo"/>
        where id = #{id}
    </select>

    <insert id="insertApsPartPlan" parameterType="com.aps.core.domain.ApsPartPlan">
        insert into aps_part_plan
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null and id != ''">id,</if>
            <if test="masterPlanner != null">master_planner,</if>
            <if test="weekDay != null">week_day,</if>
            <if test="weekCycle != null">week_cycle,</if>
            <if test="mainPartNumber != null">main_part_number,</if>
            <if test="mainPartDrawingNumber != null">main_part_drawing_number,</if>
            <if test="customer != null">customer,</if>
            <if test="businessType != null">business_type,</if>
            <if test="documentNumber != null">document_number,</if>
            <if test="requirementType != null">requirement_type,</if>
            <if test="documentStatus != null">document_status,</if>
            <if test="itemNumber != null">item_number,</if>
            <if test="drawingNo != null">drawing_no,</if>
            <if test="versionNumber != null">version_number,</if>
            <if test="productionQuantity != null">production_quantity,</if>
            <if test="goodProductsQuantity != null">good_products_quantity,</if>
            <if test="processNumber != null">process_number,</if>
            <if test="workCenter != null">work_center,</if>
            <if test="department != null">department,</if>
            <if test="planStartDay != null">plan_start_day,</if>
            <if test="planEndDay != null">plan_end_day,</if>
            <if test="standbyNumber != null">standby_number,</if>
            <if test="standbyName != null">standby_name,</if>
            <if test="standbyStock != null">standby_stock,</if>
            <if test="nextProcessDeparment != null">next_process_deparment,</if>
            <if test="isSuspended != null">is_suspended,</if>
            <if test="isOutsourcing != null">is_outsourcing,</if>
            <if test="account != null">account,</if>
            <if test="advancedMaterials != null">advanced_materials,</if>
            <if test="advancedDocumentNumber != null">advanced_document_number,</if>
            <if test="advancedRequirementDay != null">advanced_requirement_day,</if>
            <if test="isPlanComplete != null">is_plan_complete,</if>
            <if test="isStockComplete != null">is_stock_complete,</if>
            <if test="hasTurnback != null">has_turnback,</if>
            <if test="hasRisk != null">has_risk,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null and id != ''">#{id},</if>
            <if test="masterPlanner != null">#{masterPlanner},</if>
            <if test="weekDay != null">#{weekDay},</if>
            <if test="weekCycle != null">#{weekCycle},</if>
            <if test="mainPartNumber != null">#{mainPartNumber},</if>
            <if test="mainPartDrawingNumber != null">#{mainPartDrawingNumber},</if>
            <if test="customer != null">#{customer},</if>
            <if test="businessType != null">#{businessType},</if>
            <if test="documentNumber != null">#{documentNumber},</if>
            <if test="requirementType != null">#{requirementType},</if>
            <if test="documentStatus != null">#{documentStatus},</if>
            <if test="itemNumber != null">#{itemNumber},</if>
            <if test="drawingNo != null">#{drawingNo},</if>
            <if test="versionNumber != null">#{versionNumber},</if>
            <if test="productionQuantity != null">#{productionQuantity},</if>
            <if test="goodProductsQuantity != null">#{goodProductsQuantity},</if>
            <if test="processNumber != null">#{processNumber},</if>
            <if test="workCenter != null">#{workCenter},</if>
            <if test="department != null">#{department},</if>
            <if test="planStartDay != null">#{planStartDay},</if>
            <if test="planEndDay != null">#{planEndDay},</if>
            <if test="standbyNumber != null">#{standbyNumber},</if>
            <if test="standbyName != null">#{standbyName},</if>
            <if test="standbyStock != null">#{standbyStock},</if>
            <if test="nextProcessDeparment != null">#{nextProcessDeparment},</if>
            <if test="isSuspended != null">#{isSuspended},</if>
            <if test="isOutsourcing != null">#{isOutsourcing},</if>
            <if test="account != null">#{account},</if>
            <if test="advancedMaterials != null">#{advancedMaterials},</if>
            <if test="advancedDocumentNumber != null">#{advancedDocumentNumber},</if>
            <if test="advancedRequirementDay != null">#{advancedRequirementDay},</if>
            <if test="isPlanComplete != null">#{isPlanComplete},</if>
            <if test="isStockComplete != null">#{isStockComplete},</if>
            <if test="hasTurnback != null">#{hasTurnback},</if>
            <if test="hasRisk != null">#{hasRisk},</if>
         </trim>
    </insert>

    <update id="updateApsPartPlan" parameterType="com.aps.core.domain.ApsPartPlan">
        update aps_part_plan
        <trim prefix="SET" suffixOverrides=",">
            <if test="masterPlanner != null">master_planner = #{masterPlanner},</if>
            <if test="weekDay != null">week_day = #{weekDay},</if>
            <if test="weekCycle != null">week_cycle = #{weekCycle},</if>
            <if test="mainPartNumber != null">main_part_number = #{mainPartNumber},</if>
            <if test="mainPartDrawingNumber != null">main_part_drawing_number = #{mainPartDrawingNumber},</if>
            <if test="customer != null">customer = #{customer},</if>
            <if test="businessType != null">business_type = #{businessType},</if>
            <if test="documentNumber != null">document_number = #{documentNumber},</if>
            <if test="requirementType != null">requirement_type = #{requirementType},</if>
            <if test="documentStatus != null">document_status = #{documentStatus},</if>
            <if test="itemNumber != null">item_number = #{itemNumber},</if>
            <if test="drawingNo != null">drawing_no = #{drawingNo},</if>
            <if test="versionNumber != null">version_number = #{versionNumber},</if>
            <if test="productionQuantity != null">production_quantity = #{productionQuantity},</if>
            <if test="goodProductsQuantity != null">good_products_quantity = #{goodProductsQuantity},</if>
            <if test="processNumber != null">process_number = #{processNumber},</if>
            <if test="workCenter != null">work_center = #{workCenter},</if>
            <if test="department != null">department = #{department},</if>
            <if test="planStartDay != null">plan_start_day = #{planStartDay},</if>
            <if test="planEndDay != null">plan_end_day = #{planEndDay},</if>
            <if test="standbyNumber != null">standby_number = #{standbyNumber},</if>
            <if test="standbyName != null">standby_name = #{standbyName},</if>
            <if test="standbyStock != null">standby_stock = #{standbyStock},</if>
            <if test="nextProcessDeparment != null">next_process_deparment = #{nextProcessDeparment},</if>
            <if test="isSuspended != null">is_suspended = #{isSuspended},</if>
            <if test="isOutsourcing != null">is_outsourcing = #{isOutsourcing},</if>
            <if test="account != null">account = #{account},</if>
            <if test="advancedMaterials != null">advanced_materials = #{advancedMaterials},</if>
            <if test="advancedDocumentNumber != null">advanced_document_number = #{advancedDocumentNumber},</if>
            <if test="advancedRequirementDay != null">advanced_requirement_day = #{advancedRequirementDay},</if>
            <if test="isPlanComplete != null">is_plan_complete = #{isPlanComplete},</if>
            <if test="isStockComplete != null">is_stock_complete = #{isStockComplete},</if>
            <if test="hasTurnback != null">has_turnback = #{hasTurnback},</if>
            <if test="hasRisk != null">has_risk = #{hasRisk},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteApsPartPlanById" parameterType="String">
        delete from aps_part_plan where id = #{id}
    </delete>

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

 aps-modules/aps-upload/src/main/java/com/aps/upload/service/impl/CoreServiceImpl.java

@@ -1,6 +1,6 @@
package com.aps.upload.service.impl;

import com.aps.core.service.ICoreService;
import com.aps.upload.service.ICoreService;
import org.springframework.context.annotation.Primary;
import org.springframework.stereotype.Service;
import org.springframework.web.multipart.MultipartFile;