private static AssetDefinitionData Create(string deviceId, long agentInstanceId, MTConnect.MTConnectAssets.Asset asset) { var obj = new AssetDefinitionData(); // TrakHound Properties obj.DeviceId = deviceId; obj.AgentInstanceId = agentInstanceId; obj.Id = asset.AssetId; obj.Timestamp = asset.Timestamp; obj.Type = asset.Type; obj.Xml = asset.Xml; return(obj); }
public bool Write(List <AssetDefinitionData> definitions) { if (definitions.IsNullOrEmpty <AssetDefinitionData>()) { return(false); } string str = "`device_id`, `id`, `timestamp`, `agent_instance_id`, `type`, `xml`"; string format = "INSERT IGNORE INTO `assets` ({0}) VALUES {1}"; string str3 = "('{0}','{1}',{2},{3},'{4}','{5}')"; string[] strArray = new string[definitions.Count]; for (int i = 0; i < definitions.Count; i++) { AssetDefinitionData data = definitions[i]; strArray[i] = string.Format(str3, new object[] { this.EscapeString(data.DeviceId), this.EscapeString(data.Id), data.Timestamp.ToUnixTime(), data.AgentInstanceId, this.EscapeString(data.Type), this.EscapeString(data.Xml) }); } string str4 = string.Join(",", strArray); string query = string.Format(format, str, str4); return(this.Write(query)); }