public static List <werathof> getTideHigh(string dateTime)
{
try
{
string foreTime = "2016-8-27 16:00:00";
string vennue = "106";
List <werathof> info = new List <werathof>();
werathof ss = new werathof();
string sql = string.Format(@" select * from t_sz_grid_forecast where ddatetime = to_date('{0}', 'yyyy-mm-dd hh24:mi:ss')--20
and ybsx in (24,48,72,96,120,144,168)
and venueid = {1}", foreTime, vennue);
DataTable dt = db_GreateDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
ss.mintemp = dt.Rows[i]["MINTEMP"].ToString();
ss.maxtemp = dt.Rows[i]["MAXTEMP"].ToString();
ss.forecast = Convert.ToDateTime(dt.Rows[i]["FORECASTTIME"]).ToString("MM月dd日");
ss.time = Convert.ToDateTime(foreTime).ToString("yyyy-MM-dd HH:mm:ss");
info.Add(ss);
ss = new werathof();
}
return(info);
}
catch (Exception e)
{
string err = e.Message;
return(null);
}
}
public static List <werathof> getdata(string dateTime)
{
try
{
string foreTime = "2016-8-27 16:00:00";
string vennue = "106";
List <werathof> info = new List <werathof>();
werathof ss = new werathof();
string sql = string.Format(@"select* from t_sz_grid_forecast
where ddatetime = to_date('{0}', 'yyyy-mm-dd hh24:mi:ss')--20
and venueid = {1}
and ybsx between 0 and 23", foreTime, vennue);
DataTable dt = db_GreateDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
ss.mintemp = dt.Rows[i]["T2M"].ToString();
ss.maxtemp = dt.Rows[i]["rhsfc"].ToString();
ss.wether = dt.Rows[i]["wspd10m"].ToString();
ss.forecast = dt.Rows[i]["YBSX"].ToString();
info.Add(ss);
ss = new werathof();
}
return(info);
}
catch (Exception e)
{
string err = e.Message;
return(null);
}
}
public static List <werathof> GetforecastData(int day, string forTime)
{
List <werathof> info = new List <werathof>();
werathof ss = new werathof();
string sql = string.Format(@"select* from t_sz_grid_forecast
where ddatetime = to_date('{0}', 'yyyy-mm-dd hh24:mi:ss')--20
and venueid = 106
and ybsx between " + 24 * (day - 1) + " and " + 24 * day, forTime);
DataTable dt = db_GreateDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
ss.mintemp = dt.Rows[i]["T2M"].ToString();
ss.maxtemp = dt.Rows[i]["rhsfc"].ToString(); //相随湿度
ss.wether = dt.Rows[i]["wspd10m"].ToString(); //10米风
ss.forecast = dt.Rows[i]["YBSX"].ToString();
info.Add(ss);
ss = new werathof();
}
return(info);
}
