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 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());
}
}
