art: 系统管理-字段重复值校验修改

zhangherong

2025-03-20 cff3eeb04b238135f64f97e60b5a6f5639963281

art: 系统管理-字段重复值校验修改

 lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/controller/DuplicateCheckController.java

@@ -1,5 +1,6 @@
package org.jeecg.modules.system.controller;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;

import org.apache.commons.lang.StringUtils;
@@ -31,8 +32,8 @@
@Api(tags="重复校验")
public class DuplicateCheckController {

    @Autowired
    SysDictMapper sysDictMapper;
    @Resource
    private SysDictMapper sysDictMapper;

    @Autowired
    DictQueryBlackListHandler dictQueryBlackListHandler;

 lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/xml/SysDictMapper.xml

@@ -99,12 +99,18 @@

    <!-- 重复校验 sql语句 -->
    <select id="duplicateCheckCountSql" resultType="Long" parameterType="org.jeecg.modules.system.model.DuplicateCheckVo">
        SELECT COUNT(*) FROM ${tableName} WHERE ${fieldName} = #{fieldVal} and id &lt;&gt; #{dataId}
        SELECT COUNT(1) FROM ${tableName} WHERE ${fieldName} = #{fieldVal} and id &lt;&gt; #{dataId}
        <if test="delFlag != null and delFlag ">
            and del_flag=0
        </if>
    </select>

    <!-- 重复校验 sql语句 -->
    <select id="duplicateCheckCountSqlNoDataId" resultType="Long" parameterType="org.jeecg.modules.system.model.DuplicateCheckVo">
        SELECT COUNT(*) FROM ${tableName} WHERE ${fieldName} = #{fieldVal}
        SELECT COUNT(1) FROM ${tableName} WHERE ${fieldName} = #{fieldVal}
        <if test="delFlag != null and delFlag ">
            and del_flag=0
        </if>
    </select>

    <!-- 查询部门信息 作为字典数据 -->

 lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/model/DuplicateCheckVo.java

@@ -41,4 +41,10 @@
    @ApiModelProperty(value="数据ID",name="dataId",example="2000")
    private String dataId;

    /**
     * 删除标记
     */
    @ApiModelProperty(value="删除标记",name="delFlag",example="0")
    private Boolean delFlag;

}