|  |  |  | 
|---|
|  |  |  | 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++; | 
|---|