frmlogin.frm

仓库管理软件,库存信息,仓库入库,仓库出库,单据新增,修改,删除,审核,反审核等等功能.

VERSION 5.00
Begin VB.Form frmLogin 
   Caption         =   "登陆窗口"
   ClientHeight    =   2385
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   4335
   Icon            =   "frmLogin.frx":0000
   LinkTopic       =   "Form1"
   ScaleHeight     =   2385
   ScaleWidth      =   4335
   StartUpPosition =   2  '屏幕中心
   Begin VB.CommandButton cmdLogin 
      Caption         =   "登陆"
      Height          =   375
      Left            =   600
      TabIndex        =   3
      Top             =   1545
      Width           =   1335
   End
   Begin VB.CommandButton cmdCancel 
      Caption         =   "退出"
      Height          =   375
      Left            =   2400
      TabIndex        =   2
      Top             =   1545
      Width           =   1335
   End
   Begin VB.TextBox txtPWD 
      Height          =   270
      IMEMode         =   3  'DISABLE
      Left            =   1455
      PasswordChar    =   "*"
      TabIndex        =   1
      Text            =   "Text3"
      Top             =   1020
      Width           =   2370
   End
   Begin VB.ComboBox cmbUser 
      Height          =   300
      Left            =   1455
      Style           =   2  'Dropdown List
      TabIndex        =   0
      Top             =   540
      Width           =   2370
   End
   Begin VB.Label Label2 
      AutoSize        =   -1  'True
      Caption         =   "用 户 名:"
      Height          =   180
      Left            =   450
      TabIndex        =   5
      Top             =   600
      Width           =   810
   End
   Begin VB.Label Label3 
      AutoSize        =   -1  'True
      Caption         =   "密    码:"
      Height          =   180
      Left            =   450
      TabIndex        =   4
      Top             =   1065
      Width           =   810
   End
End
Attribute VB_Name = "frmLogin"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim RstLogin As New ADODB.Recordset

Private Sub cmdCancel_Click()
gExit = True
Unload Me
End Sub

Private Sub cmdLogin_Click()

    If Trim(txtPWD.Text) <> cmbUser.Tag Then
        Message "密码不正确!"
        Exit Sub
    Else
        LoginName = cmbUser.Text
        LoginTime = Time
        FirstSub
    End If
    
End Sub

Private Sub Form_Load()
    
    
    If RstLogin.State = 1 Then Rst.Close
    Set RstLogin = Nothing
    RstLogin.CursorLocation = adUseClient
    RstLogin.Open "SELECT * FROM Login", con, adOpenStatic, adLockBatchOptimistic

    Dim i As Integer

    If RstLogin.RecordCount <> 0 Then
        RstLogin.MoveFirst
        cmbUser.Clear
        For i = 0 To RstLogin.RecordCount - 1
            cmbUser.AddItem RstLogin.Fields("NAME")
            
            If IsNull(RstLogin.Fields("PASSWORD")) Then
                cmbUser.Tag = ""
            Else
                cmbUser.Tag = RstLogin.Fields("PASSWORD")
            End If

            RstLogin.MoveNext
        Next

    End If
    
    cmbUser.ListIndex = 0
    txtPWD.Text = ""
        
End Sub

Private Sub Form_Unload(Cancel As Integer)
    If RstLogin.State = 1 Then RstLogin.Close
    Set RstLogin = Nothing
End Sub