iamberry-common-parent/watero-rst-service/src/main/java/com/iamberry/rst/service/pts/MachinePartsServiceImpl.java

package com.iamberry.rst.service.pts;

import com.github.pagehelper.PageHelper;
import com.iamberry.rst.core.page.PagedResult;
import com.iamberry.rst.core.pts.PtsBom;
import com.iamberry.rst.core.pts.PtsComponents;
import com.iamberry.rst.core.pts.PtsSupplier;
import com.iamberry.rst.faces.pts.MachinePartsService;
import com.iamberry.rst.service.pts.mapper.MachineLogsMapper;
import com.iamberry.rst.service.pts.mapper.MachinePartsMapper;
import com.iamberry.rst.service.pts.mapper.MachineSupplierMapper;
import com.iamberry.rst.util.PageUtil;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;


/**
 * 机器零件管理
 * Created by LJK on 2017年9月25日11:17:29.
 */
@Service
public class MachinePartsServiceImpl implements MachinePartsService {
    @Autowired
    private MachinePartsMapper machinePartsMapper;
    @Autowired
    private MachineSupplierMapper machineSupplierMapper;


    @Override
    public Integer addMachineParts(PtsComponents ptsComponents) {
        return machinePartsMapper.addMachineParts(ptsComponents);
    }

    @Override
    public Integer getmachinePartsNumber(PtsComponents ptsComponents) {
        return machinePartsMapper.getmachinePartsNumber(ptsComponents);
    }

    @Override
    public PtsComponents getmachineParts(PtsComponents ptsComponents) {
        return machinePartsMapper.getmachineParts(ptsComponents);
    }
    public List<PtsComponents> listPtsComponents(PtsComponents ptsComponents){
        return machinePartsMapper.listPtsComponents(ptsComponents);
    }

    public List<PtsComponents> listPtsComponentsOrderByNo(PtsComponents ptsComponents){
        return machinePartsMapper.listPtsComponentsOrderByNo(ptsComponents);
    }

    @Override
    public PagedResult<PtsComponents> listPtsComponents(int pageNO, int pageSize, PtsComponents ptsComponents, boolean isTotalNum) {
        PageHelper.startPage(pageNO, pageSize, isTotalNum);
        List<PtsComponents> list = machinePartsMapper.listPtsComponents(ptsComponents);
        return PageUtil.getPage(list);
    }

    @Override
    public Integer updateParts(PtsComponents ptsComponents) {
        return machinePartsMapper.updateParts(ptsComponents);
    }

    private String noImage = "/common/images/pts/noImage.png";
    @Transactional
    @Override
    public Integer excelAddMachineParts(Sheet sheet) {
        try {
            //获取总行数
            int rowNum = sheet.getLastRowNum();
            for (int i = 1;i<=rowNum;i++){
                List<String> heads = new ArrayList<String>();
                Row row = sheet.getRow(i);
                Iterator<Cell> cells = row.cellIterator();
                // 获得第一行的迭代器,并遍历cell
                while (cells.hasNext()) {
                    Cell cell = cells.next();
                    heads.add(cell.getStringCellValue());
                }
                /**封装零件实体**/
                PtsComponents ptsComponents = new PtsComponents();
                ptsComponents.setComponentsNo(heads.get(0));
                /**获取供应商id**/
                PtsSupplier ptsSupplier = new PtsSupplier();
                ptsSupplier.setSupplierNumber(heads.get(1));
                ptsSupplier = machineSupplierMapper.getPtsSupplier(ptsSupplier);
                ptsComponents.setSupplierId(ptsSupplier.getSupplierId());
                ptsComponents.setComponentsName(heads.get(2));
                ptsComponents.setComponentsStatus(heads.get(3).equals("正常使用" )? 1 : 0);
                ptsComponents.setComponentsCost(Integer.valueOf(heads.get(4)) * 100);//元转换为分
                ptsComponents.setComponentsWeight(Integer.valueOf(heads.get(5)));
                ptsComponents.setComponentsMaterial(heads.get(6));
                Integer type = 0;
                switch (heads.get(7)){
                    case "塑胶件":
                        type = 1;
                        break;
                    case "五金件":
                        type = 2;
                        break;
                    case "电子类":
                        type = 3;
                        break;
                    case "线材":
                        type = 4;
                        break;
                    case "辅材":
                        type = 5;
                        break;
                }
                ptsComponents.setComponentsType(type);
                ptsComponents.setComponentsMbsc(heads.get(8));
                ptsComponents.setComponentsSpecification(heads.get(9));
                ptsComponents.setComponentsImg(noImage);
                ptsComponents.setComponentsCreateTime(new Date());
                machinePartsMapper.addMachineParts(ptsComponents);
            }
        }catch (Exception e){
            return 0;
        }

        return 1;
    }
}