回复 2# echo
品牌脚本:
var opts=$TOOLS.createOptions();
opts.add("","");
//if(value!=null ){
var sql01="select * from tlk_kf_DataDictionary where item_kf_DataDictionaryID =' ' ";
var datas =queryBySQL(sql01);
if(datas!=null && datas.size()>0){
for(var iter = datas.iterator();iter.hasNext();){
var doc = iter.next();
var taskNo =doc.getId();
var taskName=doc.getItemValueAsString("Name");
opts.add(taskName,taskNo);
}
}
// }
opts;
规格脚本:
var opts=$TOOLS.createOptions();
opts.add("","");
var value = getItemValueAsString("Brand");
if(value!=null ){
var sql01="select * from tlk_kf_DataDictionary where item_kf_DataDictionaryID ='"+value+"'";
var datas =queryBySQL(sql01);
if(datas!=null && datas.size()>0){
for(var iter = datas.iterator();iter.hasNext();){
var doc = iter.next();
var taskNo =doc.getId();
var taskName=doc.getItemValueAsString("Name");
opts.add(taskName,taskNo);
}
}
}
opts;
型号脚本:
var opts=$TOOLS.createOptions();
opts.add("","");
var value = getItemValueAsString("Size");
if(value!=null ){
var sql01="select * from tlk_kf_DataDictionary where item_kf_DataDictionaryID ='"+value+"'";
var datas =queryBySQL(sql01);
if(datas!=null && datas.size()>0){
for(var iter = datas.iterator();iter.hasNext();){
var doc = iter.next();
var taskNo =doc.getId();
var taskName=doc.getItemValueAsString("Name");
opts.add(taskName,taskNo);
}
}
}
opts; |