package zcgl;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.*;
import java.awt.Font;
import java.awt.Rectangle;
import javax.swing.border.TitledBorder;
import java.awt.FlowLayout;
import com.borland.jbcl.layout.VerticalFlowLayout;
import javax.swing.border.Border;
import com.borland.jbcl.layout.PaneLayout;
import com.borland.jbcl.layout.*;
import java.awt.GridBagLayout;
import java.awt.*;
import javax.swing.table.DefaultTableModel;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import javax.swing.event.AncestorEvent;
import javax.swing.event.AncestorListener;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class MainFrame extends JFrame {
    JPanel contentPane;
    JMenuBar jMenuBar1 = new JMenuBar();
    JMenu jMenuFile = new JMenu();
    JMenuItem jMenuFileExit = new JMenuItem();
    JMenuItem jMenuItem1 = new JMenuItem();
    JMenuItem jMenuItem2 = new JMenuItem();
    JMenu jMenu1 = new JMenu();
    JMenuItem jMenuItem3 = new JMenuItem();
    JMenuItem jMenuItem4 = new JMenuItem();
    JMenuItem jMenuItem5 = new JMenuItem();
    JMenu jMenu2 = new JMenu();
    JMenuItem jMenuItem6 = new JMenuItem();
    JMenuItem jMenuItem7 = new JMenuItem();
    JMenuItem jMenuItem8 = new JMenuItem();
    JPanel jPanel1 = new JPanel();
    TitledBorder titledBorder1 = new TitledBorder("");
    JLabel jLabel1 = new JLabel();
    JTextField txtFindId = new JTextField();
    VerticalFlowLayout verticalFlowLayout1 = new VerticalFlowLayout();
    JLabel jLabel2 = new JLabel();
    JTextField txtFindName = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JPanel jPanel2 = new JPanel();
    JLabel jLabel3 = new JLabel();
    JTextField txtJyDate = new JTextField();
    JLabel jLabel4 = new JLabel();
    JTextField txtName = new JTextField();
    JLabel jLabel5 = new JLabel();
    JTextField txtZcId = new JTextField();
    JLabel jLabel6 = new JLabel();
    JTextField txtStyle = new JTextField();
    JLabel jLabel7 = new JLabel();
    JTextField txtDlId = new JTextField();
    JLabel jLabel8 = new JLabel();
    JTextField txtZlId = new JTextField();
    JLabel jLabel9 = new JLabel();
    JTextField txtGhDate = new JTextField();
    JLabel jLabel10 = new JLabel();
    JTextField txtPrice = new JTextField();
    JLabel jLabel11 = new JLabel();
    JTextField txtGrDate = new JTextField();
    JLabel jLabel12 = new JLabel();
    JTextField txtStatus = new JTextField();
    JLabel jLabel13 = new JLabel();
    JTextField txtGrR = new JTextField();
    JLabel jLabel14 = new JLabel();
    JTextField txtContent = new JTextField();
    JLabel jLabel15 = new JLabel();
    JTextField txtJyR = new JTextField();
    JLabel jLabel16 = new JLabel();
    JTextField txtReturn = new JTextField();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable table;
    DefaultTableModel tm;
    JMenu jMenu3 = new JMenu();
    JMenuItem jMenuItem9 = new JMenuItem();
    JMenuItem jMenuItem10 = new JMenuItem();
    Connection con = null;
    Statement smt = null;
    ResultSet rs = null;
    JButton jButton3 = new JButton();
    JMenu jMenu4 = new JMenu();
    JMenuItem jMenuItem11 = new JMenuItem();
    public MainFrame() {
        try {
            setDefaultCloseOperation(EXIT_ON_CLOSE);
            Object[] o = {"資產編號", "資產名稱", "大類編號", "子類編號", "樣式", "價格", "購入日期",
                         "狀態", "購入人", "備注"};
            tm = new DefaultTableModel(o, 0);

            table = new JTable(tm);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    /**
     * Component initialization.
     *
     * @throws java.lang.Exception
     */
    private void jbInit() throws Exception {
        titledBorder1 = new TitledBorder("詳細信息");
        contentPane = (JPanel) getContentPane();
        contentPane.setLayout(null);
        setSize(new Dimension(753, 554));
        setTitle("資產管理系統");
        jMenuFile.setFont(new java.awt.Font("宋體", Font.BOLD, 13));
        jMenuFile.setText("固定資產管理");
        jMenuFileExit.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
        jMenuFileExit.setText("增加");
        jMenuFileExit.addActionListener(new
                                        MainFrame_jMenuFileExit_ActionAdapter(this));
        jMenuItem1.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
        jMenuItem1.setText("刪除");
        jMenuItem1.addActionListener(new MainFrame_jMenuItem1_actionAdapter(this));
        jMenuItem2.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
        jMenuItem2.setText("修改");
        jMenuItem2.addActionListener(new MainFrame_jMenuItem2_actionAdapter(this));
        jMenu1.setFont(new java.awt.Font("宋體", Font.BOLD, 13));
        jMenu1.setText("職工管理");
        jMenuItem3.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
        jMenuItem3.setText("增加");
        jMenuItem3.addActionListener(new MainFrame_jMenuItem3_actionAdapter(this));
        jMenuItem4.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
        jMenuItem4.setText("刪除");
        jMenuItem4.addActionListener(new MainFrame_jMenuItem4_actionAdapter(this));
        jMenuItem5.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
        jMenuItem5.setText("修改");
        jMenuItem5.addActionListener(new MainFrame_jMenuItem5_actionAdapter(this));
        jMenu2.setFont(new java.awt.Font("宋體", Font.BOLD, 13));
        jMenu2.setText("資產類別管理");
        jMenuItem6.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
        jMenuItem6.setText("增加");
        jMenuItem6.addActionListener(new MainFrame_jMenuItem6_actionAdapter(this));
        jMenuItem7.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
        jMenuItem7.setText("刪除");
        jMenuItem7.addActionListener(new MainFrame_jMenuItem7_actionAdapter(this));
        jMenuItem8.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
        jMenuItem8.setText("修改");
        jMenuItem8.addActionListener(new MainFrame_jMenuItem8_actionAdapter(this));
        jPanel1.setBorder(titledBorder1);
        jPanel1.setPreferredSize(new Dimension(110, 79));
        jPanel1.setBounds(new Rectangle(9, 13, 169, 322));
        jPanel1.setLayout(verticalFlowLayout1);
        jLabel1.setText("以資產編號查詢");
        jLabel2.setText("以資產名稱查詢");
        jButton1.setText("查    詢");
        jButton1.addActionListener(new MainFrame_jButton1_actionAdapter(this));
        jButton2.setText("查    詢");
        jButton2.addActionListener(new MainFrame_jButton2_actionAdapter(this));
        jPanel2.setBorder(titledBorder1);
        jPanel2.setBounds(new Rectangle(192, 13, 536, 323));
        jPanel2.setLayout(null);
        jLabel3.setText("資產名稱");
        jLabel3.setBounds(new Rectangle(315, 24, 52, 21));
        jLabel4.setText("資產編號");
        jLabel4.setBounds(new Rectangle(40, 25, 66, 15));
        txtJyDate.setBounds(new Rectangle(375, 221, 124, 22));
        txtName.setBounds(new Rectangle(375, 23, 124, 22));
        jLabel5.setText("大類編號");
        jLabel5.setBounds(new Rectangle(40, 61, 63, 26));
        txtZcId.setBounds(new Rectangle(98, 22, 91, 22));
        jLabel6.setText("子類編號");
        jLabel6.setBounds(new Rectangle(315, 67, 77, 15));
        txtStyle.setBounds(new Rectangle(98, 101, 91, 22));
        jLabel7.setText("樣式");
        jLabel7.setBounds(new Rectangle(40, 91, 63, 36));
        txtDlId.setBounds(new Rectangle(98, 62, 91, 22));
        jLabel8.setText("價格");
        jLabel8.setBounds(new Rectangle(315, 101, 51, 23));
        txtZlId.setBounds(new Rectangle(375, 63, 124, 22));
        jLabel9.setText("購入日期");
        jLabel9.setBounds(new Rectangle(40, 139, 62, 21));
        txtGhDate.setBounds(new Rectangle(98, 259, 91, 22));
        jLabel10.setText("狀態");
        jLabel10.setBounds(new Rectangle(315, 147, 48, 15));
        txtPrice.setBounds(new Rectangle(375, 106, 124, 22));
        jLabel11.setText("購入人");
        jLabel11.setBounds(new Rectangle(40, 181, 48, 15));
        txtGrDate.setBounds(new Rectangle(98, 141, 91, 22));
        jLabel12.setText("備注");
        jLabel12.setBounds(new Rectangle(315, 185, 48, 15));
        txtStatus.setBounds(new Rectangle(375, 143, 124, 22));
        jLabel13.setText("借用人");
        jLabel13.setBounds(new Rectangle(40, 222, 48, 15));
        txtGrR.setBounds(new Rectangle(98, 180, 91, 22));
        jLabel14.setText("借用日期");
        jLabel14.setBounds(new Rectangle(315, 226, 48, 14));
        txtContent.setBounds(new Rectangle(375, 180, 124, 22));
        jLabel15.setText("歸還日期");
        jLabel15.setBounds(new Rectangle(40, 264, 48, 15));
        txtJyR.setBounds(new Rectangle(98, 220, 91, 22));
        jLabel16.setText("是否歸還");
        jLabel16.setBounds(new Rectangle(315, 265, 48, 15));
        txtReturn.setBounds(new Rectangle(375, 261, 124, 22));
        jScrollPane1.setBounds(new Rectangle(9, 335, 718, 159));
        jScrollPane1.addAncestorListener(new
                                         MainFrame_jScrollPane1_ancestorAdapter(this));
        jScrollPane1.addMouseListener(new MainFrame_jScrollPane1_mouseAdapter(this));
        jMenu3.setFont(new java.awt.Font("宋體", Font.BOLD, 13));
        jMenu3.setText("資產借用管理");
        jMenuItem9.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
        jMenuItem9.setText("借用固定資產");
        jMenuItem9.addActionListener(new MainFrame_jMenuItem9_actionAdapter(this));
        jMenuItem10.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
        jMenuItem10.setText("歸還固定資產");
        jMenuItem10.addActionListener(new MainFrame_jMenuItem10_actionAdapter(this));
        jButton3.setText("查詢所有記錄");
        jButton3.addActionListener(new MainFrame_jButton3_actionAdapter(this));
        table.addMouseListener(new MainFrame_table_mouseAdapter(this));
        jMenu4.setFont(new java.awt.Font("宋體", Font.BOLD, 13));
        jMenu4.setText("用戶管理");
        jMenuItem11.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
        jMenuItem11.setText("修改口令");
        jMenuItem11.addActionListener(new MainFrame_jMenuItem11_actionAdapter(this));
        jMenuBar1.add(jMenuFile);
        jMenuBar1.add(jMenu1);
        jMenuBar1.add(jMenu2);
        jMenuBar1.add(jMenu3);
        jMenuBar1.add(jMenu4);
        jMenuFile.add(jMenuFileExit);
        jMenuFile.add(jMenuItem1);
        jMenuFile.add(jMenuItem2);
        jMenu1.add(jMenuItem3);
        jMenu1.add(jMenuItem4);
        jMenu1.add(jMenuItem5);
        jMenu2.add(jMenuItem6);
        jMenu2.add(jMenuItem7);
        jMenu2.add(jMenuItem8);
        jPanel1.add(jLabel1);
        jPanel1.add(txtFindId);
        jPanel1.add(jButton1);
        jPanel1.add(jLabel2);
        jPanel1.add(txtFindName);
        jPanel1.add(jButton2);
        jPanel1.add(jButton3);
        contentPane.add(jScrollPane1);
        jScrollPane1.getViewport().add(table);
        contentPane.add(jPanel2);
        contentPane.add(jPanel1);
        jPanel2.add(txtZlId);
        jPanel2.add(jLabel8);
        jPanel2.add(jLabel10);
        jPanel2.add(jLabel12);
        jPanel2.add(jLabel14);
        jPanel2.add(jLabel16);
        jPanel2.add(txtReturn);
        jPanel2.add(txtJyDate, null);
        jPanel2.add(txtContent);
        jPanel2.add(txtStatus);
        jPanel2.add(txtPrice);
        jPanel2.add(txtName, null);
        jPanel2.add(jLabel3, null);
        jPanel2.add(jLabel6);
        jPanel2.add(txtGrR);
        jPanel2.add(jLabel4, null);
        jPanel2.add(txtZcId);
        jPanel2.add(txtDlId);
        jPanel2.add(jLabel5);
        jPanel2.add(jLabel7);
        jPanel2.add(txtStyle);
        jPanel2.add(txtGrDate);
        jPanel2.add(jLabel9);
        jPanel2.add(jLabel11);
        jPanel2.add(jLabel13);
        jPanel2.add(txtJyR);
        jPanel2.add(txtGhDate);
        jPanel2.add(jLabel15);
        jMenu3.add(jMenuItem9);
        jMenu3.add(jMenuItem10);
        jMenu4.add(jMenuItem11);
        setJMenuBar(jMenuBar1);
    }

    /**
     * File | Exit action performed.
     *
     * @param actionEvent ActionEvent
     */
    void jMenuFileExit_actionPerformed(ActionEvent actionEvent) {
        ZcView zc = new ZcView();
        zc.setTitle("添加資產信息");
        zc.setSize(400, 400);
        zc.btnDel.setEnabled(false);
        zc.btnModify.setEnabled(false);

        zc.setLocation(300, 100);
        zc.setVisible(true);
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        con = new DbCon().getConnection();
        if (table.getRowCount() > 0) {
            for (int i = 0; table.getRowCount() > 0; i++) {
                tm.removeRow(0);
            }
        }

        try {
            smt = con.createStatement();
            rs = smt.executeQuery("select * from ASSET where assetid=" +
                                  txtFindId.getText());
            while (rs.next()) {
                String id = String.valueOf(rs.getInt("assetid")).trim();
                String name = rs.getString("asset_name").trim();
                String DlId = String.valueOf(rs.getInt("cateid")).trim();
                String ZlId = String.valueOf(rs.getInt("subcateid")).trim();
                String style = rs.getString("model").trim();
                String price = String.valueOf(rs.getFloat("price")).trim();
                String d = rs.getString("purchase_date").trim();
                d = d.substring(0, d.indexOf(" "));
                String gdate = d;
                String status = rs.getString("status").trim();
                String grr = rs.getString("useby").trim();
                String context = rs.getString("remarks").trim();
                String[] info = {id, name, DlId, ZlId, style, price, gdate,
                                status, grr, context};
                tm.addRow(info);
            }
        } catch (SQLException ex) {
        }

    }

    public void jMenuItem1_actionPerformed(ActionEvent e) {
        ZcView zc = new ZcView();
        zc.setTitle("刪除資產信息");
        zc.setSize(400, 400);
        zc.btnAdd.setEnabled(false);
        zc.btnModify.setEnabled(false);
        zc.setLocation(300, 100);
        zc.setVisible(true);

    }

    public void jMenuItem2_actionPerformed(ActionEvent e) {
        ZcView zc = new ZcView();
        zc.setTitle("修改資產信息");
        zc.setSize(400, 400);
        zc.btnAdd.setEnabled(false);
        zc.btnDel.setEnabled(false);
        zc.btnModify.setEnabled(true);
        zc.setLocation(300, 100);
        zc.setVisible(true);

    }

    public void jMenuItem3_actionPerformed(ActionEvent e) {
        ZgView zg = new ZgView();
        zg.setTitle("添加職工信息");
        zg.setSize(400, 400);
        zg.btnDel.setEnabled(false);
        zg.btnModify.setEnabled(false);

        zg.setLocation(300, 100);
        zg.setVisible(true);

    }

    public void jMenuItem4_actionPerformed(ActionEvent e) {
        ZgView zg = new ZgView();
        zg.setTitle("刪除職工信息");
        zg.setSize(400, 400);
        zg.btnAdd.setEnabled(false);
        zg.btnModify.setEnabled(false);

        zg.setLocation(300, 100);
        zg.setVisible(true);

    }

    public void jMenuItem5_actionPerformed(ActionEvent e) {
        ZgView zg = new ZgView();
        zg.setTitle("修改職工信息");
        zg.setSize(400, 400);
        zg.btnDel.setEnabled(false);
        zg.btnAdd.setEnabled(false);

        zg.setLocation(300, 100);
        zg.setVisible(true);

    }

    public void jMenuItem6_actionPerformed(ActionEvent e) {
        ZcLbView zl = new ZcLbView();
        zl.setTitle("添加類別信息");
        zl.setSize(400, 400);
        zl.btnDel.setEnabled(false);
        zl.btnModify.setEnabled(false);