//光盤管理面板
package client;

import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.*;
import com.borland.dbswing.DBDisposeMonitor;
import server.action.BusinessAction;
import server.entity.Card;
import server.entity.Cd;
import server.dao.Cddao;
import java.util.Vector;


public class Cdmanage  extends JPanel{
    //創建面板
    JTabbedPane cdtab = new JTabbedPane();
    JPanel pnlout=new JPanel();
    JPanel pnlin=new JPanel();
    JTextField txfcdoutcardid = new JTextField("");
    JPasswordField txfcdoutcardpwd = new JPasswordField("");
    JLabel jLabel1 = new JLabel("客戶密碼：");
    JLabel jLabel2 = new JLabel("客戶卡號：");
    Database database1 = new Database();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    DBDisposeMonitor dBDisposeMonitor1 = new DBDisposeMonitor(); //構造函數

    JButton btncdoutok = new JButton();
    JButton btncdoutclear = new JButton();
    JLabel lblcdoutpic = new JLabel(new ImageIcon(".\\pic\\cdmanager\\cdout.jpg"));
    JLabel lblcdinpic = new JLabel(new ImageIcon(".\\pic\\cdmanager\\cdin.jpg"));
    JTextField txfcdincdid = new JTextField("");
    JLabel jLabel3 = new JLabel("客戶卡號：");
    JButton btncdinclear = new JButton();
    JButton btncdinok = new JButton();
    JLabel lnlcdoutinf1 = new JLabel();
    JLabel jLabel5 = new JLabel("客戶密碼：");
    JTextField txfcdoutcdid = new JTextField("");
    JTextField txfcdincardid = new JTextField("");
    JLabel jLabel4 = new JLabel("客戶卡號：");
    JLabel jLabel7 = new JLabel();
    JLabel lnlcdininf1 = new JLabel();
    JTextField jTextField1 = new JTextField("");
    JTextField txfcdinusername = new JTextField("");
    JLabel jLabel6 = new JLabel("客戶卡號：");
    JLabel lnlcdininf2 = new JLabel();
    JLabel lnlcdininf3 = new JLabel();
    JLabel lnlcdoutinf3 = new JLabel();
    JLabel lnlcdoutinf2 = new JLabel();
    public Cdmanage() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
    //組建構造
    private void jbInit() throws Exception
    {
        txfcdoutcardid.setBounds(new Rectangle(162, 60, 105, 25));
        pnlout.setLayout(null);
        this.setLayout(null);
        this.setSize(794,473);
        cdtab.setBounds(new Rectangle(115, 60, 570,310));
        cdtab.setFont(new Font("宋體",0,12));
        txfcdoutcardid.setText("");
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jLabel1.setBounds(new Rectangle(74, 103, 62, 31));
        jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jLabel2.setBounds(new Rectangle(74, 57, 62, 31));
        txfcdoutcardpwd.setBounds(new Rectangle(162, 106, 105, 25));
        database1.setConnection(new ConnectionDescriptor("jdbc:odbc:mrs", "","", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
        database1.setDatabaseName("");
        queryDataSet1.setReadOnly(true);
        queryDataSet1.setSchemaName("");
        queryDataSet1.setTableName("");
        queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from cd\n\n", null, true, Load.ALL));
        btncdoutok.setBounds(new Rectangle(72, 229, 83, 32));
        btncdoutok.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        btncdoutok.setText("借  出");
        btncdoutok.addActionListener(new Cdmanage_btncdoutok_actionAdapter(this));
        btncdoutclear.setBounds(new Rectangle(186, 229, 83, 32));
        btncdoutclear.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        btncdoutclear.setText("重  置");
        btncdoutclear.addActionListener(new Cdmanage_btncdoutclear_actionAdapter(this));
        lblcdoutpic.setText("");
        lblcdoutpic.setBounds(new Rectangle(0, 0, 569, 289));
        lblcdinpic.setBounds(new Rectangle(0, 0, 569, 289));
        pnlin.setLayout(null);
        txfcdincdid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txfcdincdid.setBounds(new Rectangle(162, 60, 105, 25));
        jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jLabel3.setText("客戶卡號：");
        jLabel3.setBounds(new Rectangle(74, 103, 62, 31));
        btncdinclear.setBounds(new Rectangle(186, 229, 83, 32));
        btncdinclear.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        btncdinclear.setText("重  置");
        btncdinclear.addActionListener(new Cdmanage_btncdinclear_actionAdapter(this));
        btncdinok.setBounds(new Rectangle(72, 229, 83, 32));
        btncdinok.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        btncdinok.setText("歸  還");
        btncdinok.addActionListener(new Cdmanage_btncdinok_actionAdapter(this));
        lnlcdoutinf1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lnlcdoutinf1.setText("");
        lnlcdoutinf1.setBounds(new Rectangle(301, 58, 223, 20));
        jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jLabel5.setText("光盤編號：");
        jLabel5.setBounds(new Rectangle(74, 152, 62, 31));
        txfcdoutcdid.setBounds(new Rectangle(162, 155, 65, 25));
        txfcdincardid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txfcdincardid.setEditable(false);
        txfcdincardid.setText("");
        txfcdincardid.setBounds(new Rectangle(162, 106, 105, 25));
        jLabel4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jLabel4.setText("碟片編號：");
        jLabel4.setBounds(new Rectangle(74, 57, 62, 31));
        jLabel7.setText("jLabel7");
        jLabel7.setBounds(new Rectangle(0, 0, 34, 16));
        lnlcdininf1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lnlcdininf1.setText("");
        lnlcdininf1.setBounds(new Rectangle(301, 58, 223, 20));
        jTextField1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jTextField1.setEditable(false);
        jTextField1.setBounds(new Rectangle(162, 106, 105, 25));
        txfcdinusername.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txfcdinusername.setEditable(false);
        txfcdinusername.setBounds(new Rectangle(162, 154,105, 25));
        jLabel6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jLabel6.setText("客戶姓名：");
        jLabel6.setBounds(new Rectangle(74, 151, 62, 31));
        lnlcdininf2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lnlcdininf2.setBounds(new Rectangle(301, 80, 223, 20));
        lnlcdininf3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lnlcdininf3.setText("");
        lnlcdininf3.setBounds(new Rectangle(301, 102, 223, 20));
        lnlcdoutinf3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lnlcdoutinf3.setBounds(new Rectangle(301, 102, 223, 20));
        lnlcdoutinf2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lnlcdoutinf2.setText("");
        lnlcdoutinf2.setBounds(new Rectangle(301, 80, 223, 20));
        pnlout.add(jLabel2);
        pnlout.add(txfcdoutcardid);
        pnlout.add(lnlcdoutinf1);
        pnlout.add(btncdoutok);
        pnlout.add(btncdoutclear);
        pnlout.add(txfcdoutcardpwd);
        pnlout.add(jLabel1);
        pnlout.add(jLabel5);
        pnlout.add(txfcdoutcdid);
        pnlout.add(lnlcdoutinf3);
        pnlout.add(lnlcdoutinf2);
        pnlout.add(lblcdoutpic);
        pnlin.add(btncdinclear);
        pnlin.add(btncdinok);
        pnlin.add(txfcdincdid);
        pnlin.add(txfcdincardid);
        pnlin.add(jLabel4);
        pnlin.add(jLabel3);
        cdtab.add(pnlout, "光碟借出");
        cdtab.add(pnlin, "光碟歸還");
        this.add(cdtab);
        pnlin.add(lnlcdininf1);
        pnlin.add(jTextField1);
        pnlin.add(txfcdinusername);
        pnlin.add(jLabel6);
        pnlin.add(lnlcdininf3);
        pnlin.add(lnlcdininf2);
        pnlin.add(lblcdinpic);
    }


    //cdout重置按鈕動作
    public void btncdoutclear_actionPerformed(ActionEvent e) {
        txfcdoutcardid.setText("");
        txfcdoutcardpwd.setText("");
        txfcdoutcdid.setText("");
        lnlcdoutinf1.setText("請填寫卡號和密碼。");
        lnlcdoutinf2.setText("");
        lnlcdoutinf3.setText("");



    }
    //cdout確定按鈕動作
    public void btncdoutok_actionPerformed(ActionEvent e) {
        //初始化信息
        lnlcdoutinf1.setText("");
        lnlcdoutinf2.setText("");
        lnlcdoutinf3.setText("");
        //健壯性檢查
        if(txfcdoutcardid.getText().equals("") || new String(txfcdoutcardpwd.getPassword()).equals("")|| txfcdoutcdid.getText().equals(""))
        {
            lnlcdoutinf1.setText("請填寫完整信息！");}
        else
        {
            //得到必要的信息
            Card card=new Card();
            card.setcardid(txfcdoutcardid.getText());
            card.setcardpwd(new String(txfcdoutcardpwd.getPassword()));
            Cd cd=new Cd();
            cd.setcdid(txfcdoutcdid.getText());
            //調用借出業務
            int cdout=BusinessAction.cdout(card,cd);
            switch(cdout)
            {
            case 1:
                //客戶帳戶或密碼無效
                lnlcdoutinf1.setText("客戶名或密碼無效！");
                break;
            case 2:
                //光碟編號無效
                lnlcdoutinf1.setText("光碟編號無效！");
                break;
            case 3:
                //客戶帳戶借出數量達到上限
                lnlcdoutinf1.setText("客戶借閱的碟片數量已經達到上限。");
                break;
            case 4:
                //客戶剩余的可借碟數為0
                lnlcdoutinf1.setText("客戶不能再借閱碟片，請充值！");
                break;
            case 5:
                //碟片不在鋪
                lnlcdoutinf1.setText("該碟片已借出，請換其他碟片！");
                break;
            case 6:
                //碟片借出操作
                Vector veccdoutinf=BusinessAction.showcdoutinf(cd);
                lnlcdoutinf2.setText("《"+veccdoutinf.elementAt(0)+"》");
                lnlcdoutinf3.setText("類型："+veccdoutinf.elementAt(1)+"  分類："+veccdoutinf.elementAt(2));
                lnlcdoutinf1.setText("客戶"+veccdoutinf.elementAt(3)+"借出碟片：");
                break;
            }
        }
    }
    //cdin重置按鈕動作
    public void btncdinclear_actionPerformed(ActionEvent e) {
        txfcdincdid.setText("");
        txfcdincardid.setText("");
        txfcdinusername.setText("");
        lnlcdininf1.setText("");
        lnlcdininf2.setText("");
        lnlcdininf3.setText("");
    }
    //cdin確定按鈕動作
    public void btncdinok_actionPerformed(ActionEvent e) {
        //初始化信息
        lnlcdininf1.setText("");
        lnlcdininf2.setText("");
        lnlcdininf3.setText("");
        txfcdincardid.setText("");
        txfcdinusername.setText("");
        Vector vecinf=new Vector();
        //健壯性檢查
        if(txfcdincdid.getText().equals(""))
        {
            lnlcdininf1.setText("請輸入碟片編號！");}
        else
        {
            //得到必要的信息
            Cd cd=new Cd();
            cd.setcdid(txfcdincdid.getText());
            //調用歸還業務
            int cdin=BusinessAction.cdin(cd);
            switch (cdin)
            {
            case 1:
                //碟片編號的無效
                lnlcdininf1.setText("沒有該碟片編號，請重新輸入！");
                break;
            case 2:
                //碟片未曾借出
                lnlcdininf1.setText("碟片未曾借出，請檢查！");
                break;
            case 3:
                //碟片借出超期,顯示相關信息
                vecinf=BusinessAction.showcdininf(cd,1);
                lnlcdininf1.setText("碟片超期，請交罰款"+vecinf.elementAt(5)+"元！");
                lnlcdininf2.setText("碟片《"+vecinf.elementAt(0)+"》");
                lnlcdininf3.setText("類型："+vecinf.elementAt(1)+"  分類："+vecinf.elementAt(2));
                txfcdincardid.setText(vecinf.elementAt(3).toString());
                txfcdinusername.setText(vecinf.elementAt(4).toString());
                break;
            case 4:
                //碟片歸還操作
                lnlcdininf1.setText("碟片歸還完畢，謝謝觀賞！");
                //顯示相關信息
                vecinf=BusinessAction.showcdininf(cd,0);
                lnlcdininf2.setText("碟片《"+vecinf.elementAt(0)+"》");
                lnlcdininf3.setText("類型："+vecinf.elementAt(1)+"  分類："+vecinf.elementAt(2));
                txfcdincardid.setText(vecinf.elementAt(3).toString());
                txfcdinusername.setText(vecinf.elementAt(4).toString());
            }
        }
    }
}


class Cdmanage_btncdinok_actionAdapter implements ActionListener {
    private Cdmanage adaptee;
    Cdmanage_btncdinok_actionAdapter(Cdmanage adaptee) {
        this.adaptee = adaptee;
    }

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

class Cdmanage_btncdinclear_actionAdapter implements ActionListener {
    private Cdmanage adaptee;
    Cdmanage_btncdinclear_actionAdapter(Cdmanage adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.btncdinclear_actionPerformed(e);
    }
}

class Cdmanage_btncdoutok_actionAdapter implements ActionListener {
    private Cdmanage adaptee;
    Cdmanage_btncdoutok_actionAdapter(Cdmanage adaptee) {
        this.adaptee = adaptee;
    }

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

class Cdmanage_btncdoutclear_actionAdapter implements ActionListener {
    private Cdmanage adaptee;
    Cdmanage_btncdoutclear_actionAdapter(Cdmanage adaptee) {
        this.adaptee = adaptee;
    }

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