package tbDataModel_Dell;
|
import java.util.Iterator;
|
import java.util.List;
|
import java.util.Vector;
|
import DataBase.DatabaseManagement;
|
import Method.GetNowTime;
|
import PbuliClass.ShowMessage;
|
import home.Open_soft_dialog;
|
import tbDataModel.Point_fence_inout;
|
import tbDataModel.Tb_fence_inout;
|
|
public class Dell_Fenceinout {
|
|
static Vector<Tb_fence_inout> finout_vec=new Vector<>();
|
static Vector<Point_fence_inout> point_finout_vec=new Vector<>();
|
|
/**³õʼ»¯Êý¾Ý*/
|
@SuppressWarnings("rawtypes")
|
public static void chushihua(){
|
Open_soft_dialog.addara("¼ÓÔØtb_fence_inout");
|
Iterator iterator = DatabaseManagement.get_alldate_indatabase("tb_fence_inout").iterator();
|
while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
|
List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
|
Tb_fence_inout tbinout=new Tb_fence_inout();
|
tbinout.setId(Integer.parseInt((String)info.get(0)));
|
tbinout.setName((String)info.get(1));
|
tbinout.setZuobiao((String)info.get(2));
|
tbinout.setBianshu((String)info.get(3));
|
tbinout.setCanin((String)info.get(4));
|
tbinout.setCanout((String)info.get(5));
|
tbinout.setFloor((String)info.get(6));
|
tbinout.setAddtime((String)info.get(7));
|
String zu=(String)info.get(8);
|
String allFloor=(String)info.get(9);
|
int group=Integer.parseInt(zu);
|
if (allFloor==null){
|
allFloor="0";
|
}
|
tbinout.setBaoliu1("0");
|
tbinout.setGoroup(group);
|
finout_vec.add(tbinout);
|
get_point_fencinout((String)info.get(2),(String)info.get(6));
|
}
|
}
|
|
|
/**ij¸ö»ñÈ¡¶à±ßÐεÄÇøÓò¶ÔÏó*/
|
public static Tb_fence_inout get_finout(String name) {
|
Tb_fence_inout tbinout=null;
|
int size=finout_vec.size();
|
if(size!=0) {
|
for(int i=0;i<size;i++) {
|
Tb_fence_inout tbinout1=finout_vec.get(i);
|
if(tbinout1.getName().equals(name)) {
|
tbinout=tbinout1;
|
break;
|
}
|
}
|
}
|
return tbinout;
|
}
|
|
|
/**»ñÈ¡ÇøÓò×ø±êX¼¯ºÏ*/
|
//85,86;87,88;100,477
|
public static int[] py(String name) {
|
|
int j=0;
|
int size= Integer.parseInt(get_finout(name).getBianshu());
|
int py[]=new int[size];
|
|
String zuobiao=get_finout(name).getZuobiao().replace(";", ",");
|
|
String zuobiaos[]=zuobiao.split("\\,");
|
|
for(int i=0;i<size*2;i++) {
|
|
if((i%2) !=0) {
|
double wd=Double.parseDouble(zuobiaos[i]);
|
py[j]=(int) wd;
|
j++;
|
}
|
}
|
|
|
return py;
|
}
|
|
/**»ñÈ¡ÇøÓò×ø±êY¼¯ºÏ*/
|
//[85,86;87,88;100,477]
|
public static int[] px(String name) {
|
|
int j=0;
|
int size= Integer.parseInt(get_finout(name).getBianshu());
|
int px[]=new int[size];
|
|
String zuobiao=get_finout(name).getZuobiao().replace(";", ",");
|
|
String zuobiaos[]=zuobiao.split("\\,");
|
|
for(int i=0;i<size*2;i++) {
|
|
if((i%2) ==0) {
|
double wd=Double.parseDouble(zuobiaos[i]);
|
px[j]=(int) wd;
|
j++;
|
}
|
}
|
|
|
return px;
|
}
|
|
|
/**»ñÈ¡ÊÇ·ñ¿ÉÒÔ½øÈ뼯ºÏ*/
|
public static int[] entrance(String name) {
|
int size= Integer.parseInt(get_finout(name).getBianshu());
|
int entrance[]=new int[size];
|
String entrances[]=get_finout(name).getCanin().split(",");
|
for(int i=0;i<size;i++) {
|
String a=entrances[i].replaceAll(" ", "");
|
entrance[i]=Integer.parseInt(a);
|
}
|
return entrance;
|
}
|
|
/**»ñÈ¡ÊÇ·ñ¿ÉÒÔ³öÈ¥µÄ¼¯ºÏ*/
|
public static int[] exit(String name) {
|
int size= Integer.parseInt(get_finout(name).getBianshu());
|
int exit[]=new int[size];
|
String exits[]=get_finout(name).getCanout().split(",");
|
for(int i=0;i<size;i++) {
|
String a=exits[i].replaceAll(" ", "");
|
exit[i]=Integer.parseInt(a);
|
}
|
return exit;
|
}
|
|
|
public static Vector<Tb_fence_inout> getFinout_vec() {
|
return finout_vec;
|
}
|
|
public static void alert(String name,String zuobiao,String canin,String canout,String ceng,String group) {
|
get_finout(name).setZuobiao(zuobiao);
|
get_finout(name).setCanin(canin);
|
get_finout(name).setCanout(canout);
|
get_finout(name).setFloor(ceng);
|
get_finout(name).setGoroup(Integer.parseInt(group));
|
String[] ziduan= { "zuobiao","canin", "canout","addtime","floor","zu","name"};
|
String[] zhi= {zuobiao,canin,canout,GetNowTime.now(),ceng,group,name};
|
String[] ziduan2= { "zuobiao","addtime","floor","name"};
|
String[] zhi2= {zuobiao,GetNowTime.now(),ceng,name};
|
DatabaseManagement.fast_alert_dbase("tb_fence", ziduan2, zhi2);
|
if(DatabaseManagement.fast_alert_dbase("tb_fence_inout", ziduan, zhi)) {
|
ShowMessage.zidingyi_24("Ð޸ijɹ¦£¬ÖØÆôÈí¼þºóÉúЧ...");
|
}
|
|
}
|
|
public static void insert(String name,String zuobiaos,String type,String floor,Integer group,String allFloor) {
|
String bianshu="4";
|
StringBuffer canin=new StringBuffer();
|
StringBuffer canout=new StringBuffer();
|
|
if(type.equals("¾ØÐÎ")) {
|
canin=new StringBuffer("1,1,1,1");
|
canout=new StringBuffer("1,1,1,1");
|
}else if (type.equals("¶à±ßÐÎ")){
|
String[] zb=zuobiaos.split("\\;");
|
bianshu=String.valueOf(zb.length);
|
for(int i=0;i<zb.length-1;i++) {
|
canin.append("1,");
|
canout.append("1,");
|
if(i==(zb.length-2)) {
|
canin.append("1");
|
canout.append("1");
|
}
|
}
|
}else if (type.equals("һάÏß")){
|
String[] zb=zuobiaos.split("\\;");
|
bianshu=String.valueOf(zb.length);
|
for(int i=0;i<zb.length-1;i++) {
|
canin.append("0,");
|
canout.append("0,");
|
if(i==(zb.length-2)) {
|
canin.append("0");
|
canout.append("0");
|
}
|
}
|
}
|
|
String[] ziduan= {"name", "zuobiao", "bianshu", "canin", "canout", "floor", "addtime","zu","baoliu1"};
|
String[] zhi= {name,zuobiaos,bianshu,canin.toString(),canout.toString(),floor,GetNowTime.now(), String.valueOf(group),allFloor};
|
boolean a=DatabaseManagement.insertfast("tb_fence_inout", ziduan, zhi);
|
if(a) {
|
Tb_fence_inout tbinout=new Tb_fence_inout();
|
tbinout.setName(name);
|
tbinout.setZuobiao(zuobiaos);
|
tbinout.setBianshu(bianshu);
|
tbinout.setCanin(canin.toString());
|
tbinout.setCanout(canout.toString());
|
tbinout.setFloor(floor);
|
tbinout.setGoroup(group);
|
tbinout.setAddtime(GetNowTime.now());
|
tbinout.setBaoliu1(allFloor);
|
finout_vec.add(tbinout);
|
}else {
|
ShowMessage.zidingyi("±£´æΧÀ¸Ê§°Ü£¬Ð´ÈëÊý¾Ý¿âʧ°Ü");
|
}
|
}
|
|
/**ɾ³ýij¸ö¶ÔÏó*/
|
public static void delte(String name) {
|
if(get_finout(name) !=null) {
|
finout_vec.removeElement(get_finout(name));
|
String deleteSql="DELETE FROM tb_fence_inout WHERE name='"+name+"'";
|
DatabaseManagement.update(deleteSql);
|
}
|
}
|
|
/**È«²¿É¾³ý*/
|
public static void delteall() {
|
if(finout_vec.size() !=0) {
|
finout_vec.removeAllElements();
|
String deleteSql="TRUNCATE TABLE tb_fence_inout";
|
DatabaseManagement.update(deleteSql);
|
|
}
|
}
|
|
public static void get_point_fencinout(String message,String floor) {
|
String[] mes=message.split(";");
|
///
|
for(int i=0;i<mes.length;i++) {
|
String name=mes[i];
|
String[] xy=name.split(",");
|
double x0=Double.parseDouble(xy[0]);
|
double y0=Double.parseDouble(xy[1]);
|
int x=(int)x0;
|
int y=(int)y0;
|
Point_fence_inout pfi=new Point_fence_inout();
|
pfi.setName(name);
|
pfi.setX(x);
|
pfi.setY(y);
|
pfi.setFloor(floor);
|
point_finout_vec.add(pfi);
|
xy=null;
|
}
|
mes=null;
|
}
|
|
|
public static Vector<Point_fence_inout> getPoint_finout_vec() {
|
return point_finout_vec;
|
}
|
|
}
|
