主题：Foxtable无法获取淘宝Orders

我就是在.net里头测试的，不信的话，你可以直接在vb.net 测试20楼的代码，进行验证。

也许你定义的日期范围，根本就没有订单。

此主题相关图片如下：tid-oid.jpg

 

这是我用.net测试的结果

别管.net的结果，我在你给出的代码中，从中提取出关键部分，分别明明在.net和foxtbale测试，结果都显示订单数是0，你如何解释？

foxtable就是.net，不可能一样的代码有两样的结果。

也许你指定的日期范围内，根本就没有订单。

 

 

你在vb.net测试下面的代码看看，明明所有的订单数，都是0的。

 

 

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)

          我.net测试代码如下：

DataTable DT = new DataTable();
            //DT.Columns.Add("AdjustFee");
            DT.Columns.Add("Title");
            DT.Columns.Add("Tid");
            DT.Columns.Add("Status");
            DT.Columns.Add("SellerNick");
            DT.Columns.Add("BuyerNick");
            DT.Columns.Add("OID");
            DT.Columns.Add("PromotionDetailName");

            Top.Api.ITopClient client2;
            client2 = new Top.Api.DefaultTopClient("http://gw.api.taobao.com/router/rest", "12331621", "176b9b899ddd386d825897408268be04");
            Top.Api.Request.TradesSoldGetRequest request = new Top.Api.Request.TradesSoldGetRequest();
            request.Fields = "seller_nick,buyer_nick,title,type,created,sid,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,orders.title,orders.pic_path,orders.price,orders.num,orders.iid,orders.num_iid,orders.sku_id,orders.refund_status,orders.status,orders.oid,orders.total_fee,orders.payment,orders.discount_fee,orders.adjust_fee,orders.sku_properties_name,orders.item_meal_name,orders.buyer_rate,orders.seller_rate,orders.outer_iid,orders.outer_sku_id,orders.refund_id,orders.seller_type";
            request.PageSize = 100;
            request.StartCreated = DateTime.Parse("2011-08-29 00:00:00");
            request.EndCreated = DateTime.Parse("2011-08-30 00:00:00");
            Top.Api.Response.TradesSoldGetResponse response = client2.Execute(request);

            List<Top.Api.Domain.Trade> trades = response.Trades;

            foreach (Top.Api.Domain.Trade Td in trades)
            {
                DataRow NewR = DT.NewRow();
                //NewR["AdjustFee"] = Td.AdjustFee;
                NewR["Title"] = Td.Title;
                NewR["Tid"] = Td.Tid;
                NewR["Status"] = Td.Status;
                NewR["SellerNick"] = Td.SellerNick;
                NewR["BuyerNick"] = Td.BuyerNick;
                foreach (Top.Api.Domain.Order Od in Td.Orders)
                {
                    if (NewR["OID"].ToString().Trim() != "")
                    {
                        NewR["OID"] = NewR["OID"] + "," + Od.Oid.ToString();
                    }
                    else { NewR["OID"] = Od.Oid.ToString(); }
                }
                foreach (Top.Api.Domain.PromotionDetail Pd in Td.PromotionDetails)
                {
                    NewR["PromotionDetailName"] = NewR["PromotionDetailName"] + Pd.PromotionName;
                }
                DT.Rows.Add(NewR);
            }
            dataGridView1.DataSource = DT;

我再试试。

c#能做的，foxtable也能做，效果一样：

 

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

点击浏览该文件:管理项目61.rar

嗯嗯，是我误会狐表了。

 

1、我将我输出oid的net的代码移植到foxt，新建事件测试，oid输出正常。

 

 

此主题相关图片如下：net移植foxtable测试.jpg

 

2、之前foxt里用相同的输出oid语句调用oid不成功，原因据我分析是：我先读取trade表，给top_trade添加记录，期间又读取trade.order，给top_order添加记录，失败（原因大概是因为之前第一个表未保存？）。

    调整代码后：我先读取trade表，给top_trade添加记录，保存。重新读取trade.order，给top_order添加记录，保存。成功。

 

3、order.count 确实是foxt和net都为0.（之前在net里未作count测试，我看oid读取正常，惯性思维认为count不会为0，浮躁了。）

 

PS：属性都读取出来了，count居然为0，这是神马事啊！我再去找淘宝沟通！

 

 

谢谢狐爸，谢谢无为。