package anchor;
import java.awt.Image;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import javax.swing.ImageIcon;
import DataBase.DatabaseManagement;
import Frame.Gps_Manage;
import Method.GetNowTime;
import Method.JudgeTagOrAnchorOffline;
import PbuliClass.Shi_jian_cha_sss;
import PbuliClass.ShowMessage;
import PbuliClass.Systems;
import engbs.engine_do;
import home.Open_soft_dialog;
import tbDataModel.Tb_cengzu;
import tbDataModel_Dell.Dell_TongbuAnchor;
import tbDataModel_Dell.Dell_tbcengzu;

@SuppressWarnings("rawtypes")
public class Anchor_Dell {
	static Vector<Anchor> anchor_vector=new Vector<>();//»ùÕ¾µÄ¼¯ºÏ	
	static Vector<Anchor> kczcnchor_vector=new Vector<>();//¿ç²ã×é»ùÕ¾µÄ¼¯ºÏ
	static Vector<Anchor> bjjl_vector=new Vector<>();//±Ø¾­¾àÀë»ùÕ¾µÄ¼¯ºÏ
	private static Image zaixian;// »ùվͼƬ
	private static Image lixian;// »ùվͼƬ
	static String on="image/anchor/anchoron.png";
	static String off="image/anchor/anchoroff.png";
	static Image ceju;//ÕýÔÚ²ÎÓë²â¾àµÄ»ùÕ¾
	static Image linjin;
	static boolean biaoji=true;
	static double anchorh0=0;//±äµçվģʽÏ»ùÕ¾µÄ¸ß¶È¾àÀëµØÃæ³õʼ¸ß
	static double anchorhr=0;//±äµçվģʽÏ»ùÕ¾µÄʵʱº£°Î¸ß¶È
	static Image anchor_red=new ImageIcon("image/anchor/red.png").getImage();
	static Image anchor_yellow=new ImageIcon("image/anchor/ceju.png").getImage();
	static Image anchor_green=new ImageIcon("image/anchor/lingjin.png").getImage();
	static Image anchor_off=new ImageIcon("image/anchor/anchoroff.png").getImage();
	static Image anchor_on=new ImageIcon("image/anchor/anchoron.png").getImage();
	static ImageIcon anchor_red1=new ImageIcon("image/anchor/red.png");
	static ImageIcon anchor_yellow1=new ImageIcon("image/anchor/ceju.png");
	static ImageIcon anchor_green1=new ImageIcon("image/anchor/lingjin.png");
	static ImageIcon anchor_off1=new ImageIcon("image/anchor/anchoroff.png");
	static ImageIcon anchor_on1=new ImageIcon("image/anchor/anchoron.png");

	/**»ñÈ¡ÕýÔÚ²ÎÓë²â¾àµÄ»ùÕ¾*/
	public static Image getCeju() {
		ceju=new ImageIcon("image/anchor/ceju.png").getImage();
		return ceju;
	}

	/**»ñÈ¡ÁÙ½ü»ùÕ¾*/
	public static Image getlinjin() {
		ceju=new ImageIcon("image/anchor/lingjin.png").getImage();
		return ceju;
	}

	/**»ùÕ¾µÄ¼¯ºÏ*/
	//id,anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchormode,anchorip,GreateTime
	static {	
		zaixian= new ImageIcon(on).getImage();
		lixian=new ImageIcon(off).getImage();
		Open_soft_dialog.addara("¼ÓÔØtb_achor");		
		Iterator iterator =DatabaseManagement.table_base("tb_achor","ASC","anchorid").iterator();			
		while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
			List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
			Anchor anchor=new Anchor();			
			String anchorid=(String)info.get(1);
			String layer=(String)info.get(5);
			String zu=(String)info.get(6);
			anchor.setAnc_id(anchorid);
			anchor.setAnc_x((String)info.get(2));
			anchor.setAnc_y((String)info.get(3));
			String z0=(String)info.get(4);
			String liangcheng=(String)info.get(7);
			if(z0==null || z0.equals("")) {
				z0="0";
			}
			anchor.setAnc_z(z0);			
			anchorh0=Double.valueOf(z0);
			anchor.setAnc_floor(layer);
			anchor.setAnc_zu(zu);
			Dell_tbcengzu.add_cengzu_form_addanchor(layer, zu);//Ìí¼Ó²ã×é¶ÔÏó
			anchor.setAnc_distance(liangcheng);
			anchor.setAnc_status("-1");
			anchor.setAnc_ip((String)info.get(9));			
			anchor.setAnc_image(lixian);			
			anchor.setVersion((String)info.get(10));
			anchor.setGonglv((String)info.get(11));
			anchor.setJiaozhundistance((String)info.get(12));
			anchor.setAnc_cteatetime((String)info.get(13));			
			anchor.setGaodu(0);//ÉèÖñäµçվģʽÏÂÉ豸³õʼ¸ß¶È
			String ac15=(String)info.get(15);
			if(ac15==null) {
				ac15="0";
			}
			anchor.setBaoliu1(ac15);
			anchor.setPort(0);
			anchor.setNearok(0);
			anchor.setTongbuok(0);
			//¿ç²ã×é»ùվи߶È
			String a1=(String)info.get(16);
			if(a1 !=null) {
				if(a1.length()>2) {
					anchor.setBaoliu2(a1);
					//и߶ÈËùÔÚµÄ×é
					String a2=(String)info.get(17);
					anchor.setBaoliu3(a2);
					kczcnchor_vector.add(anchor);
				}else {
					anchor.setBaoliu2("");
					anchor.setBaoliu3("");
				}
			}else {
				anchor.setBaoliu2("");
				anchor.setBaoliu3("");
			}

			//±Ø¾­¾àÀë
			String bjjl=(String)info.get(18);
			if( bjjl==null) {
				bjjl="";
			}else {
				if(bjjl.length()>2) {
					bjjl_vector.add(anchor);
				}else {
					bjjl="";
				}
			}
			//»ùÕ¾ºÍ±êÇ©¾àÀëÅжÏÊÇ·ñÔÚÊÒÄÚ
			String juli=(String)info.get(19);
			if(juli==null) {
				juli="0";
				anchor.setBaoliu5(0);
			}else {
				if(juli.length()<2) {
				}else {
					int a3=Integer.parseInt(juli);
					anchor.setBaoliu5(a3);
				}
			}
			anchor.setBaoliu4(bjjl);
			anchor.setGetversionok(0);
			anchor.setAnchorheart(0);

			//ÎÞÏß»ùÕ¾µÄµçÁ¿
			if(Systems.isWuxian()) {//ϵͳ¿ªÆô»ùÕ¾ÎÞÏßģʽ
				String power=(String)info.get(22);
				if(power==null) {
					power="";
				}
				anchor.setBaoliu8(power);
			}
			if (Systems.isWuxian()){//ϵͳ¿ªÆô»ùÕ¾ÎÞÏßģʽ
				String distance=(String) info.get(23);
				if (distance==null){
					distance= String.valueOf(0);
				}

				anchor.setBaoliu9(distance);
			}
			if (info.size()<26){
				ShowMessage.zidingyi_24("ÕýÔÚ¸øtb_anchor±íÌí¼Ó×Ö¶Îbaoliu11,ÇëÖØÆô");
				String sql2="ALTER TABLE `hxzkuwb`.`tb_achor` ADD baoliu11 VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT -1 COMMENT 'ÎÞÏß»ùվͨѶ×éID'  AFTER baoliu10;";
				//String sql3="ALTER TABLE `hxzkuwb`.`tb_achor` ADD baoliu12 VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT -1 COMMENT 'ÎÞÏß»ùվͨѶ×éID'  AFTER baoliu11;";
				DatabaseManagement.update(sql2);
				//DatabaseManagement.update(sql3);
				System.exit(-1);
			}
			if (Systems.isWuxian()){//ϵͳ¿ªÆô»ùÕ¾ÎÞÏßģʽ
				String gonglv=(String) info.get(24);
				if (gonglv==null){
					gonglv= String.valueOf(0);
				}

				anchor.setBaoliu10(gonglv);
			}
			if (Systems.isWuxian()){//ϵͳ¿ªÆô»ùÕ¾ÎÞÏßģʽ
				String groupId=(String) info.get(25);
				if (groupId==null){
					groupId= String.valueOf(-1);
				}

				anchor.setBaoliu11(groupId);
			}
			anchor.setAnchor_distance_state(-1);//³õʼ»¯»ùÕ¾»ùÕ¾²â¾à״̬
			anchor.setAnchor_power_state(-1);//³õʼ»¯»ùÕ¾µçÁ¿×´Ì¬
			anchor.setAnc_image(anchor_off);
			anchor.setImgicon(anchor_off1);
			anchor_vector.add(anchor);
		}
	}

	public static Vector<Anchor> getAnchor_vector() {
		return anchor_vector;
	}


	/**»ñȡϵͳÖлùÕ¾µÄ×ÜÊý*/
	public static int anchornum() {		
		int num=getAnchor_vector().size();
		return num;
	}



	/**ËÑË÷ij¸ö»ùÕ¾*/
	public static Vector<Anchor> serch_anchor(String anchorid) {
		Vector<Anchor> anchor=null;
		if( get_anchor(anchorid) !=null) {
			anchor=new Vector<Anchor>();
			anchor.add(get_anchor(anchorid));
		}
		return anchor;
	}

	/**Ð޸ĻùÕ¾ÁÙ½üÏ·¢×´Ì¬*/
	public static void alert_nearok(int ok,String anchorid) {
		if( get_anchor(anchorid) !=null) {
			get_anchor(anchorid).setNearok(ok);
		}
	}

	/**Ð޸ĻùÕ¾µÄͬ²½Ï·¢Çé¿ö*/
	public static void alert_tongbuok(int ok,String anchorid) {
		if( get_anchor(anchorid) !=null) {
			get_anchor(anchorid).setTongbuok(ok);
		}
	}

	/**Ð޸ĻùÕ¾µÄͬ²½×´Ì¬*/
	public static void alert_anchor_tonbu_state(String anchorid,String state) {
		if(get_anchor(anchorid) !=null) {			
			get_anchor(anchorid).setAnchorzhuangtai(state);
		}
	}

	/**ͨ¹ýIDÕÒµ½Ä³Ò»¸ö»ùÕ¾¶ÔÏó*/
	public static  Anchor get_anchor(String anchorid) {
		Anchor anchor= null;		
		if(anchor_vector.size() !=0) {
			Iterator<Anchor> it=anchor_vector.iterator();
			while(it.hasNext()) {
				Anchor anchor1=it.next();
				String idach=anchor1.getAnc_id();
				if(idach.equals(anchorid)) {
					anchor=anchor1;
					break;
				}
			}
		}

		return anchor;
	}



	/**ͨ¹ýIPµØÖ·ÕÒµ½Ä³¸ö»ùÕ¾*/
	public static Anchor found_anchor_from_ip(String ip) {
		Anchor anchor= null;		
		if(anchor_vector.size() !=0) {
			Iterator<Anchor> it=anchor_vector.iterator();
			while(it.hasNext()) {
				Anchor anchor1=it.next();
				String ip1=anchor1.getAnc_ip();
				if(ip1 !=null) {
					if(ip1.equals(ip)) {
						anchor=anchor1;
						break;
					}
				}
			}
		}
		return anchor;
	}




	/**¸Ä±äÒ»¸ö»ùÕ¾¶ÔÏóµÄ״̬ΪÔÚÏß*/
	public  static  void set_anchor_mode(Anchor anchor,String anchorid,String ip,int port) {
		if( anchor!=null) {			
			anchor.setAnc_ip(ip);
			anchor.setPort(port);
			String b1=anchor.getAnc_status();
			if(b1.equals("0")) {//Ð޸ĻùÕ¾ÉÏÏ߼Ǽ
				String tm=anchor.getAnc_cteatetime();
				int a= Shi_jian_cha_sss.get_time_cha_s(GetNowTime.now(),tm);
				JudgeTagOrAnchorOffline.insert_indata_shangxian(anchorid,"»ùÕ¾ÉÏÏß","ÀëÏßʱ³¤:"+a);//»ùÕ¾ÀëÏß²åÈëÀëÏ߼ǼÊý¾Ý¿â
				anchor.setAnc_status("1");
				anchor.setAnc_image(zaixian);	
			}
			anchor.setAnc_cteatetime(GetNowTime.now());
		}
	}






	/**»ùÕ¾ÀëÏß»òÕßÔÚÏß״̬
	 * @param modeÔÚÏßÊÇ1ÀëÏßÊÇ0*/
	public  static  void set_anchor_onandoff(String ip,String mode) {

		if(found_anchor_from_ip(ip) !=null) {
			found_anchor_from_ip(ip).setAnc_image(zaixian);	
			if(mode.equals("0")) {
				found_anchor_from_ip(ip).setAnc_image(lixian);
			}

			found_anchor_from_ip(ip).setAnc_status(mode);			

			String[] ziduan= {"anchormode","GreateTime","anchorid"};
			String[] zhi= {mode,GetNowTime.now(),found_anchor_from_ip(ip).getAnc_id()};		
			DatabaseManagement.fast_alert_dbase("tb_achor", ziduan, zhi);

		}
	}


	/**Ð޸ĻùÕ¾µÄ°æ±¾ÐÅÏ¢ºÍIPµØÖ·*/
	public  static  void set_anchor_version(String ip,String anchorid,String version) {

		if(get_anchor(anchorid) !=null) {
			get_anchor(anchorid).setVersion(version);
			get_anchor(anchorid).setAnc_ip(ip);
			get_anchor(anchorid).setAnc_status("1");
			get_anchor(anchorid).setAnc_image(zaixian);
			String mode="1";

			String[] ziduan= {"version","anchorip","anchormode","GreateTime","anchorid"};
			String[] zhi= {version,ip,mode,GetNowTime.now(),get_anchor(anchorid).getAnc_id()};		
			DatabaseManagement.fast_alert_dbase("tb_achor", ziduan, zhi);
		}
	}


	/**¸Ä±äÒ»¸ö»ùÕ¾¶ÔÏóµÄxyzfloorip*/
	public  static  void set_anchor_xyzfip(String anchorid,String x,String y,String z,
			String floor,String ip,String zu,String liangcheng,String baoliu9) {
		if(get_anchor(anchorid) !=null) {
			get_anchor(anchorid).setAnc_x(x);
			get_anchor(anchorid).setAnc_y(y);
			get_anchor(anchorid).setAnc_z(z);
			get_anchor(anchorid).setAnc_floor(floor);
			get_anchor(anchorid).setAnc_ip(ip);
			get_anchor(anchorid).setAnc_zu(zu);
			get_anchor(anchorid).setAnc_distance(liangcheng);
			get_anchor(anchorid).setBaoliu9(baoliu9);

		}
	}

	/**ÐÂÔöÒ»¸ö»ùÕ¾¶ÔÏó
	 * @param anchorid»ùÕ¾id
	 * @param x×ø±ê
	 * @param y×ø±ê
	 * @param z×ø±ê
	 * @param floor²ã
	 * @param zu×é
	 * @param liangcheng Á¿³Ì
	 * @param  ip
	 * @param  mode״̬
	 */
	public  static  void set_anchor(String anchorid,String x,String y,String z,
			String floor,String zu,String liangcheng,String ip,String mode,String baoliu9) {
		if(get_anchor(anchorid) == null) {
			Anchor new_anchor=new Anchor();
			new_anchor.setAnc_id(anchorid);
			new_anchor.setAnc_status(mode);
			new_anchor.setAnc_x(x);
			new_anchor.setAnc_y(y);
			new_anchor.setAnc_z(z);
			new_anchor.setAnc_floor(floor);
			new_anchor.setAnc_zu(zu);
			new_anchor.setAnc_distance(liangcheng);
			new_anchor.setAnc_ip(ip);
			new_anchor.setAnc_cteatetime(GetNowTime.now());
			new_anchor.setPort(8233);
			new_anchor.setAnc_image(zaixian);
			new_anchor.setBaoliu9(baoliu9);
			anchor_vector.add(new_anchor);
		}
	}

	/**ɾ³ýÒ»¸ö»ùÕ¾¶ÔÏó*/
	public  static  void remov_anchor(String anchorid) {
		if(get_anchor(anchorid) != null) {
			anchor_vector.remove(get_anchor(anchorid));
		}

	}



	/**ɾ³ýËùÓлùÕ¾¶ÔÏó*/
	public  static  void removall_anchor() {
		if(anchor_vector.size()!= 0) {
			anchor_vector.removeAllElements();
		}

	}


	public static Image getZaixian() {
		return zaixian;
	}


	public static Image getLixian() {
		return lixian;
	}

	/**»ñÈ¡»ùÕ¾IDµÄ¼¯ºÏ*/
	public static String[] get_anchorid() {
		int size=anchor_vector.size();		
		String[] anchoridstr=new String[size+2];
		anchoridstr[0]="Ñ¡Ôñ»ùÕ¾";
		anchoridstr[1]="ËùÓлùÕ¾";
		if(size !=0) {
			for(int i=0;i<size;i++) {
				anchoridstr[i+2]=anchor_vector.get(i).getAnc_id();
			}
		}
		return anchoridstr;		
	}

	/**»ñÈ¡»ùÕ¾IDµÄ¼¯ºÏ*/
	public static String[] get_anchorid3() {
		int size=anchor_vector.size();		
		String[] anchoridstr=new String[size+2];
		anchoridstr[0]="Ñ¡Ôñ»ùÕ¾";
		anchoridstr[1]="ËùÓлùÕ¾";
		if(size !=0) {
			for(int i=0;i<size;i++) {
				anchoridstr[i+2]=anchor_vector.get(i).getAnc_id();
			}

		}
		return anchoridstr;		
	}

	/**»ñÈ¡»ùÕ¾IDµÄ¼¯ºÏ*/
	public static String[] get_anchorid4() {
		int size=anchor_vector.size();		
		String[] anchoridstr=new String[size+1];
		anchoridstr[0]="Ñ¡Ôñ»ùÕ¾";
		if(size !=0) {
			for(int i=0;i<size;i++) {
				anchoridstr[i+1]=anchor_vector.get(i).getAnc_id();
			}
		}
		return anchoridstr;		
	}

	/**»ñÈ¡»ùÕ¾IDµÄ¼¯ºÏ*/
	public static String[] get_anchorid2() {
		int size=anchor_vector.size();		
		String[] anchoridstr=new String[size];
		if(size !=0) {
			for(int i=0;i<size;i++) {
				anchoridstr[i]=anchor_vector.get(i).getAnc_id();
			}
		}
		return anchoridstr;		
	}



	/**»ùÕ¾X×ø±ê¼¯ºÏ¸øµ½JNAʹÓÃ*/
	public static int[] anchor_xyz(String[] anchrids,String type) {
		int size=anchrids.length;
		int[] anchor=new int[size];
		for(int i=0;i<size;i++) {
			if(get_anchor(anchrids[i]) !=null) {
				if(type.equals("x")) {
					anchor[i]=Integer.parseInt(get_anchor(anchrids[i]).anc_x);
				}else if(type.equals("y")) {
					anchor[i]=Integer.parseInt(get_anchor(anchrids[i]).anc_y);
				}else if(type.equals("z")) {
					anchor[i]=Integer.parseInt(get_anchor(anchrids[i]).anc_z);
				}
			}else {
				if(type.equals("x")) {
					anchor[i]=0;
				}else if(type.equals("y")) {
					anchor[i]=0;
				}else if(type.equals("z")) {
					anchor[i]=0;
				}
			}
		}
		return anchor;
	} 

	/**»ùÕ¾ËùÔÚµÄ×éint[]¸øµ½JNAʹÓÃ*/
	public static int[] zu(String[] anchrids) {
		int size=anchrids.length;
		int[] zu=new int[size];
		for(int i=0;i<size;i++) {
			if(get_anchor(anchrids[i]) !=null) {
				zu[i]=Integer.parseInt(get_anchor(anchrids[i]).getAnc_zu());
			}
		}
		return zu;
	}

	/**»ùÕ¾µÄÁ¿³ÌÏÞÖÆint[] ¸øJNAʹÓÃ*/
	public static int[] anchor_liangcheng(String[] anchrids) {
		int size=anchrids.length;
		int[] liangchneg=new int[size];

		for(int i=0;i<size;i++) {
			if(get_anchor(anchrids[i]) !=null) {
				String a=get_anchor(anchrids[i]).getAnc_distance();
				if(a.equals("ÎÞÏÞÖÆ")) {
					liangchneg[i]=100000;
				}else {
					liangchneg[i]=Integer.parseInt(a);
				}

			}
		}
		return liangchneg;
	}

	/**»ñÈ¡»ùÕ¾µÄ²ãÐÅÏ¢¸øµ½JNAʹÓÃ*/
	public static int[] anchor_floor(String[] anchrids) {
		int size=anchrids.length;
		int[] liangchneg=new int[size];
		for(int i=0;i<size;i++) {
			if(get_anchor(anchrids[i]) !=null) {
				String a=get_anchor(anchrids[i]).getAnc_floor();
				liangchneg[i]=Integer.parseInt(a);			}
		}
		return liangchneg;
	}

	/**»ñÈ¡»ùÕ¾µÄ²ãÐÅÏ¢¸øµ½JNAʹÓÃ*/
	public static int[] anchor_floor(int[] anchrids) {
		int size=anchrids.length;
		int[] liangchneg=new int[size];
		for(int i=0;i<size;i++) {
			if(get_anchor(String.valueOf(anchrids[i])) !=null) {
				String a=get_anchor(String.valueOf(anchrids[i])).getAnc_floor();
				liangchneg[i]=Integer.parseInt(a);			}
		}
		return liangchneg;
	}

	/**Ð޸ĻùÕ¾ÐÅÏ¢*/
	public static void alert_anchor(
			String anchorid,
			String x, 
			String y,
			String z,
			String floor,
			String distance,
			String tongbu,
			String ip,
			String  version,
			String anc_status) {

		if(get_anchor(anchorid) !=null) {
			get_anchor(anchorid).setAnc_id(anchorid);
			get_anchor(anchorid).setAnc_x(x);
			get_anchor(anchorid).setAnc_y(y);
			get_anchor(anchorid).setAnc_z(z);
			get_anchor(anchorid).setAnc_floor(floor);
			get_anchor(anchorid).setAnc_distance(distance);
			get_anchor(anchorid).setAnchorzhuangtai(tongbu);
			get_anchor(anchorid).setAnc_ip(ip);
			get_anchor(anchorid).setVersion(version);
			get_anchor(anchorid).setAnc_status(anc_status);
		}

	}

	/**ÐÞ¸ÄÊý¾Ý¿âÖлùÕ¾ÐÅÏ¢*/
	public static void alert_tb_anchor() {
		int size=anchor_vector.size();
		if(size==0) {
			return;
		}
		StringBuffer sql=new StringBuffer("UPDATE tb_achor SET ");
		Vector<String> vp_anchorid=new Vector<String>();
		Vector<String> vp_x=new Vector<String>();
		Vector<String> vp_y=new Vector<String>();
		Vector<String> vp_z=new Vector<String>();
		Vector<String> vp_floor=new Vector<String>();
		Vector<String> vp_distance=new Vector<String>();
		Vector<String> vp_tongbu=new Vector<String>();
		Vector<String> vp_ip=new Vector<String>();
		Vector<String> vp_version=new Vector<String>();
		Vector<String> vp_state=new Vector<String>();
		Vector<String> vp_time=new Vector<String>();
		for(int i=0;i<size;i++) {
			Anchor ac=anchor_vector.get(i);
			String anchorid=ac.getAnc_id();
			String x=ac.getAnc_x(); 
			String y=ac.getAnc_y();
			String z=ac.getAnc_z();
			String floor=ac.getAnc_floor();
			String distance=ac.getAnc_distance();
			String tongbu=ac.getAnchorzhuangtai();
			if(tongbu==null) {
				tongbu=" ";
			}
			String ip=ac.getAnc_ip();
			String  version=ac.getVersion();
			if(version==null) {
				version="V0.00";
			}
			String state=ac.getAnc_status();
			vp_anchorid.add(anchorid);
			vp_x.add(x);
			vp_y.add(y);
			vp_z.add(z);
			vp_floor.add(floor);
			vp_distance.add(distance);
			vp_tongbu.add(tongbu);;
			vp_ip.add(ip);
			vp_version.add(version);
			vp_state.add(state);
			vp_time.add(GetNowTime.now());
		}

		sql.append(engine_do.getinfo(vp_x,"POSX",vp_anchorid,"anchorid")+" , ");
		sql.append(engine_do.getinfo(vp_y,"POSY",vp_anchorid,"anchorid")+" , ");
		sql.append(engine_do.getinfo(vp_z,"POSZ",vp_anchorid,"anchorid")+" , ");
		sql.append(engine_do.getinfo(vp_floor,"layer",vp_anchorid,"anchorid")+" , ");
		sql.append(engine_do.getinfo(vp_distance,"liangcheng",vp_anchorid,"anchorid")+" , ");
		sql.append(engine_do.getinfo(vp_tongbu,"tongbu",vp_anchorid,"anchorid")+" , ");
		sql.append(engine_do.getinfo(vp_ip,"anchorip",vp_anchorid,"anchorid")+" , ");
		sql.append(engine_do.getinfo(vp_version,"version",vp_anchorid,"anchorid")+" , ");
		sql.append(engine_do.getinfo(vp_time,"GreateTime",vp_anchorid,"anchorid")+" , ");
		sql.append(engine_do.getinfo(vp_state,"anchormode",vp_anchorid,"anchorid")+"  ");
		sql.append(engine_do.getlast(vp_anchorid,"anchorid"));

		DatabaseManagement.update(sql.toString());
	}

	/**URTģʽµÄʱºòÐÂÔö»ùÕ¾*/
	public static void urt(String tagid) {
		if(get_anchor(tagid) == null) {
			Anchor_Dell.set_anchor(tagid,"0","0","0","0","0","ÎÞÏÞÖÆ","","1","0");
			String[]  ziduan= {"anchorid","POSX","POSY","POSZ","layer","zu","liangcheng","anchormode","anchorip","GreateTime"};
			String[] zhi= {tagid,"0","0","0","0","0","ÎÞÏÞÖÆ","1","",GetNowTime.now()};
			DatabaseManagement.insertfast("tb_achor", ziduan, zhi);
			//ÐÂÔöÁÙ½ü»ùÕ¾ÐÅÏ¢
			Anchor_nerby_dell.add_anchorby(tagid,"","","","","","","","","","","0");

			//ÐÂÔöͬ²½»ùÕ¾
			Dell_TongbuAnchor.add_one_rootanchor(tagid, "", "0", "");
		}
	}

	/**URTģʽϸıä»ùÕ¾µÄxyz×ø±ê*/
	public static void urt_xyz(String tagid,String x,String y) {
		if(get_anchor(tagid)  != null) {
			if(Gps_Manage.isUrt_stop()) {
				get_anchor(tagid).setAnc_x(x);
				get_anchor(tagid).setAnc_y(y);
				String[]  ziduan= {"POSX","POSY","GreateTime","anchorid"};
				String[] zhi= {x,y,GetNowTime.now(),tagid};
				DatabaseManagement.fast_alert_dbase("tb_achor", ziduan, zhi);
			}
		}else {
			if(biaoji) {
				ShowMessage.zidingyi(tagid+"²»´æÔÚÇëÌí¼Ó¸Ã»ùÕ¾");
				biaoji=false;
			}
		}
	}

	/**»ñÈ¡×éµÄ¼¯ºÏint[]*/
	public static int[] anchor_zu(String anchorid) {
		int[] zus=null;
		if(get_anchor(anchorid) !=null) {
			String zu=get_anchor(anchorid).getAnc_zu();
			String[] zust=zu.split(";");
			int size=zust.length;
			zus=new int[size];
			for(int i=0;i<size;i++) {
				zus[i]=Integer.parseInt(zust[i]);
			}
		}
		return zus;
	}

	/**»ñÈ¡Á¿³ÌµÄ¼¯ºÏint[]*/
	public static int[] anchor_lc(String anchorid) {
		int[] zus=null;
		if(get_anchor(anchorid) !=null) {
			String zu=get_anchor(anchorid).getAnc_distance();
			String[] zust=zu.split(";");
			int size=zust.length;
			zus=new int[size];
			for(int i=0;i<size;i++) {
				if (zust[i].equals("ÎÞÏÞÖÆ") || zust[i].equals("0")  ) {
					zust[i]="100000";
				}
				zus[i]=Integer.parseInt(zust[i]);
			}
		}
		return zus;
	}

	/**ÅжÏ×éºÏÁ¿³ÌÊÇ·ñÒ»ÖÂ*/
	public static boolean lc_and_zu(String zu,String lc) {
		boolean a=false;
		String[] zus=zu.split(";");
		String[] lcs=lc.split(";");
		int a0=zus.length;
		int a1=lcs.length;
		if(a0 !=a1) {
			a=true;
		}
		return a;
	}

	/**»ñÈ¡»ùվÿһ²ãµÄËã·¨¼¯ºÏin[]*/
	public static int[] get_dimension(String anchorid) {
		int[] dimension=null;
		String ceng=get_anchor(anchorid).getAnc_floor();
		int[] zus=anchor_zu(anchorid);		
		if(zus !=null) {
			int size=zus.length;
			for(int i=0;i<size;i++) {
				dimension=new int[size];
				String zu=String.valueOf(zus[i]);
				Tb_cengzu suanfa=Dell_tbcengzu.get_tbcengzu(ceng, zu);
				int sf=2;
				if(suanfa !=null) {
					sf=Integer.parseInt(suanfa.getSuan_fa_wei_du());
				}				
				dimension[i]=sf;
			}
		}
		return dimension;		
	}

	/**ÅжÏIPÊDz»ÊÇ»ùÕ¾µÄIP*/
	public static Boolean ipok(String ip) {
		boolean ipok=true;
		int size=anchor_vector.size();
		for(int i=0;i<size;i++) {
			String ip1=anchor_vector.get(i).getAnc_ip();
			if(ip1.equals(ip)) {
				ipok=true;
				break;
			}else {
				ipok=false;
			}
		}
		return ipok;

	}

	/**ÊÕµ½ÐÄÌø°ü×Ô¶¯ÐÂÔöÒ»¸ö»ùÕ¾*/
	public static void autoaddanchor(String anchorid,String anchorip,int port) {
		String POSX="0";
		String POSY="0";
		String POSZ="0";
		String layer="0";
		String zu="0";
		String baoliu9="0";
		String liangcheng="100000";
		String anchormode="1";

		String[]  ziduan= {"anchorid","POSX","POSY","POSZ","layer","zu","liangcheng","anchormode","anchorip","GreateTime"};
		String[] zhi= {anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchormode,anchorip,GetNowTime.now()};			

		if(DatabaseManagement.insertfast("tb_achor", ziduan, zhi)) {
			Dell_tbcengzu.add_cengzu_form_addanchor(layer, zu);//Ìí¼Ó²ã×é¶ÔÏó
			Anchor_Dell.set_anchor(anchorid,POSX,POSY,POSZ,layer, zu,liangcheng,anchorip,anchormode,baoliu9);			
			Anchor_nerby_dell.add_anchorby(anchorid,"","","","","","","","","","","0");	//ÐÂÔöÁÙ½ü»ùÕ¾ÐÅÏ¢
			Dell_TongbuAnchor.add_one_rootanchor(anchorid, "", "0", "");//ÐÂÔöͬ²½»ùÕ¾
			ShowMessage.zidingyi_24("×Ô¶¯Ìí¼ÓÁËһ̨δ¼ÈëµÄ»ùÕ¾£º"+anchorid);
		}
	}



	/**»ñÈ¡¿ç²ã×é»ùÕ¾µÄ¼¯ºÏ*/
	public static Vector<Anchor> getKczcnchor_vector() {
		return kczcnchor_vector;
	}

	public static Vector<Anchor> getBjjl_vector() {
		return bjjl_vector;
	}



	public static double getAnchorh0() {
		return anchorh0;
	}

	public static void setAnchorh0(double anchorh0) {
		Anchor_Dell.anchorh0 = anchorh0;
	}

	public static double getAnchorhr() {
		return anchorhr;
	}

	public static void setAnchorhr(double anchorhr) {
		Anchor_Dell.anchorhr = anchorhr;
	}

	/**»ñÈ¡ËùÓÐÔÚÏß»ùÕ¾µÄÊýÁ¿*/
	public static int[] get_online_anchornum() {
		int[] num=new int[2];
		int size=anchor_vector.size();
		int num1=0;
		for(int i=0;i<size;i++) {
			String on=anchor_vector.get(i).getAnc_status();
			if(on.equals("1")) {
				num1=num1+1;
			}
		}
		num[0]=num1;
		num[1]=size-num1;
		return num;
	}

	/**ÉèÖûùÕ¾µÄͼ±ê
	 * 0ÀëÏߣ¬1ÔÚÏߣ¬2»ÆÉ«£¬3ÂÌÉ«£¬4ºìÉ«*/
	public static void set_anchor_image(int state,String anchorid) {
		Anchor anchor=Anchor_Dell.get_anchor(anchorid);
		switch (state){
		case 0 :
			anchor.setAnc_image(anchor_off);
			anchor.setImgicon(anchor_off1);
		break;
		case 1 :
			anchor.setAnc_image(anchor_on);
			anchor.setImgicon(anchor_on1);
		break;
		case 2 :
			anchor.setAnc_image(anchor_yellow);
			anchor.setImgicon(anchor_yellow1);
		break;
		case 3 :
			anchor.setAnc_image(anchor_green);
			anchor.setImgicon(anchor_green1);
		break;
		case 4 :
			anchor.setAnc_image(anchor_red);
			anchor.setImgicon(anchor_red1);
		break;
		}
	}

}