public List<SystemUserGroupUserRelationEntity> GetAllRelationByUser(SystemUserEntity systemUserEntity) { NHibernateDynamicQueryGenerator<SystemUserGroupUserRelationEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_USERID.Eq(systemUserEntity)); return this.FindListByQueryBuilder(dynamicQueryGenerator); }
public SystemUserProfileEntity GetUserProfileByUser(SystemUserEntity userEntity) { NHibernateDynamicQueryGenerator<SystemUserProfileEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_USERID.Eq(userEntity)); return this.FindSingleEntityByQueryBuilder(queryGenerator); }
public static DetachedCriteria GetUserAssignedRoles(SystemUserEntity user) { DetachedCriteria criteria = DetachedCriteria.For(typeof(SystemUserRoleRelationEntity)); criteria.Add(SystemUserRoleRelationDataObject.PROPERTY_USERID.Eq(user)); criteria.SetProjection(SystemUserRoleRelationDataObject.PROPERTY_ROLEID); return criteria; }
public object GetUserProfileByUserIDAndPropertys(SystemUserEntity userEntity, SystemUserProfilePropertysEntity propertysEntity) { NHibernateDynamicQueryGenerator<SystemUserProfileEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_USERID.Eq(userEntity)); queryGenerator.AddWhereClause(PROPERTY_PROPERTYID.Eq(propertysEntity)); return this.FindListByQueryBuilder(queryGenerator); }
public SystemUserGroupUserRelationEntity GetUserUserGroupRelation(SystemUserEntity userentity, SystemUserGroupEntity groupEntity) { NHibernateDynamicQueryGenerator<SystemUserGroupUserRelationEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_USERID.Eq(userentity)); queryGenerator.AddWhereClause(PROPERTY_USERGROUPID.Eq(groupEntity)); return this.FindSingleEntityByQueryBuilder(queryGenerator); }
public SystemPersonalizationSettingsEntity FindByUserAndPath(SystemUserEntity systemUserEntity, string path) { NHibernateDynamicQueryGenerator<SystemPersonalizationSettingsEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_USERID.Eq(systemUserEntity)); dynamicQueryGenerator.AddWhereClause(PROPERTY_PATH.Eq(path)); return this.FindSingleEntityByQueryBuilder(dynamicQueryGenerator); }
public List <SystemPrivilegeEntity> GetAllPrivilegeByCategoryByUserID(string categoryName, SystemUserEntity userEntity) { NHibernateDynamicQueryGenerator <SystemPrivilegeInRolesEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_ROLEID.In(QueryObjects.GetUserAssignedRoles(userEntity))); if (!string.IsNullOrEmpty(categoryName)) { InClude_PrivilegeID_Query(dynamicQueryGenerator); dynamicQueryGenerator.AddWhereClause(PROPERTY_PRIVILEGEID_PRIVILEGECATEGORY.Eq(categoryName)); } return(this.FindListByProjection <SystemPrivilegeEntity>(dynamicQueryGenerator, GetDistinctProperty(PROPERTY_PRIVILEGEID))); //string hql = string.Format("select rp.PrivilegeID from {1} rp where rp.RoleID in (select ur.RoleID from {0} ur where ur.UserID = :userID)", SystemUserRoleRelationEntity.CLASS_FULL_NAME, SystemPrivilegeInRolesEntity.CLASS_FULL_NAME); //if (!string.IsNullOrEmpty(categoryName)) //{ // hql += " and (rp.PrivilegeID.PrivilegeCategory = :categoryName)"; //} //var parameters = new NhibernateParameterCollection(); //parameters.AddParameter("userID", userEntity, NHibernateUtil.Entity(typeof(SystemUserEntity))); //if (!string.IsNullOrEmpty(categoryName)) //{ // parameters.AddParameter("categoryName", categoryName, NHibernateUtil.Entity(typeof(string))); //} //return this.FindAllWithCustomQuery(hql, parameters); }
public List <SystemPersonalizationSettingsEntity> FindAllByUserId(SystemUserEntity _userId) { return(this.SelfDataObj.GetList_By_UserId_SystemUserEntity(_userId)); }
public List <SystemPersonalizationSettingsEntity> FindAllByOrderByAndFilterAndUserId(string orderByColumnName, bool isDesc, SystemUserEntity _userId, PageQueryParams pageQueryParams) { return(this.SelfDataObj.GetPageList_By_UserId_SystemUserEntity(orderByColumnName, isDesc, _userId, pageQueryParams)); }
public IList <SystemPrivilegeInRolesEntity> GetAllPrivilegeByCategoryByUserID(SystemUserEntity entity) { return(this.SelfDataObj.GetAllPrivilegeByCategoryByUserID(entity)); }
public SystemRoleEntity GetUserMinRoleTypeRole(SystemUserEntity systemUserEntity) { return(this.DataObjectsContainerIocID.SystemUserRoleRelationDataObjectInstance.GetUserMinRoleTypeRole(systemUserEntity)); }
public List <SystemUserRoleRelationEntity> GetPageList_By_UserID_SystemUserEntity(string orderByColumnName, bool isDesc, SystemUserEntity fkentity, PageQueryParams pageQueryParams) { NHibernateDynamicQueryGenerator <SystemUserRoleRelationEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_USERID.Eq(fkentity)); AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, dynamicQueryGenerator); return(FindListByPageByQueryBuilder(dynamicQueryGenerator, pageQueryParams)); }
public object GetUserProfileByUserIDAndPropertys(string loginID, SystemUserProfilePropertysEntity propertysEntity) { SystemUserEntity user = this.DataObjectsContainerIocID.SystemUserDataObjectInstance.GetUserByLoginID(loginID); return(this.SelfDataObj.GetUserProfileByUserIDAndPropertys(user, propertysEntity)); }
public List <SystemUserRoleRelationEntity> GetList_By_UserID_SystemUserEntity(SystemUserEntity fkentity) { NHibernateDynamicQueryGenerator <SystemUserRoleRelationEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_USERID.Eq(fkentity)); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public List <SystemUserProfileEntity> FindAllByUserID(SystemUserEntity _userID) { return(this.SelfDataObj.GetList_By_UserID_SystemUserEntity(_userID)); }
public List <SystemUserProfileEntity> FindAllByOrderByAndFilterAndUserID(string orderByColumnName, bool isDesc, SystemUserEntity _userID, PageQueryParams pageQueryParams) { return(this.SelfDataObj.GetPageList_By_UserID_SystemUserEntity(orderByColumnName, isDesc, _userID, pageQueryParams)); }
/// <summary> /// 获取用户分配的角色 /// </summary> /// <param name="user"></param> /// <returns></returns> public List <SystemRoleEntity> GetUserAssignedRoleByUser(SystemUserEntity user) { List <SystemRoleEntity> list = this.DataObjectsContainerIocID.SystemUserRoleRelationDataObjectInstance.GetUserAssignedRoles(user); return(list); }
public List <SystemPrivilegeEntity> GetAllPrivilegeByCategoryByUserID(string categoryName, SystemUserEntity userEntity) { string hql = string.Format("select rp.PrivilegeID from {1} rp where rp.RoleID in (select ur.RoleID from {0} ur where ur.UserID = :userID)", SystemUserRoleRelationEntity.CLASS_FULL_NAME, SystemPrivilegeInRolesEntity.CLASS_FULL_NAME); if (!string.IsNullOrEmpty(categoryName)) { hql += " and (rp.PrivilegeID.PrivilegeCategory = :categoryName)"; } var parameters = new NhibernateParameterCollection(); parameters.AddParameter("userID", userEntity, NHibernateUtil.Entity(typeof(SystemUserEntity))); if (!string.IsNullOrEmpty(categoryName)) { parameters.AddParameter("categoryName", categoryName, NHibernateUtil.Entity(typeof(string))); } return(this.FindAllWithCustomQuery(hql, parameters)); }
public SystemUserProfileEntity GetUserProfileByUserID(string loginID) { SystemUserEntity user = this.DataObjectsContainerIocID.SystemUserDataObjectInstance.GetUserByLoginID(loginID); return(this.SelfDataObj.GetUserProfileByUser(user)); }
/// <summary> /// 检查用户角色对应关系是否存在 /// </summary> /// <param name="user"></param> /// <param name="role"></param> /// <returns></returns> private bool CheckUserRoleRelationIsExist(SystemUserEntity user, SystemRoleEntity role) { SystemUserRoleRelationEntity systemUserRoleRelation = this.DataObjectsContainerIocID.SystemUserRoleRelationDataObjectInstance.GetUserRoleRelation(user, role); return(systemUserRoleRelation != null); }
public List <SystemMenuEntity> GetMenuByApplication(SystemApplicationWrapper app, SystemUserEntity userEntity) { return(this.SelfDataObj.GetMenuByApplication(app.entity)); }
public static void Send(DbContext dbContext) { try { dbContext.Db.CodeFirst.InitTables( typeof(SystemUserEntity), typeof(RoleEntity), typeof(PermissionEntity), typeof(RolePermissionEntity), typeof(InfoConfigEntity), typeof(LogEntity)); var users = dbContext.Db.Queryable <SystemUserEntity>().ToList(); if (users.Count == 0) { //添加用户初始信息 SystemUserEntity userEntity = new SystemUserEntity() { LoginName = "admin", RealName = "administrator", Password = "******", CreateUserId = 1, RoleId = 1, CreationTime = DateTime.Now, IsDeleted = false, }; dbContext.Db.Insertable <SystemUserEntity>(userEntity).ExecuteCommand(); //添加权限初始信息 List <PermissionEntity> permissionEntities = new List <PermissionEntity>(); permissionEntities.Add(new PermissionEntity() { Name = "控制台", Url = "/Home/Index", CreationTime = DateTime.Now, IsDeleted = false, Type = PermissionType.Menu, Remark = "控制台", }); permissionEntities.Add(new PermissionEntity() { Name = "用户角色管理", CreationTime = DateTime.Now, IsDeleted = false, Type = PermissionType.Menu, Remark = "用户角色管理", }); permissionEntities.Add(new PermissionEntity() { Name = "用户管理", Url = "/User/Index", ParentId = 2, CreationTime = DateTime.Now, IsDeleted = false, Type = PermissionType.Menu, Remark = "用户管理", }); permissionEntities.Add(new PermissionEntity() { Name = "角色管理", Url = "/Role/Index", ParentId = 2, CreationTime = DateTime.Now, IsDeleted = false, Type = PermissionType.Menu, Remark = "角色管理", }); permissionEntities.Add(new PermissionEntity() { Name = "权限管理", Url = "/Permission/Index", ParentId = 2, CreationTime = DateTime.Now, IsDeleted = false, Type = PermissionType.Menu, Remark = "权限管理", }); permissionEntities.Add(new PermissionEntity() { Name = "角色权限分配", Url = "/RolePermission/Index", ParentId = 2, CreationTime = DateTime.Now, IsDeleted = false, Type = PermissionType.Menu, Remark = "角色权限分配", }); dbContext.Db.Insertable(permissionEntities).ExecuteCommand(); //添加角色初始信息 RoleEntity role = new RoleEntity() { Name = "超级管理员", CreateUserId = 1, CreationTime = DateTime.Now, IsDeleted = false, IsEnabled = true, Remark = "拥有所有权限的角色" }; dbContext.Db.Insertable <RoleEntity>(role).ExecuteCommand(); //添加角色权限初始信息 List <RolePermissionEntity> rolePermissionEntities = new List <RolePermissionEntity>(); rolePermissionEntities.Add(new RolePermissionEntity() { RoleId = 1, PermissionId = 1, IsDeleted = false, CreationTime = DateTime.Now }); rolePermissionEntities.Add(new RolePermissionEntity() { RoleId = 1, PermissionId = 2, IsDeleted = false, CreationTime = DateTime.Now }); rolePermissionEntities.Add(new RolePermissionEntity() { RoleId = 1, PermissionId = 3, IsDeleted = false, CreationTime = DateTime.Now }); rolePermissionEntities.Add(new RolePermissionEntity() { RoleId = 1, PermissionId = 4, IsDeleted = false, CreationTime = DateTime.Now }); rolePermissionEntities.Add(new RolePermissionEntity() { RoleId = 1, PermissionId = 5, IsDeleted = false, CreationTime = DateTime.Now }); rolePermissionEntities.Add(new RolePermissionEntity() { RoleId = 1, PermissionId = 6, IsDeleted = false, CreationTime = DateTime.Now }); dbContext.Db.Insertable <RolePermissionEntity>(rolePermissionEntities).ExecuteCommand(); } } catch (Exception ex) { throw ex; } }