/// <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); }