public List <SPPaymentInfoEntity> FindAllDefaultClientPaymentByOrderByDate(List <SPClientEntity> spClientEntities, DateTime startDate, DateTime endDate, string sortFieldName, bool isDesc, int pageIndex, int limit, out int recordCount) { var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>(); queryBuilder.AddWhereClause(PROPERTY_CLIENTID.In(spClientEntities)); if (startDate != DateTime.MinValue) { queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Ge(startDate.Date)); } if (endDate != DateTime.MinValue) { queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Lt(endDate.AddDays(1).Date)); } AddDefaultOrderByToQueryGenerator(sortFieldName, isDesc, queryBuilder); queryBuilder.SetFirstResult((pageIndex - 1) * limit); queryBuilder.SetMaxResults(limit); return(FindListByPageByQueryBuilder(queryBuilder, out recordCount)); }
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 <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> FindAllByOrderByAndClientIDAndDateNoIntercept(SPClientEntity clientEntity, DateTime startDate, DateTime endDate, string sortFieldName, bool isdesc, int pageIndex, int limit, out int recordCount) { var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>(); queryBuilder.AddWhereClause(PROPERTY_CLIENTID.Eq(clientEntity)); if (startDate == DateTime.MinValue) { startDate = DateTime.Now; } if (endDate == DateTime.MinValue) { endDate = DateTime.Now; } queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Ge(startDate.Date)); queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Lt(endDate.AddDays(1).Date)); queryBuilder.AddWhereClause(PROPERTY_ISINTERCEPT.Eq(false)); AddDefaultOrderByToQueryGenerator(sortFieldName, isdesc, queryBuilder); queryBuilder.SetFirstResult((pageIndex - 1) * limit); queryBuilder.SetMaxResults(limit); return(FindListByPageByQueryBuilder(queryBuilder, out recordCount)); }
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 <DomainType> FindListByPageByQueryBuilder(NHibernateDynamicQueryGenerator <DomainType> queryBuilder, int pageIndex, int pageSize, out int recordCount) { queryBuilder.SetFirstResult((pageIndex - 1) * pageSize); queryBuilder.SetMaxResults(pageSize); return(queryBuilder.FindListByPage(DoGetSession(false), out recordCount)); }
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 List <SPPaymentInfoEntity> FindAllByOrderByAndSPClientGroupIDAndDateAndProviceNoIntercept(List <SPClientEntity> spClientEntities, int spClientGroupID, DateTime startDate, DateTime endDate, string province, string city, string phone, string sortFieldName, bool isdesc, int pageIndex, int limit, out int recordCount) { var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>(); queryBuilder.AddWhereClause(PROPERTY_CLIENTID.In(spClientEntities)); if (startDate == DateTime.MinValue) { startDate = DateTime.Now; } if (endDate == DateTime.MinValue) { endDate = DateTime.Now; } if (!string.IsNullOrEmpty(province)) { if (province.Equals("NULL")) { queryBuilder.AddWhereClause(PROPERTY_PROVINCE.Eq("")); } else { queryBuilder.AddWhereClause(PROPERTY_PROVINCE.Eq(province)); } } if (!string.IsNullOrEmpty(city)) { queryBuilder.AddWhereClause(PROPERTY_CITY.Eq(city)); } if (!string.IsNullOrEmpty(phone)) { queryBuilder.AddWhereClause(PROPERTY_MOBILENUMBER.Like(phone, MatchMode.Start)); } 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_CLIENTGROUPID.Eq(spClientGroupID)); AddDefaultOrderByToQueryGenerator(sortFieldName, isdesc, queryBuilder); queryBuilder.SetFirstResult((pageIndex - 1) * limit); queryBuilder.SetMaxResults(limit); return(FindListByPageByQueryBuilder(queryBuilder, out recordCount)); }
/// <summary> /// 通过用户名分页查找用户 /// </summary> /// <param name="userName"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="totalRecords"></param> /// <returns></returns> public List <SystemUserEntity> FindUsersByName(string userName, int pageIndex, int pageSize, out int totalRecords) { NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_USERLOGINID.Like(userName)); queryGenerator.SetFirstResult((pageIndex - 1) * pageSize); queryGenerator.SetMaxResults(pageSize); return(this.FindListByPageByQueryBuilder(queryGenerator, out totalRecords)); }
internal List <SystemUserEntity> FindAllInactiveProfiles(DateTime inactiveSinceDate, int pageIndex, int pageSize, out int totalRecords) { NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_LASTACTIVITYDATE.Lt(inactiveSinceDate)); queryGenerator.SetFirstResult((pageIndex - 1) * pageSize); queryGenerator.SetMaxResults(pageSize); return(this.FindListByPageByQueryBuilder(queryGenerator, out totalRecords)); }
/// <summary> /// 分页查找所拥护 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="totalRecords"></param> /// <returns></returns> public List <SystemUserEntity> FindAllUsers(int pageIndex, int pageSize, out int totalRecords) { NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddOrderBy(PROPERTY_USERID.Desc()); queryGenerator.SetFirstResult((pageIndex - 1) * pageSize); queryGenerator.SetMaxResults(pageSize); return(this.FindListByPageByQueryBuilder(queryGenerator, out totalRecords)); }
public List <SPClientChannelSycnParamsEntity> GetPageList_By_SPClientChannelSettingEntity(string orderByColumnName, bool isDesc, int pageIndex, int pageSize, SPClientChannelSettingEntity fkentity, out int recordCount) { NHibernateDynamicQueryGenerator <SPClientChannelSycnParamsEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_CLIENTCHANNELSETTINGID.Eq(fkentity)); AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, dynamicQueryGenerator); dynamicQueryGenerator.SetFirstResult((pageIndex - 1) * pageSize); dynamicQueryGenerator.SetMaxResults(pageSize); return(FindListByPageByQueryBuilder(dynamicQueryGenerator, out recordCount)); }
public List <SystemUserEntity> FindAuthenticatedUserAll(int pageIndex, int pageSize, out int totalRecords) { NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_ISAPPROVED.Eq(true)); queryGenerator.AddWhereClause(PROPERTY_ISLOCKEDOUT.Eq(false)); queryGenerator.SetFirstResult((pageIndex - 1) * pageSize); queryGenerator.SetMaxResults(pageSize); List <SystemUserEntity> result = this.FindListByPageByQueryBuilder(queryGenerator, out totalRecords); return(result); }
public List <DomainType> FindAllByOrderByAndFilter(List <QueryFilter> filters, string orderByColumn, bool isDesc, int firstRow, int maxRows, out int recordCount) { NHibernateDynamicQueryGenerator <DomainType> queryBuilder = new NHibernateDynamicQueryGenerator <DomainType>(); //构造Filter查询条件 AddQueryFiltersToQueryGenerator(filters, queryBuilder); AddDefaultOrderByToQueryGenerator(orderByColumn, isDesc, queryBuilder); queryBuilder.SetFirstResult(firstRow); queryBuilder.SetMaxResults(maxRows); List <DomainType> results = FindListByPageByQueryBuilder(queryBuilder, out recordCount); return(results); }
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); }