package fence.kaoqing;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import DataBase.DatabaseManagement;
import PbuliClass.ShowMessage;
@SuppressWarnings("rawtypes")
public class Dell_tbreallkaoqing {
	static Vector<tb_reallkaoqing>  vc_realkq=new Vector<tb_reallkaoqing>();

	
	static {		
		Iterator iterator =DatabaseManagement.table_base("tb_realkaoqing","ASC","tagid").iterator();
		while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ			
			List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
			int size=info.size();
			tb_reallkaoqing tbrk=new tb_reallkaoqing();
			tbrk.setArea((String)info.get(1));
			tbrk.setName((String)info.get(2));
			tbrk.setBumen((String)info.get(3));
			tbrk.setTagid((String)info.get(4));   
			tbrk.setIntime((String)info.get(5));  
			tbrk.setBeizhu((String)info.get(6));
			if(size>10) {
			tbrk.setJuli((String)info.get(7)); 
			//ÊÇ·ñÔÚ¿¼ÇÚÇøÓò
			tbrk.setBaoliu1((String)info.get(8));
			}else {
				ShowMessage.zidingyi_24("tb_realkaoqingÊý¾Ý±íȱÉÙ×Ö¶Î");
			}
			vc_realkq.add(tbrk);
		}
	}
	
	/**»ñÈ¡¿¼ÇÚÊý¾Ý¿âÖеÄÊý¾Ý¼¯ºÏ*/
	public static Vector<tb_reallkaoqing> getVc_realkq() {
		return vc_realkq;
	}
	
	/**»ñȡij¸ö¿¼ÇÚ¶ÔÏó*/
	public static tb_reallkaoqing  get_tbrkq(String tgid) {
		tb_reallkaoqing  tbr=null;
		return tbr;
	}
	
	/**Ïòʵʱ¿¼ÇÚÊý¾Ý¿âÌí¼ÓÒ»ÌõÊý¾Ý*/
	public static void add_in_data(String tagid) {
		String[] ziduan= {"tagid","baoliu1"};
		String[] zhi= {tagid,"1"};
		DatabaseManagement.insertfast("tb_realkaoqing", ziduan, zhi);
	}
	
	/**ɾ³ýʵʱ¿¼ÇÚÊý¾Ý±íÖеÄÒ»ÌõÊý¾Ý*/
	public static void delete_data(String tagid) {
		String deleteSql="DELETE FROM tb_realkaoqing WHERE tagid='"+tagid+"'";							
		DatabaseManagement.update(deleteSql);
	}
	
	/**ɾ³ýʵʱ¿¼ÇÚÊý¾Ý±íÖеÄËùÓÐÊý¾Ý*/
	public static void deleteall() {
		String deleteall="TRUNCATE TABLE tb_realkaoqing";					
		DatabaseManagement.update(deleteall) ;
	}
	
}