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)); }