新建电源

whyclxw

2025-05-16 78087f225a4b90fba36c0c0697bc457cb363a5ab

新建电源

 src/main/java/com/whyc/mapper/PowerInfMapper.java

@@ -3,6 +3,7 @@
import com.whyc.dto.PowerDto;
import com.whyc.pojo.db_station.PowerInf;
import com.whyc.pojo.db_station.StationInf;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@@ -12,4 +13,6 @@
    int getMaxPowerId();
    //查询电源
    List<PowerInf> getPower(PowerDto dto);
    //电源需要编号，powerNum编号，电源名称自动生成通讯电源+powerNum
    int getMaxPowerNum(@Param("stationId") Integer stationId);
}

 src/main/java/com/whyc/pojo/db_station/PowerInf.java

@@ -42,7 +42,7 @@
    @ApiModelProperty(value = "电源编号")
    private Integer powerNum;

    @ApiModelProperty(value = "机房名称[拼接后的]")
    @ApiModelProperty(value = "电源名称")
    private String powerName;

    @ApiModelProperty(value = "厂家")

 src/main/java/com/whyc/service/PowerInfService.java

@@ -30,7 +30,11 @@
    @Autowired(required = false)
    private BaojigroupService bjService;

    //添加电源
    /*添加电源
    1.判断当前用户是否是包组用户
    2.判断机房是否存在，若存在则在机房下添加电源，若不存在则新建机房+新建电源
    3.电源需要编号，powerNum编号，电源名称自动生成通讯电源+powerNum
    */
    @Transactional
   public Response addPower(PowerInf addpinf) {
       //先校验当前用户是否存在包机组不存在则不让添加电源
@@ -64,17 +68,17 @@
            addsinf.setStationId(stationId);
            sinfMapper.insert(addsinf);
        }
        //判断机房是否存在
        QueryWrapper wrapper1=new QueryWrapper();
        wrapper1.eq("power_name",addpinf.getPowerName());
        wrapper1.eq("station_id",stationId);
        wrapper1.last("limit 1");
        PowerInf juegep=mapper.selectOne(wrapper);
        if(juegep==null){
            return new Response().set(1, false, "当前机房下已添加过该电源");
        //电源需要编号，powerNum编号，电源名称自动生成通讯电源+powerNum
        int powerNum=mapper.getMaxPowerNum(stationId);
        if(powerNum==0){
            powerNum=1;
        }else{
            powerNum+=1;
        }
        //再添加电源信息
        addpinf.setStationId(stationId);
        addpinf.setPowerNum(powerNum);
        addpinf.setPowerName("通讯电源"+powerNum);
        //获取对应的电源id
        powerId = mapper.getMaxPowerId();
        if (powerId == 0) {//数据库中没有站点

 src/main/resources/mapper/PowerInfMapper.xml

@@ -10,6 +10,9 @@
    <select id="getMaxPowerId" resultType="java.lang.Integer">
        select ifnull(max(power_id),0) from  db_station.tb_power_inf where power_id>0;
    </select>
    <select id="getMaxPowerNum" resultType="java.lang.Integer">
        select ifnull(max(power_num),0) from  db_station.tb_power_inf where station_id=#{stationId};
    </select>
    <select id="getPower" resultType="com.whyc.pojo.db_station.PowerInf">
        select tb_power_inf.*,tb_station_inf.station_name,tb_station_inf.provice,tb_station_inf.city,tb_station_inf.country,tb_station_inf.full_name
        from db_station.tb_power_inf,db_station.tb_station_inf
@@ -38,4 +41,5 @@
        </if>

    </select>

</mapper>