package zcgl;

import java.awt.*;
import java.sql.*;
import javax.swing.*;
import java.awt.Rectangle;
import javax.swing.BorderFactory;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

public class LendView extends JFrame {
    Connection con = null;
    Statement smt = null;
    ResultSet rs = null;
    public LendView() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(28, 28, 350, 210));
        jPanel1.setLayout(null);
        jLabel1.setText("資產名稱");
        jLabel1.setBounds(new Rectangle(184, 31, 48, 15));
        jLabel2.setText("資產編號");
        jLabel2.setBounds(new Rectangle(12, 31, 48, 15));
        txtZcName.setBounds(new Rectangle(241, 30, 91, 20));
        txtZcId.setBounds(new Rectangle(74, 28, 91, 20));
        txtPrice.setBounds(new Rectangle(241, 63, 91, 20));
        jLabel3.setText("價格");
        jLabel3.setBounds(new Rectangle(184, 61, 63, 21));
        txtStyle.setBounds(new Rectangle(74, 60, 88, 20));
        jLabel4.setText("樣式");
        jLabel4.setBounds(new Rectangle(12, 62, 24, 15));
        jLabel5.setText("借用人編號");
        jLabel5.setBounds(new Rectangle(12, 90, 62, 25));
        cmbLender.setBounds(new Rectangle(74, 92, 90, 20));
        txtLendDate.setBounds(new Rectangle(241, 92, 91, 20));
        jLabel6.setText("借用日期");
        jLabel6.setBounds(new Rectangle(184, 89, 75, 24));
        jLabel7.setText("歸還日期");
        jLabel7.setBounds(new Rectangle(12, 126, 51, 19));
        txtGhDate.setToolTipText("");
        txtGhDate.setBounds(new Rectangle(74, 128, 92, 20));
        jLabel8.setText("是否歸還");
        jLabel8.setBounds(new Rectangle(184, 128, 58, 20));
        cmbLend.setBounds(new Rectangle(241, 127, 91, 20));
        jLabel9.setText("操作人");
        jLabel9.setBounds(new Rectangle(12, 164, 61, 23));
        txtOpator.setBounds(new Rectangle(74, 165, 92, 20));
        jLabel10.setText("備注");
        jLabel10.setBounds(new Rectangle(184, 166, 52, 19));
        txtContext.setBounds(new Rectangle(241, 163, 91, 20));
        btnBorrow.setBounds(new Rectangle(108, 252, 82, 31));
        btnBorrow.setText("借用");
        btnBorrow.addActionListener(new LendView_btnBorrow_actionAdapter(this));
        btnReturn.setBounds(new Rectangle(209, 253, 82, 31));
        btnReturn.setText("歸還");
        btnReturn.addActionListener(new LendView_btnReturn_actionAdapter(this));
        jPanel1.add(jLabel1);
        jPanel1.add(jLabel2);
        jPanel1.add(txtZcName);
        jPanel1.add(txtZcId);
        jPanel1.add(txtStyle);
        jPanel1.add(jLabel4);
        jPanel1.add(jLabel3);
        jPanel1.add(txtPrice);
        jPanel1.add(jLabel5);
        jPanel1.add(cmbLender);
        jPanel1.add(txtLendDate);
        jPanel1.add(jLabel6);
        jPanel1.add(jLabel7);
        jPanel1.add(txtGhDate);
        jPanel1.add(jLabel8);
        jPanel1.add(cmbLend);
        jPanel1.add(jLabel9);
        jPanel1.add(txtOpator);
        jPanel1.add(jLabel10);
        jPanel1.add(txtContext);
        this.getContentPane().add(btnBorrow);
        this.getContentPane().add(btnReturn);
        this.getContentPane().add(jPanel1);
        cmbLend.addItem("是");
        cmbLend.addItem("否");
        con = new DbCon().getConnection();
        smt = con.createStatement();
        rs = smt.executeQuery("select empno from EMPLOYEE");
        while (rs.next()) {
            cmbLender.addItem(rs.getInt(1));
        }

    }

    JPanel jPanel1 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JTextField txtZcName = new JTextField();
    JTextField txtZcId = new JTextField();
    JTextField txtPrice = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField txtStyle = new JTextField();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JComboBox cmbLender = new JComboBox();
    JTextField txtLendDate = new JTextField();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JTextField txtGhDate = new JTextField();
    JLabel jLabel8 = new JLabel();
    JComboBox cmbLend = new JComboBox();
    JLabel jLabel9 = new JLabel();
    JTextField txtOpator = new JTextField();
    JLabel jLabel10 = new JLabel();
    JTextField txtContext = new JTextField();
    JButton btnBorrow = new JButton();
    JButton btnReturn = new JButton();
    public void btnBorrow_actionPerformed(ActionEvent e) {
        ZcBean bean = new ZcBean();
        bean.setZcId(Integer.parseInt(txtZcId.getText()));
        if(bean.isUse()){
             JOptionPane.showMessageDialog(this, "此資產已被借出！");
             return;
        }


        bean.setZcName(txtZcName.getText());
        bean.setZcStyle(txtStyle.getText());
        bean.setLendDate(txtLendDate.getText());
        bean.setZcPrice(Float.parseFloat(txtPrice.getText()));
        bean.setReturnDate(txtGhDate.getText());
        bean.setLender(Integer.parseInt(cmbLender.getSelectedItem().toString()));

        if (cmbLend.getSelectedIndex() == 0) {
            bean.setZcStatus("1");
        } else {
            bean.setZcStatus("0");
        }
        bean.setZcGrR(txtOpator.getText());
        bean.setZcContext(txtContext.getText());
        if (bean.lend()) {
            JOptionPane.showMessageDialog(this, "操作成功！");
        } else {
            JOptionPane.showMessageDialog(this, "操作失??！");
        }

    }

    public void btnReturn_actionPerformed(ActionEvent e) {
        ZcBean bean = new ZcBean();
        bean.setZcId(Integer.parseInt(txtZcId.getText()));
        if(!bean.isUse()){
            JOptionPane.showMessageDialog(this, "此資產沒有被借出，不需要歸還！");
            return;
        }
       if( bean.returns())
           JOptionPane.showMessageDialog(this, "操作成功！");
       else
           JOptionPane.showMessageDialog(this, "操作失?。?quot;);
    }
}


class LendView_btnReturn_actionAdapter implements ActionListener {
    private LendView adaptee;
    LendView_btnReturn_actionAdapter(LendView adaptee) {
        this.adaptee = adaptee;
    }

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


class LendView_btnBorrow_actionAdapter implements ActionListener {
    private LendView adaptee;
    LendView_btnBorrow_actionAdapter(LendView adaptee) {
        this.adaptee = adaptee;
    }

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