package tbDataModel_Dell;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import DataBase.DatabaseManagement;
import Judge.JugeNumber;
import PbuliClass.ShowMessage;
import anchor.Dell_cengao;
import home.Open_soft_dialog;
import tbDataModel.Tb_cengzu;
@SuppressWarnings("rawtypes")
public class Dell_tbcengzu {
	static Vector<Tb_cengzu > cengzuvc=new Vector<>();//²ã×éµÄ¼¯ºÏ
	static Vector<Tb_cengzu > zkdc_vector=new Vector<>();//×é¿ç¶à²ãµÄ¼¯ºÏ
	static Vector<Tb_cengzu > outzu_vector=new Vector<>();//ÊÒÍâ×éµÄ¼¯ºÏ
	static Vector<Tb_cengzu > bjz_vector=new Vector<>();//±Ø¾­×éµÄ¼¯ºÏ
	static Vector<Tb_cengzu > zkdys_vector=new Vector<>();//¿í¶ÈÔ¼Êø×éµÄ¼¯ºÏ
	static Vector<Tb_cengzu > line_vector=new Vector<>();;//һά»ùÕ¾µÄ¼¯ºÏ
	static Vector<String > cengvc=new Vector<>();//²ãµÄ¼¯ºÏ

	static {
		Open_soft_dialog.addara("¼ÓÔØtb_cengzu");
		List list=DatabaseManagement.get_alldate_indatabase("tb_ceng_zu");
		Iterator iterator =list.iterator() ;
		while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ		
			List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
			Tb_cengzu tb_cengzu=new Tb_cengzu();
			String id=(String) info.get(0); // 
			String floor=(String) info.get(1);   //²ã  
			String zu=(String) info.get(2);  //×é      
			String bi_jing_ju_li=(String) info.get(3);//±Ø¾­¾àÀë    
			String is_shi_wai_zu=(String) info.get(4);//ÊÇ·ñÊÇÊÒÍâ×é0²»ÊÇ£¬1ÊÇ    
			String is_bi_jing_zu=(String) info.get(5);//ÊÇ·ñÊDZؾ­×é0²»ÊÇ£¬1ÊÇ    
			String suan_fa_wei_du=(String) info.get(6);//Ëã·¨µÄά¶È0,1,2,3    
			String suan_fa=(String) info.get(7);//ĬÈÏTOF    
			String zu_kua_duo_ceng=(String) info.get(8);//×é¿ç¶à²ã    
			String you_xiao_qu_yu=(String) info.get(9);//ÓÐЧÇøÓò    
			String zu_kuang_du=(String) info.get(10);//×é¿í¶È  
			tb_cengzu.setId(id);
			tb_cengzu.setFloor(floor);
			tb_cengzu.setZu(zu);
			tb_cengzu.setBi_jing_ju_li(bi_jing_ju_li);
			tb_cengzu.setIs_shi_wai_zu(is_shi_wai_zu);
			tb_cengzu.setIs_bi_jing_zu(is_bi_jing_zu);
			tb_cengzu.setSuan_fa_wei_du(suan_fa_wei_du);
			tb_cengzu.setSuan_fa(suan_fa);
			tb_cengzu.setZu_kua_duo_ceng(zu_kua_duo_ceng);
			tb_cengzu.setYou_xiao_qu_yu(you_xiao_qu_yu);
			tb_cengzu.setZu_kuang_du(zu_kuang_du);
			cengzuvc.add(tb_cengzu);
			addceng(floor);
			addvc(tb_cengzu,bi_jing_ju_li, is_shi_wai_zu,is_bi_jing_zu,suan_fa_wei_du, 
					zu_kua_duo_ceng,zu_kuang_du);
		}
		if(cengzuvc.size()==0) {
			add_cengzu();
		}
	}

	/**ͨ¹ý²ãIDÕÒµ½²ã*/
	public static String getfloor(String ceng) {
		String ceng1=null;
		for(int i=0;i<cengvc.size();i++ ) {
			String c0=cengvc.get(i);
			if(c0.equals(ceng)) {
				ceng1=c0;
				break;
			}
		}
		return ceng1;
	}
	
	/**Ìí¼Ó²ã*/
	public static void addceng(String ceng) {
		String floor=getfloor( ceng);
		if(floor==null) {
			cengvc.add(ceng);
			Dell_cengao.add_ceng_gao(ceng);//Ìí¼Ó²ã¸ß¶ÔÏó
		}
	}
	
	/**ͨ¹ý²ã×éÕÒµ½²ã×é¶ÔÏó*/
	public static Tb_cengzu get_tbcengzu(String ceng,String zu) {
		Tb_cengzu tb_cengzu=null;
		int size=cengzuvc.size();
		for(int i=0;i<size;i++) {
			Tb_cengzu tb_cengzu1=cengzuvc.get(i);
			String ceng1=tb_cengzu1.getFloor();
			String zu1=tb_cengzu1.getZu();
			if(ceng.equals(ceng1)&& zu.equals(zu1)) {
				tb_cengzu=tb_cengzu1;
				break;
			}
		}
		return tb_cengzu;
	}

	/**ÐÂÔö»òÕßÐÞ¸ÄÒ»¸ö²ã×é¶ÔÏó*/
	public static void add_or_alert_cengzu(
			String floor,   //²ã  
			String zu,  //×é      
			String bi_jing_ju_li,//±Ø¾­¾àÀë    
			String is_shi_wai_zu,//ÊÇ·ñÊÇÊÒÍâ×é0²»ÊÇ£¬1ÊÇ    
			String is_bi_jing_zu,//ÊÇ·ñÊDZؾ­×é0²»ÊÇ£¬1ÊÇ    
			String suan_fa_wei_du,//Ëã·¨µÄά¶È0,1,2,3    
			String suan_fa,//ĬÈÏTOF    
			String zu_kua_duo_ceng,//×é¿ç¶à²ã    
			String you_xiao_qu_yu,//ÓÐЧÇøÓò    
			String zu_kuang_du//×é¿í¶È 
			) {

		Tb_cengzu tb_cengzu=get_tbcengzu(floor,zu);
		String id=floor+""+zu;
		if(tb_cengzu==null) {
			tb_cengzu=new Tb_cengzu();
			tb_cengzu.setId(id);
			tb_cengzu.setFloor(floor);
			tb_cengzu.setZu(zu);
			tb_cengzu.setBi_jing_ju_li(bi_jing_ju_li);
			tb_cengzu.setIs_shi_wai_zu(is_shi_wai_zu);
			tb_cengzu.setIs_bi_jing_zu(is_bi_jing_zu);
			tb_cengzu.setSuan_fa_wei_du(suan_fa_wei_du);
			tb_cengzu.setSuan_fa(suan_fa);
			tb_cengzu.setZu_kua_duo_ceng(zu_kua_duo_ceng);
			tb_cengzu.setYou_xiao_qu_yu(you_xiao_qu_yu);
			tb_cengzu.setZu_kuang_du(zu_kuang_du);
			cengzuvc.add(tb_cengzu);
			insert_tb_cengzu(
					id,
					floor,   //²ã  
					zu,  //×é      
					bi_jing_ju_li,//±Ø¾­¾àÀë    
					is_shi_wai_zu,//ÊÇ·ñÊÇÊÒÍâ×é0²»ÊÇ£¬1ÊÇ    
					is_bi_jing_zu,//ÊÇ·ñÊDZؾ­×é0²»ÊÇ£¬1ÊÇ    
					suan_fa_wei_du,//Ëã·¨µÄά¶È0,1,2,3    
					suan_fa,//ĬÈÏTOF    
					zu_kua_duo_ceng,//×é¿ç¶à²ã    
					you_xiao_qu_yu,//ÓÐЧÇøÓò    
					zu_kuang_du//×é¿í¶È 
					);
		}else {
			tb_cengzu=new Tb_cengzu();
			tb_cengzu.setId(id);
			tb_cengzu.setFloor(floor);
			tb_cengzu.setZu(zu);
			tb_cengzu.setBi_jing_ju_li(bi_jing_ju_li);
			tb_cengzu.setIs_shi_wai_zu(is_shi_wai_zu);
			tb_cengzu.setIs_bi_jing_zu(is_bi_jing_zu);
			tb_cengzu.setSuan_fa_wei_du(suan_fa_wei_du);
			tb_cengzu.setSuan_fa(suan_fa);
			tb_cengzu.setZu_kua_duo_ceng(zu_kua_duo_ceng);
			tb_cengzu.setYou_xiao_qu_yu(you_xiao_qu_yu);
			tb_cengzu.setZu_kuang_du(zu_kuang_du);
			alert_tbcengzu(
					id,
					floor,   //²ã  
					zu,  //×é      
					bi_jing_ju_li,//±Ø¾­¾àÀë    
					is_shi_wai_zu,//ÊÇ·ñÊÇÊÒÍâ×é0²»ÊÇ£¬1ÊÇ    
					is_bi_jing_zu,//ÊÇ·ñÊDZؾ­×é0²»ÊÇ£¬1ÊÇ    
					suan_fa_wei_du,//Ëã·¨µÄά¶È0,1,2,3    
					suan_fa,//ĬÈÏTOF    
					zu_kua_duo_ceng,//×é¿ç¶à²ã    
					you_xiao_qu_yu,//ÓÐЧÇøÓò    
					zu_kuang_du//×é¿í¶È 
					);
		}
	}

	/**Êý¾Ý²åÈë²ã×éÊý¾Ý¿â*/
	public static void insert_tb_cengzu(
			String id,
			String floor,   //²ã  
			String zu,  //×é      
			String bi_jing_ju_li,//±Ø¾­¾àÀë    
			String is_shi_wai_zu,//ÊÇ·ñÊÇÊÒÍâ×é0²»ÊÇ£¬1ÊÇ    
			String is_bi_jing_zu,//ÊÇ·ñÊDZؾ­×é0²»ÊÇ£¬1ÊÇ    
			String suan_fa_wei_du,//Ëã·¨µÄά¶È0,1,2,3    
			String suan_fa,//ĬÈÏTOF    
			String zu_kua_duo_ceng,//×é¿ç¶à²ã    
			String you_xiao_qu_yu,//ÓÐЧÇøÓò    
			String zu_kuang_du//×é¿í¶È 
			) {
		String[] ziduan= {
				"id",
				"floor",   
				"zu",      
				"bi_jing_ju_li",  
				"is_shi_wai_zu",  
				"is_bi_jing_zu",  
				"suan_fa_wei_du",  
				"suan_fa",  
				"zu_kua_duo_ceng",  
				"you_xiao_qu_yu",  
		"zu_kuang_du"};

		String[] zhi= {
				id,
				floor,   
				zu,      
				bi_jing_ju_li,  
				is_shi_wai_zu,  
				is_bi_jing_zu,  
				suan_fa_wei_du,  
				suan_fa,  
				zu_kua_duo_ceng,  
				you_xiao_qu_yu,  
				zu_kuang_du
		};
		DatabaseManagement.insertfast("tb_ceng_zu", ziduan, zhi);
		ShowMessage.zidingyi(id+"±£´æ³É¹¦");
	}

	/**ÐÞ¸ÄÊý¾Ý¿âÊý¾Ý*/
	public static void alert_tbcengzu(
			String id,
			String floor,   //²ã  
			String zu,  //×é      
			String bi_jing_ju_li,//±Ø¾­¾àÀë    
			String is_shi_wai_zu,//ÊÇ·ñÊÇÊÒÍâ×é0²»ÊÇ£¬1ÊÇ    
			String is_bi_jing_zu,//ÊÇ·ñÊDZؾ­×é0²»ÊÇ£¬1ÊÇ    
			String suan_fa_wei_du,//Ëã·¨µÄά¶È0,1,2,3    
			String suan_fa,//ĬÈÏTOF    
			String zu_kua_duo_ceng,//×é¿ç¶à²ã    
			String you_xiao_qu_yu,//ÓÐЧÇøÓò    
			String zu_kuang_du//×é¿í¶È 
			) {
		String[] ziduan= {			
				"floor",   
				"zu",      
				"bi_jing_ju_li",  
				"is_shi_wai_zu",  
				"is_bi_jing_zu",  
				"suan_fa_wei_du",  
				"suan_fa",  
				"zu_kua_duo_ceng",  
				"you_xiao_qu_yu",  
				"zu_kuang_du",
				"id"
		};

		String[] zhi= {			
				floor,   
				zu,      
				bi_jing_ju_li,  
				is_shi_wai_zu,  
				is_bi_jing_zu,  
				suan_fa_wei_du,  
				suan_fa,  
				zu_kua_duo_ceng,  
				you_xiao_qu_yu,  
				zu_kuang_du,
				id
		};
		DatabaseManagement.fast_alert_dbase("tb_ceng_zu", ziduan, zhi);
		ShowMessage.zidingyi(id+"Ð޸ijɹ¦");
	}

	/**ÐÂÔöÒ»¸ö0²ã0×é*/
	public static void add_cengzu(){
		add_or_alert_cengzu(
				"0",   //²ã  
				"0",  //×é      
				"0",//±Ø¾­¾àÀë    
				"0",//ÊÇ·ñÊÇÊÒÍâ×é0²»ÊÇ£¬1ÊÇ    
				"0",//ÊÇ·ñÊDZؾ­×é0²»ÊÇ£¬1ÊÇ    
				"2",//Ëã·¨µÄά¶È0,1,2,3    
				"TOF",//ĬÈÏTOF    
				"-1",//×é¿ç¶à²ã    
				"Ñ¡ÔñÇøÓò",//ÓÐЧÇøÓò    
				"0"//×é¿í¶È 
				);
	}

	/**Ìí¼Ó»ùÕ¾µÄʱºòÈç¹û²ã×é²»´æÔÚÔòÔö¼ÓÒ»¸ö²ã×é¶ÔÏó*/
	public static void  add_cengzu_form_addanchor(String floor,String zu) {
		String[] zs=zu.split(";");
		int size=zs.length;
		if(size>1) {
			for(int i=0;i<size;i++) {
				add_czu_from_ac(floor,zs[i]);
			}
		}else {
			add_czu_from_ac(floor,zu);
		}

	}

	/**Ìí¼Ó»ùÕ¾µÄʱºòÈç¹û²ã×é²»´æÔÚÔòÔö¼ÓÒ»¸ö²ã×é¶ÔÏó*/
	public static void add_czu_from_ac(String floor,String zu) {
		Tb_cengzu tb_cengzu=get_tbcengzu(floor,zu);
		String id=floor+""+zu;
		if(tb_cengzu==null) {
			tb_cengzu=new Tb_cengzu();
			tb_cengzu.setId(id);
			tb_cengzu.setFloor(floor);
			tb_cengzu.setZu(zu);
			tb_cengzu.setBi_jing_ju_li("0");
			tb_cengzu.setIs_shi_wai_zu("0");
			tb_cengzu.setIs_bi_jing_zu("0");
			tb_cengzu.setSuan_fa_wei_du("2");
			tb_cengzu.setSuan_fa("TOF");
			tb_cengzu.setZu_kua_duo_ceng("-1");
			tb_cengzu.setYou_xiao_qu_yu("Ñ¡ÔñÇøÓò");
			tb_cengzu.setZu_kuang_du("0");
			cengzuvc.add(tb_cengzu);
			insert_tb_cengzu(
					id,
					floor,   //²ã  
					zu,  //×é      
					"0",//±Ø¾­¾àÀë    
					"0",//ÊÇ·ñÊÇÊÒÍâ×é0²»ÊÇ£¬1ÊÇ    
					"0",//ÊÇ·ñÊDZؾ­×é0²»ÊÇ£¬1ÊÇ    
					"2",//Ëã·¨µÄά¶È0,1,2,3    
					"TOF",//ĬÈÏTOF    
					"-1",//×é¿ç¶à²ã    
					"Ñ¡ÔñÇøÓò",//ÓÐЧÇøÓò    
					"0"//×é¿í¶È
					);
		}
	}

	/**Ìí¼Ó²ã×éÊôÐÔ½øÈ뼯ºÏ*/
	public static void addvc(
			Tb_cengzu suanfa,
			String bi_jing_ju_li,  
			String is_shi_wai_zu,  
			String is_bi_jing_zu,  
			String suan_fa_wei_du, 
			String zu_kua_duo_ceng,
			String zu_kuang_du
			) {
		//×é¿ç¶à²ãµÄ²ã
		if(zu_kua_duo_ceng.length()>2 && !zu_kua_duo_ceng.equals("×éÎÞ¿ç²ã")) {
			zkdc_vector.add(suanfa);
		}

		//ÊÇ·ñÊÇÊÇÊÒÍâ×é
		if(is_shi_wai_zu.equals("1")) {
			outzu_vector.add(suanfa);
		}

		//±Ø¾­×é
		if(!is_bi_jing_zu.equals("0")) {
			bjz_vector.add(suanfa);
		}

		//ºÏ·¨µÄ¿í¶ÈÔ¼ÊøËã·¨·ÅÈ뼯ºÏ
		if(JugeNumber.isDigit(zu_kuang_du) && zu_kuang_du.length()>2) {
			zkdys_vector.add(suanfa);
		}

		//Èç¹ûË㷨ά¶ÈÊÇ1ά
		if(suan_fa_wei_du.equals("1")){
			line_vector.add(suanfa);
		}
	}

	public static Vector<Tb_cengzu> getCengzuvc() {
		return cengzuvc;
	}

	public static void setCengzuvc(Vector<Tb_cengzu> cengzuvc) {
		Dell_tbcengzu.cengzuvc = cengzuvc;
	}

	public static Vector<Tb_cengzu> getZkdc_vector() {
		return zkdc_vector;
	}

	public static void setZkdc_vector(Vector<Tb_cengzu> zkdc_vector) {
		Dell_tbcengzu.zkdc_vector = zkdc_vector;
	}

	public static Vector<Tb_cengzu> getOutzu_vector() {
		return outzu_vector;
	}

	public static void setOutzu_vector(Vector<Tb_cengzu> outzu_vector) {
		Dell_tbcengzu.outzu_vector = outzu_vector;
	}

	public static Vector<Tb_cengzu> getBjz_vector() {
		return bjz_vector;
	}

	public static void setBjz_vector(Vector<Tb_cengzu> bjz_vector) {
		Dell_tbcengzu.bjz_vector = bjz_vector;
	}

	public static Vector<Tb_cengzu> getZkdys_vector() {
		return zkdys_vector;
	}

	public static void setZkdys_vector(Vector<Tb_cengzu> zkdys_vector) {
		Dell_tbcengzu.zkdys_vector = zkdys_vector;
	}

	public static Vector<Tb_cengzu> getLine_vector() {
		return line_vector;
	}

	public static void setLine_vector(Vector<Tb_cengzu> line_vector) {
		Dell_tbcengzu.line_vector = line_vector;
	}

	/**»ñÈ¡²ã×éµÄµÄËã·¨*/
	public static int[] weidu(int ceng,int[] zu) {
		String floor=String.valueOf(ceng);
		int size=zu.length;
		int[] weidu=new int[size];
		if(size==1) {
			String zustr=String.valueOf(zu[0]);	
			Tb_cengzu a=get_tbcengzu(floor, zustr);
			if(a!=null) {
				String sf=a.getSuan_fa_wei_du();			
				weidu[0]=Integer.parseInt(sf);
			}
		}else {
			for(int i=0;i<size;i++) {
				String zustr=String.valueOf(zu[i]);
				String sf=get_tbcengzu(floor,zustr).getSuan_fa_wei_du();
				weidu[i]=Integer.parseInt(sf);
			}
		}
		return weidu;
	}
	/**»ñÈ¡×é*/
	public static String[] getzu(){
		String[] zu=new String[100];
		for(int i=0;i<100;i++) {
			zu[i]=String.valueOf(i);
		}
		return zu;		
	}
	
	/**»ñÈ¡²ã*/
	public static String[] getceng() {
		int size=cengvc.size();
		String[] ceng=new String[size];
		for(int i=0;i<size;i++) {
			ceng[i]=cengvc.get(i);
		}
		return ceng;
	}



	public static Vector<String> getCengvc() {
		return cengvc;
	}



	public static void setCengvc(Vector<String> cengvc) {
		Dell_tbcengzu.cengvc = cengvc;
	}
}