frmclientcost.frm

一个简单的客房管理数据库系统

VERSION 5.00
Begin VB.Form frmClientCost 
   Caption         =   "客人费用查询"
   ClientHeight    =   5040
   ClientLeft      =   60
   ClientTop       =   465
   ClientWidth     =   4485
   Icon            =   "frmClientCost.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   MinButton       =   0   'False
   ScaleHeight     =   5040
   ScaleWidth      =   4485
   Begin VB.TextBox txtcBalance 
      DataField       =   "cBalance"
      DataMember      =   "ClientCost"
      DataSource      =   "dbe"
      Height          =   270
      Left            =   1800
      TabIndex        =   14
      Top             =   3960
      Width           =   1215
   End
   Begin VB.TextBox txtcCCost 
      DataField       =   "cCost"
      DataMember      =   "ClientCost"
      DataSource      =   "dbe"
      Height          =   270
      Left            =   1800
      TabIndex        =   13
      Top             =   3480
      Width           =   1215
   End
   Begin VB.TextBox txtcDays 
      DataField       =   "cDays"
      DataMember      =   "ClientCost"
      DataSource      =   "dbe"
      Height          =   270
      Left            =   1800
      TabIndex        =   12
      Top             =   3000
      Width           =   375
   End
   Begin VB.TextBox txtcRoomPrice 
      DataField       =   "cRoomPrice"
      DataMember      =   "ClientCost"
      DataSource      =   "dbe"
      Height          =   270
      Left            =   1800
      TabIndex        =   11
      Top             =   2520
      Width           =   1215
   End
   Begin VB.TextBox txtcDeposit 
      DataField       =   "cDeposit"
      DataMember      =   "ClientCost"
      DataSource      =   "dbe"
      Height          =   270
      Left            =   1800
      TabIndex        =   10
      Top             =   2040
      Width           =   1215
   End
   Begin VB.CommandButton Command1 
      Caption         =   "查询"
      Height          =   495
      Left            =   2760
      TabIndex        =   2
      Top             =   720
      Width           =   855
   End
   Begin VB.TextBox Text1 
      Height          =   375
      Left            =   840
      TabIndex        =   1
      Top             =   720
      Width           =   1215
   End
   Begin VB.Label lblFieldLable 
      Caption         =   "    差额："
      Height          =   255
      Index           =   0
      Left            =   480
      TabIndex        =   9
      Top             =   3960
      Width           =   975
   End
   Begin VB.Label lblFieldLable 
      Caption         =   "  住宿费："
      Height          =   255
      Index           =   4
      Left            =   480
      TabIndex        =   8
      Top             =   3480
      Width           =   975
   End
   Begin VB.Label lblFieldLable 
      Caption         =   "入住天数："
      Height          =   255
      Index           =   3
      Left            =   480
      TabIndex        =   7
      Top             =   3000
      Width           =   975
   End
   Begin VB.Label lblFieldLable 
      Caption         =   "客房价格："
      Height          =   255
      Index           =   2
      Left            =   480
      TabIndex        =   6
      Top             =   2520
      Width           =   975
   End
   Begin VB.Label lblFieldLable 
      Caption         =   "押金金额："
      Height          =   255
      Index           =   1
      Left            =   480
      TabIndex        =   5
      Top             =   2040
      Width           =   975
   End
   Begin VB.Label lblRoomNum 
      Height          =   255
      Left            =   2520
      TabIndex        =   4
      Top             =   1440
      Width           =   975
   End
   Begin VB.Label lblClientName 
      Height          =   255
      Left            =   600
      TabIndex        =   3
      Top             =   1440
      Width           =   1335
   End
   Begin VB.Label Label1 
      Caption         =   "请输入客人序号，查询客人住宿费用情况。"
      Height          =   255
      Left            =   480
      TabIndex        =   0
      Top             =   240
      Width           =   3495
   End
End
Attribute VB_Name = "frmClientCost"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public Sub CheckCost()
dbe.Commands("Command1").CommandText = "Select cName,rNum from" & "tblClient where cId='" & Text1.Text & "'"
If dbe.rsCommand1.State Then
dbe.rsCommand1.Close
End If
dbe.Command1
If dbe.rsCommand1.EOF Then
lblClientName.Caption = "没有该记录！"
lblRoomNum.Caption = ""
Else
lblClientName.Caption = dbe.rsCommand1.Fields("cName").Value
lblRoomNum.Caption = dbe.rsCommand1.Fields("rNum").Value & "房间"
End If


Dim myde As New dbe
If myde.rsClientCost.State Then
myde.rsClientCost.Close
End If
myde.ClientCost (Text1.Text)
If Not myde.rsClientCost.BOF Then
myde.rsClientCost.MoveFirst
Set txtcDeposit.DataSource = myde
Set txtcCCost.DataSource = myde
Set txtcDays.DataSource = myde
Set txtcBalance.DataSource = myde
Set txtcRoomPrice.DataSource = myde
End If
End Sub

Private Sub Command1_Click()
Call CheckCost
End Sub