淘宝接口调用

 

 private DataTable taobao_crm_members_get(string appkey, string appsecret, string sessionKey)
        {
            DataTable dt = new DataTable();
            long count = 0L;
            int dexIn = 0;
            try
            {
                ITopClient client = new DefaultTopClient(url, appkey, appsecret, "json");
                CrmMembersGetRequest req = new CrmMembersGetRequest();
                req.CurrentPage = 1L;
                req.PageSize = 100L;
                CrmMembersGetResponse response = client.Execute(req, sessionKey);

                if (!response.IsError)
                {
                    count = response.TotalResult;
                    try
                    {
                        do
                        {
                            dexIn++;
                            req.CurrentPage = dexIn;
                            DataSet ds = ToDataSet(response.Body);
                            dt = ds.Tables["basic_member"];//注意这个dataset中的表名，查看自己需要那张表，不然会出现dt为空出现未将对象引用到实列

                        } while (count > 100 * dexIn);
                    }
                    catch (Exception e)
                    {
                        MessageBox.Show("获取会员信息API请求异常" + e.Message);
                    }

                }
                else
                {
                    MessageBox.Show("获取会员信息API请求异常" + response.SubErrCode + "" + response.SubErrMsg);
                }
            }
            catch (Exception e)
            {

            }
            dt.Columns["buyer_nick"].ColumnName = "NICK";
            dt.Columns["buyer_id"].ColumnName = "USER_ID";
            return dt;
        }

 

/// <summary>
        /// json转换为DataSet
        /// </summary>
        /// <param name="json"></param>
        /// <returns></returns>
        private DataSet ToDataSet(string json)
        {
            try
            {
                XmlDocument doc = (XmlDocument)JavaScriptConvert.DeerializeXmlNode(json);
                XmlNodeReader reader = new XmlNodeReader(doc);
                DataSet ds = new DataSet();
                ds.ReadXml(reader);
                return ds;
            }
            catch (Exception e)
            {
                //LogManager.WriteLog("json转换异常，" + e.Message);
                return null;
            }

        }