e38-op060A-cmt/src/com/mes/ui/MesClient.java

package com.mes.ui;

import com.alibaba.fastjson2.JSON;
import com.alibaba.fastjson2.JSONArray;
import com.alibaba.fastjson2.JSONObject;
import com.github.s7connector.impl.utils.S7Utils;
import com.github.xingshuangs.iot.protocol.modbus.service.ModbusTcp;
import com.github.xingshuangs.iot.protocol.s7.enums.EPlcType;
import com.github.xingshuangs.iot.protocol.s7.service.S7PLC;
import com.mes.component.MesRadio;
import com.mes.component.MesWebView;
import com.mes.component.MyDialog;
import com.mes.netty.NettyClient;
import com.mes.util.DateLocalUtils;
import com.mes.util.HttpUtils;
import com.mes.util.JdbcUtils;
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.ArrayList;
import java.util.Properties;
import java.util.Timer;
import java.util.TimerTask;
import java.util.List;

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;
    public static String mes_gw = "";
    public static String mes_gw_des = "";
    public static String mes_server_ip = "";
    public static int mes_tcp_port = 3000;
    public static int mes_heart_beat_cycle = 10;
    public static int mes_heart_icon_cycle = 1;
    public static String mes_line_sn = "";
    public static String mes_gwflag = ""; // 工位标识

    public static NettyClient nettyClient;
    public static boolean tcp_connect_flag = false;
    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 indexScrollPaneB;
    public static JScrollPane searchScrollPane;
    public static JScrollPane searchScrollPaneDj;
    public static JScrollPane searchScrollPaneGz;

    public static Boolean check_quality_result = false;
    public static Integer work_status = 0;
    public static Integer work_status2 = 0;
    public static Boolean check_quality_result2 = false;

    public static Integer batch_status = 0; //A面 1=已绑定  0=未绑定
    public static Integer batch_status2 = 0; //B面 1=已绑定  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_ok_bt2;
    public static JButton finish_ng_bt;
    public static JButton finish_ng_bt2;
    public static JTextField product_sn;
    public static JLabel pxstatus1;
    public static JLabel pxstatus2;

    public static JButton batch_scan_1;
    public static JButton batch_scan_2;

    public static Integer tjFlag = 0; // 0=未开始 1=已扫码，设备未启动 2=设备运行中 3=设备运行结束

    public static Integer tjFlaga = 0; // 0=未开始 1=已扫码，设备未启动 2=设备运行中 3=设备运行结束
    public static Integer tjFlagb = 0; // 0=未开始 1=已扫码，设备未启动 2=设备运行中 3=设备运行结束

    public static Integer tjStatusa = 0; // 1=提交失败
    public static Integer tjStatusb = 0; // 1=提交失败

    public static String curFlag = ""; // 当前工作的面板

    public static String curSna = "";

    public static String curSnb = "";

    public static String curPage = "";

    public static Integer checkA = 0;

    public static Integer checkB = 0;

    public static Integer lastpage = 0;

    public static Boolean mesQualityFlagA = false; // true=可工作

    public static Boolean mesQualityFlagB = false; // true=可工作

    public static Boolean mesErrorFlagA = false; // true=提交MES失败,手动提交

    public static Boolean mesErrorFlagB = false; // true=提交MES失败，手动提交

    public static String user20 = "";

    public static JFrame welcomeWin;

    public static JPanel indexPanelB;
    public static MesWebView jfxPanel = null;
    public static MesRadio mesRadioHj;
    public static JPanel indexPanelC;
    public static MesWebView jfxPanel2 = null;

    public static S7PLC s7PLC = new S7PLC(EPlcType.S1200, "192.168.7.100"); //100 B工位 新设备

    public static List<String> hjparams = new ArrayList<>();

    public static JTable table;
    public static Object[] columnNames = { "物料名称", "绑定批次", "剩余次数", "操作" };
    public static Object[][] rowData = null;
//    public static Object[][] rowData = {
//    };


    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();

                    //获取当前面
                    textFocus();

                    getPlcParam();
//
                    upParams();
//
                    getPlcParams();

                }catch (Exception e){
                    e.printStackTrace();
                }
            }
        });
    }

    public static Timer cjTimerText;
    public static void textFocus() {
        if(cjTimerText!=null) {
            cjTimerText.cancel();
        }
        cjTimerText = new Timer();
        cjTimerText.schedule(new TimerTask() {
            public void run() {
                txtfa.requestFocusInWindow();

                MesClient.curPage = PlcUtil.getCurAside(s7PLC);
                if(MesClient.curPage .equals("A")){
                    page_text.setText("当前：A面");
                }else{
                    page_text.setText("当前：B面");
                }
            }
        }, 1000,1000);
    }

    public static Timer cjTimer3;
    public static void upParams() {
        if(cjTimer3!=null) {
            cjTimer3.cancel();
        }
        cjTimer3 = new Timer();
        cjTimer3.schedule(new TimerTask() {
            public void run() {
                try{
                    List<CmtReq> prods = JdbcUtils.getCmtParams();
                    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(CmtReq prodReq:prods){
                                JdbcUtils.updateProdSync(prodReq.getId(),1);
                            }
                        }
                    }
                }catch (Exception e){
                    e.printStackTrace();
                }
            }
        }, 1000,30*1000);
    }

    public static Timer cjTimer;
    public static void getPlcParam() {
        if(cjTimer!=null) {
            cjTimer.cancel();
        }
        cjTimer = new Timer();
        cjTimer.schedule(new TimerTask() {
            public void run() {
                try{
                    if(!MesClient.sessionid.isEmpty()){
                        PlcUtil.getStatusA(s7PLC);
                    }
                }catch (Exception e){
                    e.printStackTrace();
                }

                try{
                    if(!MesClient.sessionid.isEmpty()){
                        PlcUtil.getStatusB(s7PLC);
                    }
                }catch (Exception e){
                    e.printStackTrace();
                }
            }
        }, 1000,2000);
    }

    public static Timer cjTimer2;
    public static void getPlcParams() {
        if(cjTimer2!=null) {
            cjTimer2.cancel();
        }
        cjTimer2 = new Timer();
        cjTimer2.schedule(new TimerTask() {
            public void run() {
                try{
                    PlcUtil.getParamDyDl(s7PLC);
                }catch (Exception e){
                    e.printStackTrace();
                }
            }
        }, 1000,1000);
    }

    //鐠囧鍘ょ純顔芥瀮娴狅拷
    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);

        mes_gwflag = pro.getProperty("mes.gwflag");

        System.out.println(mes_gw + ";" + mes_gw_des + ";" + mes_server_ip + ";" + mes_tcp_port + ";" + mes_heart_beat_cycle);
    }

    // 閸掓繂顫愰崠鏈P
    public static void initTcpConnection() {
        try {
            if(nettyClient==null) {
                //閸掓繂顫愰崠鏈P鏉╃偞甯�
                nettyClient = new NettyClient();
                //TCP鏉╃偞甯撮悩鑸碉拷锟�
                tcp_connect_flag = false;
                //鐠佸墽鐤員CP鐠囬攱鐪伴悩鑸碉拷锟�
                connect_request_flag = true;

                DataUtil.synrTcp(nettyClient,mes_gw);
            }
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

    //閸氼垰濮╄箛鍐儲閸栧懐鈻兼惔锟�
    public static java.util.Timer heartBeatTimer;
    public static java.util.Timer heartBeatIconTimer;
    public static boolean iconREDFlag = true;
    public static JTextField param1;
    public static JTextField param2;
    public static JTextField param3;
    public static JTextField param4;
    public static JTextField param5;
    public static JTextField product_sn2;
    public static JTextField param21;
    public static JTextField param22;
    public static JTextField param23;
    public static JTextField param24;
    public static JTextField param25;
    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) {
                    //System.out.println("閸欐垿锟戒礁绺剧捄铏Г閺傦拷");
                    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){
                        System.out.println("TCP瀹稿弶鏌囧锟�");
                        //TCP闁插秵鏌婇崥灞绢劄鏉╃偞甯�
                        if(!connect_request_flag) {
                            //System.out.println("TCP闁插秵鏌婇崥灞绢劄鏉╃偞甯�");
                            //鐠佸墽鐤員CP鐠囬攱鐪伴悩鑸碉拷锟�,閸欘亪鍣搁弬鏉挎倱濮濄儴绻涢幒銉ょ濞嗭拷
                            connect_request_flag = true;

                            DataUtil.synrTcp(nettyClient,mes_gw);
                        }

                    }
                }
            }
        }, 100,mes_heart_icon_cycle*1000);
    }

    //鐠佸墽鐤唗cp鏉╃偞甯撮悩鑸碉拷浣规▔缁�锟�
    public static void setTcpStatus() {
        if(tcp_connect_flag) {
            status_menu.setText("已连接MES服务器");
            heart_beat_menu.setIcon(new ImageIcon(MesClient.class.getResource("/bg/grey_dot.png")));
            heart_beat_menu.repaint();
        }else {
            status_menu.setText("未连接MES服务器");
            heart_beat_menu.setIcon(new ImageIcon(MesClient.class.getResource("/bg/grey_dot.png")));
            heart_beat_menu.repaint();
        }
    }

    public static void initWarehouseData(){
        resetScanA();
        resetScanB();

    }

    public static void resetScanA() {
        work_status = 0;
        check_quality_result = false;
        MesClient.finish_ok_bt.setEnabled(false);
        MesClient.mesQualityFlagA = false;
        product_sn.setText("");
        MesClient.pxstatus1.setText("A");

        PlcUtil.changeEnable(s7PLC,false);

        MesClient.param1.setText("");
        MesClient.param2.setText("");
        MesClient.param3.setText("");
        MesClient.param4.setText("");
        MesClient.param5.setText("");

        MesClient.param21.setText("");
        MesClient.param22.setText("");
        MesClient.param23.setText("");
        MesClient.param24.setText("");
        MesClient.param25.setText("");

        MesClient.curSna = "";
        MesClient.tjFlaga = 0;
        MesClient.checkA = 0;

//        MesClient.batch_status = 0;
//        MesClient.textField.setText("");
//        MesClient.batch_scan_1.setEnabled(false);
        MesClient.formatScanType(1);
//        PlcUtil.changeEnable(MesClient.s7PLC,false);

        finish_ok_bt.setEnabled(false);
        finish_ng_bt.setEnabled(false);

        updateMaterailData(); // 更新物料

        shiftUserCheck();
    }

    public static int userLoginHours;//用户登录所处小时
    public static JTextField textField;
    public static JTextField textField_1;
    public static JTextField txtfa;
    public static JLabel scan_type_text;
    public static JLabel page_text;
    //换班用户信息检查
    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() {
        work_status2 = 0;
        check_quality_result2 = false;
        MesClient.finish_ng_bt.setEnabled(false);
        MesClient.mesQualityFlagB = false;
        product_sn2.setText("");

        PlcUtil.changeEnable(s7PLC,false);

        MesClient.pxstatus2.setText("B");
        MesClient.param1.setText("");
        MesClient.param2.setText("");
        MesClient.param3.setText("");
        MesClient.param4.setText("");
        MesClient.param5.setText("");

        MesClient.param21.setText("");
        MesClient.param22.setText("");
        MesClient.param23.setText("");
        MesClient.param24.setText("");
        MesClient.param25.setText("");
        MesClient.curSnb = "";
        MesClient.tjFlagb = 0;
        MesClient.checkB = 0;

//        MesClient.batch_status2 = 0;
//        MesClient.textField_1.setText("");
//        MesClient.batch_scan_2.setEnabled(false);
        MesClient.formatScanType(1);
//        PlcUtil.changeEnable(MesClient.s7PLC,false);
        finish_ok_bt2.setEnabled(false);
        finish_ng_bt2.setEnabled(false);


        updateMaterailData(); // 更新物料

//        shiftUserCheck();
    }

    //閼惧嘲褰囬悽銊﹀煕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;
    }

    //閼惧嘲褰嘼arcode閸愬懎顔�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 logoff() {
        welcomeWin.setVisible(true);
        mesClientFrame.setVisible(false);

        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("\u7528\u6237");
        fileMenu.setIcon(new ImageIcon(MesClient.class.getResource("/bg/user.png")));
        fileMenu.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 20));
        menuBar.add(fileMenu);

        JMenuItem exitMenuItem = new JMenuItem("退出");
        exitMenuItem.setIcon(new ImageIcon(MesClient.class.getResource("/bg/logoff.png")));
        exitMenuItem.setFont(new Font("Microsoft YaHei UI", 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("Microsoft YaHei UI", Font.PLAIN, 20));
        menuBar.add(settingMenu);

        JMenuItem resetTcpMenu = new JMenuItem("\u91CD\u8FDEMES");
        resetTcpMenu.setIcon(new ImageIcon(MesClient.class.getResource("/bg/reset_logo.png")));
        resetTcpMenu.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 20));
        resetTcpMenu.addMouseListener(new MouseAdapter() {
            @Override
            public void mousePressed(MouseEvent e) {
                super.mouseClicked(e);
                //闁插秷绻沵es
                nettyClient.future.channel().close();
            }
        });
        settingMenu.add(resetTcpMenu);

        JMenuItem resetTcpMenu_1 = new JMenuItem("\u91CD\u65B0\u626B\u7801-A");
        resetTcpMenu_1.setIcon(new ImageIcon(MesClient.class.getResource("/bg/reset_logo.png")));
        resetTcpMenu_1.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 20));
        resetTcpMenu_1.addMouseListener(new MouseAdapter() {
            @Override
            public void mousePressed(MouseEvent e) {
                super.mouseClicked(e);
                resetScanA();
            }
        });
        settingMenu.add(resetTcpMenu_1);

        JMenuItem resetTcpMenu_1_1 = new JMenuItem("\u91CD\u65B0\u626B\u7801-B");
        resetTcpMenu_1_1.setIcon(new ImageIcon(MesClient.class.getResource("/bg/reset_logo.png")));
        resetTcpMenu_1_1.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 20));
        resetTcpMenu_1_1.addMouseListener(new MouseAdapter() {
            @Override
            public void mousePressed(MouseEvent e) {
                super.mouseClicked(e);
                resetScanB();
            }
        });
        settingMenu.add(resetTcpMenu_1_1);

        JMenuItem resetTcpMenu_1sd = new JMenuItem("手动提交-A");
        resetTcpMenu_1sd.setIcon(new ImageIcon(MesClient.class.getResource("/bg/reset_logo.png")));
        resetTcpMenu_1sd.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 20));
        resetTcpMenu_1sd.addMouseListener(new MouseAdapter() {
            @Override
            public void mousePressed(MouseEvent e) {
                super.mouseClicked(e);
                finish_ok_bt.setEnabled(true);
                finish_ng_bt.setEnabled(true);
//                MesClient.finish_ok_bt.setEnabled(true);
//                if(MesClient.work_status == 1){
//                    Boolean sendret = DataUtil.sendQuality(MesClient.nettyClient,MesClient.product_sn.getText(),"OK",MesClient.user20,"A");
//                    if(!sendret){
//                        MesClient.pxstatus1.setText("A:结果上传MES失败");
//                        MesClient.tjStatusa = 1;
//                    }
//                }
            }
        });
        settingMenu.add(resetTcpMenu_1sd);

        JMenuItem resetTcpMenu_1_1sd = new JMenuItem("手动提交-B");
        resetTcpMenu_1_1sd.setIcon(new ImageIcon(MesClient.class.getResource("/bg/reset_logo.png")));
        resetTcpMenu_1_1sd.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 20));
        resetTcpMenu_1_1sd.addMouseListener(new MouseAdapter() {
            @Override
            public void mousePressed(MouseEvent e) {
                super.mouseClicked(e);
                finish_ok_bt2.setEnabled(true);
                finish_ng_bt2.setEnabled(true);
//                MesClient.finish_ng_bt.setEnabled(true);
//                Boolean sendret = DataUtil.sendQuality(MesClient.nettyClient,MesClient.product_sn2.getText(),"OK",MesClient.user20,"B");
//                if(!sendret){
//                    MesClient.pxstatus2.setText("B:结果上传MES失败");
//                    MesClient.tjStatusb = 1;
//                }
            }
        });
        settingMenu.add(resetTcpMenu_1_1sd);

        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("\u72B6\u6001\uFF1A");
        equipment_statu_label.setHorizontalAlignment(SwingConstants.CENTER);
        equipment_statu_label.setForeground(Color.BLACK);
        equipment_statu_label.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 20));
        equipment_statu_label.setBackground(Color.LIGHT_GRAY);
        toolBar.add(equipment_statu_label);

        status_menu = new JButton("设备未连接MES服务器");
        if(tcp_connect_flag) {
            status_menu.setText("已连接MES服务器");
            status_menu.setForeground(Color.GREEN);
        }else {
            status_menu.setText("未连接MES服务器");
            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("Microsoft YaHei UI", 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("\u5FC3\u8DF3\uFF1A");
        heart_beat_status_label.setHorizontalAlignment(SwingConstants.CENTER);
        heart_beat_status_label.setForeground(Color.BLACK);
        heart_beat_status_label.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 20));
        heart_beat_status_label.setBackground(Color.LIGHT_GRAY);
        toolBar.add(heart_beat_status_label);

        heart_beat_menu = new JButton("2024-02-20 23:20:10");
        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("Microsoft YaHei UI", 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("\u767B\u5F55\u7528\u6237\uFF1A");
        user_status_label.setHorizontalAlignment(SwingConstants.CENTER);
        user_status_label.setForeground(Color.BLACK);
        user_status_label.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 20));
        user_status_label.setBackground(Color.LIGHT_GRAY);
        toolBar.add(user_status_label);

        user_menu = new JButton("JinJuShi");
        user_menu.setForeground(Color.GREEN);
        user_menu.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 22));
        user_menu.setBackground(Color.BLACK);
        toolBar.add(user_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("Microsoft YaHei UI", Font.BOLD, 22));
        contentPane.add(tabbedPane);

        //妫ｆ牠銆�
        JPanel indexPanelA = new JPanel();
        indexScrollPaneA = new JScrollPane(indexPanelA);
        indexPanelA.setLayout(null);

        product_sn = new JTextField();
        product_sn.setText("");
        product_sn.setHorizontalAlignment(SwingConstants.CENTER);
        product_sn.setEditable(false);
        product_sn.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 22));
        product_sn.setBounds(26, 152, 446, 70);
        indexPanelA.add(product_sn);
        product_sn.setColumns(10);

//        String[] hjtitles = new String[]{"閻掑﹥婧�1","閻掑﹥婧�2","閻掑﹥婧�3"};
//        String[] hjvals = new String[]{"HJ001","HJ002","HJ003"};
//        mesRadioHj = new MesRadio(hjtitles,hjvals);
//        mesRadioHj.setSize(500,50);
//        mesRadioHj.setBounds(190,170,500,50);
//        indexPanelA.add(mesRadioHj);

        finish_ok_bt = new JButton("OK");
        finish_ok_bt.setEnabled(false);
        finish_ok_bt.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
//                if(work_status == 1 && check_quality_result){
//
//
//                }
                String sn = getBarcode(product_sn.getText());
                getUser();

                if(!sn.isEmpty()){
                    String qret = "OK";
                    Boolean sendret = DataUtil.sendQuality(nettyClient,sn,qret,user20,"A");
                    if(!sendret){
                        MesClient.pxstatus1.setText("A:结果上传MES失败");
                        MesClient.tjStatusa = 1;
                    }else{
                        MesClient.pxstatus1.setText("A:提交成功");
                        MesClient.status_menu.setText("A件提交成功");
                        MesClient.resetScanA();
                    }
                }



            }
        });
        finish_ok_bt.setIcon(new ImageIcon(MesClient.class.getResource("/bg/ok_bg.png")));
        finish_ok_bt.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 32));
        finish_ok_bt.setBounds(50, 380, 160, 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.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
//                if(work_status == 1 && check_quality_result){
//
//                    String sn = getBarcode(product_sn.getText());
//                    getUser();
//                    String qret = "OK";
//                    Boolean sendret = DataUtil.sendQuality(nettyClient,sn,qret,user20,"B");
//                    if(!sendret){
//                        JOptionPane.showMessageDialog(mesClientFrame,"上传MES失败，请重试","提醒", JOptionPane.INFORMATION_MESSAGE);
//                        return;
//                    }
//                }
                String sn = getBarcode(product_sn2.getText());
                getUser();

                if(!sn.isEmpty()){
                    String qret = "OK";
                    Boolean sendret = DataUtil.sendQuality(nettyClient,sn,qret,user20,"B");
                    if(!sendret){
                        MesClient.pxstatus2.setText("B:结果上传MES失败");
                        MesClient.tjStatusb = 1;
                    }else{
                        MesClient.pxstatus2.setText("B:提交成功");
                        MesClient.status_menu.setText("B件提交成功");
                        MesClient.resetScanB();
                    }
                }
            }
        });
        finish_ng_bt.setIcon(new ImageIcon(MesClient.class.getResource("/bg/ok_bg.png")));
        finish_ng_bt.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 32));
        finish_ng_bt.setBounds(280, 380, 160, 80);
        finish_ng_bt.setEnabled(false);
//        indexPanelA.add(finish_ng_bt);



        finish_ok_bt2 = new JButton("OK");
        finish_ok_bt2.setEnabled(false);
        finish_ok_bt2.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
//                if(work_status == 1 && check_quality_result){
//
//
//                }
                String sn = getBarcode(product_sn.getText());
                getUser();

                if(!sn.isEmpty()){
                    String qret = "OK";
                    Boolean sendret = DataUtil.sendQuality(nettyClient,sn,qret,user20,"B");
                    if(!sendret){
                        MesClient.pxstatus2.setText("B:结果上传MES失败");
                        MesClient.tjStatusb = 1;
                    }else{
                        MesClient.pxstatus2.setText("B:提交成功");
                        MesClient.status_menu.setText("B件提交成功");
                        MesClient.resetScanB();
                    }
                }



            }
        });
        finish_ok_bt2.setIcon(new ImageIcon(MesClient.class.getResource("/bg/ok_bg.png")));
        finish_ok_bt2.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 32));
        finish_ok_bt2.setBounds(550, 380, 160, 80);
        finish_ok_bt2.setEnabled(false);
//        indexPanelA.add(finish_ok_bt2);

        finish_ng_bt2 = new JButton("NG");
        finish_ng_bt2.setEnabled(false);
        finish_ng_bt2.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
//                if(work_status == 1 && check_quality_result){
//
//                    String sn = getBarcode(product_sn.getText());
//                    getUser();
//                    String qret = "OK";
//                    Boolean sendret = DataUtil.sendQuality(nettyClient,sn,qret,user20,"B");
//                    if(!sendret){
//                        JOptionPane.showMessageDialog(mesClientFrame,"上传MES失败，请重试","提醒", JOptionPane.INFORMATION_MESSAGE);
//                        return;
//                    }
//                }
                String sn = getBarcode(product_sn2.getText());
                getUser();

                if(!sn.isEmpty()){
                    String qret = "NG";
                    Boolean sendret = DataUtil.sendQuality(nettyClient,sn,qret,user20,"B");
                    if(!sendret){
                        MesClient.pxstatus2.setText("B:结果上传MES失败");
                        MesClient.tjStatusb = 1;
                    }else{
                        MesClient.pxstatus2.setText("B:提交成功");
                        MesClient.status_menu.setText("B件提交成功");
                        MesClient.resetScanB();
                    }
                }
            }
        });
        finish_ng_bt2.setIcon(new ImageIcon(MesClient.class.getResource("/bg/ok_bg.png")));
        finish_ng_bt2.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 32));
        finish_ng_bt2.setBounds(780, 380, 160, 80);
        finish_ng_bt2.setEnabled(false);
        indexPanelA.add(finish_ng_bt2);

        JLabel lblNewLabel = new JLabel("电压");
        lblNewLabel.setHorizontalAlignment(SwingConstants.RIGHT);
        lblNewLabel.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        lblNewLabel.setBounds(26, 340, 100, 40);
        lblNewLabel.setVisible(false);
        indexPanelA.add(lblNewLabel);

        JLabel lblNewLabel_1 = new JLabel("电流");
        lblNewLabel_1.setHorizontalAlignment(SwingConstants.RIGHT);
        lblNewLabel_1.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        lblNewLabel_1.setBounds(226, 340, 100, 40);
        lblNewLabel_1.setVisible(false);
        indexPanelA.add(lblNewLabel_1);

        param1 = new JTextField();
        param1.setEnabled(false);
        param1.setEditable(false);
        param1.setHorizontalAlignment(SwingConstants.CENTER);
        param1.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        param1.setBounds(136, 340, 70, 40);
        param1.setVisible(false);
        indexPanelA.add(param1);
        param1.setColumns(10);

        param2 = new JTextField();
        param2.setEnabled(false);
        param2.setEditable(false);
        param2.setHorizontalAlignment(SwingConstants.CENTER);
        param2.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        param2.setColumns(10);
        param2.setBounds(345, 340, 70, 40);
        param2.setVisible(false);
        indexPanelA.add(param2);

        JLabel lblNewLabel_2 = new JLabel("送丝速度");
        lblNewLabel_2.setHorizontalAlignment(SwingConstants.RIGHT);
        lblNewLabel_2.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        lblNewLabel_2.setBounds(26, 401, 100, 40);
        lblNewLabel_2.setVisible(false);
        indexPanelA.add(lblNewLabel_2);

        param3 = new JTextField();
        param3.setEnabled(false);
        param3.setEditable(false);
        param3.setHorizontalAlignment(SwingConstants.CENTER);
        param3.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        param3.setColumns(10);
        param3.setBounds(136, 401, 70, 40);
        param3.setVisible(false);
        indexPanelA.add(param3);

        JLabel lblNewLabel_1_1 = new JLabel("错误代码");
        lblNewLabel_1_1.setHorizontalAlignment(SwingConstants.RIGHT);
        lblNewLabel_1_1.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        lblNewLabel_1_1.setBounds(213, 401, 122, 40);
        lblNewLabel_1_1.setVisible(false);
        indexPanelA.add(lblNewLabel_1_1);

        param4 = new JTextField();
        param4.setEnabled(false);
        param4.setEditable(false);
        param4.setHorizontalAlignment(SwingConstants.CENTER);
        param4.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        param4.setColumns(10);
        param4.setBounds(345, 401, 70, 40);
        param4.setVisible(false);
        indexPanelA.add(param4);

        param5 = new JTextField();
        param5.setEnabled(false);
        param5.setEditable(false);
        param5.setHorizontalAlignment(SwingConstants.CENTER);
        param5.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        param5.setColumns(10);
        param5.setBounds(226, 470, 70, 40);
        param5.setVisible(false);
        indexPanelA.add(param5);

        JLabel lblNewLabel_1_1_1 = new JLabel("JOB号");
        lblNewLabel_1_1_1.setHorizontalAlignment(SwingConstants.RIGHT);
        lblNewLabel_1_1_1.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        lblNewLabel_1_1_1.setBounds(106, 470, 122, 40);
        lblNewLabel_1_1_1.setVisible(false);
        indexPanelA.add(lblNewLabel_1_1_1);

        product_sn2 = new JTextField();
        product_sn2.setText("");
        product_sn2.setHorizontalAlignment(SwingConstants.CENTER);
        product_sn2.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 22));
        product_sn2.setEditable(false);
        product_sn2.setColumns(10);
        product_sn2.setBounds(517, 152, 446, 70);
        indexPanelA.add(product_sn2);

        JSeparator separator = new JSeparator();
        separator.setBounds(450, 247, 0, 120);
        indexPanelA.add(separator);

        JSeparator separator_1 = new JSeparator();
        separator_1.setOrientation(SwingConstants.VERTICAL);
        separator_1.setBounds(495, 91, 23, 250);
        indexPanelA.add(separator_1);

        JLabel lblNewLabel_3 = new JLabel("电压");
        lblNewLabel_3.setHorizontalAlignment(SwingConstants.RIGHT);
        lblNewLabel_3.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        lblNewLabel_3.setBounds(528, 340, 100, 40);
        lblNewLabel_3.setVisible(false);
        indexPanelA.add(lblNewLabel_3);

        param21 = new JTextField();
        param21.setEnabled(false);
        param21.setEditable(false);
        param21.setHorizontalAlignment(SwingConstants.CENTER);
        param21.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        param21.setColumns(10);
        param21.setBounds(638, 340, 70, 40);
        param21.setVisible(false);
        indexPanelA.add(param21);

        JLabel lblNewLabel_1_2 = new JLabel("电流");
        lblNewLabel_1_2.setHorizontalAlignment(SwingConstants.RIGHT);
        lblNewLabel_1_2.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        lblNewLabel_1_2.setBounds(742, 340, 100, 40);
        lblNewLabel_1_2.setVisible(false);
        indexPanelA.add(lblNewLabel_1_2);

        param22 = new JTextField();
        param22.setEnabled(false);
        param22.setEditable(false);
        param22.setHorizontalAlignment(SwingConstants.CENTER);
        param22.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        param22.setColumns(10);
        param22.setBounds(852, 340, 70, 40);
        param22.setVisible(false);
        indexPanelA.add(param22);

        JLabel lblNewLabel_2_1 = new JLabel("送丝速度");
        lblNewLabel_2_1.setHorizontalAlignment(SwingConstants.RIGHT);
        lblNewLabel_2_1.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        lblNewLabel_2_1.setBounds(528, 401, 100, 40);
        lblNewLabel_2_1.setVisible(false);
        indexPanelA.add(lblNewLabel_2_1);

        param23 = new JTextField();
        param23.setEnabled(false);
        param23.setEditable(false);
        param23.setHorizontalAlignment(SwingConstants.CENTER);
        param23.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        param23.setColumns(10);
        param23.setBounds(638, 401, 70, 40);
        param23.setVisible(false);
        indexPanelA.add(param23);

        JLabel lblNewLabel_1_1_2 = new JLabel("错误代码");
        lblNewLabel_1_1_2.setHorizontalAlignment(SwingConstants.RIGHT);
        lblNewLabel_1_1_2.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        lblNewLabel_1_1_2.setBounds(718, 401, 122, 40);
        lblNewLabel_1_1_2.setVisible(false);
        indexPanelA.add(lblNewLabel_1_1_2);

        param24 = new JTextField();
        param24.setEnabled(false);
        param24.setEditable(false);
        param24.setHorizontalAlignment(SwingConstants.CENTER);
        param24.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        param24.setColumns(10);
        param24.setBounds(852, 401, 70, 40);
        param24.setVisible(false);
        indexPanelA.add(param24);

        JLabel lblNewLabel_1_1_1_1 = new JLabel("JOB号");
        lblNewLabel_1_1_1_1.setHorizontalAlignment(SwingConstants.RIGHT);
        lblNewLabel_1_1_1_1.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        lblNewLabel_1_1_1_1.setBounds(609, 470, 122, 40);
        lblNewLabel_1_1_1_1.setVisible(false);
        lblNewLabel_1_1_1_1.setVisible(false);
        indexPanelA.add(lblNewLabel_1_1_1_1);

        param25 = new JTextField();
        param25.setEnabled(false);
        param25.setEditable(false);
        param25.setHorizontalAlignment(SwingConstants.CENTER);
        param25.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
        param25.setColumns(10);
        param25.setBounds(742, 470, 70, 40);
        param25.setVisible(false);
        indexPanelA.add(param25);

        pxstatus1 = new JLabel("A");
        pxstatus1.setForeground(new Color(255, 128, 64));
        pxstatus1.setHorizontalAlignment(SwingConstants.CENTER);
        pxstatus1.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 20));
        pxstatus1.setBounds(26, 98, 446, 44);
        indexPanelA.add(pxstatus1);

        pxstatus2 = new JLabel("B");
        pxstatus2.setForeground(new Color(255, 128, 64));
        pxstatus2.setHorizontalAlignment(SwingConstants.CENTER);
        pxstatus2.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 20));
        pxstatus2.setBounds(517, 98, 446, 44);
        indexPanelA.add(pxstatus2);

        JSeparator separator_2 = new JSeparator();
        separator_2.setBounds(10, 264, 973, 13);
//        indexPanelA.add(separator_2);

        JLabel lblNewLabel_4 = new JLabel("\u710A\u673A1");
        lblNewLabel_4.setHorizontalAlignment(SwingConstants.CENTER);
        lblNewLabel_4.setFont(new Font("微软雅黑", Font.PLAIN, 24));
        lblNewLabel_4.setBounds(170, 290, 156, 40);
        lblNewLabel_4.setVisible(false);
//        indexPanelA.add(lblNewLabel_4);

        JLabel lblNewLabel_4_1 = new JLabel("\u710A\u673A2");
        lblNewLabel_4_1.setHorizontalAlignment(SwingConstants.CENTER);
        lblNewLabel_4_1.setFont(new Font("微软雅黑", Font.PLAIN, 24));
        lblNewLabel_4_1.setBounds(670, 287, 156, 40);
        lblNewLabel_4_1.setVisible(false);
//        indexPanelA.add(lblNewLabel_4_1);

        JSeparator separator_1_1 = new JSeparator();
        separator_1_1.setOrientation(SwingConstants.VERTICAL);
        separator_1_1.setBounds(495, 278, 23, 232);
        indexPanelA.add(separator_1_1);

        textField = new JTextField();
        textField.setText("");
        textField.setHorizontalAlignment(SwingConstants.CENTER);
        textField.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 22));
        textField.setEditable(false);
        textField.setColumns(10);
        textField.setBounds(26, 333, 446, 70);
//        indexPanelA.add(textField);

        batch_scan_1 = new JButton("解绑");
        batch_scan_1.setIcon(new ImageIcon(MesClient.class.getResource("/bg/delete.png")));
        batch_scan_1.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 32));
        batch_scan_1.setEnabled(false);
        batch_scan_1.setVisible(false);
        batch_scan_1.setBounds(136, 430, 230, 80);
        batch_scan_1.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                if(MesClient.curPage.equals("B")){
                    MesClient.setMenuStatus("该状态后梁无法解绑",-1);
                }else{
                    String sn = MesClient.product_sn.getText().trim();
                    String wsn = MesClient.textField.getText().trim();
                    JSONObject retObj = DataUtil.unBindWarehouseData(sn,wsn,user_menu.getText().trim(),"400007");
                    if(retObj.get("result")!=null&&retObj.get("result").toString().equalsIgnoreCase("true")) {
                        MesClient.setMenuStatus("后梁码解绑成功",0);
                        MesClient.formatScanType(2);

                        textField.setText("");
                        batch_scan_1.setEnabled(false);
                        PlcUtil.changeEnable(s7PLC,false);
                    }else{
                        MesClient.formatScanType(2);
                        batch_scan_1.setEnabled(true);
                        if(retObj.get("result")==null){
                            MesClient.setMenuStatus("请求失败，后梁码解绑失败，请重试",-1);
                        }else{
                            if(retObj.get("result").toString().equalsIgnoreCase("false")){
                                MesClient.setMenuStatus(retObj.getString("message"),-1);
                            }
                        }
                    }
                }
            }
        });
        indexPanelA.add(batch_scan_1);

        textField_1 = new JTextField();
        textField_1.setText("");
        textField_1.setHorizontalAlignment(SwingConstants.CENTER);
        textField_1.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 22));
        textField_1.setEditable(false);
        textField_1.setColumns(10);
        textField_1.setBounds(517, 333, 446, 70);
//        indexPanelA.add(textField_1);

        batch_scan_2 = new JButton("解绑");
        batch_scan_2.setIcon(new ImageIcon(MesClient.class.getResource("/bg/delete.png")));
        batch_scan_2.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 32));
        batch_scan_2.setEnabled(false);
        batch_scan_2.setVisible(false);
        batch_scan_2.setBounds(633, 430, 230, 80);
        batch_scan_2.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                if(MesClient.curPage.equals("A")){
                    MesClient.setMenuStatus("该状态后梁无法解绑",-1);
                }else{
                    String sn = MesClient.product_sn2.getText().trim();
                    String wsn = MesClient.textField_1.getText().trim();
                    JSONObject retObj = DataUtil.unBindWarehouseData(sn,wsn,user_menu.getText().trim(),"400007");
                    if(retObj.get("result")!=null&&retObj.get("result").toString().equalsIgnoreCase("true")) {
                        MesClient.setMenuStatus("后梁码解绑成功",0);
                        MesClient.formatScanType(2);
                        textField_1.setText("");
                        batch_scan_2.setEnabled(false);
                        PlcUtil.changeEnable(s7PLC,false);
                    }else{
                        if(retObj.get("result")==null){
                            MesClient.setMenuStatus("请求失败，前梁码解绑失败，请重试",-1);
                        }else{
                            if(retObj.get("result").toString().equalsIgnoreCase("false")){
                                MesClient.setMenuStatus(retObj.getString("message"),-1);
                            }
                        }
                    }
                }
            }
        });
        indexPanelA.add(batch_scan_2);

        JLabel pxstatus1_1 = new JLabel("A后梁");
        pxstatus1_1.setHorizontalAlignment(SwingConstants.CENTER);
        pxstatus1_1.setForeground(new Color(0, 0, 0));
        pxstatus1_1.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 20));
        pxstatus1_1.setBounds(26, 283, 446, 44);
//        indexPanelA.add(pxstatus1_1);

        JLabel pxstatus1_1_1 = new JLabel("B后梁");
        pxstatus1_1_1.setHorizontalAlignment(SwingConstants.CENTER);
        pxstatus1_1_1.setForeground(Color.BLACK);
        pxstatus1_1_1.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 20));
        pxstatus1_1_1.setBounds(517, 283, 446, 44);
//        indexPanelA.add(pxstatus1_1_1);

        txtfa = new JTextField();
        txtfa.setHorizontalAlignment(SwingConstants.LEFT);
        txtfa.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 22));
        txtfa.setColumns(10);
        txtfa.setBounds(239, 10, 503, 60);
        indexPanelA.add(txtfa);
        txtfa.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                scanBarcode();
            }
        });

        page_text = new JLabel("当前:A面");
        page_text.setForeground(new Color(0, 255, 64));
        page_text.setFont(new Font("微软雅黑", Font.PLAIN, 20));
        page_text.setHorizontalAlignment(SwingConstants.RIGHT);
        page_text.setBounds(97, 10, 132, 60);
        indexPanelA.add(page_text);

        scan_type_text = new JLabel("镭雕码");
        scan_type_text.setForeground(new Color(255, 128, 64));
        scan_type_text.setHorizontalAlignment(SwingConstants.LEFT);
        scan_type_text.setFont(new Font("微软雅黑", Font.PLAIN, 20));
        scan_type_text.setBounds(752, 10, 132, 60);
        indexPanelA.add(scan_type_text);

        tabbedPane.addTab("工作面板", new ImageIcon(MesClient.class.getResource("/bg/a_side.png")), indexScrollPaneA, null);
        tabbedPane.setEnabledAt(0, true);



        JPanel indexPanelGz = new JPanel();
        searchScrollPaneGz = new JScrollPane(indexPanelGz);
        indexPanelGz.setLayout(null);


        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);

//        bindBatchPanel();

        tabbedPane.addChangeListener(new ChangeListener() {
            @Override
            public void stateChanged(ChangeEvent e) {
                JTabbedPane tabbedPane = (JTabbedPane) e.getSource();
                int selectedIndex = tabbedPane.getSelectedIndex();
                System.out.println("selectedIndex:"+selectedIndex);

                if(selectedIndex == 1){

                }
            }
        });
    }

    public static void formatScanType(int st){
        scan_type = st;
        if(scan_type == 1){
            scan_type_text.setText("镭雕码");
        }else if(scan_type == 2){
            scan_type_text.setText("后梁码");
        }else{
            scan_type_text.setText("");
        }
    }

    public static void scanBarcode() {
        String scanBarcodeSn = txtfa.getText().trim();
        txtfa.setText("");
        System.out.println("scan_type:"+scan_type);
        //刷新界面
        mesClientFrame.repaint();
        System.out.println("456");
        System.out.println("156"+scan_type);
        if(MesClient.scan_type == 1){ // 镭雕码
            System.out.println("type1");
            if(scanBarcodeSn.isEmpty()){
                System.out.println("type2");
                MesClient.setMenuStatus("镭雕码不能为空",1);
                return;
            }
            if(MesClient.curPage.equals("A")){
                System.out.println("typeA");
                if(!product_sn.getText().isEmpty() && mesQualityFlagA){
                    MesClient.setMenuStatus("A面已存在工件码，勿重复扫码",1);
                    return;
                }
                product_sn.setText(scanBarcodeSn);
            }else{
                System.out.println("typeB");
                if(!product_sn2.getText().isEmpty() && mesQualityFlagB){
                    MesClient.setMenuStatus("B面已存在工件码，勿重复扫码",1);
                    return;
                }
                product_sn2.setText(scanBarcodeSn);
            }
            MesClient.setMenuStatus("扫码成功",0);

            //刷新界面
            mesClientFrame.repaint();
            System.out.println("123");
            getUser();
            // 查询工件质量
            Boolean sendret = DataUtil.checkQuality(nettyClient,scanBarcodeSn,user20,MesClient.curPage);
            if(!sendret){
                MesClient.setMenuStatus("消息发送失败，请重试",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")) {
            List<BindMaterialResp> 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<BindMaterialResp> 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);

        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 {
                    JdbcUtils.getConn();
                    Statement statement = JdbcUtils.conn.createStatement();
                    String selectSql = "SELECT id, bw FROM submit_record\n" +
                            "WHERE state = 0 ORDER BY id DESC LIMIT 10";
                    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");
                        // 发送请求
                        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);
                        }
                    }
                    rs.close();
                    statement.close();
                } catch (SQLException | IOException e) {
//                    throw new RuntimeException(e);
                    e.printStackTrace();
                }

            }
        },1000, 5000);
    }

    public static void formatBatchSn(){
        if((MesClient.batch_status == 1 && MesClient.tjFlaga == 1) || (MesClient.batch_status2 == 1 && MesClient.tjFlagb == 1)){
            PlcUtil.changeEnable(MesClient.s7PLC,true);
        }else{
            PlcUtil.changeEnable(MesClient.s7PLC,false);
        }
    }

    private static String checkSnType(String sn){
        String str = sn.substring(9,12);
        if(str.equals("113")){
            return "MX11-2";
        }else if(str.equals("119")){
            return "MX11-2S";
        }else{
            return "";
        }
    }

    // 检查工件是否匹配
    private static Boolean checkSnAndBatch(String sn,String batchSn){
        String gdStr1 = "151245P000012131001000"; // MX11-2
        String gdStr2 = "151245P000017812001000"; // MX11-2S
        String cate = sn.substring(0,22);
        String ptype = checkSnType(batchSn);
        if(ptype.equals("MX11-2") && cate.equals(gdStr1)){
            return true;
        }
        if(ptype.equals("MX11-2S") && cate.equals(gdStr2)){
            return true;
        }
        return false;
    }
}