station name can not have the same name

Fancy

2024-07-06 1e8e849c1cbd576dde8dc01efc63f80cf602e2eb

station name can not have the same name

 pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/daoPlt/PltStationMapper.java

@@ -31,6 +31,8 @@

    List<PltStation> selectAll();

    List<PltStation> selectByName(String name);

    String selectMaxCode();

    List<PltStation> selectStationList(PltStation record);

 pms-parent/pms-global/src/main/resources/mapper/PltStationMapper.xml

@@ -33,7 +33,11 @@
        from plt_station
        where  id = #{id,jdbcType=BIGINT} and deleted!=1
    </select>

    <select id="selectByName" parameterType="java.lang.String" resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List" />
        from plt_station where name = #{name,jdbcType=VARCHAR} and deleted!=1
    </select>
    <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPlt.PltStation" useGeneratedKeys="true">
        insert into plt_station
        <trim prefix="(" suffix=")" suffixOverrides=",">

 pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/station/StationSv.java

@@ -1,13 +1,10 @@
package com.dy.pmsPlatform.station;

import cn.hutool.core.codec.Base64;
import com.alibaba.excel.util.StringUtils;
import com.dy.common.webUtil.QueryResultVo;
import com.dy.pmsGlobal.daoPlt.PltStationMapper;
import com.dy.pmsGlobal.pojoPlt.PltProduct;
import com.dy.pmsGlobal.pojoPlt.PltStation;
import com.dy.pmsGlobal.util.QrCodeUtil;
import com.google.zxing.WriterException;
import lombok.extern.slf4j.Slf4j;
import org.apache.dubbo.common.utils.PojoUtils;
import org.springframework.beans.factory.annotation.Autowired;
@@ -15,7 +12,6 @@
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.io.IOException;
import java.util.List;
import java.util.Map;

@@ -36,9 +32,9 @@
    @Transactional
    public int save(PltStation station) throws RuntimeException {

//        if(dao.selectByCodeId(station.id,station.code)>0){
//            throw new RuntimeException("工站编号已存在");
//        }
        if(dao.selectByName(station.getName()).size() > 0){
            throw new RuntimeException("工站名称("+station.getName()+")已存在,名称不允许重复添加,请变更");
        }
        int count = 0;
        int flag=0;
        do {
@@ -81,13 +77,22 @@
        return this.dao.deleteLogicById(id);
    }



    @Transactional
    public int update(PltStation station) throws RuntimeException {
//        if(dao.selectByCodeId(station.id,station.code)>0){
//            throw new RuntimeException("工站编号已存在");
//        }
        boolean flag = false;
        List<PltStation>  stations = dao.selectByName(station.getName());
        for (int i = 0; i < stations.size(); i++) {
            if(stations.get(i).getId().equals(station.getId())){
                flag = true;
                break;
            }
        }
        if(!flag){
            throw new RuntimeException("工站名称("+station.getName()+")已存在,名称不允许重复添加,请变更");
        }
        int count = dao.updateByPrimaryKeySelective(station);
        return count;
    }