package lgcsgwxt.dialog;

import java.awt.BorderLayout;
import java.awt.Frame;
import java.sql.*;
import javax.swing.JDialog;
import javax.swing.JPanel;
import java.awt.Rectangle;
import javax.swing.JLabel;
import javax.swing.JComboBox;
import javax.swing.JTextField;
import javax.swing.BorderFactory;
import javax.swing.JTable;
import java.util.Vector;
import javax.swing.JScrollPane;
import javax.swing.table.JTableHeader;
import javax.swing.JButton;
import java.awt.Color;
import java.util.Timer;
import lgcsgwxt.means.GetTime;
import java.util.TimerTask;
import java.awt.Font;
import javax.swing.JTextArea;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JOptionPane;
import lgcsgwxt.means.*;
import java.awt.event.FocusEvent;
import java.awt.event.FocusAdapter;

/**
 * <p>Title: 魯廣超市進銷存系統</p>
 *
 * <p>Description: 北大青鳥魯廣校區S1畢業設計</p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: ST-117班</p>
 *
 * @author ST-117班第二小組
 * @version 1.0
 */
public class JoinAndExceed extends JDialog {
    Timestamp ts = new Timestamp(System.currentTimeMillis());
    JPanel panel1 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JComboBox jComboBox1 = new JComboBox();
    JLabel jLabel2 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JLabel jLabel3 = new JLabel();
    JComboBox jComboBox2 = new JComboBox();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JTextField jTextField2 = new JTextField();
    JLabel jLabel7 = new JLabel();
    JTextField jTextField3 = new JTextField();
    JLabel jLabel8 = new JLabel();
    JTextField jTextField4 = new JTextField();
    JLabel jLabel9 = new JLabel();

    JTable jTable1 = new JTable();
    JTableHeader jTableHeader1 = jTable1.getTableHeader();

    Vector colnames = new Vector(); //表頭
    Vector colnames1 = new Vector();
    Vector colnames2 = new Vector();


    JScrollPane jScrollPane1 = new JScrollPane();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    JButton jButton5 = new JButton();
    JLabel jLabel5 = new JLabel();
    JScrollPane jScrollPane2 = new JScrollPane();
    JTextArea jTextArea1 = new JTextArea();


    public JoinAndExceed(Frame owner, String title, boolean modal) {
        super(owner, title, modal);
        try {
            setDefaultCloseOperation(DISPOSE_ON_CLOSE);
            jbInit();
            pack();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public JoinAndExceed() {
        this(new Frame(), "JoinAndExceed", false);
        this.setSize(600, 500);
    }

    private void jbInit() throws Exception {
        panel1.setLayout(null);
        this.getContentPane().setLayout(null);
        jLabel4.setBorder(BorderFactory.createEtchedBorder());
        jLabel4.setBounds(new Rectangle(29, 7, 536, 36));
        jLabel6.setText("商品編號：");
        jLabel6.setBounds(new Rectangle(45, 50, 68, 21));
        jTextField2.setBounds(new Rectangle(112, 50, 127, 21));
        jTextField2.addFocusListener(new JoinAndExceed_jTextField2_focusAdapter(this));
        jLabel7.setText("數量：");
        jLabel7.setBounds(new Rectangle(263, 50, 38, 21));
        jTextField3.setBounds(new Rectangle(297, 50, 68, 21));
        jLabel8.setText("進貨單價：");
        jLabel8.setBounds(new Rectangle(394, 50, 68, 21));
        jTextField4.setBounds(new Rectangle(457, 50, 68, 21));
        jLabel9.setBorder(BorderFactory.createEtchedBorder());
        jLabel9.setBounds(new Rectangle(29, 42, 536, 41));
        jScrollPane1.setBounds(new Rectangle(29, 82, 536, 270));
        jButton1.setBounds(new Rectangle(72, 436, 81, 30));
        jButton1.setSelectedIcon(null);
        jButton1.setText("確   認");
        jButton1.addActionListener(new JoinAndExceed_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(173, 436, 81, 30));
        jButton2.setText("刪除");
        jButton2.addActionListener(new JoinAndExceed_jButton2_actionAdapter(this));
        jButton3.setBounds(new Rectangle(274, 436, 81, 30));
        jButton3.setText("撤   消");
        jButton3.addActionListener(new JoinAndExceed_jButton3_actionAdapter(this));
        jButton4.setBounds(new Rectangle(375, 436, 81, 30));
        jButton4.setText("提   交");
        jButton4.addActionListener(new JoinAndExceed_jButton4_actionAdapter(this));
        panel1.setBackground(Color.pink);
        this.getContentPane().setBackground(Color.pink);
        this.setForeground(Color.pink);
        jButton5.setBounds(new Rectangle(476, 436, 81, 30));
        jButton5.setToolTipText("");
        jButton5.setText("查詢");
        jButton5.addActionListener(new JoinAndExceed_jButton5_actionAdapter(this));
        jLabel5.setFont(new java.awt.Font("宋體", Font.PLAIN, 30));
        jLabel5.setText("備注：");
        jLabel5.setBounds(new Rectangle(47, 366, 96, 45));
        jScrollPane2.setBounds(new Rectangle(120, 352, 444, 70));
        this.getContentPane().add(panel1, null);
        jComboBox2.setBounds(new Rectangle(433, 14, 94, 20));
        jLabel3.setText("制單人：");
        jLabel3.setBounds(new Rectangle(380, 14, 84, 20));
        jTextField1.setBounds(new Rectangle(225, 14, 131, 20));
        jLabel2.setText("時間：");
        jLabel2.setBounds(new Rectangle(187, 14, 84, 20));
        jComboBox1.setBounds(new Rectangle(79, 14, 84, 20));
        Timer timer = new Timer();
        timer.schedule(new RemindTask(), 0, 1000); //得到當前時間
        this.getContentPane().add(jComboBox2);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jComboBox1);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jButton5);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jButton3);
        this.getContentPane().add(jButton4);
        this.getContentPane().add(jTextField2);
        this.getContentPane().add(jLabel9);
        this.getContentPane().add(jLabel6);
        this.getContentPane().add(jLabel7);
        this.getContentPane().add(jTextField3);
        this.getContentPane().add(jLabel8);
        this.getContentPane().add(jTextField4);
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(jScrollPane2);
        this.getContentPane().add(jLabel5);
        jScrollPane2.getViewport().add(jTextArea1);
        jScrollPane1.getViewport().add(jTable1);
        jLabel1.setText("類別：");
        jLabel1.setBounds(new Rectangle(43, 14, 84, 20));
        panel1.setBounds(new Rectangle(0, 399, 1, 1));
        jComboBox1.addItem("  進  貨 ");
        jComboBox1.addItem("  退  貨 ");
        jComboBox2.addItem("郭健偉");
        jComboBox2.addItem("譚震欣");
        jComboBox2.addItem("徐敏");
        jTextField1.setText(ts.toString().substring(0, 19));
        colnames.add("商品編號");
        colnames.add("商品名稱");
        colnames.add("數量");
        colnames.add("進貨價");
        colnames.add("日期");
        colnames.add("金額");

        colnames1.add("");
        colnames1.add("");
        colnames1.add("");
        colnames1.add("");
        colnames1.add("");
        colnames2.add(colnames1);
        jTable1 = Mytable.maketable(colnames2, colnames); //顯示內容
    }

    Vector vector1 = new Vector();
    public void jButton1_actionPerformed(ActionEvent e) {
        Vector select1 = Select_Means.Select_sort2(jTextField2.getText());
        if (select1.size() == 0) {
            JOptionPane.showMessageDialog(this, "商品不存在", "錯誤",
                                          JOptionPane.ERROR_MESSAGE);
            return;
        }
        Vector select2 = (Vector) select1.get(0);
        Vector vector = new Vector();
        double allMoney = 0;
        vector.add(jTextField2.getText());
        vector.add(select2.get(3).toString());
        vector.add(jTextField3.getText());
        vector.add(jTextField4.getText());
        vector.add(jTextField1.getText());

        try {
            Double num = new Double(jTextField3.getText());
            Double money = new Double(jTextField4.getText());
            allMoney = (int) (num * money * 100) / 100.0;
        } catch (Exception ex) {
            JOptionPane.showMessageDialog(this, "輸入的數字有誤", "錯誤",
                                          JOptionPane.ERROR_MESSAGE);
            return;
        }
        Double dd = new Double(allMoney);