//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 IHttpActionResult FavoritesGet(TbkUatmFavoritesGetRequest req)
{
ITopClient client = new DefaultTopClient(_tbkApiUrl, _appkey, _secret, _format);
TbkUatmFavoritesGetResponse rsp = client.Execute(req);
return(Json(rsp.Body));
}
/// <summary>
/// 淘宝联盟分类信息
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public TbkUatmFavoritesGetResponse GetTaoBaoFavorites(TbkUatmFavoritesGetRequest req)
{
if (req == null)
{
return(null);
}
return(Client.Execute(req));
}
public void Execute(IJobExecutionContext context)
{
log.log("开始执行Job任务" + "----" + DateTime.Now.ToString(CultureInfo.InvariantCulture));
log.log("获取淘宝联盟后台分类id" + "----" + DateTime.Now.ToString(CultureInfo.InvariantCulture));
TaoBaoClient taoBaoClient = new TaoBaoClient();
TbkUatmFavoritesGetRequest req = new TbkUatmFavoritesGetRequest
{
PageNo = 1L,
PageSize = 50L,
Fields = "favorites_title,favorites_id,type",
Type = 1L
};
var responseresulttap = taoBaoClient.GetTaoBaoFavorites(req);
_favoritItemsSrv.AddTabItems(responseresulttap);
foreach (var data in responseresulttap.Results)
{
log.log("循环淘宝联盟后台分类id" + "----" + data.FavoritesId);
//var result = _favoritItemsSrv.GetTaoBaoFavoritesItemsListAsync(data.FavoritesId);
TbkUatmFavoritesItemGetResponse responseresult;
var result = new ResponseDataList <UatmTbkItem>();
var uid = Convert.ToInt64(TaoBaoConfig.UId);
TbkUatmFavoritesItemGetRequest req2 = new TbkUatmFavoritesItemGetRequest()
{
AdzoneId = uid,
FavoritesId = data.FavoritesId,
Fields = "num_iid,title,pict_url,small_images,reserve_price,zk_final_price,user_type,provcity,item_url,click_url,seller_id,volume,nick,shop_title,zk_final_price_wap,event_start_time,event_end_time,tk_rate,status,type,coupon_info,commission_rate,coupon_click_url,coupon_end_time",
PageNo = 1,
PageSize = 500
};
responseresult = taoBaoClient.GetFavoritesList(req2);
responseresult.Results = responseresult.Results.Where(x => x.CouponInfo != null).ToList();
//查找每一个商品到券信息
foreach (var tamp in responseresult.Results)
{
//var coupon = GetCouponInfo(data.NumIid);
var coupon = tamp.CouponInfo.Split('减')[1].Substring(0, tamp.CouponInfo.Split('减')[1].IndexOf("元", StringComparison.Ordinal));
var index = responseresult.Results.IndexOf(tamp);
if (!string.IsNullOrEmpty(coupon) && Convert.ToDouble(tamp.ZkFinalPrice) > Convert.ToDouble(coupon))
{
responseresult.Results[index].CouponInfo = coupon;
}
else
{
responseresult.Results[index].CouponInfo = "0";
}
log.log("插入数据库的物品id" + "----" + tamp.NumIid);
}
_favoritItemsSrv.AddItems(responseresult, data.FavoritesId);
log.log("插入数据库的列表id" + "----" + data.FavoritesId);
}
}
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 isExist(long FavoritesId)
//{
// throw new NotImplementedException();
//}
public TbkUatmFavoritesGetResponse GetByPageNoSize(long pageNo, long pageSize, Diploma diploma)
{
TbkUatmFavoritesGetRequest req = new TbkUatmFavoritesGetRequest();
req.PageNo = pageNo; //第几页，从1开始计数
req.PageSize = pageSize; //默认20，页大小，即每一页的活动个数
req.Fields = "favorites_title,favorites_id,type"; //需要返回的字段列表，不能为空，字段名之间使用逗号分隔
req.Type = 1L; //默认值-1；选品库类型，1：普通选品组，2：高佣选品组，-1，同时输出所有类型的选品组
return(Tools.Taobao.DefaultTopClient.Get(diploma.AppUrl, diploma.AppKey, diploma.AppSecret).Execute(req));
}
public TbkUatmFavoritesGetResponse GetFavorites(int pageSize = 50, int page = 1, int type = -1)
{
TbkUatmFavoritesGetRequest req = new TbkUatmFavoritesGetRequest();
req.PageNo = page;
req.PageSize = pageSize;
req.Fields = "favorites_title,favorites_id,type";
req.Type = type;
return(_client.Execute(req));
}
public static TbkUatmFavoritesGetResponse GetXuanpinku()
{
string url = "http://gw.api.taobao.com/router/rest";
ITopClient client = new DefaultTopClient(url, Alimama.appkey, Alimama.secret);
TbkUatmFavoritesGetRequest req = new TbkUatmFavoritesGetRequest();
req.PageNo = 1L;
req.PageSize = 50L;
req.Fields = "favorites_title,favorites_id,type";
//req.Type = 1L;
return(client.Execute(req));
}
/// <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 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())
});
}
}
