public List <LWSTripsInfo> GetForecastTrips(DateTime dt) //后推两小时 { List <LWSTripsInfo> newList = null; try { dt = DateTime.Parse(dt.ToString("yyyy-MM-dd HH:") + ((dt.Minute / 6) * 6)); DateTime dtStar = dt.AddMinutes(-105); DateTime dtEnd = dt.AddMinutes(138); String dtStart = dtStar.ToString("yyyy/M/dd HH:mm:ss"); String dtend = dtEnd.ToString("yyyy/M/dd HH:mm:ss"); string SQL = "select DDATETIME,CITY,W_TYPE,W_LEVEL from t_hk_warning t where DDATETIME between to_date('" + dtStart + "','yyyy-mm-dd hh24:mi:ss') and to_date('" + dtend + "','yyyy-mm-dd hh24:mi:ss')"; DataTable dbResult = DbHelperOra.Query(SQL, CommonClass.GetconnectionStringsValue("ConnectionEJETDB247Idcty")).Tables[0]; LWSTripsInfo info; if (dbResult != null && dbResult.Rows.Count > 0) { newList = new List <LWSTripsInfo>(); DateTime dt2 = DateTime.Parse("2000-1-1"); //int d0 = 0; for (int i = 0; i < dbResult.Rows.Count; i++) { info = new LWSTripsInfo(); dt2 = DateTime.Parse("2000-1-1"); if (!DateTime.TryParse(dbResult.Rows[i]["DDATETIME"].ToString(), out dt2)) { continue; } info.DDATETIME = dt2; //d0 = 0; info.W_TYPE = dbResult.Rows[i]["W_TYPE"].ToString(); info.CITY = dbResult.Rows[i]["CITY"].ToString(); info.W_LEVEL = dbResult.Rows[i]["W_LEVEL"].ToString(); //int.TryParse(dbResult.Rows[i]["flagindex"].ToString(), out d0); //info.FlagIndex = d0; //dt2 = DateTime.Parse("2000-1-1"); //if (!DateTime.TryParse(dbResult.Rows[i]["FORECASTTIME"].ToString(), out dt2)) continue; //info.DDateTime = dt2; //info.DDateTimestr = dt2.ToString("yyyy-MM-dd HH:mm:ss"); ////if (info.DDateTime > Convert.ToDateTime("2015-06-10 00:00:00")) ////{ //// if (info.FlagIndex == 6 || info.FlagIndex == 7 || info.FlagIndex == 8) //// { //// int.TryParse(dbResult.Rows[i]["PRODUCTTYPE"].ToString(), out d0); //// if (d0 == 0) continue; //// } ////} //d0 = 0; //info.Region = dbResult.Rows[i]["region"].ToString(); //info.TripContent = dbResult.Rows[i]["tripcontent"].ToString(); //d0 = 0; //int.TryParse(dbResult.Rows[i]["triptype"].ToString(), out d0); //info.TripType = d0; //d0 = 0; //int.TryParse(dbResult.Rows[i]["usetype"].ToString(), out d0); //info.UseType = d0; //int.TryParse(dbResult.Rows[i]["RECID"].ToString(), out d0); //info.RECID = d0; newList.Add(info); } } string dd = dt.ToString("yyyy/M/dd HH:mm:ss"); SQL = "select DDATETIME,CITY,W_TYPE,W_LEVEL from t_hk_warning t where DDATETIME = to_date('" + dd + "','yyyy-mm-dd hh24:mi:ss')"; dbResult = DbHelperOra.Query(SQL, CommonClass.GetconnectionStringsValue("ConnectionEJETDB247Idcty")).Tables[0]; if (dbResult != null && dbResult.Rows.Count > 0) { newList = new List <LWSTripsInfo>(); DateTime dt2 = DateTime.Parse("2000-1-1"); //int d0 = 0; for (int i = 0; i < dbResult.Rows.Count; i++) { info = new LWSTripsInfo(); dt2 = DateTime.Parse("2000-1-1"); //if (!DateTime.TryParse(dbResult.Rows[i]["DDATETIME"].ToString(), out dt2)) continue; //d0 = 0; //int.TryParse(dbResult.Rows[i]["LEADTIME"].ToString(), out d0); //info.DDateTime = dt2.AddMinutes(d0); //info.DDateTimestr = dt2.ToString("yyyy-MM-dd HH:mm:ss"); //d0 = 0; //int.TryParse(dbResult.Rows[i]["flagindex"].ToString(), out d0); //info.FlagIndex = d0; //info.Region = dbResult.Rows[i]["region"].ToString(); //info.TripContent = dbResult.Rows[i]["tripcontent"].ToString(); //d0 = 0; //int.TryParse(dbResult.Rows[i]["usetype"].ToString(), out d0); //info.UseType = d0; //int.TryParse(dbResult.Rows[i]["RECID"].ToString(), out d0); //info.RECID = d0; newList.Add(info); } } } catch (Exception ex) { CommonClass.ErrWriter(ex.ToString()); newList = null; } return(newList); }
public List <LWSTripsInfo> GetRecentTrips(int TRIPTYPE, DateTime dt) // 前推两小时 { List <LWSTripsInfo> newList = null; try { DateTime dtStar = dt.AddMinutes(-105); DateTime dtEnd = dt.AddMinutes(138); String dtStart = dtStar.ToString("yyyy/M/dd HH:mm:ss"); String dtend = dtEnd.ToString("yyyy/M/dd HH:mm:ss"); //数据库的时间格式 string SQL = "select DDATETIME,CITY,W_TYPE,W_LEVEL from t_hk_warning t where DDATETIME between to_date('" + dtStart + "','yyyy-mm-dd hh24:mi:ss') and to_date('" + dtend + "','yyyy-mm-dd hh24:mi:ss')"; DataTable dbResult = DbHelperOra.Query(SQL, CommonClass.GetconnectionStringsValue("ConnectionEJETDB247Idcty")).Tables[0]; LWSTripsInfo info; if (dbResult != null && dbResult.Rows.Count > 0) { newList = new List <LWSTripsInfo>(); DateTime dt2 = DateTime.Parse("2000-1-1"); //int d0 = 0; for (int i = 0; i < dbResult.Rows.Count; i++) { info = new LWSTripsInfo(); dt2 = DateTime.Parse("2000-1-1"); if (!DateTime.TryParse(dbResult.Rows[i]["DDATETIME"].ToString(), out dt2)) { continue; } info.DDATETIME = dt2; //d0 = 0; info.W_TYPE = dbResult.Rows[i]["W_TYPE"].ToString(); info.CITY = dbResult.Rows[i]["CITY"].ToString(); info.W_LEVEL = dbResult.Rows[i]["W_LEVEL"].ToString(); //d0 = 0; //int.TryParse(dbResult.Rows[i]["triptype"].ToString(), out d0); //info.TripType = d0; //d0 = 0; //int.TryParse(dbResult.Rows[i]["usetype"].ToString(), out d0); //info.UseType = d0; //info.DDateTimestr = info.DDateTime.ToString("yyyy-MM-dd HH:mm:ss"); //int.TryParse(dbResult.Rows[i]["RECID"].ToString(), out d0); //info.RECID = d0; newList.Add(info); } } //冰雹 //dtend = DateTime.Parse(dtEnd.ToString("yyyy-MM-dd HH:") + ((dtEnd.Minute / 6) * 6)); //dtStar = DateTime.Parse(dtStar.ToString("yyyy-MM-dd HH:") + ((dtStar.Minute / 6) * 6)); //SQL = "select RECID,ddatetime,flagindex,region,tripcontent,usetype from lws_hailtrips where LEADTIME=0 and ddatetime between " + GetOraceDateTimeFormatString(dtStar) + " and " + GetOraceDateTimeFormatString(dtend) + " order by ddatetime,flagindex"; //dbResult = DbHelperOra.Query(SQL, CommonClass.GetconnectionStringsValue("ConnectionNowGis2010")).Tables[0]; //if (dbResult != null && dbResult.Rows.Count > 0) //{ // newList = new List<LWSTripsInfo>(); // DateTime dt2 = DateTime.Parse("2000-1-1"); // int d0 = 0; // for (int i = 0; i < dbResult.Rows.Count; i++) // { // info = new LWSTripsInfo(); // dt2 = DateTime.Parse("2000-1-1"); //if (!DateTime.TryParse(dbResult.Rows[i]["ddatetime"].ToString(), out dt2)) continue; //info.DDateTime = DateTime.Parse(dt2.ToString("yyyy-MM-dd HH:") + ((dt2.Minute / 5) * 5)); //d0 = 0; //int.TryParse(dbResult.Rows[i]["flagindex"].ToString(), out d0); //info.FlagIndex = d0; //info.Region = dbResult.Rows[i]["region"].ToString(); //info.TripContent = dbResult.Rows[i]["tripcontent"].ToString(); //d0 = 0; //int.TryParse(dbResult.Rows[i]["usetype"].ToString(), out d0); //info.UseType = d0; //int.TryParse(dbResult.Rows[i]["RECID"].ToString(), out d0); //info.RECID = d0; //newList.Add(info); //} //} } catch (Exception ex) { CommonClass.ErrWriter(ex.ToString()); newList = null; } return(newList); }