将asp.net或webservice应用程序连接到SAP B1

Question

如何将asp.net或webservice应用程序连接到SAP B1？

谁能给出一个清晰的示例代码和示例来连接任何在SAP B1中可用的模块？

Answer 1

首先，您必须安装DIAPI，请参阅SAPbobsCOM

Sap连接

        SAPbobsCOM.Company oCompany = new SAPbobsCOM.Company();
        conectado = int.MinValue;
        oCompany.Server = "localhsot";
        oCompany.CompanyDB = "DB";
        oCompany.DbUserName = "SQL_USER";
        oCompany.DbPassword = "PASS_SQL";
        oCompany.UserName = "USER_SAP";
        oCompany.Password = "PASS_SAP";

        //language
        oCompany.DbServerType = BoDataServerTypes.dst_MSSQL2012;
        oCompany.language = BoSuppLangs.ln_Spanish_La;

        conectado = oCompany.Connect();
        if (conectado != 0)
            string error = oCompany.GetLastErrorDescription();

有了这个对象，您就有了用DIAPI打开任何sap模块的基础

示例sap文档

SAPbobsCOM.Documents oDocuments = oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oQuotations);

Answer 2

如果你已经配置并运行了B1服务层，那么我建议你在SAPbobosCom上使用它。它有更好的性能，但请注意，您不能运行SQL查询。服务层是REST api并使用oData协议。