clssickpatienttypes.cls

医院门诊医生工作站,vb6 SqlServer

VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
  Persistable = 0  'NotPersistable
  DataBindingBehavior = 0  'vbNone
  DataSourceBehavior  = 0  'vbNone
  MTSTransactionMode  = 0  'NotAnMTSObject
END
Attribute VB_Name = "clsSickPatientTypes"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False
Attribute VB_Ext_KEY = "SavedWithClassBuilder6" ,"Yes"
Attribute VB_Ext_KEY = "Collection" ,"clsPatientType"
Attribute VB_Ext_KEY = "Member0" ,"clsPatientType"
Attribute VB_Ext_KEY = "Top_Level" ,"Yes"
Option Explicit

'局部变量，保存集合
Private mCol As Collection

Public Function Add(ID As String, Des As String, Flag As Integer, Optional sKey As String) As clsSickPatientType
    '创建新对象
    Dim objNewMember As clsSickPatientType
    Set objNewMember = New clsSickPatientType


    '设置传入方法的属性
    objNewMember.ID = ID
    objNewMember.Des = Des
    objNewMember.Flag = Flag
    If Len(sKey) = 0 Then
        mCol.Add objNewMember
    Else
        mCol.Add objNewMember, sKey
    End If


    '返回已创建的对象
    Set Add = objNewMember
    Set objNewMember = Nothing


End Function

Public Property Get Item(vntIndexKey As Variant) As clsSickPatientType
Attribute Item.VB_UserMemId = 0
    '引用集合中的一个元素时使用。
    'vntIndexKey 包含集合的索引或关键字，
    '这是为什么要声明为 Variant 的原因
    '语法：Set foo = x.Item(xyz) or Set foo = x.Item(5)
  Set Item = mCol(vntIndexKey)
End Property



Public Property Get Count() As Long
    '检索集合中的元素数时使用。语法：Debug.Print x.Count
    Count = mCol.Count
End Property


Public Sub Remove(vntIndexKey As Variant)
    '删除集合中的元素时使用。
    'vntIndexKey 包含索引或关键字，这是为什么要声明为 Variant 的原因
    '语法：x.Remove(xyz)


    mCol.Remove vntIndexKey
End Sub


Public Property Get NewEnum() As IUnknown
Attribute NewEnum.VB_UserMemId = -4
Attribute NewEnum.VB_MemberFlags = "40"
    '本属性允许用 For...Each 语法枚举该集合。
    Set NewEnum = mCol.[_NewEnum]
End Property


Private Sub Class_Initialize()
    '创建类后创建集合
    Set mCol = New Collection
    
    If gDbObj.GetRs("SELECT * FROM m_PatientType") >= 1 Then
        Do Until gDbObj.RS.EOF
            Me.Add gDbObj.RS!PtID, gDbObj.RS!PtDes, gDbObj.RS!Flag, gDbObj.RS!PtID
            gDbObj.RS.MoveNext
        Loop
    End If
End Sub


Private Sub Class_Terminate()
    '类终止后破坏集合
    Set mCol = Nothing
End Sub

Public Property Get DeFaultID() As String
    Dim PtObj As clsSickPatientType
    
    For Each PtObj In mCol
        If PtObj.DeFault Then
            DeFaultID = PtObj.ID
        End If
    Next
End Property
Public Property Get DeFaultDes() As String
    Dim PtObj As clsSickPatientType
    
    For Each PtObj In mCol
        If PtObj.DeFault Then
            DeFaultDes = PtObj.Des
        End If
    Next
End Property
Public Property Get DeFaultIndex() As Integer
    Dim I As Integer
    
    For I = 1 To mCol.Count
        If Item(I).DeFault Then
            DeFaultIndex = I
        End If
    Next
End Property