/// <summary>
///
/// </summary>
/// <param name="propertyId"></param>
/// <param name="value"></param>
public void CreatePropertyValues(int propertyId, List <string> value)
{
KuanMaiEntities db = new KuanMaiEntities();
try
{
Product_Spec ps = (from prop in db.Product_Spec where prop.Product_Spec_ID == propertyId select prop).FirstOrDefault <Product_Spec>();
if (ps == null)
{
throw new KMJXCException("属性不存在，不能添加属性值");
}
List <Product_Spec_Value> psValues = (from psv in db.Product_Spec_Value where psv.Product_Spec_ID == propertyId select psv).ToList <Product_Spec_Value>();
if (value != null && value.Count > 0)
{
foreach (string v in value)
{
Product_Spec_Value propValue = (from propv in psValues where propv.Name == v select propv).FirstOrDefault <Product_Spec_Value>();
if (propValue == null)
{
propValue = new Product_Spec_Value();
propValue.Product_Spec_ID = propertyId;
propValue.Name = v;
propValue.Mall_PVID = "";
propValue.Created = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
db.Product_Spec_Value.Add(propValue);
}
}
db.SaveChanges();
}
}
catch
{
}
finally
{
if (db != null)
{
db.Dispose();
}
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public Product_Spec CreateNewProperty(int categoryId, string propertyName, List <string> value)
{
Product_Spec ps = null;
if (string.IsNullOrEmpty(propertyName))
{
throw new KMJXCException("属性名称不能为空");
}
KuanMaiEntities db = new KuanMaiEntities();
List <Product_Spec> properties = new List <Product_Spec>();
try
{
var propes = from props in db.Product_Spec where props.Name == propertyName && props.Shop_ID == this.Shop.Shop_ID select props;
if (categoryId > 0)
{
propes.Where(c => c.Product_Class_ID == categoryId);
}
properties = propes.ToList <Product_Spec>();
if (properties.Count > 0)
{
throw new KMJXCException("名为" + propertyName + "已经存在");
}
ps = new Product_Spec();
ps.Product_Class_ID = categoryId;
ps.Shop_ID = this.Shop.Shop_ID;
ps.User_ID = this.CurrentUser.ID;
ps.Name = propertyName;
ps.Created = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
ps.Mall_PID = "";
db.Product_Spec.Add(ps);
db.SaveChanges();
int psId = ps.Product_Spec_ID;
if (psId == 0)
{
throw new KMJXCException("产品属性创建失败");
}
if (value != null)
{
foreach (string v in value)
{
Product_Spec_Value psv = new Product_Spec_Value();
psv.Product_Spec_ID = psId;
psv.Name = v;
psv.Created = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
psv.User_ID = ps.User_ID;
psv.Mall_PVID = "";
}
}
}
catch
{
}
finally
{
if (db != null)
{
db.Dispose();
}
}
return(ps);
}
