package shiping;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import DataBase.DatabaseManagement;
import Method.GetNowTime;
@SuppressWarnings("rawtypes")
public class Dell_shiping {

	//ÊÓƵ¶ÔÏóµÄ¼¯ºÏ
	static Vector<tb_shipin> shiping_vector=new Vector<tb_shipin>();
	static {	
		Iterator iterator = DatabaseManagement.get_alldate_indatabase("tb_shipin").iterator();	
		while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
			List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
			tb_shipin sp=new tb_shipin();
			sp.setId((String) info.get(0));  
			sp.setFencename((String) info.get(1));  
			sp.setShebeiid((String) info.get(2));              
			sp.setTongdaoid((String) info.get(3));             
			sp.setAddtime((String) info.get(4));              
			sp.setPosx((String) info.get(5));    
			sp.setPosy((String) info.get(6));    
			sp.setPosz((String) info.get(7));    
			sp.setFloor((String) info.get(8));   
			sp.setName((String) info.get(9));    
			sp.setBaoliu1((String) info.get(10));  
			sp.setBaoliu2((String) info.get(11));  
			sp.setBaoliu3((String) info.get(12));  
			sp.setBaoliu4((String) info.get(13));  
			sp.setBaoliu5((String) info.get(14));  
			sp.setBaoliu6((String) info.get(15));  
			sp.setBaoliu7((String) info.get(16)); 
			shiping_vector.add(sp);
		}
	}


	public static Vector<tb_shipin> getShiping_vector() {
		return shiping_vector;
	}


	/**ͨ¹ýÉ豸idÕÒµ½Ä³¸öÉ豸*/
	public static tb_shipin  get_tb_shipin(String Shebeiid) {
		tb_shipin sp=null;
		if(shiping_vector.size() !=0) {
			Iterator<tb_shipin> it=shiping_vector.iterator();
			while(it.hasNext()) {
				tb_shipin sp1=it.next();
				String Shebeiid1=sp1.getShebeiid();
				if(Shebeiid.equals(Shebeiid1)) {
					sp=sp1;
					break;
				}
			}
		}
		return sp;
	}

	/**Ìí¼ÓÒ»¸öÊÓƵ¶ÔÏó*/
	public static void add(
			String fencename,//ÊÓƵ×÷ÓÃÇøÓòÃû³Æ
			String shebeiid,//É豸±àºÅ
			String tongdaoid,//ͨµÀID
			String posx,//ÊÓƵ°²×°X×ø±ê
			String posy,//ÊÓƵ°²×°Y×ø±ê
			String posz,//ÊÓƵ°²×°Z×ø±ê
			String floor,//ÊÓƵËùÔÚ²ã
			String name			
			) {

		if(get_tb_shipin(shebeiid)==null) {
			tb_shipin sp=new tb_shipin();
			sp.setFencename(fencename);//ÊÓƵ×÷ÓÃÇøÓòÃû³Æ
			sp.setShebeiid(shebeiid);//É豸±àºÅ
			sp.setTongdaoid(tongdaoid);//ͨµÀID
			sp.setPosx(posx);//ÊÓƵ°²×°X×ø±ê
			sp.setPosy(posy);//ÊÓƵ°²×°Y×ø±ê
			sp.setPosz(posz);//ÊÓƵ°²×°Z×ø±ê
			sp.setFloor(floor);//ÊÓƵËùÔÚ²ã
			sp.setName(name);
			shiping_vector.add(sp);
			String addtime=GetNowTime.now();
			String[]  ziduan= {"fencename","shebeiid","tongdaoid","addtime","posx","posy","posz","floor","name"};
			String[] zhi= {fencename,shebeiid,tongdaoid,addtime,posx,posy,posz,floor,name};		
			DatabaseManagement.insertfast("tb_shipin", ziduan, zhi);
		}

	}

	/**ÐÞ¸ÄÒ»¸öÊÓƵ¶ÔÏó*/
	public static void alert(
			String fencename,//ÊÓƵ×÷ÓÃÇøÓòÃû³Æ
			String shebeiid,//É豸±àºÅ
			String tongdaoid,//ͨµÀID
			String posx,//ÊÓƵ°²×°X×ø±ê
			String posy,//ÊÓƵ°²×°Y×ø±ê
			String posz,//ÊÓƵ°²×°Z×ø±ê
			String floor,//ÊÓƵËùÔÚ²ã
			String name	
			) {

		if(get_tb_shipin(shebeiid) !=null) {
			get_tb_shipin(shebeiid).setFencename(fencename);//ÊÓƵ×÷ÓÃÇøÓòÃû³Æ
			get_tb_shipin(shebeiid).setTongdaoid(tongdaoid);//ͨµÀID
			get_tb_shipin(shebeiid).setPosx(posx);//ÊÓƵ°²×°X×ø±ê
			get_tb_shipin(shebeiid).setPosy(posy);//ÊÓƵ°²×°Y×ø±ê
			get_tb_shipin(shebeiid).setPosz(posz);//ÊÓƵ°²×°Z×ø±ê
			get_tb_shipin(shebeiid).setFloor(floor);//ÊÓƵËùÔÚ²ã
			get_tb_shipin(shebeiid).setName(name);
			String addtime=GetNowTime.now();
			String[]  ziduan= {"fencename","tongdaoid","addtime","posx","posy","posz","floor","name","shebeiid"};
			String[] zhi= {fencename,tongdaoid,addtime,posx,posy,posz,floor,name,shebeiid};		
			DatabaseManagement.fast_alert_dbase("tb_shipin", ziduan, zhi);
		}

	}

	/**ɾ³ýÒ»¸öÊÓƵ¶ÔÏó*/
	public static void delete(String shebeiid) {
		if(get_tb_shipin(shebeiid) !=null) {
			shiping_vector.removeElement(get_tb_shipin(shebeiid));
		}

	}

	/**ɾ³ýËùÓÐÒ»¸öÊÓƵ¶ÔÏó*/
	public static void deleteall() {
		if(shiping_vector.size() !=0) {
			shiping_vector.removeAllElements();
			String deleteall="TRUNCATE TABLE tb_shipin";
			DatabaseManagement.update(deleteall) ;
		}
	}
	
	/**Ìí¼ÓÒ»¸öÊÓƵ¶ÔÏó*/
	public static void add2(
			String fencename,//ÊÓƵ×÷ÓÃÇøÓòÃû³Æ
			String shebeiid,//É豸±àºÅ
			String tongdaoid,//ͨµÀID
			String posx,//ÊÓƵ°²×°X×ø±ê
			String posy,//ÊÓƵ°²×°Y×ø±ê
			String posz,//ÊÓƵ°²×°Z×ø±ê
			String floor,//ÊÓƵËùÔÚ²ã
			String name			
			) {

		if(get_tb_shipin(shebeiid)==null) {
			tb_shipin sp=new tb_shipin();
			sp.setFencename(fencename);//ÊÓƵ×÷ÓÃÇøÓòÃû³Æ
			sp.setShebeiid(shebeiid);//É豸±àºÅ
			sp.setTongdaoid(tongdaoid);//ͨµÀID
			sp.setPosx(posx);//ÊÓƵ°²×°X×ø±ê
			sp.setPosy(posy);//ÊÓƵ°²×°Y×ø±ê
			sp.setPosz(posz);//ÊÓƵ°²×°Z×ø±ê
			sp.setFloor(floor);//ÊÓƵËùÔÚ²ã
			sp.setName(name);
			shiping_vector.add(sp);
		}

	}

	/**ÐÞ¸ÄÒ»¸öÊÓƵ¶ÔÏó*/
	public static void alert2(
			String fencename,//ÊÓƵ×÷ÓÃÇøÓòÃû³Æ
			String shebeiid,//É豸±àºÅ
			String tongdaoid,//ͨµÀID
			String posx,//ÊÓƵ°²×°X×ø±ê
			String posy,//ÊÓƵ°²×°Y×ø±ê
			String posz,//ÊÓƵ°²×°Z×ø±ê
			String floor,//ÊÓƵËùÔÚ²ã
			String name	
			) {

		if(get_tb_shipin(shebeiid) !=null) {
			get_tb_shipin(shebeiid).setFencename(fencename);//ÊÓƵ×÷ÓÃÇøÓòÃû³Æ
			get_tb_shipin(shebeiid).setTongdaoid(tongdaoid);//ͨµÀID
			get_tb_shipin(shebeiid).setPosx(posx);//ÊÓƵ°²×°X×ø±ê
			get_tb_shipin(shebeiid).setPosy(posy);//ÊÓƵ°²×°Y×ø±ê
			get_tb_shipin(shebeiid).setPosz(posz);//ÊÓƵ°²×°Z×ø±ê
			get_tb_shipin(shebeiid).setFloor(floor);//ÊÓƵËùÔÚ²ã
			get_tb_shipin(shebeiid).setName(name);
		}

	}

	
	/**ɾ³ýËùÓÐÒ»¸öÊÓƵ¶ÔÏó*/
	public static void deleteall2() {
		if(shiping_vector.size() !=0) {
			shiping_vector.removeAllElements();
		}
	}
	

	
	
	

}