package rtkanchor;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import DataBase.DatabaseManagement;
import Method.GetNowTime;
import home.Open_soft_dialog;
public class Dell_jizhan {
	static Vector<Jizhan> jizhan_vector=new Vector<Jizhan>();//²î·Ö»ùÕ¾¶ÔÏóµÄ¼¯ºÏ
	

	/**³õʼ»¯tb_rtkanchorÊý¾Ý±í*/
	@SuppressWarnings("rawtypes")
	public static void chushihua_tb_rtkac() {
		Open_soft_dialog.addara("¼ÓÔØtb_rtkanchor");
		Iterator iterator = DatabaseManagement.table_base("tb_rtkanchor","DESC", "id").iterator();
		while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
			List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ			
			Jizhan jz=new Jizhan();
			String acid=(String)info.get(1);
			String state=(String)info.get(2);
			String jingdu=(String)info.get(3);
			String weidu=(String)info.get(4);
			String gaodu=(String)info.get(5);   
			String posx=(String)info.get(6);    
			String posy=(String)info.get(7);
			String floor=(String)info.get(8);
			String distance=(String)info.get(9);
			String port=(String)info.get(10);
			String ip=(String)info.get(11);//4G¿¨µØÖ·
			String gport=(String)info.get(12);//4G¿¨¶Ë¿Ú
			String time=(String)info.get(22);
			jz.setAcid(acid);
			jz.setState(state);
			jz.setJingdu(jingdu);
			jz.setWeidu(weidu);
			jz.setGaodu(gaodu);
			jz.setPosx(posx);
			jz.setPosy(posy);
			jz.setFloor(floor);
			jz.setDistance(distance);
			jz.setPort(port);
			jz.setBaoliu1(ip);
			jz.setBaoliu2(gport);
			jz.setAddtime(time);
			jizhan_vector.add(jz);
		}
	}

	/**Ð޸ĻùÕ¾µØÖ·¶Ë¿Ú*/
	public static void alertiport(String port,String ip,String port1) {
		Jizhan jz=get_2port_jizhan(port);
		if(jz !=null) {
			jz.setBaoliu1(ip);
			jz.setBaoliu2(port1);
			jz.setState("ÔÚÏß");
			jz.setAddtime(GetNowTime.now());
		}
	}
	
	/**ͨ¹ý±êÇ©idÕÒµ½Ä³¸ö»ùÕ¾¶ÔÏó*/
	public static Jizhan get_jizhan(String acid) {
		Jizhan jz=null;
		if(jizhan_vector.size() !=0) {
			Iterator<Jizhan> it=jizhan_vector.iterator();
			while(it.hasNext()) {
				Jizhan jz1=it.next();
				String idtag=jz1.getAcid();
				if(acid.equals(idtag)) {
					jz=jz1;
					break;
				}
			}
		}
		return jz;
	}
	
	/**ͨ¹ý»ùÕ¾½ÓÊն˿ÚÕÒµ½Ä³¸ö»ùÕ¾¶ÔÏó*/
	public static Jizhan get_2port_jizhan(String port) {
		Jizhan jz=null;
		if(jizhan_vector.size() !=0) {
			Iterator<Jizhan> it=jizhan_vector.iterator();
			while(it.hasNext()) {
				Jizhan jz1=it.next();
				String idtag=jz1.getPort();
				if(port.equals(idtag)) {
					jz=jz1;
					break;
				}
			}
		}
		return jz;
	}
	
	/**ͨ¹ý»ùÕ¾IPÕÒµ½Ä³¸ö»ùÕ¾¶ÔÏó*/
	public static Jizhan get_2ip_jizhan(String ip) {
		Jizhan jz=null;
		if(jizhan_vector.size() !=0) {
			Iterator<Jizhan> it=jizhan_vector.iterator();
			while(it.hasNext()) {
				Jizhan jz1=it.next();
				String idtag=jz1.getBaoliu1();
				if(ip.equals(idtag)) {
					jz=jz1;
					break;
				}
			}
		}
		return jz;
	}

	/**ÐÂÔöÒ»¸ö»ùÕ¾¶ÔÏó*/
	public static void add_ajizhan(
			String acid,
			String state,
			String jingdu,
			String weidu,
			String gaodu,   
			String posx,   
			String posy,
			String floor,
			String distance,
			String port) {
		Jizhan jz=new Jizhan();
		jz.setAcid(acid);
		jz.setState(state);
		jz.setJingdu(jingdu);
		jz.setWeidu(weidu);
		jz.setGaodu(gaodu);
		jz.setPosx(posx);
		jz.setPosy(posy);
		jz.setFloor(floor);
		jz.setDistance(distance);
		jz.setPort(port);
		jizhan_vector.add(jz);
	}
	
	
	/**ÐÞ¸ÄÒ»¸ö»ùÕ¾¶ÔÏó*/
	public static void alter_ajizhan(
			String acid,
			String jingdu,
			String weidu,
			String gaodu,   
			String posx,   
			String posy,
			String floor,
			String distance,
			String port) {
		if(get_jizhan(acid) !=null) {
			Jizhan jz=get_jizhan(acid);
			jz.setAcid(acid);
			jz.setJingdu(jingdu);
			jz.setWeidu(weidu);
			jz.setGaodu(gaodu);
			jz.setPosx(posx);
			jz.setPosy(posy);
			jz.setFloor(floor);
			jz.setDistance(distance);
			jz.setPort(port);
		}
		
	}
	/**ɾ³ýij¸ö¶ÔÏó*/
	public static void delete(String acid) {
		Jizhan jz=get_jizhan(acid);
		if(jz !=null) {
			jizhan_vector.removeElement(jz);
			String deleteSql="DELETE FROM tb_rtkanchor WHERE acid='"+acid+"'";			
			DatabaseManagement.update(deleteSql);
		}
	}

	/**»ñÈ¡²î·Ö»ù×¼Õ¾¶ÔÏóµÄ¼¯ºÏ*/
	public static Vector<Jizhan> getJizhan_vector() {
		return jizhan_vector;
	}

	public static void setJizhan_vector(Vector<Jizhan> jizhan_vector) {
		Dell_jizhan.jizhan_vector = jizhan_vector;
	}

}