private void btnXem_Click(object sender, EventArgs e) { try { Class.NW_CurrentTrafic tf = new Class.NW_CurrentTrafic(); tf.MacAddress = txtMacaddress.Text; tf.Month = cbThang.EditValue.ToString(); tf.Year = cbNam.EditValue.ToString(); DataTable dt = tf.NW_Trafic_Get(); gridItem.DataSource = dt; Series Ds = new Series("DS: KByte ", ViewType.SwiftPlot); Series Us = new Series("US: KByte ", ViewType.SwiftPlot); Ds.Points.Clear(); Us.Points.Clear(); chartDS.Series.Clear(); chartUS.Series.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { Ds.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HHmm"), dt.Rows[i]["DS"].ToString())); Us.Points.Add(new SeriesPoint(((DateTime)dt.Rows[i]["DateTime"]).ToString("dd/MM/yy HHmm"), dt.Rows[i]["US"].ToString())); } chartDS.Series.AddRange(new Series[] { Ds }); chartUS.Series.AddRange(new Series[] { Us }); } catch { MessageBox.Show(" KHÔNG TÌM THẤY YÊU CẦU !"); } }
private void timer30_Tick(object sender, EventArgs e) { try { int Min = DateTime.Now.Minute; if (Min == 10 || Min == 30 || Min == 50) { timer30.Enabled = false; try { btnConnect_Click(null, null); Thread.Sleep(10); btnTraffic_Click(null, null); Thread.Sleep(10); btnDisconnect_Click(null, null); // xu ly insert Class.NW_CurrentTrafic cur = new Class.NW_CurrentTrafic(); dtTraffic_select = cur.NW_CurrentTrafic_GetAll(); DateTime timenow = DateTime.Now; if (dtTraffic_select.Rows.Count < 1) { // lan dau insert ko can kiem tra va tinh luuluong // tien hanh insert Waiting.ShowWaitForm(); Waiting.SetWaitFormDescription(" Đang lưu dữ liệu ! "); for (int i = 0; i < dtTraffic.Rows.Count; i++) { cur.MacAddress = dtTraffic.Rows[i]["MacAddress"].ToString(); cur.DS = dtTraffic.Rows[i]["CurrentDS"].ToString(); cur.US = dtTraffic.Rows[i]["CurrentUS"].ToString(); cur.DateTime = timenow; cur.CurrentDS = dtTraffic.Rows[i]["CurrentDS"].ToString(); cur.CurrentUS = dtTraffic.Rows[i]["CurrentUS"].ToString(); cur.Insert(); Waiting.SetWaitFormDescription(" Đang lưu dữ liệu ! (" + (i + 1).ToString() + ")"); } Waiting.CloseWaitForm(); } else { // het lan dau insert DataRow[] result = null; DataRow dr; for (int i = 0; i < dtTraffic.Rows.Count; i++) { // cap nhat mac thieu luu luong result = dtTraffic_select.Select("MacAddress ='" + dtTraffic.Rows[i]["MacAddress"].ToString() + "'"); if (result.Length > 0) { } else { dr = dtTraffic_select.NewRow(); dr["MacAddress"] = dtTraffic.Rows[i]["MacAddress"].ToString(); dr["DS"] = "0"; dr["US"] = "0"; dr["CurrentDS"] = "0"; dr["CurrentUS"] = "0"; dtTraffic_select.Rows.Add(dr); } } Waiting.ShowWaitForm(); Waiting.SetWaitFormDescription(" Đang tính Lưu lượng ! "); // bat dau tinh luu luong su dung double currds = 0; double currus = 0; double Oldcurrds = 0; double Oldcurrus = 0; for (int j = 0; j < dtTraffic_select.Rows.Count; j++) { result = dtTraffic.Select("MacAddress ='" + dtTraffic_select.Rows[j]["MacAddress"].ToString() + "'"); currds = 0; currus = 0; Oldcurrds = 0; Oldcurrus = 0; if (result.Length > 0) { foreach (DataRow row in result) { dtTraffic_select.Rows[j]["DateTime"] = row["DateTime"]; double.TryParse(row["CurrentDS"].ToString(), out currds); double.TryParse(row["CurrentUS"].ToString(), out currus); double.TryParse(dtTraffic_select.Rows[j]["CurrentDS"].ToString(), out Oldcurrds); double.TryParse(dtTraffic_select.Rows[j]["CurrentUS"].ToString(), out Oldcurrus); if (currds > Oldcurrds) { dtTraffic_select.Rows[j]["CurrentDS"] = currds; dtTraffic_select.Rows[j]["DS"] = (currds - Oldcurrds).ToString(); // truong hop lon hon qua nhieu. if (currds - Oldcurrds > 500000) // bi load lai traffic { dtTraffic_select.Rows[j]["DS"] = 0; } if (Oldcurrds == 0) { dtTraffic_select.Rows[j]["DS"] = 0; } } else if (currds == Oldcurrds) { dtTraffic_select.Rows[j]["CurrentDS"] = currds; dtTraffic_select.Rows[j]["DS"] = "0"; } else { dtTraffic_select.Rows[j]["CurrentDS"] = currds; dtTraffic_select.Rows[j]["DS"] = currds.ToString(); if (currds > 500000) // bi load lai traffic { dtTraffic_select.Rows[j]["DS"] = 0; } } if (currus > Oldcurrus) { dtTraffic_select.Rows[j]["CurrentUS"] = currus; dtTraffic_select.Rows[j]["US"] = (currus - Oldcurrus).ToString(); if (currus - Oldcurrus > 50000) // bi load lai traffic { dtTraffic_select.Rows[j]["US"] = 0; } if (Oldcurrus == 0) { dtTraffic_select.Rows[j]["US"] = 0; } } else if (currus == Oldcurrus) { dtTraffic_select.Rows[j]["CurrentUS"] = currus; dtTraffic_select.Rows[j]["US"] = "0"; } else { dtTraffic_select.Rows[j]["CurrentUS"] = currus; dtTraffic_select.Rows[j]["US"] = currus.ToString(); if (currus > 50000) // bi load lai traffic { dtTraffic_select.Rows[j]["US"] = 0; } } } } else { dtTraffic_select.Rows[j]["DateTime"] =timenow; dtTraffic_select.Rows[j]["DS"] = "0"; dtTraffic_select.Rows[j]["US"] = "0"; } } // tinh xong luu luong, bat dau ghi du lieu vao csdl Waiting.SetWaitFormDescription(" Đang lưu dữ liệu ! "); cur.DeleteAll(); for (int i = 0; i < dtTraffic_select.Rows.Count; i++) { cur.MacAddress = dtTraffic_select.Rows[i]["MacAddress"].ToString(); cur.DS = dtTraffic_select.Rows[i]["DS"].ToString(); cur.US = dtTraffic_select.Rows[i]["US"].ToString(); cur.DateTime = (DateTime)dtTraffic_select.Rows[i]["DateTime"]; cur.CurrentDS = dtTraffic_select.Rows[i]["CurrentDS"].ToString(); cur.CurrentUS = dtTraffic_select.Rows[i]["CurrentUS"].ToString(); cur.Insert(); Waiting.SetWaitFormDescription(" Đang lưu dữ liệu ! (" + (i + 1).ToString() + ")"); Thread.Sleep(1); } Waiting.CloseWaitForm(); } } catch (Exception ex) { btnDisconnect_Click(null, null); timer30.Enabled = true; Class.App.Log_WriteApp(ex.Message.ToString()); } timer30.Enabled = true; } } catch (Exception ex) { timer30.Enabled = true; Class.App.Log_WriteApp(ex.Message.ToString()); } }