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);
}
private void SetModuleTree(Tree tree, Module module, UserSystem userSystems)
{
HashSet <Tree> childTreeSet = new HashSet <Tree>();
var modules = from m in module.Modules
orderby m.ShowOrder
select m;
foreach (var item in modules)
{
if (item != module)
{
Tree childTree = new Tree();
string moduleID = item.ModuleID.ToString();
var userModules = UserModuleRepository.GetQueryable().FirstOrDefault(i => i.Module.ModuleID == new Guid(moduleID) && i.UserSystem.UserSystemID == userSystems.UserSystemID);
childTree.id = userModules.UserModuleID.ToString();
childTree.text = "模块：" + item.ModuleName;
childTree.@checked = userModules == null ? false : userModules.IsActive;
childTree.attributes = "module";
childTreeSet.Add(childTree);
if (item.Modules.Count > 0)
{
SetModuleTree(childTree, item, userSystems);
}
if (item.Functions.Count > 0)
{
SetModuleFunTree(childTree, item, userModules);
}
}
}
tree.children = childTreeSet.ToArray();
}
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 void SetModuleTree(Tree tree, AUTH_MODULE module, AUTH_USER_SYSTEM userSystems)
{
HashSet <Tree> childTreeSet = new HashSet <Tree>();
var modules = from m in module.AUTH_MODULES
orderby m.SHOW_ORDER
select m;
foreach (var item in modules)
{
if (item != module)
{
Tree childTree = new Tree();
string moduleID = item.MODULE_ID.ToString();
//var userModules = UserModuleRepository.GetQueryable().FirstOrDefault(i => i.Module.ModuleID == new Guid(moduleID) && i.UserSystem.UserSystemID == userSystems.UserSystemID);
var userModules = UserModuleRepository.GetQueryable().FirstOrDefault(i => i.AUTH_MODULE.MODULE_ID == moduleID && i.AUTH_USER_SYSTEM.USER_SYSTEM_ID == userSystems.USER_SYSTEM_ID);
childTree.id = userModules.USER_MODULE_ID.ToString();
childTree.text = "模块：" + item.MODULE_NAME;
int a = Convert.ToInt32(userModules.IS_ACTIVE);
childTree.@checked = userModules == null ? false : Convert.ToBoolean(a);
childTree.attributes = "module";
childTreeSet.Add(childTree);
if (item.AUTH_MODULES.Count > 0)
{
SetModuleTree(childTree, item, userSystems);
}
if (item.AUTH_FUNCTION.Count > 0)
{
SetModuleFunTree(childTree, item, userModules);
}
}
}
tree.children = childTreeSet.ToArray();
}
public object GetUserSystemDetails(string userID, string cityID, string systemID)
{
IQueryable <AUTH_SYSTEM> querySystem = SystemRepository.GetQueryable();
IQueryable <AUTH_MODULE> queryModule = ModuleRepository.GetQueryable();
IQueryable <AUTH_USER_SYSTEM> queryUserSystem = UserSystemRepository.GetQueryable();
IQueryable <AUTH_USER_MODULE> queryUserModule = UserModuleRepository.GetQueryable();
var systems = querySystem.Single(i => i.SYSTEM_ID == systemID);
var userSystems = queryUserSystem.FirstOrDefault(i => i.AUTH_SYSTEM.SYSTEM_ID == systemID && i.AUTH_USER.USER_ID == userID && i.AUTH_CITY.CITY_ID == cityID);
HashSet <Tree> userSystemTreeSet = new HashSet <Tree>();
Tree userSystemTree = new Tree();
userSystemTree.id = userSystems.USER_SYSTEM_ID.ToString();
userSystemTree.text = "系统：" + systems.SYSTEM_NAME;
userSystemTree.@checked = userSystems.IS_ACTIVE == "1"?true:false;
userSystemTree.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 userModules = queryUserModule.FirstOrDefault(i => i.Module.ModuleID == new Guid(moduleID) && i.UserSystem.UserSystemID == userSystems.UserSystemID);
var userModules = queryUserModule.FirstOrDefault(i => i.AUTH_MODULE.MODULE_ID == moduleID && i.AUTH_USER_SYSTEM.USER_SYSTEM_ID == userSystems.USER_SYSTEM_ID);
moduleTree.id = userModules.USER_MODULE_ID.ToString();
moduleTree.text = "模块：" + item.MODULE_NAME;
int a = Convert.ToInt32(userModules.IS_ACTIVE);
moduleTree.@checked = Convert.ToBoolean(a);
moduleTree.attributes = "module";
moduleTreeSet.Add(moduleTree);
SetModuleTree(moduleTree, item, userSystems);
moduleTreeSet.Add(moduleTree);
}
userSystemTree.children = moduleTreeSet.ToArray();
userSystemTreeSet.Add(userSystemTree);
return(userSystemTreeSet.ToArray());
}
public object GetUserSystemDetails(string userID, string cityID, string systemID)
{
IQueryable <THOK.Authority.DbModel.System> querySystem = SystemRepository.GetQueryable();
IQueryable <THOK.Authority.DbModel.Module> queryModule = ModuleRepository.GetQueryable();
IQueryable <THOK.Authority.DbModel.UserSystem> queryUserSystem = UserSystemRepository.GetQueryable();
IQueryable <THOK.Authority.DbModel.UserModule> queryUserModule = UserModuleRepository.GetQueryable();
var systems = querySystem.Single(i => i.SystemID == new Guid(systemID));
var userSystems = queryUserSystem.FirstOrDefault(i => i.System.SystemID == new Guid(systemID) && i.User.UserID == new Guid(userID) && i.City.CityID == new Guid(cityID));
HashSet <Tree> userSystemTreeSet = new HashSet <Tree>();
Tree userSystemTree = new Tree();
userSystemTree.id = userSystems.UserSystemID.ToString();
userSystemTree.text = "系统：" + systems.SystemName;
userSystemTree.@checked = userSystems.IsActive;
userSystemTree.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 userModules = queryUserModule.FirstOrDefault(i => i.Module.ModuleID == new Guid(moduleID) && i.UserSystem.UserSystemID == userSystems.UserSystemID);
moduleTree.id = userModules.UserModuleID.ToString();
moduleTree.text = "模块：" + item.ModuleName;
moduleTree.@checked = userModules.IsActive;
moduleTree.attributes = "module";
moduleTreeSet.Add(moduleTree);
SetModuleTree(moduleTree, item, userSystems);
moduleTreeSet.Add(moduleTree);
}
userSystemTree.children = moduleTreeSet.ToArray();
userSystemTreeSet.Add(userSystemTree);
return(userSystemTreeSet.ToArray());
}