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 對(duì)象,用于更新表
  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;
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JLabel jLabel8 = new JLabel();
  JLabel jLabel9 = new JLabel();
  JLabel jLabel10 = new JLabel();
  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();//清理表里原有的數(shù)據(jù)
//    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);//添加數(shù)據(jù)
//  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.setEditable(false);
    txtkucun.setText("0");
    txtkucun.setBounds(new Rectangle(97, 144, 90, 28));
    txtkucun.addKeyListener(new goodsAdd_txtkucun_keyAdapter(this));
    btntijiao.setBackground(Color.lightGray);
    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(Color.lightGray);
    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("價(jià)格/元");
    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(233, 148, 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("商品編號(hào)");
    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);
    jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jLabel3.setForeground(Color.red);
    jLabel3.setText("帶星號(hào)的必填");
    jLabel3.setBounds(new Rectangle(244, 19, 135, 33));
    jLabel4.setForeground(Color.red);
    jLabel4.setText("*");
    jLabel4.setBounds(new Rectangle(192, 23, 27, 23));
    jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jLabel5.setForeground(Color.red);
    jLabel5.setText("*");
    jLabel5.setBounds(new Rectangle(195, 65, 28, 23));
    jLabel6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jLabel6.setText("折扣率");
    jLabel6.setBounds(new Rectangle(229, 106, 62, 23));
    jLabel7.setForeground(Color.red);
    jLabel7.setText("*");
    jLabel7.setBounds(new Rectangle(191, 109, 34, 23));
    jLabel8.setForeground(Color.red);
    jLabel8.setText("*");
    jLabel8.setBounds(new Rectangle(191, 146, 26, 23));
    jLabel9.setForeground(Color.red);
    jLabel9.setText("*");
    jLabel9.setBounds(new Rectangle(364, 61, 40, 23));
    jLabel10.setForeground(Color.red);
    jLabel10.setText("*");
    jLabel10.setBounds(new Rectangle(361, 149, 60, 23));
    this.getContentPane().add(btnhuanhui);
    this.getContentPane().add(btntijiao);
    this.getContentPane().add(jLabel1); //從右邊輸入
    this.getContentPane().add(lblkucun);
    this.getContentPane().add(txtdanwei);
    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);
    jPanel1.add(jLabel3);
    jPanel1.add(jLabel4);
    jPanel1.add(jLabel5);
    jPanel1.add(lbldanwei);
    jPanel1.add(jLabel6);
    jPanel1.add(jLabel7);
    jPanel1.add(jLabel8);
    jPanel1.add(jLabel9);
    jPanel1.add(jLabel10);
    this.getContentPane().add(jPanel2); //文本對(duì)齊方式
    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("") ||
       txtprice.getText().trim().equals("") ||
        txtdanwei.getText().trim().equals("")) {
      JOptionPane.showMessageDialog(null, "信息輸入不完整，請(qǐng)認(rèn)真核實(shí)!", "錯(cuò)誤",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }
    if (cmbleibie.getSelectedItem().equals("商品類別")) {
      JOptionPane.showMessageDialog(null, "請(qǐng)選擇商品類別!", "錯(cuò)誤",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }
    String id = txtid.getText().trim(); //存商品編號(hào)
    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()) { //判斷商品編號(hào)是否重復(fù)
         JOptionPane.showMessageDialog(null, "該商品編號(hào)已經(jīng)存在，請(qǐng)重新輸入！", "錯(cuò)誤",
                                       JOptionPane.ERROR_MESSAGE);
        //判斷該商品是否已經(jīng)存在
        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(),1);
      txtid.setText("");
      txtname.setText("");
      txtprice.setText("");
      txtkucun.setText("0");
      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);
  }
}