users.cls

人事信息管理系统 VB毕业设计 原代码+论文

VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
  Persistable = 0  'NotPersistable
  DataBindingBehavior = 0  'vbNone
  DataSourceBehavior  = 0  'vbNone
  MTSTransactionMode  = 0  'NotAnMTSObject
END
Attribute VB_Name = "Users"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False
'1 UserName  文本，长度为40  用户名，主键，必填字段（是），允许空字符串（否）
'2 Pwd 文本，长度为40  密码，必填字段（是），允许空字符串（否）
'3 User_type 数字，字节  用户类型（1 - 系统管理员用户，2 - 普通用户）

Public UserName As String
Public Pwd As String
Public User_type As Integer

Public Sub Init()
  UserName = ""
  Pwd = ""
  User_type = 0
End Sub

'删除Users数据
Public Sub Delete(ByVal TmpUser As String)
  If TmpUser = "Admin" Then
    Exit Sub
  End If
  
  SqlStmt = "DELETE FROM Users WHERE UserName='" + Trim(TmpUser) + "'"
  SQLExt (SqlStmt)
End Sub

Public Function GetInfo(ByVal TmpUser As String) As Boolean
  Dim rs As New ADODB.Recordset
  UserName = TmpUser
  
  SqlStmt = "SELECT * FROM Users WHERE UserName='" + Trim(TmpUser) + "'"
  Set rs = QueryExt(SqlStmt)
  If rs.EOF Then
    Init
    GetInfo = False
    Exit Function
  Else
    Pwd = Trim(rs.Fields(1))
    User_type = rs.Fields(2)
    GetInfo = True
  End If
End Function

Public Function In_DB(ByVal TmpUser As String) As Boolean
  Dim rs As New ADODB.Recordset
  
  SqlStmt = "SELECT * FROM Users WHERE UserName='" + Trim(TmpUser) + "'"
  Set rs = QueryExt(SqlStmt)
  If rs.EOF Then
    In_DB = False
  Else
    In_DB = True
  End If
End Function

Public Sub Insert()
  SqlStmt = "INSERT INTO Users Values('" + Trim(UserName) + "','" + Trim(Pwd) _
     + "'," + Trim(Str(User_type)) + ")"
  SQLExt (SqlStmt)
End Sub

Public Sub Update(ByVal TmpUser As String)
  SqlStmt = "Update Users Set UserName='" + Trim(UserName) _
          + "',Pwd='" + Trim(Pwd) + "',User_type=" + Trim(Str(User_type)) _
          + " WHERE UserName='" + Trim(TmpUser) + "'"
  SQLExt (SqlStmt)
End Sub