private DataSet Get_tank_temp() { StringBuilder str = new StringBuilder(); DateTime today = DateTime.Now; string st = today.ToString("yyyy-MM-dd"); str.Append(" select temp from t_tankwalls_history_temp "); str.Append(" where DATE(time)='" + st + "' order by time desc limit 36; "); //+ st + return(DBHelperMySQL.Query(str.ToString())); }
private DataSet Get_silo_temp() { StringBuilder str = new StringBuilder(); DateTime today = DateTime.Now; string st = today.ToString("yyyy-MM-dd"); str.Append(" select temp from t_silo_abnormal_temp "); str.Append(" where DATE(time)='2017-03-01' order by time desc limit 36; "); //"+st+" return(DBHelperMySQL.Query(str.ToString())); }