运维管理系统

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
105
106
107
108
109
110
111
112
113
package Method;
import DataBase.DatabaseManagement;
import tbDataModel.TbRealInWarning;
import tbDataModel_Dell.Tb_Warnig_Dell;
 
/**¸ÃÀàÓÃÓÚ½«Êý¾Ý²åÈëÊý¾Ý¿â*/
public class InsertData  {
 
 
    public static void insertTagStatus(String type,String id,String time) {
        String update="UPDATE tb_tag SET status='"+type+"',addtime='"+time+"' where tag_id='"+id+"'";
        DatabaseManagement.update(update);// ¸üÐÂÊý¾Ý¿â
 
    }
 
    
 
    /**½«±êÇ©ÀëÏß״̬²åÈëʵʱλÖÃÊý¾Ý¿âÖÐ*/
    public static void tagOffIsertData(String tagid) {
        String life="ÀëÏß";
        String update="UPDATE tb_realpositoin SET life='"+life+"' where tagid='"+tagid+"'";
        DatabaseManagement.update(update);// ¸üÐÂÊý¾Ý¿â    
 
    }
 
    /**sosÊý¾Ý»òÕß½øÈë¸æ¾¯ÇøÓòÊý¾Ý²åÈë¸æ¾¯Êý¾Ý¿â*/
    public static void sosInsertTbWarning(String taid,String type,String status,String beizhu) {        
        String time=GetNowTime.now();
        String[] ziduan = {"type", "objectid", "status", "time", "baoliu1" };
        String[] zhi = { type,taid,status,time,beizhu};
        DatabaseManagement.insertfast("tb_warning", ziduan, zhi);
        Tb_Warnig_Dell.add_tb_warning(type, taid,status,time);        
    }
 
 
    /**µÍµçÁ¿Êý¾Ý*/
    public static void porInsertTbWarning(String taid, String status, String power) {
        String time = GetNowTime.now();
        String type = "µÍµçÁ¿";
        String pwr = "µ±Ç°µçÁ¿"+power+"%";
        String[] ziduan = {"type", "status", "time", "baoliu1","objectid"};
        String[] zhi = {type, status, time, pwr, taid};
        if (Tb_Warnig_Dell.get_tbwarning(taid)!=null){
            Tb_Warnig_Dell.get_tbwarning(taid).setStatus("δ´¦Àí");
            String sqlpwr="UPDATE tb_warning SET STATUS='δ´¦Àí',baoliu1='F"+pwr+"' WHERE objectid='"+taid+"' AND `type`='µÍµçÁ¿' AND `status`='δ´¦Àí';";
            DatabaseManagement.update(sqlpwr);
        } else {
            DatabaseManagement.insertfast("tb_warning", ziduan, zhi);
            Tb_Warnig_Dell.add_tb_warning("µÍµçÁ¿", taid, "δ´¦Àí",pwr);
        }
    }
 
    /**SOS¸æ¾¯²åÈëÊý¾Ý¿â*/
    /**sosÊý¾Ý»òÕß½øÈë¸æ¾¯ÇøÓòÊý¾Ý²åÈë¸æ¾¯Êý¾Ý¿â*/
    public static void sosin_tbwarnig(String taid,String beizhu) {        
        String time=GetNowTime.now();
        String[] ziduan = {"type", "objectid", "status", "time", "baoliu1" };
        String[] zhi = {"SOS",taid,"δ´¦Àí",time,beizhu};
        DatabaseManagement.insertfast("tb_warning", ziduan, zhi);
    }
    
    /**Ð޸ıêÇ©±»²ð³ýÊý¾Ý²åÈëÊý¾Ý¿â*/
    public static void tagoff_into_data(String taid) {
        String[] ziduan = {"baoliu6", "p_tagid" };
        String[] zhi = {"1",taid};
        DatabaseManagement.fast_alert_dbase("tb_person", ziduan, zhi);
    }
    
 
    /**Ð޸ĸ澯Êý¾Ý¿â*/
    public static void alertSosTbWaring() {
        String updateSQL="UPDATE tb_warning SET  status='ÒÑ´¦Àí' ";    
        DatabaseManagement.update(updateSQL);// ´¦Àí¸æ¾¯ÐÅÏ¢ÐÅÏ¢    
    }
 
    /**ɾ³ýijÊý¾Ý¿âÖеÄÊý¾Ý*/
    public static void deletetData(String dataName,String id) {
        String deleteSql="DELETE FROM "+dataName+" WHERE id='"+id+"'";
        DatabaseManagement.update(deleteSql);// É¾³ý±êÇ©ÐÅÏ¢        
    }
 
    /**ɾ³ýÊý¾Ý¿âÖеÄËùÓÐÄÚÈÝ*/
    public static int delteAllData(String dataName) {
        String deleteSql="TRUNCATE TABLE"+dataName+"";
        int a=DatabaseManagement.update(deleteSql);// É¾³ýËùÓмǼ
        return a;
    }
 
 
    /**¸æ¾¯Êý¾Ý²åÈëÊý¾Ý¿â*/
    public static void into_database(String type,String area,String name,String bumen,String tagid,String intime,String outtime,String alltime) {
        String[] ziduan = {"area","name","bumen","tagid","intime","outtime","alltime"};
        String[] zhi = {area,name,bumen,tagid,intime,outtime,alltime};
 
        String[] ziduan2 = {"area","name","bumen","tagid","intime"};
        String[] zhi2 = {area,name,bumen,tagid,intime};
 
        DatabaseManagement.insertfast("tb_historyinwarning", ziduan, zhi);
        DatabaseManagement.insertfast("tb_realinwarning", ziduan2, zhi2);
        InsertData.sosInsertTbWarning(tagid,type, "δ´¦Àí",area);
    }
 
    /**¸üи澯Êý¾Ý¿â*/
    public static void intb_history_database(TbRealInWarning tbwn,String area,String in,String intime,String alltime) {        
        String name=tbwn.getName();
        String bumen=tbwn.getBumen();
        String tagid=tbwn.getTagid();
        String[] ziduan = {"area","name","bumen","tagid","intime","outtime","alltime"};
        String[] zhi = {area,name,bumen,tagid,in,intime,alltime};
        DatabaseManagement.insertfast("tb_historyinwarning", ziduan, zhi);    
    }
 
}