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