private bool UpdateUserPermission(string type, string id, string isActive)
{
bool result = false;
if (type == "system")
{
IQueryable <AUTH_USER_SYSTEM> queryUserSystem = UserSystemRepository.GetQueryable();
//Guid sid = new Guid(id);
var system = queryUserSystem.FirstOrDefault(i => i.USER_SYSTEM_ID == id);
system.IS_ACTIVE = isActive;
RoleSystemRepository.SaveChanges();
result = true;
}
else if (type == "module")
{
IQueryable <AUTH_USER_MODULE> queryUserModule = UserModuleRepository.GetQueryable();
// Guid mid = new Guid(id);
var module = queryUserModule.FirstOrDefault(i => i.USER_MODULE_ID == id);
module.IS_ACTIVE = isActive;
RoleModuleRepository.SaveChanges();
result = true;
}
else if (type == "function")
{
IQueryable <AUTH_USER_FUNCTION> queryUserFunction = UserFunctionRepository.GetQueryable();
//Guid fid = new Guid(id);
var system = queryUserFunction.FirstOrDefault(i => i.USER_FUNCTION_ID == id);
system.IS_ACTIVE = isActive;
RoleSystemRepository.SaveChanges();
result = true;
}
return(result);
}
private bool UpdateUserPermission(string type, string id, bool isActive)
{
bool result = false;
if (type == "system")
{
IQueryable <THOK.Authority.DbModel.UserSystem> queryUserSystem = UserSystemRepository.GetQueryable();
Guid sid = new Guid(id);
var system = queryUserSystem.FirstOrDefault(i => i.UserSystemID == sid);
system.IsActive = isActive;
RoleSystemRepository.SaveChanges();
result = true;
}
else if (type == "module")
{
IQueryable <THOK.Authority.DbModel.UserModule> queryUserModule = UserModuleRepository.GetQueryable();
Guid mid = new Guid(id);
var module = queryUserModule.FirstOrDefault(i => i.UserModuleID == mid);
module.IsActive = isActive;
RoleModuleRepository.SaveChanges();
result = true;
}
else if (type == "function")
{
IQueryable <THOK.Authority.DbModel.UserFunction> queryUserFunction = UserFunctionRepository.GetQueryable();
Guid fid = new Guid(id);
var system = queryUserFunction.FirstOrDefault(i => i.UserFunctionID == 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);
}
private void InitRoleSystem(AUTH_ROLE role, AUTH_CITY city, AUTH_SYSTEM system)
{
var roleSystems = role.AUTH_ROLE_SYSTEM.Where(rs => rs.AUTH_CITY.CITY_ID == city.CITY_ID &&
rs.AUTH_SYSTEM.SYSTEM_ID == system.SYSTEM_ID);
if (roleSystems.Count() == 0)
{
AUTH_ROLE_SYSTEM rs = new AUTH_ROLE_SYSTEM()
{
//ROLE_SYSTEM_ID = Guid.NewGuid().ToString(),
ROLE_SYSTEM_ID = RoleSystemRepository.GetNewID("AUTH_ROLE_SYSTEM", "ROLE_SYSTEM_ID"),
AUTH_ROLE = role,
AUTH_CITY = city,
AUTH_SYSTEM = system,
IS_ACTIVE = "0"
};
RoleSystemRepository.Add(rs);
RoleSystemRepository.SaveChanges();
}
var roleSystem = role.AUTH_ROLE_SYSTEM.Single(rs => rs.AUTH_CITY.CITY_ID == city.CITY_ID &&
rs.AUTH_SYSTEM.SYSTEM_ID == system.SYSTEM_ID);
InitRoleModule(roleSystem);
}
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());
}
private void InitRoleSystem(Role role, City city, THOK.Authority.DbModel.System system)
{
var roleSystems = role.RoleSystems.Where(rs => rs.City.CityID == city.CityID &&
rs.System.SystemID == system.SystemID);
if (roleSystems.Count() == 0)
{
RoleSystem rs = new RoleSystem()
{
RoleSystemID = Guid.NewGuid(),
Role = role,
City = city,
System = system,
IsActive = false
};
RoleSystemRepository.Add(rs);
RoleSystemRepository.SaveChanges();
}
var roleSystem = role.RoleSystems.Single(rs => rs.City.CityID == city.CityID &&
rs.System.SystemID == system.SystemID);
InitRoleModule(roleSystem);
}
