MySqlConnection conn = new MySqlConnection(connetStr);
//获取当前的日期
String data = DateTime.Now.ToString("yyyy-MM-dd");
//最大的值
Double MaxNumber = 0.0;
Double TotalNumber = 0.0;
//获取计算每天最大能量 - DayMax
conn.Open();
//拼接数据库的名称
String data_ym = DateTime.Now.ToString("yyyyMM");
string tablename = data_ym+ "wzys";
String sql_work = "SELECT max(wzEventEnergy) FROM " + tablename + " WHERE DATE_FORMAT(acquisitionTime,'%Y-%m-%d')='" + data + "'";
cmd = new MySqlCommand(sql_work, conn);
readers = cmd.ExecuteReader();
while (readers.Read())
{
Double number= readers.GetDouble(0);
}
conn.Close();
对组合查询结果的查询
Double number= readers.GetDouble(0);