kcbfdhs.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 = "KcBfdhs"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False
'QQ:75347626
'MSN:[e-mail]
Option Explicit
Dim oKcBfdhs As Collection

Public Property Get Name() As String
   Name = "KcBfdhs"
End Property

Private Sub Class_Initialize()
   Set oKcBfdhs = New Collection
End Sub

Public Sub Add(oKcBfdh As KcBfdh, Optional Needsave As Integer = 1)
   Dim mKey As Integer
   Dim vKcBfdh As KcBfdh
   For Each vKcBfdh In oKcBfdhs
      If mKey < vKcBfdh.KcBfdhKey Then
         mKey = vKcBfdh.KcBfdhKey
      End If
   Next
   oKcBfdh.KcBfdhKey = mKey + 1
   If Needsave = 1 Then
      oKcBfdh.Save
   End If
   oKcBfdhs.Add Item:=oKcBfdh, Key:=CStr(mKey + 1)
End Sub

Public Sub Remove(Vindex, Optional Needdel As Integer = 1)
 
   Dim oKcBfdh As KcBfdh
   Set oKcBfdh = Item(Vindex)
   If Needdel = 1 And oKcBfdh.KcBfdhId = 1 Then
      oKcBfdh.Del
   End If
   oKcBfdhs.Remove (Vindex)
   Set oKcBfdh = Nothing
   
End Sub

Public Property Get Count() As Integer
   Count = oKcBfdhs.Count
End Property

Public Function Item(Vindex) As KcBfdh
Attribute Item.VB_UserMemId = 0
   Set Item = oKcBfdhs.Item(Vindex)
End Function

Public Sub ClearAll()
   Dim I, Vcount As Integer
   Vcount = oKcBfdhs.Count
   For I = 1 To Vcount
      oKcBfdhs.Remove (1)
   Next
End Sub

Public Sub Fillbydb(Optional vWhereStr As String = "")
   Dim oKcBfdh As KcBfdh
   Dim Rs As ADODB.Recordset
   Dim mKey As Integer
   Dim mSqlStr As String
On Error GoTo Errorhandle

   ClearAll
   
   mSqlStr = "SELECT KcBfdHDOCNO,KcBfdHDAT,KcBfdH_HwCkMc=HwCkMc,KcBfdH_HwCkno,KcBfdHSYSDAT,KcBfdHSYSTIME,KcBfdHNO FROM KcBfdHREC,HWCKREC WHERE HWCKNO=KcBfdH_HWCKNO"
   
   If vWhereStr <> "" Then
      mSqlStr = mSqlStr & " AND " & vWhereStr
   End If
   
   mSqlStr = mSqlStr & "  ORDER BY KcBfdHDOCNO"
   
   Set Rs = Conn.Execute(mSqlStr)
   
   mKey = 1
   Do Until Rs.EOF
      Set oKcBfdh = New KcBfdh
      oKcBfdh.KcBfdhKey = mKey
      oKcBfdh.BatchLet Rs!KcBfdhDocno, Rs!KcBfdhDat, Rs!KcBfdh_HwCkMc, Rs!KcBfdh_HwCkno, Rs!KcBfdhSysDat, Rs!KcBfdhSysTime, Rs!KcBfdhNo
      oKcBfdhs.Add Item:=oKcBfdh, Key:=CStr(mKey)
      Rs.MoveNext
      mKey = mKey + 1
   Loop
   
   Rs.Close
   Set Rs = Nothing

Exit Sub
Errorhandle:
   If Not Rs Is Nothing Then
     Rs.Close
   End If
   Set Rs = Nothing
   Err.Raise vbObjectError + 1, , Err.Description
End Sub

Public Function NewEnum() As IUnknown
Attribute NewEnum.VB_UserMemId = -4
Attribute NewEnum.VB_MemberFlags = "40"
  Set NewEnum = oKcBfdhs.[_NewEnum]
End Function

Private Sub Class_Terminate()
   ClearAll
   Set oKcBfdhs = Nothing
End Sub