public IEnumerable <IConnectOptions> Load()
{
StringBuilder sqlBuilder = new StringBuilder("SELECT* FROM cfg_provider inner join cfg_provider_rabbitmq_connect ");
sqlBuilder.AppendLine(" on cfg_provider.id = cfg_provider_rabbitmq_connect.provider_id");
sqlBuilder.AppendLine(" where cfg_provider.record_state = 1 and cfg_provider_rabbitmq_connect.record_state = 1");
IList <IConnectOptions> results = new List <IConnectOptions>();
using (var dataReader = ExecuteReader(sqlBuilder.ToString()))
{
while (dataReader.Read())
{
var item = new RabbitConnectOptions
{
AutomaticRecoveryEnabled = dataReader["automatic_recovery_enabled"] == null ? true : System.Convert.ToBoolean(dataReader["automatic_recovery_enabled"].ToString()),
Account = dataReader["account"] == null ? string.Empty : dataReader["account"].ToString(),
Host = dataReader["host"] == null ? string.Empty : dataReader["host"].ToString(),
PassWord = dataReader["pass_word"] == null ? string.Empty : dataReader["pass_word"].ToString(),
Port = dataReader["port"] == null ? 0 : int.Parse(dataReader["port"].ToString()),
TagName = dataReader["tag_name"] == null ? string.Empty : dataReader["tag_name"].ToString(),
VirtualHost = dataReader["virtual_host"] == null ? string.Empty : dataReader["virtual_host"].ToString()
};
results.Add(item);
}
return(results);
}
}
public RabbitConnectionFactory(RabbitConnectOptions options)
{
Options = options;
_connectionFactory = new ConnectionFactory
{
HostName = Options.Host,
Password = Options.PassWord,
UserName = Options.Account,
Port = Options.Port,
AutomaticRecoveryEnabled = options.AutomaticRecoveryEnabled
};
}
public IEnumerable <IConnectOptions> Load()
{
IList <IConnectOptions> datas = new List <IConnectOptions>();
var cfg = (RabbitOptionConfig)ConfigurationManager.GetSection("rabbitOption");
if (cfg != null)
{
foreach (RabbitOptionElement item in cfg.Elements)
{
IConnectOptions data = new RabbitConnectOptions
{
Account = item.Account,
Host = item.Host,
Port = item.Port,
TagName = item.TagName,
PassWord = item.PassWord,
VirtualHost = item.VirtualHost
};
datas.Add(data);
}
}
return(datas);
}