public ActionResult RoleAssign()
{
var gridModel = new RoleAssignGridModel();
SetUpRoleAssignGridModel(gridModel);
return(View(gridModel));
}
public JsonResult RoleAssignOfUser_RequestData(Guid ParentRowId)
{
var gridModel = new RoleAssignGridModel();
SetUpRoleAssignGridModel(gridModel);
var oldrole = Uow.aspnet_Roles.GetAll().Where(w => w.RoleId == ParentRowId).FirstOrDefault();
var users = from user in Uow.aspnet_Users.GetAll()
join profile in Uow.aspnet_CustomProfile.GetAll() on user.UserId equals profile.UserId into uc
from cp in uc.DefaultIfEmpty()
join depts in Uow.Depts.GetAll() on cp.DeptId equals depts.DeptId into dc
from d in dc.DefaultIfEmpty()
join auth in Uow.aspnet_UsersInRoles.GetAll().Where(s => s.RoleId == oldrole.RoleId) on user.UserId equals auth.UserId into ua
from a in ua.DefaultIfEmpty()
join role in Uow.aspnet_Roles.GetAll() on a.RoleId equals role.RoleId into ra
from ras in ra.DefaultIfEmpty()
select new
{
IsInRole = (ras == null ? false : true),
user.UserId,
user.UserName,
FullName = (cp == null ? string.Empty : cp.FullName),
DeptName = (d == null ? string.Empty : d.DeptName),
};
return(gridModel.UsersGrid.DataBind(users));
}
public JsonResult RoleAssignOfRole_RequestData()
{
var gridModel = new RoleAssignGridModel();
SetUpRoleAssignGridModel(gridModel);
var roles = Uow.aspnet_Roles.GetAll();
return(gridModel.RolesGrid.DataBind(roles));
}
public JsonResult RoleAssignOfRole_RequestData()
{
var gridModel = new RoleAssignGridModel();
SetUpRoleAssignGridModel(gridModel);
var context = db;
var roles = context.aspnet_Roles;
return(gridModel.RolesGrid.DataBind(roles));
}
public JsonResult RoleAssignOfUser_RequestData(string ParentRowId)
{
//ParentRowId=HttpUtility.HtmlDecode(ParentRowId);
var gridModel = new RoleAssignGridModel();
SetUpRoleAssignGridModel(gridModel);
var contex = db;
//if (!ParentRowId.HasValue)
//{
// var users = from user in contex.aspnet_Users
// join memberships in contex.aspnet_Membership on user.UserId equals memberships.UserId into um
// from ms in um.DefaultIfEmpty()
// join profile in contex.aspnet_CustomProfile on ms.UserId equals profile.UserId into uc
// from cp in uc.DefaultIfEmpty()
// join depts in contex.Depts on cp.DeptId equals depts.DeptId into dc
// from d in dc.DefaultIfEmpty()
// select new
// {
// IsInRole = false,
// user.UserId,
// user.UserName,
// FullName = (cp == null ? string.Empty : cp.FullName),
// DeptName = (d == null ? string.Empty : d.DeptName),
// };
// return gridModel.UsersGrid.DataBind(users);
//}
//else
//{
Guid rid = Guid.Parse(ParentRowId);
var oldrole = contex.aspnet_Roles.Where(w => w.RoleId == rid).FirstOrDefault();
var users = from user in contex.aspnet_Users
//join memberships in contex.aspnet_Membership on user.UserId equals memberships.UserId into um
//from ms in um.DefaultIfEmpty()
join profile in contex.aspnet_CustomProfile on user.UserId equals profile.UserId into uc
from cp in uc.DefaultIfEmpty()
join depts in contex.Depts on cp.DeptId equals depts.DeptId into dc
from d in dc.DefaultIfEmpty()
join auth in contex.aspnet_UsersInRoles.Where(s => s.RoleId == oldrole.RoleId) on user.UserId equals auth.UserId into ua
from a in ua.DefaultIfEmpty()
join role in contex.aspnet_Roles on a.RoleId equals role.RoleId into ra
from ras in ra.DefaultIfEmpty()
select new
{
IsInRole = (ras == null ? false : true),
user.UserId,
user.UserName,
FullName = (cp == null ? string.Empty : cp.FullName),
DeptName = (d == null ? string.Empty : d.DeptName),
};
return(gridModel.UsersGrid.DataBind(users));
// }
}
private void SetUpRoleAssignGridModel(RoleAssignGridModel gridModel)
{
var usersGrid = gridModel.UsersGrid;
var rolesGrid = gridModel.RolesGrid;
rolesGrid.AppearanceSettings.Caption = "角色分配";
usersGrid.DataUrl = Url.Action("RoleAssignOfUser_RequestData");
usersGrid.EditUrl = Url.Action("RoleAssignOfUser_EditData");
usersGrid.SearchDialogSettings.MultipleSearch = true;
rolesGrid.DataUrl = Url.Action("RoleAssignOfRole_RequestData");
rolesGrid.SearchDialogSettings.MultipleSearch = true;
}
private void SetUpRoleAssignGridModel(RoleAssignGridModel gridModel)
{
var usersGrid = gridModel.UsersGrid;
var rolesGrid = gridModel.RolesGrid;
rolesGrid.AppearanceSettings.Caption = this.Title;
usersGrid.DataUrl = Url.Action("RoleAssignOfUser_RequestData");
usersGrid.EditUrl = Url.Action("RoleAssignOfUser_EditData");
usersGrid.SearchDialogSettings.MultipleSearch = true;
rolesGrid.DataUrl = Url.Action("RoleAssignOfRole_RequestData");
rolesGrid.SearchDialogSettings.MultipleSearch = true;
this.SetBoolColumn(usersGrid, "IsInRole");
}
