private ProductProperty GetProductProperty(int productId, ChannelMapType mapType)
{
using (var db = new YintaiHZhouContext())
{
if (mapType == ChannelMapType.ColorId)
{
return(db.ProductProperties.FirstOrDefault(p => p.ProductId == productId && p.IsColor.HasValue && p.IsColor.Value));
}
return(db.ProductProperties.FirstOrDefault(p => p.ProductId == productId && p.IsSize.HasValue && p.IsSize.Value));
}
}
public bool UpdateMapByLocal(string localValue, ChannelMapType mapType, string channelValue)
{
using (var db = new YintaiHZhouContext())
{
var channeMap = db.OPC_ChannelMap.FirstOrDefault(c => c.InnerValue == localValue && c.MapType == (int)mapType && c.Channel == SystemDefine.IntimeChannel);
if (channeMap == null)
{
return(false);
}
channeMap.ChannelValue = channelValue;
db.SaveChanges();
return(true);
}
}
private ProductPropertyValue GetProductPropertyValue(int productId, int propertyValueId, ChannelMapType mapType)
{
using (var db = new YintaiHZhouContext())
{
if (mapType == ChannelMapType.ColorId)
{
return(db.ProductProperties.Where(p => p.IsColor.HasValue && p.IsColor.Value && p.ProductId == productId)
.Join(db.ProductPropertyValues, p => p.Id, p => p.PropertyId, (o, p) => p).FirstOrDefault(p => p.Id == propertyValueId));
}
return(db.ProductProperties.Where(p => p.IsSize.HasValue && p.IsSize.Value && p.ProductId == productId)
.Join(db.ProductPropertyValues, p => p.Id, p => p.PropertyId, (o, p) => p).FirstOrDefault(p => p.Id == propertyValueId));
}
}
