void Load24h(int load) { Class.NW_Device_Status cl = new Class.NW_Device_Status(); DataTable dt = new DataTable(); if (load == 0) { dt = cl.NW_Device_Status_Get24h(); } else { dt = cl.NW_Device_Status_GetList(); } Series Modems = new Series("Modem", ViewType.SplineArea); Series PCs = new Series("PCs ", ViewType.SplineArea); Series I0 = new Series("Card 0/0", ViewType.Line); Series I1 = new Series("Card 1/0", ViewType.Line); Series I2 = new Series("Card 2/0", ViewType.Line); Series I3 = new Series("Card 3/0", ViewType.Line); Series I4 = new Series("Card 4/0", ViewType.Line); Series I5 = new Series("Card 5/0", ViewType.Line); Series I9 = new Series("Card 9/0", ViewType.Line); Series I10 = new Series("Card 10/0", ViewType.Line); Series I11 = new Series("Card 11/0", ViewType.Line); I0.Points.Clear(); I1.Points.Clear(); I2.Points.Clear(); I3.Points.Clear(); I4.Points.Clear(); I5.Points.Clear(); I9.Points.Clear(); I10.Points.Clear(); I11.Points.Clear(); Modems.Points.Clear(); PCs.Points.Clear(); chartDevicePC.Series.Clear(); chartInterface.Series.Clear(); chartDevicePC1.Series.Clear(); chartInterface1.Series.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Interface"].ToString() == "Totals") { Modems.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); Modems.LegendText = "Modems: " + dt.Rows[i]["Modems"].ToString(); PCs.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Hosts"].ToString())); PCs.LegendText = "PCs: " + dt.Rows[i]["Hosts"].ToString(); } if (dt.Rows[i]["Interface"].ToString() == "Cable 0/0") { I0.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); I0.LegendText = "Cable 0/0: " + dt.Rows[i]["Modems"].ToString(); } if (dt.Rows[i]["Interface"].ToString() == "Cable 1/0") { I1.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); I1.LegendText = "Cable 1/0: " + dt.Rows[i]["Modems"].ToString(); } if (dt.Rows[i]["Interface"].ToString() == "Cable 2/0") { I2.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); I2.LegendText = "Cable 2/0: " + dt.Rows[i]["Modems"].ToString(); } if (dt.Rows[i]["Interface"].ToString() == "Cable 3/0") { I3.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); I3.LegendText = "Cable 3/0: " + dt.Rows[i]["Modems"].ToString(); } if (dt.Rows[i]["Interface"].ToString() == "Cable 4/0") { I4.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); I4.LegendText = "Cable 4/0: " + dt.Rows[i]["Modems"].ToString(); } if (dt.Rows[i]["Interface"].ToString() == "Cable 5/0") { I5.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); I5.LegendText = "Cable 5/0: " + dt.Rows[i]["Modems"].ToString(); } if (dt.Rows[i]["Interface"].ToString() == "Cable 9/0") { I9.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); I9.LegendText = "Cable 9/0: " + dt.Rows[i]["Modems"].ToString(); } if (dt.Rows[i]["Interface"].ToString() == "Cable 10/0") { I10.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); I10.LegendText = "Cable 10/0: " + dt.Rows[i]["Modems"].ToString(); } if (dt.Rows[i]["Interface"].ToString() == "Cable 11/0") { I11.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); I11.LegendText = "Cable 11/0: " + dt.Rows[i]["Modems"].ToString(); } } Modems.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; PCs.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; I0.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; I1.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; I2.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; I3.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; I4.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; I5.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; I9.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; I10.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; I11.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; chartDevicePC.Series.AddRange(new Series[] { Modems }); chartDevicePC1.Series.AddRange(new Series[] { PCs }); chartInterface1.Series.AddRange(new Series[] { I0, I1, I2, I3 }); chartInterface.Series.AddRange(new Series[] { I4, I5, I9, I10, I11 }); }
void Load24h(int load) { Class.NW_Device_Status cl = new Class.NW_Device_Status(); DataTable dt = new DataTable(); if (load == 0) { dt = cl.NW_Device_Status_Get24h(); } else { dt = cl.NW_Device_Status_GetList(); } Series Modems = new Series("Modem", ViewType.SplineArea); Series PCs = new Series("PCs ", ViewType.SplineArea); Series I0 = new Series("Card 0/0", ViewType.Line); Series I1 = new Series("Card 1/0", ViewType.Line); Series I2 = new Series("Card 2/0", ViewType.Line); Series I3 = new Series("Card 3/0", ViewType.Line); Series I4 = new Series("Card 4/0", ViewType.Line); Series I5 = new Series("Card 5/0", ViewType.Line); Series I9 = new Series("Card 9/0", ViewType.Line); Series I10 = new Series("Card 10/0", ViewType.Line); Series I11 = new Series("Card 11/0", ViewType.Line); I0.Points.Clear(); I1.Points.Clear(); I2.Points.Clear(); I3.Points.Clear(); I4.Points.Clear(); I5.Points.Clear(); I9.Points.Clear(); I10.Points.Clear(); I11.Points.Clear(); Modems.Points.Clear(); PCs.Points.Clear(); chartDevicePC.Series.Clear(); chartInterface.Series.Clear(); chartDevicePC1.Series.Clear(); chartInterface1.Series.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { if(dt.Rows[i]["Interface"].ToString()=="Totals"){ Modems.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); Modems.LegendText = "Modems: " + dt.Rows[i]["Modems"].ToString(); PCs.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Hosts"].ToString())); PCs.LegendText = "PCs: " + dt.Rows[i]["Hosts"].ToString(); } if (dt.Rows[i]["Interface"].ToString() == "Cable 0/0") { I0.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); I0.LegendText = "Cable 0/0: " + dt.Rows[i]["Modems"].ToString(); } if (dt.Rows[i]["Interface"].ToString() == "Cable 1/0") { I1.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); I1.LegendText = "Cable 1/0: " + dt.Rows[i]["Modems"].ToString(); } if (dt.Rows[i]["Interface"].ToString() == "Cable 2/0") { I2.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); I2.LegendText = "Cable 2/0: " + dt.Rows[i]["Modems"].ToString(); } if (dt.Rows[i]["Interface"].ToString() == "Cable 3/0") { I3.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); I3.LegendText = "Cable 3/0: " + dt.Rows[i]["Modems"].ToString(); } if (dt.Rows[i]["Interface"].ToString() == "Cable 4/0") { I4.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); I4.LegendText = "Cable 4/0: " + dt.Rows[i]["Modems"].ToString(); } if (dt.Rows[i]["Interface"].ToString() == "Cable 5/0") { I5.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); I5.LegendText = "Cable 5/0: " + dt.Rows[i]["Modems"].ToString(); } if (dt.Rows[i]["Interface"].ToString() == "Cable 9/0") { I9.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); I9.LegendText = "Cable 9/0: " + dt.Rows[i]["Modems"].ToString(); } if (dt.Rows[i]["Interface"].ToString() == "Cable 10/0") { I10.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); I10.LegendText = "Cable 10/0: " + dt.Rows[i]["Modems"].ToString(); } if (dt.Rows[i]["Interface"].ToString() == "Cable 11/0") { I11.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HH"), dt.Rows[i]["Modems"].ToString())); I11.LegendText = "Cable 11/0: " + dt.Rows[i]["Modems"].ToString(); } } Modems.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; PCs.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; I0.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; I1.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; I2.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; I3.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; I4.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; I5.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; I9.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; I10.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; I11.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; chartDevicePC.Series.AddRange(new Series[] { Modems }); chartDevicePC1.Series.AddRange(new Series[] { PCs }); chartInterface1.Series.AddRange(new Series[] { I0,I1, I2, I3 }); chartInterface.Series.AddRange(new Series[] { I4, I5, I9, I10, I11 }); }