private void timer_Tick(object sender, System.EventArgs e)
{
count.Text = ++countNumber + "";
MyDBConnect myDBConnect = new MyDBConnect();
myDBConnect.Open();
try
{
string qian45 = DateTime.Now.AddMinutes(-45).ToString("yyyy-MM-dd HH:mm:ss");
string qian30 = DateTime.Now.AddMinutes(-30).ToString("yyyy-MM-dd HH:mm:ss");
string sql = "SELECT diaoxian.Project_ID projectId,diaoxian.`max` lasttime,pro.userid userid,wxuser.openid openid,wxuser.nickname FROM `tb_qd_projectinuser` pro LEFT JOIN (SELECT Project_ID,MAX(tb.`Date`) `max` FROM tb_monitordata15 tb WHERE tb.`Date` > '" + qian45 + "' GROUP BY Project_ID HAVING `max` < '" + qian30 + "') diaoxian ON diaoxian.Project_ID = pro.Project_ID LEFT JOIN `tb_qd_weixininuser` wxuser ON pro.userid = wxuser.userid WHERE diaoxian.Project_ID IS NOT NULL";
MySqlDataReader reader = myDBConnect.Reader(sql);
while (reader.NextResult())
{
string text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + ": projectId=" + reader.GetString("projectId") + " lasttime=" + reader.GetString("lasttime") + " userid=" + reader.GetString("userid") + " openid=" + reader.GetString("openid") + " nickname=" + reader.GetString("nickname");
content.Text = content.Text + "\r\n" + text;
}
}
catch (Exception e1)
{
}
finally
{
myDBConnect.Close();
}
}
private void OnTimedEvent(object sender, ElapsedEventArgs e)
{
MyDBConnect myDBConnect = new MyDBConnect();
myDBConnect.Open();
try
{
string qian45 = DateTime.Now.AddMinutes(-45).ToString("yyyy-MM-dd HH:mm:ss");
string qian30 = DateTime.Now.AddMinutes(-30).ToString("yyyy-MM-dd HH:mm:ss");
string sql = "SELECT diaoxian.Project_ID projectId,diaoxian.`max` lasttime,pro.userid userid,wxuser.openid openid,wxuser.nickname FROM `tb_qd_projectinuser` pro LEFT JOIN (SELECT Project_ID,MAX(tb.`Date`) `max` FROM tb_monitordata15 tb WHERE tb.`Date` > '" + qian45 + "' GROUP BY Project_ID HAVING `max` < '" + qian30 + "') diaoxian ON diaoxian.Project_ID = pro.Project_ID LEFT JOIN `tb_qd_weixininuser` wxuser ON pro.userid = wxuser.userid WHERE diaoxian.Project_ID IS NOT NULL";
MySqlDataReader reader = myDBConnect.Reader(sql);
while (reader.NextResult())
{
string text = " projectId=" + reader.GetString("projectId") + " lasttime=" + reader.GetString("lasttime") + " userid=" + reader.GetString("userid") + " openid=" + reader.GetString("openid") + " nickname=" + reader.GetString("nickname");
Console.WriteLine("报警设备的信息：" + text);
logger.Info("报警设备的信息：" + text);
}
}
catch (Exception e1)
{
logger.Info("报警设备的信息：" + e1.Message);
}
finally
{
myDBConnect.Close();
}
}
private void timer_Tick(object sender, System.EventArgs e)
{
count.Text = ++countNumber + "";
MyDBConnect myDBConnect = new MyDBConnect();
myDBConnect.Open();
string sql = null;
try
{
string qian45 = DateTime.Now.AddMinutes(-45).ToString("yyyy-MM-dd HH:mm:ss");
string qian30 = DateTime.Now.AddMinutes(-30).ToString("yyyy-MM-dd HH:mm:ss");
sql = "SELECT wxuser.openid openid, project.`Project_Name` `name`,project.Project_Address address FROM `tb_qd_projectinuser` prouser LEFT JOIN (SELECT Project_ID,MAX(tb.`Date`) `max` FROM tb_monitordata15 tb WHERE tb.`Date` > '" + qian45 + "' GROUP BY Project_ID HAVING `max` < '" + qian30 + "') diaoxian ON diaoxian.Project_ID = prouser.Project_ID LEFT JOIN `tb_qd_weixininuser` wxuser ON prouser.userid = wxuser.userid left join `tb_project` project on prouser.`Project_ID`= project.`Project_ID` WHERE diaoxian.Project_ID IS NOT NULL And wxuser.`openid` is not null and wxuser.`openid` != ''";
MySqlDataReader reader = myDBConnect.Reader(sql);
if (reader.NextResult())
{
do
{
Project project = new Project();
project.openId = reader.GetString("openid");
project.name = reader.GetString("name");
project.address = reader.GetString("address");
string text = "openid=" + project.openId + ";name=" + project.name + ";address=" + project.address;
labelContent.Text = labelContent.Text + "\r\n" + text;
} while (reader.NextResult());
}
else
{
labelContent.Text = labelContent.Text + "\r\n" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + ": 没有掉线设备" + (DateTime.Now.Ticks - startTime);
}
}
catch (Exception e1)
{
labelContent.Text = labelContent.Text + "\r\n" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + ": 查询出错";
}
finally
{
const string filename = "log.txt";
FileStream fs = new FileStream(filename, FileMode.Append);
byte[] bytes = System.Text.Encoding.Default.GetBytes("sql=" + sql);
fs.Write(bytes, 0, bytes.Length);
fs.Close();
myDBConnect.Close();
}
}
private void OnTimedEvent(object sender, ElapsedEventArgs e)
{
MyDBConnect myDBConnect = new MyDBConnect();
myDBConnect.Open();
try
{
string qian45 = DateTime.Now.AddMinutes(-45).ToString("yyyy-MM-dd HH:mm:ss");
string qian30 = DateTime.Now.AddMinutes(-30).ToString("yyyy-MM-dd HH:mm:ss");
//string sql = "SELECT diaoxian.Project_ID projectId,diaoxian.`max` lasttime,pro.userid userid,wxuser.openid openid,wxuser.nickname FROM `tb_qd_projectinuser` pro LEFT JOIN (SELECT Project_ID,MAX(tb.`Date`) `max` FROM tb_monitordata15 tb WHERE tb.`Date` > '" + qian45 + "' GROUP BY Project_ID HAVING `max` < '" + qian30 + "') diaoxian ON diaoxian.Project_ID = pro.Project_ID LEFT JOIN `tb_qd_weixininuser` wxuser ON pro.userid = wxuser.userid WHERE diaoxian.Project_ID IS NOT NULL";
string sql = "SELECT wxuser.openid openid, project.`Project_Name` `name`,project.Project_Address address FROM `tb_qd_projectinuser` prouser LEFT JOIN (SELECT Project_ID,MAX(tb.`Date`) `max` FROM tb_monitordata15 tb WHERE tb.`Date` > '" + qian45 + "' GROUP BY Project_ID HAVING `max` < '" + qian30 + "') diaoxian ON diaoxian.Project_ID = prouser.Project_ID LEFT JOIN `tb_qd_weixininuser` wxuser ON prouser.userid = wxuser.userid left join `tb_project` project on prouser.`Project_ID`= project.`Project_ID` WHERE diaoxian.Project_ID IS NOT NULL And wxuser.`openid` is not null and wxuser.`openid` != ''";
MySqlDataReader reader = myDBConnect.Reader(sql);
while (reader.NextResult())
{
Project project = new Project();
project.openId = reader.GetString("openid");
project.name = reader.GetString("name");
project.address = reader.GetString("address");
string text = "openid=" + project.openId + ";name=" + project.name + ";address=" + project.address;
Console.WriteLine("报警设备的信息：" + text);
}
const string filename = "log.txt";
FileStream fs = new FileStream(filename, FileMode.Append);
byte[] bytes = System.Text.Encoding.Default.GetBytes("sql=" + sql);
fs.Write(bytes, 0, bytes.Length);
fs.Close();
}
catch (Exception e1)
{
}
finally
{
myDBConnect.Close();
}
}
