empondutyquery.java~66~

酒店信息管理系统包括客户的信息

                table.fetch("Select  Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注 From HIMS_Employee, HIMS_OnDuty, HIMS_OnDuty_Date where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID AND HIMS_Employee.EmpID = HIMS_OnDuty_Date.EmpID  AND HIMS_OnDuty_Date.Sun < > '0';");
                return;
            }

            table.fetch("Select Name as 姓名, Department as 部门, Duty as 职务, FloorNo as 负责楼层,Proceeding as 负责事项,EmpRemark as 备注 From HIMS_Employee,HIMS_OnDuty where HIMS_Employee.EmpID = HIMS_OnDuty.EmpID  AND HIMS_Employee.Department = '" +
                        strDepartment +
                        "';");
            return;
        }
//------------------------------------------------------------------
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }

    public void jRadioButton15_actionPerformed(ActionEvent e) { //Id
        jRadioButton1.setSelected(true);

        jTextField1.setText("");
        jTextField1.setEnabled(true);

        jTextField2.setText("");
        jTextField2.setEnabled(false); //按姓名查询

        jComboBox1.removeAllItems();
        jComboBox1.setEnabled(false); //按部门

        jComboBox2.removeAllItems();
        jComboBox2.setEnabled(false); //按职务

    }

    public void jRadioButton17_actionPerformed(ActionEvent e) { //name
        jRadioButton1.setSelected(true);

        jTextField1.setText("");
        jTextField1.setEnabled(false); //ID

        jTextField2.setText("");
        jTextField2.setEnabled(true); //按姓名查询

        jComboBox1.removeAllItems();
        jComboBox1.setEnabled(false); //按部门

        jComboBox2.removeAllItems();
        jComboBox2.setEnabled(false); //按职务

    }


    public void jRadioButton9_actionPerformed(ActionEvent e) { //部门
        jRadioButton1.setSelected(true);

        jTextField1.setText("");
        jTextField1.setEnabled(false);

        jTextField2.setText("");
        jTextField2.setEnabled(false); //按姓名查询

        jComboBox1.removeAllItems();
        jComboBox1.setEnabled(true); //按部门
        jComboBox1.addItem(" ");
        jComboBox1.addItem("服务部");
        jComboBox1.addItem("客房部");

        jComboBox2.removeAllItems();
        jComboBox2.setEnabled(false); //按职务

    }

    public void jRadioButton10_actionPerformed(ActionEvent e) { //职务
        jRadioButton1.setSelected(true);

        jTextField1.setText("");
        jTextField1.setEnabled(false);

        jTextField2.setText("");
        jTextField2.setEnabled(false); //按姓名查询

        jComboBox1.removeAllItems();
        jComboBox1.setEnabled(false); //按部门

        jComboBox2.removeAllItems();
        jComboBox2.setEnabled(true); //按职务
        jComboBox2.addItem(" ");
        jComboBox2.addItem("经理");
        jComboBox2.addItem("前台");
        jComboBox2.addItem("服务员");

    }

    public void jRadioButton7_actionPerformed(ActionEvent e) {
        jRadioButton8.setSelected(true);
    }
}


class EmpOnDutyQuery_jRadioButton7_actionAdapter implements ActionListener {
    private EmpOnDutyQuery adaptee;
    EmpOnDutyQuery_jRadioButton7_actionAdapter(EmpOnDutyQuery adaptee) {
        this.adaptee = adaptee;
    }

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


class EmpOnDutyQuery_jRadioButton10_actionAdapter implements ActionListener {
    private EmpOnDutyQuery adaptee;
    EmpOnDutyQuery_jRadioButton10_actionAdapter(EmpOnDutyQuery adaptee) {
        this.adaptee = adaptee;
    }

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


class EmpOnDutyQuery_jRadioButton9_actionAdapter implements ActionListener {
    private EmpOnDutyQuery adaptee;
    EmpOnDutyQuery_jRadioButton9_actionAdapter(EmpOnDutyQuery adaptee) {
        this.adaptee = adaptee;
    }

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


class EmpOnDutyQuery_jRadioButton17_actionAdapter implements ActionListener {
    private EmpOnDutyQuery adaptee;
    EmpOnDutyQuery_jRadioButton17_actionAdapter(EmpOnDutyQuery adaptee) {
        this.adaptee = adaptee;
    }

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


class EmpOnDutyQuery_jRadioButton15_actionAdapter implements ActionListener {
    private EmpOnDutyQuery adaptee;
    EmpOnDutyQuery_jRadioButton15_actionAdapter(EmpOnDutyQuery adaptee) {
        this.adaptee = adaptee;
    }

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


class EmpOnDutyQuery_jButton2_actionAdapter implements ActionListener {
    private EmpOnDutyQuery adaptee;
    EmpOnDutyQuery_jButton2_actionAdapter(EmpOnDutyQuery adaptee) {
        this.adaptee = adaptee;
    }

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


class EmpOnDutyQuery_jButton1_actionAdapter implements ActionListener {
    private EmpOnDutyQuery adaptee;
    EmpOnDutyQuery_jButton1_actionAdapter(EmpOnDutyQuery adaptee) {
        this.adaptee = adaptee;
    }

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