运维管理系统

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
package engbs;
import DataBase.DatabaseManagement;
import Method.GetNowTime;
import PbuliClass.ShowMessage;
import PbuliClass.Systems;
import anchor.Anchor_Dell;
import anchor.Anchor_nerby_dell;
import tbDataModel_Dell.Dell_TongbuAnchor;
import tbDataModel_Dell.Dell_tbcengzu;
 
/**ÐÂÔöÒ»¸ö»ùÕ¾
 * BSTOCS1£¬ADDANC,¡¾»ùÕ¾id¡¿,¡¾X×ø±ê¡¿,¡¾Y×ø±ê¡¿,¡¾Z×ø±ê¡¿,¡¾ËùÔڲ㡿,¡¾ËùÔÚ×é¡¿£¬¡¾»ùÕ¾Á¿³Ì¡¿£¬¡¾»ùÕ¾µØÖ·¡¿£¬¡¾END¡¿
 * ¡¾X×ø±ê¡¿¸ù¾Ýʵ¼ÊÌîд£¬²»ÄÜΪ¿Õ£¬±ØÐëÊÇÊý×Ö
 * ¡¾Y×ø±ê¡¿¸ù¾Ýʵ¼ÊÌîд£¬²»ÄÜΪ¿Õ£¬±ØÐëÊÇÊý×Ö
 * ¡¾Z×ø±ê¡¿¸ù¾Ýʵ¼ÊÌîд£¬²»ÄÜΪ¿Õ£¬±ØÐëÊÇÊý×Ö
 * ¡¾ËùÔڲ㡿¸ù¾Ýʵ¼ÊÌîд£¬²»ÄÜΪ¿Õ£¬±ØÐëÊÇÊý×Ö£¬Ä¬ÈÏΪ0
 * ¡¾ËùÔÚ×é¡¿¸ù¾Ýʵ¼ÊÌîд£¬²»ÄÜΪ¿Õ£¬±ØÐëÊÇÊý×Ö
 * ¡¾»ùÕ¾Á¿³Ì¡¿Ä¬ÈÏΪ100000
 * ¡¾»ùÕ¾µØÖ·¡¿
 * ¡¾END¡¿½áÊø±ê־λ 
 * ÐÞ¸Äij¸ö»ùÕ¾
 * BSTOCS1£¬ALTERANC,¡¾»ùÕ¾id¡¿,¡¾X×ø±ê¡¿,¡¾Y×ø±ê¡¿,¡¾Z×ø±ê¡¿,¡¾ËùÔڲ㡿,¡¾ËùÔÚ×é¡¿£¬¡¾»ùÕ¾Á¿³Ì¡¿£¬¡¾»ùÕ¾µØÖ·¡¿£¬¡¾END¡¿
 * É¾³ýij¸ö»ùÕ¾
 * BSTOCS1£¬DELETEANC,¡¾»ùÕ¾id¡¿,¡¾END¡¿
 * É¾³ýËùÓлùÕ¾
 * BSTOCS1£¬DELETEALLANC,¡¾END¡¿
 **/
public class Bs_dell_anchor {
    static int baoliu9=0;
    
    /**ÐÂÔöÒ»¸ö»ùÕ¾*/
    public static void ADDANC(String[] a) {
        String anchorid=a[2];
        String x=a[3];
        String y=a[4];
        String z=a[5];
        String floor=a[6];
        String zu=a[7];
        String distance=a[8];
        String ip=a[9];
        if (Systems.isWuxian()){
            String wxdisTance=a[10];
            baoliu9 = Integer.parseInt(wxdisTance);
        }
        Anchor_Dell.set_anchor(anchorid,x,y,z,floor, zu,distance,ip,"1","0");        
        Dell_tbcengzu.add_cengzu_form_addanchor(floor, zu);//Ìí¼Ó²ã×é¶ÔÏó;//Ìí¼ÓËã·¨        
        Anchor_nerby_dell.add_anchorby(anchorid,"","","","","","","","","","","0");//ÐÂÔöÁÙ½ü»ùÕ¾ÐÅÏ¢        
        Dell_TongbuAnchor.add_one_rootanchor(anchorid, "", "0", "");//ÐÂÔöͬ²½»ùÕ¾        
        String[]  ziduan= {"anchorid","POSX","POSY","POSZ","layer","zu",
                "liangcheng","anchormode","anchorip","GreateTime"};
        String[] zhi= {anchorid,x,y,z,floor,zu,
                distance,"1",ip,GetNowTime.now()};
        DatabaseManagement.insertfast("tb_achor", ziduan, zhi);
        ShowMessage.zidingyi(GetNowTime.now()+"ÐÂÔö»ùÕ¾³É¹¦"+anchorid);
        
    }
    
    /**Ð޸ĻùÕ¾*/
    public static void ALTERANC(String[] a) {
        
        String anchorid=a[2];
        String x=a[3];
        String y=a[4];
        String z=a[5];
        String floor=a[6];
        String zu=a[7];
        String distance=a[8];
        String ip=a[9];
        Anchor_Dell.set_anchor_xyzfip(anchorid,x,y, z,floor,ip,zu,distance,"0");
        String[] ziduan= {"POSX","POSY","POSZ","layer","zu","liangcheng","anchorip","anchorid"};
        String[] zhi= {x,y,z,floor,zu,distance,ip,anchorid};
        DatabaseManagement.fast_alert_dbase("tb_achor", ziduan, zhi);
        ShowMessage.zidingyi(GetNowTime.now()+"Ð޸ĻùÕ¾³É¹¦"+anchorid);
        
    }
    
    /**ɾ³ý»ùÕ¾*/
    public static void DELETEANC(String[] a) {
        String anchorid=a[2];
        Anchor_Dell.remov_anchor(anchorid);
        String deleteSql="DELETE FROM tb_achor WHERE anchorid='"+anchorid+"'";                            
        DatabaseManagement.update(deleteSql);
        ShowMessage.zidingyi(GetNowTime.now()+"ɾ³ý»ùÕ¾³É¹¦"+anchorid);
        
    }
    
    /**ɾ³ýËùÓлùÕ¾*/
    public static void DELETEALLANC() {        
        Anchor_Dell.removall_anchor();
        String deleteSql="TRUNCATE TABLE tb_achor";
        DatabaseManagement.update(deleteSql);
        ShowMessage.zidingyi(GetNowTime.now()+"ɾ³ýËùÓлùÕ¾³É¹¦");
    }
 
}