public List <WeatherForecastInfo> GetWeatherHis(DateTime dt)
{
List <WeatherForecastInfo> list = null;
string strSQL = "SELECT forecastdate,to_char(forecastdate, 'DY') as week,weatherpic,weather, mintemp,maxtemp from LFS_WELFAREFORECASTDAYS WHERE DDATETIME = TO_DATE('" + dt.ToString("yyyy-MM-dd HH:mm") + "','yyyy-mm-dd hh24:mi') ";
try
{
OracleHelper th = new OracleHelper("HAIKOUConnect");
DataTable dTable = th.ExecuteDataTable(strSQL);
if (dTable != null && dTable.Rows.Count > 0)
{
list = new List <WeatherForecastInfo>();
for (int i = 0; i < dTable.Rows.Count; i++)
{
WeatherForecastInfo info = new WeatherForecastInfo();
info.ForecastDate = dTable.Rows[i]["forecastdate"].ToString();
info.Week = dTable.Rows[i]["week"].ToString();
info.WeatherPic = dTable.Rows[i]["weatherpic"].ToString();
info.WeatherStatus = dTable.Rows[i]["weather"].ToString();
info.MinTemp = dTable.Rows[i]["mintemp"].ToString();
info.MaxTemp = dTable.Rows[i]["maxtemp"].ToString();
list.Add(info);
}
}
}
catch (Exception ex)
{
CreateLogTxt.ErrWriter(ex);
}
return(list);
}
public List <WeatherForecastInfo> GetAllWearthInfo(DateTime dt)
{
List <WeatherForecastInfo> list = null;
string strSQL = "SELECT distinct DDATETIME,AREANAME,MINRAIN,RAIN,MINTEMPERATURE,MAXTEMPERATURE,HUMIDITY,MAXHUMIDITY,WINDSPEED,WINDDIRECT,WEATHERPIC,WEATHERSTATUS,QPFCORRECTWEATHERPIC FROM LFS_AREAWEATHER WHERE DDATETIME = TO_DATE('" + dt.ToString("yyyy-MM-dd HH:mm") + "','yyyy-mm-dd hh24:mi') and maxtemperature!=0 ";
try
{
OracleHelper th = new OracleHelper("HAIKOUConnect");
DataTable dTable = th.ExecuteDataTable(strSQL);
if (dTable != null && dTable.Rows.Count > 0)
{
list = new List <WeatherForecastInfo>();
for (int i = 0; i < dTable.Rows.Count; i++)
{
WeatherForecastInfo info = new WeatherForecastInfo();
info.DDatetime = Convert.ToDateTime(dTable.Rows[i]["DDATETIME"]);
info.AreaName = dTable.Rows[i]["AREANAME"].ToString();
info.MinRain = dTable.Rows[i]["MINRAIN"].ToString();
info.Rain = dTable.Rows[i]["RAIN"].ToString();
info.MinTemp = dTable.Rows[i]["MINTEMPERATURE"].ToString();
info.MaxTemp = dTable.Rows[i]["MAXTEMPERATURE"].ToString();
info.Humidity = dTable.Rows[i]["HUMIDITY"].ToString();
info.MaxHumidity = dTable.Rows[i]["MAXHUMIDITY"].ToString();
info.WindSpeed = dTable.Rows[i]["WINDSPEED"].ToString();
info.WindDirectName = dTable.Rows[i]["WINDDIRECT"].ToString();
info.WeatherPic = dTable.Rows[i]["WEATHERPIC"].ToString();
info.WeatherStatus = dTable.Rows[i]["WEATHERSTATUS"].ToString();
info.QpfCorrectWeatherpic = dTable.Rows[i]["QPFCORRECTWEATHERPIC"].ToString();
list.Add(info);
}
}
}
catch (Exception ex)
{
CreateLogTxt.ErrWriter(ex);
}
return(list);
}
