package engbs;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import DataBase.DatabaseManagement;
import Method.GetNowTime;
import person.Person;
import person.person_Dell;
import tbDataModel_Dell.Department;
import tbDataModel_Dell.Department_Dell;
@SuppressWarnings("rawtypes")
public class Dell_gongzhong {

	public static Vector<tb_gongzhong> gzv=new Vector<tb_gongzhong>();
	static  {
		Iterator iterator = DatabaseManagement.get_alldate_indatabase("tb_gongzhong").iterator();
		while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
			List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
			tb_gongzhong gz=new tb_gongzhong();
			gz.setBumen((String)info.get(1));
			gz.setNum((String)info.get(2));
			gz.setAddtime((String)info.get(3));
			gzv.add(gz);
		}
	}

	/**ͨ¹ýÃû³ÆÕÒµ½Ä³¸ö¹¤ÖÖ¶ÔÏó*/
	public static tb_gongzhong get_gz(String name) {
		tb_gongzhong tbgz=null;
		int size=gzv.size();
		for(int i=0;i<size;i++) {
			tb_gongzhong  tbgz1=gzv.get(i);
			String name1=tbgz1.getBumen();
			if(name.equals(name1)) {
				tbgz=tbgz1;
				break;
			}
		}
		return tbgz;		
	}

	/**Ð޸IJ¿ÃÅÈËÊý*/
	public static void alert_num(String name,String num) {
		if(get_gz( name) !=null) {
			get_gz( name).setNum(num);
			String[]  ziduan= {"num","addtime","bumen"};
			String[] zhi= {num,GetNowTime.now(),name};
			DatabaseManagement.fast_alert_dbase("tb_gongzhong", ziduan, zhi);
		}
	}

	/**ɾ³ýij¸ö²¿ÃÅ*/
	public static void delete_bumen(String name) {
		if(get_gz( name) !=null) {
			gzv.remove(get_gz( name));
			String deleteSql="DELETE FROM tb_gongzhong WHERE bumen='"+name+"'";
			DatabaseManagement.update(deleteSql);
		}
	}

	/**ÐÂÔöÒ»¸ö²¿ÃÅ*/
	public static void add_bumen(String name,String num) {

		if(get_gz( name) !=null) {
			return;
		}
		tb_gongzhong gz=new tb_gongzhong();
		gz.setBumen(name);
		gz.setNum(num);
		gz.setAddtime(GetNowTime.now());
		gzv.add(gz);		
		String[]  ziduan= {"bumen","num","addtime"};
		String[] zhi= {name,num,GetNowTime.now()};
		DatabaseManagement.insertfast("tb_gongzhong", ziduan, zhi);
	}

	/**ɾ³ýÈ«²¿²¿ÃÅ*/
	public static void delete_all_bumen() {
		gzv.removeAllElements();
		String deleteSql="TRUNCATE TABLE tb_gongzhong";
		DatabaseManagement.update(deleteSql);
	}

	/**ÐÞ¸Äͳ¼ÆÊý¾ÝÖеÄnum*/
	public static void alert_num() {
		int size=Department_Dell.getDepartment_vector().size();
		for(int i=0;i<size;i++) {
			Department dp=Department_Dell.getDepartment_vector().get(i);
			String name=dp.getDepart_name();
			int num=0;
			int size1=person_Dell.getPerson_vector().size();
			for(int j=0;j<size1;j++) {
				Person prs=person_Dell.getPerson_vector().get(j);
				String bumen=prs.getP_department();
				String online=prs.getP_online();
				if(name.equals(bumen) && online.equals("1")) {
					num=num+1;
				}				
			}
			alert_num(name,String.valueOf(num));
		}
	}

}