/// <summary>
/// 通过IDataReader创建AttributeGroupInfo信息
/// </summary>
public static AttributeGroupInfo BuildAttributeGroupFromReader(IDataReader reader)
{
AttributeGroupInfo attributeGroupInfo = new AttributeGroupInfo();
attributeGroupInfo.AttrGroupId = TypeHelper.ObjectToInt(reader["attrgroupid"]);
attributeGroupInfo.CateId = TypeHelper.ObjectToInt(reader["cateid"]);
attributeGroupInfo.Name = reader["name"].ToString();
attributeGroupInfo.DisplayOrder = TypeHelper.ObjectToInt(reader["displayorder"]);
return attributeGroupInfo;
}
public ActionResult AddAttributeGroup(AttributeGroupModel model, int cateId = -1)
{
CategoryInfo categoryInfo = AdminCategories.GetCategoryById(cateId);
if (categoryInfo == null)
return PromptView("分类不存在");
if (AdminCategories.GetAttributeGroupIdByCateIdAndName(cateId, model.AttributeGroupName) > 0)
ModelState.AddModelError("AttributeGroupName", "名称已经存在");
if (ModelState.IsValid)
{
AttributeGroupInfo attributeGroupInfo = new AttributeGroupInfo()
{
Name = model.AttributeGroupName,
CateId = categoryInfo.CateId,
DisplayOrder = model.DisplayOrder
};
AdminCategories.CreateAttributeGroup(attributeGroupInfo);
AddAdminOperateLog("添加属性分组", "添加属性分组,属性分组为:" + model.AttributeGroupName);
return PromptView("属性分组添加成功");
}
ViewData["cateId"] = categoryInfo.CateId;
ViewData["categoryName"] = categoryInfo.Name;
ViewData["referer"] = ShopUtils.GetAdminRefererCookie();
return View(model);
}
/// <summary>
/// 创建属性分组
/// </summary>
public static void CreateAttributeGroup(AttributeGroupInfo attributeGroupInfo)
{
BrnShop.Data.Categories.CreateAttributeGroup(attributeGroupInfo);
}
/// <summary>
/// 创建属性
/// </summary>
/// <param name="attributeInfo">属性信息</param>
/// <param name="attributeGroupInfo">属性组信息</param>
public static void CreateAttribute(AttributeInfo attributeInfo, AttributeGroupInfo attributeGroupInfo)
{
BrnShop.Data.Categories.CreateAttribute(attributeInfo, attributeGroupInfo.AttrGroupId, attributeGroupInfo.Name, attributeGroupInfo.DisplayOrder);
//BrnShop.Core.BSPCache.Remove(CacheKeys.SHOP_CATEGORY_FILTERAANDVLIST + attributeInfo.CateId);
BrnShop.Core.BSPCache.Remove(CacheKeys.SHOP_CATEGORY_AANDVLISTJSONCACHE + attributeInfo.CateId);
}
/// <summary>
/// 更新属性分组
/// </summary>
/// <param name="newAttributeGroupInfo">新属性分组</param>
/// <param name="oldAttributeGroupInfo">原属性分组</param>
public static void UpdateAttributeGroup(AttributeGroupInfo attributeGroupInfo)
{
BrnShop.Core.BSPData.RDBS.UpdateAttributeGroup(attributeGroupInfo);
}
/// <summary>
/// 创建属性分组
/// </summary>
public void CreateAttributeGroup(AttributeGroupInfo attributeGroupInfo)
{
DbParameter[] parms = {
GenerateInParam("@cateid", SqlDbType.SmallInt, 2, attributeGroupInfo.CateId),
GenerateInParam("@name", SqlDbType.NChar, 20, attributeGroupInfo.Name),
GenerateInParam("@displayorder", SqlDbType.Int,4,attributeGroupInfo.DisplayOrder)
};
string commandText = string.Format("INSERT INTO [{0}attributegroups]([cateid],[name],[displayorder]) VALUES(@cateid,@name,@displayorder)",
RDBSHelper.RDBSTablePre);
RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
/// <summary>
/// 更新属性分组
/// </summary>
/// <param name="newAttributeGroupInfo">新属性分组</param>
/// <param name="oldAttributeGroupInfo">原属性分组</param>
public void UpdateAttributeGroup(AttributeGroupInfo attributeGroupInfo)
{
DbParameter[] parms = {
GenerateInParam("@cateid", SqlDbType.SmallInt, 2, attributeGroupInfo.CateId),
GenerateInParam("@name", SqlDbType.NChar, 20, attributeGroupInfo.Name),
GenerateInParam("@displayorder", SqlDbType.Int,4,attributeGroupInfo.DisplayOrder),
GenerateInParam("@attrgroupid", SqlDbType.SmallInt, 2, attributeGroupInfo.AttrGroupId)
};
string commandText = string.Format("UPDATE [{0}attributegroups] SET [cateid]=@cateid,[name]=@name,[displayorder]=@displayorder WHERE [attrgroupid]=@attrgroupid",
RDBSHelper.RDBSTablePre);
int effetRowCount = RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
if (effetRowCount > 0)
{
commandText = string.Format("UPDATE [{0}attributevalues] SET [attrgroupname]='{1}',[attrgroupdisplayorder]={2} WHERE [attrgroupid]={3}",
RDBSHelper.RDBSTablePre,
attributeGroupInfo.Name,
attributeGroupInfo.DisplayOrder,
attributeGroupInfo.AttrGroupId);
RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText);
}
}