public bool UpdateMenu(MenuInfo menu)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("UPDATE vshop_Menu SET ParentMenuId = @ParentMenuId, Name = @Name, Type = @Type, ReplyId = @ReplyId, DisplaySequence = @DisplaySequence, Bind = @Bind, [Content] = @Content WHERE MenuId = @MenuId");
this.database.AddInParameter(sqlStringCommand, "ParentMenuId", DbType.Int32, menu.ParentMenuId);
this.database.AddInParameter(sqlStringCommand, "Name", DbType.String, menu.Name);
this.database.AddInParameter(sqlStringCommand, "Type", DbType.String, menu.Type);
this.database.AddInParameter(sqlStringCommand, "ReplyId", DbType.Int32, menu.ReplyId);
this.database.AddInParameter(sqlStringCommand, "DisplaySequence", DbType.Int32, menu.DisplaySequence);
this.database.AddInParameter(sqlStringCommand, "MenuId", DbType.Int32, menu.MenuId);
this.database.AddInParameter(sqlStringCommand, "Bind", DbType.Int32, (int) menu.BindType);
this.database.AddInParameter(sqlStringCommand, "Content", DbType.String, menu.Content);
return (this.database.ExecuteNonQuery(sqlStringCommand) == 1);
}
public bool SaveMenu(MenuInfo menu)
{
int allMenusCount = this.GetAllMenusCount();
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO vshop_Menu (ParentMenuId, Name, Type, ReplyId, DisplaySequence, Bind, [Content]) VALUES(@ParentMenuId, @Name, @Type, @ReplyId, @DisplaySequence, @Bind, @Content)");
this.database.AddInParameter(sqlStringCommand, "ParentMenuId", DbType.Int32, menu.ParentMenuId);
this.database.AddInParameter(sqlStringCommand, "Name", DbType.String, menu.Name);
this.database.AddInParameter(sqlStringCommand, "Type", DbType.String, menu.Type);
this.database.AddInParameter(sqlStringCommand, "ReplyId", DbType.Int32, menu.ReplyId);
this.database.AddInParameter(sqlStringCommand, "DisplaySequence", DbType.Int32, allMenusCount);
this.database.AddInParameter(sqlStringCommand, "Bind", DbType.Int32, (int) menu.BindType);
this.database.AddInParameter(sqlStringCommand, "Content", DbType.String, menu.Content);
return (this.database.ExecuteNonQuery(sqlStringCommand) == 1);
}
private void btnAddMenu_Click(object sender, EventArgs e)
{
MenuInfo menu = new MenuInfo {
Name = this.txtCategoryName.Text,
ParentMenuId = base.GetUrlIntParam("pid")
};
if (!VShopHelper.CanAddMenu(menu.ParentMenuId))
{
this.ShowMsg("一级菜单不能超过三个，对应二级菜单不能超过五个", false);
}
else
{
menu.Bind = Convert.ToInt32(this.ddlType.SelectedValue);
BindType bindType = menu.BindType;
switch (bindType)
{
case BindType.Key:
menu.ReplyId = Convert.ToInt32(this.ddlValue.SelectedValue);
break;
case BindType.Topic:
menu.Content = this.ddlValue.SelectedValue;
break;
default:
if (bindType == BindType.Url)
{
menu.Content = this.txtUrl.Text.Trim();
}
break;
}
menu.Type = "click";
if (menu.ParentMenuId == 0)
{
menu.Type = "view";
}
else if (string.IsNullOrEmpty(this.ddlType.SelectedValue) || (this.ddlType.SelectedValue == "0"))
{
this.ShowMsg("二级菜单必须绑定一个对象", false);
return;
}
if (VShopHelper.SaveMenu(menu))
{
base.Response.Redirect("ManageMenu.aspx");
}
else
{
this.ShowMsg("添加失败", false);
}
}
}
private SingleButton BuildMenu(MenuInfo menu)
{
switch (menu.BindType)
{
case BindType.Key:
return new SingleClickButton { name = menu.Name, key = menu.MenuId.ToString() };
case BindType.Topic:
case BindType.HomePage:
case BindType.ProductCategory:
case BindType.ShoppingCar:
case BindType.OrderCenter:
case BindType.MemberCard:
case BindType.Url:
return new SingleViewButton { name = menu.Name, url = menu.Url };
}
return new SingleClickButton { name = menu.Name, key = "None" };
}
public static bool UpdateMenu(MenuInfo menu)
{
return new MenuDao().UpdateMenu(menu);
}
public static bool SaveMenu(MenuInfo menu)
{
return new MenuDao().SaveMenu(menu);
}
