public List <emsData> GetValidHistoryData() { using (var context = new MTWEModels()) { var mtweMinDatas = context.SensorDataMin .Where(d => d.TP > 100 && d.TP < 1000) .OrderByDescending(data => data.DataTime) .Take(10).ToList(); return(MtweMinToEmsDatas(mtweMinDatas)); } }
public List <emsData> GetCurrentMinEmsDatas(string devCode) { using (var context = new MTWEModels()) { var minute = DateTime.Now.GetCurrentMinute().AddMinutes(-1); var mtweMinDatas = context.SensorDataMin .Where(d => d.StatCode == devCode && d.DataTime >= minute && d.TP > 0 && d.DB > 0 && d.Humidity > 0) .OrderByDescending(data => data.DataTime) .Take(1).ToList(); return(MtweMinToEmsDatas(mtweMinDatas)); } }