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