public List <ProductAttrKeyVModel> GetByCategoryID(int categoryID, bool isSku)
{
Expression <Func <ProductAttrKey, bool> > expression = x => x.ProductCategoryID == categoryID;
if (isSku)
{
expression = x => x.ProductCategoryID == categoryID && x.IsSku == 1;
}
var list = dal.Search(expression);
List <ProductAttrKeyVModel> vList = new List <ProductAttrKeyVModel>();
foreach (var item in list)
{
var vModel = new ProductAttrKeyVModel();
vModel.ID = item.ID;
vModel.AttrName = item.AttrName;
vModel.EnterType = item.EnterType;
vModel.IsImg = item.IsImg;
vModel.AttrValues = new List <string>();
var attrvalues = dalAttrValue.Search(x => x.ProductAttrKeyID == item.ID);
foreach (var valueItem in attrvalues)
{
vModel.AttrValues.Add(valueItem.AttrValue);
}
vList.Add(vModel);
}
return(vList);
}
public ActionResult Add(ProductAttrKeyVModel productAttrKeyVModel)
{
ProductAttrKey productAttrKey = new ProductAttrKey()
{
AttrName = productAttrKeyVModel.AttrName,
OrderNum = productAttrKeyVModel.OrderNum,
EnterType = productAttrKeyVModel.EnterType,
IsSku = 1,
ProductCategoryID = productAttrKeyVModel.ProductCategoryID,
IsImg = productAttrKeyVModel.IsImg
};
attrKeyBLL.Add(productAttrKey);
if (productAttrKeyVModel.AttrValues != null)
{
foreach (var item in productAttrKeyVModel.AttrValues)
{
ProductAttrValue productAttrValue = new ProductAttrValue()
{
AttrValue = item,
ProductAttrKeyID = productAttrKey.ID
};
attrValueBLL.Add(productAttrValue);
}
}
return(Json(new { state = true, msg = "添加成功！" }));
}
public ActionResult Edit(ProductAttrKeyVModel productAttrKeyVModel)
{
ProductAttrKey productAttrKey = new ProductAttrKey()
{
ID = productAttrKeyVModel.ID,
AttrName = productAttrKeyVModel.AttrName,
OrderNum = productAttrKeyVModel.OrderNum,
EnterType = productAttrKeyVModel.EnterType,
IsSku = 1,
ProductCategoryID = productAttrKeyVModel.ProductCategoryID,
IsImg = productAttrKeyVModel.IsImg
};
List <ProductAttrValue> attrValues = new List <ProductAttrValue>();
if (productAttrKeyVModel.AttrValues != null)
{
foreach (var item in productAttrKeyVModel.AttrValues)
{
ProductAttrValue productAttrValue = new ProductAttrValue()
{
AttrValue = item,
ProductAttrKeyID = productAttrKey.ID
};
attrValues.Add(productAttrValue);
}
}
var result = attrKeyBLL.Update(productAttrKey, attrValues);
return(Json(new { state = result > 0, msg = result > 0 ? "修改成功！" : "修改失败！" }));
}
public ActionResult GetWithAttrValuesByCategoryID(int categoryID)
{
var list = attrKeyBLL.Search(x => x.ProductCategoryID == categoryID && x.IsSku == 0);
List <ProductAttrKeyVModel> vList = new List <ProductAttrKeyVModel>();
foreach (var item in list)
{
var vModel = new ProductAttrKeyVModel();
vModel.ID = item.ID;
vModel.AttrName = item.AttrName;
vModel.EnterType = item.EnterType;
vModel.AttrValues = new List <string>();
var attrvalues = attrValueBLL.Search(x => x.ProductAttrKeyID == item.ID);
foreach (var valueItem in attrvalues)
{
vModel.AttrValues.Add(valueItem.AttrValue);
}
vList.Add(vModel);
}
return(Json(vList, JsonRequestBehavior.AllowGet));
}
