Пример #1
0
        public List <SPAdReportEntity> QueryReport(DateTime startDate, DateTime endDate)
        {
            NHibernateDynamicQueryGenerator <SPAdReportEntity> query = this.GetNewQueryBuilder();

            //指定查询条件
            query.AddWhereClause(PROPERTY_REPORTDATE.Ge(startDate.Date));

            query.AddWhereClause(PROPERTY_REPORTDATE.Lt(endDate.AddDays(1).Date));

            return(this.FindListByQueryBuilder(query));
        }
        public List <SPDayReportEntity> QueryReport(DateTime startDate, DateTime endDate, SPSClientEntity clientEntity)
        {
            NHibernateDynamicQueryGenerator <SPDayReportEntity> dynamicQueryGenerator = this.GetNewQueryBuilder();

            //指定查询条件
            dynamicQueryGenerator.AddWhereClause(PROPERTY_REPORTDATE.Ge(startDate.Date));

            dynamicQueryGenerator.AddWhereClause(PROPERTY_REPORTDATE.Lt(endDate.AddDays(1).Date));

            dynamicQueryGenerator.AddWhereClause(PROPERTY_CLIENTID.Eq(clientEntity));

            return(this.FindListByQueryBuilder(dynamicQueryGenerator));
        }