package engbs;
import DataBase.DatabaseManagement;
import Method.GetNowTime;
import PbuliClass.ShowMessage;
import PbuliClass.Systems;
import anchor.Anchor_Dell;
import anchor.Anchor_nerby_dell;
import tbDataModel_Dell.Dell_TongbuAnchor;
import tbDataModel_Dell.Dell_tbcengzu;

/**ÐÂÔöÒ»¸ö»ùÕ¾
 * BSTOCS1£¬ADDANC,¡¾»ùÕ¾id¡¿,¡¾X×ø±ê¡¿,¡¾Y×ø±ê¡¿,¡¾Z×ø±ê¡¿,¡¾ËùÔڲ㡿,¡¾ËùÔÚ×é¡¿£¬¡¾»ùÕ¾Á¿³Ì¡¿£¬¡¾»ùÕ¾µØÖ·¡¿£¬¡¾END¡¿
 * ¡¾X×ø±ê¡¿¸ù¾Ýʵ¼ÊÌîд£¬²»ÄÜΪ¿Õ£¬±ØÐëÊÇÊý×Ö
 * ¡¾Y×ø±ê¡¿¸ù¾Ýʵ¼ÊÌîд£¬²»ÄÜΪ¿Õ£¬±ØÐëÊÇÊý×Ö
 * ¡¾Z×ø±ê¡¿¸ù¾Ýʵ¼ÊÌîд£¬²»ÄÜΪ¿Õ£¬±ØÐëÊÇÊý×Ö
 * ¡¾ËùÔڲ㡿¸ù¾Ýʵ¼ÊÌîд£¬²»ÄÜΪ¿Õ£¬±ØÐëÊÇÊý×Ö£¬Ä¬ÈÏΪ0
 * ¡¾ËùÔÚ×é¡¿¸ù¾Ýʵ¼ÊÌîд£¬²»ÄÜΪ¿Õ£¬±ØÐëÊÇÊý×Ö
 * ¡¾»ùÕ¾Á¿³Ì¡¿Ä¬ÈÏΪ100000
 * ¡¾»ùÕ¾µØÖ·¡¿
 * ¡¾END¡¿½áÊø±ê־λ 
 * ÐÞ¸Äij¸ö»ùÕ¾
 * BSTOCS1£¬ALTERANC,¡¾»ùÕ¾id¡¿,¡¾X×ø±ê¡¿,¡¾Y×ø±ê¡¿,¡¾Z×ø±ê¡¿,¡¾ËùÔڲ㡿,¡¾ËùÔÚ×é¡¿£¬¡¾»ùÕ¾Á¿³Ì¡¿£¬¡¾»ùÕ¾µØÖ·¡¿£¬¡¾END¡¿
 * ɾ³ýij¸ö»ùÕ¾
 * BSTOCS1£¬DELETEANC,¡¾»ùÕ¾id¡¿,¡¾END¡¿
 * ɾ³ýËùÓлùÕ¾
 * BSTOCS1£¬DELETEALLANC,¡¾END¡¿
 **/
public class Bs_dell_anchor {
	static int baoliu9=0;
	
	/**ÐÂÔöÒ»¸ö»ùÕ¾*/
	public static void ADDANC(String[] a) {
		String anchorid=a[2];
		String x=a[3];
		String y=a[4];
		String z=a[5];
		String floor=a[6];
		String zu=a[7];
		String distance=a[8];
		String ip=a[9];
		if (Systems.isWuxian()){
			String wxdisTance=a[10];
			baoliu9 = Integer.parseInt(wxdisTance);
		}
		Anchor_Dell.set_anchor(anchorid,x,y,z,floor, zu,distance,ip,"1","0");		
		Dell_tbcengzu.add_cengzu_form_addanchor(floor, zu);//Ìí¼Ó²ã×é¶ÔÏó;//Ìí¼ÓËã·¨		
		Anchor_nerby_dell.add_anchorby(anchorid,"","","","","","","","","","","0");//ÐÂÔöÁÙ½ü»ùÕ¾ÐÅÏ¢		
		Dell_TongbuAnchor.add_one_rootanchor(anchorid, "", "0", "");//ÐÂÔöͬ²½»ùÕ¾		
		String[]  ziduan= {"anchorid","POSX","POSY","POSZ","layer","zu",
				"liangcheng","anchormode","anchorip","GreateTime"};
		String[] zhi= {anchorid,x,y,z,floor,zu,
				distance,"1",ip,GetNowTime.now()};
		DatabaseManagement.insertfast("tb_achor", ziduan, zhi);
		ShowMessage.zidingyi(GetNowTime.now()+"ÐÂÔö»ùÕ¾³É¹¦"+anchorid);
		
	}
	
	/**Ð޸ĻùÕ¾*/
	public static void ALTERANC(String[] a) {
		
		String anchorid=a[2];
		String x=a[3];
		String y=a[4];
		String z=a[5];
		String floor=a[6];
		String zu=a[7];
		String distance=a[8];
		String ip=a[9];
		Anchor_Dell.set_anchor_xyzfip(anchorid,x,y, z,floor,ip,zu,distance,"0");
		String[] ziduan= {"POSX","POSY","POSZ","layer","zu","liangcheng","anchorip","anchorid"};
		String[] zhi= {x,y,z,floor,zu,distance,ip,anchorid};
		DatabaseManagement.fast_alert_dbase("tb_achor", ziduan, zhi);
		ShowMessage.zidingyi(GetNowTime.now()+"Ð޸ĻùÕ¾³É¹¦"+anchorid);
		
	}
	
	/**ɾ³ý»ùÕ¾*/
	public static void DELETEANC(String[] a) {
		String anchorid=a[2];
		Anchor_Dell.remov_anchor(anchorid);
		String deleteSql="DELETE FROM tb_achor WHERE anchorid='"+anchorid+"'";							
		DatabaseManagement.update(deleteSql);
		ShowMessage.zidingyi(GetNowTime.now()+"ɾ³ý»ùÕ¾³É¹¦"+anchorid);
		
	}
	
	/**ɾ³ýËùÓлùÕ¾*/
	public static void DELETEALLANC() {		
		Anchor_Dell.removall_anchor();
		String deleteSql="TRUNCATE TABLE tb_achor";
		DatabaseManagement.update(deleteSql);
		ShowMessage.zidingyi(GetNowTime.now()+"ɾ³ýËùÓлùÕ¾³É¹¦");
	}

}