private static DataItemDefinitionData Create(string deviceId, long agentInstanceId, string parentId, MTConnectDevices.DataItem dataItem)
{
var obj = new DataItemDefinitionData();
// TrakHound Properties
obj.DeviceId = deviceId;
obj.ParentId = parentId;
// MTConnect Properties
obj.AgentInstanceId = agentInstanceId;
obj.Id = dataItem.Id;
obj.Name = dataItem.Name;
obj.Category = dataItem.Category.ToString();
obj.Type = dataItem.Type;
obj.SubType = dataItem.SubType;
obj.Statistic = dataItem.Statistic;
obj.Units = dataItem.Units;
obj.NativeUnits = dataItem.NativeUnits;
obj.NativeScale = dataItem.NativeScale;
obj.CoordinateSystem = dataItem.CoordinateSystem;
obj.SampleRate = dataItem.SampleRate;
obj.Representation = dataItem.Representation;
obj.SignificantDigits = dataItem.SignificantDigits;
return(obj);
}
public bool Write(List <DataItemDefinitionData> definitions)
{
if (definitions.IsNullOrEmpty <DataItemDefinitionData>())
{
return(false);
}
string str = "`device_id`,`agent_instance_id`, `id`, `name`, `category`, `type`, `sub_type`, `statistic`, `units`,`native_units`,`native_scale`,`coordinate_system`,`sample_rate`,`representation`,`significant_digits`,`parent_id`";
string format = "INSERT IGNORE INTO `data_items` ({0}) VALUES {1}";
string str3 = "('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}')";
string[] strArray = new string[definitions.Count];
for (int i = 0; i < definitions.Count; i++)
{
DataItemDefinitionData data = definitions[i];
strArray[i] = string.Format(str3, new object[] { this.EscapeString(data.DeviceId), data.AgentInstanceId, data.Id, this.EscapeString(data.Name), this.EscapeString(data.Category), this.EscapeString(data.Type), this.EscapeString(data.SubType), this.EscapeString(data.Statistic), this.EscapeString(data.Units), this.EscapeString(data.NativeUnits), this.EscapeString(data.NativeScale), this.EscapeString(data.CoordinateSystem), data.SampleRate, this.EscapeString(data.Representation), data.SignificantDigits, this.EscapeString(data.ParentId) });
}
string str4 = string.Join(",", strArray);
string query = string.Format(format, str, str4);
return(this.Write(query));
}
