package anchor;
|
import java.awt.Image;
|
import java.util.Iterator;
|
import java.util.List;
|
import java.util.Vector;
|
import javax.swing.ImageIcon;
|
import DataBase.DatabaseManagement;
|
import Frame.Gps_Manage;
|
import Method.GetNowTime;
|
import Method.JudgeTagOrAnchorOffline;
|
import PbuliClass.Shi_jian_cha_sss;
|
import PbuliClass.ShowMessage;
|
import PbuliClass.Systems;
|
import engbs.engine_do;
|
import home.Open_soft_dialog;
|
import tbDataModel.Tb_cengzu;
|
import tbDataModel_Dell.Dell_TongbuAnchor;
|
import tbDataModel_Dell.Dell_tbcengzu;
|
|
@SuppressWarnings("rawtypes")
|
public class Anchor_Dell {
|
static Vector<Anchor> anchor_vector=new Vector<>();//»ùÕ¾µÄ¼¯ºÏ
|
static Vector<Anchor> kczcnchor_vector=new Vector<>();//¿ç²ã×é»ùÕ¾µÄ¼¯ºÏ
|
static Vector<Anchor> bjjl_vector=new Vector<>();//±Ø¾¾àÀë»ùÕ¾µÄ¼¯ºÏ
|
private static Image zaixian;// »ùվͼƬ
|
private static Image lixian;// »ùվͼƬ
|
static String on="image/anchor/anchoron.png";
|
static String off="image/anchor/anchoroff.png";
|
static Image ceju;//ÕýÔÚ²ÎÓë²â¾àµÄ»ùÕ¾
|
static Image linjin;
|
static boolean biaoji=true;
|
static double anchorh0=0;//±äµçվģʽÏ»ùÕ¾µÄ¸ß¶È¾àÀëµØÃæ³õʼ¸ß
|
static double anchorhr=0;//±äµçվģʽÏ»ùÕ¾µÄʵʱº£°Î¸ß¶È
|
static Image anchor_red=new ImageIcon("image/anchor/red.png").getImage();
|
static Image anchor_yellow=new ImageIcon("image/anchor/ceju.png").getImage();
|
static Image anchor_green=new ImageIcon("image/anchor/lingjin.png").getImage();
|
static Image anchor_off=new ImageIcon("image/anchor/anchoroff.png").getImage();
|
static Image anchor_on=new ImageIcon("image/anchor/anchoron.png").getImage();
|
static ImageIcon anchor_red1=new ImageIcon("image/anchor/red.png");
|
static ImageIcon anchor_yellow1=new ImageIcon("image/anchor/ceju.png");
|
static ImageIcon anchor_green1=new ImageIcon("image/anchor/lingjin.png");
|
static ImageIcon anchor_off1=new ImageIcon("image/anchor/anchoroff.png");
|
static ImageIcon anchor_on1=new ImageIcon("image/anchor/anchoron.png");
|
|
/**»ñÈ¡ÕýÔÚ²ÎÓë²â¾àµÄ»ùÕ¾*/
|
public static Image getCeju() {
|
ceju=new ImageIcon("image/anchor/ceju.png").getImage();
|
return ceju;
|
}
|
|
/**»ñÈ¡ÁÙ½ü»ùÕ¾*/
|
public static Image getlinjin() {
|
ceju=new ImageIcon("image/anchor/lingjin.png").getImage();
|
return ceju;
|
}
|
|
/**»ùÕ¾µÄ¼¯ºÏ*/
|
//id,anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchormode,anchorip,GreateTime
|
static {
|
zaixian= new ImageIcon(on).getImage();
|
lixian=new ImageIcon(off).getImage();
|
Open_soft_dialog.addara("¼ÓÔØtb_achor");
|
Iterator iterator =DatabaseManagement.table_base("tb_achor","ASC","anchorid").iterator();
|
while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
|
List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËØ¸øµ½info¼¯ºÏ
|
Anchor anchor=new Anchor();
|
String anchorid=(String)info.get(1);
|
String layer=(String)info.get(5);
|
String zu=(String)info.get(6);
|
anchor.setAnc_id(anchorid);
|
anchor.setAnc_x((String)info.get(2));
|
anchor.setAnc_y((String)info.get(3));
|
String z0=(String)info.get(4);
|
String liangcheng=(String)info.get(7);
|
if(z0==null || z0.equals("")) {
|
z0="0";
|
}
|
anchor.setAnc_z(z0);
|
anchorh0=Double.valueOf(z0);
|
anchor.setAnc_floor(layer);
|
anchor.setAnc_zu(zu);
|
Dell_tbcengzu.add_cengzu_form_addanchor(layer, zu);//Ìí¼Ó²ã×é¶ÔÏó
|
anchor.setAnc_distance(liangcheng);
|
anchor.setAnc_status("-1");
|
anchor.setAnc_ip((String)info.get(9));
|
anchor.setAnc_image(lixian);
|
anchor.setVersion((String)info.get(10));
|
anchor.setGonglv((String)info.get(11));
|
anchor.setJiaozhundistance((String)info.get(12));
|
anchor.setAnc_cteatetime((String)info.get(13));
|
anchor.setGaodu(0);//ÉèÖñäµçվģʽÏÂÉ豸³õʼ¸ß¶È
|
String ac15=(String)info.get(15);
|
if(ac15==null) {
|
ac15="0";
|
}
|
anchor.setBaoliu1(ac15);
|
anchor.setPort(0);
|
anchor.setNearok(0);
|
anchor.setTongbuok(0);
|
//¿ç²ã×é»ùվи߶È
|
String a1=(String)info.get(16);
|
if(a1 !=null) {
|
if(a1.length()>2) {
|
anchor.setBaoliu2(a1);
|
//и߶ÈËùÔÚµÄ×é
|
String a2=(String)info.get(17);
|
anchor.setBaoliu3(a2);
|
kczcnchor_vector.add(anchor);
|
}else {
|
anchor.setBaoliu2("");
|
anchor.setBaoliu3("");
|
}
|
}else {
|
anchor.setBaoliu2("");
|
anchor.setBaoliu3("");
|
}
|
|
//±Ø¾¾àÀë
|
String bjjl=(String)info.get(18);
|
if( bjjl==null) {
|
bjjl="";
|
}else {
|
if(bjjl.length()>2) {
|
bjjl_vector.add(anchor);
|
}else {
|
bjjl="";
|
}
|
}
|
//»ùÕ¾ºÍ±êÇ©¾àÀëÅжÏÊÇ·ñÔÚÊÒÄÚ
|
String juli=(String)info.get(19);
|
if(juli==null) {
|
juli="0";
|
anchor.setBaoliu5(0);
|
}else {
|
if(juli.length()<2) {
|
}else {
|
int a3=Integer.parseInt(juli);
|
anchor.setBaoliu5(a3);
|
}
|
}
|
anchor.setBaoliu4(bjjl);
|
anchor.setGetversionok(0);
|
anchor.setAnchorheart(0);
|
|
//ÎÞÏß»ùÕ¾µÄµçÁ¿
|
if(Systems.isWuxian()) {//ϵͳ¿ªÆô»ùÕ¾ÎÞÏßģʽ
|
String power=(String)info.get(22);
|
if(power==null) {
|
power="";
|
}
|
anchor.setBaoliu8(power);
|
}
|
if (Systems.isWuxian()){//ϵͳ¿ªÆô»ùÕ¾ÎÞÏßģʽ
|
String distance=(String) info.get(23);
|
if (distance==null){
|
distance= String.valueOf(0);
|
}
|
|
anchor.setBaoliu9(distance);
|
}
|
if (info.size()<26){
|
ShowMessage.zidingyi_24("ÕýÔÚ¸øtb_anchor±íÌí¼Ó×Ö¶Îbaoliu11,ÇëÖØÆô");
|
String sql2="ALTER TABLE `hxzkuwb`.`tb_achor` ADD baoliu11 VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT -1 COMMENT 'ÎÞÏß»ùվͨѶ×éID' AFTER baoliu10;";
|
//String sql3="ALTER TABLE `hxzkuwb`.`tb_achor` ADD baoliu12 VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT -1 COMMENT 'ÎÞÏß»ùվͨѶ×éID' AFTER baoliu11;";
|
DatabaseManagement.update(sql2);
|
//DatabaseManagement.update(sql3);
|
System.exit(-1);
|
}
|
if (Systems.isWuxian()){//ϵͳ¿ªÆô»ùÕ¾ÎÞÏßģʽ
|
String gonglv=(String) info.get(24);
|
if (gonglv==null){
|
gonglv= String.valueOf(0);
|
}
|
|
anchor.setBaoliu10(gonglv);
|
}
|
if (Systems.isWuxian()){//ϵͳ¿ªÆô»ùÕ¾ÎÞÏßģʽ
|
String groupId=(String) info.get(25);
|
if (groupId==null){
|
groupId= String.valueOf(-1);
|
}
|
|
anchor.setBaoliu11(groupId);
|
}
|
anchor.setAnchor_distance_state(-1);//³õʼ»¯»ùÕ¾»ùÕ¾²â¾à״̬
|
anchor.setAnchor_power_state(-1);//³õʼ»¯»ùÕ¾µçÁ¿×´Ì¬
|
anchor.setAnc_image(anchor_off);
|
anchor.setImgicon(anchor_off1);
|
anchor_vector.add(anchor);
|
}
|
}
|
|
public static Vector<Anchor> getAnchor_vector() {
|
return anchor_vector;
|
}
|
|
|
/**»ñȡϵͳÖлùÕ¾µÄ×ÜÊý*/
|
public static int anchornum() {
|
int num=getAnchor_vector().size();
|
return num;
|
}
|
|
|
|
/**ËÑË÷ij¸ö»ùÕ¾*/
|
public static Vector<Anchor> serch_anchor(String anchorid) {
|
Vector<Anchor> anchor=null;
|
if( get_anchor(anchorid) !=null) {
|
anchor=new Vector<Anchor>();
|
anchor.add(get_anchor(anchorid));
|
}
|
return anchor;
|
}
|
|
/**Ð޸ĻùÕ¾ÁÙ½üÏ·¢×´Ì¬*/
|
public static void alert_nearok(int ok,String anchorid) {
|
if( get_anchor(anchorid) !=null) {
|
get_anchor(anchorid).setNearok(ok);
|
}
|
}
|
|
/**Ð޸ĻùÕ¾µÄͬ²½Ï·¢Çé¿ö*/
|
public static void alert_tongbuok(int ok,String anchorid) {
|
if( get_anchor(anchorid) !=null) {
|
get_anchor(anchorid).setTongbuok(ok);
|
}
|
}
|
|
/**Ð޸ĻùÕ¾µÄͬ²½×´Ì¬*/
|
public static void alert_anchor_tonbu_state(String anchorid,String state) {
|
if(get_anchor(anchorid) !=null) {
|
get_anchor(anchorid).setAnchorzhuangtai(state);
|
}
|
}
|
|
/**ͨ¹ýIDÕÒµ½Ä³Ò»¸ö»ùÕ¾¶ÔÏó*/
|
public static Anchor get_anchor(String anchorid) {
|
Anchor anchor= null;
|
if(anchor_vector.size() !=0) {
|
Iterator<Anchor> it=anchor_vector.iterator();
|
while(it.hasNext()) {
|
Anchor anchor1=it.next();
|
String idach=anchor1.getAnc_id();
|
if(idach.equals(anchorid)) {
|
anchor=anchor1;
|
break;
|
}
|
}
|
}
|
|
return anchor;
|
}
|
|
|
|
/**ͨ¹ýIPµØÖ·ÕÒµ½Ä³¸ö»ùÕ¾*/
|
public static Anchor found_anchor_from_ip(String ip) {
|
Anchor anchor= null;
|
if(anchor_vector.size() !=0) {
|
Iterator<Anchor> it=anchor_vector.iterator();
|
while(it.hasNext()) {
|
Anchor anchor1=it.next();
|
String ip1=anchor1.getAnc_ip();
|
if(ip1 !=null) {
|
if(ip1.equals(ip)) {
|
anchor=anchor1;
|
break;
|
}
|
}
|
}
|
}
|
return anchor;
|
}
|
|
|
|
|
/**¸Ä±äÒ»¸ö»ùÕ¾¶ÔÏóµÄ״̬ΪÔÚÏß*/
|
public static void set_anchor_mode(Anchor anchor,String anchorid,String ip,int port) {
|
if( anchor!=null) {
|
anchor.setAnc_ip(ip);
|
anchor.setPort(port);
|
String b1=anchor.getAnc_status();
|
if(b1.equals("0")) {//Ð޸ĻùÕ¾ÉÏÏ߼Ǽ
|
String tm=anchor.getAnc_cteatetime();
|
int a= Shi_jian_cha_sss.get_time_cha_s(GetNowTime.now(),tm);
|
JudgeTagOrAnchorOffline.insert_indata_shangxian(anchorid,"»ùÕ¾ÉÏÏß","ÀëÏßʱ³¤:"+a);//»ùÕ¾ÀëÏß²åÈëÀëÏ߼ǼÊý¾Ý¿â
|
anchor.setAnc_status("1");
|
anchor.setAnc_image(zaixian);
|
}
|
anchor.setAnc_cteatetime(GetNowTime.now());
|
}
|
}
|
|
|
|
|
|
|
/**»ùÕ¾ÀëÏß»òÕßÔÚÏß״̬
|
* @param modeÔÚÏßÊÇ1ÀëÏßÊÇ0*/
|
public static void set_anchor_onandoff(String ip,String mode) {
|
|
if(found_anchor_from_ip(ip) !=null) {
|
found_anchor_from_ip(ip).setAnc_image(zaixian);
|
if(mode.equals("0")) {
|
found_anchor_from_ip(ip).setAnc_image(lixian);
|
}
|
|
found_anchor_from_ip(ip).setAnc_status(mode);
|
|
String[] ziduan= {"anchormode","GreateTime","anchorid"};
|
String[] zhi= {mode,GetNowTime.now(),found_anchor_from_ip(ip).getAnc_id()};
|
DatabaseManagement.fast_alert_dbase("tb_achor", ziduan, zhi);
|
|
}
|
}
|
|
|
/**Ð޸ĻùÕ¾µÄ°æ±¾ÐÅÏ¢ºÍIPµØÖ·*/
|
public static void set_anchor_version(String ip,String anchorid,String version) {
|
|
if(get_anchor(anchorid) !=null) {
|
get_anchor(anchorid).setVersion(version);
|
get_anchor(anchorid).setAnc_ip(ip);
|
get_anchor(anchorid).setAnc_status("1");
|
get_anchor(anchorid).setAnc_image(zaixian);
|
String mode="1";
|
|
String[] ziduan= {"version","anchorip","anchormode","GreateTime","anchorid"};
|
String[] zhi= {version,ip,mode,GetNowTime.now(),get_anchor(anchorid).getAnc_id()};
|
DatabaseManagement.fast_alert_dbase("tb_achor", ziduan, zhi);
|
}
|
}
|
|
|
/**¸Ä±äÒ»¸ö»ùÕ¾¶ÔÏóµÄxyzfloorip*/
|
public static void set_anchor_xyzfip(String anchorid,String x,String y,String z,
|
String floor,String ip,String zu,String liangcheng,String baoliu9) {
|
if(get_anchor(anchorid) !=null) {
|
get_anchor(anchorid).setAnc_x(x);
|
get_anchor(anchorid).setAnc_y(y);
|
get_anchor(anchorid).setAnc_z(z);
|
get_anchor(anchorid).setAnc_floor(floor);
|
get_anchor(anchorid).setAnc_ip(ip);
|
get_anchor(anchorid).setAnc_zu(zu);
|
get_anchor(anchorid).setAnc_distance(liangcheng);
|
get_anchor(anchorid).setBaoliu9(baoliu9);
|
|
}
|
}
|
|
/**ÐÂÔöÒ»¸ö»ùÕ¾¶ÔÏó
|
* @param anchorid»ùÕ¾id
|
* @param x×ø±ê
|
* @param y×ø±ê
|
* @param z×ø±ê
|
* @param floor²ã
|
* @param zu×é
|
* @param liangcheng Á¿³Ì
|
* @param ip
|
* @param mode״̬
|
*/
|
public static void set_anchor(String anchorid,String x,String y,String z,
|
String floor,String zu,String liangcheng,String ip,String mode,String baoliu9) {
|
if(get_anchor(anchorid) == null) {
|
Anchor new_anchor=new Anchor();
|
new_anchor.setAnc_id(anchorid);
|
new_anchor.setAnc_status(mode);
|
new_anchor.setAnc_x(x);
|
new_anchor.setAnc_y(y);
|
new_anchor.setAnc_z(z);
|
new_anchor.setAnc_floor(floor);
|
new_anchor.setAnc_zu(zu);
|
new_anchor.setAnc_distance(liangcheng);
|
new_anchor.setAnc_ip(ip);
|
new_anchor.setAnc_cteatetime(GetNowTime.now());
|
new_anchor.setPort(8233);
|
new_anchor.setAnc_image(zaixian);
|
new_anchor.setBaoliu9(baoliu9);
|
anchor_vector.add(new_anchor);
|
}
|
}
|
|
/**ɾ³ýÒ»¸ö»ùÕ¾¶ÔÏó*/
|
public static void remov_anchor(String anchorid) {
|
if(get_anchor(anchorid) != null) {
|
anchor_vector.remove(get_anchor(anchorid));
|
}
|
|
}
|
|
|
|
/**ɾ³ýËùÓлùÕ¾¶ÔÏó*/
|
public static void removall_anchor() {
|
if(anchor_vector.size()!= 0) {
|
anchor_vector.removeAllElements();
|
}
|
|
}
|
|
|
public static Image getZaixian() {
|
return zaixian;
|
}
|
|
|
public static Image getLixian() {
|
return lixian;
|
}
|
|
/**»ñÈ¡»ùÕ¾IDµÄ¼¯ºÏ*/
|
public static String[] get_anchorid() {
|
int size=anchor_vector.size();
|
String[] anchoridstr=new String[size+2];
|
anchoridstr[0]="Ñ¡Ôñ»ùÕ¾";
|
anchoridstr[1]="ËùÓлùÕ¾";
|
if(size !=0) {
|
for(int i=0;i<size;i++) {
|
anchoridstr[i+2]=anchor_vector.get(i).getAnc_id();
|
}
|
}
|
return anchoridstr;
|
}
|
|
/**»ñÈ¡»ùÕ¾IDµÄ¼¯ºÏ*/
|
public static String[] get_anchorid3() {
|
int size=anchor_vector.size();
|
String[] anchoridstr=new String[size+2];
|
anchoridstr[0]="Ñ¡Ôñ»ùÕ¾";
|
anchoridstr[1]="ËùÓлùÕ¾";
|
if(size !=0) {
|
for(int i=0;i<size;i++) {
|
anchoridstr[i+2]=anchor_vector.get(i).getAnc_id();
|
}
|
|
}
|
return anchoridstr;
|
}
|
|
/**»ñÈ¡»ùÕ¾IDµÄ¼¯ºÏ*/
|
public static String[] get_anchorid4() {
|
int size=anchor_vector.size();
|
String[] anchoridstr=new String[size+1];
|
anchoridstr[0]="Ñ¡Ôñ»ùÕ¾";
|
if(size !=0) {
|
for(int i=0;i<size;i++) {
|
anchoridstr[i+1]=anchor_vector.get(i).getAnc_id();
|
}
|
}
|
return anchoridstr;
|
}
|
|
/**»ñÈ¡»ùÕ¾IDµÄ¼¯ºÏ*/
|
public static String[] get_anchorid2() {
|
int size=anchor_vector.size();
|
String[] anchoridstr=new String[size];
|
if(size !=0) {
|
for(int i=0;i<size;i++) {
|
anchoridstr[i]=anchor_vector.get(i).getAnc_id();
|
}
|
}
|
return anchoridstr;
|
}
|
|
|
|
/**»ùÕ¾X×ø±ê¼¯ºÏ¸øµ½JNAʹÓÃ*/
|
public static int[] anchor_xyz(String[] anchrids,String type) {
|
int size=anchrids.length;
|
int[] anchor=new int[size];
|
for(int i=0;i<size;i++) {
|
if(get_anchor(anchrids[i]) !=null) {
|
if(type.equals("x")) {
|
anchor[i]=Integer.parseInt(get_anchor(anchrids[i]).anc_x);
|
}else if(type.equals("y")) {
|
anchor[i]=Integer.parseInt(get_anchor(anchrids[i]).anc_y);
|
}else if(type.equals("z")) {
|
anchor[i]=Integer.parseInt(get_anchor(anchrids[i]).anc_z);
|
}
|
}else {
|
if(type.equals("x")) {
|
anchor[i]=0;
|
}else if(type.equals("y")) {
|
anchor[i]=0;
|
}else if(type.equals("z")) {
|
anchor[i]=0;
|
}
|
}
|
}
|
return anchor;
|
}
|
|
/**»ùÕ¾ËùÔÚµÄ×éint[]¸øµ½JNAʹÓÃ*/
|
public static int[] zu(String[] anchrids) {
|
int size=anchrids.length;
|
int[] zu=new int[size];
|
for(int i=0;i<size;i++) {
|
if(get_anchor(anchrids[i]) !=null) {
|
zu[i]=Integer.parseInt(get_anchor(anchrids[i]).getAnc_zu());
|
}
|
}
|
return zu;
|
}
|
|
/**»ùÕ¾µÄÁ¿³ÌÏÞÖÆint[] ¸øJNAʹÓÃ*/
|
public static int[] anchor_liangcheng(String[] anchrids) {
|
int size=anchrids.length;
|
int[] liangchneg=new int[size];
|
|
for(int i=0;i<size;i++) {
|
if(get_anchor(anchrids[i]) !=null) {
|
String a=get_anchor(anchrids[i]).getAnc_distance();
|
if(a.equals("ÎÞÏÞÖÆ")) {
|
liangchneg[i]=100000;
|
}else {
|
liangchneg[i]=Integer.parseInt(a);
|
}
|
|
}
|
}
|
return liangchneg;
|
}
|
|
/**»ñÈ¡»ùÕ¾µÄ²ãÐÅÏ¢¸øµ½JNAʹÓÃ*/
|
public static int[] anchor_floor(String[] anchrids) {
|
int size=anchrids.length;
|
int[] liangchneg=new int[size];
|
for(int i=0;i<size;i++) {
|
if(get_anchor(anchrids[i]) !=null) {
|
String a=get_anchor(anchrids[i]).getAnc_floor();
|
liangchneg[i]=Integer.parseInt(a); }
|
}
|
return liangchneg;
|
}
|
|
/**»ñÈ¡»ùÕ¾µÄ²ãÐÅÏ¢¸øµ½JNAʹÓÃ*/
|
public static int[] anchor_floor(int[] anchrids) {
|
int size=anchrids.length;
|
int[] liangchneg=new int[size];
|
for(int i=0;i<size;i++) {
|
if(get_anchor(String.valueOf(anchrids[i])) !=null) {
|
String a=get_anchor(String.valueOf(anchrids[i])).getAnc_floor();
|
liangchneg[i]=Integer.parseInt(a); }
|
}
|
return liangchneg;
|
}
|
|
/**Ð޸ĻùÕ¾ÐÅÏ¢*/
|
public static void alert_anchor(
|
String anchorid,
|
String x,
|
String y,
|
String z,
|
String floor,
|
String distance,
|
String tongbu,
|
String ip,
|
String version,
|
String anc_status) {
|
|
if(get_anchor(anchorid) !=null) {
|
get_anchor(anchorid).setAnc_id(anchorid);
|
get_anchor(anchorid).setAnc_x(x);
|
get_anchor(anchorid).setAnc_y(y);
|
get_anchor(anchorid).setAnc_z(z);
|
get_anchor(anchorid).setAnc_floor(floor);
|
get_anchor(anchorid).setAnc_distance(distance);
|
get_anchor(anchorid).setAnchorzhuangtai(tongbu);
|
get_anchor(anchorid).setAnc_ip(ip);
|
get_anchor(anchorid).setVersion(version);
|
get_anchor(anchorid).setAnc_status(anc_status);
|
}
|
|
}
|
|
/**ÐÞ¸ÄÊý¾Ý¿âÖлùÕ¾ÐÅÏ¢*/
|
public static void alert_tb_anchor() {
|
int size=anchor_vector.size();
|
if(size==0) {
|
return;
|
}
|
StringBuffer sql=new StringBuffer("UPDATE tb_achor SET ");
|
Vector<String> vp_anchorid=new Vector<String>();
|
Vector<String> vp_x=new Vector<String>();
|
Vector<String> vp_y=new Vector<String>();
|
Vector<String> vp_z=new Vector<String>();
|
Vector<String> vp_floor=new Vector<String>();
|
Vector<String> vp_distance=new Vector<String>();
|
Vector<String> vp_tongbu=new Vector<String>();
|
Vector<String> vp_ip=new Vector<String>();
|
Vector<String> vp_version=new Vector<String>();
|
Vector<String> vp_state=new Vector<String>();
|
Vector<String> vp_time=new Vector<String>();
|
for(int i=0;i<size;i++) {
|
Anchor ac=anchor_vector.get(i);
|
String anchorid=ac.getAnc_id();
|
String x=ac.getAnc_x();
|
String y=ac.getAnc_y();
|
String z=ac.getAnc_z();
|
String floor=ac.getAnc_floor();
|
String distance=ac.getAnc_distance();
|
String tongbu=ac.getAnchorzhuangtai();
|
if(tongbu==null) {
|
tongbu=" ";
|
}
|
String ip=ac.getAnc_ip();
|
String version=ac.getVersion();
|
if(version==null) {
|
version="V0.00";
|
}
|
String state=ac.getAnc_status();
|
vp_anchorid.add(anchorid);
|
vp_x.add(x);
|
vp_y.add(y);
|
vp_z.add(z);
|
vp_floor.add(floor);
|
vp_distance.add(distance);
|
vp_tongbu.add(tongbu);;
|
vp_ip.add(ip);
|
vp_version.add(version);
|
vp_state.add(state);
|
vp_time.add(GetNowTime.now());
|
}
|
|
sql.append(engine_do.getinfo(vp_x,"POSX",vp_anchorid,"anchorid")+" , ");
|
sql.append(engine_do.getinfo(vp_y,"POSY",vp_anchorid,"anchorid")+" , ");
|
sql.append(engine_do.getinfo(vp_z,"POSZ",vp_anchorid,"anchorid")+" , ");
|
sql.append(engine_do.getinfo(vp_floor,"layer",vp_anchorid,"anchorid")+" , ");
|
sql.append(engine_do.getinfo(vp_distance,"liangcheng",vp_anchorid,"anchorid")+" , ");
|
sql.append(engine_do.getinfo(vp_tongbu,"tongbu",vp_anchorid,"anchorid")+" , ");
|
sql.append(engine_do.getinfo(vp_ip,"anchorip",vp_anchorid,"anchorid")+" , ");
|
sql.append(engine_do.getinfo(vp_version,"version",vp_anchorid,"anchorid")+" , ");
|
sql.append(engine_do.getinfo(vp_time,"GreateTime",vp_anchorid,"anchorid")+" , ");
|
sql.append(engine_do.getinfo(vp_state,"anchormode",vp_anchorid,"anchorid")+" ");
|
sql.append(engine_do.getlast(vp_anchorid,"anchorid"));
|
|
DatabaseManagement.update(sql.toString());
|
}
|
|
/**URTģʽµÄʱºòÐÂÔö»ùÕ¾*/
|
public static void urt(String tagid) {
|
if(get_anchor(tagid) == null) {
|
Anchor_Dell.set_anchor(tagid,"0","0","0","0","0","ÎÞÏÞÖÆ","","1","0");
|
String[] ziduan= {"anchorid","POSX","POSY","POSZ","layer","zu","liangcheng","anchormode","anchorip","GreateTime"};
|
String[] zhi= {tagid,"0","0","0","0","0","ÎÞÏÞÖÆ","1","",GetNowTime.now()};
|
DatabaseManagement.insertfast("tb_achor", ziduan, zhi);
|
//ÐÂÔöÁÙ½ü»ùÕ¾ÐÅÏ¢
|
Anchor_nerby_dell.add_anchorby(tagid,"","","","","","","","","","","0");
|
|
//ÐÂÔöͬ²½»ùÕ¾
|
Dell_TongbuAnchor.add_one_rootanchor(tagid, "", "0", "");
|
}
|
}
|
|
/**URTģʽϸıä»ùÕ¾µÄxyz×ø±ê*/
|
public static void urt_xyz(String tagid,String x,String y) {
|
if(get_anchor(tagid) != null) {
|
if(Gps_Manage.isUrt_stop()) {
|
get_anchor(tagid).setAnc_x(x);
|
get_anchor(tagid).setAnc_y(y);
|
String[] ziduan= {"POSX","POSY","GreateTime","anchorid"};
|
String[] zhi= {x,y,GetNowTime.now(),tagid};
|
DatabaseManagement.fast_alert_dbase("tb_achor", ziduan, zhi);
|
}
|
}else {
|
if(biaoji) {
|
ShowMessage.zidingyi(tagid+"²»´æÔÚÇëÌí¼Ó¸Ã»ùÕ¾");
|
biaoji=false;
|
}
|
}
|
}
|
|
/**»ñÈ¡×éµÄ¼¯ºÏint[]*/
|
public static int[] anchor_zu(String anchorid) {
|
int[] zus=null;
|
if(get_anchor(anchorid) !=null) {
|
String zu=get_anchor(anchorid).getAnc_zu();
|
String[] zust=zu.split(";");
|
int size=zust.length;
|
zus=new int[size];
|
for(int i=0;i<size;i++) {
|
zus[i]=Integer.parseInt(zust[i]);
|
}
|
}
|
return zus;
|
}
|
|
/**»ñÈ¡Á¿³ÌµÄ¼¯ºÏint[]*/
|
public static int[] anchor_lc(String anchorid) {
|
int[] zus=null;
|
if(get_anchor(anchorid) !=null) {
|
String zu=get_anchor(anchorid).getAnc_distance();
|
String[] zust=zu.split(";");
|
int size=zust.length;
|
zus=new int[size];
|
for(int i=0;i<size;i++) {
|
if (zust[i].equals("ÎÞÏÞÖÆ") || zust[i].equals("0") ) {
|
zust[i]="100000";
|
}
|
zus[i]=Integer.parseInt(zust[i]);
|
}
|
}
|
return zus;
|
}
|
|
/**ÅжÏ×éºÏÁ¿³ÌÊÇ·ñÒ»ÖÂ*/
|
public static boolean lc_and_zu(String zu,String lc) {
|
boolean a=false;
|
String[] zus=zu.split(";");
|
String[] lcs=lc.split(";");
|
int a0=zus.length;
|
int a1=lcs.length;
|
if(a0 !=a1) {
|
a=true;
|
}
|
return a;
|
}
|
|
/**»ñÈ¡»ùվÿһ²ãµÄËã·¨¼¯ºÏin[]*/
|
public static int[] get_dimension(String anchorid) {
|
int[] dimension=null;
|
String ceng=get_anchor(anchorid).getAnc_floor();
|
int[] zus=anchor_zu(anchorid);
|
if(zus !=null) {
|
int size=zus.length;
|
for(int i=0;i<size;i++) {
|
dimension=new int[size];
|
String zu=String.valueOf(zus[i]);
|
Tb_cengzu suanfa=Dell_tbcengzu.get_tbcengzu(ceng, zu);
|
int sf=2;
|
if(suanfa !=null) {
|
sf=Integer.parseInt(suanfa.getSuan_fa_wei_du());
|
}
|
dimension[i]=sf;
|
}
|
}
|
return dimension;
|
}
|
|
/**ÅжÏIPÊDz»ÊÇ»ùÕ¾µÄIP*/
|
public static Boolean ipok(String ip) {
|
boolean ipok=true;
|
int size=anchor_vector.size();
|
for(int i=0;i<size;i++) {
|
String ip1=anchor_vector.get(i).getAnc_ip();
|
if(ip1.equals(ip)) {
|
ipok=true;
|
break;
|
}else {
|
ipok=false;
|
}
|
}
|
return ipok;
|
|
}
|
|
/**ÊÕµ½ÐÄÌø°ü×Ô¶¯ÐÂÔöÒ»¸ö»ùÕ¾*/
|
public static void autoaddanchor(String anchorid,String anchorip,int port) {
|
String POSX="0";
|
String POSY="0";
|
String POSZ="0";
|
String layer="0";
|
String zu="0";
|
String baoliu9="0";
|
String liangcheng="100000";
|
String anchormode="1";
|
|
String[] ziduan= {"anchorid","POSX","POSY","POSZ","layer","zu","liangcheng","anchormode","anchorip","GreateTime"};
|
String[] zhi= {anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchormode,anchorip,GetNowTime.now()};
|
|
if(DatabaseManagement.insertfast("tb_achor", ziduan, zhi)) {
|
Dell_tbcengzu.add_cengzu_form_addanchor(layer, zu);//Ìí¼Ó²ã×é¶ÔÏó
|
Anchor_Dell.set_anchor(anchorid,POSX,POSY,POSZ,layer, zu,liangcheng,anchorip,anchormode,baoliu9);
|
Anchor_nerby_dell.add_anchorby(anchorid,"","","","","","","","","","","0"); //ÐÂÔöÁÙ½ü»ùÕ¾ÐÅÏ¢
|
Dell_TongbuAnchor.add_one_rootanchor(anchorid, "", "0", "");//ÐÂÔöͬ²½»ùÕ¾
|
ShowMessage.zidingyi_24("×Ô¶¯Ìí¼ÓÁËһ̨δ¼ÈëµÄ»ùÕ¾£º"+anchorid);
|
}
|
}
|
|
|
|
/**»ñÈ¡¿ç²ã×é»ùÕ¾µÄ¼¯ºÏ*/
|
public static Vector<Anchor> getKczcnchor_vector() {
|
return kczcnchor_vector;
|
}
|
|
public static Vector<Anchor> getBjjl_vector() {
|
return bjjl_vector;
|
}
|
|
|
|
public static double getAnchorh0() {
|
return anchorh0;
|
}
|
|
public static void setAnchorh0(double anchorh0) {
|
Anchor_Dell.anchorh0 = anchorh0;
|
}
|
|
public static double getAnchorhr() {
|
return anchorhr;
|
}
|
|
public static void setAnchorhr(double anchorhr) {
|
Anchor_Dell.anchorhr = anchorhr;
|
}
|
|
/**»ñÈ¡ËùÓÐÔÚÏß»ùÕ¾µÄÊýÁ¿*/
|
public static int[] get_online_anchornum() {
|
int[] num=new int[2];
|
int size=anchor_vector.size();
|
int num1=0;
|
for(int i=0;i<size;i++) {
|
String on=anchor_vector.get(i).getAnc_status();
|
if(on.equals("1")) {
|
num1=num1+1;
|
}
|
}
|
num[0]=num1;
|
num[1]=size-num1;
|
return num;
|
}
|
|
/**ÉèÖûùÕ¾µÄͼ±ê
|
* 0ÀëÏߣ¬1ÔÚÏߣ¬2»ÆÉ«£¬3ÂÌÉ«£¬4ºìÉ«*/
|
public static void set_anchor_image(int state,String anchorid) {
|
Anchor anchor=Anchor_Dell.get_anchor(anchorid);
|
switch (state){
|
case 0 :
|
anchor.setAnc_image(anchor_off);
|
anchor.setImgicon(anchor_off1);
|
break;
|
case 1 :
|
anchor.setAnc_image(anchor_on);
|
anchor.setImgicon(anchor_on1);
|
break;
|
case 2 :
|
anchor.setAnc_image(anchor_yellow);
|
anchor.setImgicon(anchor_yellow1);
|
break;
|
case 3 :
|
anchor.setAnc_image(anchor_green);
|
anchor.setImgicon(anchor_green1);
|
break;
|
case 4 :
|
anchor.setAnc_image(anchor_red);
|
anchor.setImgicon(anchor_red1);
|
break;
|
}
|
}
|
|
}
|