public void Update(RemarksID remarksID)
{
StringBuilder builder = new StringBuilder("UPDATE " + AllConstant.REMARKS_TABLE + " SET ");
if (!string.IsNullOrEmpty(remarksID.remarks))
{
builder.Append("remarks = '" + remarksID.remarks + "',");
}
if (!string.IsNullOrEmpty(remarksID.A))
{
builder.Append("A = '" + remarksID.A + "',");
}
if (!string.IsNullOrEmpty(remarksID.R))
{
builder.Append("R = '" + remarksID.R + "',");
}
if (!string.IsNullOrEmpty(remarksID.G))
{
builder.Append("G = '" + remarksID.G + "',");
}
if (!string.IsNullOrEmpty(remarksID.B))
{
builder.Append("B = '" + remarksID.B + "'");
}
builder.Append(" WHERE id = '" + remarksID.id + "'");
SQLiteHelper.Instance.ExecuteNonQuery(builder.ToString(), CommandType.Text);
}
private void propertyList_FormatCell(object sender, FormatCellEventArgs e)
{
RemarksID remarksID = (RemarksID)e.Model;
if (string.IsNullOrEmpty(remarksID.A) && string.IsNullOrEmpty(remarksID.R) && string.IsNullOrEmpty(remarksID.G) && string.IsNullOrEmpty(remarksID.B))
{
e.SubItem.ForeColor = Color.Black;
}
else
{
e.SubItem.ForeColor = Color.FromArgb(int.Parse(remarksID.A), int.Parse(remarksID.R), int.Parse(remarksID.G), int.Parse(remarksID.B));
}
}
internal void UpdateList(string id, string deviceId, string typeId)
{
foreach (ItemPoint item in items)
{
if (item.deviceId.Equals(deviceId))
{
StringBuilder builder = new StringBuilder();
foreach (DataStreams dataStream in item.dataStreamsList)
{
RemarksID remarksID = RemarksDao.Instance.GetDeviceDataById(id);
foreach (DataPoints dataPoints in dataStream.datapoints)
{
dataPoints.at = dataPoints.at.Substring(0, dataPoints.at.Length - 4);
}
if (dataStream.id.Equals("P") || dataStream.id.Equals("T") || dataStream.id.Equals("H"))
{
//只获取最新的一个点在列表里显示
bool m = false;
foreach (DataPoints dataPoints in dataStream.datapoints)
{
if (m)
{
break;
}
if (remarksID != null && !string.IsNullOrEmpty(remarksID.remarks) && dataStream.id.Equals(typeId))
{
builder.Append(remarksID.remarks + "=" + dataPoints.value);
}
else
{
builder.Append(dataStream.id + "=" + dataPoints.value);
}
foreach (DeviceDataStreams stream in item.deviceDatastreams)
{
if (dataStream.id.Equals(stream.id))
{
builder.Append(stream.unit + " ");
m = true;
break;
}
}
}
}
}
item.dataStrams = builder.ToString();
deviceList.SetObjects(items);
break;
}
}
}
private void detailObject_FormatCell(object sender, FormatCellEventArgs e)
{
DetailValue detailValue = (DetailValue)e.Model;
RemarksID remarksID = RemarksDao.Instance.GetDeviceDataById(detailValue.ID + detailValue.Name);
if (remarksID != null && !string.IsNullOrEmpty(remarksID.remarks) && e.SubItem.Text.Equals(remarksID.typeId))
{
e.SubItem.Text = remarksID.remarks;
}
if (remarksID != null && !string.IsNullOrEmpty(remarksID.A) && !string.IsNullOrEmpty(remarksID.R) && !string.IsNullOrEmpty(remarksID.G) && !string.IsNullOrEmpty(remarksID.B))
{
e.SubItem.ForeColor = System.Drawing.Color.FromArgb(int.Parse(remarksID.A), int.Parse(remarksID.R), int.Parse(remarksID.G), int.Parse(remarksID.B));
}
else
{
e.SubItem.ForeColor = System.Drawing.Color.Black;
}
}
private void HandleSelectionChanged(ObjectListView propertyList)
{
if (propertyList.SelectedObject is RemarksID remarksID)
{
property.Text = remarksID.typeId;
remark.Text = remarksID.remarks;
remarks = remarksID;
if (string.IsNullOrEmpty(remarks.A) && string.IsNullOrEmpty(remarks.B) && string.IsNullOrEmpty(remarks.G) && string.IsNullOrEmpty(remarks.R))
{
pictureBox1.BackColor = Color.Black;
}
else
{
pictureBox1.BackColor = Color.FromArgb(int.Parse(remarks.A), int.Parse(remarks.R),
int.Parse(remarks.G), int.Parse(remarks.B));
}
}
}
public RemarksID GetDeviceDataById(string Id)
{
RemarksID remarksId = null;
string sql = "select * from " + AllConstant.REMARKS_TABLE + " WHERE id = '" + Id + "';";
SQLiteDataReader dataReader = (SQLiteDataReader)SQLiteHelper.Instance.ExecuteReader(sql, CommandType.Text);
while (dataReader.Read())
{
remarksId = new RemarksID();
remarksId.id = dataReader["id"].ToString();
remarksId.deviceId = dataReader["deviceId"].ToString();
remarksId.typeId = dataReader["typeId"].ToString();
remarksId.remarks = dataReader["remarks"].ToString();
remarksId.A = dataReader["A"].ToString();
remarksId.R = dataReader["R"].ToString();
remarksId.G = dataReader["G"].ToString();
remarksId.B = dataReader["B"].ToString();
}
dataReader.Close();
return(remarksId);
}
public List <RemarksID> GetAll(string deviceId)
{
List <RemarksID> remarksIdList = new List <RemarksID>();
string sql = "select * from " + AllConstant.REMARKS_TABLE + " WHERE deviceId = " + deviceId + ";";
SQLiteDataReader dataReader = (SQLiteDataReader)SQLiteHelper.Instance.ExecuteReader(sql, CommandType.Text);
while (dataReader.Read())
{
RemarksID remarksId = new RemarksID();
remarksId.id = dataReader["id"].ToString();
remarksId.deviceId = dataReader["deviceId"].ToString();
remarksId.typeId = dataReader["typeId"].ToString();
remarksId.remarks = dataReader["remarks"].ToString();
remarksId.A = dataReader["A"].ToString();
remarksId.R = dataReader["R"].ToString();
remarksId.G = dataReader["G"].ToString();
remarksId.B = dataReader["B"].ToString();
remarksIdList.Add(remarksId);
}
dataReader.Close();
return(remarksIdList);
}
private void AddTabPages(ItemPoint oLVListItem)
{
tabControl1.Controls.Clear();
foreach (DataStreams stream in oLVListItem.dataStreamsList)
{
TabPage tabPage1 = new TabPage();;
tabPage1.BackColor = System.Drawing.Color.White;
tabPage1.Location = new System.Drawing.Point(0, 0);
tabPage1.Name = stream.id;
tabPage1.Padding = new System.Windows.Forms.Padding(3);
tabPage1.Size = new System.Drawing.Size(619, 472);
tabPage1.TabIndex = 0;
RemarksID remarksID = RemarksDao.Instance.GetDeviceDataById(oLVListItem.deviceId + stream.id);
string title = null;
if (remarksID != null && !string.IsNullOrEmpty(remarksID.remarks))
{
title = remarksID.remarks + "曲线";
}
else
{
title = stream.id + "曲线";
}
System.Windows.Media.Color fillColor, strokeColor;
if (remarksID != null && !string.IsNullOrEmpty(remarksID.A) && !string.IsNullOrEmpty(remarksID.R) && !string.IsNullOrEmpty(remarksID.G) && !string.IsNullOrEmpty(remarksID.B))
{
fillColor = System.Windows.Media.Color.FromArgb(byte.Parse(remarksID.A), byte.Parse(remarksID.R), byte.Parse(remarksID.G), byte.Parse(remarksID.B));
strokeColor = System.Windows.Media.Color.FromArgb(byte.Parse(remarksID.A), byte.Parse(remarksID.R), byte.Parse(remarksID.G), byte.Parse(remarksID.B));
}
else
{
fillColor = System.Windows.Media.Color.FromArgb(255, 0, 0, 0);
strokeColor = System.Windows.Media.Color.FromArgb(225, 0, 0, 0);
}
tabPage1.Text = title;
this.tabControl1.Controls.Add(tabPage1);
//
// cartesianChart1
//
LiveCharts.WinForms.CartesianChart cartesianChart1 = new LiveCharts.WinForms.CartesianChart
{
Dock = System.Windows.Forms.DockStyle.Fill,
Location = new System.Drawing.Point(0, 0),
Name = "cartesianChart1",
Size = new System.Drawing.Size(619, 472),
TabIndex = 1,
Text = "cartesianChart1"
};
cartesianChart1.Zoom = ZoomingOptions.X;
List <DataPoints> dataPointsList = stream.datapoints;
double[] values = new double[dataPointsList.Count];
string[] labels = new string[dataPointsList.Count];
int m = dataPointsList.Count - 1;
foreach (DataPoints dataPoints in dataPointsList)
{
values[m] = double.Parse(dataPoints.value);
labels[m] = dataPoints.at;
m--;
}
cartesianChart1.Series = new SeriesCollection
{
new LineSeries
{
Title = title,
Values = new ChartValues <double>(values),
PointGeometry = DefaultGeometries.None,
Fill = new SolidColorBrush
{
Color = fillColor,
Opacity = .4
},
Stroke = new SolidColorBrush(strokeColor)
}
};
cartesianChart1.AxisX.Add(new Axis
{
Title = "时间",
Labels = labels
});
string unit = null;
foreach (DeviceDataStreams devicestream in oLVListItem.deviceDatastreams)
{
if (devicestream.id.Equals(stream.id))
{
unit = devicestream.unit;
break;
}
}
cartesianChart1.AxisY.Add(new Axis
{
//Title = "Sales",
LabelFormatter = value => value.ToString("") + unit
});
cartesianChart1.LegendLocation = LegendLocation.Top;
tabPage1.Controls.Add(cartesianChart1);
}
foreach (Control con in this.Controls)
{
if (!con.Name.Equals("Panel"))
{
con.Tag = con.Width + ":" + con.Height + ":" + con.Left + ":" + con.Top + ":" + con.Font.Size;
if (con.Controls.Count > 0)
{
SetTag(con);
}
}
}
}
/// <summary>
/// 获取绘制图表的数据点
/// </summary>
/// <param name="deviceData"></param>
/// <param name="result"></param>
public void GetDataPoints(ItemPoint deviceData, INetworkResult result, string datastream_id,
string limit, string start, string end, string cursor, string duration)
{
// client.Authenticator = new HttpBasicAuthenticator(username, password);
var request = new RestRequest("devices/{device_id}/datapoints", Method.GET);
request.AddUrlSegment("device_id", deviceData.deviceId); // replaces matching token in request.Resource
// add parameters for all properties on an object
//request.AddObject(object);
// or just whitelisted properties
//request.AddObject(object, "PersonId", "Name", ...);
// easily add HTTP Headers
request.AddHeader("api-key", "VtaeS4yK3Fk6xiOljgw69lYcH9k=");
if (!string.IsNullOrEmpty(datastream_id))
{
request.AddParameter("datastream_id", datastream_id);
}
if (!string.IsNullOrEmpty(limit))
{
request.AddParameter("limit", limit);
}
if (!string.IsNullOrEmpty(start))
{
request.AddParameter("start", start);
}
if (!string.IsNullOrEmpty(end))
{
request.AddParameter("end", end);
}
if (!string.IsNullOrEmpty(cursor))
{
request.AddParameter("cursor", cursor);
}
if (!string.IsNullOrEmpty(duration))
{
request.AddParameter("duration", duration);
}
IRestResponse response = client.Execute(request);
var content = response.Content; // raw content as string
if (response.ResponseStatus == ResponseStatus.Completed)
{
AppPoint point = JsonHelper.DeserializeJsonToObject <AppPoint>(content);
if (point.error.Equals("succ"))
{
ItemPoint item = new ItemPoint
{
deviceId = deviceData.deviceId,
title = deviceData.title
};
StringBuilder builder = new StringBuilder();
foreach (DataStreams dataStream in point.data.datastreams)
{
RemarksID remarksID = RemarksDao.Instance.GetDeviceDataById(item.deviceId + dataStream.id);
foreach (DataPoints dataPoints in dataStream.datapoints)
{
dataPoints.at = dataPoints.at.Substring(0, dataPoints.at.Length - 4);
}
if (dataStream.id.Equals("P") || dataStream.id.Equals("T") || dataStream.id.Equals("H"))
{
//只获取最新的一个点在列表里显示
bool m = false;
foreach (DataPoints dataPoints in dataStream.datapoints)
{
if (m)
{
break;
}
if (remarksID == null || string.IsNullOrEmpty(remarksID.remarks))
{
builder.Append(dataStream.id + "=" + dataPoints.value);
}
else
{
builder.Append(remarksID.remarks + "=" + dataPoints.value);
}
foreach (DeviceDataStreams stream in deviceData.deviceDatastreams)
{
if (dataStream.id.Equals(stream.id))
{
builder.Append(stream.unit + " ");
m = true;
break;
}
}
}
}
}
item.dataStreamsList = point.data.datastreams;
item.deviceDatastreams = deviceData.deviceDatastreams;
item.dataStrams = builder.ToString();
result.OnSuccess(item);
}
else
{
result.OnFailure(point.error);
}
}
else
{
result.OnFailure("获取" + deviceData.title + "的数据失败");
}
}
