From 1e8e849c1cbd576dde8dc01efc63f80cf602e2eb Mon Sep 17 00:00:00 2001
From: Fancy <Fancy.fx@outlook.com>
Date: 星期六, 06 七月 2024 10:00:00 +0800
Subject: [PATCH] station name can not have the same name
---
pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/station/StationSv.java | 23 ++++++++++++++---------
pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/daoPlt/PltStationMapper.java | 2 ++
pms-parent/pms-global/src/main/resources/mapper/PltStationMapper.xml | 6 +++++-
3 files changed, 21 insertions(+), 10 deletions(-)
diff --git a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/daoPlt/PltStationMapper.java b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/daoPlt/PltStationMapper.java
index 59d4077..499abac 100644
--- a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/daoPlt/PltStationMapper.java
+++ b/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);
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PltStationMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PltStationMapper.xml
index 969a618..159b02f 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PltStationMapper.xml
+++ b/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=",">
diff --git a/pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/station/StationSv.java b/pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/station/StationSv.java
index 3890a5a..4d220a8 100644
--- a/pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/station/StationSv.java
+++ b/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;
}
--
Gitblit v1.8.0