重复性校验合集

标题：重复性校验

package com.dss.check;

import org.springframework.web.bind.annotation.RequestBody;

/**
 * @Author:Doris
 * @Date:2019/11/26
 * @Description:code唯一性校验
 * @version:1.0
 */
public class CheckCode {
    public ResultBean<?> checkCode(@RequestBody Solicitation entity) {
        boolean isRepeat = false;  //code未重复
        QueryWrapper<Solicitation> query = new QueryWrapper<>();
        query.eq("code", entity.getCode());//根据code查询
        List<Solicitation> list = solicitationService.list(query);
        if (entity.getId() != null) {   //修改
            Solicitation solicitation = ckfCulSolicitationService.getById(entity.getId());
            if (solicitation.getCode().equals(entity.getCode())) {  //修改为本身的code
                return ResultUtil.success(isRepeat);//未重复
            } else { //修改为其他code
                if (list.size() > 0) {
                    isRepeat = true;//code重复
                    return ResultUtil.success(isRepeat);
                } else {
                    return ResultUtil.success(isRepeat);//code未重复
                }
            }
        } else {
            if (list.size() > 0) {
                isRepeat = true; //code重复
                return ResultUtil.success(isRepeat);
            } else {
                return ResultUtil.success(isRepeat);//code未重复
            }
        }
    }
}
  

public boolean validateCode(Depot entity,int addType){
       boolean isExist = false;//未重复
       if (addType == 0){ //新增操作
           QueryWrapper<Depot> query = new QueryWrapper();
           query.eq("is_delete",false);
           query.eq("code",entity.getCode());
           query.eq("type",entity.getType());
           int count = depotService.count(query);
           if(count>0){
               return true;//编号重复
           }else{
               return false;//不重复
           }
       }else{ //修改操作
           QueryWrapper<Depot> query = new QueryWrapper();
           query.eq("is_delete",false);
           query.eq("code",entity.getCode());
           query.eq("type",entity.getType());
           query.ne("depot_id",entity.getDepotId()); //排除自身id
           int count = depotService.count(query);
           
           if (count > 0){
               return true;  //编号重复
           }else{
               return  false;
           }
       }
    }

// 校验总登号 flag=1:新增,flag=2修改
	private boolean checkTotalNumber(CkfCulIntocollectItem entity, int flag) {
		if (flag == 1) { // 新增
			QueryWrapper<CkfCulIntocollectItem> queryWrapper = new QueryWrapper<>();
			queryWrapper.eq("total_number", entity.getTotalNumber());
			queryWrapper.eq("is_delete", false);
			int count = service.count(queryWrapper);
			if (count > 0) {
				return true; // 重复
			} else {
				return false;
			}
		} else { // 修改
			QueryWrapper<CkfCulIntocollectItem> queryWrapper = new QueryWrapper<>();
			queryWrapper.eq("total_number", entity.getTotalNumber());
			queryWrapper.eq("is_delete", false);
			queryWrapper.ne("collect_item_id", entity.getCollectItemId());
			int count = service.count(queryWrapper);
			if (count > 0) {
				return true; // 重复
			} else {
				return false;
			}
		}
	}