package tbDataModel_Dell;
|
import DataBase.DatabaseManagement;
|
import PbuliClass.ShowMessage;
|
import home.Open_soft_dialog;
|
import tbDataModel.tb_line;
|
|
import java.util.Arrays;
|
import java.util.Iterator;
|
import java.util.List;
|
import java.util.Vector;
|
|
public class Dell_tbline {
|
static Vector<tb_line> line = new Vector<>();
|
public static Vector<tb_line> getLine_vector() {
|
return line;
|
}
|
static int add=0;//Êý¾Ý¿âÐÂÔö×ֶΠ2023.08.21 zsh
|
|
/**³õʼ»¯Êý¾Ý*/
|
@SuppressWarnings("rawtypes")
|
public static void chushihua(){
|
Open_soft_dialog.addara("¼ÓÔØtb_line");
|
Iterator iterator = DatabaseManagement.get_alldate_indatabase("tb_line").iterator();
|
while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
|
List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
|
if (info.size()<10) {
|
addziDuan(info.size());
|
}
|
tb_line line1=new tb_line();
|
line1.setId((String) info.get(0));
|
line1.setFlr((String)info.get(1));
|
line1.setGrp((String)info.get(2));
|
line1.setVnum((String)info.get(3));
|
String ints = (String) info.get(4);
|
String ints1 = (String) info.get(5);
|
String substring = ints.substring(1, ints.length() - 1);
|
String substring1 = ints1.substring(1, ints1.length() - 1);
|
String[] x = substring.trim().split(",");
|
String[] y = substring1.trim().split(",");
|
int length = x.length;
|
int[] xs=new int[length];
|
int[] ys=new int[length];
|
for (int i=0;i<length;i++){
|
xs[i]= Integer.parseInt(x[i].trim());
|
ys[i]= Integer.parseInt(y[i].trim());
|
}
|
line1.setPx(xs);
|
line1.setPy(ys);
|
line1.setLineId((String) info.get(7));
|
String s = (String) info.get(8);
|
if (s==null){
|
s="0";
|
}
|
line1.setBaoliu1(s);
|
line.add(line1);
|
}
|
}
|
|
//¸øÊý¾Ý¿âÌí¼Ó×ֶΠ2023.08.21 zsh
|
private static void addziDuan(int size) {
|
ShowMessage.zidingyi_24("ÕýÔÚ¸øtb_person±íÌí¼Ó×Ö¶Î,ÇëÖØÆô");
|
if(add==0) {
|
|
if (size<10) {
|
String sql1 = "ALTER TABLE `hxzkuwb`.`tb_line` ADD baoliu1 VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 0 COMMENT '¶ÔËùÓÐͼ²ãÉúЧ' AFTER lineId;";
|
DatabaseManagement.update(sql1);
|
String sql = "ALTER TABLE `hxzkuwb`.`tb_line` ADD baoliu2 VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 0 COMMENT '' AFTER baoliu1;";
|
DatabaseManagement.update(sql);
|
String sql3 = "ALTER TABLE `hxzkuwb`.`tb_line` ADD baoliu3 VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 0 COMMENT '' AFTER baoliu2;";
|
DatabaseManagement.update(sql3);
|
}
|
add=1;
|
System.exit(-1);
|
}
|
}
|
|
|
public static void add( String flr,
|
String grp,
|
String vnum,
|
int[] px,
|
int[] py,
|
String allFloor){
|
tb_line li = new tb_line();
|
li.setFlr(flr);
|
li.setGrp(grp);
|
li.setVnum(vnum);
|
li.setPx(px);
|
li.setPy(py);
|
li.setBaoliu1(allFloor);
|
line.add(li);
|
}
|
|
/**
|
* Ïò¼¯ºÏÖÐÌí¼ÓÒ»¸ö¶à¶ÎÏß±í
|
*
|
* @param id
|
* @param flr
|
* @param grp
|
* @param vnum
|
* @param px
|
* @param py
|
* @param wd
|
*/
|
public static void insert_line(
|
String id,
|
String flr,
|
String grp,
|
String vnum,
|
int[] px,
|
int[] py,
|
String wd,
|
String allFloor
|
) {
|
String[] ziduan = { "flr", "grp", "vnum", "px", "py", "wd","lineId","baoliu1"};
|
String[] zhi = {flr, grp,vnum,Arrays.toString(px), Arrays.toString(py), String.valueOf(wd),String.valueOf(id),allFloor};
|
boolean a = DatabaseManagement.insertfast("tb_line", ziduan, zhi);
|
if (a) {
|
tb_line li = new tb_line();
|
li.setLineId(id);
|
li.setFlr(flr);
|
li.setGrp(grp);
|
li.setVnum(vnum);
|
li.setPx(px);
|
li.setPy(py);
|
li.setWd(wd);
|
li.setBaoliu1(allFloor);//¶ÔËùÓÐͼ²ãÉúЧ 2023.08.21 zsh
|
line.add(li);
|
}
|
}
|
|
/**ɾ³ý¼¯ºÏÖеÄij¸öΧÀ¸¶ÔÏó*/
|
public static void delete_line(String name) {
|
if( found(name) !=null) {
|
line.remove(found(name));
|
String deleteSql1="DELETE FROM tb_line WHERE lineId='"+name+"'";
|
DatabaseManagement.update(deleteSql1);
|
}
|
}
|
/**ɾ³ý¼¯ºÏÖеÄËùÓÐΧÀ¸¶ÔÏó*/
|
public static void delete_all_line() {
|
line.removeAllElements();
|
}
|
/**ÕÒµ½Ä³¸öһάÏ߶ÔÏóͨ¹ýÃû³Æ*/
|
public static tb_line found(String name) {
|
tb_line poly=null;
|
if(line.size() !=0) {
|
for(int i=0;i<line.size();i++) {
|
tb_line poly1=line.get(i);
|
String name1=poly1.getLineId();
|
if(name1.equals(name)) {
|
poly=poly1;
|
break;
|
}
|
}
|
}
|
return poly;
|
}
|
|
//ɾ³ýÈ«²¿
|
public static void delete_all() {
|
if(line.size() !=0) {
|
line.removeAllElements();
|
}
|
}
|
|
|
//ÐÞ¸Ä
|
public static void alert(int[] x,int[] y,String name) {
|
tb_line line=found(name);
|
if(line==null) {
|
return;
|
}
|
line.setPx(x);
|
line.setPy(y);
|
}
|
}
|
