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