frmlogin.frm

针对于订房中心的酒店合同管理。管理权限有管理员和业务员等。

VERSION 5.00
Begin VB.Form frmlogin 
   BorderStyle     =   0  'None
   Caption         =   "Form1"
   ClientHeight    =   2565
   ClientLeft      =   0
   ClientTop       =   0
   ClientWidth     =   4755
   LinkTopic       =   "Form1"
   Picture         =   "frmlogin.frx":0000
   ScaleHeight     =   2565
   ScaleWidth      =   4755
   ShowInTaskbar   =   0   'False
   StartUpPosition =   2  '屏幕中心
   Begin VB.TextBox TxtPasswd 
      Height          =   390
      IMEMode         =   3  'DISABLE
      Left            =   2400
      PasswordChar    =   "*"
      TabIndex        =   1
      Top             =   1440
      Width           =   1935
   End
   Begin VB.TextBox TxtUserName 
      Height          =   390
      Left            =   2400
      TabIndex        =   0
      Top             =   960
      Width           =   1935
   End
   Begin VB.Label CmdHelp 
      BackStyle       =   0  'Transparent
      Height          =   495
      Left            =   3000
      TabIndex        =   4
      Top             =   1920
      Width           =   975
   End
   Begin VB.Label CmdCancel 
      BackStyle       =   0  'Transparent
      Height          =   495
      Left            =   1920
      TabIndex        =   3
      Top             =   1920
      Width           =   855
   End
   Begin VB.Label CmdOK 
      BackStyle       =   0  'Transparent
      Height          =   495
      Left            =   840
      TabIndex        =   2
      Top             =   1920
      Width           =   855
   End
End
Attribute VB_Name = "frmlogin"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim cnt As Integer '记录确定次数

Private Sub CmdCancel_Click()
Unload Me
End
End Sub

Private Sub CmdHelp_Click()
Load FrmHelp
FrmHelp.Show vbModal
End Sub

Private Sub cmdOK_Click()
Dim sql As String
Dim rs_login As New ADODB.Recordset
Dim conn As New ADODB.Connection
Dim strShenFen As String
'Static intLoginTimes As Integer
conn.Open "provider=Microsoft.Jet.OLEDB.4.0; data source=" & App.Path & "\database\yh8888.mdb"


   
 If Trim(TxtUserName.Text) = "" Then
   MsgBox "用户名不能为空，请重新输入！"
   TxtUserName.SetFocus
 Else
   sql = "select * from admin where 用户ID='" & Trim(TxtUserName.Text) & "'"
   rs_login.Open sql, conn, adOpenKeyset, adLockPessimistic
   If rs_login.EOF = True Then
   
     MsgBox "没有这个用户,请重输入！", vbOKOnly + vbExclamation, ""
     TxtUserName.Text = ""
     TxtUserName.SetFocus
   Else
     username = TxtUserName.Text
     If Trim(rs_login.Fields(2)) = Trim(TxtPasswd.Text) Then
       'strShenFen = Adoadmin.Recordset!用户身份
        Unload Me
        If Trim(rs_login.Fields(3)) = "管理员" Then
        frmMDI.Show
        ElseIf Trim(rs_login.Fields(3)) = "业务员" Then
        FrmMian.Show
        
   Else
       MsgBox "密码不正确,请重输入！", vbOKOnly + vbExclamation, ""
        TxtPasswd.SetFocus
       TxtPasswd.Text = ""
    End If
   End If
 End If
 cnt = cnt + 1
 If cnt = 3 Then
  Unload Me
 End If
End If
End Sub

Private Sub Form_Load()
cnt = 0

End Sub