cdepartment.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 = "CDepartment"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False
Option Explicit

Public DepartmentName As String
Public SubDepartments As Collection
Private mPeople As Variant
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
'重写，将包含人员的集合传进来，在这里放到SubDepartments集合中
'Public Sub createDepartment(Document As NotesDocument)
   ' DepartmentName = Document.GetItemValue("depname")(0)
  '  mPeople = Document.GetItemValue("depmembers")
 '   Dim docCol As NotesDocumentCollection
 '   Set docCol = Document.Responses
 '   Dim dept As CDepartment
  '  Dim i As Long
  '  For i = 1 To docCol.Count
  '      Set dept = New CDepartment
  '      dept.createDepartment docCol.GetNthDocument(i)
 '       SubDepartments.Add dept, dept.DepartmentName
'    Next i
'End Sub