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

public class kindsAdd //添加類別
    extends JDialog {
  Select st;//用于接受Select 對象,用于對商品類別更新
  public kindsAdd(Select st) {
    try {
      this.st=st;
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    border5.setTitleFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    this.getContentPane().setLayout(null);
    this.setTitle("添加商品類別");
    lbltianjlb.setFont(new java.awt.Font("Dialog", Font.PLAIN, 22));
    lbltianjlb.setText("添加商品類別");
    lbltianjlb.setBounds(new Rectangle(130, 10, 196, 44));
    lblleijieming.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblleijieming.setText("商品類別");
    lblleijieming.setBounds(new Rectangle(52, 62, 91, 33));
    txtleibieming.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtleibieming.setText("");
    txtleibieming.setBounds(new Rectangle(163, 62, 116, 29));
    txtleibieming.addKeyListener(new kindsAdd_txtleibieming_keyAdapter(this));
    taxbeizhu.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    taxbeizhu.setText("");
    taxbeizhu.setBounds(new Rectangle(19, 128, 363, 104));
    taxbeizhu.addKeyListener(new kindsAdd_taxbeizhu_keyAdapter(this));
    btntijiao.setBackground(new Color(212, 255, 200));
    btntijiao.setBounds(new Rectangle(70, 243, 91, 33));
    btntijiao.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btntijiao.setToolTipText("");
    btntijiao.setText("提交");
    btntijiao.addActionListener(new kindsAdd_btntijiao_actionAdapter(this));
    btnhuanhui.setBackground(new Color(212, 255, 200));
    btnhuanhui.setBounds(new Rectangle(230, 243, 91, 33));
    btnhuanhui.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btnhuanhui.setText("返回");
    this.getContentPane().setBackground(new Color(212, 208, 200));
    this.setModal(true);
    btnhuanhui.addActionListener(new kindsAdd_btnhuanhui_actionAdapter(this));
    jPanel1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setBounds(new Rectangle(11, 8, 377, 46));
    jPanel1.setLayout(null);
    jPanel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jPanel2.setBorder(border5);
    jPanel2.setBounds(new Rectangle(11, 99, 377, 191));
    jPanel2.setLayout(null);
    jPanel3.setBorder(BorderFactory.createEtchedBorder());
    jPanel3.setBounds(new Rectangle(11, 57, 377, 40));
    jPanel3.setLayout(null);
    this.getContentPane().add(lbltianjlb);
    this.getContentPane().add(txtleibieming);
    this.getContentPane().add(lblleijieming);
    this.getContentPane().add(btnhuanhui);
    this.getContentPane().add(taxbeizhu);
    this.getContentPane().add(btntijiao);
    this.getContentPane().add(jPanel1);
    this.getContentPane().add(jPanel2);
    this.getContentPane().add(jPanel3);

  }

  JLabel lbltianjlb = new JLabel();
  JLabel lblleijieming = new JLabel();
  JTextField txtleibieming = new JTextField();
  JTextArea taxbeizhu = new JTextArea();
  JButton btntijiao = new JButton();
  JButton btnhuanhui = new JButton();
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
 /* Border border1 = BorderFactory.createEtchedBorder(Color.white,
      new Color(148, 145, 140));
  Border border2 = new TitledBorder(border1, "備注");*/
  JPanel jPanel3 = new JPanel();
 /* Border border3 = BorderFactory.createEtchedBorder(Color.white,
      new Color(148, 145, 140));*/
  Border border4 = BorderFactory.createEtchedBorder(Color.white,
      new Color(148, 145, 140));

  TitledBorder border5 = new TitledBorder(border4,"備注");
  //  Border border4 = new TitledBorder(border3, "備注");
  public void btnhuanhui_actionPerformed(ActionEvent e) {
    this.dispose();
  }

  public void btntijiao_actionPerformed(ActionEvent e) { //提交添加商品類別
    String name = txtleibieming.getText().trim();
    if (name.equals("")) {
      JOptionPane.showMessageDialog(null, "信息輸入不完整，請重新輸入！", "錯誤",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }
    int count = 0;
    Link lk = new Link();
    lk.connection();
    String sql = "select kindsname from kinds";
    ResultSet rs = lk.Select(sql);
    try {
      while (rs.next()) {
        if (rs.getString(1).trim().equals(name)) {//判斷類別名是否重復
          JOptionPane.showMessageDialog(null, "該類別名已經存在，請重新輸入!", "錯誤",
                                        JOptionPane.ERROR_MESSAGE);
          rs.close();
          lk.close();
          return;
        }
      }
    }
    catch (SQLException ex) {
    }
    sql = "insert into kinds values('" + name +"','" +
        taxbeizhu.getText() + "')";
    count = lk.Update(sql);
    if (count > 0) {
      JOptionPane.showMessageDialog(null, "成功添加類別", "成功",
                                    JOptionPane.INFORMATION_MESSAGE);

      taxbeizhu.setText("");
      txtleibieming.setText("");
      st.disleibei();
      MainFrm mf=new MainFrm(1);
    }
    else {
      JOptionPane.showMessageDialog(null, "操作失敗!請認真核實！", "錯誤",
                                    JOptionPane.ERROR_MESSAGE);
    }
    lk.close();
  }

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

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

}

class kindsAdd_taxbeizhu_keyAdapter
    extends KeyAdapter {
  private kindsAdd adaptee;
  kindsAdd_taxbeizhu_keyAdapter(kindsAdd adaptee) {
    this.adaptee = adaptee;
  }

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

class kindsAdd_btntijiao_actionAdapter
    implements ActionListener {
  private kindsAdd adaptee;
  kindsAdd_btntijiao_actionAdapter(kindsAdd adaptee) {
    this.adaptee = adaptee;
  }

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

class kindsAdd_txtleibieming_keyAdapter
    extends KeyAdapter {
  private kindsAdd adaptee;
  kindsAdd_txtleibieming_keyAdapter(kindsAdd adaptee) {
    this.adaptee = adaptee;
  }

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

class kindsAdd_btnhuanhui_actionAdapter
    implements ActionListener {
  private kindsAdd adaptee;
  kindsAdd_btnhuanhui_actionAdapter(kindsAdd adaptee) {
    this.adaptee = adaptee;
  }

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