/// <summary> /// 下載殖利率/平均月股價 /// </summary> /// <param name="stock_id">非必填</param> public void DownloadYields(string stock_id = "") { try { CheckStockCrawlerYields CSCY = new CheckStockCrawlerYields(); YieldsRepository YR = new YieldsRepository(); StockRepository SR = new StockRepository(); if (!string.IsNullOrWhiteSpace(stock_id)) { var addYields = CSCY.CheckYields(stock_id); } else { var stockList = SR.GetAll(); foreach (var stock in stockList) { var tmp = YR.Get(x => x.Stock_ID == stock.Stock_ID); if (tmp == null) { var addYields = CSCY.CheckYields(stock.Stock_ID); Console.Write("目前進行至 :" + stock.Stock_ID); if (addYields.Count > 0) { YR.CreateAll(addYields); Console.WriteLine("\t新增 : " + addYields.Count + " 筆資料"); } else { Console.WriteLine($"無新增資料"); } } else { Console.WriteLine("已取得資料 : " + stock.Stock_ID); } } } YR.SaveChanges(); } catch (Exception ex) { throw ex; } }
public YieldsService() { db = new AngleSharpEntities(); YR = new YieldsRepository(); }
public CheckStockCrawlerYields() { YR = new YieldsRepository(); TS = new T_StockService(); }