private void btnConnect_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
Waiting.ShowWaitForm();
Waiting.SetWaitFormDescription("Đang kết nối đến CMTS");
Class.CMTS cmts = new Class.CMTS();
cmts.Connect(Class.CMTS.CMTS_Host);
if (Class.CMTS.tcpClient.Connected)
{
btnConnect.Enabled = false;
}
Waiting.CloseWaitForm();
}
catch { }
}
private void btnConnect_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
Waiting.ShowWaitForm();
Waiting.SetWaitFormDescription("Đang kết nối đến CMTS");
Class.CMTS cmts = new Class.CMTS();
cmts.Connect(Class.CMTS.CMTS_Host);
if (Class.CMTS.tcpClient.Connected)
{
btnConnect.Enabled = false;
}
Waiting.CloseWaitForm();
}
catch { }
}
void get()
{
Class.CMTS cmts = new Class.CMTS();
cmts.Connect(Class.CMTS.CMTS_Host);
if (Class.CMTS.tcpClient.Connected)
{
DataRow dr;
string _ds = "";
string _us = "";
cmts.Get_TrafficMac(txtMac.Text, out _ds, out _us);
if (_ds != "")
{
if (dtTraffic.Rows.Count < 1)
{
dr = dtTraffic.NewRow();
dr["DateTime"] = DateTime.Now;
dr["DS"] = _ds;
dr["US"] = _us;
dr["CurrentDS"] = _ds;
dr["CurrentUS"] = _us;
dtTraffic.Rows.Add(dr);
}
else
{
// tinh trafic
double currds = 0;
double currus = 0;
double Oldcurrds = 0;
double Oldcurrus = 0;
double.TryParse(_ds, out currds);
double.TryParse(_us, out currus);
double.TryParse(dtTraffic.Rows[dtTraffic.Rows.Count - 1]["CurrentDS"].ToString(), out Oldcurrds);
double.TryParse(dtTraffic.Rows[dtTraffic.Rows.Count - 1]["CurrentUS"].ToString(), out Oldcurrus);
dr = dtTraffic.NewRow();
dr["DateTime"] = DateTime.Now;
if (currds > Oldcurrds)
{
dr["CurrentDS"] = currds;
dr["DS"] = (currds - Oldcurrds).ToString();
}
else if (currds == Oldcurrds)
{
dr["CurrentDS"] = currds;
dr["DS"] = "0";
}
else
{
dr["CurrentDS"] = currds;
dr["DS"] = currds.ToString();
}
if (currus > Oldcurrus)
{
dr["CurrentUS"] = currus;
dr["US"] = (currus - Oldcurrus).ToString();
}
else if (currus == Oldcurrus)
{
dr["CurrentUS"] = currus;
dr["US"] = "0";
}
else
{
dr["CurrentUS"] = currus;
dr["US"] = currus.ToString();
}
dtTraffic.Rows.Add(dr);
float down = 0;
float up = 0;
float speeddown = 0;
float speedup = 0;
float speeddownM = 0;
float speedupM = 0;
float.TryParse(dr["DS"].ToString(), out down);
float.TryParse(dr["US"].ToString(), out up);
speeddown = down / 60;
speedup = up / 60;
this.Text = " Monitoring ( Download: " + speeddown.ToString("n") + "Kbps - Upload: " + speedup.ToString("n") + "Kbps)";
arcScaleComponent1.Value = speeddown;
arcScaleComponent2.Value = speedup;
speeddownM = (speeddown * 8) / 1000;
speedupM = (speedup * 8) / 1000;
arcScaleComponent3.Value = speeddownM;
arcScaleComponent4.Value = speedupM;
lblds1.Text = speeddown.ToString("n");
lblds2.Text = speeddownM.ToString("n");
lblus1.Text = speedup.ToString("n");
lblus2.Text = speedupM.ToString("n");
}
}
}
}
private void btnLoad_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
if (btnConnect.Enabled)
{
return;
}
else
{
if (!Class.CMTS.tcpClient.Connected)
{
btnConnect.Enabled = true;
return;
}
}
Waiting.ShowWaitForm();
// lay Remote
DateTime dtime = DateTime.Now;
Class.CMTS cmts = new Class.CMTS();
string value1 = "";
string value2 = "";
string value3 = "";
string mac = "";
string IpPrivate = "";
string status = "";
string location = "";
string[] list = null;
dtRe.Rows.Clear();
list = null;
// lay remote
cmts.Remote_Card_all(out list, Waiting);
if (list != null)
{
DataRow dr;
for (int i = 0; i < list.Length; i++)
{
// lay online
if (list[i].IndexOf("MOT") < 0) // kiem tra
{
if (list[i].IndexOf("online") > 0)
status = "online";
else
status = "offline";
// location
Regex r2 = new Regex(@"(\d+)/(\d+)/(\w+) ");
Match m2 = r2.Match(list[i]);
if (m2.Success)
{
location = m2.Value.Trim();
}
// loc thong so
Regex r = new Regex(@" (\d+).(\d+).(\d+).(\d+)(.*)(\w+).(\w+).(\w+)(.*)(\d+) ");
Match m = r.Match(list[i]);
if (m.Success)
{
string kq = m.Value;
kq = kq.Trim();
kq = kq.Replace(" ", " ");
kq = kq.Replace(" ", " ");
kq = kq.Replace(" ", " ");
string[] cat = kq.Split(' ');
IpPrivate = cat[0];
mac = cat[1];
value1 = cat[2];
value2 = cat[3];
value3 = cat[4];
if (IpPrivate.Equals("0.0.0.0"))
{
mac = cat[2];
value1 = cat[3];
value2 = cat[4];
value3 = cat[5];
}
}
if (mac.Trim() != "")
{
dr = dtRe.NewRow();
dr["MacAddress"] = mac;
dr["IpPrivate"] = IpPrivate;
dr["value1"] = value1;
dr["value2"] = value2;
dr["value3"] = value3;
dr["Location"] = location;
dr["Status"] = status;
dr["DateTime"] = dtime;
dtRe.Rows.Add(dr);
}
}
}
}
/// het lay Remote
/// lay PHY
///
string value4 = "";
dtPhy.Rows.Clear();
list = null;
List<string> list1 = new List<string>();
// lay remote
cmts.PHY_Card_all(out list, Waiting, out list1);
if (list != null)
{
DataRow dr;
for (int i = 0; i < list.Length; i++)
{
value4 = "";
Regex rMac = new Regex(@"(\w+).(\w+).(\w+).(\w+)");
Match m3 = rMac.Match(list[i]);
if (m3.Success)
{
string kq2 = m3.Value;
mac = kq2;
Regex rPHY = new Regex(@" (\d+){3} ");
Match m4 = rPHY.Match(list[i]);
if (m4.Success)
{
string kq = m4.Value;
value4 = kq;
if (value4 != "")
{
if (value4.Length >= 6)
{
value4 = value4.Substring(0, 4);
}
if (int.Parse(value4) > 500)
{
value4 = "0";
}
dr = dtPhy.NewRow();
dr["MacAddress"] = mac;
dr["value4"] = value4;
dr["DateTime"] = dtime;
dr["Status"] = "online";
dtPhy.Rows.Add(dr);
}
}
}
}
}
// bo sung
if (list1 != null)
{
DataRow dr;
for (int i = 0; i < list1.Count; i++)
{
value4 = "";
Regex rMac = new Regex(@"(\w+).(\w+).(\w+).(\w+)");
Match m3 = rMac.Match(list1[i]);
if (m3.Success)
{
string kq2 = m3.Value;
mac = kq2;
Regex rPHY = new Regex(@" (\d+){3} ");
Match m4 = rPHY.Match(list1[i]);
if (m3.Success)
{
string kq = m4.Value;
value4 = kq;
if (value4 != "")
{
if (value4.Length >= 6)
{
value4 = value4.Substring(0, 4);
}
if (int.Parse(value4) > 500)
{
value4 = "0";
}
dr = dtPhy.NewRow();
dr["MacAddress"] = mac;
dr["value4"] = value4;
dr["DateTime"] = dtime;
dr["Status"] = "online";
dtPhy.Rows.Add(dr);
}
}
}
}
}
// het phan bo sung
// noi du lieu
string txt = "";
DataRow[] result = null;
DataRow[] result2 = null;
value4 = "";
Class.CMTS cls = new Class.CMTS();
if (dt.Rows.Count > 0)
{
if (dtRe.Rows.Count > 0)
{
// begin Append
for (int i = 0; i < dt.Rows.Count; i++)
{
txt = dt.Rows[i]["MacAddress"].ToString();
result = dtRe.Select("MacAddress ='" + txt + "'");
dt.Rows[i]["DateTime"] =dtime;
foreach (DataRow row in result)
{
dt.Rows[i]["IpPrivate"] = row["IpPrivate"].ToString();
dt.Rows[i]["Location"] = row["Location"].ToString();
dt.Rows[i]["value1"] = row["value1"].ToString();
dt.Rows[i]["value2"] = row["value2"].ToString();
dt.Rows[i]["value3"] = row["value3"].ToString();
dt.Rows[i]["Status"] = row["Status"].ToString();
}
result2 = dtPhy.Select("MacAddress ='" + txt + "'");
foreach (DataRow row in result2)
{
dt.Rows[i]["value4"] = row["value4"].ToString();
}
if (dt.Rows[i]["Status"].ToString() == "online")
{
if (dt.Rows[i]["value4"] == DBNull.Value)
{
Waiting.SetWaitFormDescription(" Tải lại PHY mac " + dt.Rows[i]["MacAddress"].ToString());
Thread.Sleep(2);
cls.Phy(dt.Rows[i]["MacAddress"].ToString(), out value4);
dt.Rows[i]["value4"] = value4;
}
else if (dt.Rows[i]["value4"].ToString().Trim() == "")
{
Waiting.SetWaitFormDescription(" Tải lại PHY mac " + dt.Rows[i]["MacAddress"].ToString());
Thread.Sleep(2);
cls.Phy(dt.Rows[i]["MacAddress"].ToString(), out value4);
dt.Rows[i]["value4"] = value4;
}
}
Waiting.SetWaitFormDescription("Bắt đầu tiến hành nối Dữ liệu.!(" + (i + 1) + ")");
Thread.Sleep(1);
}
}
}
// het theo kieu load het Modem
/////////////////////////////////////////////////////////////
//Waiting.SetWaitFormDescription("Lưu thông số thiết bị vào CSDL");
//Class.NW_Device clsdv = new Class.NW_Device();
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// Waiting.SetWaitFormDescription("Lưu dữ liệu thiết bị : " + (i + 1));
// Thread.Sleep(1);
// clsdv.MacAddress = dt.Rows[i]["MacAddress"].ToString();
// clsdv.IpPrivate = dt.Rows[i]["IpPrivate"].ToString();
// clsdv.IpPublic1 = dt.Rows[i]["IpPublic1"].ToString();
// clsdv.IpPublic2 = dt.Rows[i]["IpPublic2"].ToString();
// clsdv.Value1 = dt.Rows[i]["Value1"].ToString();
// clsdv.Value2 = dt.Rows[i]["Value2"].ToString();
// clsdv.Value3 = dt.Rows[i]["Value3"].ToString();
// clsdv.Value4 = dt.Rows[i]["Value4"].ToString();
// clsdv.Location = dt.Rows[i]["Location"].ToString();
// clsdv.Status = dt.Rows[i]["Status"].ToString();
// clsdv.DateTime = (DateTime)dt.Rows[i]["DateTime"];
// clsdv.UpdateSignal();
//}
Waiting.CloseWaitForm();
//btnChart_ItemClick(null, null);
}
catch {
Class.CMTS.tcpClient = null;
btnConnect.Enabled = true;
if(Waiting.IsSplashFormVisible)
Waiting.CloseWaitForm();
}
}
void getOntime()
{
Class.CMTS cmts = new Class.CMTS();
cmts.Connect(Class.CMTS.CMTS_Host);
if (Class.CMTS.tcpClient.Connected)
{
DataRow dr;
string _ds = "";
string _us = "";
cmts.Get_TrafficMac(txtMac.Text, out _ds, out _us);
if (_ds != "")
{
if (dtTraffic.Rows.Count < 1)
{
dr = dtTraffic.NewRow();
dr["DateTime"] = DateTime.Now;
dr["DS"] = _ds;
dr["US"] = _us;
dr["CurrentDS"] = _ds;
dr["CurrentUS"] = _us;
dtTraffic.Rows.Add(dr);
}
else
{
// tinh trafic
double currds = 0;
double currus = 0;
double Oldcurrds = 0;
double Oldcurrus = 0;
double.TryParse(_ds, out currds);
double.TryParse(_us, out currus);
double.TryParse(dtTraffic.Rows[dtTraffic.Rows.Count - 1]["CurrentDS"].ToString(), out Oldcurrds);
double.TryParse(dtTraffic.Rows[dtTraffic.Rows.Count - 1]["CurrentUS"].ToString(), out Oldcurrus);
dr = dtTraffic.NewRow();
dr["DateTime"] = DateTime.Now;
if (currds > Oldcurrds)
{
dr["CurrentDS"] = currds;
dr["DS"] = (currds - Oldcurrds).ToString();
}
else if (currds == Oldcurrds)
{
dr["CurrentDS"] = currds;
dr["DS"] = "0";
}
else
{
dr["CurrentDS"] = currds;
dr["DS"] = currds.ToString();
}
if (currus > Oldcurrus)
{
dr["CurrentUS"] = currus;
dr["US"] = (currus - Oldcurrus).ToString();
}
else if (currus == Oldcurrus)
{
dr["CurrentUS"] = currus;
dr["US"] = "0";
}
else
{
dr["CurrentUS"] = currus;
dr["US"] = currus.ToString();
}
dtTraffic.Rows.Add(dr);
float down = 0;
float up = 0;
float speeddown = 0;
float speedup = 0;
float speeddownM = 0;
float speedupM = 0;
float.TryParse(dr["DS"].ToString(), out down);
float.TryParse(dr["US"].ToString(), out up);
speeddown = down / 3;
speedup = up / 3;
this.Text = " Monitoring ( Download: " + speeddown.ToString("n") + "KBps - Upload: " + speedup.ToString("n") + "KBps)";
arcScaleComponent1.Value = speeddown;
arcScaleComponent2.Value = speedup;
speeddownM = (speeddown * 8) / 1000;
speedupM = (speedup * 8) / 1000;
arcScaleComponent3.Value = speeddownM;
arcScaleComponent4.Value = speedupM;
lblds1.Text = speeddown.ToString("n");
lblds2.Text = speeddownM.ToString("n");
lblus1.Text = speedup.ToString("n");
lblus2.Text = speedupM.ToString("n");
}
}
}
}
private void btnSNR_Click(object sender, EventArgs e)
{
Waiting.ShowWaitForm();
Waiting.SetWaitFormDescription("Đang truy xuất Thông số nhiễu.!");
try
{
if (!btnConnect.Enabled)
{
string Signal0 = "";
string Signal1 = "";
string Signal2 = "";
string Signal3 = "";
string Signal4 = "";
string Signal5 = "";
string Signal6 = "";
string Signal7 = "";
dtSNR.Rows.Clear();
DataRow dr;
Class.CMTS cmts = new Class.CMTS();
cmts.SNR("0/0", out Signal0, out Signal1, out Signal2, out Signal3, out Signal4, out Signal5, out Signal6, out Signal7);
if (Signal0 != "")
{
dr = dtSNR.NewRow();
dr["InterfaceController"] = "0/0-U0";
dr["Signal"] = Signal0;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "0/0-U1";
dr["Signal"] = Signal1;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "0/0-U2";
dr["Signal"] = Signal2;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "0/0-U3";
dr["Signal"] = Signal3;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "0/0-U4";
dr["Signal"] = Signal4;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "0/0-U5";
dr["Signal"] = Signal5;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "0/0-U6";
dr["Signal"] = Signal6;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "0/0-U7";
dr["Signal"] = Signal7;
dtSNR.Rows.Add(dr);
}
cmts.SNR("1/0", out Signal0, out Signal1, out Signal2, out Signal3, out Signal4, out Signal5, out Signal6, out Signal7);
if (Signal0 != "")
{
dr = dtSNR.NewRow();
dr["InterfaceController"] = "1/0-U0";
dr["Signal"] = Signal0;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "1/0-U1";
dr["Signal"] = Signal1;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "1/0-U2";
dr["Signal"] = Signal2;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "1/0-U3";
dr["Signal"] = Signal3;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "1/0-U4";
dr["Signal"] = Signal4;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "1/0-U5";
dr["Signal"] = Signal5;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "1/0-U6";
dr["Signal"] = Signal6;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "1/0-U7";
dr["Signal"] = Signal7;
dtSNR.Rows.Add(dr);
}
cmts.SNR("2/0", out Signal0, out Signal1, out Signal2, out Signal3, out Signal4, out Signal5, out Signal6, out Signal7);
if (Signal0 != "")
{
dr = dtSNR.NewRow();
dr["InterfaceController"] = "2/0-U0";
dr["Signal"] = Signal0;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "2/0-U1";
dr["Signal"] = Signal1;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "2/0-U2";
dr["Signal"] = Signal2;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "2/0-U3";
dr["Signal"] = Signal3;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "2/0-U4";
dr["Signal"] = Signal4;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "2/0-U5";
dr["Signal"] = Signal5;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "2/0-U6";
dr["Signal"] = Signal6;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "2/0-U7";
dr["Signal"] = Signal7;
dtSNR.Rows.Add(dr);
}
cmts.SNR("3/0", out Signal0, out Signal1, out Signal2, out Signal3, out Signal4, out Signal5, out Signal6, out Signal7);
if (Signal0 != "")
{
dr = dtSNR.NewRow();
dr["InterfaceController"] = "3/0-U0";
dr["Signal"] = Signal0;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "3/0-U1";
dr["Signal"] = Signal1;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "3/0-U2";
dr["Signal"] = Signal2;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "3/0-U3";
dr["Signal"] = Signal3;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "3/0-U4";
dr["Signal"] = Signal4;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "3/0-U5";
dr["Signal"] = Signal5;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "3/0-U6";
dr["Signal"] = Signal6;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "3/0-U7";
dr["Signal"] = Signal7;
dtSNR.Rows.Add(dr);
}
cmts.SNR("4/0", out Signal0, out Signal1, out Signal2, out Signal3, out Signal4, out Signal5, out Signal6, out Signal7);
if (Signal0 != "")
{
dr = dtSNR.NewRow();
dr["InterfaceController"] = "4/0-U0";
dr["Signal"] = Signal0;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "4/0-U1";
dr["Signal"] = Signal1;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "4/0-U2";
dr["Signal"] = Signal2;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "4/0-U3";
dr["Signal"] = Signal3;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "4/0-U4";
dr["Signal"] = Signal4;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "4/0-U5";
dr["Signal"] = Signal5;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "4/0-U6";
dr["Signal"] = Signal6;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "4/0-U7";
dr["Signal"] = Signal7;
dtSNR.Rows.Add(dr);
}
cmts.SNR("5/0", out Signal0, out Signal1, out Signal2, out Signal3, out Signal4, out Signal5, out Signal6, out Signal7);
if (Signal0 != "")
{
dr = dtSNR.NewRow();
dr["InterfaceController"] = "5/0-U0";
dr["Signal"] = Signal0;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "5/0-U1";
dr["Signal"] = Signal1;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "5/0-U2";
dr["Signal"] = Signal2;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "5/0-U3";
dr["Signal"] = Signal3;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "5/0-U4";
dr["Signal"] = Signal4;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "5/0-U5";
dr["Signal"] = Signal5;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "5/0-U6";
dr["Signal"] = Signal6;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "5/0-U7";
dr["Signal"] = Signal7;
dtSNR.Rows.Add(dr);
}
cmts.SNR("9/0", out Signal0, out Signal1, out Signal2, out Signal3, out Signal4, out Signal5, out Signal6, out Signal7);
if (Signal0 != "")
{
dr = dtSNR.NewRow();
dr["InterfaceController"] = "9/0-U0";
dr["Signal"] = Signal0;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "9/0-U1";
dr["Signal"] = Signal1;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "9/0-U2";
dr["Signal"] = Signal2;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "9/0-U3";
dr["Signal"] = Signal3;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "9/0-U4";
dr["Signal"] = Signal4;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "9/0-U5";
dr["Signal"] = Signal5;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "9/0-U6";
dr["Signal"] = Signal6;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "9/0-U7";
dr["Signal"] = Signal7;
dtSNR.Rows.Add(dr);
}
cmts.SNR("10/0", out Signal0, out Signal1, out Signal2, out Signal3, out Signal4, out Signal5, out Signal6, out Signal7);
if (Signal0 != "")
{
dr = dtSNR.NewRow();
dr["InterfaceController"] = "10/0-U0";
dr["Signal"] = Signal0;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "10/0-U1";
dr["Signal"] = Signal1;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "10/0-U2";
dr["Signal"] = Signal2;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "10/0-U3";
dr["Signal"] = Signal3;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "10/0-U4";
dr["Signal"] = Signal4;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "10/0-U5";
dr["Signal"] = Signal5;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "10/0-U6";
dr["Signal"] = Signal6;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "10/0-U7";
dr["Signal"] = Signal7;
dtSNR.Rows.Add(dr);
}
cmts.SNR("11/0", out Signal0, out Signal1, out Signal2, out Signal3, out Signal4, out Signal5, out Signal6, out Signal7);
if (Signal0 != "")
{
dr = dtSNR.NewRow();
dr["InterfaceController"] = "11/0-U0";
dr["Signal"] = Signal0;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "11/0-U1";
dr["Signal"] = Signal1;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "11/0-U2";
dr["Signal"] = Signal2;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "11/0-U3";
dr["Signal"] = Signal3;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "11/0-U4";
dr["Signal"] = Signal4;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "11/0-U5";
dr["Signal"] = Signal5;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "11/0-U6";
dr["Signal"] = Signal6;
dtSNR.Rows.Add(dr);
dr = dtSNR.NewRow();
dr["InterfaceController"] = "11/0-U7";
dr["Signal"] = Signal7;
dtSNR.Rows.Add(dr);
}
if (dtSNR.Rows.Count > 0)
{
Class.NW_InterfaceControllerWarning clsI = new Class.NW_InterfaceControllerWarning();
clsI.DeleteAll();
Waiting.SetWaitFormDescription(" Tiến hành ghi dữ liệu !");
clsI.Insert(dtSNR);
}
}
}
catch {
btnDisconnect_Click(null, null);
Class.App.Log_WriteApp(" Treo o tai SNR ");
}
Waiting.CloseWaitForm();
}
private void btnRemote_Click(object sender, EventArgs e)
{
try
{
if (Waiting.IsSplashFormVisible)
{
Class.App.Log_WriteApp(" Treo o remote ");
return;
}
if (btnConnect.Enabled)
return;
try
{
Waiting.ShowWaitForm();
Waiting.SetWaitFormDescription("Đang tải thông số Remote.!");
if (!btnConnect.Enabled)
{
DateTime dtime = DateTime.Now;
Class.CMTS cmts = new Class.CMTS();
string value1 = "";
string value2 = "";
string value3 = "";
string mac = "";
string IpPrivate = "";
string status = "";
string location = "";
string[] list = null;
dt.Rows.Clear();
list = null;
// lay remote
cmts.Remote_Card_all(out list, Waiting);
if (list != null)
{
DataRow dr;
for (int i = 0; i < list.Length; i++)
{
// lay online
if (list[i].IndexOf("MOT") < 0) // kiem tra
{
Regex r = new Regex(@"(\d+)/0(.*)[a-f0-9\-]{4}.[a-f0-9\-]{4}.[a-f0-9\-]{4}(.*)line");
Match m = r.Match(list[i]);
while (m.Success)
{
string kq = m.Value;
kq = kq.Trim();
while (kq.IndexOf(" ") > 0)
{
kq = kq.Replace(" ", " ");
}
string[] cat = kq.Split(' ');
if (cat.Length == 10)
{
location = cat[0] + "-" + cat[1] + "-" + cat[2];
mac = cat[3];
value1 = cat[4];
value2 = cat[5];
value3 = cat[6];
status = cat[9];
if (mac.Trim() != "")
{
dr = dt.NewRow();
dr["MacAddress"] = mac;
dr["IpPrivate"] = IpPrivate;
dr["value1"] = value1;
dr["value2"] = value2;
dr["value3"] = value3;
dr["Location"] = location;
dr["Status"] = status;
dr["DateTime"] = dtime;
dt.Rows.Add(dr);
}
}
m = m.NextMatch();
}
}
}
}
}
Waiting.CloseWaitForm();
gridItem.DataSource = dt;
}
catch
{
Waiting.CloseWaitForm();
// MessageBox.Show(ex.Message);
Class.CMTS.tcpClient = null;
btnConnect.Enabled = true;
}
}
catch { }
}
private void btnPHY_Click(object sender, EventArgs e)
{
if (Waiting.IsSplashFormVisible)
{
Class.App.Log_WriteApp(" Treo o PHY ");
return;
}
if (btnConnect.Enabled)
return;
try
{
Waiting.ShowWaitForm();
Waiting.SetWaitFormDescription("Đang tải thông số PHY.!");
if (!btnConnect.Enabled)
{
DateTime dtime = DateTime.Now;
Class.CMTS cmts = new Class.CMTS();
//string value4 = "";
//string mac = "";
string[] list = null;
string[] cat = null;
dtPHY.Rows.Clear();
list = null;
List<string> list1 = new List<string>();
// lay PHY
cmts.PHY_Card_all(out list, Waiting,out list1);
if (list != null)
{
DataRow dr;
for (int i = 0; i < list.Length; i++)
{
list[i]=list[i].Trim();
if(list[i].Trim().EndsWith("TDMA")){
while (list[i].IndexOf(" ") > 0)
{
list[i] = list[i].Replace(" ", " ");
}
cat = list[i].Split(' ');
if(cat.Length==8){
dr = dtPHY.NewRow();
dr["MacAddress"] = cat[0];
dr["value4"] = cat[5];
dr["DateTime"] = dtime;
dr["Status"] = "online";
dtPHY.Rows.Add(dr);
}
// xu ly dinh PHY
if (cat.Length == 7)
{
if (cat[4].Length == 5)
{
dr = dtPHY.NewRow();
dr["MacAddress"] = cat[0];
dr["value4"] = cat[4].Substring(2);
dr["DateTime"] = dtime;
dr["Status"] = "online";
dtPHY.Rows.Add(dr);
}
}
// value4 = "";
}
//value4 = "";
//Regex rMac = new Regex(@"(\w+).(\w+).(\w+).(\w+)");
//Match m3 = rMac.Match(list[i]);
//if (m3.Success)
//{
// string kq2 = m3.Value;
// mac = kq2;
// Regex rPHY = new Regex(@" [0-9\-]{3} ");
// Match m4 = rPHY.Match(list[i]);
// if (m4.Success)
// {
// string kq = m4.Value;
// value4 = kq;
// dr = dtPHY.NewRow();
// dr["MacAddress"] = mac;
// dr["value4"] = value4;
// dr["DateTime"] = dtime;
// dr["Status"] = "online";
// dtPHY.Rows.Add(dr);
// }
//}
}
}
}
Waiting.CloseWaitForm();
gridItem.DataSource = dtPHY;
}
catch
{
Waiting.CloseWaitForm();
// MessageBox.Show(ex.Message);
Class.CMTS.tcpClient = null;
btnConnect.Enabled = true;
}
}
void AppendData()
{
Waiting.ShowWaitForm();
Waiting.SetWaitFormDescription("Bắt đầu tiến hành nối Dữ liệu.!");
string txt = "";
DataRow[] result = null;
DataRow[] resultIP = null;
DataRow[] resultIPPublic = null;
// DataRow[] resultTraffic = null;
String value4 = "";
Class.CMTS cls = new Class.CMTS();
if (dt.Rows.Count > 0)
{
// begin Append
for( int i =0;i<dt.Rows.Count;i++)
{
txt = dt.Rows[i]["MacAddress"].ToString();
result = dtPHY.Select("MacAddress ='"+ txt +"'");
resultIP = dtIP.Select("MacAddress ='" + txt + "'");
resultIPPublic = dtIPPublic.Select("MacAddress ='" + txt + "'");
//resultTraffic = dtTraffic.Select("MacAddress ='" + txt + "'");
foreach (DataRow row in result)
{
dt.Rows[i]["value4"] = row["value4"].ToString();
}
if (dt.Rows[i]["Status"].ToString() == "online")
{
if (dt.Rows[i]["value4"] == DBNull.Value)
{
Waiting.SetWaitFormDescription(" Tải lại PHY mac " + dt.Rows[i]["MacAddress"].ToString());
Thread.Sleep(2);
cls.Phy(dt.Rows[i]["MacAddress"].ToString(), out value4);
if (value4 == "")
value4 = "";
else
{
if (int.Parse(value4) > 500)
value4 = "0";
}
dt.Rows[i]["value4"] = value4;
}
else if (dt.Rows[i]["value4"].ToString().Trim() == "")
{
Waiting.SetWaitFormDescription(" Tải lại PHY mac " + dt.Rows[i]["MacAddress"].ToString());
Thread.Sleep(2);
cls.Phy(dt.Rows[i]["MacAddress"].ToString(), out value4);
if (value4 == "")
value4 = "";
else
{
if (int.Parse(value4) > 500)
value4 = "0";
}
dt.Rows[i]["value4"] = value4;
}
}
foreach (DataRow rowIp in resultIP)
{
dt.Rows[i]["IpPrivate"] = rowIp["IpPrivate"].ToString();
dt.Rows[i]["Status"] = rowIp["Status"].ToString();
}
foreach (DataRow rowIppublic in resultIPPublic)
{
if (dt.Rows[i]["IpPublic1"].ToString().Length > 5)
{
dt.Rows[i]["IpPublic1"] =dt.Rows[i]["IpPublic1"].ToString() + "-" + rowIppublic["IpPublic1"].ToString();
dt.Rows[i]["IpPublic2"] = dt.Rows[i]["IpPublic2"].ToString() + "-" + rowIppublic["IpPublic2"].ToString();
}
else
{
dt.Rows[i]["IpPublic1"] = rowIppublic["IpPublic1"].ToString();
dt.Rows[i]["IpPublic2"] = rowIppublic["IpPublic2"].ToString();
}
}
//foreach (DataRow rowTraffic in resultTraffic)
//{
// dt.Rows[i]["CurrentDS"] = rowTraffic["CurrentDS"].ToString();
// dt.Rows[i]["CurrentUS"] = rowTraffic["CurrentUS"].ToString();
//}
Waiting.SetWaitFormDescription("Bắt đầu tiến hành nối Dữ liệu.!("+(i+1)+")");
Thread.Sleep(1);
Application.DoEvents();
}
}
Waiting.CloseWaitForm();
}
private void btnLoadIP_Click(object sender, EventArgs e)
{
if (Waiting.IsSplashFormVisible)
{
Class.App.Log_WriteApp(" Treo o Load IP ");
return;
}
if (btnConnect.Enabled)
return;
try
{
Waiting.ShowWaitForm();
Waiting.SetWaitFormDescription("Đang tải IP.!");
if (!btnConnect.Enabled)
{
DateTime dtime = DateTime.Now;
Class.CMTS cmts = new Class.CMTS();
string[] list = null;
dtIP.Rows.Clear();
list = null;
// lay remote
cmts.Stast_Card_All(out list);
if (list != null)
{
DataRow dr;
for (int i = 0; i< list.Length; i++)
{
Regex rIp = new Regex(@"(\d+)/0(.*)(\d+).(\d+).(\d+).(\d+) (.*)[a-f0-9\-]{4}.[a-f0-9\-]{4}.[a-f0-9\-]{4}");
Match _rip = rIp.Match(list[i]);
while (_rip.Success)
{
string kqIP = _rip.Value;
while (kqIP.IndexOf(" ") > 0)
{
kqIP = kqIP.Replace(" ", " ");
}
string[] catchuoi = kqIP.Split(' ');
if (catchuoi.Length == 9)
{
dr = dtIP.NewRow();
dr["MacAddress"] = catchuoi[8];
dr["IpPrivate"] = catchuoi[7];
dr["DateTime"] = dtime;
dr["Status"] = catchuoi[4];
dtIP.Rows.Add(dr);
}
_rip = _rip.NextMatch();
}
}
}
}
Waiting.CloseWaitForm();
gridItem.DataSource = dtIP;
}
catch
{
Waiting.CloseWaitForm();
// MessageBox.Show(ex.Message);
Class.CMTS.tcpClient = null;
btnConnect.Enabled = true;
}
}
private void btnIPPublic_Click(object sender, EventArgs e)
{
if (Waiting.IsSplashFormVisible)
{
Class.App.Log_WriteApp(" Treo o tai IP Public ");
return;
}
if (btnConnect.Enabled)
return;
try
{
Waiting.ShowWaitForm();
Waiting.SetWaitFormDescription("Đang tải IP Public.!");
if (!btnConnect.Enabled)
{
DateTime dtime = DateTime.Now;
Class.CMTS cmts = new Class.CMTS();
string[] list = null;
dtIPPublic.Rows.Clear();
list = null;
// lay remote
cmts.Get_IPPublic(out list);
if (list != null)
{
DataRow dr;
for (int i = 0; i < list.Length; i++)
{
Regex rIp = new Regex(@" [a-f0-9\-]{4}.[a-f0-9\-]{4}.[a-f0-9\-]{4} (.*) [a-f0-9\-]{4}.[a-f0-9\-]{4}.[a-f0-9\-]{4}");
Match _rip = rIp.Match(list[i]);
while (_rip.Success)
{
string kqIP = _rip.Value.Trim();
while (kqIP.IndexOf(" ") > 0)
{
kqIP = kqIP.Replace(" ", " ");
}
string[] catchuoi = kqIP.Split(' ');
if (catchuoi.Length == 3)
{
dr = dtIPPublic.NewRow();
dr["MacAddress"] = catchuoi[0];
dr["IpPublic1"] = catchuoi[1];
dr["IpPublic2"] = catchuoi[2];
dr["DateTime"] = dtime;
dtIPPublic.Rows.Add(dr);
}
_rip = _rip.NextMatch();
}
}
}
}
Waiting.CloseWaitForm();
gridItem.DataSource = dtIPPublic;
}
catch
{
Waiting.CloseWaitForm();
Class.CMTS.tcpClient = null;
btnConnect.Enabled = true;
}
}
private void btnDeviceStatus_Click(object sender, EventArgs e)
{
if (Waiting.IsSplashFormVisible)
{
Class.App.Log_WriteApp(" Treo o Load Device Status ");
return;
}
if (btnConnect.Enabled)
return;
try
{
Waiting.ShowWaitForm();
Waiting.SetWaitFormDescription("Đang tải Device Status.!");
if (!btnConnect.Enabled)
{
DateTime dtime = DateTime.Now;
Class.CMTS cmts = new Class.CMTS();
string[] list = null;
dtDeviceStatus.Rows.Clear();
list = null;
string[] list_cat = null;
// lay remote
cmts.Get_DeviceStatus(out list);
if (list != null)
{
DataRow dr;
for (int i = 0; i < list.Length; i++)
{
if(list[i].StartsWith("Cable")){
list_cat = list[i].Split(' ');
if (list_cat[1].IndexOf("/0") > 0)
{
dr = dtDeviceStatus.NewRow();
dr["Interface"] = list_cat[0] + " " + list_cat[1];
dr["Modems"] = list_cat[2];
dr["Hosts"] = list_cat[3];
dr["DateTime"] = dtime;
dtDeviceStatus.Rows.Add(dr);
}
}
if (list[i].StartsWith("Totals"))
{
list_cat = list[i].Split(' ');
dr = dtDeviceStatus.NewRow();
dr["Interface"] = list_cat[0];
dr["Modems"] = list_cat[1];
dr["Hosts"] = list_cat[2];
dr["DateTime"] = dtime;
dtDeviceStatus.Rows.Add(dr);
}
}
}
}
Waiting.CloseWaitForm();
if (dtDeviceStatus.Rows.Count > 0)
{
Class.NW_Device_Status dv = new NW_Device_Status();
for (int i = 0; i < dtDeviceStatus.Rows.Count;i++ )
{
dv.Interface=dtDeviceStatus.Rows[i]["Interface"].ToString();
dv.Modems=int.Parse(dtDeviceStatus.Rows[i]["Modems"].ToString());
dv.Hosts=int.Parse(dtDeviceStatus.Rows[i]["Hosts"].ToString());
dv.DateTime = (DateTime)dtDeviceStatus.Rows[i]["DateTime"];
dv.Insert();
}
}
}
catch
{
Waiting.CloseWaitForm();
// MessageBox.Show(ex.Message);
Class.CMTS.tcpClient = null;
btnConnect.Enabled = true;
}
}
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();
}
private void btnConnect_Click(object sender, EventArgs e)
{
if (Waiting.IsSplashFormVisible)
{
return;
}
try
{
Waiting.ShowWaitForm();
Waiting.SetWaitFormDescription("Đang kết nối đến CMTS");
Class.CMTS cmts = new Class.CMTS();
cmts.Connect(Class.CMTS.CMTS_Host);
if (Class.CMTS.tcpClient.Connected)
{
btnConnect.Enabled = false;
}
Waiting.CloseWaitForm();
}
catch { }
}
private void btnTraffic_Click(object sender, EventArgs e)
{
if (Waiting.IsSplashFormVisible)
{
Class.App.Log_WriteApp("Treo o traffic dau tien ");
return;
}
if (btnConnect.Enabled)
return;
try
{
Waiting.ShowWaitForm();
Waiting.SetWaitFormDescription("Đang tải Traffic.!");
if (!btnConnect.Enabled)
{
DateTime dtime = DateTime.Now;
Class.CMTS cmts = new Class.CMTS();
string list = null;
dtTraffic.Rows.Clear();
list = null;
string[] cat = null;
// lay tracffic
#region traffic
Waiting.SetWaitFormDescription("Đang tải Traffic 0/0.!");
cmts.Get_Traffic("sh cable modem 0/0 stats \r\n", out list);
if (list != null)
{
list = list.Replace("0/0", "\n\r0/0");
while (list.IndexOf("\n\r\n\r") > 0)
{
list = list.Replace("\n\r\n\r", "\n\r");
}
string[] sp = list.Split('\n');
DataRow dr;
for (int i = 0; i < sp.Length; i++)
{
cat = null;
sp[i] = sp[i].Replace("\r", "");
sp[i] = sp[i].Trim();
while (sp[i].IndexOf(" ") > 0)
{
sp[i] = sp[i].Replace(" ", " ");
}
cat = sp[i].Split(' ');
if (cat.Length == 8)
{
dr = dtTraffic.NewRow();
dr["MacAddress"] = cat[5];
dr["CurrentUS"] = cat[6];
dr["CurrentDS"] = cat[7];
dr["DateTime"] = dtime;
dtTraffic.Rows.Add(dr);
}
}
}
Waiting.SetWaitFormDescription("Đang tải Traffic 1/0.!");
// card 1/0
cmts.Get_Traffic("sh cable modem 1/0 stats \r\n", out list);
if (list != null)
{
list = list.Replace("1/0", "\n\r1/0");
while (list.IndexOf("\n\r\n\r") > 0)
{
list = list.Replace("\n\r\n\r", "\n\r");
}
string[] sp = list.Split('\n');
DataRow dr;
for (int i = 0; i < sp.Length; i++)
{
cat = null;
sp[i] = sp[i].Replace("\r", "");
sp[i] = sp[i].Trim();
while (sp[i].IndexOf(" ") > 0)
{
sp[i] = sp[i].Replace(" ", " ");
}
cat = sp[i].Split(' ');
if (cat.Length == 8)
{
dr = dtTraffic.NewRow();
dr["MacAddress"] = cat[5];
dr["CurrentUS"] = cat[6];
dr["CurrentDS"] = cat[7];
dr["DateTime"] = dtime;
dtTraffic.Rows.Add(dr);
}
}
}
Waiting.SetWaitFormDescription("Đang tải Traffic 2/0.!");
// card 2/0
cmts.Get_Traffic("sh cable modem 2/0 stats \r\n", out list);
if (list != null)
{
list = list.Replace("2/0", "\n\r2/0");
while (list.IndexOf("\n\r\n\r") > 0)
{
list = list.Replace("\n\r\n\r", "\n\r");
}
string[] sp = list.Split('\n');
DataRow dr;
for (int i = 0; i < sp.Length; i++)
{
cat = null;
sp[i] = sp[i].Replace("\r", "");
sp[i] = sp[i].Trim();
while (sp[i].IndexOf(" ") > 0)
{
sp[i] = sp[i].Replace(" ", " ");
}
cat = sp[i].Split(' ');
if (cat.Length == 8)
{
dr = dtTraffic.NewRow();
dr["MacAddress"] = cat[5];
dr["CurrentUS"] = cat[6];
dr["CurrentDS"] = cat[7];
dr["DateTime"] = dtime;
dtTraffic.Rows.Add(dr);
}
}
}
Waiting.SetWaitFormDescription("Đang tải Traffic 3/0.!");
// card 3/0
cmts.Get_Traffic("sh cable modem 3/0 stats \r\n", out list);
if (list != null)
{
list = list.Replace("3/0", "\n\r3/0");
while (list.IndexOf("\n\r\n\r") > 0)
{
list = list.Replace("\n\r\n\r", "\n\r");
}
string[] sp = list.Split('\n');
DataRow dr;
for (int i = 0; i < sp.Length; i++)
{
cat = null;
sp[i] = sp[i].Replace("\r", "");
sp[i] = sp[i].Trim();
while (sp[i].IndexOf(" ") > 0)
{
sp[i] = sp[i].Replace(" ", " ");
}
cat = sp[i].Split(' ');
if (cat.Length == 8)
{
dr = dtTraffic.NewRow();
dr["MacAddress"] = cat[5];
dr["CurrentUS"] = cat[6];
dr["CurrentDS"] = cat[7];
dr["DateTime"] = dtime;
dtTraffic.Rows.Add(dr);
}
}
}
Waiting.SetWaitFormDescription("Đang tải Traffic 4/0.!");
// card 4/0
cmts.Get_Traffic("sh cable modem 4/0 stats \r\n", out list);
if (list != null)
{
list = list.Replace("4/0", "\n\r4/0");
while (list.IndexOf("\n\r\n\r") > 0)
{
list = list.Replace("\n\r\n\r", "\n\r");
}
string[] sp = list.Split('\n');
DataRow dr;
for (int i = 0; i < sp.Length; i++)
{
cat = null;
sp[i] = sp[i].Replace("\r", "");
sp[i] = sp[i].Trim();
while (sp[i].IndexOf(" ") > 0)
{
sp[i] = sp[i].Replace(" ", " ");
}
cat = sp[i].Split(' ');
if (cat.Length == 8)
{
dr = dtTraffic.NewRow();
dr["MacAddress"] = cat[5];
dr["CurrentUS"] = cat[6];
dr["CurrentDS"] = cat[7];
dr["DateTime"] = dtime;
dtTraffic.Rows.Add(dr);
}
}
}
Waiting.SetWaitFormDescription("Đang tải Traffic 5/0.!");
// card 5/0
cmts.Get_Traffic("sh cable modem 5/0 stats \r\n", out list);
if (list != null)
{
list = list.Replace("5/0", "\n\r5/0");
while (list.IndexOf("\n\r\n\r") > 0)
{
list = list.Replace("\n\r\n\r", "\n\r");
}
string[] sp = list.Split('\n');
DataRow dr;
for (int i = 0; i < sp.Length; i++)
{
cat = null;
sp[i] = sp[i].Replace("\r", "");
sp[i] = sp[i].Trim();
while (sp[i].IndexOf(" ") > 0)
{
sp[i] = sp[i].Replace(" ", " ");
}
cat = sp[i].Split(' ');
if (cat.Length == 8)
{
dr = dtTraffic.NewRow();
dr["MacAddress"] = cat[5];
dr["CurrentUS"] = cat[6];
dr["CurrentDS"] = cat[7];
dr["DateTime"] = dtime;
dtTraffic.Rows.Add(dr);
}
}
}
Waiting.SetWaitFormDescription("Đang tải Traffic 9/0.!");
// card 9/0
cmts.Get_Traffic("sh cable modem 9/0 stats \r\n", out list);
if (list != null)
{
list = list.Replace("9/0", "\n\r9/0");
while (list.IndexOf("\n\r\n\r") > 0)
{
list = list.Replace("\n\r\n\r", "\n\r");
}
string[] sp = list.Split('\n');
DataRow dr;
for (int i = 0; i < sp.Length; i++)
{
cat = null;
sp[i] = sp[i].Replace("\r", "");
sp[i] = sp[i].Trim();
while (sp[i].IndexOf(" ") > 0)
{
sp[i] = sp[i].Replace(" ", " ");
}
cat = sp[i].Split(' ');
if (cat.Length == 8)
{
dr = dtTraffic.NewRow();
dr["MacAddress"] = cat[5];
dr["CurrentUS"] = cat[6];
dr["CurrentDS"] = cat[7];
dr["DateTime"] = dtime;
dtTraffic.Rows.Add(dr);
}
}
}
Waiting.SetWaitFormDescription("Đang tải Traffic 10/0.!");
// card 10/0
cmts.Get_Traffic("sh cable modem 10/0 stats \r\n", out list);
if (list != null)
{
list = list.Replace("10/0", "\n\r10/0");
while (list.IndexOf("\n\r\n\r") > 0)
{
list = list.Replace("\n\r\n\r", "\n\r");
}
string[] sp = list.Split('\n');
DataRow dr;
for (int i = 0; i < sp.Length; i++)
{
cat = null;
sp[i] = sp[i].Replace("\r", "");
sp[i] = sp[i].Trim();
while (sp[i].IndexOf(" ") > 0)
{
sp[i] = sp[i].Replace(" ", " ");
}
cat = sp[i].Split(' ');
if (cat.Length == 8)
{
dr = dtTraffic.NewRow();
dr["MacAddress"] = cat[5];
dr["CurrentUS"] = cat[6];
dr["CurrentDS"] = cat[7];
dr["DateTime"] = dtime;
dtTraffic.Rows.Add(dr);
}
}
}
Waiting.SetWaitFormDescription("Đang tải Traffic 11/0.!");
// card 11/0
cmts.Get_Traffic("sh cable modem 11/0 stats \r\n", out list);
if (list != null)
{
list = list.Replace("11/0", "\n\r11/0");
while (list.IndexOf("\n\r\n\r") > 0)
{
list = list.Replace("\n\r\n\r", "\n\r");
}
string[] sp = list.Split('\n');
DataRow dr;
for (int i = 0; i < sp.Length; i++)
{
cat = null;
sp[i] = sp[i].Replace("\r", "");
sp[i] = sp[i].Trim();
while (sp[i].IndexOf(" ") > 0)
{
sp[i] = sp[i].Replace(" ", " ");
}
cat = sp[i].Split(' ');
if (cat.Length == 8)
{
dr = dtTraffic.NewRow();
dr["MacAddress"] = cat[5];
dr["CurrentUS"] = cat[6];
dr["CurrentDS"] = cat[7];
dr["DateTime"] = dtime;
dtTraffic.Rows.Add(dr);
}
}
}
#endregion
}
//============================================================== kiem tra
//// 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;
// MessageBox.Show("800000" + dtTraffic_select.Rows[j]["MacAddress"].ToString() +"----"+currds+ "----" +Oldcurrds);
// }
// 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 > 800000) // 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 > 100000) // 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 > 100000) // 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";
// }
// }
// }
//=========================================
Waiting.CloseWaitForm();
gridItem.DataSource = dtTraffic_select;
}
catch(Exception ex)
{
Waiting.CloseWaitForm();
btnDisconnect_Click(null, null);
Class.App.Log_WriteApp(ex.Message.ToString());
}
}
private void btnLoad_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
if (btnConnect.Enabled)
{
return;
}
else
{
if (!Class.CMTS.tcpClient.Connected)
{
btnConnect.Enabled = true;
return;
}
}
Waiting.ShowWaitForm();
// lay Remote
DateTime dtime = DateTime.Now;
Class.CMTS cmts = new Class.CMTS();
string value1 = "";
string value2 = "";
string value3 = "";
string mac = "";
string IpPrivate = "";
string status = "";
string location = "";
string[] list = null;
dtRe.Rows.Clear();
list = null;
// lay remote
cmts.Remote_Card_all(out list, Waiting);
if (list != null)
{
DataRow dr;
for (int i = 0; i < list.Length; i++)
{
// lay online
if (list[i].IndexOf("MOT") < 0) // kiem tra
{
if (list[i].IndexOf("online") > 0)
{
status = "online";
}
else
{
status = "offline";
}
// location
Regex r2 = new Regex(@"(\d+)/(\d+)/(\w+) ");
Match m2 = r2.Match(list[i]);
if (m2.Success)
{
location = m2.Value.Trim();
}
// loc thong so
Regex r = new Regex(@" (\d+).(\d+).(\d+).(\d+)(.*)(\w+).(\w+).(\w+)(.*)(\d+) ");
Match m = r.Match(list[i]);
if (m.Success)
{
string kq = m.Value;
kq = kq.Trim();
kq = kq.Replace(" ", " ");
kq = kq.Replace(" ", " ");
kq = kq.Replace(" ", " ");
string[] cat = kq.Split(' ');
IpPrivate = cat[0];
mac = cat[1];
value1 = cat[2];
value2 = cat[3];
value3 = cat[4];
if (IpPrivate.Equals("0.0.0.0"))
{
mac = cat[2];
value1 = cat[3];
value2 = cat[4];
value3 = cat[5];
}
}
if (mac.Trim() != "")
{
dr = dtRe.NewRow();
dr["MacAddress"] = mac;
dr["IpPrivate"] = IpPrivate;
dr["value1"] = value1;
dr["value2"] = value2;
dr["value3"] = value3;
dr["Location"] = location;
dr["Status"] = status;
dr["DateTime"] = dtime;
dtRe.Rows.Add(dr);
}
}
}
}
/// het lay Remote
/// lay PHY
///
string value4 = "";
dtPhy.Rows.Clear();
list = null;
List <string> list1 = new List <string>();
// lay remote
cmts.PHY_Card_all(out list, Waiting, out list1);
if (list != null)
{
DataRow dr;
for (int i = 0; i < list.Length; i++)
{
value4 = "";
Regex rMac = new Regex(@"(\w+).(\w+).(\w+).(\w+)");
Match m3 = rMac.Match(list[i]);
if (m3.Success)
{
string kq2 = m3.Value;
mac = kq2;
Regex rPHY = new Regex(@" (\d+){3} ");
Match m4 = rPHY.Match(list[i]);
if (m4.Success)
{
string kq = m4.Value;
value4 = kq;
if (value4 != "")
{
if (value4.Length >= 6)
{
value4 = value4.Substring(0, 4);
}
if (int.Parse(value4) > 500)
{
value4 = "0";
}
dr = dtPhy.NewRow();
dr["MacAddress"] = mac;
dr["value4"] = value4;
dr["DateTime"] = dtime;
dr["Status"] = "online";
dtPhy.Rows.Add(dr);
}
}
}
}
}
// bo sung
if (list1 != null)
{
DataRow dr;
for (int i = 0; i < list1.Count; i++)
{
value4 = "";
Regex rMac = new Regex(@"(\w+).(\w+).(\w+).(\w+)");
Match m3 = rMac.Match(list1[i]);
if (m3.Success)
{
string kq2 = m3.Value;
mac = kq2;
Regex rPHY = new Regex(@" (\d+){3} ");
Match m4 = rPHY.Match(list1[i]);
if (m3.Success)
{
string kq = m4.Value;
value4 = kq;
if (value4 != "")
{
if (value4.Length >= 6)
{
value4 = value4.Substring(0, 4);
}
if (int.Parse(value4) > 500)
{
value4 = "0";
}
dr = dtPhy.NewRow();
dr["MacAddress"] = mac;
dr["value4"] = value4;
dr["DateTime"] = dtime;
dr["Status"] = "online";
dtPhy.Rows.Add(dr);
}
}
}
}
}
// het phan bo sung
// noi du lieu
string txt = "";
DataRow[] result = null;
DataRow[] result2 = null;
value4 = "";
Class.CMTS cls = new Class.CMTS();
if (dt.Rows.Count > 0)
{
if (dtRe.Rows.Count > 0)
{
// begin Append
for (int i = 0; i < dt.Rows.Count; i++)
{
txt = dt.Rows[i]["MacAddress"].ToString();
result = dtRe.Select("MacAddress ='" + txt + "'");
dt.Rows[i]["DateTime"] = dtime;
foreach (DataRow row in result)
{
dt.Rows[i]["IpPrivate"] = row["IpPrivate"].ToString();
dt.Rows[i]["Location"] = row["Location"].ToString();
dt.Rows[i]["value1"] = row["value1"].ToString();
dt.Rows[i]["value2"] = row["value2"].ToString();
dt.Rows[i]["value3"] = row["value3"].ToString();
dt.Rows[i]["Status"] = row["Status"].ToString();
}
result2 = dtPhy.Select("MacAddress ='" + txt + "'");
foreach (DataRow row in result2)
{
dt.Rows[i]["value4"] = row["value4"].ToString();
}
if (dt.Rows[i]["Status"].ToString() == "online")
{
if (dt.Rows[i]["value4"] == DBNull.Value)
{
Waiting.SetWaitFormDescription(" Tải lại PHY mac " + dt.Rows[i]["MacAddress"].ToString());
Thread.Sleep(2);
cls.Phy(dt.Rows[i]["MacAddress"].ToString(), out value4);
dt.Rows[i]["value4"] = value4;
}
else if (dt.Rows[i]["value4"].ToString().Trim() == "")
{
Waiting.SetWaitFormDescription(" Tải lại PHY mac " + dt.Rows[i]["MacAddress"].ToString());
Thread.Sleep(2);
cls.Phy(dt.Rows[i]["MacAddress"].ToString(), out value4);
dt.Rows[i]["value4"] = value4;
}
}
Waiting.SetWaitFormDescription("Bắt đầu tiến hành nối Dữ liệu.!(" + (i + 1) + ")");
Thread.Sleep(1);
}
}
}
// het theo kieu load het Modem
/////////////////////////////////////////////////////////////
//Waiting.SetWaitFormDescription("Lưu thông số thiết bị vào CSDL");
//Class.NW_Device clsdv = new Class.NW_Device();
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// Waiting.SetWaitFormDescription("Lưu dữ liệu thiết bị : " + (i + 1));
// Thread.Sleep(1);
// clsdv.MacAddress = dt.Rows[i]["MacAddress"].ToString();
// clsdv.IpPrivate = dt.Rows[i]["IpPrivate"].ToString();
// clsdv.IpPublic1 = dt.Rows[i]["IpPublic1"].ToString();
// clsdv.IpPublic2 = dt.Rows[i]["IpPublic2"].ToString();
// clsdv.Value1 = dt.Rows[i]["Value1"].ToString();
// clsdv.Value2 = dt.Rows[i]["Value2"].ToString();
// clsdv.Value3 = dt.Rows[i]["Value3"].ToString();
// clsdv.Value4 = dt.Rows[i]["Value4"].ToString();
// clsdv.Location = dt.Rows[i]["Location"].ToString();
// clsdv.Status = dt.Rows[i]["Status"].ToString();
// clsdv.DateTime = (DateTime)dt.Rows[i]["DateTime"];
// clsdv.UpdateSignal();
//}
Waiting.CloseWaitForm();
//btnChart_ItemClick(null, null);
}
catch {
Class.CMTS.tcpClient = null;
btnConnect.Enabled = true;
if (Waiting.IsSplashFormVisible)
{
Waiting.CloseWaitForm();
}
}
}
