7,763
社区成员
发帖
与我相关
我的任务
分享
'---------------------------------------------------------------------------------------
' 过程名 : GetData
' 时间 : 2010-3-11 22:56
' 作者 : 杨过.网狐.cn
' 功能 :http://topic.csdn.net/u/20100311/16/a335911d-50bc-4831-9059-f49a1f176cb0.html
' 说明 :用VB如何做DLL接口
'---------------------------------------------------------------------------------------
'
Public Function GetData() As ADODB.Recordset
Set GetData = GetProRateData("供应商编码,物料编码,单价")
End Function
'---------------------------------------------------------------------------------------
' 过程名 : GetProRateData
' 时间 : 2010-3-12 09:05
' 作者 : 杨过.网狐.cn
' 功能 :
' 说明 : strFieldClause为SELECT子句,便于对于不同的接口方法需求输出不同的字段
'---------------------------------------------------------------------------------------
'
Private Function GetProRateData(strFieldClause As String) As ADODB.Recordset
Dim cn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim strConnection As String, strSql As String
Set cn = New ADODB.Connection
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & str_MdbFile & _
";Persist Security Info=False"
cn.Open strConnection
Set rst = New ADODB.Recordset
strSql = "select " & strFieldClause & " from ProRate"
rst.Open strSql, cn, adOpenDynamic, adLockReadOnly '如允许修改则选其它的如adLockOptimistic
Set GetProRateData = rst
End Function
'
'---------------------------------------------------------------------------------------
' 过程名 : GetData
' 时间 : 2010-3-11 22:56
' 作者 : 杨过.网狐.cn
' 功能 :http://topic.csdn.net/u/20100311/16/a335911d-50bc-4831-9059-f49a1f176cb0.html
' 说明 :用VB如何做DLL接口
'---------------------------------------------------------------------------------------
'
Public Function GetData(strSql As String) As ADODB.Recordset
Dim cn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim str_Connection As String
Set cn = New ADODB.Connection
str_Connection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & str_MdbFile & _
";Persist Security Info=False"
cn.Open str_Connection
Set rst = New ADODB.Recordset
rst.Open strSql, cn, adOpenDynamic, adLockReadOnly '如允许修改则选其它的如adLockOptimistic
Set GetData = rst
End Function
Option Explicit
Public gdatServerStarted As Date
Sub Main()
'部件开始时要执行的代码,
' 对第一个对象的请求作出反应。
gdatServerStarted = Now
Debug.Print "E xecuting Sub Main"
End Sub
'为对象提供唯一标识符的函数。
Public Function GetDebugID() As Long
Static lngDebugID As Long
lngDebugID = lngDebugID + 1
GetDebugID = lngDebugID
End Function
Option Explicit
Public Function GetData(sql as string) As Recordset
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
cn.Open "..."
Set GetData = cn.Execute(sql)
End Function