www.pudn.com > new xsc.rar > frmLogin.frm

VERSION 5.00 
Begin VB.Form frmLogin  
   BorderStyle     =   3  'Fixed Dialog 
   Caption         =   "登录" 
   ClientHeight    =   1545 
   ClientLeft      =   2835 
   ClientTop       =   3480 
   ClientWidth     =   3750 
   Icon            =   "frmLogin.frx":0000 
   LinkTopic       =   "Form1" 
   MaxButton       =   0   'False 
   MinButton       =   0   'False 
   ScaleHeight     =   912.837 
   ScaleMode       =   0  'User 
   ScaleWidth      =   3521.047 
   ShowInTaskbar   =   0   'False 
   StartUpPosition =   2  '屏幕中心 
   Begin VB.TextBox txtUserName  
      Height          =   345 
      Left            =   1290 
      TabIndex        =   1 
      Top             =   135 
      Width           =   2325 
   End 
   Begin VB.CommandButton cmdOK  
      Caption         =   "确定" 
      Default         =   -1  'True 
      Height          =   390 
      Left            =   495 
      TabIndex        =   4 
      Top             =   1020 
      Width           =   1140 
   End 
   Begin VB.CommandButton cmdCancel  
      Cancel          =   -1  'True 
      Caption         =   "取消" 
      Height          =   390 
      Left            =   2100 
      TabIndex        =   5 
      Top             =   1020 
      Width           =   1140 
   End 
   Begin VB.TextBox txtPassword  
      Height          =   345 
      IMEMode         =   3  'DISABLE 
      Left            =   1290 
      PasswordChar    =   "*" 
      TabIndex        =   3 
      Top             =   525 
      Width           =   2325 
   End 
   Begin VB.Label lblLabels  
      Caption         =   "用户名称(&U):" 
      Height          =   270 
      Index           =   0 
      Left            =   105 
      TabIndex        =   0 
      Top             =   150 
      Width           =   1080 
   End 
   Begin VB.Label lblLabels  
      Caption         =   "密码(&P):" 
      Height          =   270 
      Index           =   1 
      Left            =   105 
      TabIndex        =   2 
      Top             =   540 
      Width           =   1080 
   End 
End 
Attribute VB_Name = "frmLogin" 
Attribute VB_GlobalNameSpace = False 
Attribute VB_Creatable = False 
Attribute VB_PredeclaredId = True 
Attribute VB_Exposed = False 
Option Explicit 
 
Public ok As Boolean 
Dim micount As Integer 
Private Sub Form_Load() 
  ok = False 
  micount = 0 
End Sub 
 
Private Sub cmdCancel_Click() 
    ok = False 
    Unload Me 
End Sub 
 
Private Sub cmdOK_Click() 
   Dim txtSQL As String 
   Dim m As ADODB.Recordset 
   Dim msgtext As String 
   Dim username As String 
    If Trim(txtUserName.Text = "") Then 
       MsgBox "没有这个用户，请重新输入用户名！", vbOKOnly + vbExclamation, "警告" 
   txtUserName.SetFocus 
    Else 
      txtSQL = "select * from yonghu where name='" & txtUserName.Text & "'" 
      Set m = ExecuteSQL(txtSQL, msgtext) 
      If m.RecordCount = 0 Then 
        MsgBox "没有这个用户，请重新输入用户名！", vbOKOnly + vbExclamation, "警告" 
        txtUserName.SetFocus 
      Else 
       If Trim(m.Fields(1)) = Trim(txtPassword.Text) Then 
           ok = True 
           m.Close 
           Me.Hide 
           frmmdi.Show 
           username = Trim(txtUserName.Text) 
        Else 
        MsgBox "密码错误，请重新输入！", vbOKOnly + vbExclamation, "警告" 
         txtPassword.SetFocus 
          txtPassword.Text = "" 
      End If 
     End If 
   End If 
   micount = micount + 1 
   If micount = 3 Then 
    Me.Hide 
    End 
 End If 
    Exit Sub 
End Sub