|
|
还是我的值脚本还是写的有错误:
var lbdm=getItemValue("lbdma000");
var number = "";
var wh ="";
var sql = "select domainid,id,formid,lpad((nvl(max(SUBSTR(ITEM_SWHAO000,4,7)),'0000')+1),4,0) as swhao from tlk_CBTWLWGL where ITEM_LBDMA000='"+lbdm+"' group by domainid,id,formid";
var datas =queryBySQL(sql);
if(lbdm == null || lbdm.trim().length() <=0 ){
wh = "";
}
else {
if(datas!=null && datas.size()>0){
for(var iter = datas.iterator();iter.hasNext();){
var num = iter.next();
if(num!=null){
number=num.getItemValueAsInt("swhao");
wh=lbdm+"-"+number;}
}
}
}
wh; |
|