插入数据

最新推荐文章于 2023-09-25 17:35:22 发布

weixin_30617737

最新推荐文章于 2023-09-25 17:35:22 发布

阅读量62

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/btmc/p/3918093.html

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] + "
"); } } }

转载于:https://www.cnblogs.com/btmc/p/3918093.html