package com.whyc.service; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.whyc.mapper.BattInfChangeMapper; import com.whyc.mapper.PowerInfChangeMapper; import com.whyc.mapper.StationInfChangeMapper; import com.whyc.pojo.db_station.*; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.Date; import java.util.List; @Service public class InfoChangeService { @Autowired(required = false) private StationInfChangeMapper sinfChangeMapper; @Autowired(required = false) private PowerInfChangeMapper pinfChangeMapper; @Autowired(required = false) private BattInfChangeMapper binfChangeMapper; //存入变更信息记录 public void addInfoChange(StationInf sinf, PowerInf pinf, BattInf binf,String updateReason) { StationInfChange sinfChange = new StationInfChange(); PowerInfChange pinfChange = new PowerInfChange(); BattInfChange binfChange = new BattInfChange(); Date updateTime = new Date(); //将信息拷贝至对应的变更信息表 BeanUtils.copyProperties(sinf,sinfChange); String fullName=sinf.getProvice()+"_"+sinf.getCity()+"_"+sinf.getCountry()+"_"+sinf.getStationName(); sinfChange.setFullName(fullName); sinfChange.setUpdateTime(updateTime); sinfChange.setUpdateReason(updateReason); BeanUtils.copyProperties(pinf,pinfChange); pinfChange.setUpdateTime(updateTime); pinfChange.setUpdateReason(updateReason); BeanUtils.copyProperties(binf,binfChange); binfChange.setUpdateTime(updateTime); binfChange.setUpdateReason(updateReason); //将变更记录存入变更表 sinfChangeMapper.insert(sinfChange); pinfChangeMapper.insert(pinfChange); binfChangeMapper.insert(binfChange); } //获取机房,电源,电池组变更记录 public List getSinfChange(Integer stationId) { QueryWrapper wrapper=new QueryWrapper(); wrapper.eq("station_id",stationId); wrapper.orderByDesc("update_time"); List list=sinfChangeMapper.selectList(wrapper); return list; } public List getPinfChange(Integer powerId) { QueryWrapper wrapper=new QueryWrapper(); wrapper.eq("power_id",powerId); wrapper.orderByDesc("update_time"); List list=pinfChangeMapper.selectList(wrapper); return list; } public List getBinfChange(Integer battgroupId) { QueryWrapper wrapper=new QueryWrapper(); wrapper.eq("battgroup_id",battgroupId); wrapper.orderByDesc("update_time"); List list=binfChangeMapper.selectList(wrapper); return list; } }