package zcgl;

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

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class ZcView extends JFrame {
    Connection con = null;
    ResultSet rs = null;
    Statement smt = null;
    public ZcView() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(22, 31, 358, 245));
        jPanel1.setLayout(null);
        jLabel1.setText("資產(chǎn)編號");
        jLabel1.setBounds(new Rectangle(15, 31, 48, 15));
        jLabel2.setText("資產(chǎn)名稱");
        jLabel2.setBounds(new Rectangle(184, 31, 48, 15));
        txtZcName.setBounds(new Rectangle(238, 30, 96, 20));
        jLabel3.setText("大類編號");
        jLabel3.setBounds(new Rectangle(15, 65, 48, 15));
        jLabel4.setText("子類編號");
        jLabel4.setBounds(new Rectangle(184, 64, 48, 15));
        jLabel5.setText("樣式");
        jLabel5.setBounds(new Rectangle(15, 99, 24, 15));
        cmbZlId.setBounds(new Rectangle(238, 63, 96, 23));
        cmbDlId.setBounds(new Rectangle(74, 62, 88, 23));
        txtZcId.setBounds(new Rectangle(74, 28, 88, 20));
        txtStyle.setBounds(new Rectangle(74, 97, 88, 21));
        jLabel6.setText("價格");
        jLabel6.setBounds(new Rectangle(184, 98, 63, 21));
        txtPrice.setBounds(new Rectangle(238, 100, 96, 20));
        jLabel7.setText("購入日期");
        jLabel7.setBounds(new Rectangle(15, 137, 75, 24));
        txtGrDate.setBounds(new Rectangle(74, 140, 88, 22));
        jLabel8.setText("狀態(tài)");
        jLabel8.setBounds(new Rectangle(184, 142, 42, 20));
        txtStatus.setBounds(new Rectangle(238, 143, 96, 22));
        jLabel9.setText("購入人");
        jLabel9.setBounds(new Rectangle(15, 182, 54, 25));
//     jTextField2.setText("jTextField2");
        txtGrR.setBounds(new Rectangle(74, 182, 88, 24));
        jLabel10.setText("備注");

        jLabel10.setBounds(new Rectangle(184, 183, 48, 22));

        txtContext.setBounds(new Rectangle(238, 183, 96, 24));
        btnAdd.setBounds(new Rectangle(52, 291, 68, 38));
        btnAdd.setText("添加");
        btnAdd.addActionListener(new ZcView_btnAdd_actionAdapter(this));
        btnDel.setBounds(new Rectangle(130, 291, 68, 38));
        btnDel.setText("刪除");
        btnDel.addActionListener(new ZcView_btnDel_actionAdapter(this));
        btnModify.setBounds(new Rectangle(206, 292, 68, 38));
        btnModify.setText("修改");
        btnModify.addActionListener(new ZcView_btnModify_actionAdapter(this));
        jButton1.setBounds(new Rectangle(284, 293, 68, 36));
        jButton1.setText("查詢");
        jButton1.addActionListener(new ZcView_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(36, 218, 51, 23));
        jButton2.setText("jButton2");
        jButton2.addActionListener(new ZcView_jButton2_actionAdapter(this));
        this.getContentPane().add(jPanel1);
        jPanel1.add(jLabel1);
        jPanel1.add(jLabel7);
        jPanel1.add(jLabel5);
        jPanel1.add(jLabel3);
        jPanel1.add(jLabel9);
        jPanel1.add(txtZcId);
        jPanel1.add(txtGrDate);
        jPanel1.add(txtGrR);
        jPanel1.add(txtStyle);
        jPanel1.add(cmbDlId);
        jPanel1.add(txtZcName);
        jPanel1.add(cmbZlId);
        jPanel1.add(txtPrice);
        jPanel1.add(txtStatus);
        jPanel1.add(txtContext);
        jPanel1.add(jLabel4);
        jPanel1.add(jLabel2);
        jPanel1.add(jLabel6);
        jPanel1.add(jLabel8);
        jPanel1.add(jLabel10);
        jPanel1.add(jButton2);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(btnAdd);
        this.getContentPane().add(btnDel);
        this.getContentPane().add(btnModify);
        con = new DbCon().getConnection();
        smt = con.createStatement();
        rs = smt.executeQuery("select cateid,subcateid from CATEGORY");
        while (rs.next()) {
            cmbDlId.addItem(rs.getInt(1));
            cmbZlId.addItem(rs.getInt(2));
        }
    }

    JPanel jPanel1 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JTextField txtZcId = new JTextField();
    JLabel jLabel2 = new JLabel();
    JTextField txtZcName = new JTextField();
    JLabel jLabel3 = new JLabel();
    JComboBox cmbDlId = new JComboBox();
    JLabel jLabel4 = new JLabel();
    JComboBox cmbZlId = new JComboBox();
    JLabel jLabel5 = new JLabel();
    JTextField txtStyle = new JTextField();
    JLabel jLabel6 = new JLabel();
    JTextField txtPrice = new JTextField();
    JLabel jLabel7 = new JLabel();
    JTextField txtGrDate = new JTextField();
    JLabel jLabel8 = new JLabel();
    JTextField txtStatus = new JTextField();
    JLabel jLabel9 = new JLabel();
    JTextField txtGrR = new JTextField();
    JLabel jLabel10 = new JLabel();
    JTextField txtContext = new JTextField();
    JButton btnAdd = new JButton();
    JButton btnDel = new JButton();
    JButton btnModify = new JButton();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    public void btnAdd_actionPerformed(ActionEvent e) {
        ZcBean bean = new ZcBean();
        bean.setZcId(Integer.parseInt(txtZcId.getText()));
        bean.setZcName(txtZcName.getText());
        bean.setZcDlId(Integer.parseInt(cmbDlId.getSelectedItem().toString()));
        bean.setZcZlId(Integer.parseInt(cmbZlId.getSelectedItem().toString()));
        bean.setZcStyle(txtStyle.getText());
        bean.setZcPrice(Float.parseFloat(txtPrice.getText()));
        bean.setZcGrDate(txtGrDate.getText());
        bean.setZcStatus(txtStatus.getText());
        bean.setZcGrR(txtGrR.getText());
        bean.setZcContext(txtContext.getText());
        if (bean.insert()) {
            JOptionPane.showMessageDialog(this, "插入成功！");
        } else {
            JOptionPane.showMessageDialog(this, "插入失敗！");
        }
    }

    public void btnDel_actionPerformed(ActionEvent e) {
        ZcBean bean = new ZcBean();
        bean.setZcId(Integer.parseInt(txtZcId.getText()));
        if (bean.isNull()) {
            JOptionPane.showMessageDialog(this, "沒有此記錄！");
            return;
        }
        if (bean.del()) {
            JOptionPane.showMessageDialog(this, "刪除成功！");
        } else {
            JOptionPane.showMessageDialog(this, "刪除失敗！");
        }
    }

    public void btnModify_actionPerformed(ActionEvent e) {
        ZcBean bean = new ZcBean();
        bean.setZcId(Integer.parseInt(txtZcId.getText()));
        bean.setZcName(txtZcName.getText());
        bean.setZcDlId(Integer.parseInt(cmbDlId.getSelectedItem().toString()));
        bean.setZcZlId(Integer.parseInt(cmbZlId.getSelectedItem().toString()));
        bean.setZcStyle(txtStyle.getText());
        bean.setZcPrice(Float.parseFloat(txtPrice.getText()));
        bean.setZcGrDate(txtGrDate.getText());
        bean.setZcStatus(txtStatus.getText());
        bean.setZcGrR(txtGrR.getText());
        bean.setZcContext(txtContext.getText());
        if (bean.isNull()) {
            JOptionPane.showMessageDialog(this, "沒有此記錄！");
            return;
        }

        if (bean.modify()) {
            JOptionPane.showMessageDialog(this, "修改成功！");
        } else {
            JOptionPane.showMessageDialog(this, "修改失敗！");
        }

    }

    public void jButton1_actionPerformed(ActionEvent e) throws SQLException {
        ResultSet rs=null;
        rs= new DbCon().execute("select * from ASSET where assetid="+txtZcId.getText());
        if(rs.next()){

            txtZcId.setText(String.valueOf(rs.getInt("assetid")));
            txtZcName.setText(rs.getString("asset_name").trim());

            cmbDlId.setSelectedItem(String.valueOf(rs.getInt("cateid")));
            cmbZlId.setSelectedItem(String.valueOf(rs.getInt("subcateid")));

            txtStyle.setText(rs.getString("model").trim());
            txtPrice.setText(String.valueOf(rs.getFloat("price")));

            txtGrDate.setText(rs.getDate("purchase_date").toString());
            txtStatus.setText(rs.getString("status"));
            txtGrR.setText(rs.getString("useby").trim());
            txtContext.setText(rs.getString("remarks").trim());
        }

    }

    public void jButton2_actionPerformed(ActionEvent e) {
        cmbDlId.setSelectedItem(cmbDlId.getSelectedItem());
    }
}


class ZcView_jButton2_actionAdapter implements ActionListener {
    private ZcView adaptee;
    ZcView_jButton2_actionAdapter(ZcView adaptee) {
        this.adaptee = adaptee;
    }

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


class ZcView_jButton1_actionAdapter implements ActionListener {
    private ZcView adaptee;
    ZcView_jButton1_actionAdapter(ZcView adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        try {
            adaptee.jButton1_actionPerformed(e);
        } catch (SQLException ex) {
        }
    }
}


class ZcView_btnModify_actionAdapter implements ActionListener {
    private ZcView adaptee;
    ZcView_btnModify_actionAdapter(ZcView adaptee) {
        this.adaptee = adaptee;
    }

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


class ZcView_btnAdd_actionAdapter implements ActionListener {
    private ZcView adaptee;
    ZcView_btnAdd_actionAdapter(ZcView adaptee) {
        this.adaptee = adaptee;
    }

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


class ZcView_btnDel_actionAdapter implements ActionListener {
    private ZcView adaptee;
    ZcView_btnDel_actionAdapter(ZcView adaptee) {
        this.adaptee = adaptee;
    }

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