denglu.frm

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

VERSION 5.00
Begin VB.Form denglu 
   Appearance      =   0  'Flat
   BackColor       =   &H80000005&
   Caption         =   "欢迎您进入酒店管理系统"
   ClientHeight    =   5385
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   8220
   Icon            =   "denglu.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   5385
   ScaleWidth      =   8220
   StartUpPosition =   3  '窗口缺省
   Begin VB.Frame Frame1 
      BackColor       =   &H80000018&
      Caption         =   "请在这里输入登陆信息"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   14.25
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   6375
      Left            =   0
      TabIndex        =   0
      Top             =   0
      Width           =   8895
      Begin VB.CommandButton Command2 
         Caption         =   "取消"
         BeginProperty Font 
            Name            =   "仿宋_GB2312"
            Size            =   15
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   495
         Left            =   4680
         TabIndex        =   6
         Top             =   3720
         Width           =   1455
      End
      Begin VB.CommandButton Command1 
         BackColor       =   &H000000FF&
         Caption         =   "登录"
         Default         =   -1  'True
         BeginProperty Font 
            Name            =   "仿宋_GB2312"
            Size            =   15
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   495
         Left            =   2400
         TabIndex        =   5
         Top             =   3720
         Width           =   1215
      End
      Begin VB.TextBox Text2 
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   14.25
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   525
         IMEMode         =   3  'DISABLE
         Left            =   3960
         PasswordChar    =   "*"
         TabIndex        =   4
         Top             =   2640
         Width           =   2295
      End
      Begin VB.TextBox Text1 
         BackColor       =   &H80000009&
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   14.25
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   525
         Left            =   3960
         MousePointer    =   1  'Arrow
         TabIndex        =   2
         Top             =   1920
         Width           =   2295
      End
      Begin VB.Image Image1 
         Height          =   1770
         Left            =   0
         Picture         =   "denglu.frx":038A
         Top             =   -120
         Width           =   8250
      End
      Begin VB.Label Label4 
         BackStyle       =   0  'Transparent
         Caption         =   "<hui>◎copyright"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   14.25
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H000000FF&
         Height          =   615
         Left            =   2760
         TabIndex        =   7
         Top             =   4680
         Width           =   4095
      End
      Begin VB.Label Label2 
         BackStyle       =   0  'Transparent
         Caption         =   "密码:"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   15.75
            Charset         =   134
            Weight          =   700
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H000000C0&
         Height          =   495
         Left            =   2160
         TabIndex        =   3
         Top             =   2640
         Width           =   975
      End
      Begin VB.Label Label1 
         BackStyle       =   0  'Transparent
         Caption         =   "用户名:"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   15.75
            Charset         =   134
            Weight          =   700
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H000000FF&
         Height          =   375
         Left            =   2040
         TabIndex        =   1
         Top             =   1920
         Width           =   1215
         WordWrap        =   -1  'True
      End
   End
End
Attribute VB_Name = "denglu"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim db As Database
Dim rs As Recordset
Private Sub Command1_Click()
Dim db As Database
Dim rs As Recordset
 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

caidan.Show
denglu.Hide
End If
rs.Close
Else
n = MsgBox("对不起,您不能进入!", vbExclamation)
End If
End Sub

Private Sub Command2_Click()
Dim anw As Integer
anw = MsgBox("确定要退出系统吗？", vbYesNo, "请问")
If anw = 6 Then
    Unload Me
Else
    Text1.Text = ""
    Text2.Text = ""
    Text1.SetFocus
End If
End Sub




Private Sub Image2_Click()

End Sub