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 + "的数据失败"); } }