/// <summary> /// 商品信息同步 /// </summary> /// <returns></returns> public async Task ProductSync() { string reqURL = "http://commerce.vapps.com.cn/catalog/CategoryProductJsons?categoryId=0&PageSize=1000"; var httpClient = new HttpClient(); CacheControlHeaderValue cacheControl = new CacheControlHeaderValue(); cacheControl.NoCache = true; cacheControl.NoStore = true; httpClient.DefaultRequestHeaders.CacheControl = cacheControl; try { var response = await httpClient.GetAsync(new Uri(reqURL)); var jsonResultString = await response.Content.ReadAsStringAsync(); JObject products = ((JObject)JToken.Parse(jsonResultString)["data"]); //return value; var productList = products["Data"].ToList().OrderBy(p => p["Id"]); foreach (JObject productJson in productList) { var productDetailResponse = await httpClient.GetAsync(new Uri($"http://commerce.vapps.com.cn/product/ProductDetailJson?productId={productJson["Id"]}")); var productDetailJsonResultString = await productDetailResponse.Content.ReadAsStringAsync(); JObject productsDetail = (JObject)JToken.Parse(productDetailJsonResultString)["data"]; var sku = productsDetail["Sku"].ToString(); var product = await _productManager.FindBySkuAsync(sku); if (product != null) { continue; } var productDto = new CreateOrUpdateProductInput() { Name = productsDetail["Name"].ToString(), Price = Decimal.Parse(productsDetail["ProductPrice"]["PriceValue"].ToString()), GoodCost = Decimal.Parse(productsDetail["ProductPrice"]["Cost"].ToString()), //Height = Decimal.Parse(productsDetail["Height"].ToString().IsNullOrWhiteSpace() ? "0" : productsDetail["Height"].ToString()), //Weight = Decimal.Parse(productsDetail["Weight"].ToString().IsNullOrWhiteSpace() ? "0" : productsDetail["Weight"].ToString()), //Width = Decimal.Parse(productsDetail["Width"].ToString().IsNullOrWhiteSpace() ? "0" : productsDetail["Width"].ToString()), //Length = Decimal.Parse(productsDetail["Length"].ToString().IsNullOrWhiteSpace() ? "0" : productsDetail["Length"].ToString()), Sku = sku, StockQuantity = 0, ShortDescription = productsDetail["ShortDescription"].ToString(), }; // 同步分类 var categoryJsons = productsDetail["Breadcrumb"]["CategoryBreadcrumb"]; if (!categoryJsons.IsNullOrEmpty()) { foreach (JObject categoryJson in categoryJsons.ToList()) { var categoryName = categoryJson["Name"].ToString(); var category = await _categoryManager.FindByNameAsync(categoryName); if (category == null) { category = new Category() { Name = categoryName, } } ; if (category.Id == 0) { await _categoryManager.CreateAsync(category); await CurrentUnitOfWork.SaveChangesAsync(); } productDto.Categories.Add(new ProductCategoryDto() { Id = category.Id }); } } // 图片 var defaultPictureUrl = ((JObject)productsDetail["DefaultPictureModel"])["FullSizeImageUrl"].ToString(); if (!defaultPictureUrl.IsNullOrWhiteSpace()) { var picture = await _pictureManager.FetchPictureAsync(defaultPictureUrl, (long)DefaultGroups.ProductPicture); productDto.Pictures.Add(new ProductPictureDto() { Id = picture.Id, }); } //商品属性 var attributeJsons = productsDetail["ProductAttributes"]; if (!attributeJsons.IsNullOrEmpty()) { foreach (JObject attributeJson in attributeJsons.ToList()) { var attributeName = attributeJson["Name"].ToString(); // 属性值 var attributeValueJsons = attributeJson["Values"]; if (attributeValueJsons.IsNullOrEmpty()) { continue; } var attribute = await _productAttributeManager.FindByNameAsync(attributeName); if (attribute == null) { attribute = new ProductAttribute() { Name = attributeName, }; await _productAttributeManager.CreateAsync(attribute); await CurrentUnitOfWork.SaveChangesAsync(); } var attributeDto = new ProductAttributeDto() { Id = attribute.Id, Name = attributeJson["Id"].ToString() }; // 属性值 foreach (JObject attributeValueJson in attributeValueJsons.ToList()) { var attributeValueName = attributeValueJson["Name"].ToString(); var pAttributeValue = await _productAttributeManager.FindPredefinedValueByNameAsync(attribute.Id, attributeValueName); if (pAttributeValue == null) { pAttributeValue = new PredefinedProductAttributeValue() { Name = attributeValueName, ProductAttributeId = attribute.Id, }; await _productAttributeManager.CreateOrUpdatePredefinedValueAsync(pAttributeValue); await CurrentUnitOfWork.SaveChangesAsync(); } attributeDto.Values.Add(new ProductAttributeValueDto() { Id = pAttributeValue.Id, Name = attributeValueJson["Id"].ToString(), PictureUrl = attributeValueJson["CostAdjustment"].ToString(), }); } productDto.Attributes.Add(attributeDto); } } // 属性组合 if (!productDto.Attributes.IsNullOrEmpty()) { for (int index = 0; index < productDto.Attributes[0].Values.Count; index++) { var deserializeSettings = new JsonSerializerSettings { ObjectCreationHandling = ObjectCreationHandling.Replace }; var attribute = JsonConvert.DeserializeObject <ProductAttributeDto>(JsonConvert.SerializeObject(productDto.Attributes[0]), deserializeSettings); attribute.Values = new List <ProductAttributeValueDto>(); attribute.Values.Add(productDto.Attributes[0].Values[index]); //var combin = new AttributeCombinationDto(); //combin.Attributes.Add(attribute); if (productDto.Attributes.Count() >= 2) { for (int i = 0; i < productDto.Attributes[1].Values.Count; i++) { var attribute1 = JsonConvert.DeserializeObject <ProductAttributeDto>(JsonConvert.SerializeObject(productDto.Attributes[1]), deserializeSettings); attribute1.Values = new List <ProductAttributeValueDto>(); attribute1.Values.Add(productDto.Attributes[1].Values[i]); if (productDto.Attributes.Count() >= 3) { for (int j = 0; j < productDto.Attributes[2].Values.Count; j++) { var attribute2 = JsonConvert.DeserializeObject <ProductAttributeDto>(JsonConvert.SerializeObject(productDto.Attributes[2]), deserializeSettings); attribute2.Values = new List <ProductAttributeValueDto>(); attribute2.Values.Add(productDto.Attributes[2].Values[j]); var combin = new AttributeCombinationDto(); combin.Attributes.Add(attribute); combin.Attributes.Add(attribute1); combin.Attributes.Add(attribute2); productDto.AttributeCombinations.Add(combin); } } else { var combin = new AttributeCombinationDto(); combin.Attributes.Add(attribute); combin.Attributes.Add(attribute1); productDto.AttributeCombinations.Add(combin); } } } else { var combin = new AttributeCombinationDto(); combin.Attributes.Add(attribute); productDto.AttributeCombinations.Add(combin); } } } string combinURL = "http://commerce.vapps.com.cn/product/GetStockByDropAndDropJson"; foreach (var combin in productDto.AttributeCombinations) { var para = combin.Attributes.Select(c => { return(new { ProductAttrbuteId = Convert.ToInt32(c.Name), ProductAttrbuteValueId = Convert.ToInt32(c.Values[0].Name) }); }).ToList(); var data = new { productId = Convert.ToInt32(productsDetail["Id"].ToString()), paramDictionary = para }; HttpContent content = new StringContent(JsonConvert.SerializeObject(data)); content.Headers.ContentType = new System.Net.Http.Headers.MediaTypeHeaderValue("application/json"); var combinResponse = await httpClient.PostAsync(new Uri(combinURL), content); var combinJsonResultString = await combinResponse.Content.ReadAsStringAsync(); if (combinJsonResultString.IsNullOrWhiteSpace()) { continue; } JObject combinDetail = ((JObject)JToken.Parse(combinJsonResultString)); combin.Sku = combinDetail["Sku"].ToString(); if (!combin.Attributes[0].Values[0].PictureUrl.IsNullOrWhiteSpace()) { combin.OverriddenGoodCost = decimal.Parse(combin.Attributes[0].Values[0].PictureUrl); } } await CreateOrUpdateProduct(productDto); } } catch (Exception ex) { } finally { httpClient.Dispose(); } }