private StockBonusInfo GetLatestStockBonusByCodeFromSql(List <StockBonusInfo> list, string code) { StockBonusInfo info = new StockBonusInfo(); info.code = null; foreach (var item in list) { if (item.code == code) { info = item; } } return(info); }
public List <StockBonusInfo> GetStockBonusListFromSql(string code = "") { List <StockBonusInfo> list = new List <StockBonusInfo>(); var sqlStr = "select * from [Common].[dbo].[StockBonusInfo]"; if (code != "") { sqlStr = string.Format("select * from [Common].[dbo].[StockBonusInfo] where code='{0}'", code); } DataTable dt = new DataTable(); try { dt = sqlReader.GetDataTable(sqlStr); } catch { logger.Warn(string.Format("There is no Stock Bonus information from specialized sqlserver!!!")); } foreach (DataRow dr in dt.Rows) { StockBonusInfo info = new StockBonusInfo(); info.exDividendDate = Convert.ToDateTime(dr["ExDividendDate"]); info.code = Convert.ToString(dr["Code"]); info.secName = Convert.ToString(dr["SecName"]); info.cashPayoutRatio = Convert.ToDouble(dr["CashPayoutRatio"]); info.exDividendNote = Convert.ToString(dr["ExDividendNote"]); info.rightsIssuePrice = Convert.ToDouble(dr["RightsIssuePrice"]); info.rightsIssueRatio = Convert.ToDouble(dr["RightsIssueRatio"]); info.seoPrice = Convert.ToDouble(dr["SeoPrice"]); info.seoRatio = Convert.ToDouble(dr["SeoRatio"]); info.stockDividendRatio = Convert.ToDouble(dr["StockDividendRatio"]); info.stockSplitRatio = Convert.ToDouble(dr["StockSplitRatio"]); info.updateTime = Convert.ToDateTime(dr["UpdateTime"]); if (info.cashPayoutRatio > 0) { list.Add(info); } } return(list); }