package supermarket;
import DB.*;
import javax.swing.*;
import java.awt.Color;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.awt.event.KeyEvent;
import java.awt.event.KeyAdapter;
import javax.swing.border.Border;
import javax.swing.border.TitledBorder;

public class goodsAdd
    extends JDialog {
 // Select st;//存Select 對象,用于更新表
  JLabel lblname = new JLabel();
  JTextField txtname = new JTextField();
  JComboBox cmbleibie = new JComboBox();
  JLabel lblkucun = new JLabel();
  JTextField txtkucun = new JTextField();
  JButton btntijiao = new JButton();
  JButton btnhuanhui = new JButton();
  JLabel lblzhekou = new JLabel();
  JTextField txtzhekou = new JTextField();
  JLabel jLabel1 = new JLabel();
  JTextArea txtbeizhu = new JTextArea();
  JLabel lblprice = new JLabel();
  JTextField txtprice = new JTextField();
  JLabel lbldanwei = new JLabel();
  JTextField txtdanwei = new JTextField();
  JLabel jLabel2 = new JLabel();
  JTextField txtid = new JTextField();
  JPanel jPanel1 = new JPanel();
  Border border1 = BorderFactory.createEtchedBorder(Color.white,
      new Color(148, 145, 140));
  Border border2 = new TitledBorder(border1, "添加商品");
  JPanel jPanel2 = new JPanel();
  MainFrm frm= null;
  public goodsAdd(MainFrm frm) {
    try {
      this.frm = frm;
      jbInit();
      disleibei();
//      cmbleibie.addItem("商品類別");
//      cmbleibie.addItem("日用品類");
//      cmbleibie.addItem("飲料類");
//      cmbleibie.addItem("化裝品類");
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  public void disleibei() { //顯示
    Link obj = new Link();
    obj.connection();
    String sql = "select kindsname from kinds";
    ResultSet rs = obj.Select(sql);
//    vt.removeAllElements();//清理表里原有的數據
//    Vector v=new Vector();
    cmbleibie.addItem("商品類別");
    cmbleibie.removeAllItems();
    cmbleibie.addItem("商品類別");
    try {
      while (rs.next()) {
        cmbleibie.addItem(rs.getString(1));
      }
      rs.close();
      obj.close();
    }
    catch (SQLException ex) {
//      JOptionPane.showMessageDialog(null,"Game Over");
    }
//  vt.add(v);//添加數據
//  tbljieguo.updateUI();//更新表
  }

  private void jbInit() throws Exception {
    this.getContentPane().setLayout(null);
    this.getContentPane().setBackground(new Color(212, 208, 200));
    this.setForeground(Color.darkGray);
    lblname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblname.setText("商品名");
    lblname.setBounds(new Rectangle(14, 62, 74, 29));
    txtname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtname.setText("");
    txtname.setBounds(new Rectangle(96, 61, 91, 28));
    txtname.addKeyListener(new goodsAdd_txtname_keyAdapter(this));
    cmbleibie.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    cmbleibie.setBounds(new Rectangle(251, 61, 108, 28));
    cmbleibie.addActionListener(new goodsAdd_cmbleibie_actionAdapter(this));
    lblkucun.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtkucun.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtkucun.setText("");
    txtkucun.setBounds(new Rectangle(97, 144, 90, 28));
    txtkucun.addKeyListener(new goodsAdd_txtkucun_keyAdapter(this));
    btntijiao.setBackground(new Color(212, 255, 207));
    btntijiao.setBounds(new Rectangle(75, 292, 91, 33));
    btntijiao.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btntijiao.setText("添加");
    btntijiao.addActionListener(new goodsAdd_btntijiao_actionAdapter(this));
    btnhuanhui.setBackground(new Color(212, 255, 200));
    btnhuanhui.setBounds(new Rectangle(212, 292, 91, 33));
    btnhuanhui.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btnhuanhui.setText("返回");
    btnhuanhui.addActionListener(new goodsAdd_jButton1_actionAdapter(this));
    lblzhekou.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblzhekou.setText("折扣率/折");
    lblzhekou.setBounds(new Rectangle(208, 104, 80, 29));
    txtzhekou.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtzhekou.setText("10");
    this.setModal(true);
    txtzhekou.setBounds(new Rectangle(298, 102, 59, 25));
    txtzhekou.addKeyListener(new goodsAdd_txtzhekou_keyAdapter(this));
    lblkucun.setText("庫存量");
    lblkucun.setBounds(new Rectangle(15, 145, 68, 29));
    jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jLabel1.setText("備注");
    jLabel1.setBounds(new Rectangle(17, 181, 68, 30));
    txtbeizhu.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtbeizhu.setText("");
    txtbeizhu.setBounds(new Rectangle(15, 217, 351, 65));
    txtbeizhu.addKeyListener(new goodsAdd_txtbeizhu_keyAdapter(this));
    lblprice.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblprice.setText("價格/元");
    lblprice.setBounds(new Rectangle(16, 104, 61, 27));
    txtprice.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtprice.setText("");
    txtprice.setBounds(new Rectangle(96, 102, 91, 29));
    txtprice.addKeyListener(new goodsAdd_txtprice_keyAdapter(this));
    lbldanwei.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lbldanwei.setText("單位");
    lbldanwei.setBounds(new Rectangle(208, 149, 46, 20));
    txtdanwei.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtdanwei.setText("");
    txtdanwei.setBounds(new Rectangle(298, 147, 59, 25));
    txtdanwei.addKeyListener(new goodsAdd_txtdanwei_keyAdapter(this));
    this.setModal(true);
    this.setTitle("商品添加");
    jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jLabel2.setText("商品編號");
    jLabel2.setBounds(new Rectangle(12, 25, 93, 23));
    txtid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtid.setText("");
    txtid.setBounds(new Rectangle(99, 21, 88, 25));
    jPanel1.setBorder(border2);
    jPanel1.setBounds(new Rectangle( -2, 0, 393, 291));
    jPanel1.setLayout(null);
    jPanel2.setBorder(BorderFactory.createEtchedBorder());
    jPanel2.setBounds(new Rectangle( -2, 284, 393, 50));
    jPanel2.setLayout(null);
    this.getContentPane().add(btnhuanhui);
    this.getContentPane().add(btntijiao);
    this.getContentPane().add(jLabel1); //從右邊輸入
    this.getContentPane().add(lbldanwei);
    this.getContentPane().add(lblkucun);
    this.getContentPane().add(txtdanwei);
    this.getContentPane().add(lblzhekou);
    this.getContentPane().add(lblname);
    this.getContentPane().add(lblprice);
    this.getContentPane().add(jLabel2);
    this.getContentPane().add(txtzhekou);
    this.getContentPane().add(cmbleibie);
    this.getContentPane().add(txtbeizhu);
    this.getContentPane().add(txtname);
    this.getContentPane().add(txtid);
    this.getContentPane().add(txtprice);
    this.getContentPane().add(txtkucun);
    this.getContentPane().add(jPanel1);
    this.getContentPane().add(jPanel2);
    //文本對齊方式
    txtzhekou.setHorizontalAlignment(JTextField.RIGHT);
    txtprice.setHorizontalAlignment(JTextField.RIGHT);
    txtkucun.setHorizontalAlignment(JTextField.RIGHT);
    txtdanwei.setHorizontalAlignment(JTextField.RIGHT);
  }

  public void jButton1_actionPerformed(ActionEvent e) {
    this.dispose(); //返回
  }

  public void btntijiao_actionPerformed(ActionEvent e) { //商品添加界面

    if (txtid.getText().trim().equals("") ||
        txtname.getText().trim().equals("") ||
        txtkucun.getText().trim().equals("") ||
        txtprice.getText().trim().equals("") ||
        txtdanwei.getText().trim().equals("")) {
      JOptionPane.showMessageDialog(null, "信息輸入不完整，請認真核實!", "錯誤",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }

    if (cmbleibie.getSelectedItem().equals("商品類別")) {
      JOptionPane.showMessageDialog(null, "請選擇商品類別!", "錯誤",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }
    String id = txtid.getText().trim(); //存商品編號
    int kucun = Integer.parseInt(txtkucun.getText().trim()); //存庫存量
    Link lk = new Link();
    lk.connection();
    String sql = "select * from shopping where id='" + id + "'";
    ResultSet rs = lk.Select(sql);
    try {
      if (rs.next()) { //判斷商品編號是否重復
        /* JOptionPane.showMessageDialog(null, "該商品編號已經存在，請重新輸入！", "錯誤",
                                       JOptionPane.ERROR_MESSAGE);*/
        kucun += Integer.parseInt(rs.getString(5));
        //判斷該商品是否已經存在
        if (rs.getString(1).trim().equals(cmbleibie.getSelectedItem().toString()) &&
            rs.getString(2).trim().equals(txtname.getText().trim())) {
          sql = "update shopping set total='" + kucun + "' where id='" + id +
              "'";
        }
        else {
          JOptionPane.showMessageDialog(null, "該商品編號已經存在,請重新輸入!", "錯誤",
                                        JOptionPane.ERROR_MESSAGE);//錯誤提示
          rs.close();
          lk.close();
          return;
        }
        int it = lk.Update(sql);
        if (it > 0) {
          JOptionPane.showMessageDialog(null, "庫存更新成功");

          txtid.setText("");
          txtname.setText("");
          txtkucun.setText("");
          txtprice.setText("");
          txtdanwei.setText("");
          txtbeizhu.setText("");

        }
        rs.close();
        lk.close();
        return;

      }
    }
    catch (SQLException ex) {
    }
    sql = "insert into shopping values(" + txtid.getText() + ",'" +
        cmbleibie.getSelectedItem() +
        "','" + txtname.getText() + "'," + txtprice.getText() + "," +
        txtkucun.getText() + ",'" + txtdanwei.getText() + "'," +
        txtzhekou.getText() + ",'" + txtbeizhu.getText() + "')";
    int re = lk.Update(sql);
    if (re > 0) {
      //添加成功,將所有文本框清空
      JOptionPane.showMessageDialog(null, "添加成功");
      //更新樹,傳商品類別和名稱
          frm.updateTree(cmbleibie.getSelectedItem(),txtname.getText());
      txtid.setText("");
      txtname.setText("");
      txtprice.setText("");
      txtkucun.setText("");
      txtdanwei.setText("");
      txtbeizhu.setText("");
    }
    lk.close();
  }

  public void txtname_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      btntijiao_actionPerformed(null);
    }
  }

  public void txtprice_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      btntijiao_actionPerformed(null);
    }
  }

  public void txtkucun_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      btntijiao_actionPerformed(null);
    }
  }

  public void txtdanwei_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      btntijiao_actionPerformed(null);
    }
  }

  public void txtzhekou_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      btntijiao_actionPerformed(null);
    }
  }

  public void txtbeizhu_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      btntijiao_actionPerformed(null);
    }
  }

}

class goodsAdd_txtbeizhu_keyAdapter
    extends KeyAdapter {
  private goodsAdd adaptee;
  goodsAdd_txtbeizhu_keyAdapter(goodsAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtbeizhu_keyPressed(e);
  }
}

class goodsAdd_txtzhekou_keyAdapter
    extends KeyAdapter {
  private goodsAdd adaptee;
  goodsAdd_txtzhekou_keyAdapter(goodsAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtzhekou_keyPressed(e);
  }
}

class goodsAdd_txtdanwei_keyAdapter
    extends KeyAdapter {
  private goodsAdd adaptee;
  goodsAdd_txtdanwei_keyAdapter(goodsAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {

    adaptee.txtdanwei_keyPressed(e);
  }
}

class goodsAdd_txtkucun_keyAdapter
    extends KeyAdapter {
  private goodsAdd adaptee;
  goodsAdd_txtkucun_keyAdapter(goodsAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtkucun_keyPressed(e);
  }
}

class goodsAdd_txtprice_keyAdapter
    extends KeyAdapter {
  private goodsAdd adaptee;
  goodsAdd_txtprice_keyAdapter(goodsAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtprice_keyPressed(e);
  }
}

class goodsAdd_cmbleibie_actionAdapter
    implements ActionListener {
  private goodsAdd adaptee;
  goodsAdd_cmbleibie_actionAdapter(goodsAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {

  }
}

class goodsAdd_jButton1_actionAdapter
    implements ActionListener {
  private goodsAdd adaptee;
  goodsAdd_jButton1_actionAdapter(goodsAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class goodsAdd_btntijiao_actionAdapter
    implements ActionListener {
  private goodsAdd adaptee;
  goodsAdd_btntijiao_actionAdapter(goodsAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btntijiao_actionPerformed(e);
  }
}

class goodsAdd_txtname_keyAdapter
    extends KeyAdapter {
  private goodsAdd adaptee;
  goodsAdd_txtname_keyAdapter(goodsAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtname_keyPressed(e);
  }
}