工程师,你好!我的脚本如下。
(function(){
var sql = "select domainid,ITEM_归档号 from tlk_orderapplication";
var t_sum_count = countBySQL(sql);
if(t_sum_count > 0) {
println("总需求:" + t_sum_count);
var rtn_0 = t_sum_count;
}
var fin_sql="select domainid,ITEM_归档号 from oa5.tlk_orderapplication ";
var dsName = "OA办公";
var query = queryByDSName(dsName, fin_sql);
var com_count = 0;
var inc_count = 0;
if(query != null){
for(var its = query.iterator();its.hasNext();){
var item = its.next();
var temp = item.get("ITEM_归档号");
if(temp != ""){
com_count++;
}else{
inc_count++;
}
temp = "";
}
}
println("已完成:" +com_count);
var rtn_1 = com_count;
println("未完成:" +inc_count);
var rtn_2 = inc_count;
println("hello world!!!");
return( +rtn_0, +rtn_2);
})(); |