From 2a370db9610af10873bd0292b5d5fd7246fd4039 Mon Sep 17 00:00:00 2001 From: futian.liu <liufutianyoo@163.com> Date: 星期二, 12 十二月 2023 16:13:38 +0800 Subject: [PATCH] 新增用户提示区县错误 --- consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantUserServiceImpl.java | 69 +++++++++++++++------------------- 1 files changed, 31 insertions(+), 38 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/service/FinSysTenantUserServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantUserServiceImpl.java similarity index 88% rename from consum-base/src/main/java/com/consum/base/service/FinSysTenantUserServiceImpl.java rename to consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantUserServiceImpl.java index cb746a6..7551184 100644 --- a/consum-base/src/main/java/com/consum/base/service/FinSysTenantUserServiceImpl.java +++ b/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantUserServiceImpl.java @@ -1,4 +1,12 @@ -package com.consum.base.service; +package com.consum.base.service.impl; + +import com.consum.base.service.FinSysTenantUserService; +import java.util.ArrayList; +import java.util.HashMap; +import java.util.List; +import java.util.Map; + +import org.springframework.stereotype.Service; import com.consum.base.pojo.FinSysTenantUserSearchParam; import com.consum.model.po.FinSysTenantUser; @@ -9,15 +17,9 @@ import com.walker.db.page.GenericPager; import com.walker.infrastructure.utils.StringUtils; import com.walker.jdbc.service.BaseServiceImpl; -import org.springframework.stereotype.Service; - -import java.util.ArrayList; -import java.util.HashMap; -import java.util.List; -import java.util.Map; @Service -public class FinSysTenantUserServiceImpl extends BaseServiceImpl { +public class FinSysTenantUserServiceImpl extends BaseServiceImpl implements FinSysTenantUserService { private static final String SQL_GET_USER = "SELECT * FROM fin_sys_tenant_user WHERE IS_DELETE = 0 AND `STATUS` = 1 AND TENANT_ID = ?"; @@ -50,6 +52,7 @@ * @Author wh * @Date 2023/7/17 14:26 */ + @Override public GenericPager<FinSysTenantUser> queryAllPageUser(FinSysTenantUserSearchParam param) { Map<String, Object> parameter = new HashMap<>(5); StringBuilder sql = new StringBuilder(SQL_QH_PAGE_USER_PREFIX); @@ -118,6 +121,7 @@ return this.selectSplit(sql.toString(), parameter, new FinSysTenantUser()); } + @Override public FinSysTenantUser queryOneById(String id) { FinSysTenantUser finSysTenantUser = new FinSysTenantUser(); finSysTenantUser.setId(Long.valueOf(id)); @@ -127,7 +131,9 @@ } return null; } - public FinSysTenantUser queryOneBySysId(String sysUserId) { + + @Override + public FinSysTenantUser queryOneBySysId(String sysUserId) { FinSysTenantUser finSysTenantUser = new FinSysTenantUser(); finSysTenantUser.setSysUserId(Long.valueOf(sysUserId)); List<FinSysTenantUser> finSysTenantUserList = this.select(finSysTenantUser); @@ -137,14 +143,10 @@ return null; } + @Override public FinSysTenantUser queryOneByUserId(String userId) { - List<FinSysTenantUser> finSysTenantUserList = - this.select(SQL_TENANT_USER, new Object[] {userId}, new FinSysTenantUser()); - if (finSysTenantUserList.size() > 0) { - return finSysTenantUserList.get(0); - } else { - return null; - } + FinSysTenantUser finSysTenantUser = this.get(SQL_TENANT_USER, new Object[] {userId}, new FinSysTenantUser()); + return finSysTenantUser; } /** @@ -153,6 +155,7 @@ * @param roleIdList * @param userId */ + @Override public void execInsertRoleUserList(List<Long> roleIdList, Long userId) { List<Object[]> parameters = new ArrayList<>(); Object[] one = null; @@ -168,6 +171,7 @@ /** * 鎵归噺娣诲姞瑙掕壊瀵瑰簲鐨勭敤鎴枫�傛敮鎸佸悓鏃跺涓敤鎴� */ + @Override public void execInsertRoleUserList(List<FinSysTenantUser> finSysTenantUsers) { List<Object[]> parameters = new ArrayList<>(); for (FinSysTenantUser finSysTenantUser : finSysTenantUsers) { @@ -188,6 +192,7 @@ * * @param userId */ + @Override public void execDelRoleUserList(Long userId) { List<Object[]> parameters = new ArrayList<>(); Object[] one = new Object[1]; @@ -196,19 +201,7 @@ this.execBatchUpdate(SQL_DELETE_ROLE_USER, parameters); } - /** - * 鏍规嵁鐢ㄦ埛id鍜岃鑹瞚d鍒犻櫎鐢ㄦ埛瑙掕壊 - * - * @param userId - */ - public void execDeleteRoleByUserIdAndRoleId(Long userId, Long roleId) { - List<Object[]> parameters = new ArrayList<>(); - Object[] one = new Object[2]; - one[0] = userId; - one[1] = roleId; - parameters.add(one); - this.execBatchUpdate(SQL_DELETE_ROLE_BY_USER_ID_AND_ROLE_ID, parameters); - } + /** * 鏍规嵁userCode鏌ヨ閲嶅銆� @@ -216,18 +209,14 @@ * @param userCode 鐢ㄦ埛鐧诲綍鏍囪瘑 * @return */ - public Integer getByUserCode(String userCode) { + @Override + public FinSysTenantUser getByUserCode(String userCode) { Map<String, Object> parameter = new HashMap<>(); StringBuilder sql = new StringBuilder(SQL_SELECT_USER_CODE); - sql.append("and USER_CODE= :userCode"); + sql.append("and USER_CODE= :userCode"); parameter.put("userCode", userCode); - sql.append(" limit 1"); - List<FinSysTenantUser> select = this.select(sql.toString(), parameter, new FinSysTenantUser()); - Integer flag = 0; - if (select != null && select.size() > 0) { - flag = select.size(); - } - return flag; + FinSysTenantUser finSysTenantUser = this.get(sql.toString(), parameter, new FinSysTenantUser()); + return finSysTenantUser; } /** @@ -236,6 +225,7 @@ * @param userId * @return */ + @Override public List<S_role> getByUserId(Long userId) { Map<String, Object> parameter = new HashMap<>(); StringBuilder sql = new StringBuilder(SQL_SELECT_USER_ID); @@ -250,6 +240,7 @@ * * @return */ + @Override public List<S_role> getRoleAll() { Map<String, Object> parameter = new HashMap<>(); StringBuilder sql = new StringBuilder(SQL_SELECT_USER_ID); @@ -257,6 +248,7 @@ return select; } + @Override public List<S_dept> selectDept(String deptName) { StringBuilder sqlStr = new StringBuilder(SQL_DEPT_ROLES); Map<String, Object> paramts = new HashMap<>(); @@ -271,6 +263,7 @@ * @Author wh * @Date 2023/10/4 15:49 */ + @Override public List<FinSysTenantUser> getByOrgId(Long orgId) { return this.select(SQL_GET_USER, new Object[] {orgId}, new FinSysTenantUser()); } -- Gitblit v1.9.1