public void CreateSeasonForcast(StockSeasonReport forcast) { var sql = @"insert into stock_season_report(code, reportday, reportforcastdate, profittrend, forcastcontent, changereason, updatetime) values(@code, @reportday, @reportforcastdate, @profittrend, @forcastcontent, @changereason, @updatetime);"; var parameters = new IDataParameter[] { new MySqlParameter("@code", forcast.Code), new MySqlParameter("@reportday", DateTime.Parse(forcast.ReportDay.ToString("yyyy-MM-dd"))), new MySqlParameter("@reportforcastdate", forcast.ReportForcastDate), new MySqlParameter("@profittrend", forcast.ProfitTrend), new MySqlParameter("@forcastcontent", forcast.ForcastContent), new MySqlParameter("@changereason", forcast.ChangeReason), new MySqlParameter("@updatetime", DateTime.Now), }; var returnCode = this.DbRequest.ExecuteNonQuery(this.ConnectionString, sql, parameters, CommandType.Text); }
public void UpdateSeasonForcast(StockSeasonReport forcast) { var sql = @"update stock_season_report set profittrend = @profittrend, forcastcontent = @forcastcontent, changereason = @changereason, updatetime = @updatetime where code = @code and reportday = @reportday;"; var parameters = new IDataParameter[] { new MySqlParameter("@code", forcast.Code), new MySqlParameter("@reportday", DateTime.Parse(forcast.ReportDay.ToString("yyyy-MM-dd"))), new MySqlParameter("@reportforcastdate", forcast.ReportForcastDate), new MySqlParameter("@profittrend", forcast.ProfitTrend), new MySqlParameter("@forcastcontent", forcast.ForcastContent), new MySqlParameter("@changereason", forcast.ChangeReason), new MySqlParameter("@updatetime", DateTime.Now), }; var returnCode = this.DbRequest.ExecuteNonQuery(this.ConnectionString, sql, parameters, CommandType.Text); }
public void UpdateStockMatrix_Season_Profit_Report(string stockCode, List<CompanyPerformanceForcast> crawledForcastList) { if (crawledForcastList == null || crawledForcastList.Count == 0) { return; } foreach (var fc in crawledForcastList) { var forcast = new StockSeasonReport() { Code = stockCode, ReportDay = fc.ReportDay, ReportForcastDate = fc.ReportForcastDate, ProfitTrend = fc.ProfitTrend, ForcastContent = fc.ForcastContent, ChangeReason = fc.ChangeReason, UpdateTime = DateTime.Now, }; var records = _ssrRepository.RetrieveByStockAndSeasonReportDay(forcast.Code, forcast.ReportDay); if (records == null) { _ssrRepository.CreateSeasonForcast(forcast); } else { _ssrRepository.UpdateSeasonForcast(forcast); } } }