package Frame;
import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Component;
import java.awt.Container;
import java.awt.Dimension;
import java.awt.Toolkit;
import java.awt.event.*;
import java.util.Iterator;
import java.util.Vector;
import javax.swing.Box;
import javax.swing.ButtonGroup;
import javax.swing.ImageIcon;
import javax.swing.JDialog;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JRadioButton;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.event.InternalFrameEvent;
import javax.swing.event.InternalFrameListener;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableCellRenderer;
import javax.swing.table.TableColumn;
import ColorAndFont.NothJPanel;
import ColorAndFont.UIColor;
import ColorAndFont.buttonTitle;
import DataBase.DatabaseManagement;
import Judge.JugeNumber;
import Method.BaoWenShow;
import Method.GetNowTime;
import PbuliClass.DownloadFile;
import PbuliClass.ImExport;
import PbuliClass.JButtonModel;
import PbuliClass.JCheckBoxModel;
import PbuliClass.JlableModel;
import PbuliClass.OutButton;
import PbuliClass.ShowMessage;
import PbuliClass.Systems;
import PbuliClass.WarningMessage;
import PbuliClass.greateTables;
import PbuliClass.jinternalFrame;
import anchor.Anchor;
import anchor.Anchor_Dell;
import anchor.Anchor_nerby_dell;
import tbDataModel_Dell.Dell_TongbuAnchor;
import tbDataModel_Dell.Dell_tb_gas_anchor;
import tbDataModel_Dell.Dell_tb_suanfa2;
import tbDataModel_Dell.Dell_tbcengzu;

@SuppressWarnings("rawtypes")
/**´ËÀàÓÃÓÚ»ùÕ¾¹ÜÀí*/
public class AnchorManage extends jinternalFrame {
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	jinternalFrame jinerFrame=null;
	JInternalFrame jinFrame=null;	
	JPanel innerPanel=null;//ÄÚ²¿´°ÌåÃæ°å
	NothJPanel northPanel=null;//±±²¿Ãæ°å
	JPanel centerPanel=null;//Öв¿Ãæ°å
	JTextField searchFileld=null;//ËÑË÷Îı¾¿ò
	JButtonModel search=null;//ËÑË÷°´Å¥
	JButtonModel shuaxin=null;//ˢа´Å¥
	JButtonModel add=null;//ÐÂÔö°´Å¥
	JButtonModel alter=null;//Ð޸İ´Å¥
	JButtonModel delete=null;//ɾ³ý°´Å¥
	JButtonModel deleteAll=null;//È«²¿É¾³ý°´Å¥
	JButtonModel enterPort=null;//µ¼ÈëÈËÔ±°´Å¥
	JButtonModel download=null;//Ä£°åÏÂÔØ°´Å¥
	JButtonModel Jbt_openwangye=null;//´ò¿ªÍøÒ³
	JScrollPane gd=null;//¹ö¶¯Ãæ°å
	static JTable table=null;//ÉêÃ÷±í¸ñ	
	Vector rowData=null;
	DefaultTableModel tableModel=null;//ÉùÃ÷±í¸ñÄ£ÐÍ
	int selectedRow;//±»Ñ¡ÖеÄÐÐ	
	Vector<String> columnName;
	Container rq;
	AddAchorDialog addachdialog=null;
	String zaixian="image/anchor/anchoron.png";
	String lixian="image/anchor/anchoroff.png";
	static String choose_anchor="0";//±»Ñ¡ÖеĻùÕ¾id
	static boolean open=false;



	public AnchorManage() {//¹¹Ôì·½·¨
		this.setTitle(buttonTitle.getAnchorManage());
		rowData=new Vector();
		this.setFrameIcon(new ImageIcon("image/icon/anchoricon.png"));//ÉèÖô°Ìåͼ±ê
		rq=getContentPane();//»ñÈ¡ÈÝÆ÷
		rq.setLayout(new BorderLayout());
		rq.setBackground(UIColor.getNorth_color());
		rq.add(getNorthPanel(),BorderLayout.NORTH);
		rq.add(getGd(),BorderLayout.CENTER);
		open=true;		
		this.addInternalFrameListener(new InternalFrameListener() {

			@Override
			public void internalFrameOpened(InternalFrameEvent e) {	

			}

			@Override
			public void internalFrameIconified(InternalFrameEvent e) {
			}

			@Override
			public void internalFrameDeiconified(InternalFrameEvent e) {				
			}

			@Override
			public void internalFrameDeactivated(InternalFrameEvent e) {				
			}

			@Override
			public void internalFrameClosing(InternalFrameEvent e) {
				open=false;
				choose_anchor="0";
				table=null;
			}

			@Override
			public void internalFrameClosed(InternalFrameEvent e) {
			}

			@Override
			public void internalFrameActivated(InternalFrameEvent e) {
			}
		});
		this.setBounds(175,0,1000,610);

	}


	/**»ñÈ¡±±²¿Ãæ°åµÄ·½·¨*/	
	public NothJPanel getNorthPanel() {
		if(northPanel==null) {
			northPanel=new NothJPanel();
			Box topicBox = Box.createHorizontalBox();// ´´½¨Ò»¸öˮƽÏäÈÝÆ÷
			topicBox.add(getSearchFileld());//Ìí¼ÓËÑË÷Îı¾¿ò
			topicBox.add(Box.createHorizontalStrut(3));// Ìí¼ÓÒ»¸ö3ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getSearch());//Ìí¼ÓËÑË÷°´Å¥
			topicBox.add(Box.createHorizontalStrut(10));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getShuaxin());//Ìí¼Óˢа´Å¥
			topicBox.add(Box.createHorizontalStrut(10));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getAdd());//Ìí¼ÓÐÂÔö°´Å¥
			topicBox.add(Box.createHorizontalStrut(10));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getAlter());//Ìí¼ÓÐ޸İ´Å¥
			topicBox.add(Box.createHorizontalStrut(10));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getDelete());//Ìí¼Óɾ³ý°´Å¥
			topicBox.add(Box.createHorizontalStrut(10));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getDeleteAll());//Ìí¼Óɾ³ýÈ«²¿°´Å¥
			topicBox.add(Box.createHorizontalStrut(10));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getEnterPort());//Ìí¼Óµ¼Èë
			topicBox.add(Box.createHorizontalStrut(10));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getOutport());//Ìí¼Óµ¼³ö±í¸ñ°´Å¥
			topicBox.add(Box.createHorizontalStrut(10));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù			
			topicBox.add(getJbt_openwangye());
			topicBox.add(Box.createHorizontalStrut(10));
			topicBox.add(getDownload());//Ìí¼ÓÏÂÔØÄ£°å°´Å¥
			northPanel.add(topicBox );
		}
		return northPanel;
	}


	/**»ñÈ¡Öв¿Ãæ°åµÄ·½·¨*/	
	public JPanel getCenterPanel() {
		if(centerPanel==null) {
			centerPanel=new JPanel();
			centerPanel.add(getGd());//Ìí¼Ó¹ö¶¯Ãæ°å
			centerPanel.setBackground(UIColor.getNorth_color());

		}
		return centerPanel;
	}
	/**»ñÈ¡ËÑË÷Îı¾¿òµÄ·½·¨*/
	public JTextField getSearchFileld() {
		if(searchFileld==null){
			searchFileld=new JTextField(10);
			searchFileld.addKeyListener(new KeyListener() {	//¼üÅÌʼþ¼àÌý				
				public void keyTyped(KeyEvent e) {				

				}					
				public void keyReleased(KeyEvent e) {
					int keyCode=e.getKeyCode();
					if(keyCode==KeyEvent.VK_ENTER) {
						getSearch().doClick();//ËÑË÷°´Å¥±»µã»÷
					}						
				}					
				public void keyPressed(KeyEvent e) {					

				}
			});

		}
		return searchFileld;
	}


	/**»ñÈ¡ËÑË÷°´Å¥µÄ·½·¨*/	
	public JButtonModel getSearch() {
		if(search==null){
			search=new JButtonModel(buttonTitle.getSerch());
			search.addActionListener(new ActionListener() {	

				public void actionPerformed(ActionEvent e) {
					if(getSearchFileld().getText().length()>=1) {
						String serch=getSearchFileld().getText().trim();
						updateSerch(serch);	
					}
				}
			});

		}
		return search;
	}

	/**»ñȡˢа´Å¥µÄ·½·¨*/	
	public JButtonModel getShuaxin() {
		if(shuaxin==null){
			shuaxin=new JButtonModel(buttonTitle.getRefresh());
			shuaxin.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					updateTable() ;
				}
			});

		}
		return shuaxin;
	}



	/**»ñÈ¡ÐÂÔö°´Å¥µÄ·½·¨*/	
	public JButtonModel getAdd() {
		if(add==null){
			add=new JButtonModel(buttonTitle.getAddOne());
			add.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					if(addachdialog==null) {
						addachdialog=new AddAchorDialog("ÐÂÔö»ùÕ¾¶Ô»°¿ò");
					}
				}
			});

		}
		return add;
	}


	/**»ñÈ¡±í¸ñ±»Ñ¡ÖеÄÐз½·¨*/	
	public int getSelectedRow() {
		selectedRow=getTable().getSelectedRow();		
		return selectedRow;

	}

	/**»ñÈ¡Ð޸İ´Å¥µÄ·½·¨*/	
	public JButtonModel getAlter() {


		if(alter==null){
			alter=new JButtonModel(buttonTitle.getAlert());
			alter.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					if(getSelectedRow()  !=-1) {//Èç¹ûÑ¡ÖеÄÐв»Îª¿Õ
						new alertDiolog("Ð޸ĻùÕ¾¶Ô»°¿ò");

					}
					else {
						ShowMessage.zidingyi("ÇëÏÈÑ¡ÖÐÐèÒªÐ޸ĵÄÐÐ!");
						return;
					}

				}
			}); 
		}
		return alter;
	}

	/**»ñȡɾ³ý°´Å¥µÄ·½·¨*/	
	public JButtonModel getDelete() {
		if(delete==null){
			delete=new JButtonModel(buttonTitle.getDelete());
			delete.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					int[] selectedRows=table.getSelectedRows();//±»Ñ¡ÖÐÐеÄË÷Òý¼¯ºÏ
					if(selectedRows.length ==0) {
						ShowMessage.zidingyi("ÇëÑ¡ÖÐÐèҪɾ³ýµÄÐУ¡");	
						return;
					}

					if(selectedRows.length !=0) {
						for(int i=0;i<selectedRows.length;i++){	
							String anchorid=(String) table.getValueAt(selectedRows[i], 1);
							String deleteSql="DELETE FROM tb_achor WHERE anchorid='"+anchorid+"'";	
							String deleteSql2="DELETE FROM tb_suanfa WHERE anchorid='"+anchorid+"'";	
							if(DatabaseManagement.update(deleteSql) !=0) {
								DatabaseManagement.update(deleteSql2);//ɾ³ýËã·¨ÖбíÖеÄÉ豸
								Anchor_Dell.remov_anchor(anchorid);//ɾ³ý»ùÕ¾¼¯ºÏÖеĻùÕ¾
								Anchor_nerby_dell.delete_anchorby(anchorid);//ɾ³ýÁÙ½ü»ùÕ¾								
								Dell_TongbuAnchor.delete_rootanchor(anchorid);//ɾ³ýͬ²½»ùÕ¾
								//ɾ³ýËùÓб»Ñ¡ÖеÄÐÐ								
							}
						}

						//ɾ³ýËùÓб»Ñ¡ÖеÄÐÐ
						for(int j=selectedRows.length-1;j>=0;j--){//ÕâÊǹؼü´úÂë
							tableModel.removeRow(selectedRows[j]);//ɾ³ýÈÎÒⱻѡÖÐÐÐ
						}
						table.setModel(tableModel);//¸üбí¸ñÄ£ÐÍ
						ShowMessage.zidingyi(selectedRows.length+"Ìõ¼Ç¼ɾ³ý³É¹¦£¡");	//ɾ³ý³É¹¦ÌáʾÐÅÏ¢			
					}
				}
			});

		}
		return delete;
	}


	/**»ñÈ¡È«²¿É¾³ý°´Å¥µÄ·½·¨*/	
	public JButtonModel getDeleteAll() {
		if(deleteAll==null){
			deleteAll=new JButtonModel(buttonTitle.getDeleteall());
			deleteAll.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					if(table.getRowCount()==0) {
						ShowMessage.zidingyi("Êý¾Ý¿âΪ¿Õ£¡");
						return;
					}
					//Ñ¡Ôñ¶Ô»°¿òÈçyes·µ»Ø0£¬NO·µ»Ø1£¬È¡Ïû·µ»Ø2
					WarningMessage warning=new WarningMessage();
					warning.setMessage("±í¸ñÊý¾Ý½«±»È«²¿É¾³ýÈ·¶¨Âð£¿");
					int warn=warning.getwarMss(getCenterPanel());
					if( warn==0) {																
						String deleteSql="TRUNCATE TABLE tb_achor";	//ɾ³ýËùÓб»ÐÐ
						String deleteSql2="TRUNCATE TABLE tb_suanfa";	//ɾ³ýËùÓб»ÐÐ
						Anchor_Dell.removall_anchor();
						ShowMessage.deleteAll(DatabaseManagement.update(deleteSql));//ɾ³ýÊý¾Ý¿âÖеÄËùÓÐÊý¾Ý
						DatabaseManagement.update(deleteSql2);//ɾ³ýËã·¨±íÖеÄËùÓÐÊý¾Ý
						Anchor_nerby_dell.delete_all_anchorby();//ɾ³ýËùÓÐÁÙ½ü»ùÕ¾						
						Dell_TongbuAnchor.delete_all_rootanchor();//ɾ³ýËùÓÐͬ²½»ùÕ¾Êý¾Ý

						//ɾ³ý±í¸ñÖеÄËùÓÐÐÐ
						int a = table.getRowCount();
						for (int i = 0; i < a; i++) {
							tableModel.removeRow(0);
						}
						rq.repaint();
					}
				}
			});

		}
		return deleteAll;
	}
	/**»ñÈ¡µ¼Èë»ùÕ¾°´Å¥µÄ·½·¨*/	
	public JButtonModel getEnterPort() {
		if(enterPort==null){
			enterPort=new JButtonModel(buttonTitle.getImport());
			enterPort.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					new ImExport().excelAnchorToMysql(getNorthPanel());
					updateTable();//ˢбí¸ñ 
				}
			});

		}
		return enterPort;
	}
	/**»ñÈ¡µ¼³ö±í¸ñ°´Å¥µÄ·½·¨*/	
	public JButtonModel getOutport() {
		OutButton.setAddtime("GreateTime");
		OutButton.setDataName("tb_achor");
		return new OutButton().get_ouotport_button();
	}
	/**»ñÈ¡ÏÂÔØÄ£°å°´Å¥µÄ·½·¨*/	
	public JButtonModel getDownload() {
		if(download==null){
			download=new JButtonModel(buttonTitle.getTemplate());
			download.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {;
				DownloadFile dw=new DownloadFile();
				dw.downAnchorFile(getNorthPanel());

				}
			});

		}
		return download;
	}

	/**»ñÈ¡¹ö¶¯Ãæ°åµÄ·½·¨*/	
	public JScrollPane getGd() {
		if(gd==null){
			gd=new JScrollPane();
			gd.getViewport().setBackground(UIColor.getNorth_color());
			gd.setViewportView(getTable());

		}
		return gd;
	}


	/**Ìí¼Ó±í¸ñÐÐÏòÁ¿Êý¾Ý·½·¨*/
	@SuppressWarnings("unchecked")
	public void getRowData( Vector<Anchor> vc ) {
		Iterator<Anchor> iterator = vc.iterator();//´´½¨µü´úÆ÷		
		while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ			
			Anchor anchor=  iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½list¼¯ºÏ
			Vector row = new Vector();
			row.add(anchor.getImgicon());
			row.add(anchor.getAnc_id());// »ùÕ¾ID
			row.add(anchor.getAnc_x());// X×ø±ê
			row.add(anchor.getAnc_y());// Y×ø±ê
			row.add(anchor.getAnc_z());// Z×ø±ê
			row.add(anchor.getAnc_floor());// ²ã	
			row.add(anchor.getAnc_zu());// ×é
			String name=anchor.getAnc_distance();
			row.add(name);// Á¿³Ì			
			row.add(anchor.getAnchorzhuangtai());//»ùվͬ²½×´Ì¬
			row.add(anchor.getAnc_ip());// »ùÕ¾ip
			row.add(anchor.getPort());// »ùÕ¾port
			row.add(anchor.getVersion());//»ùÕ¾°æ±¾
			if(Dell_tb_suanfa2.isJuli_juge_in()) {//Èç¹û¿ªÆôͨ¹ý¾àÀëÅжÏÊÒÄÚÍâ				
				row.add(anchor.getBaoliu5()+"");
			}else {
				row.add("ÎÞ");
			}
			if(Systems.isWuxian()) {
				row.add(anchor.getBaoliu8());

			}

			row.add(anchor.getAnc_cteatetime());//¸üÐÂʱ¼ä
			if(Systems.isWuxian()) {
				row.add(anchor.getBaoliu9());
			}

			String baoliu4 = anchor.getBaoliu4();//±ØÐë¾­¹ýµÄ¾àÀë
			if ("".equals(baoliu4)){
				baoliu4="ÎÞ";
			}


			row.add(baoliu4);
			if(Systems.isWuxian()) {
				row.add(anchor.getBaoliu10());
				row.add(anchor.getBaoliu11());
			}
			tableModel.addRow(row);
		}
	}


	/**»ñÈ¡»ùÕ¾±í¸ñµÄ·½·¨*/	
	@SuppressWarnings("serial")
	public JTable getTable() {
		if(table==null) {
			String name1="״̬";
			String name2="񅧏";
			String name3="X×ø±ê";
			String name4="Y×ø±ê";
			String name5="Z×ø±ê";
			String name6="²ã";
			String name7="×é";
			String name8="Á¿³Ì";
			String name9="ͬ²½";
			String name10="IP";
			String name11="¶Ë¿Ú";
			String name12="°æ±¾";
			String name13="ÅжϾàÀë";
			String name14="µçÁ¿";
			String name16="ÎÞÏß¾àÀë";
			String name15="ʱ¼ä";
			String name17="±Ø¾­¾àÀë";
			String name18="¹¦ÂÊ";
			String name19="ͨѶ×é";
			if(Systems.sys().getLanguage().equals("English")) {
				name1="Status";
				name2="AnchorId";
				name3="X(cm)";
				name4="Y(cm)";
				name5="Z(cm)";
				name6="Layer";
				name7="Group";
				name8="Range";
				name9="Synchronization";
				name10="ip";
				name11="port";
				name12="Version";
				name13="juli";
				name14="power";
				name15="addtime";
				name16="wirelessDistance";
				name17="mustPassDistance";
				name18="power";
				name19="communicate Group";
			}
			//Ìí¼Ó±í¸ñÁÐÏòÁ¿
			String[] columnNames= {name1,name2,name3,name4,name5,name6,name7,
					name8,name9,name10,name11,name12,name13,name15,name17};//±í¸ñÁÐÃû
			String[] columnNames2= {name1,name2,name3,name4,name5,name6,name7,
					name8,name9,name10,name11,name12,name13,name14,name15,name16,name17,name18,name19};//±í¸ñÁÐÃû

			columnName=new Vector<>();
			if(Systems.isWuxian()) {//ϵͳ¿ªÆô»ùÕ¾ÎÞÏßģʽ
				for(int i=0;i<columnNames2.length;i++){
					columnName.add(columnNames2[i]);			
				}
			}else {
				for(int i=0;i<columnNames.length;i++){
					columnName.add(columnNames[i]);			
				}
			}
			greateTables tables=new greateTables();
			tableModel=new DefaultTableModel(rowData, columnName){  
				//  ʵÏÖÈÃÕû¸ö±í¸ñ²»²»ÔÊÐí±»±à¼­
				public boolean isCellEditable(int row,int column){  
					return false;  
				}  
			};

			table=tables.getTable(tableModel);	
			getRowData( Anchor_Dell.getAnchor_vector());

			//table.setRowSorter(new TableRowSorter<>(tableModel));//ÉèÖÃÅÅÐòÆ÷
			table.getColumnModel().getColumn(0).setPreferredWidth(40);
			table.getColumnModel().getColumn(2).setPreferredWidth(70);
			table.getColumnModel().getColumn(3).setPreferredWidth(70);
			table.getColumnModel().getColumn(4).setPreferredWidth(70);
			table.getColumnModel().getColumn(5).setPreferredWidth(45);
			table.getColumnModel().getColumn(6).setPreferredWidth(45);
			table.getColumnModel().getColumn(7).setPreferredWidth(60);
			table.getColumnModel().getColumn(8).setPreferredWidth(45);
			table.getColumnModel().getColumn(9).setPreferredWidth(100);
			table.getColumnModel().getColumn(10).setPreferredWidth(50);
			TableColumn column = table.getColumnModel().getColumn(0);// »ñÈ¡±í¸ñµÚ7ÁжÔÏó
			column.setCellRenderer(new TableCellRenderer() {// ÉèÖõÚ6ÁеÄäÖȾÆ÷                
				public Component getTableCellRendererComponent(
						JTable table, Object value, boolean isSelected,
						boolean hasFocus, int row, int column) {
					ImageIcon icon = (ImageIcon) value;
					JLabel label = new JLabel(icon);// ´´½¨Í¼±ê
					// °ÑÑ¡ÔñµÄ±êÇ©ÉèÖÃΪ͸Ã÷					
					label.setOpaque(true);					

					if (row % 2 == 0) {
						label.setBackground(UIColor.getTable_1());
					} else {
						label.setBackground(UIColor.getTable_2());
					}

					if(isSelected) {
						label.setBackground(UIColor.getTable_sekected());	
					}

					return label;// °Ñͼ±ê×÷ΪΪäÖȾ¿Ø¼þ
				}
			});
			
			/**±í¸ñÌí¼ÓÊó±êµã»÷¼àÌý*/
			 table.addMouseListener(new MouseAdapter() {	 				
	                public void mouseClicked(MouseEvent e) {
	                    int row = table.getSelectedRow();
	                    String anchorid=(String) table.getValueAt(row, 1);
						int b1=Anchor_Dell.get_anchor(anchorid).getDis_err_num();
						String a1=anchorid+"²â¾àÒì³£"+b1+"´Î";
						BaoWenShow.showmust(a1);
	                }
	            });
		}

		return table;

	}

	/**ˢбí¸ñ·½·¨*/
	public void updateTable() {	
		if(tableModel !=null) {
			tableModel.getDataVector().clear();
			getRowData( Anchor_Dell.getAnchor_vector());
			gd.validate();
		}
	}


	/**ËÑË÷·½·¨*/
	public void updateSerch(String anchorid) {	
		if(Anchor_Dell.serch_anchor(anchorid)==null) {
			ShowMessage.zidingyi("ÄãËÑË÷µÄ»ùÕ¾"+anchorid+"²»´æÔÚ...");
			return;
		}
		int tagnum=table.getRowCount();//±í¸ñ×ÜÐÐÊý
		if(tagnum >0 ) {
			for (int i = 0; i < tagnum; i++) {//ɾ³ýËùÓÐÐÐ
				tableModel.removeRow(0);							
			}
			//½«ÁбíÖÐËùÓнá¹û¼¯¸øµ½list¼¯ºÏ
			getRowData(Anchor_Dell.serch_anchor(anchorid));
		}

	}


	/**ÐÂÔö»ùÕ¾¶Ô»°¿ò*/
	class AddAchorDialog extends JDialog implements WindowListener{

		/**
		 * 
		 */
		private static final long serialVersionUID = 1L;
		JlableModel  anchorId=new JlableModel("»ùÕ¾µÄ±àºÅID:");//»ùÕ¾id	
		JlableModel  posx=new JlableModel("»ùÕ¾X×ø±ê(cm):");//x×ø±ê
		JlableModel  posy=new JlableModel("»ùÕ¾Y×ø±ê(cm):");//y×ø±ê
		JlableModel  posz=new JlableModel("»ùÕ¾Z×ø±ê(cm):");//z×ø±ê
		JlableModel  layer=new JlableModel("»ùÕ¾ËùÔÚ²ã:");//²ã
		JlableModel  anc_zu_jl=new JlableModel("»ùÕ¾ËùÔÚ×é:");
		JlableModel  anc_liangcheng_jl=new JlableModel("»ùÕ¾µÄÁ¿³Ì(cm):");		
		JlableModel  anchorState=new JlableModel("»ùÕ¾µÄ״̬:");//»ùվ״̬
		JlableModel  ipAdress=new JlableModel("»ùÕ¾µÄµØÖ·:");//ipµØÖ·
		JlableModel  jl_juli=new JlableModel("ÅжÏÊÒÄÚ¾àÀë:");//ͨ¹ý¾àÀëÅжϱêÇ©ÊÇ·ñÔÚÊÒÄÚ
		JlableModel  jl_distance=new JlableModel("»ùվУ׼¾àÀë(cm):");//ÎÞÏßģʽÏ»ùÕ¾µÄ¾àÀë
		JlableModel  jl_sanwei=new JlableModel("Æøѹ²Î¿¼»ùÕ¾ID:");//ÎÞÏßģʽÏ»ùÕ¾µÄ¾àÀë


		JButtonModel serchTag=null;//²éÕÒ±êÇ©
		JButtonModel sure=null;//È·¶¨°´Å¥
		JButtonModel quxiao=null;//È¡Ïû°´Å¥
		JRadioButton online=null;//µ¥Ñ¡°´»ùÕ¾ÔÚÏß
		JRadioButton offline=null;//µ¥Ñ¡°´Å¥»ùÕ¾ÀëÏß
		ButtonGroup btgroup=null;//ÉêÃ÷°´Å¥×é
		JTextField anchorIdFile=null;//»ùÕ¾idÎı¾¿ò
		JTextField posxFile=null;//x×ø±êÎı¾¿ò
		JTextField posyFile=null;//y×ø±êÎı¾¿ò
		JTextField poszFile=null;//z×ø±êÎı¾¿ò
		JTextField layerFile=null;//²ãÎı¾¿ò
		JTextField ipAdressFile=null;//»ùÕ¾ipµØÖ·Îı¾¿ò
		JTextField anc_zu_jt=new JTextField("¶à·Ö×éÓÃ;·Ö¸ô(ĬÈÏΪ0)");//»ùÕ¾×éÎı¾¿ò
		JTextField anc_liangcheng_jt=new JTextField("¶àÁ¿³ÌÓÃ;·Ö¸ô(ĬÈÏ100000)");//»ùÕ¾µÄÁ¿³Ì
		JTextField jt_juli=new JTextField("¾àÀ뵥λ:cm(ĬÈÏΪ0)");//ÅжÏÔÚÊÒÄÚ¾àÀë
		JTextField jt_distance=new JTextField("¾àÀ뵥λ:cm(ĬÈÏΪ0)");//ÎÞÏß»ùÕ¾¾àÀëÎı¾¿ò
		JTextField jt_sanwei=new JTextField();//°ó¶¨²Î¿¼µÄÆøѹ»ùÕ¾
		String anchormode="0";

		JPanel mb=null;//ÉêÃ÷Ò»¸öÃæ°å
		JlableModel Jl_tip1=new JlableModel("");
		JlableModel Jl_tip2=new JlableModel("");
		JlableModel Jl_tip3=new JlableModel("¾àÀ뵥λ£ºcm");
		JlableModel Jl_tip4=new JlableModel("¾àÀ뵥λ£ºcm");

		//¿ç²ã×鸴ѡ¿ò
		JCheckBoxModel Jck_kcz=null;

		/**¹Ø±Õ¶Ô»°¿ò·½·¨*/
		public void closeTagDialog() {
			this.dispose();
			addachdialog=null;

		}
		/**»ñÈ¡¶Ô»°¿ò·½·¨*/
		public AddAchorDialog(String title) {		
			super();
			this.setAlwaysOnTop(true);//×ÜÊÇÖö¥
			this.setTitle(title);
			Toolkit toolkit = getToolkit();// »ñµÃ´°Ì幤¾ß°ü
			Dimension screenSize = toolkit.getScreenSize();// »ñÈ¡ÆÁÄ»´óС
			int width = (int) (screenSize.width* 0.5);// ¼ÆËã´°Ìåпí¶È
			int height = (int) (screenSize.height * 0.5);// ¼ÆËã´°Ìåпí¶È
			int w=600;
			int h=540;
			int x0=width-w/2;//´°Ìåx0×ø±ê
			int y0=height-h/2;//´°Ìåy0×ø±ê
			Container rq=getContentPane();		
			rq.add(getMb());
			this.setBounds(x0, y0,w,h);
			this.addWindowListener((WindowListener) this);
			this.setVisible(true);
		}

		/**»ñÈ¡Ãæ°å*/
		public JPanel getMb() {
			if(mb==null){
				mb=new JPanel();
				mb.setLayout(null);
				mb.setBackground(Color.white);
				int x=50;
				int y=10;
				int h=30;
				int l1=160;
				int x2=x+l1;
				int l2=200;
				int j=15;

				mb.add(jl_juli);
				mb.add(getJt_juli());

				anchorId.setBounds(x,y, l1, h);
				getAnchorIdFile().setBounds(x2,y, l2, h);

				posx.setBounds(x,y+1*(h+j), l1, h);
				getPosxFile().setBounds(x2,y+1*(h+j),l2, h);

				posy.setBounds(x,y+2*(h+j), l1, h);
				getPosyFile().setBounds(x2,y+2*(h+j),l2, h);

				posz.setBounds(x,y+3*(h+j), l1, h);
				getPoszFile().setBounds(x2,y+3*(h+j),l2, h);

				layer.setBounds(x,y+4*(h+j), l1, h);
				getLayerFile().setBounds(x2,y+4*(h+j),l2, h);

				anc_zu_jl.setBounds(x,y+5*(h+j), l1, h);
				getAnc_zu_jt().setBounds(x2,y+5*(h+j),l2, h);
				//Jl_tip1.setBounds(x2+l2+10,y+5*(h+j),100, h);

				anc_liangcheng_jl.setBounds(x,y+6*(h+j), l1, h);
				getAnc_liangcheng_jt().setBounds(x2,y+6*(h+j),l2, h);
				//Jl_tip2.setBounds(x2+l2+10,y+6*(h+j),100, h);

				ipAdress.setBounds(x,y+7*(h+j), l1, h);
				getIpAdressFile().setBounds(x2,y+7*(h+j),l2, h);

				//ͨ¹ý»ùÕ¾¾àÀëÅжÏÊÇ·ñÔÚÊÒÄÚ
				int y8=y+8*(h+j);
				int y9=y8;

				if(Dell_tb_suanfa2.isJuli_juge_in()) {//ͨ¹ý»ùÕ¾¾àÀëÅжÏÊÇ·ñÔÚÊÒÄÚ
					jl_juli.setBounds(x,y8,l1, h);
					jt_juli.setBounds(x2,y8,l2, h);
					//Jl_tip4.setBounds(x2+l2+10,y8,100, h);
					y9=y8+h+j;
				}
				int y10=y9;
				if(Systems.isWuxian()){
					mb.add(jl_distance);
					mb.add(getJt_distance());
					jl_distance.setBounds(x,y9,l1,h);
					jt_distance.setBounds(x2,y9,l2,h);
					//Jl_tip3.setBounds(x2+l2+10,y9,100, h);
					y10=y9+h+j;
				}

				int y11=y10;
				if(Systems.isIssanwei()) {//Èç¹ûϵͳ¿ªÆôÈýά¶¨Î»Ä£Ê½
					mb.add(jl_sanwei);
					mb.add(jt_sanwei);
					jl_sanwei.setBounds(x,y11,l1,h);
					jt_sanwei.setBounds(x2,y11,l2,h);
					y11=y10+h+j;
				}
				int y12=y11;
				getSure().setBounds(x,y12,l1-20, h);//±£´æ°´Å¥
				getQuxiao().setBounds(x2,y12,l2, h);//È¡Ïû°´Å¥


				mb.add(anchorId);
				mb.add(anchorIdFile);
				mb.add(posx);
				mb.add(posxFile);
				mb.add(posy);
				mb.add(posyFile);
				mb.add(posz);
				mb.add(poszFile);
				mb.add(layer);
				mb.add(layerFile);
				mb.add(anc_zu_jl);
				mb.add(anc_zu_jt);
				mb.add(anc_liangcheng_jl);
				mb.add(anc_liangcheng_jt);
				mb.add(ipAdress);
				mb.add(ipAdressFile);
				mb.add(getSure());
				mb.add(getQuxiao());

				if (Systems.isWuxian()){
					mb.add(jt_distance);
				}


			}

			return mb;
		}



		public JTextField getAnchorIdFile() {
			if(anchorIdFile==null) {
				anchorIdFile=new JTextField(10);
			}

			return anchorIdFile;
		}
		public JTextField getPosxFile() {
			if(posxFile==null) {
				posxFile=new JTextField(10);
			}

			return posxFile;
		}
		public JTextField getPosyFile() {
			if(posyFile==null) {
				posyFile=new JTextField(10);
			}
			return posyFile;
		}

		/**»ñÈ¡Z×ø±êµÄÎı¾¿ò*/
		public JTextField getPoszFile() {
			if(poszFile==null) {
				poszFile=new JTextField(10);
			}

			return poszFile;
		}
		public JTextField getLayerFile() {
			if(layerFile==null) {
				layerFile=new JTextField(10);
				layerFile.setText("0");
			}
			return layerFile;
		}
		public JTextField getIpAdressFile() {
			if(ipAdressFile==null) {
				ipAdressFile=new JTextField(10);
			}
			return ipAdressFile;
		}


		public JTextField getAnc_zu_jt() {
			anc_zu_jt.addFocusListener(new FocusAdapter() {
				@Override
				public void focusGained(FocusEvent e) {
					if ("¶à·Ö×éÓÃ;·Ö¸ô(ĬÈÏΪ0)".equals(anc_zu_jt.getText())){
						anc_zu_jt.setText("0");
					}
				}
			});
			return anc_zu_jt;
		}


		public JTextField getAnc_liangcheng_jt() {
			anc_liangcheng_jt.addFocusListener(new FocusAdapter() {
				@Override
				public void focusGained(FocusEvent e) {
					if ("¶àÁ¿³ÌÓÃ;·Ö¸ô(ĬÈÏ100000)".equals(anc_liangcheng_jt.getText())){
						anc_liangcheng_jt.setText("0");
					}
				}
			});
			return anc_liangcheng_jt;
		}

		public JTextField getJt_juli() {
			jt_juli.addFocusListener(new FocusAdapter() {
				@Override
				public void focusGained(FocusEvent e) {
					if ("¾àÀ뵥λ:cm(ĬÈÏΪ0)".equals(jt_juli.getText())){
						jt_juli.setText("0");
					}
				}
			});
			return jt_juli;
		}
		public JTextField getJt_distance() {
			jt_distance.addFocusListener(new FocusAdapter() {
				@Override
				public void focusGained(FocusEvent e) {
					if ("¾àÀ뵥λ:cm(ĬÈÏΪ0)".equals(jt_distance.getText())){
						jt_distance.setText("0");
					}
				}
			});


			return jt_distance;
		}



		/**»ñÈ¡È·¶¨°´Å¥*/
		public JButtonModel getSure() {
			if(sure==null) {
				sure=new JButtonModel("È·¶¨");
				sure.addActionListener(new ActionListener() {
					public void actionPerformed(ActionEvent e) {						
						setUpadateSql();//ÐÞ¸ÄÊý¾Ý¿â»ùÕ¾±í¸ñ
					}
				});
			}

			return sure;
		}

		/**ÐÞ¸ÄÊý¾Ý¿â±í±í¸ñ*/
		@SuppressWarnings("unchecked")
		public void setUpadateSql(){
			// Ö´ÐÐSQL²éѯÓï¾ä»ñµÃµÄ½á¹û¼¯Èç¹û»ùÕ¾IDÒѾ­´æÔÚÔò²»ÔÙÖ´ÐÐÏÂÃæµÄÓï¾ä

			String anchorid=anchorIdFile.getText().replaceAll(" ", "");
			anchorid=anchorid.toUpperCase();//תΪ´óд×Öĸ
			String POSX=posxFile.getText().trim();
			String POSY=posyFile.getText().trim();
			String POSZ=poszFile.getText().trim();
			String layer=layerFile.getText().trim();
			String zu=anc_zu_jt.getText().trim();
			String[] fzu = null;
			if("¶à·Ö×éÓÃ;·Ö¸ô(ĬÈÏΪ0)".equals(zu)) {
				zu="0";
				fzu=new String[1];
				fzu[0]="0";
			}else {
				fzu=zu.split(";");
			}


			String[] zus=fzu;
			String liangcheng=anc_liangcheng_jt.getText().trim();
			String[] dlc=null;
			if("¶àÁ¿³ÌÓÃ;·Ö¸ô(ĬÈÏ100000)".equals(liangcheng)) {
				dlc=new String[1];
				dlc[0]="100000";
				liangcheng="100000";
			}else {
				dlc=liangcheng.split(";");
			}
			String[] lcs=dlc;
			String baoliu5=jt_juli.getText().trim();
			String baoliu9=jt_distance.getText().trim();
			if (Systems.isWuxian()){
				baoliu9=jt_distance.getText().trim();
			}

			String anchorip=ipAdressFile.getText().trim();
			String baoliu1="δ°ó¶¨";
			if(Systems.isIssanwei()) {				
				baoliu1=jt_sanwei.getText().trim();
				if(Dell_tb_gas_anchor.get_Tb_gas_anchor(baoliu1)==null) {
					ShowMessage.zidingyi(baoliu1+"°ó¶¨µÄÆøѹ²Î¿¼»ùÕ¾ÔÚtb_gas_anchor±í²»´æÔÚ...");
					return;
				}
			}


			if(anchorid.length()<3) {
				ShowMessage.zidingyi("»ùÕ¾µÄIDÓÐ´í£¡");
				return;
			}else {
				if(!JugeNumber.isLetterDigit(anchorid)) {				
					ShowMessage.zidingyi_24(anchorid+"»ùÕ¾ID±ØÐëΪHEX¸ñʽÇëÐ޸ģ¡");
					return;
				}
			}

			if(POSX.length()<1) {
				POSX="0";
			}
			String sx =POSX;
			if(!JugeNumber.isInteger(sx)) {
				ShowMessage.zidingyi("X×ø±êÊýÖµ±ØÐëÊÇÕûÊý");
				return;
			}
			if(POSY.length()<1) {
				POSY="0";
			}
			String sy = POSY;
			if(!JugeNumber.isInteger(sy)) {
				ShowMessage.zidingyi("Y×ø±êÊýÖµ±ØÐëÊÇÕûÊý");
				return;
			}
			if(POSZ.length()<1) {
				POSZ="0";
			}
			String sz =POSZ;
			if(!JugeNumber.isInteger(sz)) {
				ShowMessage.zidingyi("Z×ø±êÊýÖµ±ØÐëÊÇÕûÊý");
				return;
			}
			if(layer.equals("")) {
				layer="0";
			}
			String la =layer;
			if(!JugeNumber.isInteger(la)) {
				ShowMessage.zidingyi("²ãÊýÖµ±ØÐëÊÇÕûÊý");
				return;
			}
			if(anchorip.equals("")) {
				anchorip="";
			}



			if(Anchor_Dell.lc_and_zu(zu, liangcheng)) {
				ShowMessage.zidingyi("×éºÏÁ¿³ÌµÄ³¤¶È±ØÐëÒ»Ö£¬Ò»¸ö×é¶ÔÓ¦Ò»¸öÁ¿³Ì...");
				return;
			}
			if(zus==null ) {
				ShowMessage.zidingyi_24(zus+"±£´æʧ°Ü");
				return;
			}
			if(zus.length !=lcs.length) {
				ShowMessage.zidingyi_24(zus.length+"×éÊýÐèÒªºÍÁ¿³ÌÊýÁ¿¶ÔÓ¦ÓÃÓ¢Îķֺŷָô¿ª");
				return;
			}
			if("¾àÀ뵥λ:cm(ĬÈÏΪ0)".equals(baoliu5)){
				baoliu5="0";
			}else if (!JugeNumber.isInteger(baoliu5)) {
				ShowMessage.zidingyi("ÅжÏÊÒÄÚ¾àÀë±ØÐëÊÇÕûÊý");
				return;
			}
			if("¾àÀ뵥λ:cm(ĬÈÏΪ0)".equals(baoliu9)||"null".equals((baoliu9))){
				baoliu9="0";
			} else if (!JugeNumber.isInteger(baoliu9)){
				ShowMessage.zidingyi("»ùվУ׼¾àÀë±ØÐëÊÇÕûÊý");
				return;
			}

			if(Anchor_Dell.get_anchor(anchorid) !=null) {
				ShowMessage.zidingyi("»ùÕ¾Ìí¼Óʧ°Ü"+anchorid+"ÒѾ­´æÔÚ£¡");
				return;
			}

			String baoliu2="";//»ùÕ¾ÐÂµÄ¸ß¶È                       
			String baoliu3="";//и߶ÈËùÔÚµÄ×é                    
			String baoliu4=""; //»ùÕ¾±Ø¾­¾àÀë  
			String baoliu6="";//±äµçվģʽÏ»ùÕ¾µÄ¾­¶È        
			String baoliu7="";//±äµçվģʽÏ»ùÕ¾µÄγ¶È        
			String baoliu8="100";//Ãâ²¼ÏßģʽÏ»ùÕ¾µÄµçÁ¿
			String[]  ziduan= {"anchorid","POSX","POSY","POSZ","layer","zu",
					"liangcheng","anchormode","anchorip",
					"baoliu1","baoliu2","baoliu3","baoliu4",
					"baoliu5","baoliu6","baoliu7","baoliu8","baoliu9",
			"GreateTime"};
			String[] zhi= {anchorid,POSX,POSY,POSZ,layer,zu,
					liangcheng,anchormode,anchorip,
					baoliu1,baoliu2,baoliu3,baoliu4,baoliu5,baoliu6,
					baoliu7,baoliu8,baoliu9,
					GetNowTime.now()};

			if(DatabaseManagement.insertfast("tb_achor", ziduan, zhi)) {
				//Ïò±í¸ñĩβÌí¼ÓÒ»ÐÐÊý¾Ý
				ImageIcon icon=new ImageIcon("image/anchor/»ùÕ¾ÔÚÏß.png"); 
				Vector addrowData=new Vector();
				addrowData.add(icon);
				addrowData.add(anchorid);
				addrowData.add(POSX);
				addrowData.add(POSY);
				addrowData.add(POSZ);
				addrowData.add(layer);	
				addrowData.add(zu);
				addrowData.add(liangcheng);
				addrowData.add(icon);
				addrowData.add("");//ͬ²½
				addrowData.add(anchorip);
				addrowData.add("");//°æ±¾
				addrowData.add(GetNowTime.now());
				addrowData.add(baoliu9);
				tableModel.addRow(addrowData);
				add_new_anchor_do(anchorid,POSX,POSY,POSZ,layer,zu,liangcheng,anchorip,baoliu1,anchormode,baoliu9);
				updateTable() ;
				ShowMessage.zidingyi("»ùվдÈëÊý¾Ý¿â³É¹¦£¡");
			}else {
				ShowMessage.zidingyi("»ùվдÈëÊý¾Ý¿âʧ°Ü£¡");
			}			

		}




		/**»ñÈ¡È¡Ïû°´Å¥*/
		public JButtonModel getQuxiao() {
			if(quxiao==null) {
				quxiao=new JButtonModel("È¡Ïû");
				quxiao.addActionListener(new ActionListener() {
					public void actionPerformed(ActionEvent e) {
						closeTagDialog();
					}
				});
			}
			return quxiao;
		}
		@Override
		public void windowOpened(WindowEvent e) {
			// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù
		}
		@Override
		public void windowClosing(WindowEvent e) {
			// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù
			addachdialog=null;

		}
		@Override
		public void windowClosed(WindowEvent e) {
			// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù

		}
		@Override
		public void windowIconified(WindowEvent e) {
			// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù

		}
		@Override
		public void windowDeiconified(WindowEvent e) {
			// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù

		}
		@Override
		public void windowActivated(WindowEvent e) {
			// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù

		}
		@Override
		public void windowDeactivated(WindowEvent e) {
			// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù

		}
	}

	/**Ð޸ĻùÕ¾¶Ô»°¿ò*/
	class  alertDiolog extends AddAchorDialog{

		/**
		 * 
		 */
		private static final long serialVersionUID = 1L;
		String anchorid=null;
		String POSX=null;
		String POSY=null;
		String POSZ=null;
		String layer=null;
		String zu=null;
		String liangcheng=null;
		String anchorip=null;
		String baoliu1="0";
		String baoliu5="0";
		String baoliu9="0";


		public alertDiolog(String title) {
			super(title);
			getAnchorIdFile().setEnabled(false);
			String achrid=(String)table.getValueAt(getSelectedRow(), 1);
			getAnchorIdFile().setText(achrid);
			getPosxFile().setText((String)table.getValueAt(getSelectedRow(), 2));
			getPosyFile().setText((String)table.getValueAt(getSelectedRow(), 3));
			getPoszFile().setText((String)table.getValueAt(getSelectedRow(), 4));
			getLayerFile().setText((String)table.getValueAt(getSelectedRow(), 5));
			getAnc_zu_jt().setText((String)table.getValueAt(getSelectedRow(), 6));
			getAnc_liangcheng_jt().setText((String)table.getValueAt(getSelectedRow(), 7));
			getIpAdressFile().setText((String)table.getValueAt(getSelectedRow(), 9));
			getJt_juli().setText((String)table.getValueAt(getSelectedRow(),12));
			if (Systems.isWuxian()){
				getJt_distance().setText((String)table.getValueAt(getSelectedRow(),15));
			}

			if(Systems.isIssanwei()) {
				baoliu1=Anchor_Dell.get_anchor(achrid).getBaoliu1();
				jt_sanwei.setText(baoliu1);
			}

		}



		/**ÐÞ¸Ä±í·½·¨*/
		public void setUpadateSql(){
			// Ö´ÐÐSQL²éѯÓï¾ä»ñµÃµÄ½á¹û¼¯Èç¹û±êÇ©ÒѾ­´æÔÚÔò²»ÔÙÖ´ÐÐÏÂÃæµÄÓï¾ä

			anchorid=getAnchorIdFile().getText().trim();
			POSX=getPosxFile().getText().trim();
			POSY=getPosyFile().getText().trim();
			POSZ=getPoszFile().getText().trim();
			layer=getLayerFile().getText().trim();
			zu=getAnc_zu_jt().getText().trim();
			liangcheng=getAnc_liangcheng_jt().getText().trim();
			anchorip=getIpAdressFile().getText().trim();
			if(Dell_tb_suanfa2.isJuli_juge_in()) {//ͨ¹ý¾àÀëÅжÏÊÒÄÚÍâ
				baoliu5=getJt_juli().getText().trim();
			}
			baoliu9=getJt_distance().getText().trim();

			if(POSX.length()<1) {
				POSX="0";
			}


			if(POSY.length()<1) {
				POSY="0";
			}


			if(POSZ.length()<1) {
				POSZ="0";
			}


			if(layer.equals("")) {
				layer="0";
			}
			String layer1 =layer;
			if(!JugeNumber.isInteger(layer1)) {
				ShowMessage.zidingyi("²ãÊýÖµ±ØÐëÊÇÕûÊý");
				return;
			}
			if(anchorip.equals("")) {
				anchorip="";
			}
			if(Anchor_Dell.lc_and_zu(zu, liangcheng)) {
				ShowMessage.zidingyi("×éºÏÁ¿³ÌµÄ³¤¶È±ØÐëÒ»Ö£¬Ò»¸ö×é¶ÔÓ¦Ò»¸öÁ¿³Ì...");
				return;
			}
			if(Dell_tb_suanfa2.isJuli_juge_in()) {
				if (!JugeNumber.isInteger(baoliu5)) {
					ShowMessage.zidingyi("ÅжÏÊÒÄÚ¾àÀë±ØÐëÊÇÕûÊý");
					return;
				}
			}
			if (Systems.isWuxian()){
				if (!JugeNumber.isInteger(baoliu9)){
					ShowMessage.zidingyi("»ùվУ׼¾àÀë±ØÐëÊÇÕûÊý");
					return;
				}
			}

			if(Systems.isIssanwei()) {	
				baoliu1=jt_sanwei.getText().trim();
				if(Dell_tb_gas_anchor.get_Tb_gas_anchor(baoliu1)==null) {
					ShowMessage.zidingyi(baoliu1+"°ó¶¨µÄÈýά»ùÕ¾ÔÚtb_gas_anchor±í²»´æÔÚ...");
					return;
				}
			}

			String[] ziduan= {"POSX","POSY","POSZ","layer","zu",
					"liangcheng","anchorip","baoliu1","baoliu5","baoliu9","anchorid"};
			String[] zhi= {POSX,POSY,POSZ,layer,zu,
					liangcheng,anchorip,baoliu1,baoliu5,baoliu9,anchorid};

			if(DatabaseManagement.fast_alert_dbase("tb_achor", ziduan, zhi)) {
				Anchor_Dell.set_anchor_xyzfip(anchorid, POSX, POSY, POSZ,layer, anchorip,zu,liangcheng,baoliu9);
				Dell_tbcengzu.add_cengzu_form_addanchor(layer, zu);//Ìí¼Ó²ã×é¶ÔÏó
				ShowMessage.zidingyi("»ùÕ¾Ð޸ijɹ¦£¡"); 								
				this.closeTagDialog();
				updateTable() ;
			}else {
				ShowMessage.zidingyi("Êý¾ÝдÈëÊý¾Ý¿âʧ°Ü£¡");
				return;
			}	


		}


	}



	public static String getChoose_anchor() {
		if(open) {
			if(table.getSelectedRowCount() ==1 && table.getSelectedRow()<table.getRowCount()) {
				choose_anchor=(String) table.getValueAt(table.getSelectedRow(), 1);				
			}
		}
		return choose_anchor;
	}


	public static void add_new_anchor_do(
			String anchorid,
			String POSX,
			String POSY,
			String POSZ,
			String layer, 
			String zu,
			String liangcheng,
			String anchorip,
			String baoliu1,//»ùÕ¾ÊÇ·ñÊÇÈýά²Î¿¼»ù×¼
			String anchormode,
			String baoliu9////ÎÞÏß»ùվУ׼¾àÀë
			) {


		Anchor_Dell.set_anchor(anchorid,POSX,POSY,POSZ,layer, zu,liangcheng,anchorip,anchormode,baoliu9);
		Dell_tbcengzu.add_cengzu_form_addanchor(layer, zu);//Ìí¼Ó²ã×é¶ÔÏó
		Anchor_nerby_dell.add_anchorby(anchorid,"","","","","","","","","","","0");//ÐÂÔöÁÙ½ü»ùÕ¾ÐÅÏ¢		
		Dell_TongbuAnchor.add_one_rootanchor(anchorid, "", "0", "");//ÐÂÔöͬ²½»ùÕ¾		

	}




	public JButtonModel getJbt_openwangye() {
		if(Jbt_openwangye==null) {
			Jbt_openwangye=new JButtonModel("´ò¿ªÍøÒ³");
			Jbt_openwangye.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {

					if(getSelectedRow()==(-1)) {
						ShowMessage.zidingyi("ÇëÏÈÑ¡ÖÐÐèÒª´ò¿ªµÄ»ùÕ¾");
						return;
					}

					String id=(String)table.getValueAt(getSelectedRow(),1);
					String ip=(String)table.getValueAt(getSelectedRow(),9);
					if(ip.length()<10) {
						ShowMessage.zidingyi(id+"IPµØÖ·²»ÕýÈ·");
						return;
					}


					try {
						String url ="http://"+ip;
						java.net.URI uri = java.net.URI.create(url);
						// »ñÈ¡µ±Ç°ÏµÍ³×ÀÃæÀ©Õ¹
						ShowMessage.zidingyi("ÕýÔÚ´ò¿ªµØÖ·£º"+ip+"ÍøÒ³");
						java.awt.Desktop dp = java.awt.Desktop.getDesktop();
						// ÅжÏϵͳ×ÀÃæÊÇ·ñÖ§³ÖÒªÖ´ÐеŦÄÜ
						if (dp.isSupported(java.awt.Desktop.Action.BROWSE)) {
							dp.browse(uri);
							// »ñȡϵͳĬÈÏä¯ÀÀÆ÷´ò¿ªÁ´½Ó
						}
					} catch (NullPointerException e1) {
						// ´ËΪuriΪ¿ÕʱÅ׳öÒì³£
						e1.printStackTrace();
					} catch (java.io.IOException e1) {
						// ´ËΪÎÞ·¨»ñȡϵͳĬÈÏä¯ÀÀÆ÷
						e1.printStackTrace();
					}

				}
			});
		}
		return Jbt_openwangye;
	}


}