package com.fgkj.mapper.impl.ram;
|
|
import com.fgkj.dto.BattInf;
|
import com.fgkj.dto.User_inf;
|
import com.fgkj.dto.ram.Fbs9100_state;
|
import org.apache.ibatis.annotations.Delete;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
public interface Fbs9100_stateMapper{
|
|
public int add(Fbs9100_state state);
|
|
public int update(Fbs9100_state state);
|
|
//fbs9600设备内阻测试
|
public int updatePro(List<Fbs9100_state> list);
|
|
@Delete("delete from db_ram_db.tb_Fbs9100_state where num=#{num}")
|
public int del(Fbs9100_state state);
|
|
@Select("select * from db_ram_db.tb_Fbs9100_state")
|
public List<Fbs9100_state> searchAll();
|
|
//11.1FBS9100设备通信状态查询
|
/*
|
* fbs9100：op_cmd:0:全部；1：fbs9100,2:fbs9600
|
* dev_errcommcount;0:通讯正常，1：通讯中断，100：全部
|
* */
|
public List<Fbs9100_state> serchByCondition(Fbs9100_state state);
|
|
//判断机房实时数据中该机房有没有连接到服务器
|
public int judgeSatationInState(int dev_id);
|
|
//实时监测界面根据dev_alarmstate状态判断接触器状态
|
@Select("select dev_id,dev_alarmstate,dev_workstate,record_datetime,dev_temp,dev_res_test_state," +
|
"dev_testtype,dev_testgroupnum,dev_conresist,dev_concurr,dev_condvoldp,dev_condcurr,dev_61850alarms," +
|
"dev_last_captest_stop_type from db_ram_db.tb_fbs9100_state where dev_id=#{dev_id} limit 1")
|
public Fbs9100_state serchContactorState(Fbs9100_state state);
|
|
//放电测试界面根据设备id查询网络拓扑图
|
public List<Fbs9100_state> serchByInfo(BattInf binf);
|
|
//实时界面左侧导航实时查询61850设备是否存在4种告警和设备的工作状态
|
@Select("select dev_id,dev_61850alarms,dev_workstate from db_ram_db.tb_fbs9100_state where dev_id like '%61850%' ")
|
public List<Fbs9100_state> serchBy61850Alarms();
|
|
//FBS9600设备内阻测试显示全部9600设备的信息
|
@Select("select distinct tb_Fbs9100_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_Fbs9100_state " +
|
" left outer join db_battinf.tb_battinf ON tb_Fbs9100_state.dev_id=db_battinf.tb_battinf.FBSDeviceId " +
|
" where tb_Fbs9100_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_Fbs9100_state.dev_id like '%96%'")
|
public List<Fbs9100_state> searchByUid(User_inf uinf);
|
|
//查询61850设备的6种工作状态
|
public List<Fbs9100_state> searchDevWorkstate(Fbs9100_state state);
|
|
//实时查询61850设备的设备状态
|
@Select("select dev_id,dev_workstate,dev_61850alarms " +
|
" from db_ram_db.tb_fbs9100_state " +
|
" where dev_id like '%6185%' " +
|
" and dev_id=#{fbsDeviceId} limit 1")
|
public List<Fbs9100_state> seachDevNow(BattInf obj);
|
|
//导航上实时查询61850设备的处于核容测试的数据
|
public List<Fbs9100_state> seach6185Nuclear_cap(User_inf uinf,int nuclearCapWorkState);
|
|
//11.1FBS9100设备通信状态查询<-------跨域----------->
|
public List serchByCondition_ky();
|
|
/*public static void main(String[] args) {
|
Fbs9100_stateImpl fi=new Fbs9100_stateImpl();
|
*//*List<Fbs9100_state> list=fi.searchAll();
|
System.out.println(list.size());
|
for(Fbs9100_state f:list){
|
System.out.println(f);
|
}*//*
|
Fbs9100_state fs=new Fbs9100_state();
|
fs.setNum(1002);
|
fs.setDev_id(0);
|
fs.setDev_workstate(100);
|
fs.setDev_errcommcount(2);
|
Page p=new Page();
|
p.setPageSize(20);
|
p.setPageCurr(1);
|
fs.setPage(p);
|
*//*List<Fbs9100_state> list=fi.serchByCondition(fs);
|
System.out.println(list.size());
|
for(Fbs9100_state f:list){
|
System.out.println(f);
|
}*//*
|
*//*BattInf binf=new BattInf();
|
binf.setBattGroupId(1005069);
|
List list=fi.serchByInfo(binf);
|
System.out.println(list);*//*
|
User_inf uinf=new User_inf();
|
uinf.setuId(1002);
|
//List<Fbs9100_state> list=fi.searchByUid(uinf);
|
List<Fbs9100_state> list=fi.searchDevWorkstate(fs);
|
// List<Fbs9100_state> list=fi.seach6185Nuclear_cap(uinf);
|
System.out.println(list.size());
|
for(Fbs9100_state f:list){
|
System.out.println(f);
|
}
|
}*/
|
|
}
|
