public SystemUserProfileEntity GetUserProfileByUser(SystemUserEntity userEntity)
{
NHibernateDynamicQueryGenerator <SystemUserProfileEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_USERID.Eq(userEntity));
return(this.FindSingleEntityByQueryBuilder(queryGenerator));
}
public SPClientEntity GetClientByUserID(int userId)
{
NHibernateDynamicQueryGenerator <SPClientEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_USERID.Eq(userId));
return(this.FindSingleEntityByQueryBuilder(queryGenerator));
}
public List <SystemUserRoleRelationEntity> GetUserRoleRelationByUser(SystemUserEntity user)
{
NHibernateDynamicQueryGenerator <SystemUserRoleRelationEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_USERID.Eq(user));
return(this.FindListByQueryBuilder(queryGenerator));
}
/// <summary>
/// 获取用户分配的角色
/// </summary>
/// <param name="user">用户</param>
/// <returns></returns>
public List <SystemRoleEntity> GetUserAssignedRoles(SystemUserEntity user)
{
NHibernateDynamicQueryGenerator <SystemUserRoleRelationEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_USERID.Eq(user));
return(this.FindListByProjection <SystemRoleEntity>(queryGenerator, SystemUserRoleRelationDataObject.PROPERTY_ROLEID));
}
public List <SystemUserGroupUserRelationEntity> GetAllRelationByUser(SystemUserEntity systemUserEntity)
{
NHibernateDynamicQueryGenerator <SystemUserGroupUserRelationEntity> dynamicQueryGenerator = this.GetNewQueryBuilder();
dynamicQueryGenerator.AddWhereClause(PROPERTY_USERID.Eq(systemUserEntity));
return(this.FindListByQueryBuilder(dynamicQueryGenerator));
}
public List <SystemUserProfileEntity> FindAllByUsers(List <SystemUserEntity> entities)
{
NHibernateDynamicQueryGenerator <SystemUserProfileEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_USERID.In(entities));
return(this.FindListByQueryBuilder(queryGenerator));
}
/// <summary>
/// 获取用户角色关系是否存在
/// </summary>
/// <param name="user">用户</param>
/// <param name="role">角色</param>
/// <returns></returns>
public SystemUserRoleRelationEntity GetUserRoleRelation(SystemUserEntity user, SystemRoleEntity role)
{
NHibernateDynamicQueryGenerator <SystemUserRoleRelationEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_USERID.Eq(user));
queryGenerator.AddWhereClause(PROPERTY_ROLEID.Eq(role));
return(this.FindSingleEntityByQueryBuilder(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 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 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));
}
/// <summary>
/// 分页查找所拥护
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalRecords"></param>
/// <returns></returns>
public List <SystemUserEntity> FindAllUsers(int pageIndex, int pageSize, out int totalRecords)
{
NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddOrderBy(PROPERTY_USERID.Desc());
queryGenerator.SetFirstResult((pageIndex - 1) * pageSize);
queryGenerator.SetMaxResults(pageSize);
return(this.FindListByPageByQueryBuilder(queryGenerator, out totalRecords));
}
/// <summary>
/// 分页查找所拥护
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalRecords"></param>
/// <returns></returns>
public List <SystemUserEntity> FindAllUsers(int pageIndex, int pageSize, out int totalRecords)
{
NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddOrderBy(PROPERTY_USERID.Desc());
PageQueryParams pageQueryParams = new PageQueryParams();
pageQueryParams.PageIndex = pageIndex;
pageQueryParams.PageSize = pageSize;
List <SystemUserEntity> result = this.FindListByPageByQueryBuilder(queryGenerator, pageQueryParams);
totalRecords = pageQueryParams.RecordCount;
return(result);
}
public SystemRoleEntity GetUserMinRoleTypeRole(SystemUserEntity systemUserEntity)
{
NHibernateDynamicQueryGenerator <SystemUserRoleRelationEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_USERID.Eq(systemUserEntity));
InClude_RoleID_Query(queryGenerator);
queryGenerator.AddOrderBy(PROPERTY_ROLEID_ROLETYPE.Asc());
SystemUserRoleRelationEntity userRoleRelationEntity = this.FindSingleEntityByQueryBuilder(queryGenerator);
if (userRoleRelationEntity == null)
{
return(null);
}
else
{
return(userRoleRelationEntity.RoleID);
}
}
