From 7306feb6ef771bce42a9df846284ad6f57efb45c Mon Sep 17 00:00:00 2001 From: hewenqiang <1527468660@qq.com> Date: 星期四, 20 一月 2022 15:24:38 +0800 Subject: [PATCH] fix 修改用户信息校验方法。 1. 校验用户名称是否唯一采用baseMapper.exists()方法判断是否存在。 2. 校验手机号码和校验email是否唯一,当存在userId时,sql查询条件才加上不等于当前userId。 --- ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysPostServiceImpl.java | 20 ++++++++++---------- 1 files changed, 10 insertions(+), 10 deletions(-) diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysPostServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysPostServiceImpl.java index 640eed6..968ce2b 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysPostServiceImpl.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysPostServiceImpl.java @@ -33,9 +33,9 @@ @Override public TableDataInfo<SysPost> selectPagePostList(SysPost post, PageQuery pageQuery) { LambdaQueryWrapper<SysPost> lqw = new LambdaQueryWrapper<SysPost>() - .like(StringUtils.isNotBlank(post.getPostCode()), SysPost::getPostCode, post.getPostCode()) - .eq(StringUtils.isNotBlank(post.getStatus()), SysPost::getStatus, post.getStatus()) - .like(StringUtils.isNotBlank(post.getPostName()), SysPost::getPostName, post.getPostName()); + .like(StringUtils.isNotBlank(post.getPostCode()), SysPost::getPostCode, post.getPostCode()) + .eq(StringUtils.isNotBlank(post.getStatus()), SysPost::getStatus, post.getStatus()) + .like(StringUtils.isNotBlank(post.getPostName()), SysPost::getPostName, post.getPostName()); Page<SysPost> page = baseMapper.selectPage(pageQuery.build(), lqw); return TableDataInfo.build(page); } @@ -49,9 +49,9 @@ @Override public List<SysPost> selectPostList(SysPost post) { return baseMapper.selectList(new LambdaQueryWrapper<SysPost>() - .like(StringUtils.isNotBlank(post.getPostCode()), SysPost::getPostCode, post.getPostCode()) - .eq(StringUtils.isNotBlank(post.getStatus()), SysPost::getStatus, post.getStatus()) - .like(StringUtils.isNotBlank(post.getPostName()), SysPost::getPostName, post.getPostName())); + .like(StringUtils.isNotBlank(post.getPostCode()), SysPost::getPostCode, post.getPostCode()) + .eq(StringUtils.isNotBlank(post.getStatus()), SysPost::getStatus, post.getStatus()) + .like(StringUtils.isNotBlank(post.getPostName()), SysPost::getPostName, post.getPostName())); } /** @@ -96,8 +96,8 @@ public String checkPostNameUnique(SysPost post) { Long postId = StringUtils.isNull(post.getPostId()) ? -1L : post.getPostId(); boolean count = baseMapper.exists(new LambdaQueryWrapper<SysPost>() - .eq(SysPost::getPostName, post.getPostName()) - .ne(SysPost::getPostId, postId)); + .eq(SysPost::getPostName, post.getPostName()) + .ne(SysPost::getPostId, postId)); if (count) { return UserConstants.NOT_UNIQUE; } @@ -114,8 +114,8 @@ public String checkPostCodeUnique(SysPost post) { Long postId = StringUtils.isNull(post.getPostId()) ? -1L : post.getPostId(); boolean count = baseMapper.exists(new LambdaQueryWrapper<SysPost>() - .eq(SysPost::getPostCode, post.getPostCode()) - .ne(SysPost::getPostId, postId)); + .eq(SysPost::getPostCode, post.getPostCode()) + .ne(SysPost::getPostId, postId)); if (count) { return UserConstants.NOT_UNIQUE; } -- Gitblit v1.9.3