sql p.deleted = 0

zxl

2025-02-24 8160808e6b69f2d1a0e0ea1a249582f563a2c3e6

sql p.deleted = 0

 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());
            }

 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>