package PbuliClass;
|
import java.util.Iterator;
|
import java.util.List;
|
import java.util.Vector;
|
|
import DataBase.DatabaseManagement;
|
import tbDataModel.Tb_led;
|
|
@SuppressWarnings("rawtypes")
|
public class Leds {
|
static Vector<Tb_led> tb_leds=new Vector<>(); //»ñÈ¡ËùÓÐled¶ÔÏó
|
static Vector<String> kqvc=new Vector<String>();//ÐèÒªÏÔʾµÄ¿¼ÇÚÄÚÈÝ
|
static Vector<String> gasvc=new Vector<String>();//ÐèÒªÏÔʾÆøÌåÄÚÈÝ
|
static int i=0;
|
static {
|
Iterator iterator = DatabaseManagement.get_alldate_indatabase("tb_led").iterator();
|
while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
|
List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
|
Tb_led led=new Tb_led();
|
|
led.setId(Integer.parseInt((String)info.get(0)));
|
led.setIp((String)info.get(1));
|
String open=(String)info.get(2);
|
led.setPort(open);
|
led.setOpen((String)info.get(3));
|
led.setClose((String)info.get(4));
|
led.setLight((String)info.get(5));
|
led.setTitle((String)info.get(6));
|
led.setLeft((String)info.get(7));
|
led.setRight((String)info.get(8));
|
led.setTime((String)info.get(9));
|
led.setGas((String)info.get(10));
|
led.setTayTime((String)info.get(11));
|
led.setGengxintime((String)info.get(12));
|
led.setTitle_x((String)info.get(13));
|
led.setTitle_y((String)info.get(14));
|
led.setTitle_S((String)info.get(15));
|
led.setTime_x((String)info.get(16));
|
led.setTime_y((String)info.get(17));
|
led.setTime_s((String)info.get(18));
|
led.setKq_x((String)info.get(19));
|
led.setKq_y((String)info.get(20));
|
led.setKq_s((String)info.get(21));
|
led.setKq_g((String)info.get(22));
|
led.setShx((String)info.get(23));
|
led.setShy((String)info.get(24));
|
led.setShs((String)info.get(25));
|
led.setShg((String)info.get(26));
|
led.setLed_w((String)info.get(27));
|
led.setLed_h((String)info.get(28));
|
led.setShow_name((String)info.get(29));
|
led.setShow_kahao((String)info.get(30));
|
led.setShow_bumen((String)info.get(31));
|
led.setShow_quyu((String)info.get(32));
|
led.setShow_time((String)info.get(33));
|
led.setShow_distance((String)info.get(34));
|
led.setGas_name((String)info.get(35));
|
led.setGas_type((String)info.get(36));
|
led.setGas_nongdu((String)info.get(37));
|
led.setGas_quyu((String)info.get(38));
|
led.setGas_time((String)info.get(39));
|
led.setGas_state((String)info.get(40));
|
led.setTimeshow((String)info.get(41));
|
led.setJx((String)info.get(42));
|
led.setJy((String)info.get(43));
|
led.setjW((String)info.get(44));
|
led.setJh((String)info.get(45));
|
led.setTh((String)info.get(46));
|
led.setTl((String)info.get(47));
|
String x0=(String)info.get(48);
|
String y0=(String)info.get(49);
|
if(x0==null) {
|
led.setBaoliu1("0");
|
led.setBaoliu2("0");
|
}else {
|
led.setBaoliu1(x0);
|
led.setBaoliu2(y0);
|
}
|
|
if(((String)info.get(29)).equals("1")) {
|
kqvc.add("ÐÕÃû");
|
}
|
|
if(((String)info.get(30)).equals("1")) {
|
kqvc.add("¿¨ºÅ");
|
}
|
|
if(((String)info.get(31)).equals("1")) {
|
kqvc.add("²¿ÃÅ");
|
}
|
|
if(((String)info.get(32)).equals("1")) {
|
kqvc.add("ÇøÓò");
|
}
|
|
if(((String)info.get(33)).equals("1")) {
|
kqvc.add("½øÈë");
|
}
|
|
if(((String)info.get(34)).equals("1")) {
|
kqvc.add("¾àÀë");
|
}
|
|
if(((String)info.get(35)).equals("1")) {
|
gasvc.add("ÆøÌå");
|
}
|
|
if(((String)info.get(36)).equals("1")) {
|
gasvc.add("ÀàÐÍ");
|
}
|
|
if(((String)info.get(37)).equals("1")) {
|
gasvc.add("Ũ¶È");
|
}
|
|
if(((String)info.get(38)).equals("1")) {
|
gasvc.add("ÇøÓò");
|
}
|
|
if(((String)info.get(39)).equals("1")) {
|
gasvc.add("ʱ¼ä");
|
}
|
|
if(((String)info.get(40)).equals("1")) {
|
gasvc.add("״̬");
|
}
|
|
if(i==0) {
|
tb_leds.add(led);
|
i=1;
|
}
|
}
|
}
|
|
|
|
public static Vector<Tb_led> get_tb_leds(){
|
return tb_leds;
|
}
|
|
/**¸Ä±äled*/
|
public static void alert_tb_led(
|
String ip,
|
String port,
|
String open,
|
String close,
|
String light,
|
String title,
|
String left,
|
String right,
|
String time,
|
String gas,
|
String tayTime,
|
String gengxintime,
|
String title_x,
|
String title_y,
|
String title_S,
|
String time_x,
|
String time_y,
|
String time_s,
|
String kq_x,
|
String kq_y,
|
String kq_s,
|
String kq_g,
|
String shx,
|
String shy,
|
String shs,
|
String shg,
|
String led_w,
|
String led_h,
|
String show_name,
|
String show_kahao,
|
String show_bumen,
|
String show_quyu,
|
String show_time,
|
String show_distance,
|
String gas_name,
|
String gas_type,
|
String gas_nongdu,
|
String gas_quyu,
|
String gas_time,
|
String gas_state,
|
String timeshow,
|
String jx,
|
String jy,
|
String jW,
|
String jh,
|
String th,
|
String tl,
|
String baoliu1,
|
String baoliu2
|
|
) {
|
tb_leds.get(0).setIp(ip);
|
tb_leds.get(0).setPort(port);
|
tb_leds.get(0).setOpen(open);
|
tb_leds.get(0).setClose(close);
|
tb_leds.get(0).setLight(light);
|
tb_leds.get(0).setTitle(title);
|
tb_leds.get(0).setLeft(left);
|
tb_leds.get(0).setRight(right);
|
tb_leds.get(0).setTime(time);
|
tb_leds.get(0).setGas(gas);
|
tb_leds.get(0).setTayTime(tayTime);
|
tb_leds.get(0).setGengxintime(gengxintime);
|
tb_leds.get(0).setTitle_x(title_x);
|
tb_leds.get(0).setTitle_y(title_y);
|
tb_leds.get(0).setTitle_S(title_S);
|
tb_leds.get(0).setTime_x(time_x);
|
tb_leds.get(0).setTime_y(time_y);
|
tb_leds.get(0).setTime_s(time_s);
|
tb_leds.get(0).setKq_x(kq_x);
|
tb_leds.get(0).setKq_y(kq_y);
|
tb_leds.get(0).setKq_s(kq_s);
|
tb_leds.get(0).setKq_g(kq_g);
|
tb_leds.get(0).setShx(shx);
|
tb_leds.get(0).setShy(shy);
|
tb_leds.get(0).setShs(shs);
|
tb_leds.get(0).setShg(shg);
|
tb_leds.get(0).setLed_w(led_w);
|
tb_leds.get(0).setLed_h(led_h);
|
tb_leds.get(0).setShow_name(show_name);
|
tb_leds.get(0).setShow_kahao(show_kahao);
|
tb_leds.get(0).setShow_bumen(show_bumen);
|
tb_leds.get(0).setShow_quyu(show_quyu);
|
tb_leds.get(0).setShow_time(show_time);
|
tb_leds.get(0).setShow_distance(show_distance);
|
tb_leds.get(0).setGas_name(gas_name);
|
tb_leds.get(0).setGas_type(gas_type);
|
tb_leds.get(0).setGas_nongdu(gas_nongdu);
|
tb_leds.get(0).setGas_quyu(gas_quyu);
|
tb_leds.get(0).setGas_time(gas_time);
|
tb_leds.get(0).setGas_state(gas_state);
|
tb_leds.get(0).setTimeshow(timeshow);
|
tb_leds.get(0).setJx(jx);
|
tb_leds.get(0).setJy(jy);
|
tb_leds.get(0).setjW(jW);
|
tb_leds.get(0).setJh(jh);
|
tb_leds.get(0).setTh(th);
|
tb_leds.get(0).setTl(tl);
|
tb_leds.get(0).setBaoliu1(baoliu1);
|
tb_leds.get(0).setBaoliu2(baoliu2);
|
|
|
String[] ziduan= {
|
"ip",
|
"port",
|
"open" ,
|
"close",
|
"light",
|
"title",
|
"left1",
|
"right1",
|
"time",
|
"gas",
|
"tayTime",
|
"gengxintime",
|
"title_x",
|
"title_y",
|
"title_S",
|
"time_x",
|
"time_y",
|
"time_s",
|
"kq_x",
|
"kq_y",
|
"kq_s",
|
"kq_g",
|
"shx",
|
"shy",
|
"shs",
|
"shg",
|
"led_w",
|
"led_h",
|
"show_name",
|
"show_kahao",
|
"show_bumen",
|
"show_quyu",
|
"show_time",
|
"show_distance",
|
"gas_name",
|
"gas_type",
|
"gas_nongdu",
|
"gas_quyu",
|
"gas_time",
|
"gas_state",
|
"timeshow",
|
"jx",
|
"jy",
|
"jW",
|
"jh",
|
"th",
|
"tl",
|
"baoliu1",
|
"baoliu2",
|
"id"};
|
String[] zhi= {
|
ip,
|
port,
|
open,
|
close,
|
light,
|
title,
|
left,
|
right,
|
time,
|
gas,
|
tayTime,
|
gengxintime,
|
title_x,
|
title_y,
|
title_S,
|
time_x,
|
time_y,
|
time_s,
|
kq_x,
|
kq_y,
|
kq_s,
|
kq_g,
|
shx,
|
shy,
|
shs,
|
shg,
|
led_w,
|
led_h,
|
show_name,
|
show_kahao,
|
show_bumen,
|
show_quyu,
|
show_time,
|
show_distance,
|
gas_name,
|
gas_type,
|
gas_nongdu,
|
gas_quyu,
|
gas_time,
|
gas_state,
|
timeshow,
|
jx,
|
jy,
|
jW,
|
jh,
|
th,
|
tl,
|
baoliu1,
|
baoliu2,
|
"1"};
|
|
if(DatabaseManagement.fast_alert_dbase("tb_led", ziduan, zhi)) {
|
ShowMessage.zidingyi("Êý¾Ý±£´æ³É¹¦£¡");
|
}else {
|
ShowMessage.zidingyi("Êý¾Ý±£´æʧ°Ü£¡");
|
}
|
}
|
|
/**¸Ä±äledµÄ¿ª¹Ø״̬*/
|
public static void alert_led_open(String open) {
|
tb_leds.get(0).setOpen(open);
|
StringBuffer updateSQL=new StringBuffer("UPDATE tb_led SET open='"+open+"' where id='1'");
|
DatabaseManagement.update(updateSQL.toString());
|
}
|
|
/**¸Ä±äledµÄÁÁ¶È*/
|
public static void alert_led_light(String light) {
|
tb_leds.get(0).setLight(light);
|
StringBuffer updateSQL=new StringBuffer("UPDATE tb_led SET light='"+light+"' where id='1'");
|
DatabaseManagement.update(updateSQL.toString());
|
}
|
|
/**¿ªÆôLEDͶÆÁ¹¦ÄÜ*/
|
public static void start_screnn(String close) {
|
tb_leds.get(0).setLight(close);
|
StringBuffer updateSQL=new StringBuffer("UPDATE tb_led SET close='"+close+"' where id='1'");
|
DatabaseManagement.update(updateSQL.toString());
|
}
|
|
|
/**»ñÈ¡led¶ÔÏó*/
|
public static Tb_led get_tb_led() {
|
if (tb_leds.size()==0){
|
//ShowMessage.zidingyi_24("ÎÞ¿¼ÇڼǼ");
|
return null;
|
}
|
Tb_led tb_led=tb_leds.get(0);
|
return tb_led;
|
}
|
|
|
public static Vector<String> getKqvc() {
|
return kqvc;
|
}
|
|
/**ÐèÒªÏÔʾµÄ¿¼ÇÚÄÚÈÝÊýÁ¿*/
|
public static int kqtitlenum(){
|
int num=0;
|
if(kqvc !=null) {
|
num=kqvc.size();
|
}
|
return num;
|
}
|
|
public static Vector<String> getGasvc() {
|
return gasvc;
|
}
|
|
/**ÐèÒªÏÔʾµÄÆøÌåÄÚÈÝÊýÁ¿*/
|
public static int gasnum(){
|
int num=0;
|
if(gasvc !=null) {
|
num=kqvc.size();
|
}
|
return num;
|
}
|
|
}
|
