上班随便写写
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Threading;
namespace Mywifi
{
public partial class Mywifi : Form
{
public Mywifi()
{
InitializeComponent();
}
System.Diagnostics.Stopwatch sw;
///
/// 开始
///
///
///
private void button1_Click(object sender, EventArgs e)
{
//时间记录
sw = new System.Diagnostics.Stopwatch();
sw.Start();
timer1.Start();
//多线程执行
Thread onc = new Thread(new ThreadStart(NonpametetrRun));
onc.Start();
}
///
/// 时间开始
///
///
///
private void timer1_Tick(object sender, EventArgs e)
{
TimeSpan ts = sw.Elapsed;
shijian.Text = String.Format("{0}天{1}小时{2}分{3}秒{4}毫秒", ts.Days, ts.Hours, ts.Minutes, ts.Seconds, ts.Milliseconds);
}
///
/// 线程导入数据
///
public void NonpametetrRun()
{
DataTable dt = new DataTable("date");
DataTable ds = new DataTable("date");
DataTable BS = new DataTable("date");
BS.Columns.Add("ROUTER_CMAC", Type.GetType("System.String"));
BS.Columns.Add("DEVICE_MAC", Type.GetType("System.String"));
BS.Columns.Add("CREATE_TIME", Type.GetType("System.String"));
//BS.Columns.Add("XIAXIAN_TIME", Type.GetType("System.String"));
BS.Columns.Add("ID", Type.GetType("System.String"));
BS.Columns.Add("AP_MAC", Type.GetType("System.String"));
BS.Columns.Add("SINGAL", Type.GetType("System.String"));
try
{
//分组查询
string sql = "SELECT ROUTER_MAC,DEVICE_MAC FROM macs_20140707 GROUP BY ROUTER_MAC,DEVICE_MAC";
dt = DbHelperMySqL.GetDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
//根据分组查询每个用户的信息
string sql1 = "SELECT CREATE_TIME,ID,AP_MAC,SINGAL FROM macs_20140707 WHERE ROUTER_MAC='" + dt.Rows[i]["ROUTER_MAC"] + "' AND DEVICE_MAC='" + dt.Rows[i]["DEVICE_MAC"] + "' ORDER BY CREATE_TIME ASC";
ds = DbHelperMySqL.GetDataTable(sql1);
for (int c = 0; c < ds.Rows.Count; c++)
{
//当datatable大于1才能进入
if (c - 1 > 0)
{
//时间间隔之差
DateTime lastTime = DateTime.Parse(ds.Rows[c - 1][0].ToString());
DateTime currentTime = DateTime.Parse(ds.Rows[c][0].ToString());
TimeSpan span = currentTime - lastTime;
//判断时间间隔为10分种
if (span.Minutes >= 10)
{
BS.Rows.Add(new object[] { dt.Rows[i][0], dt.Rows[i][1], ds.Rows[c][0], ds.Rows[c][1], ds.Rows[c][2], ds.Rows[c][3] });
}
}
else if (c - 1 < 0)
{
BS.Rows.Add(new object[] { dt.Rows[i][0], dt.Rows[i][1], ds.Rows[c][0], ds.Rows[c][1], ds.Rows[c][2], ds.Rows[c][3] });
}
else if (i == dt.Rows.Count && c == ds.Rows.Count)
{
for (int d = 0; d < BS.Rows.Count; d++)
{
string str = "insert into Mydatewifi( ROUTER_MAC,DEVICE_MAC,CREATE_TIME,ID,AP_MAC,SINGAL)values('" + BS.Rows[d]["ROUTER_CMAC"].ToString() + "','" + BS.Rows[d]["DEVICE_MAC"].ToString() + "','" + DateTime.Parse(BS.Rows[d]["CREATE_TIME"].ToString()) + "','" + int.Parse(BS.Rows[d]["ID"].ToString()) + "','" + BS.Rows[d]["AP_MAC"] + "','" + int.Parse(BS.Rows[d]["SINGAL"].ToString()) + "')";
DBHelper.ExecuteCommand(str);
if (d == BS.Rows.Count)
{
//时间停止
sw.Stop();
TimeSpan ts = sw.Elapsed;
}
}
}
max( int.Parse(ds.Rows[c][1].ToString()));
setcatred(ds.Rows.Count);
}
maxtat(i);
setcatre(dt.Rows.Count);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
Thread.Sleep(600);
}
///
/// 委托获取最大数字
///
///
public delegate void sett(int resp);
private void setcatre(int resp)
{
if (label2.InvokeRequired == true)
{
sett set = new sett(setcatre);
label2.Invoke(set, new object[] { resp });
}
else
{
label2.Text = resp.ToString();
}
}
///
/// 委托获取总数
///
///
public delegate void sett1(int respd);
private void setcatred(int respd)
{
if ( shulang.InvokeRequired==true)
{
sett1 set = new sett1(setcatred);
shulang.Invoke(set, new object[] { respd });
}
else
{
shulang.Text = respd.ToString();
}
}
///
/// 委托获取总数循环第几次
///
///
public delegate void sett2(int respd);
private void maxtat(int respd)
{
if (label5.InvokeRequired == true)
{
sett2 set = new sett2(maxtat);
label5.Invoke(set, new object[] { respd });
}
else
{
label5.Text = respd.ToString();
}
}
///
/// 委托获取第几条
///
///
public delegate void sett3(int respd);
private void max(int respd)
{
if (label6.InvokeRequired == true)
{
sett3 set = new sett3(max);
label6.Invoke(set, new object[] { respd });
}
else
{
label6.Text = respd.ToString();
}
}
}
}
