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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
package com.fgkj.mapper.impl.ram;
 
import com.fgkj.dto.BattInf;
import com.fgkj.dto.ram.FBS9100;
import com.fgkj.dto.ram.Fbs9100_setparam;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
 
import java.util.List;
 
public interface Fbs9100_setparamMapper{
   
    //将需要放电的数据添加放电参数表中
    public boolean add(Object obj);
    
    //修改放电参数表中
    @Update("update db_ram_db.tb_Fbs9100_setparam set testCmd=#{testCmd},HourRate=#{hourRate},DisCurr=#{disCurr}," +
            "DisCap=#{disCap},DisTime=#{disTime},groupVol_Low=#{groupVol_Low},monomerVol_Low=#{monomerVol_Low},monomerLowCount=#{monomerLowCount},battGroupNum=#{battGroupNum}," +
            "onlineVolLowAction=#{onlineLowAction},dCVolHighLimit=#{dCVolHighLimit},chargeCurrSet=#{chargeCurrSet},MonomerTmp_High=#{monomerTmp_High} where dev_id=#{dev_id}"
    )
    public int update(Fbs9100_setparam fsparam);
 
    //离线养护功能
    @Update("replace into db_ram_db.tb_fbs9100_setparam" +
            "(dev_id,MonomerTmp_High,OnLineVol_Low,OffLineYH_Cycle,OffLineYHstarttime,OffLineYHTimes,OffLineYHOnceCycle) " +
            "values(#{dev_id},#{monomerTmp_High},#{onLineVol_Low},#{offLineYH_Cycle},#{offLineYHstarttime},#{offLineYHTimes},#{offLineYHOnceCycle})")
    public int updateMaintain(Fbs9100_setparam fsparam);
 
    //修改放电参数表中ld6
    @Update("update db_ram_db.tb_Fbs9100_setparam set testCmd=#{testCmd},GroupVol_LOW=#{groupVol_LOW}," +
            "MonomerVol_LOW=#{monomerVol_LOW},MonomerLowCount=#{monomerLowCount},"+
            "MonomerTmp_High=#{monomerTmp_High},DisTime=#{disTime},DisCap=#{disCap},AutoTestStartVol=#{autoTestStartVol}" +
            " where dev_id=#{dev_id}"
    )
    public int updateld6Param(Fbs9100_setparam fsparam);
    
    //修改61850的放电参数
    @Update("update db_ram_db.tb_Fbs9100_setparam set testCmd=#{testCmd}," +
            "DisCurr=#{disCurr},DisCap=#{disCap},DisTime=#{disTime},MonomerTmp_High=#{monomerTmp_High},"+
            "groupVol_Low=#{groupVol_Low},monomerVol_Low=#{monomerVol_Low},"+
            "DCVolHighLimit=#{dCVolHighLimit},ChargeCurrSet=#{chargeCurrSet} " +
            "where dev_id=#{dev_id}")
    public int update61850Param(Fbs9100_setparam fsparam);
 
   
    public boolean del(Object obj);
   
    public List searchAll();
 
    //判断该机房是不是以前有过记录
    public int judgeSatationInParam(int dev_id);
    
    //根据机房编号和维护区查询放电机房的信息和放电参数
    public List serchByCondition(BattInf obj);
 
   //根据设备id查询设备的放电参数
    @Select("select db_ram_db.tb_fbs9100_setparam.dev_id,db_ram_db.tb_fbs9100_setparam.HourRate,db_ram_db.tb_fbs9100_setparam.DisCurr,db_ram_db.tb_fbs9100_setparam.DisCap " +
            ",db_ram_db.tb_fbs9100_setparam.DisTime,db_ram_db.tb_fbs9100_setparam.GroupVol_LOW,db_ram_db.tb_fbs9100_setparam.MonomerVol_LOW" +
            ",db_ram_db.tb_fbs9100_setparam.MonomerLowCount,db_ram_db.tb_fbs9100_setparam.OnlineVolLowAction " +
            ",db_ram_db.tb_fbs9100_setparam.dCVolHighLimit,db_ram_db.tb_fbs9100_setparam.chargeCurrSet "+
            ",db_ram_db.tb_fbs9100_setparam.battgroupnum,db_ram_db.tb_fbs9100_setparam.testcmd,db_ram_db.tb_fbs9100_setparam.MonomerTmp_High,db_ram_db.tb_fbs9100_setparam.AutoTestStartVol  " +
            " FROM db_ram_db.tb_fbs9100_setparam " +
            " where  db_ram_db.tb_fbs9100_setparam.dev_id=#{fbsDeviceId} ")
    public List<Fbs9100_setparam> serchdevParam(BattInf binf);
 
    //机房命令操作设备时的cmd和ack校验  test_type  -->默认启动测试的类型
    public boolean sendCmdToFBS9100Dev(int cmd,int test_type,int dev_id);
 
    //根据dev_id查询弹出框中的数据
    public FBS9100 serchbyDev_id(Fbs9100_setparam fsparam);
 
    //实时刷新放电表格的电池组状态(集合)
    FBS9100 getFbs9100ByInfo(BattInf battInf);
    FBS9100 get61850ByInfo(BattInf battInf);
    FBS9100 getLD9ByInfo(BattInf battInf);
    FBS9100 getFbs9600ByInfo(BattInf battInf);
 
    Integer updateOpCmdByDevId(int m_cmd, int dev_id,String sql_end);
 
    @Select("SELECT op_cmd FROM db_ram_db.tb_fbs9100_setparam "+
            " WHERE dev_id=#{dev_id}")
    Integer getOpCmdByDevId(int dev_id);
 
 
 
    /*public static void main(String[] args) {
        Fbs9100_setparamImpl fi=new Fbs9100_setparamImpl();
      
        BattInf binf=new BattInf();
        binf.setStationName("");
        binf.setStationName1("");
        binf.setBattGroupId(1000011);
        List<FBS9100> list=fi.serchByCondition(binf);
        System.out.println(list.size());
        for(FBS9100 f:list){
            System.out.println(f);
        }
    }*/
}