update

whycrzg

2021-02-23 351b9a53cb9ecebdf8f79db0117f540d9c42c2a4

 src/main/java/com/fgkj/mapper/impl/ram/Fbs9600_stateMapper.java

@@ -1,55 +1,70 @@
package com.fgkj.mapper.impl.ram;

import com.fgkj.dto.BattInf;
import com.fgkj.dto.User_inf;
import com.fgkj.dto.ram.Fbs9600_state;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

public interface Fbs9600_stateMapper{

   public boolean add(Object obj);
   @Insert("insert into db_ram_db.tb_Fbs9600_state(dev_ip,dev_id,op_cmd,dev_workstate,dev_alarmstate,dev_commcount," +
         "dev_errcommcount) values(#{dev_ip},#{dev_id},#{op_cmd},#{dev_workstate},#{dev_alarmstate},#{dev_commcount},#{dev_errcommcount})")
   public int add(Fbs9600_state state);

    //fbs显示屏启动放电
   public boolean update(Object obj);
   // public boolean update(Object obj);

   //fbs9600设备内阻测试
   public boolean updatePro(Object obj);
	
   public boolean del(Object obj);
   public int updatePro(List<Fbs9600_state> list);

   @Delete("delete from db_ram_db.tb_Fbs9600_state where num=#{num}")
   public int del(Fbs9600_state state);

   //FBS9600设备内阻测试显示全部9600设备的信息
   public List searchByUid(Object obj);
   @Select("select  distinct tb_Fbs9600_state.num,dev_ip,dev_id,op_cmd,dev_workstate,dev_alarmstate,dev_commcount,dev_errcommcount, " +
         " db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.FbsDeviceName " +
         " from db_ram_db.tb_Fbs9600_state  " +
         " left outer join db_battinf.tb_battinf ON tb_fbs9600_state.dev_id=db_battinf.tb_battinf.FBSDeviceId  " +
         " where  tb_fbs9600_state.dev_id in(select distinct db_battinf.tb_battinf.FBSDeviceId " +
         " from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf   " +
         " where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId   " +
         " and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id  " +
         " and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid  " +
         " and db_user.tb_user_inf.uid=#{uId} ) and tb_fbs9600_state.dev_id like '%9600%' or tb_fbs9600_state.dev_id like '%9616%' ")
   public List<Fbs9600_state> searchByUid(User_inf uinf);

   //11.1FBS9100设备通信状态查询
      /*
       * fbs9100：op_cmd:0:全部；1：fbs9100,2:fbs9600
       * dev_errcommcount;0:通讯正常，1：通讯中断，100：全部*/
   public List serchByCondition(Object obj);
   public List<Fbs9600_state> serchByCondition(Fbs9600_state state);
   
   //机房命令操作设备时的cmd和ack校验
   public boolean sendCmdToFBS9600Dev(int cmd,int dev_id);
//   public boolean sendCmdToFBS9600Dev(int cmd,int dev_id);
   
    //放电测试添加fbs9600设备的添加电池组的操作
   public List serchByInfo(Object obj);
	
   /*public static void main(String[] args) {
      Fbs9600_stateImpl fi=new Fbs9600_stateImpl();
      *//*Fbs9600_state fs=new Fbs9600_state();
      fs.setNum(5)*//*;
		
      Fbs9100_state fs=new Fbs9100_state();
       fs.setNum(5);
       fs.setDev_errcommcount(0);
	    
      *//*List<Fbs9600_state> list=fi.serchByCondition(fs);
      System.out.println(list.size());
      for(Fbs9600_state f:list){
         System.out.println(f);
      }*//*
       User_inf uinf=new User_inf();
       uinf.setUId(1002);
        List<Fbs9600_state> list=fi.searchByUid(uinf);
      System.out.println(list.size());
      for(Fbs9600_state f:list){
         System.out.println(f);
      }
   }*/
   @Select("select db_battinf.tb_battinf.battgroupid,db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.FBSDeviceId,db_battinf.tb_battinf.FBSDeviceIp,FbsDeviceName,db_battinf.tb_battinf.BattGroupName" +
         ",db_battinf.tb_battinf.GroupIndexInFBSDevice,db_battinf.tb_battinf.MonCount,db_battinf.tb_battinf.MonVolStd,db_battinf.tb_battinf.MonCapStd" +
         ",db_ram_db.tb_fbs9600_state.dev_ip,db_ram_db.tb_fbs9600_state.dev_id,db_ram_db.tb_fbs9600_state.op_cmd" +
         ",db_ram_db.tb_fbs9600_state.dev_commcount,db_ram_db.tb_fbs9600_state.dev_errcommcount  " +
         " FROM db_battinf.tb_battinf " +
         " LEFT OUTER JOIN db_ram_db.tb_fbs9600_state  on db_ram_db.tb_fbs9600_state.dev_id=db_battinf.tb_battinf.FBSDeviceId " +
         " where db_battinf.tb_battinf.StationName1 like concat('%',#{stationName1},'%') and db_battinf.tb_battinf.StationName LIKE concat('%',#{stationName},'%') " +
         " and db_battinf.tb_battinf.battgroupid=#{battGroupId} ")
   public List<Fbs9600_state> serchByInfo(BattInf binf);

   @Update( "UPDATE db_ram_db.tb_fbs9600_state  SET "
         + " op_cmd=#{m_cmd} "
         + " WHERE dev_id=#{dev_id} ")
   int updateOpCmdByDevId(int m_cmd, int dev_id);

   @Select("SELECT op_cmd FROM db_ram_db.tb_fbs9600_state "+
         " WHERE dev_id=#{dev_id}")
   int getOpCmdByDevId(int dev_id);
	
}