void LoadChart(string mac) { Class.NW_SignalLog cls = new Class.NW_SignalLog(); cls.MacAddress = mac; dt = cls.NW_SignalLog_GetByMac(); Series Dssnr = new Series("DSSNR \r\n " + mac, ViewType.Line); Series UsTx = new Series("USTX \r\n " + mac, ViewType.Line); Series DsRx = new Series("DSRX \r\n " + mac, ViewType.Line); Series UsSnr = new Series("USSNR \r\n " + mac, ViewType.StepArea); Series UsNoise = new Series("", ViewType.StepArea); // Series Remote = new Series("Remote \r\n " + mac, ViewType.Line); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Status"].ToString() == "online") { Dssnr.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), dt.Rows[i]["value1"].ToString())); UsTx.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), dt.Rows[i]["value2"].ToString())); DsRx.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), dt.Rows[i]["value3"].ToString())); } else { Dssnr.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), "0")); UsTx.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), "0")); DsRx.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), "0")); } if (dt.Rows[i]["value4"].ToString() != "") { UsSnr.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), dt.Rows[i]["value4"].ToString())); if (int.Parse(dt.Rows[i]["value4"].ToString()) < 210) { UsNoise.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), dt.Rows[i]["value4"].ToString())); } else { UsNoise.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), "0")); } } else { UsSnr.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), "0")); UsNoise.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), "0")); } } // chartDSSNR.Series.AddRange(new Series[] { Dssnr }); // chartUSTx.Series.AddRange(new Series[] { UsTx }); // chartDSRx.Series.AddRange(new Series[] { DsRx }); chartUSSnr.Series.AddRange(new Series[] { UsSnr, UsNoise }); chartRemote.Series.AddRange(new Series[] { UsTx, Dssnr, DsRx }); }
void LoadChart(string mac,int t) { Class.NW_SignalLog cls = new Class.NW_SignalLog(); cls.MacAddress = mac; dt = cls.NW_SignalLog_5Day_GetByMac(); Series Dssnr = new Series("DSSNR \r\n " + mac, ViewType.Line); Series UsTx = new Series("USTX \r\n " + mac, ViewType.Line); Series DsRx = new Series("DSRX \r\n " + mac, ViewType.Line); Series UsSnr = new Series("USSNR \r\n " + mac, ViewType.StepArea); Series UsNoise = new Series("", ViewType.StepArea); // Series Remote = new Series("Remote \r\n " + mac, ViewType.Line); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Status"].ToString() == "online") { Dssnr.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), dt.Rows[i]["value1"].ToString())); UsTx.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), dt.Rows[i]["value2"].ToString())); DsRx.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), dt.Rows[i]["value3"].ToString())); } else { Dssnr.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), "0")); UsTx.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), "0")); DsRx.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), "0")); } if (dt.Rows[i]["value4"].ToString() != "") { UsSnr.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), dt.Rows[i]["value4"].ToString())); if (int.Parse(dt.Rows[i]["value4"].ToString()) < 210) { UsNoise.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), dt.Rows[i]["value4"].ToString())); } else { UsNoise.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), "0")); } } else { UsSnr.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), "0")); UsNoise.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy H"), "0")); } } // chartDSSNR.Series.AddRange(new Series[] { Dssnr }); // chartUSTx.Series.AddRange(new Series[] { UsTx }); // chartDSRx.Series.AddRange(new Series[] { DsRx }); chartUSSnr.Series.AddRange(new Series[] { UsSnr, UsNoise }); chartRemote.Series.AddRange(new Series[] { UsTx, Dssnr, DsRx }); }
void LoadList(string mac) { Class.NW_SignalLog cls = new Class.NW_SignalLog(); cls.MacAddress = mac; gridItem.DataSource = cls.NW_SignalLog_GetByMac(); }
void InsertData() { Waiting.ShowWaitForm(); if (dt.Rows.Count > 0) { // them dl truoc khi insert int x = 0; int dem = 0; while (x < 1) { dem = 0; string value4; Class.CMTS cmts = new Class.CMTS(); for (int i = 0; i < dt.Rows.Count; i++) { value4 = ""; if (dt.Rows[i]["Status"].ToString() == "online") { if (dt.Rows[i]["Status"].ToString() == "online" && dt.Rows[i]["Value4"].ToString() == "") { dem++; Waiting.SetWaitFormDescription(" Tải lại PHY mac " + dt.Rows[i]["MacAddress"].ToString()); Thread.Sleep(2); cmts.Phy(dt.Rows[i]["MacAddress"].ToString(), out value4); Thread.Sleep(2); if (value4 == "") value4 = ""; else { if (int.Parse(value4) > 500) value4 = "0"; if (value4.Length == 5) { value4 = value4.Substring(2); } } dt.Rows[i]["value4"] = value4; } } if (value4 == "") { if (dt.Rows[i]["Status"].ToString() == "online") { if (dt.Rows[i]["Status"].ToString() == "online" && dt.Rows[i]["Value4"].ToString() == "") { dem++; Waiting.SetWaitFormDescription(" Tải lại PHY mac " + dt.Rows[i]["MacAddress"].ToString()); Thread.Sleep(2); cmts.Phy(dt.Rows[i]["MacAddress"].ToString(), out value4); if (value4 == "") value4 = ""; else { if (int.Parse(value4) > 500) value4 = "0"; } dt.Rows[i]["value4"] = value4; } } } } if (dem == 0) break; x++; Thread.Sleep(2); } Class.NW_SignalLog cls = new Class.NW_SignalLog(); for(int i=0;i<dt.Rows.Count;i++) { Waiting.SetWaitFormDescription("Lưu dữ liệu thiết bị : "+(i+1)); cls.MacAddress = dt.Rows[i]["MacAddress"].ToString(); cls.IpPrivate = dt.Rows[i]["IpPrivate"].ToString(); cls.IpPublic1 = dt.Rows[i]["IpPublic1"].ToString(); cls.IpPublic2 = dt.Rows[i]["IpPublic2"].ToString(); cls.Value1 = dt.Rows[i]["Value1"].ToString(); cls.Value2 = dt.Rows[i]["Value2"].ToString(); cls.Value3 = dt.Rows[i]["Value3"].ToString(); cls.Value4 = dt.Rows[i]["Value4"].ToString(); cls.Status = dt.Rows[i]["Status"].ToString(); cls.Location = dt.Rows[i]["Location"].ToString(); cls.DateTime = (DateTime)dt.Rows[i]["DateTime"]; cls.Description = dt.Rows[i]["Description"].ToString(); cls.CurrentDS = dt.Rows[i]["CurrentDS"].ToString(); cls.CurrentUS = dt.Rows[i]["CurrentUS"].ToString(); cls.Insert(); } } Waiting.CloseWaitForm(); }