From 24c4699005da96f45562d7057d80c103b8e428a2 Mon Sep 17 00:00:00 2001 From: WangHan <wwh_work@126,com> Date: 星期五, 03 一月 2025 10:32:34 +0800 Subject: [PATCH] 子级分类在用删除 --- consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantUserServiceImpl.java | 36 ++++++++++++++++++++++++++++++++++++ 1 files changed, 36 insertions(+), 0 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantUserServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantUserServiceImpl.java index d40f9dd..a612b3f 100644 --- a/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantUserServiceImpl.java +++ b/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantUserServiceImpl.java @@ -269,4 +269,40 @@ 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; + } } -- Gitblit v1.9.1