guestchechinroom.java~71~

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

            jTFRoomID01.setEnabled(true);
            jTFRoomID02.setEnabled(true);
            jTFRoomID03.setEnabled(true);
            jTFRoomID04.setEnabled(true);
        } else if (guestreg.RoomMon.equals("6")) {
            jTFRoomID01.setEnabled(true);
            jTFRoomID02.setEnabled(true);
            jTFRoomID03.setEnabled(true);
            jTFRoomID04.setEnabled(true);
            jTFRoomID05.setEnabled(true);
            jTFRoomID06.setEnabled(true);
        } else if (guestreg.RoomMon.equals("7")) {
            jTFRoomID01.setEnabled(true);
            jTFRoomID02.setEnabled(true);
            jTFRoomID03.setEnabled(true);
            jTFRoomID04.setEnabled(true);
            jTFRoomID05.setEnabled(true);
            jTFRoomID06.setEnabled(true);
            jTFRoomID07.setEnabled(true);
        } else if (guestreg.RoomMon.equals("8")) {
            jTFRoomID01.setEnabled(true);
            jTFRoomID02.setEnabled(true);
            jTFRoomID03.setEnabled(true);
            jTFRoomID04.setEnabled(true);
            jTFRoomID05.setEnabled(true);
            jTFRoomID06.setEnabled(true);
            jTFRoomID07.setEnabled(true);
            jTFRoomID08.setEnabled(true);
        } else {
            jTFRoomID01.setEnabled(false);
            jTFRoomID02.setEnabled(false);
            jTFRoomID03.setEnabled(false);
            jTFRoomID04.setEnabled(false);
            jTFRoomID05.setEnabled(false);
            jTFRoomID06.setEnabled(false);
            jTFRoomID07.setEnabled(false);
            jTFRoomID08.setEnabled(false);
        }

        jTFGuestRegID.setText(guestreg.RegisterID);

    }

    public void jButton3_actionPerformed(ActionEvent e) { //

        strRoomName01 = jTFRoomID01.getText();
        strRoomName02 = null;
        strRoomName03 = null;
        strRoomName04 = null;
        strRoomName05 = null;
        strRoomName06 = null;
        strRoomName07 = null;
        strRoomName08 = null;

        try {
            strRoomName02 = jTFRoomID02.getText();
        } catch (Exception ex) {
            strRoomName02 = null;
        }
        try {
            strRoomName03 = jTFRoomID03.getText();
        } catch (Exception ex) {
            strRoomName03 = null;
        }
        try {
            strRoomName04 = jTFRoomID04.getText();
        } catch (Exception ex) {
            strRoomName04 = null;
        }
        try {
            strRoomName05 = jTFRoomID05.getText();
        } catch (Exception ex) {
            strRoomName05 = null;
        }
        try {
            strRoomName06 = jTFRoomID06.getText();
        } catch (Exception ex) {
            strRoomName06 = null;
        }
        try {
            strRoomName07 = jTFRoomID07.getText();
        } catch (Exception ex) {
            strRoomName07 = null;
        }
        try {
            strRoomName08 = jTFRoomID08.getText();
        } catch (Exception ex) {
            strRoomName08 = null;
        }

        //----------------------------------------------------------------------- 散客登记管理||团体登记管理
        if (MainFrame.strGuestStyle.equals("SN") ||
            MainFrame.strGuestStyle.equals("TN")) { //散客登记管理||团体登记管理
            try {
                connect1 = new DataConnect();
                connect2 = new DataConnect();
                connect1.con1 = DriverManager.getConnection(connect1.url); //建立连接
                connect2.con2 = DriverManager.getConnection(connect2.url); //建立连接

                connect1.stmt1 = connect1.con1.createStatement(); //创建语句
                connect2.stmt2 = connect2.con2.createStatement(); //创建语句

                connect1.sql1 =
                        " Update HIMS_Register_CheckInRoom Set RoomName01 =  '" +
                        strRoomName01
                        + "',RoomName02 = '" + strRoomName02 +
                        "',RoomName03 = '" + strRoomName03
                        + "',RoomName04 = '" + strRoomName04 +
                        "',RoomName05 = '" + strRoomName05 +
                        "' ,RoomName06 = '" + strRoomName06 +
                        "',RoomName07 = '" + strRoomName07 + "',RoomName08 = '" +
                        strRoomName08 +
                        "'  where RegRoomID =  '" + guestreg.RegisterID + "'";

                connect2.sql2 =
                        " UPDATE  HIMS_RoomState SET  OnUser = '1' , Reason  = '此房间有客人入住！！' where RoomID = '" +
                        strRoomName01 + "' or RoomID = '" +
                        strRoomName02
                        + "' or RoomID = '" + strRoomName03 +
                        "' or RoomID = '" + strRoomName04 +
                        "' or RoomID = '" + strRoomName05 +
                        "' or RoomID = '" + strRoomName02
                        + "' or RoomID = '" + strRoomName06 +
                        "' or RoomID = '" + strRoomName07 +
                        "' or RoomID = '" + strRoomName08 + "'";
                connect1.stmt1.executeUpdate(connect1.sql1);
                connect2.stmt2.executeUpdate(connect2.sql2);

//---------------------------------------------------------------------------------------散客预约管理||团体预约管理

            } catch (SQLException ex) {
                ex.printStackTrace();
            } finally {
                try {
                    if (connect1.con1 != null && connect2.con2 != null) {
                        connect1.con1.close(); //关闭数据库
                        connect2.con2.close(); //关闭数据库
                        connect1.stmt1.close();
                        connect2.stmt2.close();
                        JOptionPane.showMessageDialog(null, "操作成功！",
                                "酒店信息管理系统提示",
                                JOptionPane.WARNING_MESSAGE);

                        this.setVisible(false);

                    } //if
                } catch (SQLException ex) {
                    System.out.println(ex);
                } //catch
            } //finally
        }
        //-----------------------------------------------------------------
        else if (MainFrame.strGuestStyle.equals("SF") ||
                 MainFrame.strGuestStyle.equals("TF")) {
            try {
                connect1 = new DataConnect();
                connect2 = new DataConnect();
                connect1.con1 = DriverManager.getConnection(connect1.url); //建立连接
                connect2.con2 = DriverManager.getConnection(connect2.url); //建立连接

                connect1.stmt1 = connect1.con1.createStatement(); //创建语句
                connect2.stmt2 = connect2.con2.createStatement(); //创建语句

                connect1.sql1 =
                        " Update HIMS_Register_CheckInRoom Set RoomName01 =  '" +
                        strRoomName01
                        + "',RoomName02 = '" + strRoomName02 +
                        "',RoomName03 = '" + strRoomName03
                        + "',RoomName04 = '" + strRoomName04 +
                        "',RoomName05 = '" + strRoomName05 +
                        "' ,RoomName06 = '" + strRoomName06 +
                        "',RoomName07 = '" + strRoomName07 + "',RoomName08 = '" +
                        strRoomName08 + "'  where RegRoomID =  '" +
                        guestreg.RegisterID + "'";

                connect2.sql2 = " UPDATE  HIMS_RoomState SET  OnUser = '3' , Reason  = '此房间以预定！！' where RoomID = '" +
                                strRoomName01 + "' or RoomID = '" +
                                strRoomName02
                                + "' or RoomID = '" + strRoomName03 +
                                "' or RoomID = '" + strRoomName04 +
                                "' or RoomID = '" + strRoomName05 +
                                "' or RoomID = '" + strRoomName02
                                + "' or RoomID = '" + strRoomName06 +
                                "' or RoomID = '" + strRoomName07 +
                                "' or RoomID = '" + strRoomName08 + "'";

                connect1.stmt1.executeUpdate(connect1.sql1);
                connect2.stmt2.executeUpdate(connect2.sql2);

//-----------------------------------------------------------------------------------------------------
            } catch (SQLException ex) {
                ex.printStackTrace();
            } finally {
                try {
                    if (connect1.con1 != null && connect2.con2 != null) {
                        connect1.con1.close(); //关闭数据库
                        connect2.con2.close(); //关闭数据库
                        connect1.stmt1.close();
                        connect2.stmt2.close();
                        JOptionPane.showMessageDialog(null, "操作成功！",
                                "酒店信息管理系统提示",
                                JOptionPane.WARNING_MESSAGE);
                        this.setVisible(false);

                    } //if
                } catch (SQLException ex) {
                    System.out.println(ex);
                } //catch
            } //finally
        }
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        RoomManagement.FreeRoomQuery freeroomquery = new RoomManagement.
                FreeRoomQuery();
        freeroomquery.setVisible(true);
    }

    public void jBChange_actionPerformed(ActionEvent e) {
        ChangeRoom changeroom = new ChangeRoom();
        changeroom.setVisible(true);
        jBChange.setVisible(false);
        jBPush.setEnabled(true);
    }
}


class GuestChechInRoom_jBChange_actionAdapter implements ActionListener {
    private GuestChechInRoom adaptee;
    GuestChechInRoom_jBChange_actionAdapter(GuestChechInRoom adaptee) {
        this.adaptee = adaptee;
    }

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


class GuestChechInRoom_jButton1_actionAdapter implements ActionListener {
    private GuestChechInRoom adaptee;
    GuestChechInRoom_jButton1_actionAdapter(GuestChechInRoom adaptee) {
        this.adaptee = adaptee;
    }

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


class GuestChechInRoom_jButton3_actionAdapter implements ActionListener {
    private GuestChechInRoom adaptee;
    GuestChechInRoom_jButton3_actionAdapter(GuestChechInRoom adaptee) {
        this.adaptee = adaptee;
    }

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