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)); } }