public List <emsData> GetValidHistoryData()
{
using (var context = new EsMonitorModels())
{
var esDatas = context.EsMin.Where(obj => obj.TP > 100 && obj.TP < 1000)
.Take(10).ToList();
return(EsMinToEmsDatas(esDatas));
}
}
public List <emsData> GetHistoryDayEmsDatas(string devCode, DateTime startDateTime, DateTime endDateTIme)
{
using (var context = new EsMonitorModels())
{
var deviceId = int.Parse(devCode);
var esDayDatas =
context.EsDay.Where(obj => obj.DevId == deviceId && obj.UpdateTime > startDateTime && obj.UpdateTime < endDateTIme).ToList();
return(EsDayToEmsDatas(esDayDatas));
}
}
public List <emsData> GetCurrentDayEmsDatas(string devCode)
{
using (var context = new EsMonitorModels())
{
var day = DateTime.Now.GetPrevioudDay();
var deviceId = int.Parse(devCode);
var esDayDatas =
context.EsDay.Where(obj => obj.DevId == deviceId && obj.UpdateTime >= day &&
obj.TP > 0 && obj.DB > 0 && obj.Temperature > 0 && obj.Humidity > 0).ToList();
return(EsDayToEmsDatas(esDayDatas));
}
}
public List <emsData> GetCurrentMinEmsDatas(string devCode)
{
using (var context = new EsMonitorModels())
{
var deviceId = int.Parse(devCode);
var minute = DateTime.Now.GetCurrentMinute().AddMinutes(-1);
var esMinDatas =
context.EsMin.Where(obj => obj.DevId == deviceId && obj.UpdateTime >= minute &&
obj.TP > 0 && obj.DB > 0 && obj.Temperature > 0 && obj.Humidity > 0).Take(1).ToList();
return(EsMinToEmsDatas(esMinDatas));
}
}
public void UpdateNewData(emsData data, int statId, int devId, string country, int?statCodeUp)
{
using (var context = new EsMonitorModels())
{
var last = context.EsMin.FirstOrDefault(d => d.DevId == devId);
if (last == null)
{
return;
}
last.TP = data.dust;
last.DB = data.noise;
last.Temperature = data.temperature;
last.Humidity = data.humidity;
last.WindDirection = data.windDirection;
last.WindSpeed = data.windSpeed;
context.EsMin.AddOrUpdate(last);
context.SaveChanges();
}
}
public void AddNewData(emsData data, int statId, int devId, string country, int?statCodeUp)
{
using (var context = new EsMonitorModels())
{
var newData = new T_ESMin
{
TP = data.dust,
DB = data.noise,
Temperature = data.temperature,
Humidity = data.humidity,
WindDirection = data.windDirection,
WindSpeed = data.windSpeed,
Airpressure = 0,
DevId = devId,
StatId = statId,
Country = country,
StatCode = statCodeUp,
DataStatus = "N"
};
context.EsMin.Add(newData);
context.SaveChanges();
}
}
