From 8160808e6b69f2d1a0e0ea1a249582f563a2c3e6 Mon Sep 17 00:00:00 2001
From: zxl <763096477@qq.com>
Date: 星期一, 24 二月 2025 12:01:30 +0800
Subject: [PATCH] sql p.deleted = 0
---
business/src/main/resources/mapper/ProjectInfoMapper.xml | 2 +-
business/src/main/java/com/ycl/service/impl/ProjectInfoServiceImpl.java | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/business/src/main/java/com/ycl/service/impl/ProjectInfoServiceImpl.java b/business/src/main/java/com/ycl/service/impl/ProjectInfoServiceImpl.java
index 611867a..fe7b15f 100644
--- a/business/src/main/java/com/ycl/service/impl/ProjectInfoServiceImpl.java
+++ b/business/src/main/java/com/ycl/service/impl/ProjectInfoServiceImpl.java
@@ -146,7 +146,7 @@
if (updateId == null) {
queryWrapper.eq("project_name", entity.getProjectName());
-
+ queryWrapper.eq("deleted",0);
if (StringUtils.isNotEmpty(entity.getProjectCode())) {
queryWrapper.eq("project_code", entity.getProjectCode());
}
diff --git a/business/src/main/resources/mapper/ProjectInfoMapper.xml b/business/src/main/resources/mapper/ProjectInfoMapper.xml
index c6db4ae..fffefae 100644
--- a/business/src/main/resources/mapper/ProjectInfoMapper.xml
+++ b/business/src/main/resources/mapper/ProjectInfoMapper.xml
@@ -242,7 +242,7 @@
<id column="id" property="id"/>
</resultMap>
<select id="checkProjectNameAndIdIsUnique" resultMap="pInfo">
- select p.id from t_project_info p where p.project_name =#{name} and p.id != #{id}
+ select p.id from t_project_info p where p.project_name =#{name} and p.id != #{id} and p.deleted = 0
<if test="code !=null and code !=''">
and p.project_code =#{code}
</if>
--
Gitblit v1.8.0