Ejemplo n.º 1
0
        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()));
        }
Ejemplo n.º 2
0
        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()));
        }