|
|
本帖最后由 spiral 于 2012-12-5 15:59 编辑
报错信息为
代码为
var parent = getParentDocument();
var 产品编号_abc=parent.getItemValueAsString("产品编号");
var 产品名称_abc=parent.getItemValueAsString("产品名称");
$PRINTER.println("*****************************->1"+产品编号_abc);
$PRINTER.println("*****************************->2"+产品名称_abc);
//在视图添加一个查询按钮 执行前脚本
var text = getParameterAsText("_selects");
var docids = text.split(';');
for (var i=0; i < docids.length; i++ ) {
if(docids != null && !docids.equals("undined") && !docids.equals("null") ){
var doc = findDocument(docids);
$PRINTER.println("*****************************->输出doc______"+产品名称_abc);
//获取字段值
var 工序编号_abc = doc.getItemValueAsString("工序编号");
var 工序名称_abc = doc.getItemValueAsString("工序名称");
if(产品编号_abc==""||产品名称_abc=="") break;
//1. 校验唯一性
sql="select * from tlk_期初余额设置表 where ITEM_工序编号='"+工序编号_abc+"' and ITEM_产品编号='"+产品编号_abc+"'";
var docs=queryBySQL(sql);
sql1="select * from tlk_期初余额设置表 where ITEM_工序编号='"+工序编号_abc+"' and ITEM_产品编号='"+产品编号_abc+"' and VERSIONS=2";
var docs1=queryBySQL(sql1);
if((docs !=null && docs.size()>0)||(docs1 !=null && docs1.size()>0)) break;
#include "doclib";
InsertDataOnOtherDoc("计件工资系统/计件工资核算/期初余额设置表", "11e2-1998-603426fc-a585-dbdea3dd946e",
["工序编号","工序名称","产品编号","产品名称"], [工序编号_abc,工序名称_abc,产品编号_abc,产品名称_abc]);//调用
}
}
函数库
/**
create new object, insert data onto other form
*formName 表单名
*formId 表单id
*fieldNames 字段名,数组或字符串
*fieldValues 字段值,数组或字符串
*parentDoc 父文档,可不传
*isDateNames date类型的字段名(可不传)(string类型)
*isDateValues date 类型的值 (可不传)(date类型)
*/
function InsertDataOnOtherDoc(formName, formId, fieldNames, fieldValues, parentDoc,isDateNames,isDateValues) {
var doc = getCurrentDocument();
var domain = getDomainid();
var application = getApplication();
var process = getDocProcess($WEB.getApplication());
var uuid = new Packages.cn.myapps.util.sequence.Sequence();
var child = new Packages.cn.myapps.core.dynaform.document.ejb.Document();
child.setId(uuid.getSequence());
if(parentDoc) child.setParent(parentDoc);
child.setFormname(formName);
child.setAuthor(getWebUser());
child.setFormid(formId);
child.setIstmp(false);
child.setApplicationid(application);
child.setLastmodifier(getWebUser().getId());
child.setDomainid(domain);
child.setMappingId(child.getId());
var count = 1;
var fieldName = "";
var fieldValue = "";
if (fieldNames.constructor == Array) {
count = fieldNames.length;
} else {
fieldName = fieldNames;
}
if (fieldValues.constructor != Array) {
fieldValue = fieldValues;
child.addStringItem(fieldName, fieldValue);
} else {
for (var i = 0; i < count; i++) {
child.addStringItem(fieldNames, fieldValues);
}
}
if(isDateNames && isDateValues){
var datecount = 1;
var dateName = "";
var dateValue = "";
if (isDateNames.constructor == Array) {
datecount = isDateNames.length;
} else {
dateName = isDateNames;
}
if (isDateValues.constructor != Array) {
dateValue = isDateValues;
child.addDateItem(dateName, dateValue);
} else {
for (var i = 0; i < datecount; i++) {
child.addDateItem(isDateNames, isDateValues);
}
}
}
process.doCreate(child);
} |
|