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