frmtuifang.frm

simple hotel management system

VERSION 5.00
Begin VB.Form frmtuifang 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "退房结算"
   ClientHeight    =   1380
   ClientLeft      =   2100
   ClientTop       =   2865
   ClientWidth     =   3735
   Icon            =   "frmtuifang.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   1380
   ScaleWidth      =   3735
   ShowInTaskbar   =   0   'False
   Begin VB.CommandButton cmdquxiao 
      Caption         =   "取消"
      Height          =   375
      Left            =   2760
      TabIndex        =   3
      Top             =   840
      Width           =   735
   End
   Begin VB.CommandButton cmdqueding 
      Caption         =   "确定"
      Height          =   375
      Left            =   1680
      TabIndex        =   2
      Top             =   840
      Width           =   735
   End
   Begin VB.TextBox Txtfangjianhao 
      Height          =   375
      Left            =   1680
      TabIndex        =   1
      Top             =   240
      Width           =   1695
   End
   Begin VB.Label lblfangjianhao 
      Caption         =   "客户编号"
      Height          =   495
      Left            =   240
      TabIndex        =   0
      Top             =   240
      Width           =   1095
   End
End
Attribute VB_Name = "frmtuifang"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdqueding_Click()
    Dim chaxun As String
    Dim ca As String
    Dim riqi As String
    Dim days As String
    Dim jiage As String
    If Txtfangjianhao <> Empty Then
    chaxun = "select * from kehudengji where kehuid=" & Txtfangjianhao
       If querydata(chaxun) = True Then
    rct.MoveFirst
    riqi = rct.Fields("ruzhuriqi").Value
    
    days = DateDiff("d", riqi, Now)
    End If
    ca = "select * from fangjianbiao"
        If querydata(ca) = True Then
    rct.MoveFirst
    jiage = rct.Fields("fangjianjiage").Value
    MsgBox "共住" & (days + 1) & "天" & (days + 1) * jiage & "元"
    End If
    Else
        MsgBox "你输入无效"
    End If
End Sub

Private Sub cmdquxiao_Click()
    Unload Me
End Sub