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