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));
}
}
