Esempio n. 1
0
        public List <SystemUserEntity> FindUsersByNames(string[] usernames)
        {
            NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder();

            queryGenerator.AddWhereClause(PROPERTY_USERLOGINID.In(usernames));

            return(this.FindListByQueryBuilder(queryGenerator));
        }
Esempio n. 2
0
        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));
        }