cdepartments.cls

vb开发的连接mysql的工作流设置程序,图形化工作流自定义工具,原先是连接到Domino上的工作流自定义工具,现修改至mysql上,后台管理员设置工作流,前台读取数据库调用.

VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
  Persistable = 0  'NotPersistable
  DataBindingBehavior = 0  'vbNone
  DataSourceBehavior  = 0  'vbNone
  MTSTransactionMode  = 0  'NotAnMTSObject
END
Attribute VB_Name = "CDepartments"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False
Option Explicit

Implements CDepartment

Public DepartmentName As String
Public SubDepartments As Collection
Private mPeople As Variant

'06-04-24Private Sub CDepartment_createDepartment(Document As NotesDocument)
   ' createDepartment Document
'End Sub

Private Property Let CDepartment_DepartmentName(ByVal RHS As String)
    '
End Property

Private Function CDepartment_getSubDepartment(DeptName As String) As CDepartment
    Set CDepartment_getSubDepartment = getSubDepartment(DeptName)
End Function

Private Property Get CDepartment_People() As Variant
    CDepartment_People = mPeople
End Property

Private Property Set CDepartment_SubDepartments(ByVal RHS As Collection)
    'Set SubDepartments = RHS
End Property

Private Property Get CDepartment_SubDepartments() As Collection
    Set CDepartment_SubDepartments = SubDepartments
End Property

Private Sub Class_Initialize()
    Set SubDepartments = New Collection
    ReDim mPeople(0)
End Sub

Public Property Get People() As Variant
    People = mPeople
End Property

Public Function getSubDepartment(DeptName As String) As CDepartment
    On Error GoTo ErrHandler
    Set getSubDepartment = SubDepartments.Item(DeptName)
ErrHandler:
End Function

'06-04-24Public Sub createDepartment(Document As NotesDocument)
    'Dim dept As New CDepartment
    'dept.createDepartment Document
    'SubDepartments.Add dept, Document.GetItemValue("depname")(0)
'End Sub

Private Property Get CDepartment_DepartmentName() As String
    CDepartment_DepartmentName = ""
End Property