导入后直接插表

创建导入界面，此处省略

if (gUtil.isNull(inputForm.get(‘FILE_PATH’))) {
gUtil.error(‘请先上传Excel文件’);
return;
}
$vm.save(function(result){
if (!result) return;
$vm.dialogCallback(result.inputForm);
});

#set($filePath=$inputForm.FILE_PATH);

#if ($vs.util.isNull($filePath))
$vs.exception.throwException(‘请先上传需要导入数据的文件’);

#end

#set($sheets = $vs.file.readExcelFile($filePath));

#if (null==$sheets || $sheets.size()==0)
$vs.exception.throwException(‘Excel文件无效:未发现数据’);

#end
//只有第一个sheet有效

#set($sheet=$sheets.get(0));

#if (null==$sheet.rows || $sheet.rows.size()==0)
$vs.exception.throwException(‘Excel文件无效:未发现数据’);

#end
//封装数据

#set($list = $vs.util.newList());

#foreach ($row in $sheet.rows)

#set($item = $vs.util.newMap());
#set($item.WAREHOUSE_NAME = $row.getData(0));
#set($item.COMPANY_NAME = $row.getData(1));
#set($item.PARTSNAME_NAME = $row.getData(2));
#set($item.GOODS_MATERIAL = $row.getData(3));
#set($item.GOODS_SPEC = $row.getData(4));
#set($item.PRODUCTAREA_NAME = $row.getData(5));//获取string的值
#set($item.GOODS_NUM = $row.getDouble(6));//获取double的值
#set($item.GOODS_WEIGHT = $row.getDouble(7, 4));//获取double的值且round
#set($item.PARTSNAME_NUMUNIT = $row.getData(8));
#set($item.PARTSNAME_WEIGHTUNIT = $row.getData(9));
#set($item.GOODS_METERING = $row.getData(10));
#set($item.GOODS_CODESTR10 = $row.getData(11));
#set($item.GOODS_CODESTR1 = $row.getData(12));
#set($item.GOODS_CODESTR2 = $row.getData(13));
#set($item.GOODS_CODESTR3 = $row.getData(14));
#set($item.GOODS_INIT_DATE = $row.getDate(15));//获取日期
#set($item.ORG_NAME = $row.getData(16));
#set($item.DEPT_NAME = $row.getData(17));
#set($item.GOODS_INIT_REMARK = $row.getData(18));
//$row.getInteger(0) //获取整型数据
$vs.util.checkInput($item.WAREHOUSE_NAME,'仓库未输入');
$vs.util.checkInput($item.COMPANY_NAME,'货主未输入');
$vs.util.checkInput($item.PARTSNAME_NAME,'品名未输入');
$vs.util.checkInput($item.GOODS_MATERIAL,'材质未输入');
$vs.util.checkInput($item.GOODS_SPEC,'规格未输入');
$vs.util.checkInput($item.PRODUCTAREA_NAME,'产地未输入');
$vs.util.checkInput($item.GOODS_WEIGHT,'重量未输入');
#if (null==$item.GOODS_INIT_DATE)
    $vs.exception.throwException('入库日期未输入');
#end
$vs.util.checkInput($item.ORG_NAME,'业务机构未输入');
$vs.util.checkInput($item.DEPT_NAME,'业务部门未输入');
#if ($vs.util.isNull($item.GOODS_METERING))
    #set($item.GOODS_METERING = '磅计');
#end
$list.add($item);

#end

#set($proc=$vs.proc.find(‘com.golden.bdp.wms.basic.common’));

#set($inputForm.list=$proc.checkImportGoods($list));