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;
}
}
