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