From c7e058bb6dc997bde478c488ddc98561c61085dc Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期六, 17 五月 2025 14:39:14 +0800
Subject: [PATCH] 查询机房，电源，电池组信息
---
src/main/java/com/whyc/service/BattInfService.java | 131 ++++++++++++++++++++++++++++++++++++++++---
1 files changed, 122 insertions(+), 9 deletions(-)
diff --git a/src/main/java/com/whyc/service/BattInfService.java b/src/main/java/com/whyc/service/BattInfService.java
index a4c0bd1..f502949 100644
--- a/src/main/java/com/whyc/service/BattInfService.java
+++ b/src/main/java/com/whyc/service/BattInfService.java
@@ -6,8 +6,8 @@
import com.github.pagehelper.PageInfo;
import com.whyc.dto.BattDto;
import com.whyc.dto.InfoDto;
-import com.whyc.dto.PowerDto;
import com.whyc.dto.Response;
+import com.whyc.factory.InfoFactory;
import com.whyc.mapper.BattInfMapper;
import com.whyc.mapper.PowerInfMapper;
import com.whyc.mapper.StationInfMapper;
@@ -33,6 +33,9 @@
@Autowired(required = false)
private StationInfMapper sinfMapper;
+
+ @Autowired(required = false)
+ private BaojigroupService bjService;
/*鏂板缓鐢垫睜缁勶紙鏂扮殑璁惧鏂扮殑鐢垫睜缁勶級
* @param binf
@@ -118,6 +121,8 @@
UpdateWrapper wrapper2=new UpdateWrapper();
wrapper2.eq("power_id",powerId);
pinfMapper.delete(wrapper);
+ //鍒犻櫎鎵�鏈夊寘鏈虹粍涓嬬殑鐢垫簮
+ bjService.delPowerInBaoji(powerId);
//鍐嶆娴嬪鏋滄満鎴夸笅鐢垫簮涔熷叏鍒犻櫎浜嗭紝瑕佸皢鏈烘埧涔熷垹闄�
QueryWrapper wrapper3=new QueryWrapper();
wrapper3.eq("station_id",stationId);
@@ -126,11 +131,124 @@
UpdateWrapper wrapper4=new UpdateWrapper();
wrapper4.eq("station_id",stationId);
sinfMapper.delete(wrapper4);
+ //鍒犻櫎鎵�鏈夊寘鏈虹粍涓嬬殑鏈烘埧
+ bjService.delStationInBaoji(stationId);
}
}
return new Response().set(1,true);
}
- //淇敼鐢垫睜缁�
+ //缂栬緫鏈烘埧锛岀數婧愶紝鐢垫睜缁勪俊鎭�
+ @Transactional
+ public Response updateInfo(InfoDto info) {
+ //鍏堜慨鏀规満鎴夸俊鎭�
+ PowerInf pinf=InfoFactory.infoToPower(info);
+ StationInf sinf=pinf.getSinf();
+ UpdateWrapper wrapper1=new UpdateWrapper();
+ if(sinf.getStationName()!=null){
+ wrapper1.set("station_name",sinf.getStationName());
+ String fullName=sinf.getProvice()+"_"+sinf.getCity()+"_"+sinf.getCountry()+"_"+sinf.getStationName();
+ wrapper1.set("full_name",fullName);
+ }
+ if(sinf.getStationType()!=null){
+ wrapper1.set("station_type",sinf.getStationType());
+ }
+ if(sinf.getLongitude()!=null){
+ wrapper1.set("longitude",sinf.getLongitude());
+ }
+ if(sinf.getLatitude()!=null){
+ wrapper1.set("latitude",sinf.getLatitude());
+ }
+ wrapper1.eq("station_id",sinf.getStationId());
+ sinfMapper.update((StationInf) ActionUtil.objeNull,wrapper1);
+ //鍐嶄慨鏀圭數婧愪俊鎭�
+ UpdateWrapper wrapper2=new UpdateWrapper();
+ if(pinf.getCompany()!=null){
+ wrapper2.set("company",pinf.getCompany());
+ }
+ if(pinf.getPowerModel()!=null){
+ wrapper2.set("power_model",pinf.getPowerModel());
+ }
+ if(pinf.getProtocol()!=null){
+ wrapper2.set("protocol",pinf.getProtocol());
+ }
+ if(pinf.getPowerIp()!=null){
+ wrapper2.set("power_ip",pinf.getPowerIp());
+ }
+ if(pinf.getPowerName()!=null){
+ //妫�娴嬭鏈烘埧涓嬭淇敼鐨勭數婧愬悕鏄惁瀛樺湪
+ QueryWrapper queryWrapper=new QueryWrapper();
+ queryWrapper.eq("power_name",pinf.getPowerName());
+ queryWrapper.eq("station_id",pinf.getStationId());
+ queryWrapper.last("limit 1");
+ PowerInf juegep=pinfMapper.selectOne(queryWrapper);
+ if(juegep!=null){
+ return new Response().set(1,false,"璇ユ満鎴夸笅宸插瓨鍦�"+pinf.getPowerName()+"鐨勭數婧�");
+ }
+ wrapper2.set("power_name",pinf.getPowerName());
+ }
+ wrapper2.eq("power_id",pinf.getPowerId());
+ pinfMapper.update((PowerInf) ActionUtil.objeNull,wrapper2);
+ //鏈�鍚庝慨鏀硅澶囦俊鎭�
+ BattInf binf=InfoFactory.infoToBatt(info);
+ UpdateWrapper wrapper3=new UpdateWrapper();
+ if(binf.getDevIp()!=null){
+ wrapper3.set("dev_ip",binf.getDevIp());
+ }
+ if(binf.getDevName()!=null){
+ //妫�娴嬭鐢垫簮涓嬩慨鏀圭殑璁惧鍚嶆槸鍚﹀瓨鍦�
+ QueryWrapper queryWrapper1=new QueryWrapper();
+ queryWrapper1.eq("dev_name",binf.getDevName());
+ queryWrapper1.eq("power_id",pinf.getPowerId());
+ queryWrapper1.last("limit 1");
+ BattInf jueged=mapper.selectOne(queryWrapper1);
+ if(jueged!=null){
+ return new Response().set(1,false,"璇ョ數婧愪笅宸插瓨鍦�"+binf.getDevName()+"鐨勮澶�");
+ }
+ wrapper3.set("dev_name",binf.getDevName());
+ }
+ if(binf.getDevType()!=null){
+ wrapper3.set("dev_type",binf.getDevType());
+ }
+ wrapper3.eq("dev_id",binf.getDevId());
+ mapper.update((BattInf) ActionUtil.objeNull,wrapper3);
+
+ //淇敼鐢垫睜缁勪俊鎭�
+ UpdateWrapper wrapper4=new UpdateWrapper();
+ if(binf.getBattgroupName()!=null){
+ //妫�娴嬭鏈烘埧涓嬭淇敼鐨勭數婧愬悕鏄惁绮楀湪
+ QueryWrapper queryWrapper=new QueryWrapper();
+ queryWrapper.eq("battgroup_name",binf.getBattgroupName());
+ queryWrapper.eq("dev_id",binf.getDevId());
+ queryWrapper.last("limit 1");
+ BattInf juegeb=mapper.selectOne(queryWrapper);
+ if(juegeb!=null){
+ return new Response().set(1,false,"璇ヨ澶囦笅宸插瓨鍦�"+binf.getBattgroupName()+"鐨勭數姹犵粍");
+ }
+ wrapper4.set("battgroup_name",binf.getBattgroupName());
+ }
+ if(binf.getMonvolstd()!=null){
+ wrapper4.set("monvolstd",binf.getMonvolstd());
+ }
+ if(binf.getMoncapstd()!=null){
+ wrapper4.set("moncapstd",binf.getMoncapstd());
+ }
+ if(binf.getMonresstd()!=null){
+ wrapper4.set("monresstd",binf.getMonresstd());
+ }
+ if(binf.getProduct()!=null){
+ wrapper4.set("product",binf.getProduct());
+ }
+ if(binf.getMoncount()!=null){
+ wrapper4.set("moncount",binf.getMoncount());
+ }
+ if(binf.getBattModel()!=null){
+ wrapper4.set("batt_model",binf.getBattModel());
+ }
+ wrapper4.eq("battgroup_id",binf.getBattgroupId());
+ mapper.update((BattInf) ActionUtil.objeNull,wrapper4);
+ return new Response().set(1,true);
+ }
+ /*//淇敼鐢垫睜缁�
public Response updateBatt(BattInf binf) {
UpdateWrapper wrapper1=new UpdateWrapper();
wrapper1.eq("dev_id",binf.getDevId());
@@ -174,7 +292,7 @@
}
mapper.update((BattInf) ActionUtil.objeNull,wrapper);
return new Response().set(1,true);
- }
+ }*/
//鏌ヨ鏈烘埧锛岀數婧愶紝鐢垫睜缁勪俊鎭�
public Response getInfo(BattDto dto) {
User user= ActionUtil.getUser();
@@ -183,12 +301,6 @@
List<InfoDto> list=mapper.getInfo(dto);
PageInfo pageInfo=new PageInfo(list);
return new Response().setII(1,list!=null,pageInfo,"鏌ヨ鐢垫睜");
- }
- //鍒犻櫎鐢垫簮涓嬬殑鐢垫睜缁�
- public void delBattInPower(Integer pid) {
- UpdateWrapper wrapper=new UpdateWrapper();
- wrapper.eq("power_id",pid);
- mapper.delete(wrapper);
}
//鑾峰彇鐢垫睜鍝佺墝(涓嬫媺)
@@ -218,4 +330,5 @@
List<String> list=mapper.getDevTypeByUid(uid);
return new Response().setII(1,list.size()>0,list,"鑾峰彇璁惧鍨嬪彿(涓嬫媺)");
}
+
}
\ No newline at end of file
--
Gitblit v1.9.1