guestquery.java~49~

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

                JOptionPane.showMessageDialog(this, "没有找到你所要查的信息！",
                                              "酒店信息管理系统提示",
                                              JOptionPane.
                                              INFORMATION_MESSAGE);
                return;
            }
            return;
        }
        if (buttonGroup1.getSelection() == jRBName.getModel()) { //姓名
            String strName = jTFName.getText();
            table.fetch("Select RegisterID as 客人登记号, Name as 姓名, Company as 单位, County as 国家,RegPhone as 联系电话 ,PaperType as 证件类型, PaperNo as 证件号码,RegiType,CheckInType,Deposit as 押金,WillCheckDate as 抵店日期, CheckInDate as 入住日期, CheckInDay as 入住天数,PersonMon as 人数,RoomMon as 订房数,Reason as 入住原因 , RoomName01 as 房间号1,RoomName02 as 房间号2,RoomName03 as 房间号3 ,RoomName04 as 房间号4 ,RoomName05 as 房间号5,RoomName06 as 房间号6,RoomName07 as 房间号7,RoomName08 as 房间号8 from HIMS_Register,HIMS_Register_CheckInRoom Where HIMS_Register.RegisterID = HIMS_Register_CheckInRoom.RegRoomID  AND HIMS_Register.Name like '%" +
                        strName +
                        "%'  AND HIMS_Register.Company = '' AND  CheckInType != 'Q'");
            if (jTable1.getRowCount() == 0) {
                JOptionPane.showMessageDialog(this, "没有找到你所要查的信息！",
                                              "酒店信息管理系统提示",
                                              JOptionPane.
                                              INFORMATION_MESSAGE);
                return;
            }
            return;
        }
        if (buttonGroup1.getSelection() == jRBCompany.getModel()) { //单位
            String strCompany = jTFCompany.getText();
            table.fetch("Select RegisterID as 客人登记号, Name as 姓名, Company as 单位, County as 国家,RegPhone as 联系电话 ,PaperType as 证件类型, PaperNo as 证件号码,RegiType,CheckInType,Deposit as 押金,WillCheckDate as 抵店日期, CheckInDate as 入住日期, CheckInDay as 入住天数,PersonMon as 人数,RoomMon as 订房数,Reason as 入住原因 , RoomName01 as 房间号1,RoomName02 as 房间号2,RoomName03 as 房间号3 ,RoomName04 as 房间号4 ,RoomName05 as 房间号5,RoomName06 as 房间号6,RoomName07 as 房间号7,RoomName08 as 房间号8 from HIMS_Register,HIMS_Register_CheckInRoom Where HIMS_Register.RegisterID = HIMS_Register_CheckInRoom.RegRoomID  AND HIMS_Register.Company like '%" +
                        strCompany +
                        "%' AND HIMS_Register.Name = '' AND  CheckInType != 'Q'");
            if (jTable1.getRowCount() == 0) {
                JOptionPane.showMessageDialog(this, "没有找到你所要查的信息！",
                                              "酒店信息管理系统提示",
                                              JOptionPane.
                                              INFORMATION_MESSAGE);
                return;
            }
            return;
        }
        if (buttonGroup1.getSelection() == jRBTodayArrive.getModel()) { //今日要入住的客人信息
            table.fetch("Select RegisterID as 客人登记号, Name as 姓名, Company as 单位, County as 国家,RegPhone as 联系电话 ,PaperType as 证件类型, PaperNo as 证件号码,RegiType,CheckInType,Deposit as 押金,WillCheckDate as 抵店日期, CheckInDate as 入住日期, CheckInDay as 入住天数,PersonMon as 人数,RoomMon as 订房数,Reason as 入住原因 , RoomName01 as 房间号1,RoomName02 as 房间号2,RoomName03 as 房间号3 ,RoomName04 as 房间号4 ,RoomName05 as 房间号5,RoomName06 as 房间号6,RoomName07 as 房间号7,RoomName08 as 房间号8 from HIMS_Register,HIMS_Register_CheckInRoom Where HIMS_Register.RegisterID = HIMS_Register_CheckInRoom.RegRoomID  AND HIMS_Register.WillCheckDate = '" +
                        strStartDate + "' AND CheckInType = 'F' ");
            if (jTable1.getRowCount() == 0) {
                JOptionPane.showMessageDialog(this, "预约的客人今日没有到到达的！",
                                              "酒店信息管理系统提示",
                                              JOptionPane.
                                              INFORMATION_MESSAGE);
                return;
            }
            return;
        }
        if (buttonGroup1.getSelection() == jRBTodaySettleAccounts.getModel()) { //今日要结账的客人信息
            table.fetch("Select RegisterID as 客人登记号, Name as 姓名, Company as 单位, County as 国家,RegPhone as 联系电话 ,PaperType as 证件类型, PaperNo as 证件号码,RegiType,CheckInType,Deposit as 押金,WillCheckDate as 抵店日期, CheckInDate as 入住日期, CheckInDay as 入住天数,PersonMon as 人数,RoomMon as 订房数,Reason as 入住原因 , RoomName01 as 房间号1,RoomName02 as 房间号2,RoomName03 as 房间号3 ,RoomName04 as 房间号4 ,RoomName05 as 房间号5,RoomName06 as 房间号6,RoomName07 as 房间号7,RoomName08 as 房间号8 from HIMS_Register,HIMS_Register_CheckInRoom Where HIMS_Register.RegisterID = HIMS_Register_CheckInRoom.RegRoomID  AND HIMS_Register.QuitDate = '" +
                        strStartDate + "' AND CheckInType = 'N' ");
            if (jTable1.getRowCount() == 0) {
                JOptionPane.showMessageDialog(this, "今日没有要结账的客人！",
                                              "酒店信息管理系统提示",
                                              JOptionPane.
                                              INFORMATION_MESSAGE);
                return;
            }
            return;
        }

    }

    public void jRadioButton5_actionPerformed(ActionEvent e) { //客人登记号
        jTFChickOnTime.setText("");
        jTFWillGoHereTime.setText("");
        jTFName.setText("");
        jTFCompany.setText("");

    }

    public void jRadioButton6_actionPerformed(ActionEvent e) {
        jTFChickOnTime.setEnabled(true);

        jTFChickOnTime.setText("");
        jTFWillGoHereTime.setText("");
        jTFName.setText("");
        jTFCompany.setText("");
    }

    public void jRadioButton7_actionPerformed(ActionEvent e) {
        jTFWillGoHereTime.setEnabled(true);

        jTFChickOnTime.setText("");
        jTFWillGoHereTime.setText("");
        jTFName.setText("");
        jTFCompany.setText("");
    }

    public void jRadioButton8_actionPerformed(ActionEvent e) {
        jTFName.setEnabled(true);

        jTFChickOnTime.setText("");
        jTFWillGoHereTime.setText("");
        jTFName.setText("");
        jTFCompany.setText("");

    }

    public void jRadioButton9_actionPerformed(ActionEvent e) {
        jTFCompany.setEnabled(true);

        jTFChickOnTime.setText("");
        jTFWillGoHereTime.setText("");
        jTFName.setText("");
        jTFCompany.setText("");

    }

    public void jTable1_mouseClicked(MouseEvent e) {
        String strRegiType = jTable1.getValueAt(jTable1.getSelectedRow(), 7).
                             toString();
        String strCheckInType = jTable1.getValueAt(jTable1.getSelectedRow(), 8).
                                toString();
        if (strRegiType.equals("T") && strCheckInType.equals("F")) { //客人类型:团体 入住形式:预定
            jRBGroupDestine.setSelected(true);
        }
        if (strRegiType.equals("T") && strCheckInType.equals("N")) { //客人类型:团体||入住形式:现入
            jRBGroupRegist.setSelected(true);
        }
        if (strRegiType.equals("S") && strCheckInType.equals("F")) { //客人类型:散客 入住形式:预定
            jRBGuestDestine.setSelected(true);
        }
        if (strRegiType.equals("S") && strCheckInType.equals("N")) { //客人类型:散客||入住形式:现入
            jRBGuestRegist.setSelected(true);
        }
    }

}


class GuestQuery_jTable1_mouseAdapter extends MouseAdapter {
    private GuestQuery adaptee;
    GuestQuery_jTable1_mouseAdapter(GuestQuery adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.jTable1_mouseClicked(e);
    }
}


class GuestQuery_jRadioButton9_actionAdapter implements ActionListener {
    private GuestQuery adaptee;
    GuestQuery_jRadioButton9_actionAdapter(GuestQuery adaptee) {
        this.adaptee = adaptee;
    }

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


class GuestQuery_jRadioButton8_actionAdapter implements ActionListener {
    private GuestQuery adaptee;
    GuestQuery_jRadioButton8_actionAdapter(GuestQuery adaptee) {
        this.adaptee = adaptee;
    }

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


class GuestQuery_jRadioButton7_actionAdapter implements ActionListener {
    private GuestQuery adaptee;
    GuestQuery_jRadioButton7_actionAdapter(GuestQuery adaptee) {
        this.adaptee = adaptee;
    }

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


class GuestQuery_jRadioButton6_actionAdapter implements ActionListener {
    private GuestQuery adaptee;
    GuestQuery_jRadioButton6_actionAdapter(GuestQuery adaptee) {
        this.adaptee = adaptee;
    }

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


class GuestQuery_jButton1_actionAdapter implements ActionListener {
    private GuestQuery adaptee;
    GuestQuery_jButton1_actionAdapter(GuestQuery adaptee) {
        this.adaptee = adaptee;
    }

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


class GuestQuery_jButton2_actionAdapter implements ActionListener {
    private GuestQuery adaptee;
    GuestQuery_jButton2_actionAdapter(GuestQuery adaptee) {
        this.adaptee = adaptee;
    }

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