frmlogin.frm

vb+sqlserver实现的人事管理系统

VERSION 5.00
Begin VB.Form frmLogin 
   BorderStyle     =   0  'None
   Caption         =   "登录"
   ClientHeight    =   4470
   ClientLeft      =   2790
   ClientTop       =   3150
   ClientWidth     =   4560
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   2641.023
   ScaleMode       =   0  'User
   ScaleWidth      =   4281.593
   ShowInTaskbar   =   0   'False
   StartUpPosition =   2  '屏幕中心
   Begin VB.Frame Frame1 
      BackColor       =   &H00D8D7D5&
      Height          =   3855
      Left            =   0
      TabIndex        =   0
      Top             =   600
      Width           =   4455
      Begin VB.Frame Frame3 
         BackColor       =   &H00D8D7D5&
         Height          =   1455
         Left            =   120
         TabIndex        =   3
         Top             =   2040
         Width           =   3975
         Begin VB.CommandButton Cmd_Cancel 
            Caption         =   "取消"
            Height          =   615
            Left            =   2280
            Style           =   1  'Graphical
            TabIndex        =   9
            Top             =   480
            Width           =   1335
         End
         Begin VB.CommandButton Cmd_OK 
            BackColor       =   &H0080FF80&
            Caption         =   "确定"
            Height          =   615
            Left            =   120
            TabIndex        =   8
            Top             =   480
            Width           =   1455
         End
      End
      Begin VB.Frame Frame2 
         BackColor       =   &H00D8D7D5&
         Height          =   1935
         Left            =   120
         TabIndex        =   1
         Top             =   120
         Width           =   3975
         Begin VB.TextBox txtPwd 
            Appearance      =   0  'Flat
            BackColor       =   &H00C0FFFF&
            Height          =   495
            IMEMode         =   3  'DISABLE
            Left            =   1560
            PasswordChar    =   "*"
            TabIndex        =   7
            Top             =   1200
            Width           =   2055
         End
         Begin VB.TextBox txtUser 
            Appearance      =   0  'Flat
            BackColor       =   &H00C0FFFF&
            Height          =   495
            Left            =   1560
            TabIndex        =   5
            Top             =   360
            Width           =   2055
         End
         Begin VB.Label Label3 
            BackStyle       =   0  'Transparent
            Caption         =   "输入用户密码："
            Height          =   375
            Left            =   240
            TabIndex        =   6
            Top             =   1320
            Width           =   1335
         End
         Begin VB.Label Label1 
            BackStyle       =   0  'Transparent
            Caption         =   "输入用户姓名："
            Height          =   375
            Left            =   240
            TabIndex        =   2
            Top             =   480
            Width           =   1455
         End
      End
   End
   Begin VB.Image Image2 
      Height          =   345
      Left            =   4200
      Picture         =   "frmLogin.frx":0000
      Top             =   0
      Width           =   345
   End
   Begin VB.Label Label2 
      BackStyle       =   0  'Transparent
      Caption         =   "登 陆 系 统"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00FFFFFF&
      Height          =   255
      Left            =   1440
      TabIndex        =   4
      Top             =   120
      Width           =   2055
   End
   Begin VB.Image Image1 
      Height          =   6975
      Left            =   0
      Picture         =   "frmLogin.frx":2300
      Top             =   0
      Width           =   6885
   End
End
Attribute VB_Name = "frmLogin"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public PasswordKey As String
Public NameKey As String
Public Try_times As Integer





Private Sub Cmd_Cancel_Click()
  End
End Sub

Private Sub Cmd_Ok_Click()
  Dim tmpUser, tmpPwd As String
  Dim isexe As Boolean
  Dim rsusers As ADODB.Recordset
  
  tmpUser = Trim(txtUser.Text)
  tmpPwd = Trim(txtPwd.Text)
  UserName = tmpUser

      If MyUser.in_db(tmpUser, tmpPwd) <> True Then
      
        MsgBox "用户名或密码错误", 48, "提示"
      Else
      
         Unload Me
        Load frmMain
       frmMain.Show
   
   End If
  
End Sub

Private Sub Form_Load()
  txtUser.Text = "admin"
  txtPwd.Text = "0"
End Sub

Private Sub Image2_Click()
 Unload Me
End Sub