public BasePageList<MenuViewMode> GetMenuList(MenuQueryModel query) { return _baseservice.GetMenuList(query); }
/// <summary> /// 获取菜单列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public BasePageList<MenuViewMode> GetMenuList(MenuQueryModel query) { const string spName = "sp_common_pager"; const string tableName = @"sys_menu "; const string fields = "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"; var orderField = string.IsNullOrWhiteSpace(query.Order) ? " level asc " : query.Order; // var groupField = string.IsNullOrWhiteSpace(query.Group) ? " parentid " : query.Group; ; var sqlWhere = new StringBuilder("1=1"); //菜单名称 if (!string.IsNullOrWhiteSpace(query.name)) { sqlWhere.AppendFormat(" and name like '%{0}%' ", query.name); } //层级 if (query.level != null) { sqlWhere.AppendFormat(" and level = {0} ", query.level); } var model = new PagingModel(spName, tableName, fields, orderField, sqlWhere.ToString(), query.PageSize, query.PageIndex); var list = Helper.ExecutePaging<MenuViewMode>(model, query.Echo); return list; }