代码示例如下:
function getUsersByDeptAndRoles(roleName, department) {
var userList = createObject("java.util.ArrayList");
var roleid = getRoleIdByName(roleName);
var sql = "select '" + getDomainid() + "'AS DOMAINID , userid as item_userid from " + DATASOURENAME + ".t_user_department_role_set where departmentid='" + department + "' and roleid='" + roleid + "'";
var datas = queryBySQL(sql);
if (datas != null) {
for (var iter = datas.iterator(); iter.hasNext(); ) {
var data = iter.next();
var userid = data.getItemValueAsString("userid");
userList.add(userid);
}
}
return userList;
}