mima.frm

宾馆在正常的运营中需要对客房资源、顾客信息、结算信息进行管理

VERSION 5.00
Begin VB.Form mima 
   Caption         =   "进入酒店内部资料"
   ClientHeight    =   3195
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   4680
   Icon            =   "mima.frx":0000
   LinkTopic       =   "Form1"
   ScaleHeight     =   3195
   ScaleWidth      =   4680
   StartUpPosition =   3  '窗口缺省
   Begin VB.Frame Frame1 
      Caption         =   "经理级以上人员才可进入"
      Height          =   3135
      Left            =   0
      TabIndex        =   0
      Top             =   0
      Width           =   4695
      Begin VB.CommandButton Command2 
         Caption         =   "取消"
         BeginProperty Font 
            Name            =   "楷体_GB2312"
            Size            =   12
            Charset         =   134
            Weight          =   700
            Underline       =   0   'False
            Italic          =   -1  'True
            Strikethrough   =   0   'False
         EndProperty
         Height          =   495
         Left            =   2520
         TabIndex        =   6
         Top             =   2160
         Width           =   1095
      End
      Begin VB.CommandButton Command1 
         Caption         =   "进入"
         Default         =   -1  'True
         BeginProperty Font 
            Name            =   "楷体_GB2312"
            Size            =   12
            Charset         =   134
            Weight          =   700
            Underline       =   0   'False
            Italic          =   -1  'True
            Strikethrough   =   0   'False
         EndProperty
         Height          =   495
         Left            =   600
         TabIndex        =   5
         Top             =   2160
         Width           =   1095
      End
      Begin VB.TextBox Text2 
         Height          =   375
         IMEMode         =   3  'DISABLE
         Left            =   1320
         PasswordChar    =   "*"
         TabIndex        =   4
         Top             =   1440
         Width           =   2535
      End
      Begin VB.TextBox Text1 
         Height          =   375
         Left            =   1320
         TabIndex        =   2
         Top             =   480
         Width           =   2535
      End
      Begin VB.Label Label2 
         Caption         =   "密码:"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   14.25
            Charset         =   134
            Weight          =   700
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   480
         TabIndex        =   3
         Top             =   1440
         Width           =   855
      End
      Begin VB.Label Label1 
         Caption         =   "ID:"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   15.75
            Charset         =   134
            Weight          =   700
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   720
         TabIndex        =   1
         Top             =   480
         Width           =   495
      End
   End
End
Attribute VB_Name = "mima"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Dim db As Database
Dim rs As Recordset
Text1.SetFocus
Set db = OpenDatabase(App.Path & "\登陆信息表.mdb", True, False)
Set rs = db.OpenRecordset("登陆信息表")
If Text1.Text <> "" Then
Set rs = db.OpenRecordset("select 帐号,密码 from 登陆信息表 where 帐号='" & Text1.Text & "'and 密码='" & Text2.Text & "'")
If rs.EOF = True And rs.BOF = True Then
n = MsgBox("密码错误,请重新输入!", vbExclamation)
Text2.Text = ""
Text2.SetFocus
Else
MsgBox ("欢迎进入酒店内部资料菜单!")
jiudianneibuziliaocaidan.Show
mima.Hide
End If
rs.Close
Else
n = MsgBox("对不起,您不能进入!", vbExclamation)
End If
Text1.Text = ""
Text2.Text = ""
End Sub

Private Sub Command2_Click()
mima.Hide
caidan.Show
End Sub