package yunwei;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import DataBase.DatabaseManagement;
import Method.GetNowTime;
import home.Open_soft_dialog;

public class dell_shebei_manege {	
	static Vector<Tb_shebei_manege> shebeivc = new Vector<Tb_shebei_manege>();
	/** »ñÈ¡Êý¾Ý¿âÖÐËùÓбêÇ© */
	static {
		Open_soft_dialog.addara("¼ÓÔØtb_shebei_manege");
		String sql = "select * from tb_shebei_manege order by id ASC ";
		@SuppressWarnings("rawtypes")
		Iterator iterator = DatabaseManagement.serch(sql).iterator();
		while (iterator.hasNext()) {// µü´úÆ÷´æÔÚÔªËØ
			@SuppressWarnings("rawtypes")
			List info = (List) iterator.next();// ½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
			String id=(String)info.get(0);
			String name=(String)info.get(1);    
			String icid=(String)info.get(2);    
			String macid=(String)info.get(3);   
			String ip=(String)info.get(4);  
			String version=(String)info.get(5);
			String addtime=(String)info.get(6);
			Tb_shebei_manege tbshebei=new Tb_shebei_manege();
			tbshebei.setId(id);
			tbshebei.setName(name);
			tbshebei.setIcid(icid);
			tbshebei.setMacid(macid);
			tbshebei.setIp(ip);
			tbshebei.setVersion(version);
			tbshebei.setAddtime(addtime);
			shebeivc.add(tbshebei);
		}
	}

	/** ͨ¹ý±êÇ©id»ñȡijһ¸ö±êÇ©¶ÔÏó */
	public static Tb_shebei_manege get_Tb_shebei_manege(String tagid) {
		Tb_shebei_manege engm = null;
		if (shebeivc.size() != 0) {
			Iterator<Tb_shebei_manege> it = shebeivc.iterator();
			while (it.hasNext()) {
				Tb_shebei_manege engm1 = it.next();
				String macid1 = engm1.getMacid();
				if (macid1.equals(tagid)) {
					engm= engm1;
					break;
				}
			}
		}
		return engm;
	}

	/**¸üÐÂÊý¾Ý*/
	public static void alert_shebei(String tagid,String ip,String macid,String icid,String version) {
		Tb_shebei_manege tbtag=get_Tb_shebei_manege(tagid);
		String addtime=GetNowTime.now();
		if(tbtag !=null) {
			tbtag.setAddtime(addtime);
			tbtag.setIp(ip);
			tbtag.setMacid(macid);
			tbtag.setIcid(icid);
			String[] ziduan = {"icid","macid","ip","addtime","tbshebei","version","tagid" };
			String[] zhi = {icid,macid,ip,addtime, version,tagid };
			DatabaseManagement.fast_alert_dbase("tb_shebei_manege", ziduan, zhi);
		}else {
			tbtag=new Tb_shebei_manege();	
			tbtag.setTagid(tagid);
			tbtag.setMacid(macid);
			tbtag.setAddtime(addtime);
			tbtag.setIp(ip);
			tbtag.setIcid(icid);
			String[] ziduan = {"icid","macid","ip","addtime", "version","tagid" };
			String[] zhi = {icid,macid,ip,addtime, version,tagid };
			DatabaseManagement.insertfast("tb_shebei_manege", ziduan, zhi);
		}		
	}

	//$equipment,tagid,¿¨ºÅ,°æ±¾ºÅ,µçÄÔÐòÁкÅ,end
	public static void dell_message(String message,String ip) {
		String a[]=message.split(",");
		String tagid=a[1];
		String icid=a[2];
		String version=a[2];
		String macid=a[4];
		alert_shebei(tagid,ip,macid,icid,version);
	}
}