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