ASP.NET MVC5+EF6+EasyUI 后台管理系统-分配角色给用户
分类:
IT文章
•
2023-11-30 14:02:19
系列目录
由于之前做了将权限赋给角色，还需要做将角色组赋给用户，和将用户赋给角色组，一个用户可以拥有多个角色组，一个角色组包含多个用户,打开模块管理，添加一个分配的操作码
并在
角色权限设置授权给他
在SysUser的Index添加以下按钮
@Html.ToolButton("btnAllot", "icon-share", "分配角色", perm, "Allot", true)
我们要弹出所有角色的选择窗口来勾选后保存。这个大家应该想到了，所以先设置弹出界面的视图，我命名为GetRoleByUser
所以在SysUser添加以下3个方法
#region 设置用户角色
[SupportFilter(ActionName = "Allot")]
public ActionResult GetRoleByUser(string userId)
{
ViewBag.UserId = userId;
ViewBag.Perm = GetPermission();
return View();
}
[SupportFilter(ActionName = "Allot")]
public JsonResult GetRoleListByUser(GridPager pager, string userId)
{
if (string.IsNullOrWhiteSpace(userId))
return Json(0);
var userList = userBLL.GetRoleByUserId(ref pager,userId);
var jsonData = new
{
total = pager.totalRows,
rows = (
from r in userList
select new SysRoleModel()
{
Id= r.Id,
Name= r.Name,
Description = r.Description,
Flag = r.flag=="0"?"0":"1",
}
).ToArray()
};
return Json(jsonData);
}
#endregion
[SupportFilter(ActionName = "Save")]
public JsonResult UpdateUserRoleByUserId(string userId, string roleIds)
{
string[] arr = roleIds.Split(',');
if (userBLL.UpdateSysRoleSysUser(userId, arr))
{
LogHandler.WriteServiceLog(GetUserId(), "Ids:" + roleIds, "成功", "分配角色", "用户设置");
return Json(JsonHandler.CreateMessage(1, Suggestion.SetSucceed), JsonRequestBehavior.AllowGet);
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(GetUserId(), "Ids:" + roleIds, "失败", "分配角色", "用户设置");
return Json(JsonHandler.CreateMessage(0, Suggestion.SetFail), JsonRequestBehavior.AllowGet);
}
}
GetRoleByUser为弹出视图
GetRoleListByUser为根据选择的用户获取角色并让已经分配的角色呈现选择状态 （存储过程实现）
![]()
USE [AppDB]
GO
/****** Object: StoredProcedure [dbo].[P_Sys_GetRoleByUserId] Script Date: 02/21/2014 11:17:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create proc [dbo].[P_Sys_GetRoleByUserId]
@UserId varchar(50)
as
begin
--读取用户所包含的角色
select a.*,ISNULL(b.SysUserId,0) as flag from SysRole a left join
SysRoleSysUser b
on a.Id = b.SysRoleId
and b.SysUserId = @UserId
order by b.SysUserId desc
end
P_Sys_GetRoleByUserId
UpdateUserRoleByUserId更新选择的后的情况（存储过程实现）
![]()
Create PROCEDURE [dbo].[P_Sys_UpdateSysRoleSysUser]
@roleId varchar(50),@userId varchar(50)
AS
--更新角色用户中间关系表
BEGIN
insert into SysRoleSysUser(SysRoleId,SysUserId)
values(@roleId,@userId)
END
P_Sys_UpdateSysRoleSysUser
public IQueryable<P_Sys_GetRoleByUserId_Result> GetRoleByUserId(ref GridPager pager, string userId)
{
IQueryable<P_Sys_GetRoleByUserId_Result> queryData = sysUserRepository.GetRoleByUserId(db, userId);
pager.totalRows = queryData.Count();
queryData = sysUserRepository.GetRoleByUserId(db, userId);
return queryData.Skip((pager.page - 1) * pager.rows).Take(pager.rows);
}
public bool UpdateSysRoleSysUser(string userId, string[] roleIds)
{
try
{
sysUserRepository.UpdateSysRoleSysUser(userId, roleIds);
return true;
}
catch (Exception ex)
{
ExceptionHander.WriteException(ex);
return false;
}
}
public IQueryable<P_Sys_GetRoleByUserId_Result> GetRoleByUserId(DBContainer db, string userId)
{
return db.P_Sys_GetRoleByUserId(userId).AsQueryable();
}
public void UpdateSysRoleSysUser(string userId, string[] roleIds)
{
using (DBContainer db = new DBContainer())
{
db.P_Sys_DeleteSysRoleSysUserByUserId(userId);
foreach (string roleid in roleIds)
{
if (!string.IsNullOrWhiteSpace(roleid))
{
db.P_Sys_UpdateSysRoleSysUser(roleid,userId);
}
}
db.SaveChanges();
}
}
Create PROCEDURE [dbo].[P_Sys_DeleteSysRoleSysUserByUserId]
@userId varchar(50)
AS
--更新角色用户中间关系表,前删除关联
BEGIN
delete SysRoleSysUser where SysUserId=@userId
END
![]()
@using App.Admin;
@using App.Common;
@using App.Models.Sys;
@{
ViewBag.Title = "设置用户包含的角色";
Layout = "~/Views/Shared/_Index_LayoutEdit.cshtml";
List<permModel> perm = (List<permModel>)ViewBag.Perm;
if (perm == null)
{
perm = new List<permModel>();
}
}
<div class="mvctool bgb">
@Html.ToolButton("btnSave", "icon-save", "保存", perm, "Create", true)
</div>
<div class="pd3">
<table id="UserList"></table>
</div>
@*Jqgrid*@
<script type="text/javascript">
$(function () {
$('#UserList').datagrid({
url: '/SysUser/GetRoleListByUser?userId=@(ViewBag.UserId)',
SetGridWidthSub(6),
methord: 'post',
height: SetGridHeightSub(41),
fitColumns: true,
sortName: 'Id',
sortOrder: 'desc',
idField: 'Id',
pageSize: 12,
pageList: [12, 20, 30, 40, 50],
pagination: true,
striped: true, //奇偶行是否区分
singleSelect: true,//单选模式
columns: [[
{ field: 'Id', title: 'ID', 80, hidden: true },
{ field: 'Name', title: '角色名称', 120 },
{ field: 'Description', title: '说明', 80},
{ field: 'Flag', title: '是否分配', 80, editor: { type: 'checkbox', options: { on: '1', off: '0' } }}
]],
onLoadSuccess: function () {
var rows = $("#UserList").datagrid("getRows");
for (var i = 0; i < rows.length; i++) {
//获取每一行的数据
$('#UserList').datagrid('beginEdit', i);
}
}
});
});
</script>
@*operation*@
<script type="text/javascript">
$(function () {
$("#btnSave").click(function () {
var rows = $("#UserList").datagrid("getRows"); //这段代码是获取当前页的所有行。
var data = new Array();
for (var i = 0; i < rows.length; i++) {
var setFlag = $("td[field='Flag'] input").eq(i).prop("checked");
if (setFlag)//判断是否有作修改
{
data.push(rows[i].Id);
}
}
var roleIds = data.join();
//提交数据库
$.post("/SysUser/UpdateUserRoleByUserId", { userId: '@(ViewBag.UserId)', roleIds: roleIds },
function (data) {
if (data.type == 1) {
window.parent.frameReturnByMes(data.message);
window.parent.frameReturnByReload(true);
window.parent.frameReturnByClose()
}
else {
window.parent.frameReturnByMes(data.message);
}
}, "json");
});
});
</script>
