frmlogin.frm

本科毕业设计-商贸有限公司销售管理系统(论文+源代码+答辩PPT)

VERSION 5.00
Begin VB.Form frmLogin 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "Login"
   ClientHeight    =   3240
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   5070
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   MinButton       =   0   'False
   ScaleHeight     =   3240
   ScaleWidth      =   5070
   Begin VB.CommandButton cmdCancel 
      Cancel          =   -1  'True
      Caption         =   "取   消"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   2760
      TabIndex        =   6
      Top             =   2520
      Width           =   1215
   End
   Begin VB.CommandButton cmdLogin 
      Caption         =   "登    录"
      Default         =   -1  'True
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   840
      TabIndex        =   5
      Top             =   2520
      Width           =   1215
   End
   Begin VB.Frame fraLogin 
      BackColor       =   &H80000018&
      Height          =   1935
      Left            =   360
      TabIndex        =   1
      Top             =   240
      Width           =   4335
      Begin VB.ComboBox Combo1 
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   12
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   360
         Left            =   1680
         TabIndex        =   0
         Top             =   480
         Width           =   2175
      End
      Begin VB.TextBox txtPwd 
         Height          =   375
         IMEMode         =   3  'DISABLE
         Left            =   1680
         PasswordChar    =   "*"
         TabIndex        =   4
         Top             =   1200
         Width           =   2175
      End
      Begin VB.Label lblPwd 
         BackColor       =   &H00C0C000&
         Caption         =   "密  码："
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   12
            Charset         =   134
            Weight          =   700
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   240
         TabIndex        =   3
         Top             =   1200
         Width           =   1095
      End
      Begin VB.Label lblUser 
         BackColor       =   &H00C0C000&
         Caption         =   "用户名："
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   12
            Charset         =   134
            Weight          =   700
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   240
         TabIndex        =   2
         Top             =   480
         Width           =   1095
      End
   End
End
Attribute VB_Name = "frmLogin"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim rstUser As New ADODB.Recordset
Dim rs_user As New ADODB.Recordset

Private Sub cmdCancel_Click()
   Unload Me
End Sub

Private Sub cmdLogin_Click()
    '首先检查用户是否输入了用户名和密码
   
    If Combo1.Text = "" Then
       MsgBox "请输入用户名！", vbOKOnly + vbInformation, "注意"
       Combo1.SetFocus
       Exit Sub
    ElseIf txtPwd.Text = "" Then
       MsgBox "请输入密码！", vbOKOnly + vbInformation, "注意"
       txtPwd.SetFocus
       Exit Sub
    End If
       
   Dim sql As String
   sql = "select * from userdb where 用户名 = '" & Combo1.Text & "' and " _
   & " 密码= '" & txtPwd.Text & "'"
   rstUser.Open sql, conn, adOpenKeyset, adLockPessimistic
   If rstUser.EOF = True Then
     MsgBox "用户名或密码错误，无法登录", vbOKOnly + vbInformation, ""
     rstUser.Close
   
   ElseIf rstUser.Fields(3) = "二级客户端" Then
          MsgBox "正确登录", vbOKOnly + vbExclamation, ""
   '打开窗体
   MDIfrmMain.mnchpwd.Enabled = False
   MDIfrmMain.adduser.Enabled = False
   MDIfrmMain.mntrade.Enabled = False
   MDIfrmMain.mnbuyst.Enabled = True
   MDIfrmMain.mnsellst.Enabled = True
   MDIfrmMain.mngrade.Enabled = True
   MDIfrmMain.mntable.Enabled = True
   
    rstUser.Close
   Unload Me
     
    ElseIf rstUser.Fields(3) = "一级客户端" Then
          MsgBox "正确登录", vbOKOnly + vbExclamation, ""
   '打开窗体
   MDIfrmMain.mnchpwd.Enabled = False
   MDIfrmMain.adduser.Enabled = False
   MDIfrmMain.mntrade.Enabled = True
   MDIfrmMain.mnbuyst.Enabled = True
   MDIfrmMain.mnsellst.Enabled = True
   MDIfrmMain.mngrade.Enabled = True
   MDIfrmMain.mntable.Enabled = True
    
  
   rstUser.Close
   Unload Me
   
   ElseIf rstUser.Fields(3) = "系统管理员" Then
    MsgBox "正确登录", vbOKOnly + vbExclamation, ""
   MDIfrmMain.mnchpwd.Enabled = True
   MDIfrmMain.mntrade.Enabled = True
   MDIfrmMain.mnbuyst.Enabled = True
   MDIfrmMain.mnsellst.Enabled = True
   MDIfrmMain.mngrade.Enabled = True
   MDIfrmMain.mntable.Enabled = True
   MDIfrmMain.adduser.Enabled = True
    
  
   rstUser.Close
   Unload Me
   End If
End Sub


Private Sub Form_Load()
   Dim X0 As Long
   Dim Y0 As Long
  
   '让窗体居中
   X0 = Screen.Width
   Y0 = Screen.Height
   X0 = (X0 - Me.Width) / 2
   Y0 = (Y0 - Me.Height) / 2
   Me.Move X0, Y0
   
  Dim sqluser As String
   sqluser = "select * from username"
   rs_user.CursorLocation = adUseClient
   rs_user.Open sqluser, conn, adOpenKeyset, adLockPessimistic
   While Not rs_user.EOF
      Combo1.AddItem rs_user.Fields(0)
      rs_user.MoveNext
   Wend
    rs_user.Close
End Sub