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