public List <SystemUserEntity> FindUsersByNames(string[] usernames)
{
NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_USERLOGINID.In(usernames));
return(this.FindListByQueryBuilder(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));
}