update

whycrzg

2021-02-23 351b9a53cb9ecebdf8f79db0117f540d9c42c2a4

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
package com.fgkj.mapper.impl.ram;
 
import com.fgkj.dto.ram.Fbs9100_sysparam;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
 
import java.util.List;
 
public interface Fbs9100_sysparamMapper{
 
    //修改系统参数
    @Update("update db_ram_db.tb_fbs9100_sysparam set IPADDR=#{ipadDR},SubIPADDR=#{subIPADDR},NetGateADDR=#{netGateADDR}," +
            "GroupVolRange=#{groupVolRange},GroupVolSorce=#{groupVolSorce},CurrentRange=#{currentRange},CurrentTyte=#{currentTyte},MonomerOrder=#{monomerOrder},BackLightTime=#{backLightTime}" +
            ",MACADDR=#{macadDR},LoaderCount=#{loaderCount},DtCardCount=#{dtCardCount},PowerBreakChargeCurr=#{powerBreakChargeCurr},MajorBattGroupNum=#{majorBattGroupNum}," +
            "POF_BG_Boost_Cnt=#{pof_BG_Boost_Cnt},POF_BG_Boost_VolStop=#{pof_BG_Boost_VolStop},POF_BG_Boost_VolStart=#{pof_BG_Boost_VolStart} " +
            "where dev_id=#{dev_id} ")
    public int update(Fbs9100_sysparam sysParam);
 
    //修改61850设备系统参数
    @Update(" update db_ram_db.tb_fbs9100_sysparam set GroupVolSorce=#{groupVolSorce},CurrentTyte=#{currentTyte},MonomerOrder=#{monomerOrder} " +
            ",PowerBreakChargeCurr=#{powerBreakChargeCurr},POF_BG_Boost_VolStop=#{pof_BG_Boost_VolStop},POF_BG_Boost_VolStart=#{pof_BG_Boost_VolStart} " +
            "where dev_id=#{dev_id}")
    public int update61850(Object obj);
 
    //批量设置系统参数
    public int updatePro(List<Fbs9100_sysparam> list);
 
    //查询系统参数前(如果没有默认数据要用REPLACE 添加一笔数据)
    @Update("REPLACE  into db_ram_db.tb_fbs9100_sysparam(dev_id) values(#{dev_id})")
    public int replace (Fbs9100_sysparam sys);
 
    //查询系统参数前(如果没有默认数据要用REPLACE 添加一笔数据)同时发送命令
    public boolean replacePL(Object obj);
 
    //批量读取电池参数
    public int readPL(List<Fbs9100_sysparam> list);
 
    //根据设备id查询系统参数(一定是被管理的)
    @Select(" select distinct dev_ip,dev_id,op_cmd,IPADDR,SubIPADDR,NetGateADDR,GroupVolRange,GroupVolSorce,CurrentRange,CurrentTyte,MonomerOrder,BackLightTime" +
            " ,MACADDR,LoaderCount,DtCardCount,PowerBreakChargeCurr,MajorBattGroupNum,POF_BG_Boost_Cnt,POF_BG_Boost_VolStop,POF_BG_Boost_VolStart" +
            " ,db_battinf.tb_battinf.FBSDeviceName,db_battinf.tb_battinf.StationName " +
            " from db_ram_db.tb_fbs9100_sysparam,db_battinf.tb_battinf " +
            " where db_ram_db.tb_fbs9100_sysparam.dev_id=db_battinf.tb_battinf.FBSDeviceId " +
            " and db_ram_db.tb_fbs9100_sysparam.dev_id=#{dev_id}")
    public List<Fbs9100_sysparam> serchByCondition(Fbs9100_sysparam sys);
 
    //系统参数命令操作设备时的cmd和ack校验
    // public boolean sendCmdToFBS9100Dev(int cmd,int dev_id);
 
    //批量设置系统参数成功后读取命令的ACK
    @Select("SELECT op_cmd FROM db_ram_db.tb_fbs9100_sysparam "+
            " WHERE dev_id=#{dev_id}")
    public int getCmdAck(int dev_id);
    
    /*public static void main(String[] args) {
        Fbs9100_sysparamImpl fimpl=new Fbs9100_sysparamImpl();
        Fbs9100_sysparam sys=new Fbs9100_sysparam();
        sys.setDev_id(910000011);
        List list=fimpl.serchByCondition(sys);
        System.out.println(list.size());
    }*/
 
}