/// <summary>
/// 提交按钮点击方法
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void SubmitButton_Click(object sender, EventArgs e)
{
NavMenuInfo navMenu = new NavMenuInfo();
navMenu.Id = RequestHelper.GetQueryString <int>("ID");
navMenu.OrderId = Convert.ToInt32(OrderID.Text);
navMenu.Name = Name.Text;
navMenu.LinkUrl = LinkUrl.Text;
navMenu.Introduce = Introduce.Text;
navMenu.IsShow = Convert.ToInt32(IsShow.Checked);
string alertMessage = ShopLanguage.ReadLanguage("AddOK");
if (navMenu.Id == int.MinValue)
{
CheckAdminPower("AddNavMenu", PowerCheckType.Single);
int id = NavMenuBLL.Add(navMenu);
AdminLogBLL.Add(ShopLanguage.ReadLanguage("AddRecord"), "导航菜单", id);
}
else
{
CheckAdminPower("UpdateNavMenu", PowerCheckType.Single);
NavMenuBLL.Update(navMenu);
AdminLogBLL.Add(ShopLanguage.ReadLanguage("UpdateRecord"), "导航菜单", navMenu.Id);
alertMessage = ShopLanguage.ReadLanguage("UpdateOK");
}
ScriptHelper.Alert(alertMessage, "/Admin/NavMenu.aspx");
}
/// <summary>
/// 修改导航排序
/// </summary>
/// <param name="id">要移动的id</param>
public void ChangeNavMenuOrder(int id, int orderId)
{
NavMenuInfo navmenu = Read(id);
navmenu.OrderId = orderId;
Update(navmenu);
}
public void Update(NavMenuInfo entity)
{
using (var conn = new SqlConnection(connectString))
{
string sql = @"update NavMenu set Name=@Name,IsShow=@IsShow,OrderId=@OrderId,LinkUrl=@LinkUrl,Introduce=@Introduce where Id=@Id";
conn.Execute(sql, entity);
}
}
public int Add(NavMenuInfo entity)
{
using (var conn = new SqlConnection(connectString))
{
string sql = @"insert into NavMenu([Name],[IsShow],[OrderId],[LinkUrl],[Introduce])
values(@Name,@IsShow,@OrderId,@LinkUrl,@Introduce);
select SCOPE_IDENTITY()";
return(conn.Query <int>(sql, entity).Single());
}
}
/// <summary>
/// 页面加载方法
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
int navMenuID = RequestHelper.GetQueryString <int>("ID");
if (navMenuID != int.MinValue)
{
CheckAdminPower("ReadNavMenu", PowerCheckType.Single);
NavMenuInfo navMenu = NavMenuBLL.Read(navMenuID);
OrderID.Text = navMenu.OrderId.ToString();
Name.Text = navMenu.Name;
LinkUrl.Text = navMenu.LinkUrl;
Introduce.Text = navMenu.Introduce;
IsShow.Checked = Convert.ToBoolean(navMenu.IsShow);
}
}
}
public static void Update(NavMenuInfo entity)
{
dal.Update(entity);
}
public static int Add(NavMenuInfo entity)
{
entity.Id = dal.Add(entity);
return(entity.Id);
}
