运维管理系统

zsh_root

2024-01-02 7b595546af704983dbafcd0d385c8768ddacefc2

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
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));
        }
    }
 
}