package com.mes.ui; import com.alibaba.fastjson2.JSON; import com.alibaba.fastjson2.JSONObject; import com.mes.component.MesRadio; import com.mes.component.MesWebView; import com.mes.netty.NettyClient; import com.mes.util.DateLocalUtils; import com.mes.util.HttpUtils; import com.mes.util.JdbcUtils; import com.mes.ygsl.MesProductBs; import com.mes.ygsl.YgslClient; import com.mes.ygsl.YgslUtil; import javafx.embed.swing.JFXPanel; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import javax.swing.*; import javax.swing.border.EmptyBorder; import javax.swing.event.ChangeEvent; import javax.swing.event.ChangeListener; import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; import java.io.BufferedReader; import java.io.IOException; import java.io.InputStream; import java.io.InputStreamReader; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.time.LocalDateTime; import java.util.*; import java.util.List; import java.util.Timer; public class MesClient extends JFrame { public static final Logger log = LoggerFactory.getLogger(MesClient.class); private static String Drivde = "org.sqlite.JDBC"; public static int mes_auth = 0; // 权限级别 0=无权限 1=操作工人 2=管理员 public static String mes_gw = ""; // 工位号 public static String mes_gw_des = ""; // 工位名称 public static String mes_server_ip = ""; // 服务器IP地址 public static int mes_tcp_port = 3000; // TCP服务端口 public static int mes_heart_beat_cycle = 10; // 心跳周期 public static int mes_heart_icon_cycle = 1; public static String mes_line_sn = ""; // 产线编号 //TCP连接 public static NettyClient nettyClient; //TCP连接状态 public static boolean tcp_connect_flag = false; //TCP连接请求 public static boolean connect_request_flag = false; //session public static String sessionid = ""; public static JPanel contentPane; public static MesClient mesClientFrame; public static JTabbedPane tabbedPane; public static JScrollPane indexScrollPaneA; public static JScrollPane searchScrollPane; public static JScrollPane searchScrollPaneD; public static JScrollPane searchScrollPaneDj; public static JScrollPane searchScrollPaneJs; public static JPanel indexPanelJs; public static MesWebView jfxPanelJs = null; public static Boolean check_quality_result = false; public static Integer work_status = 0; public static JButton heart_beat_menu; public static JButton status_menu; public static JButton user_menu; public static int scan_type = 0; public static JButton finish_ok_bt; public static JButton finish_ng_bt; public static JTextField product_sn; public static JButton f_scan_data_bt_1; public static String user20 = ""; public static JFrame welcomeWin; public static JPanel indexPanelB; public static MesWebView jfxPanel = null; public static JPanel indexPanelC; public static JPanel indexPanelD; public static MesWebView jfxPanel2 = null; public static MesWebView jfxPanel3 = null; public static MesRadio mesRadioHj; public static JTable table; public static Object[] columnNames = { "物料名称", "绑定批次", "剩余次数", "操作" }; public static Object[][] rowData = null; //TCP连接 public static YgslClient ygslClient; //TCP连接状态 public static boolean ygsl_tcp_connect_flag = false; //TCP连接请求 public static boolean ygsl_connect_request_flag = false; public static JButton torsional_menu; // public static int count = 0; public static JTextField monitoring_text;//扭力监控 public static JTextField result_text;//总结果 public static JTextField torsionalMaxValue; //扭力值范围 public static JTextField torsionalValue;//当前扭力值 public static Integer cur = 0; // 当前数 public static Integer max = 3; //任务数 public static List atids = new ArrayList<>(); public static ArrayList torsionalValueList = new ArrayList();//扭力值存储数组 public static Boolean fininsh_flag = false; // false=不合格 true=合格 public static void main(String[] args) { EventQueue.invokeLater(new Runnable() { @Override public void run() { try{ //读文件配置 readProperty(); // 显示界面 mesClientFrame = new MesClient(); mesClientFrame.setVisible(false); JdbcUtils.getConn(); welcomeWin = new LoginFarme(); welcomeWin.setVisible(true); getMaterailData(); startUpdateQualityTimer(); // 开启提交结果的定时任务 uploadParams(); }catch (Exception e){ log.error(e.getMessage()); } } }); } //读配置文件 private static void readProperty() throws IOException{ String enconding = "UTF-8"; InputStream is = ClassLoader.getSystemResourceAsStream("config/config.properties"); Properties pro = new Properties(); BufferedReader br = new BufferedReader(new InputStreamReader(is, enconding)); pro.load(br); mes_gw = pro.getProperty("mes.gw"); // mes_gw_des = pro.getProperty("mes.gw_des"); mes_server_ip = pro.getProperty("mes.server_ip"); mes_tcp_port = Integer.parseInt(pro.getProperty("mes.tcp_port")); mes_heart_beat_cycle = Integer.parseInt(pro.getProperty("mes.heart_beat_cycle")); mes_line_sn = pro.getProperty("mes.line_sn"); mes_gw_des = OprnoUtil.getGwDes(mes_line_sn,mes_gw); log.info(mes_gw + ";" + mes_gw_des + ";" + mes_server_ip + ";" + mes_tcp_port + ";" + mes_heart_beat_cycle); } // 初始化TCP public static void initTcpConnection() { try { if(nettyClient==null) { //初始化TCP连接 nettyClient = new NettyClient(); //TCP连接状态 tcp_connect_flag = false; //设置TCP请求状态 connect_request_flag = true; DataUtil.synrTcp(nettyClient,mes_gw); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void initYgslTcpConnection() { try { if(ygslClient==null) { //初始化TCP连接 ygslClient = new YgslClient(); // //TCP连接状态 // ygsl_tcp_connect_flag = false; // //设置TCP请求状态 // ygsl_connect_request_flag = true; try{ ygslClient.run(); }catch (Exception e){ e.printStackTrace(); } } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static java.util.Timer cjTimer2; public static void uploadParams() { if(cjTimer2!=null) { cjTimer2.cancel(); } cjTimer2 = new Timer(); cjTimer2.schedule(new TimerTask() { public void run() { try{ List prods = JdbcUtils.getProds(); System.out.println("prods:"+ JSON.toJSONString(prods)); if(prods.size() > 0){ // 定时上传参数 JSONObject retObj = DataUtil.upParams(JSON.toJSONString(prods)); if(retObj.get("result")!=null&&retObj.get("result").toString().equalsIgnoreCase("true")) { // 更新sqlite已同步 for(MesProductBs mesProductBs:prods){ JdbcUtils.updateProdSync(mesProductBs.getId(),1); } } } }catch (Exception e){ e.printStackTrace(); } } }, 1000,30*1000); } public static java.util.Timer heartYgslBeatTimer; public static void startYgslHeartBeatTimer() { if(heartYgslBeatTimer!=null) { heartYgslBeatTimer.cancel(); } heartYgslBeatTimer = new java.util.Timer(); heartYgslBeatTimer.schedule(new TimerTask() { public void run() { if(ygslClient!=null && ygsl_tcp_connect_flag) { System.out.println("发送心跳报文ygsl"); YgslUtil.comHeart(ygslClient); torsional_menu.setText("在线"); torsional_menu.setForeground(Color.GREEN); } // else{ // System.out.println("发送心跳报文ygsl离线"); // MesClient.ygsl_tcp_connect_flag = false; // MesClient.ygsl_connect_request_flag = true; // MesClient.ygslClient = null; // MesClient.initYgslTcpConnection(); // torsional_menu.setText("离线"); // torsional_menu.setForeground(Color.RED); // } } }, 100, 10 * 1000); } //启动心跳包程序 public static java.util.Timer heartBeatTimer; public static java.util.Timer heartBeatIconTimer; public static boolean iconREDFlag = true; public static void startHeartBeatTimer() { if(heartBeatTimer!=null) { heartBeatTimer.cancel(); } heartBeatTimer = new java.util.Timer(); heartBeatTimer.schedule(new TimerTask() { public void run() { if(nettyClient!=null&&tcp_connect_flag) { //log.info("发送心跳报文"); DataUtil.heartBeat(nettyClient,mes_gw); heart_beat_menu.setText(DateLocalUtils.getCurrentTime()); } } }, 100,mes_heart_beat_cycle*1000); //心跳显示图标 if(heartBeatIconTimer!=null) { heartBeatIconTimer.cancel(); } heartBeatIconTimer = new Timer(); heartBeatIconTimer.schedule(new TimerTask() { public void run() { if(tcp_connect_flag) { if(iconREDFlag) { heart_beat_menu.setIcon(new ImageIcon(MesClient.class.getResource("/bg/grey_dot.png"))); iconREDFlag = false; }else { heart_beat_menu.setIcon(new ImageIcon(MesClient.class.getResource("/bg/green_dot.png"))); iconREDFlag = true; } heart_beat_menu.setText(DateLocalUtils.getCurrentTime()); heart_beat_menu.repaint(); }else { heart_beat_menu.setIcon(new ImageIcon(MesClient.class.getResource("/bg/grey_dot.png"))); heart_beat_menu.setText(DateLocalUtils.getCurrentTime()); heart_beat_menu.repaint(); //若未连接则尝试连接 if(nettyClient!=null&&!tcp_connect_flag){ log.info("TCP已断开"); //TCP重新同步连接 if(!connect_request_flag) { //log.info("TCP重新同步连接"); //设置TCP请求状态,只重新同步连接一次 connect_request_flag = true; DataUtil.synrTcp(nettyClient,mes_gw); } } } } }, 100,mes_heart_icon_cycle*1000); } //设置tcp连接状态显示 public static void setTcpStatus() { if(tcp_connect_flag) { heart_beat_menu.setIcon(new ImageIcon(MesClient.class.getResource("/bg/grey_dot.png"))); heart_beat_menu.repaint(); }else { heart_beat_menu.setIcon(new ImageIcon(MesClient.class.getResource("/bg/grey_dot.png"))); heart_beat_menu.repaint(); } } public static void initWarehouseData(){ resetScanA(); } public static void resetScanA() { work_status = 0; check_quality_result = false; MesClient.finish_ok_bt.setEnabled(false); MesClient.finish_ng_bt.setEnabled(false); product_sn.setText(""); MesClient.f_scan_data_bt_1.setEnabled(true); MesClient.setMenuStatus("请扫工件码",0); fininsh_flag = false; result_text.setText(""); // torsionalValueList.clear(); // count = 0; // torsionalMaxValue.setText("11-13N.m"); torsionalMaxValue.setText(""); torsionalValue.setText(""); atids.clear(); cur = 0; // monitoring_text.setText(MesClient.max+"/"+MesClient.cur); monitoring_text.setText(MesClient.cur+"/"+MesClient.max); updateMaterailData(); // shiftUserCheck(); } public static int userLoginHours;//用户登录所处小时 //换班用户信息检查 private static void shiftUserCheck() { LocalDateTime now = LocalDateTime.now(); // 判断时间范围 if (userLoginHours >= 8 && userLoginHours < 20) { int hour = now.getHour(); if (hour >= 20 || hour < 8) { logoff(); } } else { int hour = now.getHour(); if (hour >= 8 && hour < 20) { logoff(); } } } public static void resetScanB() { } //获取用户20位 public static void getUser() { user20 = user_menu.getText().toString(); String space_tmp1 = ""; if(user20.length()<20) { for(int i=0;i<20-user20.length();i++) { space_tmp1 = space_tmp1 + " "; } } user20 = user20 + space_tmp1; } //获取barcode内容36位 public static String getBarcode(String barcodeTmp) { String barcodeRet = barcodeTmp; if(barcodeTmp.equalsIgnoreCase("")) { return ""; }else { if(barcodeTmp.length()<36) { String space = ""; for(int i=0;i<36-barcodeTmp.length();i++) { space = space + " "; } barcodeRet = barcodeTmp + space; } } return barcodeRet; } public static void scanBarcode() { if(work_status == 1){ JOptionPane.showMessageDialog(mesClientFrame,"工作中，勿扫码","提示窗口", JOptionPane.INFORMATION_MESSAGE); return; } String scanBarcodeTitle = ""; switch(scan_type) { case 1: product_sn.setText(""); scanBarcodeTitle = "请扫工件码"; break; } //弹窗扫工件码 String scanBarcode = JOptionPane.showInputDialog(null, scanBarcodeTitle); if(scanBarcode!=null&&!scanBarcode.equalsIgnoreCase("")) { //获取用户 getUser(); //获取扫码内容36位 String barcode36 = getBarcode(scanBarcode);//处理36为码 //工位号 String gw = ""; switch(scan_type) { case 1: product_sn.setText(scanBarcode); break; } //刷新界面 mesClientFrame.repaint(); if(!tcp_connect_flag) { JOptionPane.showMessageDialog(mesClientFrame,"设备未连接Mes服务器","提示窗口", JOptionPane.INFORMATION_MESSAGE); return; } // 查询工件质量 Boolean sendret = DataUtil.checkQuality(nettyClient,barcode36,user20); if(!sendret){ JOptionPane.showMessageDialog(mesClientFrame,"消息发送失败，请重试","提示窗口", JOptionPane.INFORMATION_MESSAGE); return; } }else { JOptionPane.showMessageDialog(mesClientFrame,"请扫工件码","提示窗口", JOptionPane.INFORMATION_MESSAGE); return; } } public static void logoff() { // welcomeWin.setVisible(true); mesClientFrame.setVisible(false); //退出程序 退出登录 System.exit(0); nettyClient = null; // if(heartBeatTimer!=null) { // heartBeatTimer.cancel(); // } // if(heartBeatIconTimer!=null) { // heartBeatIconTimer.cancel(); // } tcp_connect_flag = false; connect_request_flag = false; } public MesClient() { setIconImage(Toolkit.getDefaultToolkit().getImage(MesClient.class.getResource("/bg/logo.png"))); setTitle("MES系统客户端："+mes_gw + "- " + mes_gw_des); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setBounds(0, 0, 1024, 768); JMenuBar menuBar = new JMenuBar(); menuBar.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 26)); setJMenuBar(menuBar); JMenu fileMenu = new JMenu("用户"); fileMenu.setIcon(new ImageIcon(MesClient.class.getResource("/bg/user.png"))); fileMenu.setFont(new Font("微软雅黑", Font.PLAIN, 20)); menuBar.add(fileMenu); JMenuItem exitMenuItem = new JMenuItem("退出"); exitMenuItem.setIcon(new ImageIcon(MesClient.class.getResource("/bg/logoff.png"))); exitMenuItem.setFont(new Font("微软雅黑", Font.PLAIN, 22)); fileMenu.add(exitMenuItem); exitMenuItem.addMouseListener(new MouseAdapter() { @Override public void mousePressed(MouseEvent e) {//只能检测到mousePressed事件 super.mouseClicked(e); //dispose(); logoff(); } }); JMenu settingMenu = new JMenu("设置"); //settingMenu.setVisible(false); settingMenu.setIcon(new ImageIcon(MesClient.class.getResource("/bg/menu_setting.png"))); settingMenu.setFont(new Font("微软雅黑", Font.PLAIN, 20)); menuBar.add(settingMenu); JMenuItem resetTcpMenu = new JMenuItem("重连MES"); resetTcpMenu.setIcon(new ImageIcon(MesClient.class.getResource("/bg/reset_logo.png"))); resetTcpMenu.setFont(new Font("微软雅黑", Font.PLAIN, 20)); resetTcpMenu.addMouseListener(new MouseAdapter() { @Override public void mousePressed(MouseEvent e) { super.mouseClicked(e); //重连mes nettyClient.future.channel().close(); } }); settingMenu.add(resetTcpMenu); JMenuItem resetTcpMenu_1 = new JMenuItem("刷新工件"); resetTcpMenu_1.setIcon(new ImageIcon(MesClient.class.getResource("/bg/reset_logo.png"))); resetTcpMenu_1.setFont(new Font("微软雅黑", Font.PLAIN, 20)); resetTcpMenu_1.addMouseListener(new MouseAdapter() { @Override public void mousePressed(MouseEvent e) { super.mouseClicked(e); resetScanA(); } }); settingMenu.add(resetTcpMenu_1); contentPane = new JPanel(); contentPane.setBorder(new EmptyBorder(5, 5, 5, 5)); setContentPane(contentPane); contentPane.setLayout(new BorderLayout(0, 0)); JToolBar toolBar = new JToolBar(); contentPane.add(toolBar, BorderLayout.NORTH); JLabel equipment_statu_label = new JLabel("状态："); equipment_statu_label.setHorizontalAlignment(SwingConstants.CENTER); equipment_statu_label.setForeground(Color.BLACK); equipment_statu_label.setFont(new Font("微软雅黑", Font.PLAIN, 20)); equipment_statu_label.setBackground(Color.LIGHT_GRAY); toolBar.add(equipment_statu_label); status_menu = new JButton("设备未连接MES服务器"); if(tcp_connect_flag) { MesClient.setMenuStatus("已连接MES服务器",0); status_menu.setForeground(Color.GREEN); }else { MesClient.setMenuStatus("未连接MES服务器",-1); status_menu.setForeground(Color.DARK_GRAY); } status_menu.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { } }); status_menu.setForeground(Color.GREEN); status_menu.setFont(new Font("微软雅黑", Font.PLAIN, 20)); status_menu.setBackground(Color.BLACK); toolBar.add(status_menu); JLabel space_1 = new JLabel(" "); toolBar.add(space_1); JLabel heart_beat_status_label = new JLabel("心跳："); heart_beat_status_label.setHorizontalAlignment(SwingConstants.CENTER); heart_beat_status_label.setForeground(Color.BLACK); heart_beat_status_label.setFont(new Font("微软雅黑", Font.PLAIN, 20)); heart_beat_status_label.setBackground(Color.LIGHT_GRAY); toolBar.add(heart_beat_status_label); heart_beat_menu = new JButton(""); heart_beat_menu.setIcon(new ImageIcon(MesClient.class.getResource("/bg/green_dot.png"))); heart_beat_menu.setForeground(Color.GREEN); heart_beat_menu.setFont(new Font("微软雅黑", Font.PLAIN, 20)); heart_beat_menu.setBackground(Color.BLACK); toolBar.add(heart_beat_menu); JLabel space_2 = new JLabel(" "); toolBar.add(space_2); JLabel user_status_label = new JLabel("登录用户："); user_status_label.setHorizontalAlignment(SwingConstants.CENTER); user_status_label.setForeground(Color.BLACK); user_status_label.setFont(new Font("微软雅黑", Font.PLAIN, 20)); user_status_label.setBackground(Color.LIGHT_GRAY); toolBar.add(user_status_label); user_menu = new JButton(""); user_menu.setForeground(Color.GREEN); user_menu.setFont(new Font("微软雅黑", Font.PLAIN, 22)); user_menu.setBackground(Color.BLACK); toolBar.add(user_menu); JLabel torsional_status_label = new JLabel("扭力扳手状态："); torsional_status_label.setHorizontalAlignment(SwingConstants.CENTER); torsional_status_label.setForeground(Color.BLACK); torsional_status_label.setFont(new Font("微软雅黑", Font.PLAIN, 20)); torsional_status_label.setBackground(Color.LIGHT_GRAY); toolBar.add(torsional_status_label); torsional_menu = new JButton("在线"); torsional_menu.setForeground(Color.red); torsional_menu.setFont(new Font("微软雅黑", Font.PLAIN, 22)); torsional_menu.setBackground(Color.BLACK); toolBar.add(torsional_menu); JLabel space_3 = new JLabel(" "); toolBar.add(space_3); JLabel space_4 = new JLabel(" "); toolBar.add(space_4); tabbedPane = new JTabbedPane(JTabbedPane.TOP); tabbedPane.setMinimumSize(new Dimension(400, 50)); tabbedPane.setFont(new Font("宋体", Font.BOLD, 22)); contentPane.add(tabbedPane); //首页 JPanel indexPanelA = new JPanel(); indexScrollPaneA = new JScrollPane(indexPanelA); indexPanelA.setLayout(null); product_sn = new JTextField(); product_sn.setHorizontalAlignment(SwingConstants.CENTER); product_sn.setEditable(false); product_sn.setFont(new Font("微软雅黑", Font.PLAIN, 28)); product_sn.setBounds(81, 70, 602, 70); indexPanelA.add(product_sn); product_sn.setColumns(10); f_scan_data_bt_1 = new JButton("扫码"); f_scan_data_bt_1.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { scan_type = 1; scanBarcode(); } }); f_scan_data_bt_1.setIcon(new ImageIcon(MesClient.class.getResource("/bg/scan_barcode.png"))); f_scan_data_bt_1.setFont(new Font("微软雅黑", Font.PLAIN, 32)); f_scan_data_bt_1.setBounds(693, 70, 198, 70); indexPanelA.add(f_scan_data_bt_1); finish_ok_bt = new JButton("下一件"); finish_ok_bt.setEnabled(false); finish_ok_bt.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { if(fininsh_flag){ setMenuStatus("结果已提交!",-1); return; } if(connect_request_flag){ setMenuStatus("设备未连接Mes服务器!",-1); return; } if(product_sn.getText().isEmpty()){ setMenuStatus("未扫工件码!",-1); return; } if(work_status == 1 && check_quality_result){ String sn = getBarcode(product_sn.getText()); getUser(); String qret = "OK"; if (cur != max) { qret = "NG"; } Boolean result = DataUtil.sendQuality(sn,qret,user20); if(result) { MesClient.resetScanA(); MesClient.setMenuStatus("结果提交成功，请扫下一件", 0); MesClient.scan_type = 1; // MesClient.scanBarcode(); } else { MesClient.setMenuStatus("结果提交失败，请重试",-1); } } } }); finish_ok_bt.setIcon(new ImageIcon(MesClient.class.getResource("/bg/ok_bg.png"))); finish_ok_bt.setFont(new Font("微软雅黑", Font.PLAIN, 32)); finish_ok_bt.setBounds(357, 457, 240, 80); finish_ok_bt.setEnabled(false); indexPanelA.add(finish_ok_bt); finish_ng_bt = new JButton("NG"); finish_ng_bt.setEnabled(false); finish_ng_bt.setVisible(false); finish_ng_bt.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { if(work_status == 1 && check_quality_result){ String sn = getBarcode(product_sn.getText()); getUser(); String qret = "NG"; Boolean result = DataUtil.sendQuality(sn,qret,user20); if(result) { MesClient.resetScanA(); MesClient.setMenuStatus("结果提交成功，请扫下一件", 0); MesClient.scan_type = 1; MesClient.scanBarcode(); } else { MesClient.setMenuStatus("结果提交失败，请重试",-1); } } } }); finish_ng_bt.setIcon(new ImageIcon(MesClient.class.getResource("/bg/ng_bg.png"))); finish_ng_bt.setFont(new Font("微软雅黑", Font.PLAIN, 32)); finish_ng_bt.setBounds(508, 291, 240, 80); finish_ng_bt.setEnabled(false); indexPanelA.add(finish_ng_bt); monitoring_text = new JTextField(); monitoring_text.setHorizontalAlignment(SwingConstants.CENTER); monitoring_text.setFont(new Font("Dialog", Font.PLAIN, 24)); monitoring_text.setEditable(false); monitoring_text.setColumns(10); monitoring_text.setBounds(264, 310, 150, 60); indexPanelA.add(monitoring_text); JLabel lblNewLabel_1_1 = new JLabel("扭力监控"); lblNewLabel_1_1.setHorizontalAlignment(SwingConstants.RIGHT); lblNewLabel_1_1.setFont(new Font("Dialog", Font.PLAIN, 22)); lblNewLabel_1_1.setBounds(81, 310, 150, 60); indexPanelA.add(lblNewLabel_1_1); JLabel lblNewLabel_1_1_1 = new JLabel("总结果"); lblNewLabel_1_1_1.setHorizontalAlignment(SwingConstants.RIGHT); lblNewLabel_1_1_1.setFont(new Font("Dialog", Font.PLAIN, 22)); lblNewLabel_1_1_1.setBounds(502, 310, 150, 60); indexPanelA.add(lblNewLabel_1_1_1); result_text = new JTextField(); result_text.setHorizontalAlignment(SwingConstants.CENTER); result_text.setFont(new Font("Dialog", Font.PLAIN, 24)); result_text.setEditable(false); result_text.setColumns(10); result_text.setBounds(685, 310, 150, 60); indexPanelA.add(result_text); torsionalMaxValue = new JTextField(); torsionalMaxValue.setHorizontalAlignment(SwingConstants.CENTER); torsionalMaxValue.setFont(new Font("Dialog", Font.PLAIN, 24)); torsionalMaxValue.setEditable(false); torsionalMaxValue.setColumns(10); torsionalMaxValue.setBounds(264, 391, 150, 60); indexPanelA.add(torsionalMaxValue); JLabel lblNewLabel_1_1_2 = new JLabel("扭力值范围"); lblNewLabel_1_1_2.setHorizontalAlignment(SwingConstants.RIGHT); lblNewLabel_1_1_2.setFont(new Font("Dialog", Font.PLAIN, 22)); lblNewLabel_1_1_2.setBounds(81, 391, 150, 60); indexPanelA.add(lblNewLabel_1_1_2); JLabel lblNewLabel_1_1_1_1 = new JLabel("当前扭力值"); lblNewLabel_1_1_1_1.setHorizontalAlignment(SwingConstants.RIGHT); lblNewLabel_1_1_1_1.setFont(new Font("Dialog", Font.PLAIN, 22)); lblNewLabel_1_1_1_1.setBounds(502, 391, 150, 60); indexPanelA.add(lblNewLabel_1_1_1_1); torsionalValue = new JTextField(); torsionalValue.setHorizontalAlignment(SwingConstants.CENTER); torsionalValue.setFont(new Font("Dialog", Font.PLAIN, 24)); torsionalValue.setEditable(false); torsionalValue.setColumns(10); torsionalValue.setBounds(685, 391, 150, 60); indexPanelA.add(torsionalValue); tabbedPane.addTab("工作面板", new ImageIcon(MesClient.class.getResource("/bg/a_side.png")), indexScrollPaneA, null); tabbedPane.setEnabledAt(0, true); indexPanelC = new JPanel(); searchScrollPaneDj = new JScrollPane(indexPanelC); indexPanelC.setLayout(null); tabbedPane.addTab("开班点检", new ImageIcon(MesClient.class.getResource("/bg/menu_data_preprocess.png")), searchScrollPaneDj, null); indexPanelB = new JPanel(); searchScrollPane = new JScrollPane(indexPanelB); indexPanelB.setLayout(null); tabbedPane.addTab("工作记录", new ImageIcon(MesClient.class.getResource("/bg/menu_data_preprocess.png")), searchScrollPane, null); //只有带胶水的有 OP265 indexPanelJs = new JPanel(); searchScrollPaneJs = new JScrollPane(indexPanelJs); indexPanelJs.setLayout(null); // tabbedPane.addTab("胶水寿命", new ImageIcon(MesClient.class.getResource("/bg/menu_data_preprocess.png")), searchScrollPaneJs, null); indexPanelD = new JPanel(); searchScrollPaneD = new JScrollPane(indexPanelD); indexPanelD.setLayout(null); // tabbedPane.addTab("工具寿命", new ImageIcon(MesClient.class.getResource("/bg/menu_data_preprocess.png")), searchScrollPaneD, null); tabbedPane.addChangeListener(new ChangeListener() { @Override public void stateChanged(ChangeEvent e) { JTabbedPane tabbedPane = (JTabbedPane) e.getSource(); int selectedIndex = tabbedPane.getSelectedIndex(); if(selectedIndex == 1){ } } }); } public static void setMenuStatus(String msg,int error){ if(error == 0){ MesClient.status_menu.setForeground(Color.GREEN); }else{ MesClient.status_menu.setForeground(Color.RED); } MesClient.status_menu.setText(msg); } public static void getMaterailData(){ JSONObject retObj = DataUtil.getBindMaterail(); if(retObj.get("result")!=null&&retObj.get("result").toString().equalsIgnoreCase("true")) { java.util.List arrs = retObj.getList("data",BindMaterialResp.class); int i = 0; rowData = new Object[arrs.size()][7]; for (BindMaterialResp bindMaterialResp:arrs){ rowData[i][0] = bindMaterialResp.getMaterialTitle(); rowData[i][1] = bindMaterialResp.getBatchSn(); rowData[i][2] = bindMaterialResp.getLastTimes(); rowData[i][3] = ""; rowData[i][4] = bindMaterialResp.getCraft(); rowData[i][5] = bindMaterialResp.getMaterialId(); rowData[i][6] = bindMaterialResp.getType(); i++; } bindBatchPanel(); } } public static void updateMaterailData(){ JSONObject retObj = DataUtil.getBindMaterail(); if(retObj.get("result")!=null&&retObj.get("result").toString().equalsIgnoreCase("true")) { List arrs = retObj.getList("data",BindMaterialResp.class); int i = 0; for (BindMaterialResp bindMaterialResp:arrs){ rowData[i][0] = bindMaterialResp.getMaterialTitle(); rowData[i][1] = bindMaterialResp.getBatchSn(); rowData[i][2] = bindMaterialResp.getLastTimes(); rowData[i][3] = ""; rowData[i][4] = bindMaterialResp.getCraft(); rowData[i][5] = bindMaterialResp.getMaterialId(); rowData[i][6] = bindMaterialResp.getType(); i++; } MesClient.table.repaint(); } } // 绑定物料批次码 public static void scanBatchSn(BindMaterialResp bindMaterialResp) { //弹窗扫工件码 String scanBarcodeTitle = "请扫物料:"+bindMaterialResp.getMaterialTitle(); String scanBarcode = JOptionPane.showInputDialog(null, scanBarcodeTitle); if(scanBarcode!=null&&!scanBarcode.equalsIgnoreCase("")) { JSONObject retObj = DataUtil.saveBindMaterail(scanBarcode,bindMaterialResp.getCraft(),bindMaterialResp.getMaterialId(),bindMaterialResp.getType()); if(retObj.get("result")!=null&&retObj.get("result").toString().equalsIgnoreCase("true")) { MesClient.setMenuStatus("扫物料:"+bindMaterialResp.getMaterialTitle()+"成功",0); updateMaterailData(); }else{ if(retObj.get("result")==null){ MesClient.setMenuStatus("请求失败，请重试",-1); }else{ if(retObj.get("result").toString().equalsIgnoreCase("false")){ MesClient.setMenuStatus(retObj.getString("message"),-1); } } } } } public static void bindBatchPanel(){ JPanel indexPanelBB = new JPanel(); JPanel panel = new JPanel(); panel.setBounds(0, 0, 990, 550); // panel.setBounds(81, 50, 810, 479); indexPanelBB.add(panel); panel.setLayout(new GridLayout(0, 1, 0, 0)); table = new JTable(rowData, columnNames){ public boolean isCellEditable(int row, int column) { if(column == 3){ return true; } return false; } }; table.setRowHeight(40); table.setEnabled(true); table.setFont(new Font("微软雅黑", Font.PLAIN, 14)); table.getColumnModel().getColumn(3).setCellRenderer(new TableCellRendererButton()); table.getColumnModel().getColumn(3).setCellEditor(new TableCellEditorButton()); JScrollPane scrollPane = new JScrollPane(table); panel.add(scrollPane); JScrollPane indexScrollPaneB = new JScrollPane(indexPanelBB); indexPanelBB.setLayout(null); tabbedPane.addTab("绑定物料", new ImageIcon(MesClient.class.getResource("/bg/menu_data_preprocess.png")), indexScrollPaneB, null); } // 开启发送结果定时任务 public static void startUpdateQualityTimer(){ new Timer().schedule(new TimerTask() { @Override public void run() { try { Statement statement = JdbcUtils.conn.createStatement(); String selectSql = "SELECT id, bw FROM submit_record\n" + "WHERE state = 0"; String updateSql = "UPDATE submit_record \n" + "SET state = '1'\n" + "WHERE id = "; ResultSet rs = statement.executeQuery(selectSql); while(rs.next()){ int id = rs.getInt("id"); String bw = rs.getString("bw"); log.info("submit_record表取数据: id: " + id + " bw:" + bw); // 发送请求 String url = "http://"+MesClient.mes_server_ip+":8980/js/a/mes/mesProductRecord/updateQualityByTiming"; String s = HttpUtils.sendPostRequestJson(url, bw ); Boolean result = JSONObject.parseObject(s).getBoolean("result"); if(result) { // 更改状态为 1 statement.executeUpdate(updateSql + id); } else { log.error("定时任务提交结果失败"); } } rs.close(); statement.close(); } catch (SQLException | IOException e) { // throw new RuntimeException(e); //log.info(e.getMessage()); } } },1000, 5000); } }