package anchor;
|
import java.util.Iterator;
|
import java.util.List;
|
import java.util.Vector;
|
import DataBase.DatabaseManagement;
|
import PbuliClass.ShowMessage;
|
import PbuliClass.Systems;
|
import home.Open_soft_dialog;
|
import tbDataModel.anchornear;
|
@SuppressWarnings("rawtypes")
|
public class Anchor_nerby_dell {
|
static Vector<anchornear> Anchornearby_vector=new Vector<anchornear>();//ÁÙ½ü»ùÕ¾µÄ¼¯ºÏ
|
static boolean biaozhi=true;
|
/**»ùÕ¾ÁÙ½üµÄ¼¯ºÏ*/
|
static {
|
Open_soft_dialog.addara("¼ÓÔØtb_anchor_nearby");
|
Iterator iterator = DatabaseManagement.get_alldate_indatabase("tb_anchor_nearby").iterator();
|
while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
|
List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËØ¸øµ½info¼¯ºÏ
|
anchornear acner=new anchornear();
|
Vector<String> neranchorid=new Vector<String>();
|
acner.setAnchorid((String)info.get(0));
|
String near1=(String)info.get(1);
|
if(near1==null) {
|
near1="0";
|
}else {
|
near1=near1.replaceAll(" ", "");
|
}
|
|
String near2=(String)info.get(2);
|
if(near2==null) {
|
near2="0";
|
}else {
|
near2=near2.replaceAll(" ", "");
|
}
|
String near3=(String)info.get(3);
|
if(near3==null) {
|
near3="0";
|
}else {
|
near3=near3.replaceAll(" ", "");
|
}
|
String near4=(String)info.get(4);
|
if(near4==null) {
|
near4="0";
|
}else {
|
near4=near4.replaceAll(" ", "");
|
}
|
String near5=(String)info.get(5);
|
if(near5==null) {
|
near5="0";
|
}else {
|
near5=near5.replaceAll(" ", "");
|
}
|
String near6=(String)info.get(6);
|
if(near6==null) {
|
near6="0";
|
}else {
|
near6=near6.replaceAll(" ", "");
|
}
|
String near7=(String)info.get(7);
|
if(near7==null) {
|
near7="0";
|
}else {
|
near7=near7.replaceAll(" ", "");
|
}
|
String near8=(String)info.get(8);
|
if(near8==null) {
|
near8="0";
|
}else {
|
near8=near8.replaceAll(" ", "");
|
}
|
String near9=(String)info.get(9);
|
if(near9==null) {
|
near9="0";
|
}else {
|
near9=near9.replaceAll(" ", "");
|
}
|
String near10=(String)info.get(10);
|
if(near10==null) {
|
near10="0";
|
}else {
|
near10=near10.replaceAll(" ", "");
|
}
|
String dis=((String)info.get(11));
|
String fastdis=((String)info.get(12));
|
if(fastdis==null) {
|
fastdis="65535";
|
}
|
|
String allout=((String)info.get(13));//ËùÓÐÊý¾ÝÊä³ö
|
if(allout ==null) {
|
allout="0";
|
}
|
acner.setAlldata(allout);
|
|
int fastdisint=Integer.parseInt(fastdis);
|
acner.setFastdistance(fastdisint);
|
|
|
int distance=Integer.parseInt(dis);
|
acner.setDistance(distance);
|
|
if(near1.length()>3) {
|
neranchorid.add(near1);
|
}
|
|
if(near2.length()>3) {
|
neranchorid.add(near2);
|
}
|
|
if(near3.length()>3) {
|
neranchorid.add(near3);
|
}
|
|
if(near4.length()>3) {
|
neranchorid.add(near4);
|
}
|
|
if(near5.length()>3) {
|
neranchorid.add(near5);
|
}
|
|
if(near6.length()>3) {
|
neranchorid.add(near6);
|
}
|
|
if(near7.length()>3) {
|
neranchorid.add(near7);
|
}
|
|
if(near8.length()>3) {
|
neranchorid.add(near8);
|
}
|
|
if(near9.length()>3) {
|
neranchorid.add(near9);
|
}
|
|
if(near10.length()>3) {
|
neranchorid.add(near10);
|
}
|
acner.setNeranchorid(neranchorid);
|
acner.setNearnum(neranchorid.size());
|
|
Anchornearby_vector.add(acner);
|
}
|
}
|
|
|
|
/**ͨ¹ýIDÕÒµ½Ä³Ò»¸ö¶ÔÏó*/
|
public static anchornear get_anchor(String anchorid) {
|
anchornear acner= null;
|
if(Anchornearby_vector.size() !=0) {
|
for(int i=0;i<Anchornearby_vector.size();i++) {
|
anchornear acner1=Anchornearby_vector.get(i);
|
String anchorid1=acner1.getAnchorid();
|
if(anchorid1.equals(anchorid)) {
|
acner=acner1;
|
break;
|
}
|
}
|
}
|
return acner;
|
}
|
|
|
/**ÐÂÔöÒ»¸öÁÙ½ü»ùÕ¾¶ÔÏó */
|
public static void add_anchorby(
|
String anchorid,
|
String near1,
|
String near2,
|
String near3,
|
String near4,
|
String near5,
|
String near6,
|
String near7,
|
String near8,
|
String near9,
|
String near10,
|
String qiehuan) {
|
if(get_anchor(anchorid) == null) {
|
anchornear acner=new anchornear();
|
Vector<String> neranchorid=new Vector<String>();
|
acner.setAnchorid(anchorid);
|
int distance=Integer.parseInt(qiehuan);
|
acner.setDistance(distance);
|
|
if(near1.length()>3) {
|
neranchorid.add(near1.trim());
|
}
|
|
if(near2.length()>3) {
|
neranchorid.add(near2.trim());
|
}
|
|
if(near3.length()>3) {
|
neranchorid.add(near3.trim());
|
}
|
|
if(near4.length()>3) {
|
neranchorid.add(near4.trim());
|
}
|
|
if(near5.length()>3) {
|
neranchorid.add(near5.trim());
|
}
|
|
if(near6.length()>3) {
|
neranchorid.add(near6.trim());
|
}
|
|
if(near7.length()>3) {
|
neranchorid.add(near7.trim());
|
}
|
|
if(near8.length()>3) {
|
neranchorid.add(near8.trim());
|
}
|
|
if(near9.length()>3) {
|
neranchorid.add(near9.trim());
|
}
|
|
if(near10.length()>3) {
|
neranchorid.add(near10.trim());
|
}
|
acner.setNeranchorid(neranchorid);
|
acner.setNearnum(neranchorid.size());
|
Anchornearby_vector.add(acner);
|
String[] ziduan= { "anchorid","near1","near2","near3","near4","near5","near6","near7","near8","near9","near10","qiehuan"};
|
String[] zhi= {anchorid,near1,near2,near3,near4,near5,near6,near7,near8,near9,near10,qiehuan};
|
DatabaseManagement.insertfast("tb_anchor_nearby", ziduan, zhi);
|
}
|
}
|
|
/**ɾ³ýÒ»¸öÁÙ½ü»ùÕ¾¶ÔÏó*/
|
public static void delete_anchorby(String anchorid) {
|
if(get_anchor(anchorid) != null) {
|
Anchornearby_vector.remove(get_anchor(anchorid));
|
String deleteSql="DELETE FROM tb_anchor_nearby WHERE anchorid='"+anchorid+"'";
|
DatabaseManagement.update(deleteSql);
|
}
|
|
}
|
|
/**ɾ³ýËùÓÐÁÙ½ü»ùÕ¾¶ÔÏó*/
|
public static void delete_all_anchorby() {
|
if(Anchornearby_vector.size() !=0) {
|
Anchornearby_vector.removeAllElements();
|
String deleteSql="TRUNCATE TABLE tb_anchor_nearby";
|
DatabaseManagement.update(deleteSql);
|
}
|
|
}
|
|
public static Vector<anchornear> getAnchornearby_vector() {
|
return Anchornearby_vector;
|
}
|
|
/**ÐÞ¸ÄÒ»¸öÁÙ½ü»ùÕ¾¶ÔÏó */
|
public static void alert_anchorby(
|
String anchorid,
|
String near1,
|
String near2,
|
String near3,
|
String near4,
|
String near5,
|
String near6,
|
String near7,
|
String near8,
|
String near9,
|
String near10,
|
String qiehuan,
|
String fastdis,
|
String baoliu2) {
|
if(get_anchor(anchorid) != null) {
|
Vector<String> neranchorid=new Vector<String>();
|
int distance=Integer.parseInt(qiehuan);
|
anchornear acner=get_anchor(anchorid) ;
|
acner.setDistance(distance);
|
int fastdistance=Integer.parseInt(fastdis);
|
acner.setFastdistance(fastdistance);
|
acner.setAlldata(baoliu2);
|
if(near1.length()>3) {
|
neranchorid.add(near1);
|
}
|
|
if(near2.length()>3) {
|
neranchorid.add(near2);
|
}
|
|
if(near3.length()>3) {
|
neranchorid.add(near3);
|
}
|
|
if(near4.length()>3) {
|
neranchorid.add(near4);
|
}
|
|
if(near5.length()>3) {
|
neranchorid.add(near5);
|
}
|
|
if(near6.length()>3) {
|
neranchorid.add(near6);
|
}
|
|
if(near7.length()>3) {
|
neranchorid.add(near7);
|
}
|
|
if(near8.length()>3) {
|
neranchorid.add(near8);
|
}
|
|
if(near9.length()>3) {
|
neranchorid.add(near9);
|
}
|
|
if(near10.length()>3) {
|
neranchorid.add(near10);
|
}
|
acner.setNeranchorid(neranchorid);
|
acner.setNearnum(neranchorid.size());
|
}
|
}
|
|
|
/**»ñȡij¸ö»ùÕ¾ÁÙ½ü»ùÕ¾µÄ¼¯ºÏ*/
|
public static String[] get_nearanhor(String anchorid) {
|
String[] anchorner=null;
|
if(!Systems.isWuxian()) {
|
anchornear ancn=get_anchor(anchorid);
|
if(ancn==null) {
|
if(biaozhi) {
|
ShowMessage.zidingyi_24(anchorid+"ͬ²½»ùÕ¾²»´æÔÚ");
|
biaozhi=false;
|
}
|
}else {
|
anchorner=new String[ancn.getNearnum()];
|
for(int i=0;i<ancn.getNearnum();i++) {
|
String anchiri=ancn.getNeranchorid().get(i).replaceAll(" ","");
|
anchorner[i]=anchiri;
|
}
|
|
}
|
}
|
return anchorner;
|
}
|
|
/**»ñȡij¸ö»ùÕ¾ÁÙ½ü»ùÕ¾µÄ¼¯ºÏ*/
|
public static int[] get_nearanhorhex(String anchorid) {
|
int[] anchorner=null;
|
if(!Systems.isWuxian()) {
|
anchornear ancn=get_anchor(anchorid);
|
if(ancn==null) {
|
if(biaozhi) {
|
ShowMessage.zidingyi_24(anchorid+"ͬ²½»ùÕ¾²»´æÔÚ");
|
biaozhi=false;
|
}
|
}else {
|
anchorner=new int[ancn.getNearnum()];
|
for(int i=0;i<ancn.getNearnum();i++) {
|
String anchiri=ancn.getNeranchorid().get(i).trim();
|
anchorner[i]=Integer.parseInt(anchiri,16);
|
}
|
|
}
|
}
|
return anchorner;
|
|
}
|
|
|
}
|