⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 frmpayfroomedit.frm

📁 酒店管理系统 基于VB和SQL的一个很好的程序 可以实现酒店的日常管理工作
💻 FRM
字号:
VERSION 5.00
Begin VB.Form FrmPayFRoomEdit 
   Caption         =   "编辑结款信息"
   ClientHeight    =   3675
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   10320
   Icon            =   "FrmPayFRoomEdit.frx":0000
   LinkTopic       =   "Form1"
   ScaleHeight     =   3675
   ScaleWidth      =   10320
   StartUpPosition =   2  '屏幕中心
   Begin VB.Frame Frame2 
      Caption         =   "客户信息"
      Height          =   855
      Left            =   120
      TabIndex        =   14
      Top             =   120
      Width           =   10095
      Begin VB.Label Label15 
         AutoSize        =   -1  'True
         Caption         =   "编 号:"
         Height          =   180
         Left            =   240
         TabIndex        =   18
         Top             =   360
         Width           =   540
      End
      Begin VB.Label Label11 
         AutoSize        =   -1  'True
         Caption         =   "姓 名:"
         Height          =   180
         Left            =   3360
         TabIndex        =   17
         Top             =   360
         Width           =   540
      End
      Begin VB.Label lblCname 
         AutoSize        =   -1  'True
         Caption         =   "lblCname"
         Height          =   180
         Left            =   4080
         TabIndex        =   16
         Top             =   360
         Width           =   720
      End
      Begin VB.Label lblCid 
         AutoSize        =   -1  'True
         Caption         =   "lblCid"
         Height          =   180
         Left            =   960
         TabIndex        =   15
         Top             =   360
         Width           =   540
      End
   End
   Begin VB.Frame Frame3 
      Caption         =   "预定信息"
      Height          =   1695
      Left            =   120
      TabIndex        =   2
      Top             =   1080
      Width           =   10095
      Begin VB.Label lblPay 
         AutoSize        =   -1  'True
         Caption         =   "lblPay"
         Height          =   180
         Left            =   3600
         TabIndex        =   29
         Top             =   1320
         Width           =   540
      End
      Begin VB.Label Label10 
         AutoSize        =   -1  'True
         Caption         =   "应收款(元)"
         Height          =   180
         Left            =   2400
         TabIndex        =   28
         Top             =   1320
         Width           =   1080
      End
      Begin VB.Label lblFirstPay 
         AutoSize        =   -1  'True
         Caption         =   "lblFirstPay"
         Height          =   180
         Left            =   1200
         TabIndex        =   27
         Top             =   1320
         Width           =   990
      End
      Begin VB.Label lblOtherFee 
         AutoSize        =   -1  'True
         Caption         =   "lblOtherFee"
         Height          =   180
         Left            =   6360
         TabIndex        =   26
         Top             =   840
         Width           =   990
      End
      Begin VB.Label lblRate 
         AutoSize        =   -1  'True
         Caption         =   "lblRate"
         Height          =   180
         Left            =   3600
         TabIndex        =   25
         Top             =   840
         Width           =   630
      End
      Begin VB.Label lblPrice 
         AutoSize        =   -1  'True
         Caption         =   "lblPrice"
         Height          =   180
         Left            =   1200
         TabIndex        =   24
         Top             =   840
         Width           =   720
      End
      Begin VB.Label lblLeaveDate 
         AutoSize        =   -1  'True
         Caption         =   "lblLeaveDate"
         Height          =   180
         Left            =   8760
         TabIndex        =   23
         Top             =   405
         Width           =   1080
      End
      Begin VB.Label lblDays 
         AutoSize        =   -1  'True
         Caption         =   "lblDays"
         Height          =   180
         Left            =   6360
         TabIndex        =   22
         Top             =   360
         Width           =   630
      End
      Begin VB.Label lblInDate 
         AutoSize        =   -1  'True
         Caption         =   "lblInDate"
         Height          =   180
         Left            =   3600
         TabIndex        =   21
         Top             =   360
         Width           =   810
      End
      Begin VB.Label Label18 
         AutoSize        =   -1  'True
         Caption         =   "总费用(元)"
         Height          =   180
         Left            =   4920
         TabIndex        =   13
         Top             =   1335
         Width           =   1080
      End
      Begin VB.Label lblTotal 
         Alignment       =   1  'Right Justify
         AutoSize        =   -1  'True
         Caption         =   "0"
         Height          =   180
         Left            =   7080
         TabIndex        =   12
         Top             =   1335
         Width           =   90
      End
      Begin VB.Label Label16 
         AutoSize        =   -1  'True
         Caption         =   "其他费用(元)"
         Height          =   180
         Left            =   4920
         TabIndex        =   11
         Top             =   840
         Width           =   1260
      End
      Begin VB.Label Label14 
         AutoSize        =   -1  'True
         Caption         =   "折扣(%)"
         Height          =   180
         Left            =   2400
         TabIndex        =   10
         Top             =   855
         Width           =   810
      End
      Begin VB.Label Label13 
         AutoSize        =   -1  'True
         Caption         =   "入住天数"
         Height          =   180
         Left            =   4920
         TabIndex        =   9
         Top             =   360
         Width           =   720
      End
      Begin VB.Label Label7 
         AutoSize        =   -1  'True
         Caption         =   "报价(元)"
         Height          =   180
         Left            =   240
         TabIndex        =   8
         Top             =   855
         Width           =   900
      End
      Begin VB.Label lblRoomNo 
         AutoSize        =   -1  'True
         Caption         =   "lblRoomNo"
         Height          =   180
         Left            =   1200
         TabIndex        =   7
         Top             =   360
         Width           =   810
      End
      Begin VB.Label Label5 
         AutoSize        =   -1  'True
         Caption         =   "入住日期"
         Height          =   180
         Left            =   2400
         TabIndex        =   6
         Top             =   360
         Width           =   720
      End
      Begin VB.Label Label8 
         AutoSize        =   -1  'True
         Caption         =   "客房编号:"
         Height          =   180
         Left            =   240
         TabIndex        =   5
         Top             =   360
         Width           =   810
      End
      Begin VB.Label Label6 
         AutoSize        =   -1  'True
         Caption         =   "退房日期"
         Height          =   180
         Left            =   7560
         TabIndex        =   4
         Top             =   405
         Width           =   720
      End
      Begin VB.Label Label9 
         AutoSize        =   -1  'True
         Caption         =   "押金(元)"
         Height          =   180
         Left            =   240
         TabIndex        =   3
         Top             =   1320
         Width           =   900
      End
   End
   Begin VB.CommandButton Cmd_Close 
      Caption         =   "关 闭"
      Height          =   495
      Left            =   9120
      TabIndex        =   1
      Top             =   3000
      Width           =   1095
   End
   Begin VB.CommandButton Cmd_Pay 
      Caption         =   "结 款"
      Height          =   495
      Left            =   7560
      TabIndex        =   0
      Top             =   3000
      Width           =   1095
   End
   Begin VB.Label Label19 
      AutoSize        =   -1  'True
      Caption         =   "收款日期"
      Height          =   180
      Left            =   3120
      TabIndex        =   31
      Top             =   3157
      Width           =   720
   End
   Begin VB.Label lblOptDate 
      AutoSize        =   -1  'True
      Caption         =   "lblOptDate"
      Height          =   180
      Left            =   4080
      TabIndex        =   30
      Top             =   3157
      Width           =   900
   End
   Begin VB.Label lblEmpName 
      AutoSize        =   -1  'True
      Caption         =   "lblEmpName"
      Height          =   180
      Left            =   1200
      TabIndex        =   20
      Top             =   3157
      Width           =   900
   End
   Begin VB.Label Label17 
      AutoSize        =   -1  'True
      Caption         =   "操作人员"
      Height          =   180
      Left            =   240
      TabIndex        =   19
      Top             =   3157
      Width           =   720
   End
End
Attribute VB_Name = "FrmPayFRoomEdit"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public TmpRid As Integer  '编号

Private Sub Cmd_Close_Click()
  Unload Me
End Sub

Private Sub Cmd_Pay_Click()
  Dim TmpRNo As String
  '添加结款记录
  With MyPayFRoom
  .RegId = TmpRid
  .Amount = Val(lblTotal)
  .OptTime = lblOptDate
  .UserName = CurUser.UserName
  .Insert
  End With
  '更改入住登记记录状态值为3(已结款)
  MyReg.Status = 3
  MyReg.UpdateStatus (TmpRid)
  '读取房间编号
  MyReg.GetInfo (TmpRid)
  TmpRNo = MyReg.RoomNo
  '更改房间状态
  MyRoom.Status = 0
  MyRoom.UpdateStatus (TmpRNo)
  Unload Me
End Sub

Private Sub Form_Load()
  lblEmpName = CurUser.EmpName
  lblOptDate = Date
End Sub

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -