public List <SPPaymentInfoEntity> FindAllNotSendData(int clientChannelId, DateTime startDate, DateTime endDate, int maxRetryCount) { var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>(); if (startDate == DateTime.MinValue) { startDate = DateTime.Now.Date; } if (endDate == DateTime.MinValue) { endDate = DateTime.Now.Date; } queryBuilder.AddWhereClause(PROPERTY_CHANNLECLIENTID.Eq(clientChannelId)); queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Ge(startDate.Date)); queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Lt(endDate.AddDays(1).Date)); queryBuilder.AddWhereClause(PROPERTY_ISINTERCEPT.Eq(false)); queryBuilder.AddWhereClause(PROPERTY_SUCESSSTOSEND.Eq(false)); queryBuilder.AddWhereClause(PROPERTY_ISSYCNDATA.Eq(true)); queryBuilder.AddWhereClause(Or(PROPERTY_SYCNRETRYTIMES.IsNull(), PROPERTY_SYCNRETRYTIMES.Lt(maxRetryCount))); queryBuilder.AddOrderBy(PROPERTY_ID.Asc()); return(this.FindListByQueryBuilder(queryBuilder)); }
public List <SPPaymentInfoEntity> FindAllNotSendData(SPChannelEntity channelId, SPClientEntity clientId, DateTime startdate, DateTime endDate, int maxDataCount) { var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>(); if (channelId != null) { queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(channelId)); } if (clientId != null) { queryBuilder.AddWhereClause(PROPERTY_CLIENTID.Eq(clientId)); } queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Ge(startdate.Date)); queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Lt(endDate.AddDays(1).Date)); queryBuilder.AddWhereClause(PROPERTY_ISINTERCEPT.Eq(false)); queryBuilder.AddWhereClause(PROPERTY_SUCESSSTOSEND.Eq(false)); queryBuilder.SetMaxResults(maxDataCount); return(this.FindListByQueryBuilder(queryBuilder)); }
public List <SPPaymentInfoEntity> FindAllDataTableByOrderByAndCleintIDAndChanneLIDAndDate(SPChannelEntity channelId, SPClientEntity clientId, DateTime startDateTime, DateTime enddateTime, string dataType, string sortFieldName, bool isDesc, int pageIndex, int pageSize, out int recordCount) { var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>(); if (channelId != null) { queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(channelId)); } if (clientId != null) { queryBuilder.AddWhereClause(PROPERTY_CLIENTID.Eq(clientId)); } if (startDateTime == DateTime.MinValue) { startDateTime = DateTime.Now; } if (enddateTime == DateTime.MinValue) { enddateTime = DateTime.Now; } queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Ge(startDateTime.Date)); queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Lt(enddateTime.AddDays(1).Date)); switch (dataType) { case "All": break; case "Intercept": queryBuilder.AddWhereClause(PROPERTY_ISINTERCEPT.Eq(true)); break; case "Down": queryBuilder.AddWhereClause(PROPERTY_ISINTERCEPT.Eq(false)); break; case "DownSycn": queryBuilder.AddWhereClause(PROPERTY_ISINTERCEPT.Eq(false)); queryBuilder.AddWhereClause(PROPERTY_SUCESSSTOSEND.Eq(true)); break; } AddDefaultOrderByToQueryGenerator(sortFieldName, isDesc, queryBuilder); queryBuilder.SetFirstResult((pageIndex - 1) * pageSize); queryBuilder.SetMaxResults(pageSize); return(FindListByPageByQueryBuilder(queryBuilder, out recordCount)); }