public SPClientPriceEntity GetClientPriceByClientID(int clientid, int clientGroupid)
{
NHibernateDynamicQueryGenerator <SPClientPriceEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_SPCLIENTID.Eq(clientid));
queryGenerator.AddWhereClause(PROPERTY_SPCLIENTGROUPID.Eq(clientGroupid));
return(this.FindSingleEntityByQueryBuilder(queryGenerator));
}
public List <SPAdAssignedHistortyEntity> FindAllCLientAssignedAdPack(SPSClientEntity client)
{
NHibernateDynamicQueryGenerator <SPAdAssignedHistortyEntity> query = this.GetNewQueryBuilder();
query.AddWhereClause(PROPERTY_ENDDATE.IsNull());
query.AddWhereClause(PROPERTY_SPCLIENTID.Eq(client));
return(FindListByQueryBuilder(query));
}
public List <SPAdReportEntity> QueryReport(DateTime startDate, DateTime endDate, SPSClientEntity spsClientEntity)
{
NHibernateDynamicQueryGenerator <SPAdReportEntity> query = this.GetNewQueryBuilder();
//指定查询条件
query.AddWhereClause(PROPERTY_REPORTDATE.Ge(startDate.Date));
query.AddWhereClause(PROPERTY_REPORTDATE.Lt(endDate.AddDays(1).Date));
query.AddWhereClause(PROPERTY_SPCLIENTID.Eq(spsClientEntity));
return(this.FindListByQueryBuilder(query));
}
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));
}
