package supermarket;
import DB.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Vector;
import java.sql.ResultSet;
import java.sql.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class VipFrm
    extends JDialog {
  JPanel contentPane;
  JLabel lbltitie = new JLabel();
  JTextField txtid = new JTextField();
  JLabel lblid = new JLabel();
  JLabel lblname = new JLabel();
  JTextField txtname = new JTextField();
  JButton jButton5 = new JButton();
  JScrollPane jScrollPane1 = new JScrollPane();
  JButton jButton2 = new JButton();
  JButton btnupdate = new JButton();
  JButton btnshangchu = new JButton();
  JButton jButton6 = new JButton();
  // JTable tablehuiyuan = new JTable();
  Vector vt = new Vector();
  String head[] = {
      "會員卡號", "會員名", "會員積分", "會員等級"};
  TableModle dm = new TableModle(head, vt);
  JTable tablehuiyuan = new JTable(dm);
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  public VipFrm() {
    try {
      // setDefaultCloseOperation(EXIT_ON_CLOSE);
      jbInit();
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }
  }

  /**
   * Component initialization.
   *
   * @throws java.lang.Exception
   */
  private void jbInit() throws Exception {
    contentPane = (JPanel) getContentPane();
    contentPane.setLayout(null);
    this.getContentPane().setBackground(new Color(212, 208, 200));
    setSize(new Dimension(650, 500));
    setTitle("會員管理");
    lbltitie.setFont(new java.awt.Font("華文中宋", Font.PLAIN, 20));
    lbltitie.setText("會員管理");
    txtid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtid.setText("");
    txtid.setBounds(new Rectangle(111, 22, 125, 25));
    lblid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblid.setText("會員卡號");
    lblid.setBounds(new Rectangle(14, 24, 85, 20));
    lblname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblname.setText("會員姓名");
    lblname.setBounds(new Rectangle(266, 24, 85, 20));
    txtname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtname.setText("");
    txtname.setBounds(new Rectangle(375, 22, 125, 25));
    jButton5.setBounds(new Rectangle(525, 20, 91, 29));
    jButton5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jButton5.setText("查詢");
    jButton5.addActionListener(new VipFrm_jButton5_actionAdapter(this));
    jScrollPane1.getViewport().setBackground(new Color(212, 208, 200));
    jScrollPane1.setBorder(BorderFactory.createEtchedBorder());
    jScrollPane1.setBounds(new Rectangle(5, 55, 634, 346));
    jButton2.setBounds(new Rectangle(9, 428, 128, 29));
    jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jButton2.setText("添加會員");
    jButton2.addActionListener(new VipFrm_jButton2_actionAdapter(this));
    btnupdate.setBounds(new Rectangle(176, 428, 128, 29));
    btnupdate.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btnupdate.setText("修改會員");
    btnupdate.addActionListener(new VipFrm_jButton3_actionAdapter(this));
    btnshangchu.setBounds(new Rectangle(342, 428, 128, 29));
    btnshangchu.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btnshangchu.setText("刪除會員");
    btnshangchu.addActionListener(new VipFrm_jButton4_actionAdapter(this));
    jButton6.setBounds(new Rectangle(509, 428, 128, 29));
    jButton6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jButton6.setText("返回");
    jButton6.addActionListener(new VipFrm_jButton6_actionAdapter(this));
    tablehuiyuan.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jPanel1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setBounds(new Rectangle(5, 16, 632, 39));
    jPanel2.setBorder(BorderFactory.createEtchedBorder());
    jPanel2.setBounds(new Rectangle(5, 400, 632, 74));
    contentPane.add(lbltitie);
    contentPane.add(jScrollPane1);
    jScrollPane1.getViewport().add(tablehuiyuan);
    contentPane.add(btnupdate);
    contentPane.add(btnshangchu);
    contentPane.add(jButton2);
    contentPane.add(jButton6);
    contentPane.add(txtname);
    contentPane.add(jButton5);
    contentPane.add(lblname);
    contentPane.add(txtid);
    contentPane.add(lblid);
    contentPane.add(jPanel1);
    contentPane.add(jPanel2);
    this.setModal(true);
  }

  public void jButton6_actionPerformed(ActionEvent e) {
    this.dispose();
  }
public void gengxin(){//用于查詢會員表

  String name = txtname.getText().trim();
  String id = txtid.getText().trim();
  Link lk = new Link();
  lk.connection();
  String sql = "";
  if (name.equals("") && id.equals("")) {
    sql = "select * from vip";
  }
  else if (!name.equals("") && !id.equals("")) {
    sql = "select * from vip where VIPname like '%" + name +
        "%' and cardid='" + id + "'";
  }
  else if (!name.equals("") && id.equals("")) {
    sql = "select * from vip where VIPname like '%" + name + "%'";
  }
  else {
    sql = "select * from vip where cardid='" + id + "'";
  }
  ResultSet rs = lk.Select(sql);
  vt.removeAllElements(); //刪除表中所有的數據
  try {
    if (rs.next()) {
      do {
        Vector v = new Vector();
        v.add(rs.getString(1).trim()); //卡號
        v.add(rs.getString(2).trim()); //會員名
        v.add(rs.getString(3)); //積分
        int i = rs.getInt(4);
        switch (i) { //等級
          case 1:
            v.add("普通會員");
            break;
          case 2:
            v.add("高級會員");
            break;
          default:
            JOptionPane.showMessageDialog(null, "等級錯誤", "錯誤",
                                          JOptionPane.ERROR_MESSAGE);
            break;
        }
        vt.add(v); //添加數據
      }
      while (rs.next());
      tablehuiyuan.updateUI();
      rs.close();
    }
    else {
      JOptionPane.showMessageDialog(null, "不存在記錄!", "提示",
                                    JOptionPane.INFORMATION_MESSAGE);
    }
  }
  catch (SQLException ex) {
  }
  lk.close();

}
  public void jButton5_actionPerformed(ActionEvent e) {
    gengxin();
  }

  public void jButton2_actionPerformed(ActionEvent e) {
    VipAdd va = new VipAdd();
    va.setSize(400, 298);
    va.setLocation(300, 250);
    va.show();
    gengxin();
   tablehuiyuan.updateUI();
  }

  public void jButton3_actionPerformed(ActionEvent e) {
    int i = tablehuiyuan.getSelectedRow();
    if (i >= 0) {
      VipUpdate obj = new VipUpdate(vt, i);
//      obj.VipUpdate();
      obj.setSize(400, 350); //彈出窗口大小
      obj.setLocation(300, 200); //彈出窗口位置
      obj.show();
      gengxin();
      tablehuiyuan.updateUI();
    }
    else {
      JOptionPane.showMessageDialog(null, "請先選擇一個會員", "提示",
                                    JOptionPane.INFORMATION_MESSAGE);
      return;
    }
  }

  public void jButton4_actionPerformed(ActionEvent e) {
    int i = tablehuiyuan.getSelectedRow();
    if (i < 0) { //判斷是否選中至少一個會員
      JOptionPane.showMessageDialog(null, "請先選擇一個會員!", "錯誤",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }
    if (JOptionPane.showConfirmDialog(null, "確認刪除?", "確認",
                                      JOptionPane.YES_NO_OPTION) == 0) {
      Vector v = (Vector) vt.get(i); //將表中的一列存到一個動態數組中
      String sql = "delete from vip where cardid='" + v.get(0).toString() +
          "'";
      Link lk = new Link();
      lk.connection();
      int count = lk.Update(sql);
      if (count > 0) { //操作成功
        JOptionPane.showMessageDialog(null, "刪除成功!", "成功",
                                      JOptionPane.INFORMATION_MESSAGE);
        vt.remove(i); //刪除表中數據
      }
      else {
        lk.close();
        return;

      }
      tablehuiyuan.updateUI(); //更新表中的數據
      lk.close();
    }
  }
}

class VipFrm_jButton3_actionAdapter
    implements ActionListener {
  private VipFrm adaptee;
  VipFrm_jButton3_actionAdapter(VipFrm adaptee) {
    this.adaptee = adaptee;
  }

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

class VipFrm_jButton4_actionAdapter
    implements ActionListener {
  private VipFrm adaptee;
  VipFrm_jButton4_actionAdapter(VipFrm adaptee) {
    this.adaptee = adaptee;
  }

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

class VipFrm_jButton2_actionAdapter
    implements ActionListener {
  private VipFrm adaptee;
  VipFrm_jButton2_actionAdapter(VipFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {

    adaptee.jButton2_actionPerformed(e);
  }
}

class VipFrm_jButton5_actionAdapter
    implements ActionListener {
  private VipFrm adaptee;
  VipFrm_jButton5_actionAdapter(VipFrm adaptee) {
    this.adaptee = adaptee;
  }

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

class VipFrm_jButton6_actionAdapter
    implements ActionListener {
  private VipFrm adaptee;
  VipFrm_jButton6_actionAdapter(VipFrm adaptee) {
    this.adaptee = adaptee;
  }

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