| | |
| | | import com.core.common.Cools; |
| | | import com.core.common.SpringUtils; |
| | | import com.core.exception.CoolException; |
| | | import com.zy.asrs.entity.InOut; |
| | | import com.zy.asrs.entity.Mat; |
| | | import com.zy.asrs.entity.Tag; |
| | | import com.zy.asrs.mapper.TagMapper; |
| | | import com.zy.asrs.service.InOutService; |
| | | import com.zy.asrs.service.MatService; |
| | | import com.zy.asrs.service.TagService; |
| | | import com.zy.common.entity.MatExcel; |
| | |
| | | TagService tagService = SpringUtils.getBean(TagService.class); |
| | | TagMapper tagMapper = SpringUtils.getBean(TagMapper.class); |
| | | MatService matService = SpringUtils.getBean(MatService.class); |
| | | InOutService inOutService = SpringUtils.getBean(InOutService.class); |
| | | Date now = new Date(); |
| | | Long tagId; |
| | | // 分类 |
| | |
| | | // 商品 |
| | | Mat mat = matService.selectByMatnr(excel.getMatnr()); |
| | | if (mat == null) { |
| | | InOut inOut=new InOut(); |
| | | mat = excel; |
| | | mat.setTagId(tagId); |
| | | mat.setMatnr(excel.getMatnr()+"__"+excel.getName()); |
| | | inOut.setMatnr(mat.getMatnr()); |
| | | inOut.setMaktx(mat.getMaktx()); |
| | | inOut.setColor(mat.getColor()); |
| | | inOut.setSpecs(mat.getSpecs()); |
| | | inOut.setTemp1(""); |
| | | if (!matService.insert(mat)) { |
| | | throw new CoolException("保存商品档案失败,商品编码:" + excel.getMatnr()); |
| | | } |
| | | if (!inOutService.insert(inOut)){ |
| | | throw new CoolException("保存商品信息失败,商品编码:" + excel.getMatnr()); |
| | | } |
| | | total++; |