public void CreateMajorShareholderRecord(StockMajorShareholder shareholder)
{
var sql = @"insert into stock_major_shareholder (code, holdername, holdernature, holdertype, holderrank, holdshareamount, holdshareratio, sharetype, enddate, publishdate, updatetime)
values(@code, @holdername, @holdernature, @holdertype, @holderrank, @holdshareamount, @holdshareratio, @sharetype, @enddate, @publishdate, @updatetime);";
var parameters = new IDataParameter[]
{
new MySqlParameter("@code", shareholder.Code),
new MySqlParameter("@holdername", shareholder.HolderName),
new MySqlParameter("@holdernature", shareholder.HolderNature),
new MySqlParameter("@holdertype", shareholder.HolderType),
new MySqlParameter("@holderrank", shareholder.HolderRank),
new MySqlParameter("@holdshareamount", shareholder.HoldShareAmount),
new MySqlParameter("@holdshareratio", shareholder.HoldShareRatio),
new MySqlParameter("@sharetype", shareholder.ShareType),
new MySqlParameter("@enddate", shareholder.EndDate),
new MySqlParameter("@publishdate", shareholder.PublishDate),
new MySqlParameter("@updatetime", DateTime.Now),
};
var returnCode = this.DbRequest.ExecuteNonQuery(this.ConnectionString, sql, parameters, CommandType.Text);
}
public void UpdateStockMatrix_Major_Shareholder(string stockCode, List<CompanyMajorShareholder> majorShareholderList)
{
if (majorShareholderList == null || majorShareholderList.Count == 0)
{
return;
}
foreach (var holder in majorShareholderList)
{
var stock_shareholder = new StockMajorShareholder()
{
Code = stockCode,
EndDate = new DateTime(int.Parse(holder.EndDate.Substring(0, 4)), int.Parse(holder.EndDate.Substring(4, 2)), int.Parse(holder.EndDate.Substring(6, 2))),
PublishDate = holder.PublishDate == null ? (DateTime?)null : new DateTime(int.Parse(holder.PublishDate.Substring(0, 4)), int.Parse(holder.PublishDate.Substring(4, 2)), int.Parse(holder.PublishDate.Substring(6, 2))),
HolderName = holder.HolderName,
HolderNature = holder.HolderNature,
HolderRank = holder.HolderRank,
HolderType = holder.HolderType,
HoldShareAmount = holder.HoldShareAmount,
HoldShareRatio = holder.HoldShareRatio,
ShareType = holder.ShareType,
UpdateTime = DateTime.Now
};
_cmsRepository.CreateMajorShareholderRecord(stock_shareholder);
}
}
