/// <summary>
/// 日数据
/// </summary>
/// <returns></returns>
public List <DataList> Getday()
{
List <decimal> valueList = new List <decimal>();
var result = Gethour();
foreach (var data in result)
{
valueList.Add(data.Avg);
}
Minutedata minutedata = new Minutedata();
var Avgresult = minutedata.DataStatistic(valueList);
return(Avgresult);
}
/// <summary>
/// 分钟数据
/// </summary>
/// <returns></returns>
public List <DataList> GetMinute()
{
using (OracleConnection conn = DapperHelper.GetConnString())
{
string sql = @"select d.MonitorValue from MonitorPoint a inner join MonitorPointPollutan b on a.id=b.pointid inner join Pollutant c on b.pollutantid=c.id
inner join RealData d on d.monitor_pollutionid=b.id where createtime>(sysdate-numtodsinterval(10,'minute')); ";
//var conditon = new { PollutantName = pollutantname };
var result = conn.Query <RealData>(sql, null);
List <decimal> valueList = new List <decimal>();
foreach (var data in result)
{
valueList.Add(data.MonitorValue);
}
Minutedata minutedata = new Minutedata();
var Avgresult = minutedata.DataStatistic(valueList);
return(Avgresult);
}
}
