C# (CSharp) PROPERTY_ISAPPROVED示例

示例#1

        public List <SystemUserEntity> FindAllInactiveAuthenticatedProfiles(DateTime inactiveSinceDate)
        {
            NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder();

            queryGenerator.AddWhereClause(PROPERTY_LASTACTIVITYDATE.Lt(inactiveSinceDate));

            queryGenerator.AddWhereClause(PROPERTY_ISAPPROVED.Eq(true));

            queryGenerator.AddWhereClause(PROPERTY_ISLOCKEDOUT.Eq(false));

            return(this.FindListByQueryBuilder(queryGenerator));
        }

示例#2

文件： SystemUserDataObject.cs 项目： Ravivishnubhotla/basewebframework

        public List <SystemUserEntity> FindAllInactiveAuthenticatedProfiles(DateTime inactiveSinceDate, int pageIndex, int pageSize, out int totalRecords)
        {
            NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder();

            queryGenerator.AddWhereClause(PROPERTY_LASTACTIVITYDATE.Lt(inactiveSinceDate));

            queryGenerator.AddWhereClause(PROPERTY_ISAPPROVED.Eq(true));

            queryGenerator.AddWhereClause(PROPERTY_ISLOCKEDOUT.Eq(false));

            queryGenerator.SetFirstResult((pageIndex - 1) * pageSize);

            queryGenerator.SetMaxResults(pageSize);

            return(this.FindListByPageByQueryBuilder(queryGenerator, out totalRecords));
        }

示例#3

文件： SystemUserDataObject.cs 项目： Ravivishnubhotla/basewebframework

        public List <SystemUserEntity> FindAuthenticatedUserAll(int pageIndex, int pageSize, out int totalRecords)
        {
            NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder();

            queryGenerator.AddWhereClause(PROPERTY_ISAPPROVED.Eq(true));

            queryGenerator.AddWhereClause(PROPERTY_ISLOCKEDOUT.Eq(false));

            queryGenerator.SetFirstResult((pageIndex - 1) * pageSize);

            queryGenerator.SetMaxResults(pageSize);

            List <SystemUserEntity> result = this.FindListByPageByQueryBuilder(queryGenerator, out totalRecords);

            return(result);
        }

示例#4

        public List <SystemUserEntity> FindAuthenticatedUserAll(int pageIndex, int pageSize, out int totalRecords)
        {
            NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder();

            queryGenerator.AddWhereClause(PROPERTY_ISAPPROVED.Eq(true));

            queryGenerator.AddWhereClause(PROPERTY_ISLOCKEDOUT.Eq(false));

            PageQueryParams pageQueryParams = new PageQueryParams();

            pageQueryParams.PageIndex = pageIndex;

            pageQueryParams.PageSize = pageSize;

            List <SystemUserEntity> result = this.FindListByPageByQueryBuilder(queryGenerator, pageQueryParams);

            totalRecords = pageQueryParams.RecordCount;

            return(result);
        }