public List <SystemUserEntity> FindUsersByNames(string[] usernames)
{
NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_USERLOGINID.In(usernames));
return(this.FindListByQueryBuilder(queryGenerator));
}
/// <summary>
/// 通过用户名密码获取用户
/// </summary>
/// <param name="loginID"></param>
/// <param name="password"></param>
/// <returns></returns>
public SystemUserEntity GetUserByLoginIDAndPassword(string loginID, string password)
{
NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_USERLOGINID.Eq(loginID));
queryGenerator.AddWhereClause(PROPERTY_USERPASSWORD.Eq(password));
return(this.FindSingleEntityByQueryBuilder(queryGenerator));
}
public List <SystemUserEntity> FindAllByOrderByExpcept(string sortFieldName, bool isDesc, List <string> expceptUserLoginId, List <string> expceptRoleName, PageQueryParams pageQueryParams)
{
NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder();
AddDefaultOrderByToQueryGenerator(sortFieldName, isDesc, queryGenerator);
queryGenerator.AddWhereClause(Not(PROPERTY_USERLOGINID.In(expceptUserLoginId)));
//queryGenerator.AddWhereClause(Not(PROPERTY_USERLOGINID.In(expceptUserLoginId)));
return(this.FindListByPageByQueryBuilder(queryGenerator, pageQueryParams));
}
/// <summary>
/// 通过用户名分页查找用户
/// </summary>
/// <param name="userName"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalRecords"></param>
/// <returns></returns>
public List <SystemUserEntity> FindUsersByName(string userName, int pageIndex, int pageSize, out int totalRecords)
{
NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_USERLOGINID.Like(userName));
queryGenerator.SetFirstResult((pageIndex - 1) * pageSize);
queryGenerator.SetMaxResults(pageSize);
return(this.FindListByPageByQueryBuilder(queryGenerator, out totalRecords));
}
/// <summary>
/// 通过用户名分页查找用户
/// </summary>
/// <param name="userName"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalRecords"></param>
/// <returns></returns>
public List <SystemUserEntity> FindUsersByName(string userName, int pageIndex, int pageSize, out int totalRecords)
{
NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_USERLOGINID.Like(userName));
PageQueryParams pageQueryParams = new PageQueryParams();
pageQueryParams.PageIndex = pageIndex;
pageQueryParams.PageSize = pageSize;
List <SystemUserEntity> result = this.FindListByPageByQueryBuilder(queryGenerator, pageQueryParams);
totalRecords = pageQueryParams.RecordCount;
return(result);
}
