package tbDataModel_Dell;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import javax.swing.ImageIcon;
import DataBase.DatabaseManagement;
import Method.GetNowTime;
import PbuliClass.ShowMessage;
import home.Open_soft_dialog;
import tbDataModel.Tbicon;

@SuppressWarnings("rawtypes")
public class Dell_Tbicon {
	static Vector<Tbicon > tbicon_vector;//»ùÕ¾µÄ¼¯ºÏ
	static {
		Open_soft_dialog.addara("¼ÓÔØtb_icon");
		Iterator iterator = DatabaseManagement.get_alldate_indatabase("tb_icon").iterator();
		tbicon_vector=new Vector<>();
		while (iterator.hasNext()) {
			List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
			Tbicon tbicon=new Tbicon();
			tbicon.setIcon_name((String) info.get(1));
			tbicon.setIcon_adress((String) info.get(2));
			tbicon.setAdd_time((String) info.get(3));
			tbicon.setBeizhu((String) info.get(4));
			tbicon.setIcon(new ImageIcon((String)info.get(2)));
			tbicon_vector.add(tbicon);
		}
	}

	/**¸ù¾Ýͼ±êÃû³Æ»ñȡͼ±ê¶ÔÏó*/
	public static  Tbicon get_icon(String icobName) {
		Tbicon tbicon=null;
		if(tbicon_vector.size() !=0) {
			Iterator<Tbicon> it=tbicon_vector.iterator();
			while(it.hasNext()) {
				Tbicon tbicon1=it.next();
				String icobName1=tbicon1.getIcon_name();
				if(icobName1.equals(icobName) ) {
					tbicon=tbicon1;
					break;
				}
			}
		}
		return tbicon;
	}

	/**Ïò¼¯ºÏÌí¼ÓÒ»¸öͼ±ê¶ÔÏó*/
	public static void add_tbicon(String name,String adress) {
		if(get_icon(name)==null) {			
			String sql="INSERT tb_icon (icon_name,icon_adress,add_time) VALUES "
					+ "('"
					+name+"','"
					+adress+"','"
					+GetNowTime.now()+"')";

			//Ìí¼Ó³É¹¦ÌáʾÐÅÏ¢		
			if(DatabaseManagement.update(sql) !=0){			
				Tbicon tbicon=new Tbicon();
				tbicon.setIcon_name(name);
				tbicon.setIcon_adress(adress);
				tbicon.setAdd_time(GetNowTime.now());
				tbicon.setIcon(new ImageIcon(adress));
				tbicon_vector.add(tbicon);
				ShowMessage.zidingyi("Ìí¼Óͼ±ê"+name+"³É¹¦£¡");
			}
		}else {
			ShowMessage.zidingyi("ͼ±ê"+name+"ÒѾ­´æÔÚ²»ÄÜÖظ´Ìí¼Ó£¡");
		}
	}

	/**ɾ³ýij¸öͼ±ê¶ÔÏó*/
	public static void delete_tbicon(String name) {
		if(get_icon(name) !=null) {			
			String deleteSql="DELETE FROM tb_icon WHERE icon_name='"+
					name+"'";
			if(DatabaseManagement.update(deleteSql) !=0) {
				tbicon_vector.remove(get_icon(name));
			}
		}
	}

	/**ÐÞ¸Äij¸öͼ±ê¶ÔÏó*/
	public static void alert_tbicon(String name,String adress,String addtime) {
		if(get_icon(name) !=null) {	

			String sql="UPDATE tb_icon SET icon_adress='"+adress
					+"'where icon_name='"+name+"'";	
			if(DatabaseManagement.update(sql)!=0) {
				get_icon(name).setIcon_adress(adress);
				get_icon(name).setAdd_time(GetNowTime.now());
				get_icon(name).setIcon(new ImageIcon(adress));
			}
		}
	}

	/**ɾ³ýËùÓеÄͼ±ê¶ÔÏó*/
	public static void delete_all_tbicon() {
		if(tbicon_vector.size() !=0) {
			tbicon_vector.removeAllElements();
		}
	}

	/**»ñÈ¡ËùÓÐͼ±êÃû³ÆµÄ¼¯ºÏ*/
	public static String[] icon_name() {
		int size=tbicon_vector.size();
		String[] iconname=new String[size];
		if(size !=0) {
			for(int i=0;i<size;i++) {
				iconname[i]=tbicon_vector.get(i).getIcon_name();
			}
		}
		return iconname;
	}

	public static Vector<Tbicon> getTbicon_vector() {
		return tbicon_vector;
	}


}