首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >获取发布QuickBooks客户备注列表=> QuickBooks桌面SDK用于.NET C#

获取发布QuickBooks客户备注列表=> QuickBooks桌面SDK用于.NET C#
EN

Stack Overflow用户
提问于 2022-06-29 19:54:37
回答 1查看 30关注 0票数 0

为了获得Customer Notes,我什么都试过了,但没有遇到任何问题。它只是给出了第一个Note,但没有列出。我试过使用AdditionalNotesRetList,但它将为空。

使用QuickBooks SDK 15 32位,涵盖QuickBooks 2002-2022的所有版本。

代码:

代码语言:javascript
复制
QBSessionManager sessionManager = null;
        bool sessionBegun = false;
        bool connectionOpen = false;
        try
        {
            sessionManager = new QBSessionManager();
            sessionManager.OpenConnection("", "Company2");
            connectionOpen = true;
            sessionManager.BeginSession(@"C:\Users\Public\Documents\Intuit\QuickBooks\Company Files\Company2.qbw", ENOpenMode.omDontCare);
            sessionBegun = true;

            IMsgSetRequest requestMsgSet = sessionManager.CreateMsgSetRequest("US", 8, 0);
            requestMsgSet.Attributes.OnError = ENRqOnError.roeContinue;

            ICustomerQuery customerQueryRq = requestMsgSet.AppendCustomerQueryRq();

            IMsgSetResponse responseMsgSet = sessionManager.DoRequests(requestMsgSet);
            IResponse response = responseMsgSet.ResponseList.GetAt(0);
            ICustomerRetList customerRetList = (ICustomerRetList)response.Detail;
            ICustomerRet customerRet = customerRetList.GetAt(0);

            // customerRet.AdditionalNotesRetList is null
            IAdditionalNotesRetList listnotes = (IAdditionalNotesRetList)customerRet.AdditionalNotesRetList;

        }
        catch (Exception ex)
        {

            throw;
        }
EN

回答 1

Stack Overflow用户

发布于 2022-07-05 09:15:09

找到了解决办法。

我没有使用这个,而是使用了XML请求。

代码语言:javascript
复制
IMsgSetResponse responseMsgSet = sessionManager.DoRequests(requestMsgSet);

我用的是DoRequestsFromXMLString。其余的代码是一样的。

代码语言:javascript
复制
IMsgSetResponse responseMsgSet sessionManager.DoRequestsFromXMLString(file);

要获得AdditionalNotesList,请使用以下

代码语言:javascript
复制
<IncludeRetElement>AdditionalNotesRet</IncludeRetElement>

XML请求

代码语言:javascript
复制
<?xml version="1.0" encoding="utf-8"?>
<?qbxml version="13.0"?>
<QBXML>

    <QBXMLMsgsRq onError = "stopOnError">

        <CustomerQueryRq>

            <ActiveStatus>All</ActiveStatus>

            <FromModifiedDate>2018-01-12T09:20:42</FromModifiedDate>

            <IncludeRetElement>ListID</IncludeRetElement>

            <IncludeRetElement>Name</IncludeRetElement>

            <IncludeRetElement>CompanyName</IncludeRetElement>

            <IncludeRetElement>CustomerFullName</IncludeRetElement>

            <IncludeRetElement>CustomerType</IncludeRetElement>

            <IncludeRetElement>IsActive</IncludeRetElement>

            <IncludeRetElement>Sublevel</IncludeRetElement>

            <IncludeRetElement>ParentRef</IncludeRetElement>

            <IncludeRetElement>JobStartDate</IncludeRetElement>

            <IncludeRetElement>JobEndDate</IncludeRetElement>

            <IncludeRetElement>AdditionalNotesRet</IncludeRetElement>

            <IncludeRetElement>Notes</IncludeRetElement>

            <IncludeRetElement>JobTypeRef</IncludeRetElement>

            <IncludeRetElement>JobStatus</IncludeRetElement>

        </CustomerQueryRq>

    </QBXMLMsgsRq>

</QBXML>
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/72807125

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档