Excel导出优化

zhangchao

2024-11-05 9cb8cf8894306ef24e934e5f81b1c08caac5e8ad

 src/main/java/com/zy/asrs/utils/MatExcelListener.java

@@ -2,6 +2,7 @@

import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.core.common.Cools;
import com.core.common.SpringUtils;
import com.core.exception.CoolException;
@@ -132,9 +133,14 @@
            mat = excel;
            mat.setTagId(tagId);
            if (!matService.insert(mat)) {
                throw new CoolException("保存商品信息失败，商品编码：" + excel.getMatnr());
                throw new CoolException("保存商品信息失败，物料号：" + excel.getMatnr());
            }
            total++;
        }else {
            mat = excel;
            mat.setTagId(tagId);
            matService.update(mat,new EntityWrapper<Mat>().eq("matnr",mat.getMatnr()));
            total++;
        }
    }