public OPC_Stock Sync(int skuId, ProductDto product)
{
using (var db = new YintaiHZhouContext())
{
/**
* 库存同步逻辑
* 1. 检查门店信息
* 2. 检查商品Id映射关系
*/
// 同步门店相关信息
var sectionExt = _sectionSyncProcessor.Sync(product.SectionId, product.StoreNo);
if (sectionExt == null)
{
Log.ErrorFormat("同步库存时发生错误,专柜sectionId:{0}不存在", product.SectionId);
return(null);
}
// 获取单品信息
var skuExt = db.OPC_SKU.FirstOrDefault(s => s.Id == skuId);
if (skuExt == null)
{
Log.ErrorFormat("单品id:{0}不存在,请排查数据", skuId);
return(null);
}
// 检查库存信息,进行价格和库存更新
var stockExt = db.OPC_Stock.FirstOrDefault(s => s.SkuId == skuExt.Id && s.SectionId == sectionExt.Id);
if (stockExt == null)
{
var newStock = new OPC_Stock()
{
SkuId = skuExt.Id,
SectionId = sectionExt.Id,
Price = product.CurrentPrice,
Count = Convert.ToInt32(decimal.Floor(product.Stock ?? 0)),
SourceStockId = product.ProductId,
ProdSaleCode = product.PosCode,
ProductName = product.ProductName,
SectionCode = product.SectionId,
StoreCode = product.StoreNo,
ProductCode = product.ProductCode,
Status = 1,
IsDel = false,
CreatedDate = DateTime.Now,
CreatedUser = SystemDefine.SystemUser,
UpdatedUser = SystemDefine.SystemUser,
UpdatedDate = DateTime.Now,
LabelPrice = product.LabelPrice
};
db.OPC_Stock.Add(newStock);
db.SaveChanges();
Log.TraceFormat("单品id:{1}创建成功", skuId);
return(newStock);
}
stockExt.Price = product.CurrentPrice;
stockExt.LabelPrice = product.LabelPrice;
stockExt.Count = Convert.ToInt32(decimal.Floor(product.Stock ?? 0));
stockExt.SourceStockId = product.ProductId;
stockExt.ProdSaleCode = product.PosCode;
stockExt.CreatedDate = DateTime.Now;
stockExt.CreatedUser = SystemDefine.SystemUser;
stockExt.UpdatedDate = DateTime.Now;
stockExt.UpdatedUser = SystemDefine.SystemUser;
// 保存更新价格
db.SaveChanges();
Log.TraceFormat("单品id:{1}更新成功", skuId);
return(stockExt);
}
}
public Domain.Models.Product Sync(ProductDto channelProduct)
{
/**
* 首先同步相关信息
* 1. 同步品牌
* 2. 同步分类
* 3. 同步专柜及门店
* 4. 同步商品基本信息
*/
/**
* 检查并同步专柜, 同步专柜信息时同时会同步门店信息，在此无需再同步门店
*/
var section = _sectionSyncProcessor.Sync(channelProduct.SectionId, channelProduct.StoreNo);
if (section == null)
{
Log.ErrorFormat("同步商品对应专柜失败:productId:[{0}]，sectionId:[1],stroeNo:[{2}]", channelProduct.ProductId, channelProduct.SectionId, channelProduct.StoreNo);
return(null);
}
/**
* 检查并同步品牌,目前集团的商品只有品牌名称，所以同步商品不成功，只是提供警告
*/
var brand = _brandSyncProcessor.SyncBrand(channelProduct.BrandId, channelProduct.BrandName);
if (brand == null)
{
var channelMap = _channelMapper.GetMapByChannelValue(channelProduct.BrandName, ChannelMapType.Brand);
if (channelMap == null)
{
//品牌没有的，按所属专柜在查找，如果没有的，如果有则关联此品牌；如果没有，则依据专柜创建品牌并关联
using (var db = new YintaiHZhouContext())
{
brand =
db.Brands.Where(
b =>
b.Name.Trim().ToUpper() == section.Name.Trim().ToUpper() ||
b.EnglishName.Trim().ToUpper() == section.Name.Trim().ToUpper() && b.Status == 1)
.OrderByDescending(x => x.Id)
.FirstOrDefault();
if (brand == null)
{
/**
* 品牌映射关系不存在，
*
* 1. 创建新品牌
* 2. 保存映射关系
*/
var newBrand = new Brand()
{
//ChannelBrandId = brandSource.BrandId,
Name = section.Name,
EnglishName = string.Empty,
Logo = string.Empty,
Status = 1,
Description = string.Empty,
Group = string.Empty,
WebSite = string.Empty,
CreatedDate = DateTime.Now,
CreatedUser = SystemDefine.SystemUser,
UpdatedDate = DateTime.Now,
UpdatedUser = SystemDefine.SystemUser,
};
// 添加品牌并保持
brand = db.Brands.Add(newBrand);
db.SaveChanges();
}
else
{
if (brand.Status != 1)
{
brand.Status = 1;
brand.UpdatedDate = DateTime.Now;
db.SaveChanges();
}
}
// 添加映射关系
var newChannelMap = new ChannelMap()
{
LocalId = brand.Id,
ChannnelValue = section.Name.Trim().ToUpper(),
MapType = ChannelMapType.Brand
};
_channelMapper.CreateMap(newChannelMap);
}
}
else
{
using (var db = new YintaiHZhouContext())
{
brand = db.Brands.FirstOrDefault(x => x.Id == channelMap.LocalId);
}
}
Log.WarnFormat("同步商品对应品牌失败:ProductId:[{0}],brandId:[{1}],brandName:[{2}]", channelProduct.ProductId, channelProduct.BrandId, channelProduct.BrandName);
}
using (var db = new YintaiHZhouContext())
{
if (!db.IMS_SectionBrand.Any(x => x.BrandId == brand.Id && x.SectionId == section.Id))
{
var sb = new IMS_SectionBrand()
{
BrandId = brand.Id,
SectionId = section.Id
};
db.IMS_SectionBrand.Add(sb);
db.SaveChanges();
}
}
/**
* 检查并同步分类,目前集团分类信息为空，所以同步商品不成功，只是提供警告
*/
var category = _categorySyncProcessor.Sync(channelProduct.CategoryId4, channelProduct.Category4);
if (category == null)
{
//如果分类为空，设置一个默认值
Log.WarnFormat("同步商品对应分类失败:[{0}],categoryId:[{1}],category:[{2}]", channelProduct.ProductId, channelProduct.CategoryId4, channelProduct.Category4);
}
var tagId = FetchTagId(channelProduct);
int catid;
if (!string.IsNullOrEmpty(channelProduct.CategoryId4))
{
int.TryParse(channelProduct.CategoryId4, out catid);
}
else
{
catid = 0;
}
using (var db = new YintaiHZhouContext())
{
/**
* 同步商品基本信息,
* 说明 productId为商品唯一标识
* productCode为商品的款编号
* 商品款号加上品牌id唯一标识
*/
var mapKey = string.Format("{1}-{0}", channelProduct.ProductCode, brand.Id);
var productCodeMap = _channelMapper.GetMapByChannelValue(mapKey, ChannelMapType.ProductCode);
if (productCodeMap == null)
{
var newProduct = new Domain.Models.Product()
{
ProductType = 1,
Brand_Id = brand.Id,
Name = string.IsNullOrEmpty(channelProduct.ProductName) ? string.Format("{0}-{1}", brand.Name, channelProduct.ProductCode) : channelProduct.ProductName,
UnitPrice = channelProduct.LabelPrice,
Store_Id = section.StoreId ?? 0,
Price = channelProduct.CurrentPrice,
Description = string.Empty,
SkuCode = channelProduct.ProductCode,
Is4Sale = false, //商品属性同步完成了，设置为true
RecommendedReason = string.Empty,
RecommendUser = DEFAULT_OWNER_ID,
SortOrder = 0,
Status = 1,
Tag_Id = tagId,
BarCode = string.Empty,
Favorable = "1",
UpdatedDate = DateTime.Now,
UpdatedUser = DEFAULT_OWNER_ID,
CreatedDate = DateTime.Now,
CreatedUser = DEFAULT_OWNER_ID,
};
newProduct = db.Products.Add(newProduct);
db.SaveChanges();
// 保存映射关系
_channelMapper.CreateMap(new ChannelMap()
{
LocalId = newProduct.Id,
ChannnelValue = mapKey,
MapType = ChannelMapType.ProductCode
});
// 保存本地商品Id和渠道的对应的关系，用于如更新图片等功能的使用
_channelMapper.CreateMap(new ChannelMap()
{
LocalId = newProduct.Id,
ChannnelValue = channelProduct.ProductId,
MapType = ChannelMapType.ProductId
});
if (catid > 0)
{
CreateProductMap(channelProduct, newProduct.Id, catid);
}
return(newProduct);
}
var proudctExt = db.Products.FirstOrDefault(p => p.Id == productCodeMap.LocalId);
if (proudctExt == null)
{
Log.ErrorFormat("商品productId:[{0}],productcode:[{1}],存在映射关系，商品数据不存在", channelProduct.ProductId, channelProduct.ProductCode);
return(null);
}
var productMap = _channelMapper.GetMapByChannelValue(channelProduct.ProductId, ChannelMapType.ProductId);
if (productMap == null)
{
// 保存本地商品Id和渠道的对应的关系，用于如更新图片等功能的使用
_channelMapper.CreateMap(new ChannelMap()
{
LocalId = proudctExt.Id,
ChannnelValue = channelProduct.ProductId,
MapType = ChannelMapType.ProductId
});
}
//proudctExt.BarCode = string.Empty;
proudctExt.Store_Id = section.StoreId ?? 0;
proudctExt.Brand_Id = brand == null ? 0 : brand.Id;
proudctExt.Tag_Id = tagId;
proudctExt.SkuCode = channelProduct.ProductCode;
proudctExt.Name = string.IsNullOrEmpty(channelProduct.ProductName) ? string.Format("{0}-{1}", brand.Name, channelProduct.ProductCode) : channelProduct.ProductName;
proudctExt.UnitPrice = channelProduct.LabelPrice;
proudctExt.Price = channelProduct.CurrentPrice;
//proudctExt.Description = string.Empty;
//proudctExt.RecommendedReason = string.Empty;
proudctExt.UpdatedDate = DateTime.Now;
proudctExt.UpdatedUser = DEFAULT_OWNER_ID;
if (catid > 0 && !db.ProductMaps.Any(x => x.Channel == SystemDefine.IntimeChannel && x.ProductId == proudctExt.Id))
{
CreateProductMap(channelProduct, proudctExt.Id, catid);
}
db.SaveChanges();
return(proudctExt);
}
}