clsistotal.cls

一个用VB写的财务软件源码

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

Public Sub Init(ByVal Sql As String)
Set rSt = glo.cnnMain.Execute(Sql)
End Sub

Public Function Find(ByVal Condition As String) As Boolean
rSt.Filter = Condition
Find = Not (rSt.EOF And rSt.BOF)
End Function

Public Function GetValue(ByVal FName As String) As Variant
If Not IsNull(rSt.Fields(FName).Value) Then
    GetValue = rSt.Fields(FName).Value
End If
End Function