计划成本法材料未入库分录(计划成本材料尚未入库分录)

本文解答了关于《计划成本法材料未入库分录》相关内容，同时关于1、计划成本法材料未入库分录,2、计划成本法材料未入库会计分录,3、计划成本材料尚未入库分录,4、计划成本原材料未入库,5、计划成本下材料未入库应计入什么科目,的相关问答本篇文章福途教育网小编也整理了进来，希望对您有帮助。

计划成本法材料未入库分录

excelService.writeClWryrkToExcel(skps, clId, clmc);

}

excelService.ExcelEndWriting();

return "请查看D盘excel文件夹下skp.xls文件";

}

/**

* excel抽取skp模板

* @throws Exception

*/

@RequestMapping("excelimportSkp")

public Object excelimportSkp() throws Exception{

MultipartHttpServletRequest req = ((MultipartHttpServletRequest) request);

MultipartFile file = req.getFile("file_data");

ExcelReader reader = new ExcelReader();

List> list = reader.readExcelContent(file);

if(list == null

list.size() == 0){

throw new Exception("文件无数据");

}

List skps = new ArrayList();

//遍历list中的数据

for(int i = 1; i < list.size(); i++){

Map rowData = list.get(i);

//1,2,3不判断

String clbh = (String)rowData.get(4);

String clmc = (String)rowData.get(5);

double kpsl = 0;

try {

kpsl = Double.parseDouble((String)rowData.get(6));

} catch (Exception e) {

}

String skdw = (String)rowData.get(7);

String cksj = (String)rowData.get(8);

String khbh = (String)rowData.get(9);

String ckmc = (String)rowData.get(10);

if(StringUtils.isBlank(clbh)

StringUtils.isBlank(clmc)){

System.out.println("材料编号或者材料名称为空。");

continue;

}

Skp skp = new Skp();

skp.setClbh(clbh);

skp.setClmc(clmc);

skp.setKpsl(kpsl);

skp.setSkdw(skdw);

if(StringUtils.isBlank(cksj)){

skp.setCksj("");

}else{

skp.setCksj(cksj);

}

skp.setKhbh(khbh);

skp.setCkmc(ckmc);

skps.add(skp);

}

if(skps != null && skps.size() > 0){

skpService.excelimportSkp(skps);

}

return "抽取excel文件成功。";

}

}