本帖最后由 kelly 于 2017-9-11 22:36 编辑
您好,您试试底下代码试:
(function(){
var id =getId()
var fapiao=""
var types=getItemValueAsString("依据类型");
var sql;
if(types=="设施外包"){
sql="SELECT sum(cast(ITEM_不含税金额 as float)) as 不含税金额 from TLK_新付款依据信息外包 where parent ='"+id+"'";}
else if (types=="设施用料"){
sql="SELECT sum(cast(ITEM_不含税金额 as float)) as 不含税金额 from TLK_新付款依据信息 where parent ='"+id+"'";
}
else{return}
println(sql+sb)
var datas = queryByDSName("SP_obpm" , sql);
if(datas!=null || datas.size()>0){
var iter = datas.iterator();iter.hasNext();
var data = iter.next();
println(sql)
var fapiaoold=data.get("不含税金额");
fapiao= fapiaoold
}
else{fapiao=0}
return fapiao;
})()
有问题,加我Q851042911,我们一起进行解决! |