| | |
|---|
| | | public List<FinSysTenantUser> getByOrgId(Long orgId) { |
|---|
| | | return this.select(SQL_GET_USER, new Object[] {orgId}, new FinSysTenantUser()); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public GenericPager<S_role> queryPageRoleList(Long orgId, Integer status, String roleName, Integer dataScope, |
|---|
| | | Integer pageNum, Integer pageSize) { |
|---|
| | | Map<String, Object> parameters = new HashMap(); |
|---|
| | | StringBuilder sql = new StringBuilder("select * from s_role where org_id=:orgId"); |
|---|
| | | parameters.put("orgId", orgId); |
|---|
| | | if (status >= 0) { |
|---|
| | | sql.append(" and status=:status"); |
|---|
| | | parameters.put("status", status); |
|---|
| | | } |
|---|
| | | |
|---|
| | | if (dataScope != null) { |
|---|
| | | sql.append(" and data_scope >=:dataScope"); |
|---|
| | | parameters.put("dataScope", dataScope); |
|---|
| | | } |
|---|
| | | |
|---|
| | | if (com.walker.infrastructure.utils.StringUtils.isNotEmpty(roleName)) { |
|---|
| | | sql.append(" and role_name like :roleName"); |
|---|
| | | parameters.put("roleName", "%" + roleName + "%"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | return this.selectSplit(sql.toString(), parameters, pageNum, pageSize, new S_role()); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public FinSysTenantUser getByTenaniId(String tenantId,String userCode) { |
|---|
| | | Map<String, Object> parameter = new HashMap<>(); |
|---|
| | | StringBuilder sql = new StringBuilder(SQL_SELECT_USER_CODE); |
|---|
| | | sql.append(" and TENANT_ID= :tenantId"); |
|---|
| | | parameter.put("tenantId", tenantId); |
|---|
| | | sql.append(" and USER_CODE= :userCode"); |
|---|
| | | parameter.put("userCode", userCode); |
|---|
| | | FinSysTenantUser finSysTenantUser = this.get(sql.toString(), parameter, new FinSysTenantUser()); |
|---|
| | | return finSysTenantUser; |
|---|
| | | } |
|---|
| | | } |
|---|
