private Common.DuanwuForecastModel.DuanwuForecastTBInfo GetDuanwuForecastInfoNow(DateTime dt)
{
try
{
Common.DuanwuForecastModel.DuanwuForecastTBInfo infoList = null;
string strSQL = "select * from sf_duanwuforecast_tb where ddatetime = to_date('" + dt.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.DuanwuForecastModel.DuanwuForecastTBInfo();
string[] Forecasttime = new string[dTable.Rows.Count];
string[] Weatherpic = new string[dTable.Rows.Count];
string[] Weatherdes = new string[dTable.Rows.Count];
string[] Temperature = new string[dTable.Rows.Count];
string[] Wind = new string[dTable.Rows.Count];
for (int i = 0; i < dTable.Rows.Count; i++)
{
infoList.Ddatetime = dt.ToString("yyyy-MM-dd HH:mm");
Forecasttime[i] = dTable.Rows[i]["FORECASTTIME"].ToString();
Weatherpic[i] = dTable.Rows[i]["WEATHERPIC"].ToString();
Weatherdes[i] = dTable.Rows[i]["WEATHER"].ToString();
Temperature[i] = dTable.Rows[i]["TEMPERATURE"].ToString();
Wind[i] = dTable.Rows[i]["WIND"].ToString();
}
infoList.Forecasttime = Forecasttime;
infoList.Weatherpic = Weatherpic;
infoList.Weatherdes = Weatherdes;
infoList.Temperature = Temperature;
infoList.Wind = Wind;
}
return(infoList);
}
catch (Exception ex)
{
OracleHelper.ErrWriter(ex);
}
return(null);
}
//端午专报
public bool InsertDuanwuForecast(DateTime dt, Common.DuanwuForecastModel.DuanwuForecastInfo info, Common.DuanwuForecastModel.DuanwuForecastTBInfo TBinfo, string forecaster)
{
try
{
string strSQL = "";
string strSQLTB = "";
string str = "";
string strID = "";
string strIDTB = "";
int result1 = 0;
int result = 0;
strSQL = "select recid from sf_duanwuforecast where ddatetime=to_date('" + dt.ToString("yyyy-MM-dd HH:mm") + "','yyyy-mm-dd hh24:mi')";
strSQLTB = "select recid from sf_duanwuforecast_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);
if (strID.Length > 0)
{
strSQL = "update sf_duanwuforecast set DDATETIME =to_date('" + dt.ToString("yyyy-MM-dd HH:mm") + "','yyyy-mm-dd hh24:mi') "
+ ",FORECASTER='" + info.Forecaster + "'"
+ ",WAETHERTREND='" + info.Weather_trend + "'"
+ ",WEATHERFORECAST='" + info.Weather_details + "'"
+ ",WEATHERPIC='" + info.Pic + "'"
+ ",WEATHERPICDES='" + info.PicDes + "'"
+ ",SUBHEAD='" + info.Subhead + "'"
+ ",FILEFLAG=0"
+ " where RECID=" + strID;
}
else
{
strSQL = "insert into sf_duanwuforecast(DDATETIME,FORECASTER,WAETHERTREND,WEATHERFORECAST,WEATHERPIC,WEATHERPICDES,SUBHEAD,recid) values("
+ " to_date('" + dt.ToString("yyyy-MM-dd HH:mm") + "','yyyy-mm-dd hh24:mi') "
+ ",'" + info.Forecaster + "'"
+ ",'" + info.Weather_trend + "'"
+ ",'" + info.Weather_details + "'"
+ ",'" + info.Pic + "'"
+ ",'" + info.PicDes + "'"
+ ",'" + info.Subhead + "',SEQ_sf_duanwuforecast.Nextval)";
}
result1 = oh.db_ExecuteNonQuery(strSQL);
//表格数据
strSQLTB = "insert all into sf_duanwuforecast_tb(DDATETIME,FORECASTTIME,WEATHERPIC,WEATHER,TEMPERATURE,WIND,recid) ";
for (int i = 0; i < TBinfo.Forecasttime.Length; i++)
{
if (i == TBinfo.Forecasttime.Length - 1)
{
str += "values (to_date('" + dt.ToString("yyyy-MM-dd HH:mm") + "','yyyy-mm-dd hh24:mi') "
+ ",'" + TBinfo.Forecasttime[i] + "'"
+ ",'" + TBinfo.Weatherpic[i] + "'"
+ ",'" + TBinfo.Weatherdes[i] + "'"
+ ",'" + TBinfo.Temperature[i] + "'"
+ ",'" + TBinfo.Wind[i] + "',seq_sf_duanwuforecast_tb.Nextval) SELECT * FROM dual";
}
else
{
str += "values (to_date('" + dt.ToString("yyyy-MM-dd HH:mm") + "','yyyy-mm-dd hh24:mi') "
+ ",'" + TBinfo.Forecasttime[i] + "'"
+ ",'" + TBinfo.Weatherpic[i] + "'"
+ ",'" + TBinfo.Weatherdes[i] + "'"
+ ",'" + TBinfo.Temperature[i] + "'"
+ ",'" + TBinfo.Wind[i] + "',seq_sf_duanwuforecast_tb.Nextval) into sf_duanwuforecast_tb(DDATETIME,FORECASTTIME,WEATHERPIC,WEATHER,TEMPERATURE,WIND,recid) ";
}
}
strSQLTB += str;
result = oh.db_ExecuteNonQuery(strSQLTB);
if (result1 <= 0 || result <= 0)
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public Common.DuanwuForecastModel.DuanwuForecastTBInfo GetDuanwuForecastTBInfo(DateTime dt)
{
Common.DuanwuForecastModel.DuanwuForecastTBInfo info = GetDuanwuForecastInfoNow(dt);
return(info);
}
//端午专报
public bool InsertDuanwuForcast(DateTime dt, Common.DuanwuForecastModel.DuanwuForecastInfo info, Common.DuanwuForecastModel.DuanwuForecastTBInfo TBinfo, string forecaster)
{
return(hfDAL.InsertDuanwuForecast(dt, info, TBinfo, forecaster));
}
