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); }