excel导出优化

zhangchao

2024-11-04 59f80df1e377e8775969ca4acadfa2eadd6e37ae

 src/main/java/com/zy/asrs/service/impl/AgvWrkDetlServiceImpl.java

@@ -1,20 +1,15 @@
package com.zy.asrs.service.impl;

import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import com.core.common.Cools;
import com.core.exception.CoolException;
import com.zy.asrs.entity.AgvWrkDetl;
import com.zy.asrs.entity.Mat;
import com.zy.asrs.entity.WrkDetl;
import com.zy.asrs.mapper.AgvWrkDetlMapper;
import com.zy.asrs.service.AgvWrkDetlService;
import com.zy.asrs.service.MatService;
import com.zy.common.model.DetlDto;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.Date;
import java.util.List;

@Service
@@ -23,6 +18,7 @@
    @Autowired
    private MatService matService;

    /*
    @Override
    @Transactional
    public void createWorkDetail(Integer workNo, List<DetlDto> detlDtos, String barcode, Long userId) {
@@ -39,10 +35,11 @@
            AgvWrkDetl wrkDetl = new AgvWrkDetl();
            wrkDetl.sync(mat);
            wrkDetl.setWrkNo(workNo);
            wrkDetl.setOrderNo(dto.getOrderNo());
            wrkDetl.setIoTime(now);
            wrkDetl.setBatch(dto.getBatch());
            wrkDetl.setAnfme(dto.getAnfme()); // 数量
            wrkDetl.setZpallet(barcode); // 托盘条码
            wrkDetl.setZpallet(barcode); // 货架条码
            wrkDetl.setAppeUser(userId);
            wrkDetl.setAppeTime(now);
            wrkDetl.setModiUser(userId);
@@ -52,9 +49,10 @@
            }
        }
    }

    */
    @Override
    public List<WrkDetl> selectByWrkNo(Integer wrkNo) {
    public List<AgvWrkDetl> selectByWrkNo(Integer wrkNo) {

        return this.baseMapper.selectByWrkNo(wrkNo);
    }

@@ -92,4 +90,14 @@
        return baseMapper.updateOrderNo(orderNo, wrkNo, matnr, batch) > 0;
    }

    @Override
    public boolean updateWrkNo1(Integer wrkNo, String barcode, String matnr, String threeCode) {
        return baseMapper.updateWrkNo1(wrkNo, barcode, matnr, threeCode) > 0;
    }

    @Override
    public boolean deleteByWrkNo(int wrkNo) {
        return this.delete(new EntityWrapper<AgvWrkDetl>().eq("wrk_no",wrkNo));
    }

}