110,561
社区成员
发帖
与我相关
我的任务
分享
Imports SAPBAPIControlLib
Imports SAPTableFactoryCtrl
Imports System.Xml
Public Class Class1
Public bapi As Object = CreateObject("SAP.Functions")
Public Function GetConn() As Object
Dim connection As Object
connection = bapi.Connection
connection.ApplicationServer = My.Settings.Server
connection.Client = My.Settings.Client
connection.Language = My.Settings.Language
connection.User = My.Settings.User
connection.Password = My.Settings.Password
connection.SystemNumber = My.Settings.SystemNumber
connection.CodePage = My.Settings.CodePage
Return connection
End Function
'费用科目列表
Public Function GetSubjectList(ByVal comanyCode As String) As String
Dim connection As Object
Dim returnString As String
returnString = "<SubjectList>"
connection = GetConn()
If (connection.Logon(0, True)) Then
Dim codes = bapi.Add("Z_OA_001")
codes.Exports.Item("BUKRS") = comanyCode
codes.call()
Dim table As Table
table = codes.Tables("ACCOUNTS")
Dim I As Integer
For I = 1 To table.RowCount
returnString = returnString + "<item>"
returnString = returnString + "<id>" + table.Cell(I, "SAKNR") + "</id>"
returnString = returnString + "<txt>" + table.Cell(I, "TXT50") + "</txt>"
returnString = returnString + "</item>"
Next
End If
returnString = returnString + "</SubjectList>"
connection.logoff()
Return returnString
End Function