fix: 修复数据库表名大小写不一致问题及SQL查询错误

yubo

2025-09-24 d89118c8c2f83e4d39f05b774e9019141f0a6341

 febs-server/febs-server-system/src/main/java/cc/mrbird/febs/server/system/service/impl/DicServiceImpl.java

@@ -3,6 +3,7 @@
import cc.mrbird.febs.common.core.constant.ModuleCode;
import cc.mrbird.febs.common.core.entity.QueryRequest;
import cc.mrbird.febs.common.core.entity.system.Dic;
import cc.mrbird.febs.common.core.entity.system.Position;
import cc.mrbird.febs.common.core.utils.FebsUtil;
import cc.mrbird.febs.common.core.utils.SequenceUtil;
import cc.mrbird.febs.server.system.mapper.DicMapper;
@@ -12,6 +13,7 @@
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.RequiredArgsConstructor;
import org.apache.commons.lang3.StringUtils;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
@@ -41,6 +43,9 @@
    public IPage<Dic> findDics(QueryRequest request, Dic dic) {
        LambdaQueryWrapper<Dic> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(Dic::getDelFlag, 0);
        if(StringUtils.isNotBlank(dic.getDicName())){
            queryWrapper.like(Dic::getDicName, dic.getDicName());
        }
        Page<Dic> page = new Page<>(request.getPageNum(), request.getPageSize());
        return this.page(page, queryWrapper);
    }
@@ -78,6 +83,7 @@
    public void deleteDic(Dic dic) {
        LambdaQueryWrapper<Dic> wrapper = new LambdaQueryWrapper<>();
// TODO 设置删除条件
        wrapper.eq(Dic::getDicId, dic.getDicId());
        this.remove(wrapper);
    }

@@ -95,6 +101,11 @@
    public void logicDelDic(String ids) {
        String[] str = ids.split(",");
        List<String> list = new ArrayList<>(Arrays.asList(str));
        dicMapper.logicDeleteByIds(list, operatorId);
        for (String str1:list){
            LambdaQueryWrapper<Dic> wrapper = new LambdaQueryWrapper<>();
// TODO 设置删除条件
            wrapper.eq(Dic::getDicId, str1);
            this.remove(wrapper);
        }
    }
}