package Frame;
|
import java.awt.BorderLayout;
|
import java.awt.Color;
|
import java.awt.Container;
|
import java.awt.Dimension;
|
import java.awt.Toolkit;
|
import java.awt.event.ActionEvent;
|
import java.awt.event.ActionListener;
|
import java.awt.event.KeyEvent;
|
import java.awt.event.KeyListener;
|
import java.awt.event.WindowEvent;
|
import java.awt.event.WindowListener;
|
import java.util.List;
|
import java.util.Vector;
|
import javax.swing.Box;
|
import javax.swing.ImageIcon;
|
import javax.swing.JDialog;
|
import javax.swing.JPanel;
|
import javax.swing.JScrollPane;
|
import javax.swing.JTable;
|
import javax.swing.JTextField;
|
import javax.swing.table.DefaultTableModel;
|
import ColorAndFont.English;
|
import ColorAndFont.NothJPanel;
|
import ColorAndFont.UIColor;
|
import ColorAndFont.buttonTitle;
|
import DataBase.DatabaseManagement;
|
import PbuliClass.JButtonModel;
|
import PbuliClass.JlableModel;
|
import PbuliClass.OutButton;
|
import PbuliClass.ShowMessage;
|
import PbuliClass.Systems;
|
import PbuliClass.WarningMessage;
|
import PbuliClass.greateTables;
|
import PbuliClass.jinternalFrame;
|
import tbDataModel.Tb_gas_anchor;
|
import tbDataModel.Tb_tag_gas_jiaozhun_value;
|
import tbDataModel_Dell.Dell_tag_gas_jiaozhun_value;
|
import tbDataModel_Dell.Dell_tb_gas_anchor;
|
import tbDataModel_Dell.LineXy;
|
@SuppressWarnings("rawtypes")
|
public class Tag_gas_value extends jinternalFrame {
|
/**
|
*
|
*/
|
private static final long serialVersionUID = 1L;
|
|
JPanel inJpanel=null;//ÄÚ²¿Ãæ°å
|
NothJPanel northJpanel=null;//±±²¿Ãæ°å
|
JPanel centerJpanel=null;//Öв¿Ãæ°å
|
JButtonModel jbut;//°´Å¥Ä£ÐÍ
|
JTextField searchFileld=null;//ËÑË÷Îı¾¿ò
|
JButtonModel search=null;//ËÑË÷°´Å¥
|
JButtonModel shuaxin=null;//ˢа´Å¥
|
JButtonModel delete=null;//ɾ³ý°´Å¥
|
JButtonModel deleteAll=null;//È«²¿É¾³ý°´Å¥
|
JButtonModel save=null;//±£´æÀúÊ·¼Ç¼ֵ
|
JTable table=null;//ÉêÃ÷±í¸ñ
|
Vector<Vector<String>> rowData=null;
|
DefaultTableModel tableModel=null;//±í¸ñÄ£ÐÍ
|
List list;
|
Container rq;
|
JScrollPane gd=null;
|
|
JButtonModel open=null;//´ò¿ª
|
int maxPageNumber;
|
Dialog dialog=null;
|
static int currentPageNumber = 1;//µ±Ç°Ò³Ãæ
|
int allrows;//Êý¾Ý×ÜÌõÊý
|
NothJPanel south=null;
|
JlableModel nowpage;//µ±Ç°Ò³Âë
|
String serch;
|
int k;
|
String a;
|
int selectedRow;//±»Ñ¡ÖеÄÐÐ
|
JTextField hang=null;
|
String tagid=null;
|
static boolean save_history_gas_value=false;//±£´æÀúÊ·Æøѹֵ
|
|
public Tag_gas_value() {
|
String title="±êÇ©ÆøѹУ׼±í";
|
if(Systems.sys().getLanguage().equals("English")) {
|
title="lixianRcord";
|
}
|
this.setTitle(title);
|
this.setFrameIcon(new ImageIcon("image/icon/anchoricon.png"));//ÉèÖô°Ìåͼ±ê
|
rowData=new Vector<>();
|
rq=getContentPane();//»ñÈ¡ÈÝÆ÷
|
rq.setLayout(new BorderLayout());
|
rq.setBackground(Color.white);
|
rq.add(getNorthJpanel(),BorderLayout.NORTH);
|
rq.add(getGd(),BorderLayout.CENTER);
|
rq.add(getSouth(),BorderLayout.SOUTH);
|
|
}
|
|
|
/**»ñÈ¡±±²¿Ãæ°å*/
|
public NothJPanel getNorthJpanel() {
|
if(northJpanel==null) {
|
northJpanel=new NothJPanel();
|
Box topicBox = Box.createHorizontalBox();// ´´½¨Ò»¸öˮƽÏäÈÝÆ÷
|
topicBox.add(getSearchFileld());//Ìí¼ÓËÑË÷Îı¾¿ò
|
topicBox.add(Box.createHorizontalStrut(3));// Ìí¼ÓÒ»¸ö3ÏñËØ¿íµÄˮƽ֧Öù
|
topicBox.add(getSearch());//Ìí¼ÓËÑË÷°´Å¥
|
topicBox.add(Box.createHorizontalStrut(30));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
|
topicBox.add(getShuaxin());//Ìí¼Óˢа´Å¥
|
topicBox.add(Box.createHorizontalStrut(30));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
|
topicBox.add(getSave());//Ìí¼Óɾ³ý°´Å¥
|
topicBox.add(Box.createHorizontalStrut(30));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
|
topicBox.add(getDeleteAll());//Ìí¼Óɾ³ýÈ«²¿°´Å¥
|
northJpanel.add(topicBox );
|
}
|
|
return northJpanel;
|
}
|
|
/**»ñÈ¡Äϲ¿Ãæ°åµÄ·½·¨*/
|
public NothJPanel getSouth() {
|
if(south==null) {
|
south=new NothJPanel();
|
}
|
return south;
|
}
|
|
|
|
/**»ñÈ¡ËÑË÷Îı¾¿òµÄ·½·¨*/
|
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) {
|
// Ö´ÐÐSQL²éѯÓï¾ä»ñµÃµÄ½á¹û¼¯
|
try {
|
if(getSearchFileld().getText().length()>1) {
|
String go=searchFileld.getText().trim();
|
updateSerch(go);
|
}else {
|
ShowMessage.zidingyi("ÇëÊäÈëÐèÒªËÑË÷µÄÉ豸ID...");
|
}
|
} catch (Exception er) {
|
er.printStackTrace();
|
}
|
}
|
});
|
}
|
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 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) {
|
for(int i=0;i<selectedRows.length;i++){
|
String deleteSql="DELETE FROM tb_tag_gas_jiaozhun_value WHERE tagid='"+table.getValueAt(selectedRows[i], 0)+"'";
|
DatabaseManagement.update(deleteSql);// ɾ³ý±êÇ©ÐÅÏ¢
|
}
|
|
//ɾ³ýËùÓб»Ñ¡ÖеÄÐÐ
|
for(int j=selectedRows.length-1;j>=0;j--){//ÕâÊǹؼü´úÂë
|
tableModel.removeRow(selectedRows[j]);//ɾ³ýÈÎÒⱻѡÖÐÐÐ
|
}
|
table.setModel(tableModel);//¸üбí¸ñÄ£ÐÍ
|
|
//ɾ³ý³É¹¦ÌáʾÐÅÏ¢
|
ShowMessage.delteSuccess(selectedRows.length);
|
|
}
|
else {
|
ShowMessage.zidingyi("ÇëÑ¡ÖÐÐèҪɾ³ýµÄÐУ¡");
|
}
|
updateTable();
|
}
|
});
|
}
|
return delete;
|
}
|
|
|
/**»ñÈ¡È«²¿É¾³ý°´Å¥µÄ·½·¨*/
|
public JButtonModel getDeleteAll() {
|
if(deleteAll==null){
|
deleteAll=new JButtonModel("Çå¿ÕÀúÊ·¼Ç¼");
|
deleteAll.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
//Ñ¡Ôñ¶Ô»°¿òÈçyes·µ»Ø0£¬NO·µ»Ø1£¬È¡Ïû·µ»Ø2
|
WarningMessage warning=new WarningMessage();
|
warning.setMessage("Ñ¡Ôñɾ³ýÈ«²¿½«»á°Ñ±í¸ñÊý¾ÝÈ«²¿É¾³ýÈ·¶¨Âð£¿");
|
warning.getwarMss(getNorthJpanel());
|
String deleteSql="TRUNCATE TABLE tag_gas_history";
|
ShowMessage.deleteAll(DatabaseManagement.update(deleteSql));
|
}
|
});
|
|
}
|
return deleteAll;
|
}
|
|
/**»ñÈ¡µ¼³ö±í¸ñ°´Å¥µÄ·½·¨*/
|
public JButtonModel getOutport() {
|
OutButton.setAddtime("time");
|
OutButton.setDataName("tb_tag_gas_jiaozhun_value");
|
return new OutButton().get_ouotport_button();
|
}
|
|
/**»ñÈ¡¹ö¶¯Ãæ°åµÄ·½·¨*/
|
public JScrollPane getGd() {
|
gd=new JScrollPane(getTable());
|
gd.getViewport().setBackground(UIColor.getNorth_color());
|
return gd;
|
}
|
|
|
/**Ìí¼Ó±í¸ñÐÐÏòÁ¿Êý¾Ý·½·¨*/
|
@SuppressWarnings("unchecked")
|
public void getRowData(Vector<Tb_tag_gas_jiaozhun_value> taggasjiaohzunvc ) {
|
int size=taggasjiaohzunvc.size();
|
for(int i=0;i<size;i++) {
|
Tb_tag_gas_jiaozhun_value tg=taggasjiaohzunvc.get(i);
|
Vector row = new Vector();
|
String tagid=tg.getTagid();;//±êÇ©±àºÅ
|
String gasanchorid=tg.getGasanchorid();//Æøѹ»ùÕ¾ID
|
int value=tg.getValue();//ÆøѹУ׼ֵ
|
int timesnum=tg.getTimesnum();//У׼´ÎÊý
|
int state=tg.getTag_wait_gaodu_jiaozhun();
|
String time=tg.getTime();//×îÐÂУ׼ʱ¼ä
|
String baoliu1=tg.getBaoliu1();// ±êÇ©µÄУ׼Çé¿ö
|
Tb_gas_anchor tbgasanchor=Dell_tb_gas_anchor.get_Tb_gas_anchor(gasanchorid);
|
String gasanchorgao="δ֪";
|
String anchrgas_value="δ֪";
|
if(tbgasanchor !=null) {
|
gasanchorgao=tbgasanchor.getAnchorz();
|
anchrgas_value=tbgasanchor.getGasvalue();
|
}else {
|
gasanchorgao=gasanchorid+"Æøѹ»ùÕ¾²»´æÔÚ";
|
anchrgas_value=gasanchorid+"Æøѹ»ùÕ¾²»´æÔÚ";
|
}
|
|
int taggas_value=tg.getTag_gas();
|
String tagnowgao=tg.getTag_now_gao();
|
row.add(tagid);
|
row.add(gasanchorid);
|
row.add(value+"");
|
row.add(timesnum+"");
|
String a1="³õʼ»¯";
|
if(state==0) {
|
a1="µÈ´ýУ׼";
|
}else if(state==1){
|
a1="У׼Íê³É";
|
}
|
row.add(a1);
|
row.add(baoliu1);
|
row.add(gasanchorgao);
|
row.add(anchrgas_value);
|
row.add(taggas_value+"");
|
row.add(tagnowgao);
|
row.add(time);
|
tableModel.addRow(row);// Ïò±í¸ñ¶ÔÏóÌí¼ÓÐÐÊý¾Ý
|
}
|
}
|
|
|
/**»ñÈ¡±êÇ©µçÁ¿±í¸ñµÄ·½·¨*/
|
@SuppressWarnings("serial")
|
public JTable getTable() {
|
if(table==null) {
|
String[] name1= {"±êÇ©±àºÅ","»ùÕ¾±àºÅ","У׼ֵ","У׼´ÎÊý","У׼Çé¿ö","µ±Ç°×´Ì¬",
|
"A¸ß¶È","Aѹ","Tѹ","T¸ß¶È","¸üÐÂʱ¼ä"};//±í¸ñÁÐÃû
|
String[] name2= {"tagid","anchorid","value","times","state0","state",
|
"Achorgao","Agas","Tgas","Tgao","time"};//±í¸ñÁÐÃû
|
String[] columnNames=English.columnNames(name1, name2);
|
//Ìí¼Ó±í¸ñÁÐÏòÁ¿
|
Vector<String> columnName=new Vector<>();
|
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(Dell_tag_gas_jiaozhun_value.getTaggasjiaohzunvc());
|
}
|
return table;
|
}
|
|
|
/**ˢбí¸ñ·½·¨*/
|
public void updateTable() {
|
|
if(tableModel !=null) {
|
tableModel.getDataVector().clear();
|
String sql="select * from tb_tag_gas_jiaozhun_value order by id desc limit 500";
|
list = DatabaseManagement.serch(sql);
|
getRowData(Dell_tag_gas_jiaozhun_value.getTaggasjiaohzunvc());
|
gd.validate();
|
}
|
|
}
|
|
|
/**ËÑË÷·½·¨*/
|
public void updateSerch(String serch) {
|
Vector<Tb_tag_gas_jiaozhun_value> vcs=Dell_tag_gas_jiaozhun_value.serchtag(serch);
|
if(vcs.size()>0) {
|
if(tableModel !=null) {
|
tableModel.getDataVector().clear();
|
getRowData(vcs);
|
}
|
}else {
|
ShowMessage.zidingyi("ÄãËÑË÷µÄ"+serch+"²»´æÔÚ...");
|
}
|
}
|
|
|
class Dialog extends JDialog implements WindowListener{
|
|
/**
|
*
|
*/
|
private static final long serialVersionUID = 1L;
|
/**»ñÈ¡¶Ô»°¿ò·½·¨*/
|
public Dialog(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 x0=width-390;//´°Ìåx0×ø±ê
|
int y0=height-240;//´°Ìåy0×ø±ê
|
Container rq=getContentPane();
|
this.setIconImage(new ImageIcon("image/icon/anchoricon.png").getImage());
|
this.addWindowListener((WindowListener) this);
|
rq.add(new LineXy().getMb(title));
|
this.setBounds(x0, y0, 780, 480);
|
this.setVisible(true);
|
}
|
|
|
|
public void windowOpened(WindowEvent e) {
|
// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù
|
|
}
|
@Override
|
public void windowClosing(WindowEvent e) {
|
// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù
|
dialog=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 ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù
|
|
}
|
|
}
|
|
|
public static boolean isSave_history_gas_value() {
|
return save_history_gas_value;
|
}
|
|
|
public static void setSave_history_gas_value(boolean save_history_gas_value) {
|
Tag_gas_value.save_history_gas_value = save_history_gas_value;
|
}
|
|
|
public JButtonModel getSave() {
|
if(save==null) {
|
save=new JButtonModel("±£´æ¼Ç¼¹Ø±Õ");
|
save.addActionListener(new ActionListener() {
|
public void actionPerformed(ActionEvent e) {
|
if(save_history_gas_value) {
|
save_history_gas_value=false;
|
save.setBackground(Color.gray);
|
save.setText("±£´æ¼Ç¼¹Ø±Õ");
|
}else {
|
save_history_gas_value=true;
|
save.setText("±£´æ¼Ç¼¿ªÆô");
|
save.setBackground(Color.red);
|
}
|
|
}
|
});
|
}
|
return save;
|
}
|
|
|
public void setSave(JButtonModel save) {
|
this.save = save;
|
}
|
|
}
|
