package tbDataModel_Dell;
|
import java.awt.Image;
|
import java.util.Iterator;
|
import java.util.List;
|
import java.util.Vector;
|
import javax.swing.ImageIcon;
|
import DataBase.DatabaseManagement;
|
import Method.GetNowTime;
|
import PbuliClass.Shi_jian_cha_sss;
|
import PbuliClass.ShowMessage;
|
import PbuliClass.Systems;
|
import home.Open_soft_dialog;
|
import tag.Tag_Dell;
|
import tbDataModel.Tb_gas_anchor;
|
|
/**´¦ÀíÆøѹ»ùÕ¾Êý¾Ý
|
* @author yang20230730*/
|
@SuppressWarnings("rawtypes")
|
public class Dell_tb_gas_anchor {
|
static Vector<Tb_gas_anchor> gas_anchorvc = new Vector<>();
|
static String on="image/anchor/gasanchoronlie.png";
|
static String off="image/anchor/gasanchoroff.png";
|
static Image zaixian= new ImageIcon(on).getImage();// »ùվͼƬ
|
static Image lixian= new ImageIcon(off).getImage();// »ùվͼƬ
|
static Vector<Tb_gas_anchor> gasanchor_vector=new Vector<Tb_gas_anchor>();//´øÆøѹ»ùÕ¾µÄ¼¯ºÏ
|
static {
|
Open_soft_dialog.addara("¼ÓÔØtb_suanfa2");
|
List list=DatabaseManagement.get_alldate_indatabase("tb_gas_anchor");
|
Iterator iterator =list.iterator() ;
|
while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
|
List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
|
Tb_gas_anchor tbgasanchor=new Tb_gas_anchor();
|
String id=(String) info.get(0); //ÐòºÅ
|
String anchorid=(String) info.get(1); //Æøѹ»ùÕ¾ID
|
String anchorid2=(String) info.get(2); //±¸ÓÃÆøѹ»ùÕ¾ID
|
String anchorx=(String) info.get(3); //Æøѹ»ùÕ¾X×ø±ê
|
String anchory=(String) info.get(4); //Æøѹ»ùÕ¾Y×ø±ê
|
String anchorz=(String) info.get(5); //Æøѹ»ùÕ¾Z×ø±ê
|
// String onlie=(String) info.get(6); //Æøѹ»ùվ״̬ÔÚÏß1ÀëÏß0
|
// String gasvalue=(String) info.get(7); //Æøѹ»ùÕ¾Æøѹֵ
|
String refresh_time=(String) info.get(8); //Æøѹ»ùÕ¾¸üÐÂÊý¾Ýʱ¼ä
|
tbgasanchor.setId(id);
|
tbgasanchor.setAnchorid(anchorid);
|
tbgasanchor.setAnchorid2(anchorid2);
|
if(anchorx.length()<1) {
|
anchorx="0";
|
}
|
if(anchory.length()<1) {
|
anchory="0";
|
}
|
tbgasanchor.setAnchorx(anchorx);
|
tbgasanchor.setAnchory(anchory);
|
tbgasanchor.setAnchorz(anchorz);
|
tbgasanchor.setOnlie("-1");
|
tbgasanchor.setGasvalue("-1");
|
tbgasanchor.setRefresh_time(refresh_time);
|
tbgasanchor.setAnchorqiyagaodu(-1);
|
tbgasanchor.setAnc_image(lixian);
|
gas_anchorvc.add(tbgasanchor);
|
}
|
}
|
|
/**ͨ¹ýÉ豸±àºÅÕÒµ½É豸*/
|
public static Tb_gas_anchor get_Tb_gas_anchor(String anchorid) {
|
Tb_gas_anchor tbgasanchor=null;
|
int size=gas_anchorvc.size();
|
if(size>0) {
|
for(int i=0;i<size;i++) {
|
Tb_gas_anchor tbgasanchor1=gas_anchorvc.get(i);
|
String ancid=tbgasanchor1.getAnchorid();
|
if(anchorid.equals(ancid)) {
|
tbgasanchor=tbgasanchor1;
|
break;
|
}
|
}
|
}
|
return tbgasanchor;
|
}
|
|
/**ÐÂÔö»òÕßÐ޸ĶÔÏó*/
|
public static void add_alert(
|
String anchorid,//Æøѹ»ùÕ¾ID
|
String anchorid2, //±¸ÓÃÆøѹ»ùÕ¾ID
|
String anchorx,//Æøѹ»ùÕ¾X×ø±ê
|
String anchory, //Æøѹ»ùÕ¾Y×ø±ê
|
String anchorz, //Æøѹ»ùÕ¾Z×ø±ê
|
String onlie,//Æøѹ»ùվ״̬ÔÚÏß1ÀëÏß0
|
String gasvalue //Æøѹ»ùÕ¾Æøѹֵ
|
) {
|
Tb_gas_anchor tbgasanchor=get_Tb_gas_anchor(anchorid);
|
String refresh_time=GetNowTime.now();
|
int type=0;
|
if(tbgasanchor==null) {
|
tbgasanchor=new Tb_gas_anchor();
|
tbgasanchor.setAnchorid(anchorid);
|
tbgasanchor.setAnchorid2(anchorid2);
|
tbgasanchor.setAnchorx(anchorx);
|
tbgasanchor.setAnchory(anchory);
|
tbgasanchor.setAnchorz(anchorz);
|
tbgasanchor.setOnlie(onlie);
|
tbgasanchor.setGasvalue(gasvalue);
|
tbgasanchor.setRefresh_time(refresh_time);
|
gas_anchorvc.add(tbgasanchor);
|
|
}else {
|
tbgasanchor.setAnchorid(anchorid);
|
tbgasanchor.setAnchorid2(anchorid2);
|
tbgasanchor.setAnchorx(anchorx);
|
tbgasanchor.setAnchory(anchory);
|
tbgasanchor.setAnchorz(anchorz);
|
tbgasanchor.setOnlie(onlie);
|
tbgasanchor.setGasvalue(gasvalue);
|
tbgasanchor.setRefresh_time(refresh_time);
|
type=1;
|
}
|
insert_database(
|
type,//0ÊDzåÈ룬1ÊÇÐÞ¸Ä
|
anchorid,//Æøѹ»ùÕ¾ID
|
anchorid2, //±¸ÓÃÆøѹ»ùÕ¾ID
|
anchorx,//Æøѹ»ùÕ¾X×ø±ê
|
anchory, //Æøѹ»ùÕ¾Y×ø±ê
|
anchorz, //Æøѹ»ùÕ¾Z×ø±ê
|
onlie,//Æøѹ»ùվ״̬ÔÚÏß1ÀëÏß0
|
gasvalue, //Æøѹ»ùÕ¾Æøѹֵ
|
refresh_time
|
);
|
}
|
|
|
/**Êý¾Ý²åÈë²ã×éÊý¾Ý¿â*/
|
public static void insert_database(
|
int type,//0ÊDzåÈ룬1ÊÇÐÞ¸Ä
|
String anchorid,//Æøѹ»ùÕ¾ID
|
String anchorid2, //±¸ÓÃÆøѹ»ùÕ¾ID
|
String anchorx,//Æøѹ»ùÕ¾X×ø±ê
|
String anchory, //Æøѹ»ùÕ¾Y×ø±ê
|
String anchorz, //Æøѹ»ùÕ¾Z×ø±ê
|
String onlie,//Æøѹ»ùվ״̬ÔÚÏß1ÀëÏß0
|
String gasvalue, //Æøѹ»ùÕ¾Æøѹֵ
|
String refresh_time
|
) {
|
|
String[] ziduan= {
|
"anchorid2",
|
"anchorx",
|
"anchory",
|
"anchorz",
|
"onlie",
|
"gasvalue",
|
"refresh_time",
|
"anchorid"
|
};
|
|
String[] zhi= {
|
anchorid2,
|
anchorx,
|
anchory,
|
anchorz,
|
onlie,
|
gasvalue,
|
refresh_time,
|
anchorid
|
};
|
if(type==0) {
|
DatabaseManagement.insertfast("tb_gas_anchor", ziduan, zhi);
|
Tag_Dell.add_tag(anchorid, "Æøѹ»ùÕ¾",anchorz,"1000","1",0,"ϵͳĬÈÏ",0);
|
ShowMessage.zidingyi(anchorid+"±£´æ³É¹¦...");
|
}else {
|
DatabaseManagement.fast_alert_dbase("tb_gas_anchor", ziduan, zhi);
|
ShowMessage.zidingyi(anchorid+"Ð޸ijɹ¦...");
|
}
|
|
}
|
|
/**ÐÞ¸Äij¸ö×ֶεÄÖµ*/
|
public static void alert_one_dabase(String valuename,String vlue,String anchorid) {
|
String[] ziduan= {valuename,anchorid};
|
String[] zhi= {vlue,anchorid};
|
DatabaseManagement.fast_alert_dbase("tb_gas_anchor", ziduan, zhi);
|
}
|
|
|
/**ÅжÏÆøѹ»ùÕ¾ÊÇ·ñÀëÏß*/
|
public static void gasanchor_off() {
|
int size=gas_anchorvc.size();
|
if(size !=0) {
|
for(int i=0;i<size;i++) {
|
Tb_gas_anchor ac=gas_anchorvc.get(i);
|
String state=ac.getOnlie();
|
if(state.equals("1")) {//Èç¹û»ùվ֮ǰ´¦ÓÚÔÚÏß״̬ÔÙÅжÏÊÇ·ñÀëÏß
|
String tm=ac.getRefresh_time();
|
int a= Shi_jian_cha_sss.get_time_cha_s(GetNowTime.now(),tm);
|
int b=30;
|
if( a>b) {
|
ac.setOnlie("0");
|
String anchorid=ac.getAnchorid();
|
alert_one_dabase("onlie","0",anchorid);
|
ac.setAnc_image(lixian);
|
ac.setOnlie("0");
|
ac.setGasvalue("-1");
|
}
|
}
|
}
|
}
|
}
|
|
/**ÐÞ¸ÄÉ豸״̬*/
|
public static void alert_state(Tb_gas_anchor ac,String gasvalue) {
|
if(ac!=null) {
|
ac.setOnlie("1");
|
ac.setAnc_image(zaixian);
|
ac.setGasvalue(gasvalue);
|
ac.setRefresh_time(GetNowTime.now());
|
}
|
|
}
|
|
|
/**ËÑËØij¸öÆøѹ»ùÕ¾¶ÔÏó*/
|
public static Vector<Tb_gas_anchor> getserch_gasanchor(String anchorid){
|
Vector<Tb_gas_anchor> gasvc=new Vector<Tb_gas_anchor>();
|
Tb_gas_anchor tbgasanchor=get_Tb_gas_anchor(anchorid);
|
if(tbgasanchor!=null) {
|
String tagid=tbgasanchor.getAnchorid();
|
if(tagid.equals(anchorid)) {
|
gasvc.add(tbgasanchor);
|
}
|
}
|
return gasvc;
|
}
|
|
/**»ñÈ¡Æøѹ»ùÕ¾¼¯ºÏ*/
|
public static Vector<Tb_gas_anchor> getGas_anchorvc() {
|
return gas_anchorvc;
|
}
|
|
public static void setGas_anchorvc(Vector<Tb_gas_anchor> gas_anchorvc) {
|
Dell_tb_gas_anchor.gas_anchorvc = gas_anchorvc;
|
}
|
|
/**»ñÈ¡Èýά²Î¿¼»ùÕ¾IDµÄ¼¯ºÏ*/
|
public static String[] get_gasanchoridstrs() {
|
String[] anchoridstr=null;
|
if(Systems.isIssanwei()) {
|
int size=gasanchor_vector.size();
|
anchoridstr=new String[size+1];
|
anchoridstr[0]="Ñ¡Ôñ²Î¿¼»ùÕ¾";
|
if(size !=0) {
|
for(int i=0;i<size;i++) {
|
anchoridstr[i+1]=gasanchor_vector.get(i).getAnchorid();
|
}
|
}
|
}else {
|
anchoridstr=new String[1];
|
anchoridstr[0]="Ñ¡Ôñ²Î¿¼»ùÕ¾";
|
}
|
return anchoridstr;
|
}
|
|
public static Vector<Tb_gas_anchor> getGasanchor_vector() {
|
return gasanchor_vector;
|
}
|
|
public static void setGasanchor_vector(Vector<Tb_gas_anchor> gasanchor_vector) {
|
Dell_tb_gas_anchor.gasanchor_vector = gasanchor_vector;
|
}
|
}
|
