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