package supermarket;

import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import DB.Link;
import java.sql.ResultSet;
import java.sql.*;
import java.beans.PropertyChangeEvent;
import java.beans.PropertyChangeListener;
import java.beans.PropertyVetoException;
import java.beans.VetoableChangeListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Deluser
    extends JDialog {
  public Deluser() {
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    this.getContentPane().setLayout(null);
    this.setTitle("刪除用戶");
    btncle.setBounds(new Rectangle(176, 57, 71, 33));
    btncle.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btncle.setText("取消");
    btncle.addActionListener(new Deluser_btncle_actionAdapter(this));
    jPanel1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setBounds(new Rectangle(32, 32, 290, 177));
    jPanel1.setLayout(null);
    jPanel2.setBorder(BorderFactory.createEtchedBorder());
    jPanel2.setBounds(new Rectangle(1, 37, 288, 39));
    jPanel2.setLayout(null);
    jPanel3.setBorder(BorderFactory.createEtchedBorder());
    jPanel3.setBounds(new Rectangle(0, 75, 290, 101));
    jPanel3.setLayout(null);
    jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
    jLabel1.setText("刪除用戶");
    jLabel1.setBounds(new Rectangle(100, 11, 91, 20));
    btndel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btndel.addActionListener(new Deluser_btndel_actionAdapter(this));
    cmbuser.addItemListener(new Deluser_cmbuser_itemAdapter(this));
    this.getContentPane().add(jPanel1);
    lblname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblname.setText("");
    lblname.setBounds(new Rectangle(22, 20, 243, 23));
    cmbuser.setBounds(new Rectangle(82, 7, 125, 24));
    jPanel1.add(jPanel2);
    jPanel2.add(cmbuser);
    jPanel1.add(jPanel3);
    jPanel3.add(lblname);
    jPanel3.add(btncle);
    jPanel3.add(btndel);
    jPanel1.add(jLabel1);
    this.setModal(true);
    btndel.setBounds(new Rectangle(37, 57, 71, 33));
    btndel.setText("刪除");
    sel(); //調(diào)用該方法將用戶名添加到下拉筐中
  }

  JButton btndel = new JButton();
  JButton btncle = new JButton();
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  JPanel jPanel3 = new JPanel();
  JLabel lblname = new JLabel();
  JComboBox cmbuser = new JComboBox();
  JLabel jLabel1 = new JLabel();

  public void sel() { //從數(shù)據(jù)庫中讀取非管理員的用戶添加到下拉筐中
    String sql = "select * from usertitle where purview=2 or purview=1";
    Link lk = new Link();
    lk.connection();
    ResultSet rs = lk.Select(sql);
    try {
      if (rs.next()) {
        do {
          cmbuser.addItem(rs.getString(1));
        }
        while (rs.next());
      }
      else {
        JOptionPane.showMessageDialog(null, "數(shù)據(jù)庫中沒有非管理員用戶");
      }
    }
    catch (SQLException ex) {
    }

    lk.close();
  }

  public void btndel_actionPerformed(ActionEvent e) { //刪除用戶
    if (JOptionPane.showConfirmDialog(null, "確認(rèn)刪除?", "確認(rèn)",
                                      JOptionPane.YES_NO_OPTION) == 0) {
      String sql = "delete from usertitle where username='" +
          cmbuser.getSelectedItem().toString() + "'";
      Link lk = new Link();
      lk.connection();
      int it = lk.Update(sql);
      if (it > 0) {
        JOptionPane.showMessageDialog(null, "刪除成功");
      }
      lk.close();
      cmbuser.removeAllItems();
      sel();
      lblname.setText("");
    }
    else {
      return;
    }
  }



  public void btncle_actionPerformed(ActionEvent e) {
    this.dispose();
  }

  public void cmbuser_itemStateChanged(ItemEvent e) {
    if(e.getStateChange() == 2){//選定下拉項(xiàng)
      if (cmbuser.getSelectedItem()!=null) {
        //JOptionPane.showMessageDialog(null,e.getStateChange()+"aaaaa");
        String sql = "select purview from usertitle where username='" +
            cmbuser.getSelectedItem().toString() + "' ";
        Link lk = new Link();
        lk.connection();
        ResultSet rs = lk.Select(sql);
        try {
          if (rs.next()) {
            int pur = 0;
            pur = Integer.parseInt(rs.getString(1).trim());
            if (pur == 2) {
              lblname.setText("該用戶是倉庫管理員");
            }
            if (pur == 1) {
              lblname.setText("該用戶是收銀員");
            }
          }
        }
        catch (SQLException ex) {
        }
        lk.close();

      }
    }
  }

}


class Deluser_cmbuser_itemAdapter
    implements ItemListener {
  private Deluser adaptee;
  Deluser_cmbuser_itemAdapter(Deluser adaptee) {
    this.adaptee = adaptee;
  }

  public void itemStateChanged(ItemEvent e) {
    adaptee.cmbuser_itemStateChanged(e);
  }
}

class Deluser_btncle_actionAdapter
    implements ActionListener {
  private Deluser adaptee;
  Deluser_btncle_actionAdapter(Deluser adaptee) {
    this.adaptee = adaptee;
  }

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

class Deluser_btndel_actionAdapter
    implements ActionListener {
  private Deluser adaptee;
  Deluser_btndel_actionAdapter(Deluser adaptee) {
    this.adaptee = adaptee;
  }

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