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 SystemConfigGroupEntity FindByCode(string groupCode)
{
NHibernateDynamicQueryGenerator <SystemConfigGroupEntity> dynamicQueryGenerator = this.GetNewQueryBuilder();
dynamicQueryGenerator.AddWhereClause(PROPERTY_CODE.Eq(groupCode));
dynamicQueryGenerator.AddOrderBy(PROPERTY_ID.Desc());
return(this.FindSingleEntityByQueryBuilder(dynamicQueryGenerator));
}
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 <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 <SPSendClientParamsEntity> GetAllEnableParams(SPClientEntity spClientEntity)
{
NHibernateDynamicQueryGenerator <SPSendClientParamsEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_CLIENTID.Eq(spClientEntity));
queryGenerator.AddWhereClause(PROPERTY_ISENABLE.Eq(true));
queryGenerator.AddOrderBy(PROPERTY_ID.Desc());
return(this.FindListByQueryBuilder(queryGenerator));
}
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));
}
