private LiveForecastModel.LiveForecastTBInfo GetLiveForecastTBInfoNow(DateTime DDateTime) { try { Common.LiveForecastModel.LiveForecastTBInfo infoList = null; string strSQL = "select * from SF_TROPICALSTORM_TB where ddatetime = to_date('" + DDateTime.ToString("yyyy-MM-dd HH:mm") + "','yyyy-mm-dd hh24:mi') "; OracleHelper oh = new OracleHelper("HAIKOUConnect"); DataTable dTable = oh.ExecuteDataTable(strSQL); if (dTable != null && dTable.Rows.Count > 0) { infoList = new Common.LiveForecastModel.LiveForecastTBInfo(); infoList.Ddatetime = DDateTime.ToString("yyyy-MM-dd HH:mm"); infoList.Reporttime = dTable.Rows[0]["FORECASTTIME"].ToString(); infoList.Name = dTable.Rows[0]["NAME"].ToString(); infoList.Middleposition = dTable.Rows[0]["MIDDLEPOSITION"].ToString(); infoList.Strength = dTable.Rows[0]["STRENGTH"].ToString(); infoList.Windspeed = dTable.Rows[0]["WINDSPEED"].ToString(); infoList.Middlepressure = dTable.Rows[0]["MIDDLEPRESSURE"].ToString(); infoList.Referposition = dTable.Rows[0]["REFERPOSITION"].ToString(); infoList.Report = dTable.Rows[0]["REPORT"].ToString(); } return(infoList); } catch (Exception ex) { OracleHelper.ErrWriter(ex); } return(null); }
public bool InsertLiveForecast(DateTime dt, Common.LiveForecastModel.LiveForecastInfo info, Common.LiveForecastModel.LiveForecastTBInfo TBinfo, string forecaster) { try { string strSQL = ""; string strSQLTB = ""; string strID = ""; string strIDTB = ""; int result1 = 0; int result = 0; strSQL = "select recid from SF_LIVEFORECAST where ddatetime=to_date('" + dt.ToString("yyyy-MM-dd HH:mm") + "','yyyy-mm-dd hh24:mi')"; strSQLTB = "select recid from SF_TROPICALSTORM_TB where ddatetime=to_date('" + dt.ToString("yyyy-MM-dd HH:mm") + "','yyyy-mm-dd hh24:mi')"; OracleHelper oh = new OracleHelper("HAIKOUConnect"); strID = oh.db_GreateQuery(strSQL); strIDTB = oh.db_GreateQuery(strSQLTB); DateTime updateTime = dt.AddHours(12); //预报一下次更新时间 if (strID.Length > 0) { strSQL = "update SF_LIVEFORECAST set DDATETIME =to_date('" + dt.ToString("yyyy-MM-dd HH:mm") + "','yyyy-mm-dd hh24:mi') " + ",FORECASTER='" + info.Forecaster + "'" + ",SUMMARY='" + info.Summary + "'" + ",RAINVAL='" + info.Rainval + "'" + ",WINDVAL='" + info.Windval + "'" + ",THREEHOUR_REPORTVAL='" + info.Threehour_reportval + "'" + ",THREEDAY_REPORTVAL='" + info.Threeday_reportval + "'" + ",WINDPIC='" + info.Windpic + "'" + ",WINDPICDES='" + info.Windpicdes + "'" + ",RAINPIC='" + info.Raindpic + "'" + ",RAINPICDES='" + info.Rainpicdes + "'" + ",DDATETIME =to_date('" + updateTime.ToString("yyyy-MM-dd HH:mm") + "','yyyy-mm-dd hh24:mi') " + ",FILEFLAG=0" + " where RECID=" + strID; } else { strSQL = "insert into SF_LIVEFORECAST(DDATETIME,FORECASTER,SUMMARY,RAINVAL,WINDVAL,THREEHOUR_REPORTVAL,THREEDAY_REPORTVAL,WINDPIC,WINDPICDES,RAINPIC,UPDATETIME,RAINPICDES) values(" + " to_date('" + dt.ToString("yyyy-MM-dd HH:mm") + "','yyyy-mm-dd hh24:mi') " + ",'" + info.Forecaster + "'" + ",'" + info.Summary + "'" + ",'" + info.Rainval + "'" + ",'" + info.Windval + "'" + ",'" + info.Threehour_reportval + "'" + ",'" + info.Threeday_reportval + "'" + ",'" + info.Windpic + "'" + ",'" + info.Windpicdes + "'" + ",'" + info.Raindpic + "'" + " ,to_date('" + updateTime.ToString("yyyy-MM-dd HH:mm") + "','yyyy-mm-dd hh24:mi') " + ",'" + info.Rainpicdes + "')"; } result1 = oh.db_ExecuteNonQuery(strSQL); //表格数据 if (strIDTB.Length > 0) { strSQLTB = "update SF_TROPICALSTORM_TB set DDATETIME =to_date('" + dt.ToString("yyyy-MM-dd HH:mm") + "','yyyy-mm-dd hh24:mi') " + ",FORECASTTIME='" + TBinfo.Reporttime + "'" + ",NAME='" + TBinfo.Name + "'" + ",MIDDLEPOSITION='" + TBinfo.Middleposition + "'" + ",STRENGTH='" + TBinfo.Strength + "'" + ",WINDSPEED='" + TBinfo.Windspeed + "'" + ",MIDDLEPRESSURE='" + TBinfo.Middlepressure + "'" + ",REFERPOSITION='" + TBinfo.Referposition + "'" + ",REPORT='" + TBinfo.Report + "'" + " where RECID=" + strIDTB; } else { strSQLTB = "insert into SF_TROPICALSTORM_TB(DDATETIME,FORECASTTIME,NAME,MIDDLEPOSITION,STRENGTH,WINDSPEED,MIDDLEPRESSURE,REFERPOSITION,REPORT) values(" + " to_date('" + dt.ToString("yyyy-MM-dd HH:mm") + "','yyyy-mm-dd hh24:mi') " + ",'" + TBinfo.Reporttime + "'" + ",'" + TBinfo.Name + "'" + ",'" + TBinfo.Middleposition + "'" + ",'" + TBinfo.Strength + "'" + ",'" + TBinfo.Windspeed + "'" + ",'" + TBinfo.Middlepressure + "'" + ",'" + TBinfo.Referposition + "'" + ",'" + TBinfo.Report + "')"; } result = oh.db_ExecuteNonQuery(strSQLTB); if (result1 <= 0 || result <= 0) { return(false); } } catch (Exception ex) { return(false); } return(true); }
public Common.LiveForecastModel.LiveForecastTBInfo GetLiveForecastTBInfo(DateTime DDateTime) { Common.LiveForecastModel.LiveForecastTBInfo info = GetLiveForecastTBInfoNow(DDateTime); return(info); }
public bool InsertLiveForcast(DateTime dt, Common.LiveForecastModel.LiveForecastInfo info, Common.LiveForecastModel.LiveForecastTBInfo TBinfo, string forecaster) { return(lfDAL.InsertLiveForecast(dt, info, TBinfo, forecaster)); }