users.cls

售后服务系统 优质的售后服务是企业生存和市场竞争的保障

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  Varchar 40  用户名
'2 EmpName varchar 50 员工姓名
'3 UserPwd Varchar 40  密码
'4 UserType tinyint 用户类型：1-管理员；2-经理；3-工程师

Public UserName As String
Public EmpName As String
Public UserPwd As String
Public UserType As String

Public Sub Init()
  UserName = ""
  EmpName = ""
  UserPwd = ""
  UserType = 0
End Sub

'删除Users数据
Public Sub Delete(ByVal TmpUser As String)
  If UserType = 1 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
  UserName = TmpUser
  Dim rs As New ADODB.Recordset
  
  SqlStmt = "SELECT * FROM Users WHERE UserName='" _
          + Trim(TmpUser) + "'"
  Set rs = QueryExt(SqlStmt)
  If rs.EOF Then
    GetInfo = False
    Exit Function
  Else
    If IsNull(rs.Fields(1)) Then
      EmpName = ""
    Else
      EmpName = Trim(rs.Fields(1))
    End If
    If IsNull(rs.Fields(2)) Then
      UserPwd = ""
    Else
      UserPwd = Trim(rs.Fields(2))
    End If
    If IsNull(rs.Fields(3)) Then
      UserType = 0
    Else
      UserType = rs.Fields(3)
    End If
  End If

  GetInfo = True
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 Not rs.EOF Then
    In_DB = True
  Else
    In_DB = False
  End If
End Function

Public Sub Insert()
  SqlStmt = "INSERT INTO Users Values('" _
     + Trim(UserName) + "','" + Trim(EmpName) + "','" _
     + Trim(UserPwd) + "'," + Trim(UserType) + ")"
  SQLExt (SqlStmt)
End Sub

Public Sub Update(ByVal TmpUser As String)
  SqlStmt = "Update Users Set UserName='" + Trim(UserName) _
          + "',UserPwd='" + Trim(UserPwd) _
          + "',EmpName='" + Trim(EmpName) + "',UserType=" + Trim(UserType) _
          + " WHERE UserName='" + Trim(TmpUser) + "'"
  SQLExt (SqlStmt)
End Sub
Public Sub UpdatePassword(ByVal TmpUser As String)
  SqlStmt = "Update Users Set UserPwd='" + Trim(UserPwd) _
          + "' WHERE UserName='" + Trim(TmpUser) + "'"
  SQLExt (SqlStmt)
End Sub
'读取用户的员工姓名
Public Function GetName(ByVal TmpUserName As String) As String
  Dim rs As New ADODB.Recordset
  SqlStmt = "SELECT * FROM Users WHERE UserName='" _
          + Trim(TmpUserName) + "'"
  Set rs = QueryExt(SqlStmt)
  If Not rs.EOF Then
    GetName = rs("UserName")
  Else
    GetName = ""
  End If
End Function