主题：Foxtable无法获取淘宝Orders

.net能用,foxtable肯定就能用。

你贴出.net的代码给我看看，是能运行。

还有库文件也传一个。

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:top_trade.xls

 

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:top_order.xls

 

 

 

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:top代码.txt

 

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:topsdk.rar

我在foxtable的命令窗口，测试下面的代码，得到的结果是79:

 

Dim client2 As Top.Api.ITopClient
client2= New Top.Api.DefaultTopClient("http://gw.api.taobao.com/router/rest", "12331621", "176b9b899ddd386d825897408268be04")
Dim request As Top.Api.Request.TradesSoldGetRequest = New Top.Api.Request.TradesSoldGetRequest
request.Fields= "seller_nick, buyer_nick, title, type, created, tid, seller_rate, buyer_rate, status, payment, discount_fee, adjust_fee, post_fee, total_fee, pay_time, end_time, modified, consign_time, buyer_obtain_point_fee, point_fee, real_point_fee, received_payment, commission_fee, pic_path, num_iid, num, price, cod_fee, cod_status, shipping_type, receiver_name, receiver_state, receiver_city, receiver_district, receiver_address, receiver_zip, receiver_mobile, receiver_phone"
request.StartCreated = DateTime.Parse("2011-08-29 00:00:00")
request.EndCreated = DateTime.Parse("2011-08-30 00:00:00")
request.Status="TRADE_FINISHED"
request.PageSize=100
request.PageNo=1
Dim response As  Top.Api.Response.TradesSoldGetResponse= client2.Execute(request)
Dim trades As List(Of Top.Api.Domain.Trade) = response.Trades
messagebox.show(trades.count)

淘宝交易单读取OK，淘宝交易单的子订单读取数据为0。交易单与子订单的对应关系是1：N（N>=1）。

 

 

麻烦狐爸啦，帮忙给看下吧。

     output.show(trades.Orders.count)
这个值传回看看。

嗯嗯，问题出在Orders.count。狐爸那里测试结果怎么样啊？

  

此主题相关图片如下：tbao.gif

trade是交易单，order是交易单的子订单。问题出在子订单。获取不到的是trade的order的count.

output.show(trades(0).orders.count)

我在vs.net 和foxtable分别测试下面的代码：

 

Dim s As String
Dim client2 As Top.Api.ITopClient
client2 = New Top.Api.DefaultTopClient("http://gw.api.taobao.com/router/rest", "12331621", "176b9b899ddd386d825897408268be04")
Dim request As Top.Api.Request.TradesSoldGetRequest = New Top.Api.Request.TradesSoldGetRequest
request.Fields = "seller_nick, buyer_nick, title, type, created, tid, seller_rate, buyer_rate, status, payment, discount_fee, adjust_fee, post_fee, total_fee, pay_time, end_time, modified, consign_time, buyer_obtain_point_fee, point_fee, real_point_fee, received_payment, commission_fee, pic_path, num_iid, num, price, cod_fee, cod_status, shipping_type, receiver_name, receiver_state, receiver_city, receiver_district, receiver_address, receiver_zip, receiver_mobile, receiver_phone"
request.StartCreated = DateTime.Parse("2011-08-29 00:00:00")
request.EndCreated = DateTime.Parse("2011-08-30 00:00:00")
request.Status = "TRADE_FINISHED"
request.PageSize = 100
request.PageNo = 1
Dim response As Top.Api.Response.TradesSoldGetResponse = client2.Execute(request)
Dim trades As List(Of Top.Api.Domain.Trade) = response.Trades
For Each Td As Top.Api.Domain.Trade In trades
    Dim Ods As List(Of Top.Api.Domain.Order) = Td.Orders
    s = s & ControlChars.NewLine & (Ods.Count)
Next
MessageBox.Show(s)

 

得到的结果都是一连串的0,显然并非在.net行，在foxtable不行，而是本来就不行，直接向淘宝询问吧

.net 里面可以读出来的。

 

trade与order关系至少为1对1.所以order的count值一定是大于等于1的。