public JResult GetAllMenu(BaseMenuModel model) { return _baseservice.GetAllMenu(model); }
public JResult AddMenu(BaseMenuModel model) { return _baseservice.AddMenu(model); }
public JResult UpdateMenu(BaseMenuModel model) { return _baseservice.UpdateMenu(model); }
/// <summary> /// 获取所有菜单 /// </summary> /// <returns></returns> public IEnumerable<MenuViewMode> GetAllMenu(BaseMenuModel model) { StringBuilder sqlwhere = new StringBuilder(); //层级 if (model.level != null) { sqlwhere.AppendFormat(" and level ={0} ", model.level); } //innerid if (!string.IsNullOrWhiteSpace(model.innerid)) { sqlwhere.AppendFormat(" and innerid ='{0}' ", model.innerid); } StringBuilder sql = new StringBuilder(); sql.AppendFormat(@"select innerid, ifnull(code,'') as code,ifnull(name,'') as name, ifnull(url,'') as url, sort, parentid, level, openmode, isenabled, ifnull(remark,'') as remark, createdtime, modifiedtime, icon, submenu from sys_menu where isenabled=1 {0} order by modifiedtime desc ;", sqlwhere.ToString()); var menuList = Helper.Query<MenuViewMode>(sql.ToString()); return menuList; }
/// <summary> /// 添加菜单 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddMenu(BaseMenuModel model) { const string sql = @"INSERT INTO `sys_menu` (`innerid`, `code`, `name`, `url`, `sort`, `parentid`, `level`, `openmode`, `isenabled`, `remark`, `createdtime`, `modifiedtime`, `icon`, `submenu`) VALUES (uuid(), @code, @name, @url, @sort, @parentid, @level, @openmode, 1, @remark, now(), now(), @icon, @submenu);"; using (var conn = Helper.GetConnection()) { try { conn.Execute(sql, model); return 1; } catch (Exception ex) { return 0; } } }
/// <summary> /// 更新菜单信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdateMenu(BaseMenuModel model) { var sql = new StringBuilder("update `sys_menu` set "); sql.Append(Helper.CreateField(model).Trim().TrimEnd(',')); sql.Append(" where innerid = @innerid"); int result; try { result = Helper.Execute(sql.ToString(), model); } catch (Exception ex) { result = 0; } return result; }