package engbs; import java.util.Vector; import BaoWen.Urt_7000_port; import DataBase.DatabaseManagement; import Method.GetNowTime; import PbuliClass.Get_Tb_Gass; import PbuliClass.Leds; import PbuliClass.Shi_jian_cha_sss; import PbuliClass.Systems; import fence.Fences; import fence.kaoqing.Dell_KaoQing; import fence.kaoqing.TbRealKaoQing; import person.Person; import person.person_Dell; import tag.Tag; import tag.Tag_Dell; import tbDataModel.TbGas; import tbDataModel.Tb_gps; import tbDataModel.Tb_led; import urt.Dell_gps; import urt.xytognss; public class engine_do { static boolean a=Systems.sys().getEng_bs().equals("1"); /**time 10·ÖÖÓ¸üÐÂÒ»´ÎµãÁÁÊý¾Ý*/ public static void tb_person(int time10) { //Èç¹û¿ªÆôÁË×÷ΪBSÒýÇæģʽ /*** * UPDATE tb_person SET p_x = CASE p_tagid * WHEN '3225' THEN '121' * WHEN '1222' THEN '1231' * WHEN '1233' THEN '41' * END, * p_y = CASE p_tagid * WHEN '3225' THEN '121' * WHEN '1222' THEN '1231' * WHEN '1233' THEN '41' * END * WHERE p_tagid IN ('3225','1222','1233')*/ //Èç¹ûʱ¼ä²î´óÓÚ60Ãë±íʾûÓÐÊý¾ÝÉÏÀ´ if(a) { Vector person_vector=person_Dell.getPerson_vector(); int size=person_vector.size(); if(size==0) { return; } StringBuffer sql=new StringBuffer("UPDATE tb_person SET "); StringBuffer sql2=new StringBuffer("UPDATE tb_realocation SET "); Vector vp_tagid=new Vector(); Vector vp_x=new Vector(); Vector vp_y=new Vector(); Vector vp_floor=new Vector(); Vector vp_sos=new Vector(); Vector vp_online=new Vector(); Vector vp_power=new Vector(); Vector vp_kaoqing=new Vector(); Vector vp_fence=new Vector(); Vector vp_fencename=new Vector(); Vector vp_kaoqqingname=new Vector(); Vector vp_addtiem=new Vector(); Vector vp_shipin=new Vector(); Vector vp_shipingname=new Vector(); Vector vp_baoliu2=new Vector();//¾­¶È Vector vp_baoliu3=new Vector();//γ¶È Vector vp_baoliu4=new Vector();//¸ß¶È Vector vp_baoliu6=new Vector(); Vector vp_baoliu5=new Vector();//±êÇ©ÀàÐÍ Vector vp_baoliu8=new Vector();//±êÇ©IPµØÖ· Vector vp_baoliu9=new Vector();//±êÇ©¶Ë¿Ú Vector vp_baoliu10=new Vector();//±êÇ©Ïà¶Ôº£°Î¸ß¶È Vector vp_baoliu13=new Vector();//GPSµ±Ç°×´Ì¬ Vector vp_baoliu14=new Vector();//GPS¾­¶È¶È·Ö¸ñʽ Vector vp_baoliu15=new Vector();//GPSά¶È¶È·Ö¸ñʽ Vector vp_baoliu16=new Vector();//ÐÄÂʸüРVector vp_baoliu20=new Vector();//ÊÇ·ñÔÚ½øß澯ÇøÓò1ÔÚ,0²»ÔÚ Vector vp_baoliu21=new Vector();//ÊÇ·ñÔÚ³öß澯ÇøÓò1ÔÚ£¬0²»ÔÚ Vector vp_baoliu22=new Vector();//XY½âµÄÀ´Ô´ Vector vp_baoliu23=new Vector();//±êÇ©µÄËÙ¶È if(size !=0) { for(int i=0;i zhi,String name,Vector tagid,String ziduan) { StringBuffer sql=new StringBuffer(name+"= CASE "+ziduan+" "); int size=tagid.size(); for (int i = 0; i < size; i++) { if (zhi.size()>0) { sql.append(" WHEN '" + tagid.get(i) + "' THEN '" + zhi.get(i) + "' "); }else { sql.append(" WHEN '" + tagid.get(i) + "' THEN '" + "-1" + "' "); } } sql.append(" END "); return sql.toString(); } public static String getlast(Vector tagid,String name) { StringBuffer sql=new StringBuffer("WHERE "+name+" IN ("); int size=tagid.size(); for(int i=0;i vgps_utc_time=new Vector(); Vector vgps_weidu=new Vector(); Vector vgps_NS=new Vector(); Vector vgsp_jingdu=new Vector(); Vector vgps_EW=new Vector(); Vector vgps_state=new Vector(); Vector vgps_num=new Vector(); Vector vgps_hdop=new Vector(); Vector vgps_haiba_gao=new Vector(); Vector vgps_tuoqiu=new Vector(); Vector vgps_chafen_time=new Vector(); Vector vgps_chafen_id=new Vector(); Vector vgps_jiaoyan=new Vector(); Vector vtagid=new Vector(); Vector vgps_power=new Vector(); Vector vgps_sos=new Vector(); Vector vccid=new Vector(); Vector vversion=new Vector(); Vector vaddtime=new Vector(); Vector vbaoliu2=new Vector(); Vector vadress=new Vector(); Vector gps_vector= Dell_gps.getGps_vector(); int size=gps_vector.size(); if(size !=0) { for(int i=0;i0) { sql.append(getinfo(vgps_utc_time,"gps_utc_time",vtagid,"tagid")+" , "); sql.append(getinfo(vgps_weidu,"gps_weidu",vtagid,"tagid")+" , "); sql.append(getinfo(vgps_NS,"gps_NS",vtagid,"tagid")+" , "); sql.append(getinfo(vgsp_jingdu,"gsp_jingdu",vtagid,"tagid")+" , "); sql.append(getinfo(vgps_EW,"gps_EW",vtagid,"tagid")+" , "); sql.append(getinfo(vgps_state,"gps_state",vtagid,"tagid")+" , "); sql.append(getinfo(vgps_num,"gps_num",vtagid,"tagid")+" , "); sql.append(getinfo(vgps_hdop,"gps_hdop",vtagid,"tagid")+" , "); sql.append(getinfo(vgps_haiba_gao,"gps_haiba_gao",vtagid,"tagid")+" , "); sql.append(getinfo(vgps_tuoqiu,"gps_tuoqiu",vtagid,"tagid")+" , "); sql.append(getinfo(vgps_chafen_id,"gps_chafen_id",vtagid,"tagid")+" , "); sql.append(getinfo(vgps_jiaoyan,"gps_jiaoyan",vtagid,"tagid")+" , "); if(time10==10) {//10·ÖÖÓ¸üÐÂÒ»´ÎµçÁ¿ sql.append(getinfo(vgps_power,"gps_power",vtagid,"tagid")+" , "); } if(vadress.size()!=0) { sql.append(getinfo(vadress,"adress",vtagid,"tagid")+" , "); } sql.append(getinfo(vgps_sos,"gps_sos",vtagid,"tagid")+" , "); sql.append(getinfo(vaddtime,"addtime",vtagid,"tagid")+" , "); sql.append(getinfo(vccid,"ccid",vtagid,"tagid")+" , "); sql.append(getinfo(vversion,"version",vtagid,"tagid")+" , "); sql.append(getinfo(vbaoliu2,"baoliu2",vtagid,"tagid")+" , "); sql.append(getinfo(vgps_chafen_time,"gps_chafen_time",vtagid,"tagid")+" "); sql.append(getlast(vtagid,"tagid")); DatabaseManagement.update(sql.toString()); sql.setLength(0);//Çå¿Õ } } } /**¸üÐÂtb_tag±êÇ©*/ public static void tb_tag() { Vector tag_vector =Tag_Dell.getTag_vector(); int size=tag_vector.size(); if(size !=0) { StringBuffer sql=new StringBuffer("UPDATE tb_tag SET "); Vector vtag_id=new Vector(); Vector vpower=new Vector(); Vector vstatus=new Vector(); Vector vgaodu=new Vector(); Vector vversion=new Vector(); Vector vpinglv=new Vector(); for(int i=0;i person_vector=person_Dell.getPerson_vector(); int size=person_vector.size(); if(size !=0) { StringBuffer sql=new StringBuffer("UPDATE tb_person SET "); StringBuffer sql2=new StringBuffer("UPDATE tb_realocation SET "); Vector vp_tagid=new Vector(); Vector vp_x=new Vector(); Vector vp_y=new Vector(); Vector vp_floor=new Vector(); Vector vp_sos=new Vector(); Vector vp_online=new Vector(); Vector vp_power=new Vector(); Vector vp_kaoqing=new Vector(); Vector vp_fence=new Vector(); Vector vp_fencename=new Vector(); Vector vp_kaoqqingname=new Vector(); Vector vp_addtiem=new Vector(); Vector vp_shipin=new Vector(); Vector vp_shipingname=new Vector(); for(int i=0;i rkq=Dell_KaoQing.getrealkaoqings(); Tb_led tb_led = Leds.get_tb_led(); if (tb_led==null){ return; } boolean aled=tb_led.getShow_distance().equals("1"); int size=rkq.size(); if(size !=0) { StringBuffer sql=new StringBuffer("UPDATE tb_realkaoqing SET "); Vector vcarea=new Vector(); Vector vcname=new Vector(); Vector vcbumen=new Vector(); Vector vctagid=new Vector(); Vector vcintime=new Vector(); Vector vcjuli=new Vector(); Vector vcbaoliu1=new Vector(); for(int i=0;i TbGass=Get_Tb_Gass .get_gass(); int size=TbGass.size(); if(size !=0) { StringBuffer sql=new StringBuffer("UPDATE tb_gas SET "); Vector vcid=new Vector(); Vector vcnong_du=new Vector(); Vector vcstatus=new Vector(); Vector vcaddtime=new Vector(); for(int i=0;i5) {//Èç¹ûʱ¼ä²î´óÓÚ5Ãë int x5=ps.getPosx5s();//±êÇ©5ÃëÇ°µÄx×ø±ê int y5=ps.getPosy5s();//±êÇ©5ÃëÇ°µÄy×ø±ê sudu=(x-x5)+","+(y-y5); ps.setPosx5s(x); ps.setPosy5s(y); ps.setLast5s(GetNowTime.now()); } } } return sudu; } }