public Task <CDataResults <CSeaTemperatureDto> > GetSeaTemperatureByToday(CSeaTemperatureInput input)
{
string sql = "select time as Time,t3 as T3,t6 as T6,t9 as T9,t12 as T12,t20 as T20 from viewSeaTemperature";
sql += " where station_name = '" + input.StationCode + "'";
if (input.QueryDateTime.HasValue)
{
sql += " and time > '" + input.QueryDateTime.Value.ToString("yyyy-MM-dd") + "'";
}
var list = _sqlExecuter.SqlQuery <CSeaTemperatureDto>(sql);
var result = list.ToList();
return(Task.FromResult(new CDataResults <CSeaTemperatureDto>()
{
IsSuccess = true,
ErrorMessage = null,
Data = result,
Total = result.Count
}));
}
public Task <CDataResults <CUnusualDto> > GetUnusualData(CSeaTemperatureInput input)
{
StringBuilder sb = new StringBuilder();
sb.Append("SELECT station_name , SUM(CASE WHEN t3 < 0 THEN - 1 WHEN t3 IS NULL THEN - 1 ELSE 0 END) AS t3");
sb.Append(", SUM(CASE WHEN t6 < 0 THEN - 1 WHEN t6 IS NULL THEN - 1 ELSE 0 END ) AS t6");
sb.Append(" , SUM(CASE WHEN t9 < 0 THEN - 1 WHEN t9 IS NULL THEN - 1 ELSE 0 END ) AS t9");
sb.Append(" , SUM(CASE WHEN t12 < 0 THEN - 1 WHEN t12 IS NULL THEN - 1 ELSE 0 END ) AS t12");
sb.Append(" , SUM(CASE WHEN t20 < 0 THEN - 1 WHEN t20 IS NULL THEN - 1 ELSE 0 END ) AS t20 FROM ViewSeaTemperature");
sb.Append(" where time >= '" + input.QueryDateTime.Value.ToString("yyyy-MM-dd") + " 00:00:00' and [time] <= '" + input.QueryDateTime.Value.ToString("yyyy-MM-dd") + " 23:59:59' GROUP BY station_name");
var list = _sqlExecuter.SqlQuery <CUnusualDto>(sb.ToString());
var result = list.ToList();
return(Task.FromResult(new CDataResults <CUnusualDto>()
{
IsSuccess = true,
ErrorMessage = null,
Data = result,
Total = result.Count
}));
}
