utilFunctions
__68zGjFNYxfzExGBiSBB
__68zGjFNYxfzExGBiSBB
" + regulatorSql);
var datas = queryByDSName(dsName, regulatorSql);
if (datas != null) {
for(var iterator = datas.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
var code= map1.get("ITEM_CODE");
subordinateRegulatorIds+=",'"+code+"'";
}
}
subordinateRegulatorIds+=")";
//println("获取"+regulatorId+"下级监管机构,结果："+subordinateRegulatorIds);
return subordinateRegulatorIds;
}
}catch (e){
println("获取下级监管机构异常"+e)
}
}
/**
根据公司的id获取信息。这里获取的是监管相关信息，后续根据需求做添加
*/
function getOrganizationInfo(domainid){
var sql = "select supervise_region_code,supervise_depart_id,supervise_depart_name from tenant_organizations where id = '" + domainid + "'";
var datas = queryByDSName(dsNames.DS_OBPM2, sql);
var info = new Packages.java.util.HashMap();
if(datas != null){
var iterator = datas.iterator();
if(iterator.hasNext()){
info = iterator.next();
}
}
return info;
}
/**
根据监管组织编码获取名称
*/
function getSuperviseDepartmentName(departmentId){
var name = "";
try {
if (isNotNull(departmentId)){
var regulatorSql = "SELECT ITEM_NAME FROM tlk_departmentlevel WHERE ITEM_CODE = '" + departmentId + "';";
var datas = queryByDSName(dsNames.DS_ORGANIZATIONAUTH, regulatorSql);
if (datas != null) {
var iterator = datas.iterator();
if(iterator.hasNext()){
var map1 = iterator.next();//取值
name = map1.get("ITEM_NAME");
}
}
}
return name;
}catch (e){
println("获取当前层级监管机构名称"+e);
return name;
}
}
]]>
42