#

Junjie

2024-06-03 133848ee1872b889ab5357db88f77d80e7084a3b

#

 zy-asrs-common/src/main/java/com/zy/asrs/common/domain/entity/MatExcel.java

@@ -3,6 +3,7 @@
import com.alibaba.excel.annotation.ExcelIgnoreUnannotated;
import com.alibaba.excel.annotation.ExcelProperty;
import com.zy.asrs.common.wms.entity.Mat;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

/**
@@ -20,4 +21,10 @@
    @ExcelProperty(index = 1, value = "二级分类")
    private String secClass;

    @ExcelProperty(index = 2, value = "商品编号")
    private String matnr;

    @ExcelProperty(index = 3, value = "商品名称")
    private String maktx;

}

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

@@ -129,10 +129,11 @@
            tagId = tagService.getTop(hostId).getId();
        }
        // 商品
        Mat mat = matService.getOne(new LambdaQueryWrapper<Mat>().eq(Mat::getMatnr, excel.getMatnr()));
        Mat mat = matService.getOne(new LambdaQueryWrapper<Mat>().eq(Mat::getMatnr, excel.getMatnr()).eq(Mat::getHostId, hostId));
        if (mat == null) {
            mat = excel;
            mat.setTagId(tagId);
            mat.setHostId(hostId);
            if (!matService.save(mat)) {
                throw new CoolException("保存商品信息失败，商品编码：" + excel.getMatnr());
            }

 zy-asrs-common/src/main/java/com/zy/asrs/common/wms/entity/Mat.java

@@ -3,6 +3,7 @@
import java.text.SimpleDateFormat;
import java.util.Date;

import com.alibaba.excel.annotation.ExcelProperty;
import com.zy.asrs.common.wms.service.TagService;
import org.springframework.format.annotation.DateTimeFormat;