package com.fgkj.mapper.impl;
|
|
import java.util.List;
|
|
import com.fgkj.dto.Batt_Maint_Dealarm;
|
import com.fgkj.dto.Battalarm_data_history;
|
import org.apache.ibatis.annotations.Delete;
|
import org.springframework.stereotype.Repository;
|
|
public interface Battalarm_data_historyMapper{
|
|
|
//3.2电池告警查询(删除记录)<多条记录删除>
|
@Delete("delete from db_alarm.tb_battalarm_data_history where num=#{num}")
|
public int delPro(Battalarm_data_history obj);
|
|
// 3.2电池告警
|
/*
|
* 条件所存放的位置前台：tb_batt_maint_inf
|
* 在线电压：usr_id 119001
|
* 组端电压：fault_type_id 119002
|
* 充电电流：fault_level 119003
|
* 放电电流：record_uid 119004
|
* 单体电压：maint_type_id 119005
|
* 单体温度：maint_done 119006
|
* 单体内阻：maint_close 119007
|
* 连接条阻抗：master_id 119008
|
* -----alarm_data
|
* MonNum 容量告警告警
|
*Record_Id 容量更换告警
|
* 告警等级
|
* 一级告警：num
|
* 二级告警：battgroupid
|
* 三级告警：master_audit
|
* 四级告警：appoint-uid
|
*
|
*
|
* 下限告警/上限告警 alarm_data
|
* alm_signal_id：为奇数--上限告警（alm_id） 选中1 未选中100
|
* alm_signal_id：为偶数--下限告警 (alm_signal_id) 选中0 未选中100
|
*
|
* 告警状态alm_cleared_type;
|
* 当前告警:选中0
|
* 历史告警:选中1
|
* 两者告警:选中100
|
* 全都不选:不选200
|
|
*/
|
public List serchByInfo(Batt_Maint_Dealarm obj);
|
|
/*public static void main(String[] args) throws ParseException {
|
Battalarm_data_historyImpl bimpl=new Battalarm_data_historyImpl();
|
Page p = new Page();
|
p.setPageCurr(1);
|
p.setPageSize(10);
|
*//*条件所存放的位置前台：tb_batt_maint_inf
|
* 在线电压：usr_id
|
* 组端电压：fault_type_id
|
* 充电电流：fault_level
|
* 放电电流：record_uid
|
* 单体电压：maint_type_id
|
* 单体温度：maint_done
|
* 单体内阻：maint_close
|
* 连接条阻抗：master_id
|
* *//*
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
|
Date date1 = sdf.parse("2000-01-01");
|
Date date2 = sdf.parse("2020-01-01");
|
Batt_maint_inf mainf=new Batt_maint_inf();
|
mainf.setUsr_id(119001);
|
mainf.setFault_type_id(119002);
|
mainf.setFault_level(119003);
|
mainf.setRecord_uid(119004);
|
mainf.setMaint_type_id(119005);
|
mainf.setMaint_done(119006);
|
mainf.setMaint_close(119007);
|
mainf.setMaster_id(119008);
|
|
|
mainf.setNum(1);
|
mainf.setBattGroupId(2);
|
mainf.setMaster_audit(3);
|
mainf.setAppoint_uid(4);
|
|
Battalarm_data_history adata = new Battalarm_data_history();
|
adata.setAlm_id(0); //下限告警未选中
|
adata.setAlm_signal_id(1); //上限告警选中
|
adata.setAlm_cleared_type(100);
|
adata.setAlm_start_time(ActionUtil.getSimpDate(date1));
|
adata.setAlm_start_time1(ActionUtil.getSimpDate(date2));
|
|
BattInf binf = new BattInf();
|
|
binf.setStationName("");
|
binf.setStationName1("");
|
binf.setBattGroupId(0);
|
|
|
User_inf uinf=new User_inf();
|
uinf.setuId(1002);
|
Batt_Maint_Dealarm bmd = new Batt_Maint_Dealarm();
|
bmd.setPage(p);
|
bmd.setAdata_H(adata);
|
bmd.setMainf(mainf);
|
bmd.setBinf(binf);
|
bmd.setUinf(uinf);
|
List<Batt_Maint_Dealarm> list=bimpl.serchByInfo(bmd);
|
for (Batt_Maint_Dealarm b : list) {
|
System.out.println(b.getPage());
|
}
|
}*/
|
}
|
