|
|
函数库
function checkUnique(table,col,value){
var user = getWebUser();
var qq = user.getDomainid();
var did = getCurrentDocument().getId();
var sql = "select '"+qq+"' as domainid ,count(*)"
+" as item_num from "+table+" where "
+col+" ='"+value+"' and domainid='"+qq+"' "
+" and id <> '"+did+"' ";
println("-----------sql="+sql);
var docs = queryBySQL(sql);
var val = 0;
for( var iter = docs.iterator();iter.hasNext();){
var doc = iter.next();
val += doc.getItemValueAsDouble("num");
}
return val;
} |
|