var childs = getCurrentDocument().getChilds("物品领用申请明细表");
var sql = "select * from tlk_物品名称维护表 where item_物品名称 =(select item_物品名称 from tlk_物品领用申请明细表 where parent ='"+getCurrentDocument().getId()+"')";
var datas = queryBySQL(sql);
if(datas!=null && datas.size()>0){
createConfirm("表单提交成功");
println("alert框");
var slabel = getCurrentDocument().getStateLabel();
if(slabel.equals("") || slabel.equals("行政部审核通过")){
for(var iter = datas.iterator(); iter.hasNext();){
var subdoc = iter.next();
var remark =parseInt(subdoc.getItemValueAsString("库存数量"));
var ret = 0;
for(var iter = childs.iterator(); iter.hasNext();){
var subChilds = iter.next();
var mont = parseInt(subChilds.getItemValueAsString("数量"));
if(remark != null && remark >= mont){
ret = parseInt(remark - mont);
}
else{
//createAlert("库存量不够");
println("库存不够");
}
subdoc.findItem("库存数量").setValue(ret);
var process = getDocProcess(getApplication());
process.doUpdate(subdoc);
}
}
}
}