/// <summary> /// 把淘宝联盟拉下来的数据添加到本地数据库 /// </summary> /// <param name="info"></param> /// <param name="favoritesId"></param> public void AddItems(TbkUatmFavoritesItemGetResponse info, long favoritesId) { Thread.Sleep(10); List <UatmFavoritItems> result = new List <UatmFavoritItems>(); foreach (var data in info.Results) { UatmFavoritItems ufItem = new UatmFavoritItems(); var strSmallImages = string.Join(",", data.SmallImages.ToArray()); ufItem.NumIid = data.NumIid; ufItem.Category = data.Category; ufItem.ClickUrl = data.ClickUrl; ufItem.CommissionRate = data.CommissionRate; ufItem.CouponClickUrl = data.CouponClickUrl; //ufItem.coupon_end_time = Convert.ToDateTime(data.CouponEndTime); ufItem.CouponInfo = data.CouponInfo; ufItem.CouponRemainCount = data.CouponRemainCount; //ufItem.coupon_start_time = Convert.ToDateTime(data.CouponStartTime); ufItem.CouponTotalCount = data.CouponTotalCount; //ufItem.event_end_time = data.EventEndTime; //ufItem.event_start_time = data.EventStartTime; ufItem.ItemUrl = data.ItemUrl; ufItem.Nick = data.Nick; ufItem.PictUrl = data.PictUrl; ufItem.Provcity = data.Provcity; ufItem.ReservePrice = Convert.ToDouble(data.ReservePrice); ufItem.SellerId = data.SellerId; ufItem.ShopTitle = data.ShopTitle; ufItem.SmallImages = strSmallImages; ufItem.Title = data.Title; ufItem.Status = data.Status; ufItem.ItemUrl = data.ItemUrl; ufItem.TkRate = Convert.ToDouble(data.TkRate); ufItem.Type = data.Type; ufItem.UserType = data.UserType; ufItem.Volume = data.Volume; ufItem.ZkFinalPrice = Convert.ToDouble(data.ZkFinalPrice); ufItem.ZkFinalPriceWap = Convert.ToDouble(data.ZkFinalPriceWap); ufItem.FavoritesTitle = _favoritItemsDbDal.GetTitle(favoritesId).FavoritesTitle; ufItem.FavoritesId = favoritesId; ufItem.CreateTime = DateTime.Now; //判断下数据库存不存在当前物品 if (_favoritItemsDbDal.GetNumiid(data.NumIid) == 0) { result.Add(ufItem); } else { //存在就更新 _favoritItemsDbDal.UpdateItem(ufItem); } } _favoritItemsDbDal.AddTbItemsList(result); }
public bool UpdateItem(UatmFavoritItems item) { EconomicalleagueEntity.UatmFavoritItems.AddOrUpdate(item); EconomicalleagueEntity.SaveChanges(); return(true); }