零件工单计划：上传后删除旧的计划数据

bluejay

2025-04-14 faafd7295f73246a4ff5895e9fdf79deb543f35d

零件工单计划：上传后删除旧的计划数据

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

@@ -63,4 +63,6 @@
    public int deleteApsPartPlanByIds(String[] ids);

    int insertBatch(List<ApsPartPlanTemp> apsPartPlanTemps);

    int removeAllPartPlans();
}

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

@@ -13,6 +13,7 @@
import com.aps.core.mapper.ApsPartPlanMapper;
import com.aps.core.domain.ApsPartPlan;
import com.aps.core.service.IApsPartPlanService;
import org.springframework.transaction.annotation.Transactional;

/**
 * 零件计划管理Service业务层处理
@@ -102,8 +103,11 @@
        return apsPartPlanMapper.deleteApsPartPlanById(id);
    }

    @Transactional
    @Override
    public int confirmPart(ApsPartPlanTemp apsPartPlanTemp) {

        apsPartPlanMapper.removeAllPartPlans();
        //查询临时表数据
        List<ApsPartPlanTemp> apsPartPlanTemps=apsPartPlanTempMapper.selectApsPartPlanTempList(apsPartPlanTemp);
        int count=0;

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

@@ -82,6 +82,7 @@
            <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>
             and del_flag='0'
        </where>
    </select>
    
@@ -271,4 +272,15 @@
            ,#{item.isStockComplete},#{item.hasTurnback},#{item.hasRisk},#{item.plant})
        </foreach>
    </insert>

    <update id="selectPartPlanListByDocumentNumbers" parameterType="String" >
        select id from aps_part_plan where documentNumber in
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </update>

    <update id="removeAllPartPlans" parameterType="String">
        update  aps_part_plan  set del_flag='1' where del_flag ='0'
    </update>
</mapper>