public List <SPClientChannelSettingEntity> FindAllByOrderByAndFilterAndChannelIDAndProvinceAndPort(string sortFieldName, bool isDesc, SPChannelEntity channelEntity, string province, string port, int pageIndex, int pageSize, out int recordCount) { NHibernateDynamicQueryGenerator <SPClientChannelSettingEntity> queryGenerator = this.GetNewQueryBuilder(); if (channelEntity != null) { queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(channelEntity)); } queryGenerator.AddWhereClause(Or(PROPERTY_DISABLE.IsNull(), PROPERTY_DISABLE.Eq(false))); if (!string.IsNullOrEmpty(province)) { queryGenerator.AddWhereClause(PROPERTY_ALLOWANDDISABLEAREA.Like(province, MatchMode.Anywhere)); } if (!string.IsNullOrEmpty(port)) { queryGenerator.AddWhereClause(PROPERTY_CHANNELCODE.Like(port, MatchMode.Anywhere)); } AddDefaultOrderByToQueryGenerator(sortFieldName, isDesc, queryGenerator); queryGenerator.SetFirstResult((pageIndex - 1) * pageSize); queryGenerator.SetMaxResults(pageSize); List <SPClientChannelSettingEntity> results = FindListByPageByQueryBuilder(queryGenerator, out recordCount); return(results); }
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> FindAllByChannelIDAndClientChannelIDAndPhoneListByOrderBy(SPChannelEntity channelId, int clientChannelId, List <string> phones, string sortFieldName, bool isDesc, int pageIndex, int limit, out int recordCount) { var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>(); if (channelId != null) { queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(channelId)); } if (clientChannelId > 0) { queryBuilder.AddWhereClause(PROPERTY_CHANNLECLIENTID.Eq(clientChannelId)); } if (phones != null && phones.Count > 0) { queryBuilder.AddWhereClause(PROPERTY_MOBILENUMBER.In(phones)); } AddDefaultOrderByToQueryGenerator(sortFieldName, isDesc, queryBuilder); queryBuilder.SetFirstResult((pageIndex - 1) * limit); queryBuilder.SetMaxResults(limit); return(FindListByPageByQueryBuilder(queryBuilder, out recordCount)); }
public List <SPClientChannelSettingEntity> GetSettingByChannel(SPChannelEntity spChannelEntity) { NHibernateDynamicQueryGenerator <SPClientChannelSettingEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(spChannelEntity)); return(this.FindListByQueryBuilder(queryGenerator)); }
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)); }
public SPSStatePaymentInfoEntity FindByChannelIDAndLinkID(int channelId, string linkid) { var queryBuilder = new NHibernateDynamicQueryGenerator <SPSStatePaymentInfoEntity>(); queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(channelId)); queryBuilder.AddWhereClause(PROPERTY_LINKID.Eq(linkid)); return(this.FindSingleEntityByQueryBuilder(queryBuilder)); }
public SPInterceptRateEntity FindRateByChannelIdAndClinetId(int channelId, int clientId) { NHibernateDynamicQueryGenerator <SPInterceptRateEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(channelId)); queryGenerator.AddWhereClause(PROPERTY_CLIENTID.Eq(clientId)); return(this.FindSingleEntityByQueryBuilder(queryGenerator)); }
public SPRecordEntity FindByLinkIDAndChannelID(SPChannelEntity spChannelEntity, string linkId) { var queryBuilder = new NHibernateDynamicQueryGenerator <SPRecordEntity>(); queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(spChannelEntity)); queryBuilder.AddWhereClause(PROPERTY_LINKID.Eq(linkId)); return(this.FindSingleEntityByQueryBuilder(queryBuilder)); }
public SPPaymentInfoEntity CheckChannleLinkIDIsExist(SPChannelEntity spChannelEntity, SPPaymentInfoEntity paymentInfo) { var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>(); queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(spChannelEntity)); queryBuilder.AddWhereClause(PROPERTY_LINKID.Eq(paymentInfo.Linkid)); return(this.FindSingleEntityByQueryBuilder(queryBuilder)); }
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 <SPChannelDefaultClientSycnParamsEntity> GetAllEnableDefaultSendParams(SPChannelEntity spChannelEntity) { NHibernateDynamicQueryGenerator <SPChannelDefaultClientSycnParamsEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(spChannelEntity)); queryGenerator.AddWhereClause(PROPERTY_ISENABLE.Eq(true)); queryGenerator.AddOrderBy(PROPERTY_ID.Desc()); return(this.FindListByQueryBuilder(queryGenerator)); }
public List <SPChannelParamsEntity> GetAllShowParams(SPChannelEntity channle) { NHibernateDynamicQueryGenerator <SPChannelParamsEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(channle)); queryGenerator.AddWhereClause(PROPERTY_ISENABLE.Eq(true)); queryGenerator.AddOrderBy(PROPERTY_ID.Desc()); return(this.FindListByQueryBuilder(queryGenerator)); }
public List <SPCodeInfoEntity> FindAllByOrderByAndFilterAndChannelID(SPChannelEntity channelEntity, List <QueryFilter> queryFilters, string orderByColumnName, bool isDesc) { NHibernateDynamicQueryGenerator <SPCodeInfoEntity> queryGenerator = this.GetNewQueryBuilder(); if (channelEntity != null) { queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(channelEntity)); } AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, queryGenerator); List <SPCodeInfoEntity> results = FindListByQueryBuilder(queryGenerator); return(results); }
public SPPaymentInfoEntity CheckChannleLinkIDIsExist(SPChannelEntity spChannelEntity, SPPaymentInfoEntity paymentInfo, List <string> uniqueKeyNames) { var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>(); queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(spChannelEntity)); queryBuilder.AddWhereClause(PROPERTY_LINKID.Eq(paymentInfo.Linkid)); if (uniqueKeyNames.Contains("mobile")) { queryBuilder.AddWhereClause(PROPERTY_MOBILENUMBER.Eq(paymentInfo.MobileNumber)); } return(this.FindSingleEntityByQueryBuilder(queryBuilder)); }
public List <SPChannelParamsEntity> FindPageDataByChannelID(string orderByColumnName, bool isDesc, int pageIndex, int pageSize, SPChannelEntity channle, out int recordCount) { NHibernateDynamicQueryGenerator <SPChannelParamsEntity> queryGenerator = this.GetNewQueryBuilder(); if (channle == null) { recordCount = 0; return(new List <SPChannelParamsEntity>()); } else { queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(channle)); } AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, queryGenerator); return(this.FindListByPageByQueryBuilder(queryGenerator, pageIndex, pageSize, out recordCount)); }
public List <SPCodeInfoEntity> FindAllByOrderByAndFilterAndChannelID(SPChannelEntity channelEntity, List <QueryFilter> filters, string orderByColumnName, bool isDesc, int pageIndex, int pageSize, out int recordCount) { NHibernateDynamicQueryGenerator <SPCodeInfoEntity> queryGenerator = this.GetNewQueryBuilder(); if (channelEntity != null) { queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(channelEntity)); } AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, queryGenerator); queryGenerator.SetFirstResult((pageIndex - 1) * pageSize); queryGenerator.SetMaxResults(pageSize); List <SPCodeInfoEntity> results = FindListByPageByQueryBuilder(queryGenerator, out recordCount); return(results); }
private NHibernateDynamicQueryGenerator <SPRecordEntity> BuilderQueryGenerator(SPChannelEntity channel, SPCodeEntity code, SPSClientEntity client, string dataType, DateTime?startDate, DateTime?endDate, List <QueryFilter> filters, string orderByColumnName, bool isDesc) { var queryBuilder = new NHibernateDynamicQueryGenerator <SPRecordEntity>(); if (channel != null) { queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(channel)); } if (code != null) { queryBuilder.AddWhereClause(PROPERTY_CODEID.Eq(code)); } if (client != null) { queryBuilder.AddWhereClause(PROPERTY_CLIENTID.Eq(client)); } DayReportType reportType = (DayReportType)Enum.Parse(typeof(DayReportType), dataType); SetReportTypeFilter(queryBuilder, reportType); if (startDate != null) { queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Ge(startDate.Value.Date)); } if (endDate != null) { queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Lt(endDate.Value.Date.AddDays(1))); } AddQueryFiltersToQueryGenerator(filters, queryBuilder); AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, queryBuilder); return(queryBuilder); }
public List <SPPaymentInfoEntity> FindAllByChannelIDAndClientChannelIDAndPhoneList(SPChannelEntity channelId, int clientChannelId, List <string> phones) { var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>(); if (channelId != null) { queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(channelId)); } if (clientChannelId > 0) { queryBuilder.AddWhereClause(PROPERTY_CHANNLECLIENTID.Eq(clientChannelId)); } if (phones != null && phones.Count > 0) { queryBuilder.AddWhereClause(PROPERTY_MOBILENUMBER.In(phones)); } queryBuilder.AddOrderBy(PROPERTY_ID.Asc()); return(FindListByQueryBuilder(queryBuilder)); }