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