public static EachDayTVSeriesDO GetTVSeries(DateTime effectiveDate, int timeTypeID) { string sql = @"select * from [dbo].[EachDayTVSeries] where EffectiveDate=@EffectiveDate and TimeTypeID=@TimeTypeID"; EachDayTVSeriesDO tvDO = new EachDayTVSeriesDO(); SqlParameter[] pars = new SqlParameter[2]; pars[0] = new SqlParameter("@EffectiveDate", effectiveDate); pars[1] = new SqlParameter("@TimeTypeID", timeTypeID); return((EachDayTVSeriesDO)baseLogic.Select(tvDO, sql, pars)); }
private void ReadTVSeries(DateTime reportDate, string filePath) { try { DataTable dtChannel = NPOIHelper.ImportExceltoDt(filePath, "交互分析", 1); if (dtChannel == null) { MessageBox.Show("文件中未找到相关数据"); return; } for (int i = 2; i < dtChannel.Rows.Count; i++) { DataRow row = dtChannel.Rows[i]; string name = row[1].ToString().Trim(); if (string.IsNullOrEmpty(name)) { continue; } int timeTypeID = 1; if (name.StartsWith("08:30")) { timeTypeID = 1; } else if (name.StartsWith("12:30")) { timeTypeID = 2; } else if (name.StartsWith("19:30")) { timeTypeID = 3; } string tvRate = row[3].ToString(); decimal _tvRate = 0; decimal.TryParse(tvRate, out _tvRate); EachDayTVSeriesDO tvDO = new EachDayTVSeriesDO(); tvDO.StrTime = name; tvDO.TimeTypeID = timeTypeID; tvDO.EffectiveDate = reportDate; tvDO.TVRate = _tvRate; tvDO.EffectiveDate = reportDate; BusinessLogicBase.Default.Insert(tvDO); } MessageBox.Show("读取成功!"); } catch (Exception ex) { } }
public static decimal GetLastSameTVSeriesRate(DateTime effectiveDate, int timeTypeID) { string sql = @"select top 1 TVRate from [dbo].[EachDayTVSeries] where EffectiveDate<@EffectiveDate and EffectiveDate>=dateadd(day,-7,@EffectiveDate) and TimeTypeID=@TimeTypeID order by EffectiveDate desc"; EachDayTVSeriesDO tvDO = new EachDayTVSeriesDO(); SqlParameter[] pars = new SqlParameter[2]; pars[0] = new SqlParameter("@EffectiveDate", effectiveDate); pars[1] = new SqlParameter("@TimeTypeID", timeTypeID); decimal result = 0; DataTable dt = baseLogic.Select(sql, pars); if (dt != null && dt.Rows.Count > 0) { decimal.TryParse(dt.Rows[0][0].ToString(), out result); } return(result); }