public List <SPDayReportEntity> FindByDate(DateTime date)
{
NHibernateDynamicQueryGenerator <SPDayReportEntity> dynamicQueryGenerator = this.GetNewQueryBuilder();
//指定查询条件
dynamicQueryGenerator.AddWhereClause(PROPERTY_REPORTDATE.Eq(date.Date));
return(this.FindListByQueryBuilder(dynamicQueryGenerator));
}
public SPDayReportEntity FindReportByChannelIDChannelIDAndDate(int channelId, int clientId, DateTime date)
{
NHibernateDynamicQueryGenerator <SPDayReportEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(channelId));
queryGenerator.AddWhereClause(PROPERTY_CLIENTID.Eq(clientId));
queryGenerator.AddWhereClause(PROPERTY_REPORTDATE.Eq(new DateTime(date.Year, date.Month, date.Day)));
return(this.FindSingleEntityByQueryBuilder(queryGenerator));
}
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));
}
public SPAdReportEntity FindByCilentIDAdPackIDAndReportDate(int?spadId, SPAdPackEntity spPackId, SPSClientEntity spClientId, DateTime?reportDate)
{
NHibernateDynamicQueryGenerator <SPAdReportEntity> query = this.GetNewQueryBuilder();
//指定查询条件
query.AddWhereClause(PROPERTY_REPORTDATE.Eq(reportDate.Value));
query.AddWhereClause(PROPERTY_SPCLIENTID.Eq(spClientId));
query.AddWhereClause(PROPERTY_SPADID.Eq(spadId.Value));
query.AddWhereClause(PROPERTY_SPPACKID.Eq(spPackId));
return(this.FindSingleEntityByQueryBuilder(query));
}
