public bool UpdateRolePermission(string type, string id, bool isActive)
{
bool result = false;
if (type == "system")
{
IQueryable <THOK.Authority.DbModel.RoleSystem> queryRoleSystem = RoleSystemRepository.GetQueryable();
Guid sid = new Guid(id);
var system = queryRoleSystem.FirstOrDefault(i => i.RoleSystemID == sid);
system.IsActive = isActive;
RoleSystemRepository.SaveChanges();
result = true;
}
else if (type == "module")
{
IQueryable <THOK.Authority.DbModel.RoleModule> queryRoleModule = RoleModuleRepository.GetQueryable();
Guid mid = new Guid(id);
var module = queryRoleModule.FirstOrDefault(i => i.RoleModuleID == mid);
module.IsActive = isActive;
RoleModuleRepository.SaveChanges();
result = true;
}
else if (type == "function")
{
IQueryable <THOK.Authority.DbModel.RoleFunction> queryRoleFunction = RoleFunctionRepository.GetQueryable();
Guid fid = new Guid(id);
var system = queryRoleFunction.FirstOrDefault(i => i.RoleFunctionID == fid);
system.IsActive = isActive;
RoleSystemRepository.SaveChanges();
result = true;
}
return(result);
}
public bool UpdateRolePermission(string type, string id, string isActive)
{
bool result = false;
if (type == "system")
{
IQueryable <AUTH_ROLE_SYSTEM> queryRoleSystem = RoleSystemRepository.GetQueryable();
//Guid sid = new Guid(id);
//string sid = id;
var system = queryRoleSystem.FirstOrDefault(i => i.ROLE_SYSTEM_ID == id);
system.IS_ACTIVE = isActive.ToString();
RoleSystemRepository.SaveChanges();
result = true;
}
else if (type == "module")
{
IQueryable <AUTH_ROLE_MODULE> queryRoleModule = RoleModuleRepository.GetQueryable();
//Guid mid = new Guid(id);
var module = queryRoleModule.FirstOrDefault(i => i.ROLE_MODULE_ID == id);
module.IS_ACTIVE = isActive.ToString();
RoleModuleRepository.SaveChanges();
result = true;
}
else if (type == "function")
{
IQueryable <AUTH_ROLE_FUNCTION> queryRoleFunction = RoleFunctionRepository.GetQueryable();
//Guid fid = new Guid(id);
var system = queryRoleFunction.FirstOrDefault(i => i.ROLE_FUNCTION_ID == id);
system.IS_ACTIVE = isActive.ToString();
RoleSystemRepository.SaveChanges();
result = true;
}
return(result);
}
public object GetRoleSystemDetails(string roleID, string cityID, string systemID)
{
IQueryable <AUTH_SYSTEM> querySystem = SystemRepository.GetQueryable();
IQueryable <AUTH_MODULE> queryModule = ModuleRepository.GetQueryable();
IQueryable <AUTH_ROLE_SYSTEM> queryRoleSystem = RoleSystemRepository.GetQueryable();
IQueryable <AUTH_ROLE_MODULE> queryRoleModule = RoleModuleRepository.GetQueryable();
var systems = querySystem.Single(i => i.SYSTEM_ID == systemID);
var roleSystems = queryRoleSystem.FirstOrDefault(i => i.AUTH_SYSTEM.SYSTEM_ID == systemID && i.AUTH_ROLE.ROLE_ID == roleID && i.AUTH_CITY.CITY_ID == cityID);
HashSet <Tree> RolesystemTreeSet = new HashSet <Tree>();
Tree roleSystemTree = new Tree();
roleSystemTree.id = roleSystems.ROLE_SYSTEM_ID.ToString();
roleSystemTree.text = "系统：" + systems.SYSTEM_NAME;
int a = Convert.ToInt32(roleSystems.IS_ACTIVE);
roleSystemTree.@checked = Convert.ToBoolean(a);
roleSystemTree.attributes = "system";
var modules = queryModule.Where(m => m.AUTH_SYSTEM.SYSTEM_ID == systems.SYSTEM_ID && m.MODULE_ID == m.PARENT_AUTH_MODULE.MODULE_ID)
.OrderBy(m => m.SHOW_ORDER)
.Select(m => m);
HashSet <Tree> moduleTreeSet = new HashSet <Tree>();
foreach (var item in modules)
{
Tree moduleTree = new Tree();
string moduleID = item.MODULE_ID.ToString();
//var roleModules = queryRoleModule.FirstOrDefault(i => i.Module.ModuleID == new Guid(moduleID) && i.RoleSystem.RoleSystemID == roleSystems.RoleSystemID);
var roleModules = queryRoleModule.FirstOrDefault(i => i.AUTH_MODULE.MODULE_ID == moduleID && i.AUTH_ROLE_SYSTEM.ROLE_SYSTEM_ID == roleSystems.ROLE_SYSTEM_ID);
moduleTree.id = roleModules.ROLE_MODULE_ID.ToString();
moduleTree.text = "模块：" + item.MODULE_NAME;
string b = roleModules.IS_ACTIVE == "1" ? "true" : "false";
moduleTree.@checked = bool.Parse(b);
moduleTree.attributes = "module";
moduleTreeSet.Add(moduleTree);
SetTree(moduleTree, item, roleSystems);
moduleTreeSet.Add(moduleTree);
}
roleSystemTree.children = moduleTreeSet.ToArray();
RolesystemTreeSet.Add(roleSystemTree);
return(RolesystemTreeSet.ToArray());
}
public object GetRoleSystemDetails(string roleID, string cityID, string systemID)
{
IQueryable <THOK.Authority.DbModel.System> querySystem = SystemRepository.GetQueryable();
IQueryable <THOK.Authority.DbModel.Module> queryModule = ModuleRepository.GetQueryable();
IQueryable <THOK.Authority.DbModel.RoleSystem> queryRoleSystem = RoleSystemRepository.GetQueryable();
IQueryable <THOK.Authority.DbModel.RoleModule> queryRoleModule = RoleModuleRepository.GetQueryable();
var systems = querySystem.Single(i => i.SystemID == new Guid(systemID));
var roleSystems = queryRoleSystem.FirstOrDefault(i => i.System.SystemID == new Guid(systemID) && i.Role.RoleID == new Guid(roleID) && i.City.CityID == new Guid(cityID));
HashSet <Tree> RolesystemTreeSet = new HashSet <Tree>();
Tree roleSystemTree = new Tree();
roleSystemTree.id = roleSystems.RoleSystemID.ToString();
roleSystemTree.text = "系统：" + systems.SystemName;
roleSystemTree.@checked = roleSystems.IsActive;
roleSystemTree.attributes = "system";
var modules = queryModule.Where(m => m.System.SystemID == systems.SystemID && m.ModuleID == m.ParentModule.ModuleID)
.OrderBy(m => m.ShowOrder)
.Select(m => m);
HashSet <Tree> moduleTreeSet = new HashSet <Tree>();
foreach (var item in modules)
{
Tree moduleTree = new Tree();
string moduleID = item.ModuleID.ToString();
var roleModules = queryRoleModule.FirstOrDefault(i => i.Module.ModuleID == new Guid(moduleID) && i.RoleSystem.RoleSystemID == roleSystems.RoleSystemID);
moduleTree.id = roleModules.RoleModuleID.ToString();
moduleTree.text = "模块：" + item.ModuleName;
moduleTree.@checked = roleModules.IsActive;
moduleTree.attributes = "module";
moduleTreeSet.Add(moduleTree);
SetTree(moduleTree, item, roleSystems);
moduleTreeSet.Add(moduleTree);
}
roleSystemTree.children = moduleTreeSet.ToArray();
RolesystemTreeSet.Add(roleSystemTree);
return(RolesystemTreeSet.ToArray());
}
