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);
}
