package tbDataModel_Dell;
|
import java.util.Iterator;
|
import java.util.List;
|
import java.util.Vector;
|
import DataBase.DatabaseManagement;
|
import Method.GetNowTime;
|
import home.Open_soft_dialog;
|
import tbDataModel.TbWaring;
|
|
/**¸ÃÀàÓÃÓÚ´¦ÀíËùÓеĸ澯ÐÅÏ¢*/
|
@SuppressWarnings("rawtypes")
|
public class Tb_Warnig_Dell {
|
static Vector<TbWaring> tbwarning_vector;
|
static {
|
tbwarning_vector=new Vector<>();
|
Open_soft_dialog.addara("¼ÓÔØtb_warning");
|
Iterator iterator = DatabaseManagement.table_AandD("tb_warning", "DESC").iterator();
|
while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
|
List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËØ¸øµ½info¼¯ºÏ
|
TbWaring warning=new TbWaring();
|
String status=(String)info.get(3);
|
if(status.equals("δ´¦Àí")) {
|
warning.setType((String)info.get(1));
|
warning.setObjectid((String)info.get(2));
|
warning.setStatus(status);
|
warning.setTime((String)info.get(4));
|
tbwarning_vector.add(warning);
|
}
|
|
}
|
}
|
|
/**ÐÂÔöÒ»ÌõSOS¸æ¾¯¼Ç¼
|
* @param ¸æ¾¯ÀàÐÍ
|
* @param É豸ÀàÐÍ
|
* @param ´¦Àí״̬£¬ÒÑ´¦Àí»òÕßδ´¦Àí
|
* @param Ìí¼Óʱ¼ä*/
|
public static void add_tb_warning(String type,String objectid,String status,String beizhu) {
|
TbWaring newwarning=new TbWaring();
|
String time=GetNowTime.now();
|
newwarning.setType(type);
|
newwarning.setObjectid(objectid);
|
newwarning.setStatus(status);
|
newwarning.setTime(time);
|
tbwarning_vector.add(newwarning);
|
}
|
|
/* *//**²åÈëµÍµçÁ¿Êý¾Ý*//*
|
public static void add_lowpoer(String taid,String power) {
|
if(get_tbwarning(taid )!=null) {
|
return;
|
}
|
InsertData.sosInsertTbWarning(taid,"µÍµçÁ¿","δ´¦Àí",power);
|
}*/
|
|
/**»ñȡijÖÖδ´¦ÀíÀàÐͱ¨ÎĵÄÌõÊý*/
|
public static int get_warning_num(String type) {
|
int num=tbwarning_vector.size() ;
|
if(num>2000) {
|
String deleteSql="TRUNCATE TABLE tb_warning ";
|
DatabaseManagement.update(deleteSql);
|
tbwarning_vector.removeAllElements();
|
}
|
int num1=0;
|
for(int i=0;i<num;i++) {
|
String type0=tbwarning_vector.get(i).getType();
|
String stat=tbwarning_vector.get(i).getStatus();
|
if(type0.equals(type) && stat.equals("δ´¦Àí")) {
|
num1=num1+1;
|
}
|
}
|
return num1;
|
}
|
|
/**½«SOS¸æ¾¯×´Ì¬ÉèÖÃΪÒÑ´¦Àí*/
|
public static void alert_sos_status(String tagid) {
|
if(tbwarning_vector.size() !=0) {
|
for(int i=0;i<tbwarning_vector.size();i++) {
|
TbWaring tbw1=tbwarning_vector.get(i);
|
String type1=tbw1.getType();
|
String status1=tbw1.getStatus();
|
String id=tbw1.getObjectid();
|
if(id.equals(tagid) && type1.equals("SOS") && status1.equals("δ´¦Àí")) {
|
tbw1.setStatus("ÒÑ´¦Àí");
|
tbwarning_vector.removeElement(tbw1);
|
}
|
}
|
}
|
}
|
|
/**ÕÒµ½Ä³ÌõµÍµçÁ¿¸æ¾¯ÐÅÏ¢*/
|
public static TbWaring get_tbwarning(String tagid ) {
|
TbWaring tbw=null;
|
if(tbwarning_vector.size() !=0) {
|
for(int i=0;i<tbwarning_vector.size();i++) {
|
TbWaring tbw1=tbwarning_vector.get(i);
|
String type1=tbw1.getType();
|
String status1=tbw1.getStatus();
|
String id=tbw1.getObjectid();
|
if(id.equals(tagid) && type1.equals("µÍµçÁ¿") && status1.equals("δ´¦Àí")) {
|
tbw=tbw1;
|
break;
|
}
|
}
|
}
|
return tbw;
|
}
|
|
/**½«ËùÓи澯ÐÅÏ¢ÉèÖÃΪÒÑ´¦Àí*/
|
public static void alert_all_status() {
|
if(tbwarning_vector.size() !=0) {
|
tbwarning_vector.removeAllElements();
|
}
|
}
|
|
/**ɾ³ýËùÓеĸ澯ÐÅÏ¢*/
|
public static void delete_all_tbwarning() {
|
if(tbwarning_vector.size() !=0) {
|
tbwarning_vector.removeAllElements();
|
}
|
}
|
|
/**ɾ³ýijÌõ¸æ¾¯ÐÅÏ¢*/
|
public static void delete_tbwarning(String id,String addtime) {
|
if(tbwarning_vector.size() !=0) {
|
for(int i=0;i<tbwarning_vector.size();i++) {
|
TbWaring tbw1=tbwarning_vector.get(i);
|
String tagid=tbw1.getObjectid();
|
String time=tbw1.getTime();
|
if(tagid.equals(id) && time.equals(addtime)) {
|
tbwarning_vector.remove(tbw1);
|
break;
|
}
|
}
|
}
|
}
|
|
/**ɾ³ýij±êÇ©µÄËùÓе͵çÁ¿¸æ¾¯ÐÅϢʵʱ¸æ¾¯¼¯ºÏÖеÄ**/
|
public static void delete_lowpoer_tbwarning(String id) {
|
if(tbwarning_vector.size() !=0) {
|
for(int i=0;i<tbwarning_vector.size();i++) {
|
TbWaring tbw1=tbwarning_vector.get(i);
|
String tagid=tbw1.getObjectid();
|
if(tagid.equals(id)) {
|
tbwarning_vector.remove(tbw1);
|
}
|
}
|
}
|
}
|
|
public static Vector<TbWaring> getTbwarning_vector() {
|
return tbwarning_vector;
|
}
|
|
public static void setTbwarning_vector(Vector<TbWaring> tbwarning_vector) {
|
Tb_Warnig_Dell.tbwarning_vector = tbwarning_vector;
|
}
|
|
/**ÊÇ·ñ´æÔÚijÌõÆøÌåŨ¶È¹ý¸ßµÄ¸æ¾¯Êý¾Ýδ´¦ÀíÈç¹û´æÔÚ*/
|
|
}
|