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;
	}
}