guestsettleaccounts.java~93~

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

                                            strRoomName06 + " " +
                                            strRoomName07 +
                                            " " + strRoomName08);
                        if (strSystemDate.compareTo(QuitDate) < 0) {
                            int inChoose = JOptionPane.showConfirmDialog(null,
                                    "您与要离店的日期还有一段时间，真的要结账吗？！",
                                    "酒店信息管理系统提示", JOptionPane.YES_NO_OPTION);
                            if (inChoose == 0) { //choose为0时，用户选则“是”
                                int iNum = strSystemDate.compareTo(
                                        String.valueOf(daCheckInDate).toString());
                                jTFCHODay.setText(String.valueOf(iNum).
                                                  toString());
                                connect2 = new DataConnect();
                                connect3 = new DataConnect();
                                connect4 = new DataConnect();
                                connect2.con2 = DriverManager.getConnection(
                                        connect2.url); //建立连接
                                connect3.con3 = DriverManager.getConnection(
                                        connect3.url); //建立连接
                                connect4.con4 = DriverManager.getConnection(
                                        connect4.url); //建立连接
                                connect2.stmt2 = connect2.con2.createStatement(); //创建语句
                                connect3.stmt3 = connect3.con3.createStatement(); //创建语句
                                connect4.stmt4 = connect4.con4.createStatement(); //创建语句
                                connect2.sql2 =
                                        " UPDATE  HIMS_Register_Account SET AccountID = '" +
                                        strID +
                                        "' , Reckoning= '" + flSum +
                                        "', DutyID= '" + ReturnPopedom.strEmpID +
                                        "' Where AccountID = '" + strID + "'";
                                connect3.sql3 =
                                        " UPDATE  HIMS_Register SET CheckInType = 'Q ' Where RegisterID = '" +
                                        strID + "'";
                                connect4.sql4 =
                                        " UPDATE  HIMS_RoomState SET  OnUser = '2' , 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 + "'";

                                connect2.stmt2.executeUpdate(connect2.sql2);
                                connect3.stmt3.executeUpdate(connect3.sql3);
                                connect4.stmt4.executeUpdate(connect4.sql4);

                            }
                            return;
                        }
                        return;
                    } else if (strCheckInTypes.equals("F")) {
                        JOptionPane.showMessageDialog(null, "您所查找的是预约帐单！",
                                "酒店信息管理系统提示",
                                JOptionPane.YES_NO_OPTION);
                        return;
                    }
                }
            } //while

            JOptionPane.showMessageDialog(null, "您所查找的内容不在库中！",
                                          "酒店信息管理系统提示",
                                          JOptionPane.WARNING_MESSAGE);
            jTFCompany.setText("");
            //-----------------------------------------------------------------------------------------------------------

        } catch (SQLException ex) {
            ex.printStackTrace();
        } finally {
            try {
                if (connect1.con1 != null && connect2.con2 != null &&
                    connect3.con3 != null && connect4.con4 != null) {
                    connect1.con1.close(); //关闭数据库admin
                    connect2.con2.close(); //关闭数据库admin
                    connect3.con3.close(); //关闭数据库admin
                    connect4.con4.close(); //关闭数据库admin
                    connect1.stmt1.close();
                    connect2.stmt2.close();
                    connect3.stmt3.close();
                    connect4.stmt4.close();

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

    public void jBSettlement_actionPerformed(ActionEvent e) { //结算
        String strBuffMo = jTFReceive.getText(); //收取的金额
        if (!judgeval.isFigureWhitPoint(strBuffMo)) {
            JOptionPane.showMessageDialog(null,
                                          "金额必须是数字或格式不标准，请重新输入！",
                                          "酒店信息管理系统警告",
                                          JOptionPane.WARNING_MESSAGE);
            jTFReceive.setText("");
            return;
        }
        if (strBuffMo.equals("")) {
            JOptionPane.showMessageDialog(null,
                                          "金额不能为空，请重新输入！",
                                          "酒店信息管理系统警告",
                                          JOptionPane.WARNING_MESSAGE);
            jTFReceive.setText("");
            return;
        }
        if (strFlag.equals("F")) {
            float flSetNum = Float.valueOf(strBuffMo) + flGiveyou;
            if (flSetNum > 0) {
                jLSumShow.setText("应找付给客人" + String.valueOf(flSetNum));
                jBSettlement.setEnabled(false);
                jBReSet.setEnabled(true);
            } else if (flSetNum < 0) {
                JOptionPane.showMessageDialog(null,
                                              "金额不够，请重新输入！",
                                              "酒店信息管理系统警告",
                                              JOptionPane.WARNING_MESSAGE);
                jLSumShow.setText("客户应付" + String.valueOf(flGiveyou).toString());
                jTFReceive.setText("");
            } else {
                jLSumShow.setText("谢谢下次光临!!");
                jBSettlement.setEnabled(false);
                jBReSet.setEnabled(true);
            }
        }

    }

    public void jBReSet_actionPerformed(ActionEvent e) {
        jRBGroupSettleAccounts.setSelected(false);
        jRBGuestSettleAccounts.setSelected(false);
        jTFAccounts.setText("");
        jBQueryAccounts.setEnabled(true);
        jTFReceive.setText("");
        jTFCompany.setText("");
        jTFName.setText("");
        jLSumShow.setText("");
        jBAddRoom.setEnabled(false);
        jBShowRoomInfo.setEnabled(false);
        jTFDeposit.setText("");
        jTFCHODay.setText("");
        jTFRoomNum.setText("");
        jTARoomName.setText("");
        jBReSet.setEnabled(false);
        jTFReceive.setEnabled(false);
    }

}


class GuestSettleAccounts_jBReSet_actionAdapter implements ActionListener {
    private GuestSettleAccounts adaptee;
    GuestSettleAccounts_jBReSet_actionAdapter(GuestSettleAccounts adaptee) {
        this.adaptee = adaptee;
    }

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


class GuestSettleAccounts_jBSettlement_actionAdapter implements
        ActionListener {
    private GuestSettleAccounts adaptee;
    GuestSettleAccounts_jBSettlement_actionAdapter(GuestSettleAccounts
            adaptee) {
        this.adaptee = adaptee;
    }

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


class GuestSettleAccounts_jBQueryAccounts_actionAdapter implements
        ActionListener {
    private GuestSettleAccounts adaptee;
    GuestSettleAccounts_jBQueryAccounts_actionAdapter(GuestSettleAccounts
            adaptee) {
        this.adaptee = adaptee;
    }

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


class GuestSettleAccounts_jBAddRoom_actionAdapter implements ActionListener {
    private GuestSettleAccounts adaptee;
    GuestSettleAccounts_jBAddRoom_actionAdapter(GuestSettleAccounts adaptee) {
        this.adaptee = adaptee;
    }

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


class GuestSettleAccounts_jBShowRoomInfo_actionAdapter implements
        ActionListener {
    private GuestSettleAccounts adaptee;
    GuestSettleAccounts_jBShowRoomInfo_actionAdapter(GuestSettleAccounts
            adaptee) {
        this.adaptee = adaptee;
    }

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


class GuestSettleAccounts_jBQuit_actionAdapter implements ActionListener {
    private GuestSettleAccounts adaptee;
    GuestSettleAccounts_jBQuit_actionAdapter(GuestSettleAccounts adaptee) {
        this.adaptee = adaptee;
    }

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