private void Init(string deviceId, Connection connection, string deviceName, int interval)
{
if (connection != null)
{
AgentConnection = new ConnectionDefinitionData();
AgentConnection.Address = connection.Address;
AgentConnection.Port = connection.Port;
AgentConnection.PhysicalAddress = connection.PhysicalAddress;
AgentConnection.DeviceId = deviceId;
_deviceId = deviceId;
_address = connection.Address;
_physicalAddress = connection.PhysicalAddress;
_port = connection.Port;
_deviceName = deviceName;
_interval = interval;
}
}
public bool Write(List <ConnectionDefinitionData> definitions)
{
//Write ConnectionDefinitionData to Database
if (definitions.IsNullOrEmpty <ConnectionDefinitionData>())
{
return(false);
}
string str = "`device_id`, `address`, `port`, `physical_address`";
string format = "INSERT INTO `connections` ({0}) VALUES {1} ON DUPLICATE KEY UPDATE `address`=VALUES(`address`), `port`=VALUES(`port`), `physical_address`=VALUES(`physical_address`)";
string str3 = "('{0}','{1}',{2},'{3}')";
string[] strArray = new string[definitions.Count];
for (int i = 0; i < definitions.Count; i++)
{
ConnectionDefinitionData data = definitions[i];
strArray[i] = string.Format(str3, new object[] { this.EscapeString(data.DeviceId), this.EscapeString(data.Address), data.Port, this.EscapeString(data.PhysicalAddress) });
}
string str4 = string.Join(",", strArray);
string query = string.Format(format, str, str4);
return(this.Write(query));
}
