/// 将分析好的数据添加到列表
private void ShowDataRows(RawCapture packet)
{
try
{
temp_packetIndex = packetIndex + 1;
dataGridPacket.Rows.Add(rowsBulider.Row(packet, temp_packetIndex));//加载DataGridRows;
string[] rowsLinebuffer = new string[7];
rowsLinebuffer = rowsBulider.Row(packet, ++packetIndex);
Console.WriteLine("rowsLinebuffer is " + rowsLinebuffer.Length);
if (rowsLinebuffer[1] == "TCP" || rowsLinebuffer[1] == "SMTP" || rowsLinebuffer[1] == "POP3" || rowsLinebuffer[1] == "HTTP" || rowsLinebuffer[1] == "OICQ")
{
rowData = new ProcessingAllData();
rowData.Id = rowsLinebuffer[0];
rowData.Protocol = rowsLinebuffer[1];
rowData.Length = rowsLinebuffer[2];
rowData.SourceAddress = rowsLinebuffer[3];
rowData.DestinationAddress = rowsLinebuffer[4];
rowData.HardwareType = rowsLinebuffer[5];
rowData.Time = rowsLinebuffer[6];
rowData.BinaryData = packet.Data;
rowData.Data = HexConvert.ConvertToAscii(packet.Data);
//添加总的数据
lock (padList.SyncRoot)
{
padList.Add(rowData);
}
//saveAllData.SaveAll(saveAllData.MyConnect,rowData);
if (rowsLinebuffer[1] == "OICQ")
{
pqll = new ProcessingQQLoginLogout();
countQQ += pqll.Analysis(rowData);
if (pqll.QqLogin == 1 || pqll.QqLogin == 2)
{
lock (pqllList.SyncRoot)
{
pqllList.Add(pqll);
//这里写存入数据库的代码
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
this.qqNoticeLabel.Text = "已捕获QQ上下线记录" + countQQ + "条";
}
public List <ProcessingQQLoginLogout> SearchQQ(MySqlConnection myConnect, string startTime, string endTime, string qqNum, bool login, bool leave)
{
List <ProcessingQQLoginLogout> datalist = new List <ProcessingQQLoginLogout>();
myConnect.Open();
string sql = "";
MySqlCommand myCmd = null;
sql = "select * from qq_info where time >= '" + startTime + "' and time <= '" + endTime + "'";
if (qqNum != "")
{
sql += "and qqnum = '" + qqNum + "'";
}
if (login && (!leave))
{
sql += "and qqLogin = "******"'上线'";
}
if ((!login) && leave)
{
sql += "and qqLogin = "******"'下线'";
}
if (login && leave)
{
sql += "and qqLogin = "******"'上线'" + "or qqLogin = "******"'下线'";
}
Debug.WriteLine(sql);
try
{
myCmd = new MySqlCommand(get_uft8(sql), myConnect);
MySqlDataReader reader = myCmd.ExecuteReader();
ProcessingQQLoginLogout row;
while (reader.Read())
{
row = new ProcessingQQLoginLogout();
row.QqID = reader[1].ToString();
row.QqIP = reader[2].ToString();
if (reader[3].ToString() == "上线")
{
row.QqLogin = 1;
}
else
{
row.QqLogin = 2;
}
row.Time = reader[4].ToString();
datalist.Add(row);
}
}
finally
{
myConnect.Close();
}
return(datalist);
}
/// <summary>
/// 将分析好的数据添加到列表
/// </summary>
/// <param name="packet"></param>
private void AddDataToList(RawCapture packet)
{
Console.Write("AddDataToList");
try
{
string[] rowsLinebuffer = new string[7];
rowsLinebuffer = rowsBulider.Row(packet, ++packetIndex);
if (rowsLinebuffer[1] == "TCP" || rowsLinebuffer[1] == "SMTP" || rowsLinebuffer[1] == "POP3" || rowsLinebuffer[1] == "HTTP" || rowsLinebuffer[1] == "OICQ")
{
rowData = new ProcessingAllData();
rowData.Id = rowsLinebuffer[0];
rowData.Protocol = rowsLinebuffer[1];
rowData.Length = rowsLinebuffer[2];
rowData.SourceAddress = rowsLinebuffer[3];
rowData.DestinationAddress = rowsLinebuffer[4];
rowData.HardwareType = rowsLinebuffer[5];
rowData.Time = rowsLinebuffer[6];
rowData.BinaryData = packet.Data; //?
rowData.Data = HexConvert.ConvertToAscii(packet.Data);
//添加总的数据
lock (padList.SyncRoot)
{
padList.Add(rowData);
}
if (rowsLinebuffer[1] == "OICQ")
{
pqll = new ProcessingQQLoginLogout();
countQQ += pqll.Analysis(rowData);
if (pqll.QqLogin == 1 || pqll.QqLogin == 2)
{
lock (pqllList.SyncRoot)
{
pqllList.Add(pqll);
//这里写存入数据库的代码
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
//this.staffNoticeLabel.Text = "今日新增记录" + countBehave + "条";
this.qqNoticeLabel.Text = "今日新增记录" + countQQ + "条";
}
private string SetSQLString(ProcessingQQLoginLogout qq)
{
string qqnum;
string IP;
string logn_out;
string time;
qqnum = qq.QqID;
IP = qq.QqIP;
if (qq.QqLogin == 1)
{
logn_out = "上线";
}
else
{
logn_out = "下线";
}
time = qq.Time;
return("insert into qq_info(qqnum,qqIP,qqLogin,time) values('" + qqnum + "','" + IP + "','" + logn_out + "','" + time + "')");
}
private void ShowDataRows(ProcessingQQLoginLogout qqll)
{
try
{
rowsLine[0] = qqll.Time;
rowsLine[1] = qqll.QqIP;
rowsLine[2] = qqll.QqID;
if (qqll.QqLogin == 1)
{
rowsLine[3] = "上线";
}
else
{
rowsLine[3] = "下线";
}
monitoringResultslistView.Rows.Add(rowsLine);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void SaveAll(MySqlConnection myConnect, ProcessingQQLoginLogout rowData)
{
myConnect.Open();
string sql = "";
MySqlCommand myCmd = null;
///
sql = SetSQLString(rowData);
Debug.WriteLine(sql);
try
{
myCmd = new MySqlCommand(get_uft8(sql), myConnect);
myCmd.ExecuteNonQuery();
}
finally
{
myConnect.Close();
}
//MySqlCommand mycmd = new MySqlCommand("insert into buyer(name,password,email) values('小王','dikd3939','*****@*****.**')", mycon);
}
private void ShowDataRows(RawCapture packet)
{
try
{
temp_packetIndex = packetIndex + 1;
dataGridPacket.Rows.Add(rowsBulider.Row(packet, temp_packetIndex));//加载DataGridRows;
string[] rowsLinebuffer = new string[7];
rowsLinebuffer = rowsBulider.Row(packet, ++packetIndex);
//Console.WriteLine("rowsLinebuffer的长度是："+ rowsLinebuffer.Length);
if (rowsLinebuffer[1] == "TCP" || rowsLinebuffer[1] == "SMTP" || rowsLinebuffer[1] == "POP3" || rowsLinebuffer[1] == "HTTP" || rowsLinebuffer[1] == "OICQ")
{
rowData = new ProcessingAllData();
rowData.Id = rowsLinebuffer[0];
rowData.Protocol = rowsLinebuffer[1];
rowData.Length = rowsLinebuffer[2];
rowData.SourceAddress = rowsLinebuffer[3];
rowData.DestinationAddress = rowsLinebuffer[4];
rowData.HardwareType = rowsLinebuffer[5];
//Console.WriteLine("305 索引前rowsLinebuffer的长度是：" + rowsLinebuffer.Length);
rowData.Time = rowsLinebuffer[6];
//Console.WriteLine("308 索引后rowsLinebuffer的长度是：" + rowsLinebuffer.Length);
rowData.BinaryData = packet.Data; //?
rowData.Data = HexConvert.ConvertToAscii(packet.Data);
//Console.WriteLine("311 rowsLinebuffer的长度是：" + rowsLinebuffer.Length);
//添加总的数据
lock (padList.SyncRoot)
{
padList.Add(rowData);
}
if (rowsLinebuffer[1] == "OICQ")
{
pqll = new ProcessingQQLoginLogout();
countQQ += pqll.Analysis(rowData);
if (pqll.QqLogin == 1 || pqll.QqLogin == 2)
{
lock (pqllList.SyncRoot)
{
pqllList.Add(pqll);
//这里写存入数据库的代码
saveAllData.SaveAll(saveAllData.MyConnect, pqll);
}
}
}
//员工行为
if (rowsLinebuffer[1] == "TCP" || rowsLinebuffer[1] == "HTTP")
{
pb = new ProcessingBehave();
String key = pb.Analysis(rowData, ht, pbList);
if (!key.Equals("key"))
{
ht.Remove(key);
countBehave++;
saveAllData.SaveAll(saveAllData.MyConnect, pb);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
this.qqNoticeLabel.Text = "已捕获QQ上下线记录" + countQQ + "条";
this.staffNoticeLabel.Text = "已捕获影音娱乐记录" + countBehave + "条";
}