为了获得Customer Notes,我什么都试过了,但没有遇到任何问题。它只是给出了第一个Note,但没有列出。我试过使用AdditionalNotesRetList,但它将为空。
使用QuickBooks SDK 15 32位,涵盖QuickBooks 2002-2022的所有版本。
代码:
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;
}发布于 2022-07-05 09:15:09
找到了解决办法。
我没有使用这个,而是使用了XML请求。
IMsgSetResponse responseMsgSet = sessionManager.DoRequests(requestMsgSet);我用的是DoRequestsFromXMLString。其余的代码是一样的。
IMsgSetResponse responseMsgSet sessionManager.DoRequestsFromXMLString(file);要获得AdditionalNotesList,请使用以下
<IncludeRetElement>AdditionalNotesRet</IncludeRetElement>XML请求
<?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>https://stackoverflow.com/questions/72807125
复制相似问题