public IHttpActionResult Submit([FromBody] UserMenuInfo menuInfo) { try { var request = new AuthenticatedRequest(); if (!request.IsAdminLoggin || !request.AdminPermissionsImpl.HasSystemPermissions(ConfigManager.AppPermissions.SettingsConfigHomeMenu)) { return(Unauthorized()); } if (menuInfo.Id == 0) { DataProvider.UserMenuDao.Insert(menuInfo); request.AddAdminLog("新增用户菜单", $"用户菜单:{menuInfo.Text}"); } else if (menuInfo.Id > 0) { DataProvider.UserMenuDao.Update(menuInfo); request.AddAdminLog("修改用户菜单", $"用户菜单:{menuInfo.Text}"); } return(Ok(new { Value = UserMenuManager.GetAllUserMenuInfoList() })); } catch (Exception ex) { return(InternalServerError(ex)); } }
public void Update(UserMenuInfo menuInfo) { var sqlString = $@"UPDATE {TableName} SET {nameof(UserMenuInfo.SystemId)} = @{nameof(UserMenuInfo.SystemId)}, {nameof(UserMenuInfo.GroupIdCollection)} = @{nameof(UserMenuInfo.GroupIdCollection)}, {nameof(UserMenuInfo.IsDisabled)} = @{nameof(UserMenuInfo.IsDisabled)}, {nameof(UserMenuInfo.ParentId)} = @{nameof(UserMenuInfo.ParentId)}, {nameof(UserMenuInfo.Taxis)} = @{nameof(UserMenuInfo.Taxis)}, {nameof(UserMenuInfo.Text)} = @{nameof(UserMenuInfo.Text)}, {nameof(UserMenuInfo.IconClass)} = @{nameof(UserMenuInfo.IconClass)}, {nameof(UserMenuInfo.Href)} = @{nameof(UserMenuInfo.Href)}, {nameof(UserMenuInfo.Target)} = @{nameof(UserMenuInfo.Target)} WHERE {nameof(UserMenuInfo.Id)} = @{nameof(UserMenuInfo.Id)}"; IDataParameter[] parameters = { GetParameter(nameof(UserMenuInfo.SystemId), DataType.VarChar, 50, menuInfo.SystemId), GetParameter(nameof(UserMenuInfo.GroupIdCollection), DataType.VarChar, 200, menuInfo.GroupIdCollection), GetParameter(nameof(UserMenuInfo.IsDisabled), DataType.Boolean, menuInfo.IsDisabled), GetParameter(nameof(UserMenuInfo.ParentId), DataType.Integer, menuInfo.ParentId), GetParameter(nameof(UserMenuInfo.Taxis), DataType.Integer, menuInfo.Taxis), GetParameter(nameof(UserMenuInfo.Text), DataType.VarChar, 50, menuInfo.Text), GetParameter(nameof(UserMenuInfo.IconClass), DataType.VarChar, 50, menuInfo.IconClass), GetParameter(nameof(UserMenuInfo.Href), DataType.VarChar, 200, menuInfo.Href), GetParameter(nameof(UserMenuInfo.Target), DataType.VarChar, 50, menuInfo.Target), GetParameter(nameof(UserMenuInfo.Id), DataType.Integer, menuInfo.Id) }; ExecuteNonQuery(sqlString, parameters); UserMenuManager.ClearCache(); }
public IHttpActionResult Delete() { try { var request = new AuthenticatedRequest(); if (!request.IsAdminLoggin || !request.AdminPermissionsImpl.HasSystemPermissions(ConfigManager.AppPermissions.SettingsConfigHomeMenu)) { return(Unauthorized()); } var id = request.GetPostInt("id"); DataProvider.UserMenuDao.Delete(id); return(Ok(new { Value = UserMenuManager.GetAllUserMenuInfoList() })); } catch (Exception ex) { return(InternalServerError(ex)); } }
public IHttpActionResult Reset() { try { var request = new AuthenticatedRequest(); if (!request.IsAdminLoggin || !request.AdminPermissionsImpl.HasSystemPermissions(ConfigManager.AppPermissions.SettingsConfigHomeMenu)) { return(Unauthorized()); } foreach (var userMenuInfo in UserMenuManager.GetAllUserMenuInfoList()) { DataProvider.UserMenuDao.Delete(userMenuInfo.Id); } request.AddAdminLog("重置用户菜单"); return(Ok(new { Value = UserMenuManager.GetAllUserMenuInfoList() })); } catch (Exception ex) { return(InternalServerError(ex)); } }
// Use this for initialization void Awake() { if (instance != null) { Destroy(this); } instance = this; umList = new List <UserMenu>(); }
public dynamic AddUserMenu([FromBody] UserMenuViewModel model) { var vm = new UserMenuManager(); List <ExpandoObject> sugarQueryable = vm.GetMaxid("user_menu", "um_id", 1, 1); model.um_id = sugarQueryable.First().ObjToInt(); //vm.Insert(model); return(Ok()); }
public object GetIndex(RequestImpl request) { var menus = new List <object>(); var defaultPageUrl = string.Empty; if (request.IsUserLoggin) { var userMenus = UserMenuManager.GetAllUserMenuInfoList(); foreach (var menuInfo1 in userMenus) { if (menuInfo1.IsDisabled || menuInfo1.ParentId != 0 || !string.IsNullOrEmpty(menuInfo1.GroupIdCollection) && !StringUtils.In(menuInfo1.GroupIdCollection, request.UserInfo.GroupId)) { continue; } var children = new List <object>(); foreach (var menuInfo2 in userMenus) { if (menuInfo2.IsDisabled || menuInfo2.ParentId != menuInfo1.Id || !string.IsNullOrEmpty(menuInfo2.GroupIdCollection) && !StringUtils.In(menuInfo2.GroupIdCollection, request.UserInfo.GroupId)) { continue; } children.Add(new { menuInfo2.Text, menuInfo2.IconClass, menuInfo2.Href, menuInfo2.Target }); } menus.Add(new { menuInfo1.Text, menuInfo1.IconClass, menuInfo1.Href, menuInfo1.Target, Menus = children }); } defaultPageUrl = PluginMenuManager.GetHomeDefaultPageUrl(); } return(new { Value = request.UserInfo, Config = ConfigManager.Instance.SystemConfigInfo, Menus = menus, DefaultPageUrl = defaultPageUrl }); }
public void Delete(int menuId) { var sqlString = $"DELETE FROM {TableName} WHERE {nameof(UserMenuInfo.Id)} = @{nameof(UserMenuInfo.Id)} OR {nameof(UserMenuInfo.ParentId)} = @{nameof(UserMenuInfo.ParentId)}"; var parms = new IDataParameter[] { GetParameter($"@{nameof(UserMenuInfo.Id)}", DataType.Integer, menuId), GetParameter($"@{nameof(UserMenuInfo.ParentId)}", DataType.Integer, menuId) }; ExecuteNonQuery(sqlString, parms); UserMenuManager.ClearCache(); }
public ResponseBaseModel UserMenuList([FromBody] SelectBaseModel model) { var vm = new UserMenuManager(); int _count = vm.GetList(i => i.um_id > 0).Count; int _pageCount = _count / model.pageSize + 1; List <user_menu> _list = vm.GetPageList(i => i.um_id > 0, new PageModel { PageIndex = model.current, PageSize = model.pageSize, PageCount = _pageCount }); ResponseBaseModel responseBaseModel = new ResponseBaseModel(); responseBaseModel.Data = _list; responseBaseModel.pageCount = _pageCount; responseBaseModel.currentIndex = model.current; responseBaseModel.totalCount = _count; return(responseBaseModel); }
public int Insert(UserMenuInfo menuInfo) { var sqlString = $@" INSERT INTO {TableName} ( {nameof(UserMenuInfo.SystemId)}, {nameof(UserMenuInfo.GroupIdCollection)}, {nameof(UserMenuInfo.IsDisabled)}, {nameof(UserMenuInfo.ParentId)}, {nameof(UserMenuInfo.Taxis)}, {nameof(UserMenuInfo.Text)}, {nameof(UserMenuInfo.IconClass)}, {nameof(UserMenuInfo.Href)}, {nameof(UserMenuInfo.Target)} ) VALUES ( @{nameof(UserMenuInfo.SystemId)}, @{nameof(UserMenuInfo.GroupIdCollection)}, @{nameof(UserMenuInfo.IsDisabled)}, @{nameof(UserMenuInfo.ParentId)}, @{nameof(UserMenuInfo.Taxis)}, @{nameof(UserMenuInfo.Text)}, @{nameof(UserMenuInfo.IconClass)}, @{nameof(UserMenuInfo.Href)}, @{nameof(UserMenuInfo.Target)} )"; var parms = new IDataParameter[] { GetParameter($"@{nameof(UserMenuInfo.SystemId)}", DataType.VarChar, 50, menuInfo.SystemId), GetParameter($"@{nameof(UserMenuInfo.GroupIdCollection)}", DataType.VarChar, 200, menuInfo.GroupIdCollection), GetParameter($"@{nameof(UserMenuInfo.IsDisabled)}", DataType.Boolean, menuInfo.IsDisabled), GetParameter($"@{nameof(UserMenuInfo.ParentId)}", DataType.Integer, menuInfo.ParentId), GetParameter($"@{nameof(UserMenuInfo.Taxis)}", DataType.Integer, menuInfo.Taxis), GetParameter($"@{nameof(UserMenuInfo.Text)}", DataType.VarChar, 50, menuInfo.Text), GetParameter($"@{nameof(UserMenuInfo.IconClass)}", DataType.VarChar, 50, menuInfo.IconClass), GetParameter($"@{nameof(UserMenuInfo.Href)}", DataType.VarChar, 200, menuInfo.Href), GetParameter($"@{nameof(UserMenuInfo.Target)}", DataType.VarChar, 50, menuInfo.Target) }; var menuId = ExecuteNonQueryAndReturnId(TableName, nameof(UserMenuInfo.Id), sqlString, parms); UserMenuManager.ClearCache(); return(menuId); }
public IHttpActionResult Get() { try { var request = new AuthenticatedRequest(); if (!request.IsAdminLoggin || !request.AdminPermissionsImpl.HasSystemPermissions(ConfigManager.AppPermissions.SettingsConfigHomeMenu)) { return(Unauthorized()); } return(Ok(new { Value = UserMenuManager.GetAllUserMenuInfoList(), Groups = UserGroupManager.GetUserGroupInfoList() })); } catch (Exception ex) { return(InternalServerError(ex)); } }
public List <MenuTree> MenuTree() { var vm = new UserMenuManager(); return(vm.GetTreeMenu()); }