/// <summary>
/// 通过Email获取用户
/// </summary>
/// <param name="email"></param>
/// <returns></returns>
public SystemUserEntity GetUserByEmail(string email)
{
NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_USEREMAIL.Eq(email));
return(this.FindSingleEntityByQueryBuilder(queryGenerator));
}
/// <summary>
/// 通过Email分页查找用户
/// </summary>
/// <param name="emailToMatch"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalRecords"></param>
/// <returns></returns>
public List <SystemUserEntity> FindUsersByEmail(string emailToMatch, int pageIndex, int pageSize, out int totalRecords)
{
NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_USEREMAIL.Like(emailToMatch));
queryGenerator.SetFirstResult((pageIndex - 1) * pageSize);
queryGenerator.SetMaxResults(pageSize);
return(this.FindListByPageByQueryBuilder(queryGenerator, out totalRecords));
}
/// <summary>
/// 通过Email分页查找用户
/// </summary>
/// <param name="emailToMatch"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalRecords"></param>
/// <returns></returns>
public List <SystemUserEntity> FindUsersByEmail(string emailToMatch, int pageIndex, int pageSize, out int totalRecords)
{
NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_USEREMAIL.Like(emailToMatch));
PageQueryParams pageQueryParams = new PageQueryParams();
pageQueryParams.PageIndex = pageIndex;
pageQueryParams.PageSize = pageSize;
List <SystemUserEntity> result = this.FindListByPageByQueryBuilder(queryGenerator, pageQueryParams);
totalRecords = pageQueryParams.RecordCount;
return(result);
}
