public SystemEmailTemplateEntity GetTemplateByName(string name)
{
NHibernateDynamicQueryGenerator <SystemEmailTemplateEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_NAME.Eq(name));
queryGenerator.AddWhereClause(PROPERTY_ISENABLE.Eq(true));
return(this.FindSingleEntityByQueryBuilder(queryGenerator));
}
public SystemEmailSettingsEntity GetDefaultSetting()
{
NHibernateDynamicQueryGenerator <SystemEmailSettingsEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_ISDEFAULT.Eq(true));
queryGenerator.AddWhereClause(PROPERTY_ISENABLE.Eq(true));
return(this.FindSingleEntityByQueryBuilder(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 <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));
}