public VseDbDataSet.Connection_StatsDataTable Get_ConnStatsByParams(VseDbDataSet dataSet, bool clearBeforeFill,
DateTime start, DateTime end, float lport, float fport, string fip, DateTime conn_start_time)
{
TimeSpan OneSecond = new TimeSpan(0, 0, 1);
DateTime DtStart = start - OneSecond;
DateTime DtEnd = end + OneSecond;
adapt1.ClearBeforeFill = clearBeforeFill;
VseDbDataSet.Connection_StatsDataTable dtable = adapt1.GetDataBy1(DtStart, DtEnd,
lport, fport, fip, conn_start_time);
return(dtable);
}
private void FillConnListFromRange(DateTime start, DateTime end)
{
treeView1.Nodes.Clear();
//Distinct local ports
VseDbDataSet.Connection_StatsDataTable distinctLocalPorts = new VseDbDataSet.Connection_StatsDataTable();
distinctLocalPorts = sqlMan.Fill_DistinctLocalPortsByRange(start, end);
//Distinct connection records
//SELECT DISTINCT Local_Port, Foreign_Port, Foreign_IP, Conn_Start_Time
VseDbDataSet.Connection_StatsDataTable distinctConns = new VseDbDataSet.Connection_StatsDataTable();
distinctConns = sqlMan.Fill_DistinctConnStatsByRange(start, end);
string selBase = "Local_Port = 'portnum'";
foreach (VseDbDataSet.Connection_StatsRow lRow in distinctLocalPorts.Rows)
{
string sPort = lRow.Local_Port.ToString("F0");
TreeNode tNode = new TreeNode(sPort);
string selPort = selBase.Replace("portnum", sPort);
DataRow[] cRows = distinctConns.Select(selPort);
foreach (VseDbDataSet.Connection_StatsRow cRow in cRows)
{
#region build child nodes
//double localPort = (double)cRow["Local_Port"];
double forgnPort = (double)cRow["Foreign_Port"];
//string lPort = localPort.ToString("F0");
string fPort = forgnPort.ToString("F0");
string fIp = (string)cRow["Foreign_IP"];
DateTime startTime = (DateTime)cRow["Conn_Start_Time"];
string sTime = startTime.ToString();
StringBuilder sb = new StringBuilder(fPort);
sb.Append(" : ");
sb.Append(fIp);
sb.Append(" (");
sb.Append(sTime);
sb.Append(")");
string cDisplay = sb.ToString();
TreeNode cNode = new TreeNode(cDisplay);
cNode.Tag = cRow;
tNode.Nodes.Add(cNode);
#endregion
}
treeView1.Nodes.Add(tNode);
}
}
