//每隔30秒采集一次数据
private void timer1_Tick(object sender, EventArgs e)
{
try
{
DateTime LastDate = new DateTime();
//便利datatable中的所有行
if (dt.Rows.Count > 0)
{
//for(int j=0;j<dt.Rows.Count;j++)
//{
//}
for (int i = 0; i < dt.Rows.Count; i++)
{
string temp = HttpRequest.SendGet(dt.Rows[i][3].ToString() + "?count=1").Replace("\"data\":", "").Replace(",\"success\":\"true\"", "");
if (temp.Length > 10)
{
temp = temp.Substring(1, temp.Length - 2);
List <WanWuYunData> entityList = JsonHelper.JonsToList <WanWuYunData>(temp);
foreach (WanWuYunData entity in entityList)
{
if (WanWuYunDataList[i] == entity.TIME)
{
this.richTextBox1.Text += DateTime.Now.ToString() + " 设备：" + dt.Rows[i][1].ToString() + "数据与上次相同，请查看设备状态" + "\n";
TXTLogHelper.LogBackup(DateTime.Now.ToString() + " 设备：" + dt.Rows[i][1].ToString() + "数据与上次相同，请查看设备状态" + "\r\n");
break;
}
entity.ID = CommonHelper.GetGuid;
WanWuYunData.Insert(entity);
this.richTextBox1.Text += DateTime.Now.ToString() + " 设备：" + dt.Rows[i][1].ToString() + "数据已更新" + "\n";
TXTLogHelper.LogBackup(DateTime.Now.ToString() + " 设备：" + dt.Rows[i][1].ToString() + "数据已更新" + "\r\n");
WanWuYunDataList[i] = Convert.ToDateTime(entity.TIME);
}
}
else
{
this.richTextBox1.Text += DateTime.Now.ToString() + " 设备：" + dt.Rows[i][1].ToString() + "数据未获取到" + "\n";
TXTLogHelper.LogBackup(DateTime.Now.ToString() + " 设备：" + dt.Rows[i][1].ToString() + "数据未获取到" + "\r\n");
}
}
}
//避免richTextBox1数据过大，占用内存过大，定期清除
if (this.richTextBox1.Text.Length > 500)
{
this.richTextBox1.Text = "";
}
}
catch (Exception ex)
{
TXTLogHelper.LogBackup(DateTime.Now.ToString() + "发生异常：" + ex.Message + "\r\n");
}
//string testData = "[{\"DEV_ID\":\"C8:93:46:72:E7:59\",\"G\":\"0.0\",\"GX\":\"0.0\",\"GY\":\"0.0\",\"GZ\":\"0.0\",\"H\":\"56\",\"HCHO\":\"0.053\",\"LIGHT\":\"0\",\"PM25\":\"61\",\"T\":\"28\",\"TIME\":\"2018-09-07 17:42:40\",\"VERSION\":\"V4.0\"},{\"DEV_ID\":\"C8:93:46:72:E7:59\",\"G\":\"0.0\",\"GX\":\"0.0\",\"GY\":\"0.0\",\"GZ\":\"0.0\",\"H\":\"57\",\"HCHO\":\"0.054\",\"LIGHT\":\"0\",\"PM25\":\"53\",\"T\":\"28\",\"TIME\":\"2018-09-07 17:42:10\",\"VERSION\":\"V4.0\"},{\"DEV_ID\":\"C8:93:46:72:E7:59\",\"G\":\"0.0\",\"GX\":\"0.0\",\"GY\":\"0.0\",\"GZ\":\"0.0\",\"H\":\"56\",\"HCHO\":\"0.054\",\"LIGHT\":\"0\",\"PM25\":\"50\",\"T\":\"28\",\"TIME\":\"2018-09-07 17:41:40\",\"VERSION\":\"V4.0\"},{\"DEV_ID\":\"C8:93:46:72:E7:59\",\"G\":\"0.0\",\"GX\":\"0.0\",\"GY\":\"0.0\",\"GZ\":\"0.0\",\"H\":\"56\",\"HCHO\":\"0.054\",\"LIGHT\":\"0\",\"PM25\":\"54\",\"T\":\"28\",\"TIME\":\"2018-09-07 17:41:10\",\"VERSION\":\"V4.0\"},{\"DEV_ID\":\"C8:93:46:72:E7:59\",\"G\":\"0.0\",\"GX\":\"0.0\",\"GY\":\"0.0\",\"GZ\":\"0.0\",\"H\":\"55\",\"HCHO\":\"0.051\",\"LIGHT\":\"0\",\"PM25\":\"53\",\"T\":\"28\",\"TIME\":\"2018-09-07 17:40:40\",\"VERSION\":\"V4.0\"},{\"DEV_ID\":\"C8:93:46:72:E7:59\",\"G\":\"0.0\",\"GX\":\"0.0\",\"GY\":\"0.0\",\"GZ\":\"0.0\",\"H\":\"55\",\"HCHO\":\"0.053\",\"LIGHT\":\"0\",\"PM25\":\"53\",\"T\":\"28\",\"TIME\":\"2018-09-07 17:40:10\",\"VERSION\":\"V4.0\"},{\"DEV_ID\":\"C8:93:46:72:E7:59\",\"G\":\"0.0\",\"GX\":\"0.0\",\"GY\":\"0.0\",\"GZ\":\"0.0\",\"H\":\"55\",\"HCHO\":\"0.053\",\"LIGHT\":\"0\",\"PM25\":\"52\",\"T\":\"28\",\"TIME\":\"2018-09-07 17:39:39\",\"VERSION\":\"V4.0\"},{\"DEV_ID\":\"C8:93:46:72:E7:59\",\"G\":\"0.0\",\"GX\":\"0.0\",\"GY\":\"0.0\",\"GZ\":\"0.0\",\"H\":\"54\",\"HCHO\":\"0.046\",\"LIGHT\":\"0\",\"PM25\":\"57\",\"T\":\"28\",\"TIME\":\"2018-09-07 17:39:09\",\"VERSION\":\"V4.0\"},{\"DEV_ID\":\"C8:93:46:72:E7:59\",\"G\":\"0.0\",\"GX\":\"0.0\",\"GY\":\"0.0\",\"GZ\":\"0.0\",\"H\":\"53\",\"HCHO\":\"0.042\",\"LIGHT\":\"0\",\"PM25\":\"55\",\"T\":\"28\",\"TIME\":\"2018-09-07 17:38:39\",\"VERSION\":\"V4.0\"},{\"DEV_ID\":\"C8:93:46:72:E7:59\",\"G\":\"0.0\",\"GX\":\"0.0\",\"GY\":\"0.0\",\"GZ\":\"0.0\",\"H\":\"53\",\"HCHO\":\"0.044\",\"LIGHT\":\"0\",\"PM25\":\"52\",\"T\":\"28\",\"TIME\":\"2018-09-07 17:38:09\",\"VERSION\":\"V4.0\"}]";
//List<WanWuYunData> entityListtemp= JsonHelper.JonsToList<WanWuYunData>(testData);
}
private void button1_Click(object sender, EventArgs e)
{
try
{
string sql = " select * from t_statistic where 1=1 and UPDATE_TIME is not null ";
if (MaxRecord != "")
{
sql = sql + " and UPDATE_TIME>'{0}' ";
}
sql = string.Format(sql, MaxRecord);
DataTable dt = MySqlHelper.Query(sql).Tables[0];
SqlBulkCopyInsert(ConfigurationManager.ConnectionStrings["MyConn"].ConnectionString, "t_statistic", dt, out string message);
this.label1.Text = DateTime.Now.ToString() + message;
TXTLogHelper.LogBackup(DateTime.Now.ToString() + "手动同步" + message);
}
catch (Exception ex)
{
TXTLogHelper.LogBackup(DateTime.Now.ToString() + "手动同步出错" + ex.Message);
}
}
//调用html模板发送邮件通知
private void SendMail(string email, string name, string date, string table1, string table2, string level, string qianzhui)
{
string mailFrom = MailHelper.MailServerFrom;
string mailTo = string.Empty;
string mailSubject = string.Empty;
string mailBody = string.Empty;
string mailAttch = string.Empty;
string mailCode = MailHelper.MailPassword;
string mailPriority = string.Empty;
string mailCC = string.Empty;
string resultMessage = "";
if (!string.IsNullOrEmpty(email))
{
mailTo = email;
mailSubject = "GP12遏制产品待处理信息通知";
try
{
string templetpath = System.Environment.CurrentDirectory + "/MailTemplate/test.html";
NameValueCollection myCol = new NameValueCollection();
myCol.Add("ename", name);
myCol.Add("date", date);
myCol.Add("table1", table1);
myCol.Add("table2", table2);
myCol.Add("level", level);
myCol.Add("qianzhui", qianzhui);
//ConfigurationManager.ConnectionStrings["S1"].ToString()
//myCol.Add("link", System.Configuration.ConfigurationManager.AppSettings["rootUrl"]);
mailBody = TemplateHelper.BulidByFile(templetpath, myCol);
MailHelper.SendNetMail(mailFrom, mailTo, mailSubject, mailBody, mailAttch, mailCode, mailPriority, mailCC, out resultMessage);
TXTLogHelper.LogBackup(resultMessage);
}
catch (Exception ex)
{
}
}
}
