查询权限限制备份

TSUser user = ResourceUtil.getSessionUser();
        String departid = user.getDepartid();
        TSDepart tsDepart = systemService.getEntity(TSDepart.class, departid);
        String sysOrgCode = tsDepart.getOrgCode();
        try{
            //获取用户的角色
            List<TSRoleUser> rUsers1 = systemService.findByProperty(TSRoleUser.class, "TSUser.id", user.getId());
            boolean isture = true;
            for (TSRoleUser ru : rUsers1) {
                if (ru.getTSRole().getRoleName().equals("系统管理员") || ru.getTSRole().getRoleName().equals("管理员")) {
                    isture = false;
                }
            }
            if (isture) {
                // 自己组织只看自己
                if (StringUtil.isNotEmpty(sysOrgCode)) {
                    cq.add(Restrictions.sqlRestriction(" SUBSTR(sys_org_code,1,3) = SUBSTR('" + sysOrgCode + "',1,3)"));
                }
            }
        }catch (Exception e) {
            throw new BusinessException(e.getMessage());
        }