package PbuliClass;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;

import DataBase.DatabaseManagement;
import Method.GetNowTime;
import tbDataModel.TbGas;

/**»ñÈ¡ËùÓеĴ«¸ÐÆ÷¶ÔÏó*/
@SuppressWarnings("rawtypes")
public class Get_Tb_Gass {
	
	static Vector<TbGas>  TbGass=new Vector<>();//ËùÓеIJɼ¯ÒǶÔÏó
	//³õʼ»¯
	static {
		Iterator iterator = DatabaseManagement.get_alldate_indatabase("tb_gas").iterator();
		while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
			List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
			TbGas gas=new TbGas();
			gas.setId(Integer.parseInt((String)info.get(0)));
			gas.setWei_zhi((String)info.get(1));//²É¼¯ÒǵݲװλÖÃ
			gas.setGas_type((String)info.get(2));//´«¸ÐÆ÷µÄÖÖÀà
			gas.setNong_du((String)info.get(3));//Ũ¶ÈÖµ
			gas.setStatus((String)info.get(4));//¸æ¾¯(״̬)
			gas.setCollect_ip((String)info.get(5));//´«¸ÐÆ÷ËùÔڵIJɼ¯ÒǵÄÖ÷»úID
			gas.setTong_dao((String)info.get(6));//´«¸ÐÆ÷ËùÔڵIJɼ¯ÒÇͨµÀ
			gas.setWaring_zhi((String)info.get(7));//´«¸ÐÆ÷µÄ±¨¾¯Öµ
			gas.setIp((String)info.get(8));//´«¸ÐÆ÷ËùÔÚÖ÷»úµÄ´®¿ÚµÄIP
			gas.setX((String)info.get(9));//´«¸ÐÆ÷°²×°µÄX×ø±ê
			gas.setY((String)info.get(10));//´«¸ÐÆ÷°²×°µÄY×ø±ê	
			gas.setAddtime((String)info.get(11));//Êý¾Ý¸üеÄʱ¼ä
			TbGass.add(gas);
		}
	}
	
	/**»ñÈ¡ËùÓеÄÆøÌå´«¸ÐÆ÷¶ÔÏó*/
	public static Vector<TbGas>  get_gass(){
		return TbGass;
	}
	
	/**ͨ¹ýIDÕÒµ½Ä³¸öÆøÌå´«¸ÐÆ÷¶ÔÏó*/
	public static TbGas get_gas(String id) {
		TbGas gas=null;
		if(TbGass.size() !=0) {
			Iterator<TbGas> it=TbGass.iterator();
			while (it.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ	
				TbGas gas1 = it.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
				String id1=String.valueOf(gas1.getId());
				if(id1.equals(id)) {
					gas=gas1;		
					break;
				}
			}
		}			
		return gas;	
	}
	
	/**»ñȡij¸ö°²×°Î»ÖõÄËùÓд«¸ÐÆ÷¶ÔÏó*/
	public static Vector<TbGas> get_mou_weizhi_tbgas(String name) {
		Vector<TbGas> mou_tbgas=new Vector<>();
		if(TbGass.size() !=0) {
			Iterator<TbGas> it=TbGass.iterator();
			while (it.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ	
				TbGas gas = it.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
				String weizhi=gas.getWei_zhi();
				if(weizhi.equals(name)) {
					mou_tbgas.add(gas);
				}
			}
		}
		return mou_tbgas;		
	}
	
	
	/**ͨ¹ý´«¸ÐÆ÷µÄ²É¼¯ÒÇipºÍËùÔÚͨµÀ»ñÈ¡´«¸ÐÆ÷¶ÔÏó*/
	public static TbGas get_gas(String tongdao,String collect_ip) {
		TbGas gas=null;
		if(TbGass.size() !=0) {
			Iterator<TbGas> it=TbGass.iterator();
			while (it.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ	
				TbGas gas1 = it.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
				String tongdao2=gas1.getTong_dao();
				String collect_ip1=gas1.getIp();
				if(tongdao2.equals(tongdao)&& collect_ip1.equals(collect_ip)) {
					gas=gas1;		
					break;
				}
			}
		}			
		return gas;	
	}
	
	
	/**»ñȡij¸ö²É¼¯ÒÇËùÕ¼ÓõÄͨµÀÊýÒâ˼¾ÍÊÇ°²×°Á˼¸¸öÆøÌå´«¸ÐÆ÷*/
	public static int get_gasnum(int id) {
		int gasnum=0;
		if(TbGass.size() !=0) {
			Iterator<TbGas> it=TbGass.iterator();
			while (it.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ	
				TbGas gas1 = it.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
				int ip=Integer.parseInt(gas1.getCollect_ip());
				if(ip==id) {
					gasnum++;
				}
			}
		}
		return gasnum;		
		
	}
	
	
	
	
	
	/**ɾ³ýijһ¸öÆøÌå´«¸ÐÆ÷¶ÔÏó*/
	public static void delete_gas(String tongdao,String collect_ip) {
		if( !TbGass.isEmpty()) {
			TbGass.remove(get_gas(tongdao,collect_ip));
		}
	}
	
	
	/**ͨ¹ýIDɾ³ýijһ¸öÆøÌå´«¸ÐÆ÷¶ÔÏó*/
	public static void delete_gas(String id) {
		if( !TbGass.isEmpty()) {
			TbGass.remove(get_gas(id));
		}
	}
	
	/**ɾ³ýËùÓеĴ«¸ÐÆ÷¶ÔÏó*/
	public static void deleteall_gas() {
		if( !TbGass.isEmpty()) {
			TbGass.removeAll(TbGass);
		}
	}
	
	/**ÐÂÔö´«¸ÐÆ÷¶ÔÏó*/
	public static void add_gas(String id,String tongdao,String collect_ip,String gas_type,String ip,String x,String y,String warning_zhi) {
		TbGas newgas=new TbGas();
		newgas.setId(Integer.parseInt(id));
		newgas.setTong_dao(tongdao);//´«¸ÐÆ÷ËùÔڵIJɼ¯ÒÇͨµÀ
		newgas.setCollect_ip(collect_ip);//´«¸ÐÆ÷ËùÔڵIJɼ¯ÒǵÄÖ÷»úID
		newgas.setGas_type(gas_type);//´«¸ÐÆ÷µÄÖÖÀà
		newgas.setIp(ip);//´«¸ÐÆ÷ËùÔÚÖ÷»úµÄ´®¿ÚµÄIP
		newgas.setX(x);//´«¸ÐÆ÷°²×°µÄX×ø±ê
		newgas.setY(y);//´«¸ÐÆ÷°²×°µÄY×ø±ê
		newgas.setWaring_zhi(warning_zhi);//´«¸ÐÆ÷µÄ±¨¾¯Öµ
		TbGass.add(newgas);
	}
	
	/**Ð޸Ĵ«¸ÐÆ÷¶ÔÏó*/
	public static void alert_gas(String tongdao,String collect_ip,String gas_type,String ip,String x,String y,String warning_zhi) {	
		if(get_gas(tongdao,collect_ip) !=null) {
			get_gas(tongdao,collect_ip).setTong_dao(tongdao);//´«¸ÐÆ÷ËùÔڵIJɼ¯ÒÇͨµÀ
			get_gas(tongdao,collect_ip).setCollect_ip(collect_ip);//´«¸ÐÆ÷ËùÔڵIJɼ¯ÒǵÄÖ÷»úID
			get_gas(tongdao,collect_ip).setGas_type(gas_type);//´«¸ÐÆ÷µÄÖÖÀà
			get_gas(tongdao,collect_ip).setIp(ip);//´«¸ÐÆ÷ËùÔÚÖ÷»úµÄ´®¿ÚµÄIP
			get_gas(tongdao,collect_ip).setX(x);//´«¸ÐÆ÷°²×°µÄX×ø±ê
			get_gas(tongdao,collect_ip).setY(y);//´«¸ÐÆ÷°²×°µÄY×ø±ê
			get_gas(tongdao,collect_ip).setWaring_zhi(warning_zhi);//´«¸ÐÆ÷µÄ±¨¾¯Öµ			
		}
	}
	
	
	/**Ð޸Ĵ«¸ÐÆ÷µÄ״̬*/
	public static void alert_gas_status(String id,String status) {
		
		if(get_gas(id)!=null) {
			get_gas(id).setStatus(status);
			get_gas(id).setAddtime(GetNowTime.gethm());
		}
		
	}
	
	
	/**Ð޸Ĵ«¸ÐÆ÷¶ÔÏóºÍÊý¾Ý¿â*/
	public static boolean alert_gasc(String id,String tong_dao,String collect_ip,String gas_type,String x,String y,String warning_zhi) {
		boolean alert=false;
		if(get_gas(id) !=null) {
			get_gas(id).setTong_dao(tong_dao);//´«¸ÐÆ÷ËùÔڵIJɼ¯ÒÇͨµÀ
			get_gas(id).setCollect_ip(collect_ip);//´«¸ÐÆ÷ËùÔڵIJɼ¯ÒǵÄÖ÷»úID
			get_gas(id).setGas_type(gas_type);//´«¸ÐÆ÷µÄÖÖÀà
			get_gas(id).setX(x);//´«¸ÐÆ÷°²×°µÄX×ø±ê
			get_gas(id).setY(y);//´«¸ÐÆ÷°²×°µÄY×ø±ê
			get_gas(id).setWaring_zhi(warning_zhi);//´«¸ÐÆ÷µÄ±¨¾¯Öµ	
			StringBuilder updateSQL=new StringBuilder("UPDATE tb_gas SET tong_dao='"
					+tong_dao+"' , collect_ip='"+collect_ip+"' , gas_type='"+gas_type+"' , x='"
					+x+"' , y='"+y+"' , waring_zhi='"+warning_zhi+"' where id='"+id+"'");
			if(DatabaseManagement.update(updateSQL.toString())==1) {
				alert=true;
			};
		}
		return alert;
	}
	
	
	/**ÐÞ¸ÄijÆøÌå´«¸ÐÆ÷µÄŨ¶ÈÖµ*/
	public static void alert_gas_nongdu(String id,String nong_du,String status) {
		if(get_gas(id) !=null) {
			get_gas(id).setNong_du(nong_du);
			get_gas(id).setStatus(status);
			get_gas(id).setAddtime(GetNowTime.HH_MM_SS());
		} 
	}
	
	/**ͨ¹ý´«¸ÐÆ÷µÄIDÕÒµ½Ä³¸ö´«¸ÐÆ÷*/
	public static TbGas get_tbGas(String id) {
		TbGas gas=null;
		if(TbGass.size() !=0) {
			Iterator<TbGas> it=TbGass.iterator();
			while (it.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ	
				TbGas gas1 = it.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
				String id1=String.valueOf(gas1.getId());
				if(id1.equals(id)) {
					gas=gas1;		
					break;
				}
			}
		}			
		return gas;	
	}
	
	
	/**Ð޸Ĵ«¸ÐÆ÷IPµØÖ·*/
	public static void alert_ip(String ip,String caijiyi_ip,String wei_zhi) {
		if(TbGass.size() !=0) {
			Iterator<TbGas> it=TbGass.iterator();
			while (it.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ	
				TbGas tbgas=it.next();
				if(tbgas.getCollect_ip().equals(caijiyi_ip)) {
					tbgas.setIp(ip);//Ð޸ļ¯ºÏÖвɼ¯ÒÇIPÏàͬµÄÆøÌå´«¸ÐÆ÷IPµØÖ·
					StringBuilder updateSQL=new StringBuilder("UPDATE tb_gas SET ip='"
							+ip+"',wei_zhi='"+wei_zhi+"' where collect_ip='"+caijiyi_ip+"'");
					DatabaseManagement.update(updateSQL.toString());
				}
			}
		}
	}
	

}