public IHttpActionResult FavoritesGet(TbkUatmFavoritesGetRequest req)
{
ITopClient client = new DefaultTopClient(_tbkApiUrl, _appkey, _secret, _format);
TbkUatmFavoritesGetResponse rsp = client.Execute(req);
return(Json(rsp.Body));
}
public void AddTabItems(TbkUatmFavoritesGetResponse itemList)
{
Thread.Sleep(10);
List <Favorites> retsult;
retsult = new List <Favorites>();
foreach (var data in itemList.Results)
{
Favorites temp = new Favorites();
temp.FavoritesId = data.FavoritesId;
temp.FavoritesTitle = data.FavoritesTitle;
temp.Type = data.Type;
if (_favoritItemsDbDal.GetFavorites(data.FavoritesId) == 0)
{
retsult.Add(temp);
}
else
{
_favoritItemsDbDal.UpdateFavorites(temp);
}
}
_favoritItemsDbDal.AddFavorites(retsult);
}
//public ResponseDataList<UatmFavoritItems> GetItemsesList(long typeId, int pageSize = 10, int pageIndex = 1)
//{
// var list = _favoritItemsDbDal.GetFavoritItemsesList(typeId, pageSize, pageIndex);
// return list;
//}
///// <summary>
///// 把淘宝客商品信息数据保存到本地数据库
///// </summary>
///// <param name="info"></param>
///// <returns></returns>
//public bool AddFavoritesDetail(List<TbkFavoritesDetail> info)
//{
// var dataList = new List<UatmFavoritItems>();
// foreach (var temp in info)
// {
// //小图转换成字符串用，隔开
// var strSmallImages = string.Join(",", temp.SmallImages.ToArray());
// var cendTime = Convert.ToDateTime(temp.CouponEndTime);
// var cStartTime = Convert.ToDateTime(temp.CouponStartTime);
// var data = new UatmFavoritItems
// {
// num_iid = temp.NumIid,
// title = temp.Title,
// pic_url = temp.PictUrl,
// small_images = strSmallImages,
// reserve_price = Convert.ToDouble(temp.ReservePrice),
// zk_final_price = Convert.ToDouble(temp.ZkFinalPrice),
// provcity = temp.Provcity,
// item_url = temp.ItemUrl,
// click_url = temp.ClickUrl,
// nick = temp.Nick,
// seller_id = temp.SellerId,
// volume = temp.Volume,
// tk_rate = Convert.ToDouble(temp.TkRate),
// zk_final_price_wap = Convert.ToDouble(temp.ZkFinalPriceWap),
// category = temp.Category,
// coupon_click_url = temp.CouponClickUrl,
// coupon_end_time = cendTime,
// coupon_info = temp.CouponInfo,
// coupon_start_time = cStartTime,
// coupon_total_count = temp.CouponTotalCount,
// coupon_remain_count = temp.CouponRemainCount,
// commission_rate = temp.CommissionRate,
// event_end_time = temp.EventEndTime,
// event_start_time = temp.EventStartTime,
// shop_title = temp.ShopTitle,
// status = temp.Status,
// type = temp.Type
// };
// dataList.Add(data);
// }
// var isSuccess = _favoritItemsDbDal.AddTbItemsList(dataList);
// return isSuccess;
//}
///// <summary>
///// 添加选品库信息到本地数据库
///// </summary>
///// <param name="info"></param>
///// <returns></returns>
//public bool AddTbItemsList(List<TbkFavorites> info)
//{
// var datalist = new List<TBItemsList>();
// foreach (var temp in info)
// {
// //var data = new TBItemsList
// //{
// // type = temp.Type,
// // favorites_id = temp.FavoritesId,
// // favorites_title = temp.FavoritesTitle
// //};
// //datalist.Add(data);
// }
// var isSuccess = _favoritItemsDbDal.AddTbItemsList(datalist);
// return isSuccess;
//}
#endregion
/// <summary>
/// 淘宝联盟后台获取分类信息
/// </summary>
/// <returns></returns>
public ResponseDataList <TbkFavorites> GetTaoBaoFavorites()
{
var responseresult = new TbkUatmFavoritesGetResponse();
var result = new ResponseDataList <TbkFavorites>();
TaoBaoClient taoBaoClient = new TaoBaoClient();
TbkUatmFavoritesGetRequest req = new TbkUatmFavoritesGetRequest
{
PageNo = 1L,
PageSize = 50L,
Fields = "favorites_title,favorites_id,type",
Type = 1L
};
try
{
responseresult = taoBaoClient.GetTaoBaoFavorites(req);
if (responseresult.IsError)
{
LogHelper.Error(responseresult.ErrMsg);
return(null);
}
result.Count = responseresult.TotalResults;
result.DataList = responseresult.Results;
//开一个线程插入数据库
//System.Threading.Tasks.Task.Run(() => AddTabItems(responseresult));
}
catch (Exception ex)
{
LogHelper.Exception(ex);
}
return(result);
}
public ActionResult SynchronizationFavorites(long?pageno = 1L)
{
try
{
ITopClient client = new DefaultTopClient(AliPayConfig.tkapp_url, AliPayConfig.tkapp_key, AliPayConfig.tkapp_secret, "json");
TbkUatmFavoritesGetRequest req = new TbkUatmFavoritesGetRequest();
req.PageNo = pageno;
req.PageSize = 100L;
req.Fields = "favorites_title,favorites_id,type";
req.Type = -1L;
TbkUatmFavoritesGetResponse rsp = client.Execute(req);
//Console.WriteLine(rsp.Body);
var bodys = rsp.Body;
//List<tempfavorites> sdudentList4 = Comm.DeserializeJsonToList<tempfavorites>("[{\"ID\":\"112\",\"Name\":\"石子儿\"}]");
var jsondataformain = Newtonsoft.Json.JsonConvert.DeserializeObject(bodys) as JContainer;//转json格式
string s = jsondataformain.SelectToken("tbk_uatm_favorites_get_response").ToString();
var js = Newtonsoft.Json.JsonConvert.DeserializeObject(s) as JContainer;
string s1 = js.SelectToken("results").ToString();
int total = Convert.ToInt32(js.SelectToken("total_results"));//总数
var js1 = Newtonsoft.Json.JsonConvert.DeserializeObject(s1) as JContainer;
string s2 = js1.SelectToken("tbk_favorites").ToString();
var js2 = Newtonsoft.Json.JsonConvert.DeserializeObject(s2) as JContainer;
if (js2.Count > 0)
{
for (int j = 0; j < js2.Count; j++)
{
string tempid = js2[j].SelectToken("favorites_id").ToString();
if (!db.tb_Favorites.Any(d => d.FavoritesID == tempid))
{
var model = new tb_Favorites
{
FavoritesID = tempid,
Type = FavoritesType.Ordinary,
Name = js2[j].SelectToken("favorites_title").ToString(),
Explain = "淘宝同步选品库",
ImagePath = ""
};
db.tb_Favorites.Add(model);
db.SaveChanges();
}
if (j == js2.Count - 1 && (total - 100) > 0 && pageno < 2)
{
SynchronizationFavorites(2L);
}
}
}
return(Json(Comm.ToJsonResult("Success", "成功"), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(View());
}
}
public Favorites GetFavorites(TbkUatmFavoritesGetResponse rsp, int row)
{
Favorites favorites = new Favorites();
favorites.FavoritesId = rsp.Results[row].FavoritesId;
favorites.FavoritesTitle = rsp.Results[row].FavoritesTitle;
favorites.Type = rsp.Results[row].Type;
favorites.TotalResults = rsp.TotalResults;
return(favorites);
}
public IList <Favorites> AddToIlist(IList <Favorites> list, TbkUatmFavoritesGetResponse rsp)
{
for (int row = 0; row < rsp.Results.Count; row++)
{
Favorites favorites = new Favorites();
favorites.FavoritesId = rsp.Results[row].FavoritesId;
favorites.FavoritesTitle = rsp.Results[row].FavoritesTitle;
favorites.Type = rsp.Results[row].Type;
favorites.TotalResults = rsp.TotalResults;
list.Add(favorites);
}
return(list);
}
/// <summary>
/// taobao.tbk.uatm.favorites.get( 获取淘宝联盟选品库列表 )
/// </summary>
public static void QueryUatmFavorites()
{
var client = GetClient();
TbkUatmFavoritesGetRequest req = new TbkUatmFavoritesGetRequest();
req.PageNo = 1L;
req.PageSize = 20L;
req.Fields = "favorites_title,favorites_id,type";
req.Type = 1L;//默认值-1；选品库类型，1：普通选品组，2：高佣选品组，-1，同时输出所有类型的选品组
TbkUatmFavoritesGetResponse rsp = client.Execute(req);
Console.WriteLine(rsp.Body);
}
public ActionResult GetFavoritesList()
{
ITopClient client = new DefaultTopClient(AliPayConfig.tkapp_url, AliPayConfig.tkapp_key, AliPayConfig.tkapp_secret, "json");
TbkUatmFavoritesGetRequest req = new TbkUatmFavoritesGetRequest();
req.PageNo = 1L;
req.PageSize = 20L;
req.Fields = "favorites_title,favorites_id,type";
req.Type = -1L;
TbkUatmFavoritesGetResponse rsp = client.Execute(req);
//Console.WriteLine(rsp.Body);
var returndata = new
{
body = rsp.Body
};
return(Json(Comm.ToJsonResult("Success", "成功", returndata), JsonRequestBehavior.AllowGet));
//return View();
}
public IList <Favorites> GetIList(long pageNo, long pageSize, Diploma diploma)
{
TbkUatmFavoritesGetResponse rsp = new TbkUatmFavoritesGetResponse();
IList <Favorites> list = new List <Favorites>();
rsp = GetByPageNoSize(pageNo, pageSize, diploma);
if (rsp.TotalResults > 100)
{
list = AddToIlist(list, GetByPageNoSize(pageNo, pageSize, diploma));
list = AddToIlist(list, GetByPageNoSize(pageNo + 1, pageSize, diploma));
}
else
{
list = AddToIlist(list, GetByPageNoSize(pageNo, pageSize, diploma));
}
return(list);
throw new NotImplementedException();
}
public IEnumerable <Favorite> getFavoriteList(string fields = "favorites_title,favorites_id,type", int page_no = 1, int page_size = 200, int type = -1)
{
TbkUatmFavoritesGetRequest req = new TbkUatmFavoritesGetRequest();
//req.Fields = fields == FavoritesFields.all ? FavoritesFields.favorites_id.ToString() + "," + FavoritesFields.favorites_title.ToString() + "," + FavoritesFields.type.ToString() : fields.ToString();
req.Fields = fields;
req.PageNo = page_no;
req.PageSize = page_size;
req.Type = type;
TbkUatmFavoritesGetResponse response = topClient.Execute(req);
JToken tokenList = JsonConvert.DeserializeObject <JObject>(response.Body)["tbk_uatm_favorites_get_response"]["results"]["tbk_favorites"];
foreach (JToken item in tokenList)
{
yield return(new Favorite()
{
favorites_id = Convert.ToInt64(item["favorites_id"].ToString()),
favorites_title = item["favorites_title"].ToString(),
type = Convert.ToInt64(item["type"].ToString())
});
}
}
