插入数据
string sql = "select AP_MAV,ROUTER_MAC,DEVICE_MAC from Sunnywife where ID>=1 AND ID<=20 group by AP_MAV,ROUTER_MAC,DEVICE_MAC";
DataTable dt = DBHelper.GetDataTable(sql);
foreach (DataRow row in dt.Rows)
{
string sqlTime = "select CREATE_TIME from Sunnywife where ROUTER_MAC='" + row["ROUTER_MAC"] + "' and DEVICE_MAC='" + row["DEVICE_MAC"] + "'and AP_MAV='" + row["AP_MAV"] + "'AND ID>=1 AND ID<=20";
DataTable timeTable = DBHelper.GetDataTable(sqlTime);
for (int i = 0; i < timeTable.Rows.Count; i++)
{
if (i - 1 > 0)
{
DateTime lastTime = DateTime.Parse(timeTable.Rows[i - 1][0].ToString());
DateTime currentTime = DateTime.Parse(timeTable.Rows[i][0].ToString());
TimeSpan span = currentTime - lastTime;
if (span.Minutes >=10)
{
Response.Write("插入" + row["ROUTER_MAC"] + timeTable.Rows[i][0] + "
"); } else { Response.Write("不插入" + row["ROUTER_MAC"] + timeTable.Rows[i][0] + "
"); } } else if(i-1<0) { Response.Write("插入" + row["ROUTER_MAC"] + timeTable.Rows[i][0] + "
"); } } }
"); } else { Response.Write("不插入" + row["ROUTER_MAC"] + timeTable.Rows[i][0] + "
"); } } else if(i-1<0) { Response.Write("插入" + row["ROUTER_MAC"] + timeTable.Rows[i][0] + "
"); } } }