gatdata获取曲线_曲线图获取数据

public static DataTable GetPM25ChartsByYear(string year, string seqId)

{

string sql = @"SELECT MAX(EPAir1) AS [max],AVG(EPAir1) AS

[avg],MIN(EPAir1) AS [min],DATEPART(MONTH,EPAddTime) AS [month] FROM

dbo.BASE_EPRecord

WHERE DATEPART(YEAR,EPAddTime)='{0}' AND EPDevSeq='{1}'

GROUP BY DATEPART(MONTH,EPAddTime)

ORDER BY [month] ASC";

return DbHelperSQL.GetDataTable(string.Format(sql, DateTime.Parse(year).Year, seqId));

}

public static DataTable GetPM25ChartsByMonth(string month, string seqId)

{

string sql = @"SELECT MAX(EPAir1) AS [max],AVG(EPAir1) AS

[avg],MIN(EPAir1) AS [min],CAST(CONVERT(varchar(100), EPAddTime, 23) AS

DATETIME) AS addTime FROM dbo.BASE_EPRecord

WHERE DATEPART(MONTH,EPAddTime)={0} AND DATEPART(YEAR,EPAddTime)='{1}' AND E