enter.frm

库存管理系统

VERSION 5.00
Object = "{FAEEE763-117E-101B-8933-08002B2F4F5A}#1.1#0"; "DBLIST32.OCX"
Begin VB.Form enter 
   BackColor       =   &H80000008&
   BorderStyle     =   0  'None
   Caption         =   "管理员登陆"
   ClientHeight    =   1830
   ClientLeft      =   4410
   ClientTop       =   3885
   ClientWidth     =   3510
   Icon            =   "enter.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   1830
   ScaleWidth      =   3510
   ShowInTaskbar   =   0   'False
   Begin VB.Frame Frame1 
      BackColor       =   &H00FFC0C0&
      Height          =   1905
      Left            =   7
      TabIndex        =   0
      Top             =   -90
      Width           =   3495
      Begin VB.Data Dataenter 
         Caption         =   "Dataenter"
         Connect         =   "Access"
         DatabaseName    =   "C:\Documents and Settings\Administrator\桌面\通用库管\库存管理.mdb"
         DefaultCursorType=   0  'DefaultCursor
         DefaultType     =   2  'UseODBC
         DragMode        =   1  'Automatic
         Exclusive       =   0   'False
         Height          =   345
         Left            =   1440
         Options         =   0
         ReadOnly        =   0   'False
         RecordsetType   =   1  'Dynaset
         RecordSource    =   "员工表"
         Top             =   240
         Width           =   1815
      End
      Begin VB.TextBox sqname 
         BackColor       =   &H00FFFFC0&
         ForeColor       =   &H00FFFFC0&
         Height          =   285
         Left            =   1440
         TabIndex        =   8
         Top             =   600
         Width           =   1935
      End
      Begin VB.CommandButton Command1 
         BackColor       =   &H00C0C0C0&
         Caption         =   "显   示"
         Height          =   375
         Left            =   1238
         TabIndex        =   6
         Top             =   1440
         Width           =   975
      End
      Begin VB.TextBox sqpassword 
         BackColor       =   &H00FFFFC0&
         ForeColor       =   &H00FFFFC0&
         Height          =   285
         Left            =   1440
         TabIndex        =   3
         Top             =   1080
         Width           =   1935
      End
      Begin VB.CommandButton yes 
         BackColor       =   &H00004080&
         Caption         =   "确   认"
         Height          =   375
         Left            =   120
         TabIndex        =   2
         Top             =   1440
         Width           =   975
      End
      Begin VB.CommandButton no 
         Caption         =   "取   消"
         Height          =   375
         Left            =   2400
         TabIndex        =   1
         Top             =   1440
         Width           =   975
      End
      Begin MSDBCtls.DBCombo dbpassword 
         Bindings        =   "enter.frx":0442
         Height          =   315
         Left            =   1560
         TabIndex        =   9
         Top             =   1080
         Visible         =   0   'False
         Width           =   1935
         _ExtentX        =   3413
         _ExtentY        =   556
         _Version        =   393216
         ForeColor       =   16744576
         ListField       =   "密码"
         BoundColumn     =   "密码"
         Text            =   ""
      End
      Begin VB.Label Label3 
         BackColor       =   &H00FFC0C0&
         Caption         =   "需要东方软件的授权才能使用"
         BeginProperty Font 
            Name            =   "隶书"
            Size            =   12
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H00FF80FF&
         Height          =   255
         Left            =   240
         TabIndex        =   7
         Top             =   240
         Width           =   3135
      End
      Begin VB.Label Label1 
         BackColor       =   &H00FFC0C0&
         Caption         =   "授权名称："
         BeginProperty Font 
            Name            =   "方正姚体"
            Size            =   12
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H00FF80FF&
         Height          =   255
         Left            =   120
         TabIndex        =   5
         Top             =   600
         Width           =   1455
      End
      Begin VB.Label Label2 
         BackColor       =   &H00FFC0C0&
         Caption         =   "授权密码："
         BeginProperty Font 
            Name            =   "方正姚体"
            Size            =   12
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H00FF80FF&
         Height          =   255
         Left            =   120
         TabIndex        =   4
         Top             =   1080
         Width           =   1335
      End
   End
End
Attribute VB_Name = "enter"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
sqname.ForeColor = &H80000008
sqpassword.ForeColor = &H80000008
End Sub

Private Sub Form_Load()
Dataenter.DatabaseName = App.Path & "\库存管理.mdb"
Dataenter.Connect = ";pwd=lee1012"
Dataenter.RecordSource = "员工表"
Dataenter.Refresh
Dataenter.Visible = False

End Sub

Private Sub no_Click()
Unload MDIFrmMain
Unload Me

End Sub

Private Sub sqpassword_Change()
Dataenter.Recordset.FindFirst "姓名 ='" & sqname.Text & "'"

End Sub

Private Sub yes_Click()
Dim a As Boolean
If sqpassword.Text = Dataenter.Recordset("密码") Then
    MDIFrmMain.Show
'Unload Me
Else
    a = MsgBox("你不是合法用户！请出去！", vbCritical, "东方库管")
    Unload Me
End If
Me.Visible = False
'Unload Me
End Sub