public void Update(StockPriceHistory entity)
{
var format = @"update stockpricehistory set `openprice` = {1}, `price` = {2}, `highestprice` = {3}, `lowestprice` = {4}, `ceilingprice` = {5}, `floorprice` = {6}, `yesterdaycloseprice` = {7}, `pricechangepercent` = {8}, `priceshakepercent` = {9}, `exchangerate` = {10}, `exchangeamountinhands` = {11}, `exchangeamountinrmb` = {12}, `pe` = {13}, `pb` = {14}, `flowablemarketvalue` = {15}, `totalmarketvalue` = {16}, `updatetime` = '{17}' where `id` = {0};";
var f1 = entity.OpenPrice;
var f2 = entity.Price;
var f3 = entity.HighestPrice;
var f4 = entity.LowestPrice;
var f5 = entity.CeilingPrice;
var f6 = entity.FloorPrice;
var f7 = entity.YesterdayClosePrice;
var f8 = entity.PriceChangePercent;
var f9 = entity.PriceShakePercent;
var f10 = entity.ExchangeRate;
var f11 = entity.ExchangeAmountInHands;
var f12 = entity.ExchangeAmountInRMB;
var f13 = entity.PE;
var f14 = entity.PB;
var f15 = entity.FlowableMarketValue;
var f16 = entity.TotalMarketValue;
var f17 = DateTime.Now.ToString(Setting.Date_Format_4y_2M_2d_2H_2m_2s);
var formatedSql = string.Format(format, entity.Id, f1, f2, f3, f4, f5, f6, f7, f8, f9, f10, f11, f12, f13, f14, f15, f16, f17);
this.DbRequest.ExecuteNonQuery(this.ConnectionString, formatedSql, null, CommandType.Text);
}
public void Create(StockPriceHistory entity)
{
var sql = @"insert into stockpricehistory(openprice,price,highestprice,lowestprice,ceilingprice,floorprice,yesterdaycloseprice,pricechangepercent,priceshakepercent,exchangerate,exchangeamountinhands,exchangeamountinrmb,pe,pb,flowablemarketvalue,totalmarketvalue,createtime,updatetime,code,name,date) values(@openprice,@price,@highestprice,@lowestprice,@ceilingprice,@floorprice,@yesterdaycloseprice,@pricechangepercent,@priceshakepercent,@exchangerate,@exchangeamountinhands,@exchangeamountinrmb,@pe,@pb,@flowablemarketvalue,@totalmarketvalue,@createtime,@updatetime,@code,@name,@date);";
var parameters = new IDataParameter[]
{
new MySqlParameter("@openprice",entity.OpenPrice),
new MySqlParameter("@price",entity.Price),
new MySqlParameter("@highestprice",entity.HighestPrice),
new MySqlParameter("@lowestprice",entity.LowestPrice),
new MySqlParameter("@ceilingprice",entity.CeilingPrice),
new MySqlParameter("@floorprice",entity.FloorPrice),
new MySqlParameter("@yesterdaycloseprice",entity.YesterdayClosePrice),
new MySqlParameter("@pricechangepercent",entity.PriceChangePercent),
new MySqlParameter("@priceshakepercent",entity.PriceShakePercent),
new MySqlParameter("@exchangerate",entity.ExchangeRate),
new MySqlParameter("@exchangeamountinhands",entity.ExchangeAmountInHands),
new MySqlParameter("@exchangeamountinrmb",entity.ExchangeAmountInRMB),
new MySqlParameter("@pe",entity.PE),
new MySqlParameter("@pb",entity.PB),
new MySqlParameter("@flowablemarketvalue",entity.FlowableMarketValue),
new MySqlParameter("@totalmarketvalue",entity.TotalMarketValue),
new MySqlParameter("@createtime",DateTime.Now),
new MySqlParameter("@updatetime",DateTime.Now),
new MySqlParameter("@code",entity.Code),
new MySqlParameter("@name",entity.Name),
new MySqlParameter("@date",entity.Date.ToString("yyyy-MM-dd"))
};
this.DbRequest.ExecuteNonQuery(this.ConnectionString, sql, parameters, CommandType.Text);
}
static StockPriceHistory CreateNewPriceItem(MarketStock stock, DateTime today)
{
// 从数据源获取最新的价格数据
var pulse = _crawler.FetchRealtimePrice(stock.Market, stock.Code);
if (pulse == null)
{
return null;
}
var priceItem = new StockPriceHistory()
{
Code = stock.Code,
Name = stock.Name,
Date = today,
OpenPrice = pulse.F5_TodayOpenPrice ?? 0,
Price = pulse.F3_CurrentPrice ?? 0,
HighestPrice = pulse.F33_HighestPriceInToday ?? 0,
LowestPrice = pulse.F34_LowestPriceInToday ?? 0,
CeilingPrice = pulse.F47_CeilingPrice ?? 0,
FloorPrice = pulse.F48_FloorPrice ?? 0,
YesterdayClosePrice = pulse.F4_YesterdayClosePrice ?? 0,
PriceChangePercent = pulse.F32_PriceChangePercent ?? 0,
PriceShakePercent = pulse.F43_PriceShakePercent,
ExchangeRate = pulse.F38_ExchangeHandsRatePercent ?? 0,
ExchangeAmountInHands = pulse.F6_ExchangedNumbersInHands ?? 0,
ExchangeAmountInRMB = pulse.F37_ExchangeAmountInRMBTenThousand ?? 0,
PB = pulse.F46_PB ?? 0,
PE = pulse.F39_DynamicPE ?? 0,
FlowableMarketValue = pulse.F44_FlowableValue ?? 0,
TotalMarketValue = pulse.F45_TotalValue ?? 0,
CreateTime = DateTime.Now,
UpdateTime = DateTime.Now,
};
return priceItem;
}