package tbDataModel_Dell;
|
import java.util.Iterator;
|
import java.util.List;
|
import java.util.Vector;
|
import DataBase.DatabaseManagement;
|
import Judge.JugeNumber;
|
import PbuliClass.ShowMessage;
|
import anchor.Dell_cengao;
|
import home.Open_soft_dialog;
|
import tbDataModel.Tb_cengzu;
|
@SuppressWarnings("rawtypes")
|
public class Dell_tbcengzu {
|
static Vector<Tb_cengzu > cengzuvc=new Vector<>();//²ã×éµÄ¼¯ºÏ
|
static Vector<Tb_cengzu > zkdc_vector=new Vector<>();//×é¿ç¶à²ãµÄ¼¯ºÏ
|
static Vector<Tb_cengzu > outzu_vector=new Vector<>();//ÊÒÍâ×éµÄ¼¯ºÏ
|
static Vector<Tb_cengzu > bjz_vector=new Vector<>();//±Ø¾×éµÄ¼¯ºÏ
|
static Vector<Tb_cengzu > zkdys_vector=new Vector<>();//¿í¶ÈÔ¼Êø×éµÄ¼¯ºÏ
|
static Vector<Tb_cengzu > line_vector=new Vector<>();;//һά»ùÕ¾µÄ¼¯ºÏ
|
static Vector<String > cengvc=new Vector<>();//²ãµÄ¼¯ºÏ
|
|
static {
|
Open_soft_dialog.addara("¼ÓÔØtb_cengzu");
|
List list=DatabaseManagement.get_alldate_indatabase("tb_ceng_zu");
|
Iterator iterator =list.iterator() ;
|
while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
|
List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
|
Tb_cengzu tb_cengzu=new Tb_cengzu();
|
String id=(String) info.get(0); //
|
String floor=(String) info.get(1); //²ã
|
String zu=(String) info.get(2); //×é
|
String bi_jing_ju_li=(String) info.get(3);//±Ø¾¾àÀë
|
String is_shi_wai_zu=(String) info.get(4);//ÊÇ·ñÊÇÊÒÍâ×é0²»ÊÇ£¬1ÊÇ
|
String is_bi_jing_zu=(String) info.get(5);//ÊÇ·ñÊDZؾ×é0²»ÊÇ£¬1ÊÇ
|
String suan_fa_wei_du=(String) info.get(6);//Ëã·¨µÄά¶È0,1,2,3
|
String suan_fa=(String) info.get(7);//ĬÈÏTOF
|
String zu_kua_duo_ceng=(String) info.get(8);//×é¿ç¶à²ã
|
String you_xiao_qu_yu=(String) info.get(9);//ÓÐЧÇøÓò
|
String zu_kuang_du=(String) info.get(10);//×é¿í¶È
|
tb_cengzu.setId(id);
|
tb_cengzu.setFloor(floor);
|
tb_cengzu.setZu(zu);
|
tb_cengzu.setBi_jing_ju_li(bi_jing_ju_li);
|
tb_cengzu.setIs_shi_wai_zu(is_shi_wai_zu);
|
tb_cengzu.setIs_bi_jing_zu(is_bi_jing_zu);
|
tb_cengzu.setSuan_fa_wei_du(suan_fa_wei_du);
|
tb_cengzu.setSuan_fa(suan_fa);
|
tb_cengzu.setZu_kua_duo_ceng(zu_kua_duo_ceng);
|
tb_cengzu.setYou_xiao_qu_yu(you_xiao_qu_yu);
|
tb_cengzu.setZu_kuang_du(zu_kuang_du);
|
cengzuvc.add(tb_cengzu);
|
addceng(floor);
|
addvc(tb_cengzu,bi_jing_ju_li, is_shi_wai_zu,is_bi_jing_zu,suan_fa_wei_du,
|
zu_kua_duo_ceng,zu_kuang_du);
|
}
|
if(cengzuvc.size()==0) {
|
add_cengzu();
|
}
|
}
|
|
/**ͨ¹ý²ãIDÕÒµ½²ã*/
|
public static String getfloor(String ceng) {
|
String ceng1=null;
|
for(int i=0;i<cengvc.size();i++ ) {
|
String c0=cengvc.get(i);
|
if(c0.equals(ceng)) {
|
ceng1=c0;
|
break;
|
}
|
}
|
return ceng1;
|
}
|
|
/**Ìí¼Ó²ã*/
|
public static void addceng(String ceng) {
|
String floor=getfloor( ceng);
|
if(floor==null) {
|
cengvc.add(ceng);
|
Dell_cengao.add_ceng_gao(ceng);//Ìí¼Ó²ã¸ß¶ÔÏó
|
}
|
}
|
|
/**ͨ¹ý²ã×éÕÒµ½²ã×é¶ÔÏó*/
|
public static Tb_cengzu get_tbcengzu(String ceng,String zu) {
|
Tb_cengzu tb_cengzu=null;
|
int size=cengzuvc.size();
|
for(int i=0;i<size;i++) {
|
Tb_cengzu tb_cengzu1=cengzuvc.get(i);
|
String ceng1=tb_cengzu1.getFloor();
|
String zu1=tb_cengzu1.getZu();
|
if(ceng.equals(ceng1)&& zu.equals(zu1)) {
|
tb_cengzu=tb_cengzu1;
|
break;
|
}
|
}
|
return tb_cengzu;
|
}
|
|
/**ÐÂÔö»òÕßÐÞ¸ÄÒ»¸ö²ã×é¶ÔÏó*/
|
public static void add_or_alert_cengzu(
|
String floor, //²ã
|
String zu, //×é
|
String bi_jing_ju_li,//±Ø¾¾àÀë
|
String is_shi_wai_zu,//ÊÇ·ñÊÇÊÒÍâ×é0²»ÊÇ£¬1ÊÇ
|
String is_bi_jing_zu,//ÊÇ·ñÊDZؾ×é0²»ÊÇ£¬1ÊÇ
|
String suan_fa_wei_du,//Ëã·¨µÄά¶È0,1,2,3
|
String suan_fa,//ĬÈÏTOF
|
String zu_kua_duo_ceng,//×é¿ç¶à²ã
|
String you_xiao_qu_yu,//ÓÐЧÇøÓò
|
String zu_kuang_du//×é¿í¶È
|
) {
|
|
Tb_cengzu tb_cengzu=get_tbcengzu(floor,zu);
|
String id=floor+""+zu;
|
if(tb_cengzu==null) {
|
tb_cengzu=new Tb_cengzu();
|
tb_cengzu.setId(id);
|
tb_cengzu.setFloor(floor);
|
tb_cengzu.setZu(zu);
|
tb_cengzu.setBi_jing_ju_li(bi_jing_ju_li);
|
tb_cengzu.setIs_shi_wai_zu(is_shi_wai_zu);
|
tb_cengzu.setIs_bi_jing_zu(is_bi_jing_zu);
|
tb_cengzu.setSuan_fa_wei_du(suan_fa_wei_du);
|
tb_cengzu.setSuan_fa(suan_fa);
|
tb_cengzu.setZu_kua_duo_ceng(zu_kua_duo_ceng);
|
tb_cengzu.setYou_xiao_qu_yu(you_xiao_qu_yu);
|
tb_cengzu.setZu_kuang_du(zu_kuang_du);
|
cengzuvc.add(tb_cengzu);
|
insert_tb_cengzu(
|
id,
|
floor, //²ã
|
zu, //×é
|
bi_jing_ju_li,//±Ø¾¾àÀë
|
is_shi_wai_zu,//ÊÇ·ñÊÇÊÒÍâ×é0²»ÊÇ£¬1ÊÇ
|
is_bi_jing_zu,//ÊÇ·ñÊDZؾ×é0²»ÊÇ£¬1ÊÇ
|
suan_fa_wei_du,//Ëã·¨µÄά¶È0,1,2,3
|
suan_fa,//ĬÈÏTOF
|
zu_kua_duo_ceng,//×é¿ç¶à²ã
|
you_xiao_qu_yu,//ÓÐЧÇøÓò
|
zu_kuang_du//×é¿í¶È
|
);
|
}else {
|
tb_cengzu=new Tb_cengzu();
|
tb_cengzu.setId(id);
|
tb_cengzu.setFloor(floor);
|
tb_cengzu.setZu(zu);
|
tb_cengzu.setBi_jing_ju_li(bi_jing_ju_li);
|
tb_cengzu.setIs_shi_wai_zu(is_shi_wai_zu);
|
tb_cengzu.setIs_bi_jing_zu(is_bi_jing_zu);
|
tb_cengzu.setSuan_fa_wei_du(suan_fa_wei_du);
|
tb_cengzu.setSuan_fa(suan_fa);
|
tb_cengzu.setZu_kua_duo_ceng(zu_kua_duo_ceng);
|
tb_cengzu.setYou_xiao_qu_yu(you_xiao_qu_yu);
|
tb_cengzu.setZu_kuang_du(zu_kuang_du);
|
alert_tbcengzu(
|
id,
|
floor, //²ã
|
zu, //×é
|
bi_jing_ju_li,//±Ø¾¾àÀë
|
is_shi_wai_zu,//ÊÇ·ñÊÇÊÒÍâ×é0²»ÊÇ£¬1ÊÇ
|
is_bi_jing_zu,//ÊÇ·ñÊDZؾ×é0²»ÊÇ£¬1ÊÇ
|
suan_fa_wei_du,//Ëã·¨µÄά¶È0,1,2,3
|
suan_fa,//ĬÈÏTOF
|
zu_kua_duo_ceng,//×é¿ç¶à²ã
|
you_xiao_qu_yu,//ÓÐЧÇøÓò
|
zu_kuang_du//×é¿í¶È
|
);
|
}
|
}
|
|
/**Êý¾Ý²åÈë²ã×éÊý¾Ý¿â*/
|
public static void insert_tb_cengzu(
|
String id,
|
String floor, //²ã
|
String zu, //×é
|
String bi_jing_ju_li,//±Ø¾¾àÀë
|
String is_shi_wai_zu,//ÊÇ·ñÊÇÊÒÍâ×é0²»ÊÇ£¬1ÊÇ
|
String is_bi_jing_zu,//ÊÇ·ñÊDZؾ×é0²»ÊÇ£¬1ÊÇ
|
String suan_fa_wei_du,//Ëã·¨µÄά¶È0,1,2,3
|
String suan_fa,//ĬÈÏTOF
|
String zu_kua_duo_ceng,//×é¿ç¶à²ã
|
String you_xiao_qu_yu,//ÓÐЧÇøÓò
|
String zu_kuang_du//×é¿í¶È
|
) {
|
String[] ziduan= {
|
"id",
|
"floor",
|
"zu",
|
"bi_jing_ju_li",
|
"is_shi_wai_zu",
|
"is_bi_jing_zu",
|
"suan_fa_wei_du",
|
"suan_fa",
|
"zu_kua_duo_ceng",
|
"you_xiao_qu_yu",
|
"zu_kuang_du"};
|
|
String[] zhi= {
|
id,
|
floor,
|
zu,
|
bi_jing_ju_li,
|
is_shi_wai_zu,
|
is_bi_jing_zu,
|
suan_fa_wei_du,
|
suan_fa,
|
zu_kua_duo_ceng,
|
you_xiao_qu_yu,
|
zu_kuang_du
|
};
|
DatabaseManagement.insertfast("tb_ceng_zu", ziduan, zhi);
|
ShowMessage.zidingyi(id+"±£´æ³É¹¦");
|
}
|
|
/**ÐÞ¸ÄÊý¾Ý¿âÊý¾Ý*/
|
public static void alert_tbcengzu(
|
String id,
|
String floor, //²ã
|
String zu, //×é
|
String bi_jing_ju_li,//±Ø¾¾àÀë
|
String is_shi_wai_zu,//ÊÇ·ñÊÇÊÒÍâ×é0²»ÊÇ£¬1ÊÇ
|
String is_bi_jing_zu,//ÊÇ·ñÊDZؾ×é0²»ÊÇ£¬1ÊÇ
|
String suan_fa_wei_du,//Ëã·¨µÄά¶È0,1,2,3
|
String suan_fa,//ĬÈÏTOF
|
String zu_kua_duo_ceng,//×é¿ç¶à²ã
|
String you_xiao_qu_yu,//ÓÐЧÇøÓò
|
String zu_kuang_du//×é¿í¶È
|
) {
|
String[] ziduan= {
|
"floor",
|
"zu",
|
"bi_jing_ju_li",
|
"is_shi_wai_zu",
|
"is_bi_jing_zu",
|
"suan_fa_wei_du",
|
"suan_fa",
|
"zu_kua_duo_ceng",
|
"you_xiao_qu_yu",
|
"zu_kuang_du",
|
"id"
|
};
|
|
String[] zhi= {
|
floor,
|
zu,
|
bi_jing_ju_li,
|
is_shi_wai_zu,
|
is_bi_jing_zu,
|
suan_fa_wei_du,
|
suan_fa,
|
zu_kua_duo_ceng,
|
you_xiao_qu_yu,
|
zu_kuang_du,
|
id
|
};
|
DatabaseManagement.fast_alert_dbase("tb_ceng_zu", ziduan, zhi);
|
ShowMessage.zidingyi(id+"Ð޸ijɹ¦");
|
}
|
|
/**ÐÂÔöÒ»¸ö0²ã0×é*/
|
public static void add_cengzu(){
|
add_or_alert_cengzu(
|
"0", //²ã
|
"0", //×é
|
"0",//±Ø¾¾àÀë
|
"0",//ÊÇ·ñÊÇÊÒÍâ×é0²»ÊÇ£¬1ÊÇ
|
"0",//ÊÇ·ñÊDZؾ×é0²»ÊÇ£¬1ÊÇ
|
"2",//Ëã·¨µÄά¶È0,1,2,3
|
"TOF",//ĬÈÏTOF
|
"-1",//×é¿ç¶à²ã
|
"Ñ¡ÔñÇøÓò",//ÓÐЧÇøÓò
|
"0"//×é¿í¶È
|
);
|
}
|
|
/**Ìí¼Ó»ùÕ¾µÄʱºòÈç¹û²ã×é²»´æÔÚÔòÔö¼ÓÒ»¸ö²ã×é¶ÔÏó*/
|
public static void add_cengzu_form_addanchor(String floor,String zu) {
|
String[] zs=zu.split(";");
|
int size=zs.length;
|
if(size>1) {
|
for(int i=0;i<size;i++) {
|
add_czu_from_ac(floor,zs[i]);
|
}
|
}else {
|
add_czu_from_ac(floor,zu);
|
}
|
|
}
|
|
/**Ìí¼Ó»ùÕ¾µÄʱºòÈç¹û²ã×é²»´æÔÚÔòÔö¼ÓÒ»¸ö²ã×é¶ÔÏó*/
|
public static void add_czu_from_ac(String floor,String zu) {
|
Tb_cengzu tb_cengzu=get_tbcengzu(floor,zu);
|
String id=floor+""+zu;
|
if(tb_cengzu==null) {
|
tb_cengzu=new Tb_cengzu();
|
tb_cengzu.setId(id);
|
tb_cengzu.setFloor(floor);
|
tb_cengzu.setZu(zu);
|
tb_cengzu.setBi_jing_ju_li("0");
|
tb_cengzu.setIs_shi_wai_zu("0");
|
tb_cengzu.setIs_bi_jing_zu("0");
|
tb_cengzu.setSuan_fa_wei_du("2");
|
tb_cengzu.setSuan_fa("TOF");
|
tb_cengzu.setZu_kua_duo_ceng("-1");
|
tb_cengzu.setYou_xiao_qu_yu("Ñ¡ÔñÇøÓò");
|
tb_cengzu.setZu_kuang_du("0");
|
cengzuvc.add(tb_cengzu);
|
insert_tb_cengzu(
|
id,
|
floor, //²ã
|
zu, //×é
|
"0",//±Ø¾¾àÀë
|
"0",//ÊÇ·ñÊÇÊÒÍâ×é0²»ÊÇ£¬1ÊÇ
|
"0",//ÊÇ·ñÊDZؾ×é0²»ÊÇ£¬1ÊÇ
|
"2",//Ëã·¨µÄά¶È0,1,2,3
|
"TOF",//ĬÈÏTOF
|
"-1",//×é¿ç¶à²ã
|
"Ñ¡ÔñÇøÓò",//ÓÐЧÇøÓò
|
"0"//×é¿í¶È
|
);
|
}
|
}
|
|
/**Ìí¼Ó²ã×éÊôÐÔ½øÈ뼯ºÏ*/
|
public static void addvc(
|
Tb_cengzu suanfa,
|
String bi_jing_ju_li,
|
String is_shi_wai_zu,
|
String is_bi_jing_zu,
|
String suan_fa_wei_du,
|
String zu_kua_duo_ceng,
|
String zu_kuang_du
|
) {
|
//×é¿ç¶à²ãµÄ²ã
|
if(zu_kua_duo_ceng.length()>2 && !zu_kua_duo_ceng.equals("×éÎÞ¿ç²ã")) {
|
zkdc_vector.add(suanfa);
|
}
|
|
//ÊÇ·ñÊÇÊÇÊÒÍâ×é
|
if(is_shi_wai_zu.equals("1")) {
|
outzu_vector.add(suanfa);
|
}
|
|
//±Ø¾×é
|
if(!is_bi_jing_zu.equals("0")) {
|
bjz_vector.add(suanfa);
|
}
|
|
//ºÏ·¨µÄ¿í¶ÈÔ¼ÊøËã·¨·ÅÈ뼯ºÏ
|
if(JugeNumber.isDigit(zu_kuang_du) && zu_kuang_du.length()>2) {
|
zkdys_vector.add(suanfa);
|
}
|
|
//Èç¹ûË㷨ά¶ÈÊÇ1ά
|
if(suan_fa_wei_du.equals("1")){
|
line_vector.add(suanfa);
|
}
|
}
|
|
public static Vector<Tb_cengzu> getCengzuvc() {
|
return cengzuvc;
|
}
|
|
public static void setCengzuvc(Vector<Tb_cengzu> cengzuvc) {
|
Dell_tbcengzu.cengzuvc = cengzuvc;
|
}
|
|
public static Vector<Tb_cengzu> getZkdc_vector() {
|
return zkdc_vector;
|
}
|
|
public static void setZkdc_vector(Vector<Tb_cengzu> zkdc_vector) {
|
Dell_tbcengzu.zkdc_vector = zkdc_vector;
|
}
|
|
public static Vector<Tb_cengzu> getOutzu_vector() {
|
return outzu_vector;
|
}
|
|
public static void setOutzu_vector(Vector<Tb_cengzu> outzu_vector) {
|
Dell_tbcengzu.outzu_vector = outzu_vector;
|
}
|
|
public static Vector<Tb_cengzu> getBjz_vector() {
|
return bjz_vector;
|
}
|
|
public static void setBjz_vector(Vector<Tb_cengzu> bjz_vector) {
|
Dell_tbcengzu.bjz_vector = bjz_vector;
|
}
|
|
public static Vector<Tb_cengzu> getZkdys_vector() {
|
return zkdys_vector;
|
}
|
|
public static void setZkdys_vector(Vector<Tb_cengzu> zkdys_vector) {
|
Dell_tbcengzu.zkdys_vector = zkdys_vector;
|
}
|
|
public static Vector<Tb_cengzu> getLine_vector() {
|
return line_vector;
|
}
|
|
public static void setLine_vector(Vector<Tb_cengzu> line_vector) {
|
Dell_tbcengzu.line_vector = line_vector;
|
}
|
|
/**»ñÈ¡²ã×éµÄµÄËã·¨*/
|
public static int[] weidu(int ceng,int[] zu) {
|
String floor=String.valueOf(ceng);
|
int size=zu.length;
|
int[] weidu=new int[size];
|
if(size==1) {
|
String zustr=String.valueOf(zu[0]);
|
Tb_cengzu a=get_tbcengzu(floor, zustr);
|
if(a!=null) {
|
String sf=a.getSuan_fa_wei_du();
|
weidu[0]=Integer.parseInt(sf);
|
}
|
}else {
|
for(int i=0;i<size;i++) {
|
String zustr=String.valueOf(zu[i]);
|
String sf=get_tbcengzu(floor,zustr).getSuan_fa_wei_du();
|
weidu[i]=Integer.parseInt(sf);
|
}
|
}
|
return weidu;
|
}
|
/**»ñÈ¡×é*/
|
public static String[] getzu(){
|
String[] zu=new String[100];
|
for(int i=0;i<100;i++) {
|
zu[i]=String.valueOf(i);
|
}
|
return zu;
|
}
|
|
/**»ñÈ¡²ã*/
|
public static String[] getceng() {
|
int size=cengvc.size();
|
String[] ceng=new String[size];
|
for(int i=0;i<size;i++) {
|
ceng[i]=cengvc.get(i);
|
}
|
return ceng;
|
}
|
|
|
|
public static Vector<String> getCengvc() {
|
return cengvc;
|
}
|
|
|
|
public static void setCengvc(Vector<String> cengvc) {
|
Dell_tbcengzu.cengvc = cengvc;
|
}
|
}
|
