private void UpdatePrice(int centerId, bool bFirst)
{
try
{
var redisPrice = new RedisClient(ConfigRedis.PriceHost, ConfigRedis.PricePort);
var redis = new RedisClient(ConfigRedis.Host, ConfigRedis.Port);
//var pdt = bFirst ? sql.GetAllPrice(centerId) : sql.GetChangedPriceSymbols(centerId);
var sql = new SqlDb();
var isInTrading = Utils.InTradingTime(centerId);
var bRealtime = isInTrading;
if (!isInTrading)
{
var rlddt = sql.GetLastRealtimePriceDate(centerId);
var impdt = sql.GetLastImportPriceDate(centerId);
if (impdt.Rows.Count == 0)
{
bRealtime = rlddt.Rows.Count > 0;
}
else
{
if (rlddt.Rows.Count == 0) bRealtime = false;
else
{
bRealtime = int.Parse(rlddt.Rows[0][0].ToString().Replace(".", "")) > int.Parse(impdt.Rows[0][0].ToString().Replace(".", ""));
}
}
}
//log.WriteEntry("UpdatePrice : " + centerId + " : " + bRealtime, EventLogEntryType.Information);
var pdt = bRealtime ? sql.GetRealtimePrice(centerId) : sql.GetPriceData(centerId);
var allkey = string.Format(RedisKey.KeyRealTimePrice, centerId);
if (redis.ContainsKey(allkey))
redis.Set(allkey, Utils.Serialize(pdt));
else
redis.Add(allkey, Utils.Serialize(pdt));
var stats = new List<int> { 0, 0, 0, 0, 0 };
var rows = pdt.Select("Symbol<>'CENTER'");
//log.WriteEntry("UpdatePrice : " + centerId + " : " + bRealtime + " : " + rows[0]["TradeDate"], EventLogEntryType.Information);
foreach (var pdr in rows)
{
var symbol = pdr["Symbol"].ToString();
try
{
#region Get Stock Price Data
//var cdt = sql.GetCenterId(symbol);
//if (cdt.Rows.Count == 0) continue;
//var centerId = int.Parse(pdr["centerId"].ToString());
//var pdt = sql.GetRealtimePriceData(symbol, centerId);
//if (pdt.Rows.Count == 0) continue;
//var pdr = pdt.Rows[0];
var bAvg = centerId != 1 && !isInTrading;
var price = redis.Get<StockPrice>(String.Format(RedisKey.PriceKey, symbol)) ?? new StockPrice();
price.Symbol = symbol;
price.LastTradeDate = (DateTime)pdr["TradeDate"];
price.Price = double.Parse(pdr[bAvg ? "AveragePrice" : "TradingPrice"].ToString()); price.RefPrice = double.Parse(pdr["Ref"].ToString()); price.CeilingPrice = double.Parse(pdr["Ceiling"].ToString()); price.FloorPrice = double.Parse(pdr["Floor"].ToString()); price.Volume = double.Parse(pdr["TradingVol"].ToString()); price.Value = double.Parse(pdr["TotalTradingValue"].ToString()); price.HighPrice = double.Parse(pdr["TradingPriceMax"].ToString()); price.LowPrice = double.Parse(pdr["TradingPriceMin"].ToString()); price.OpenPrice = double.Parse(pdr["OpenPrice"].ToString()); price.ClosePrice = double.Parse(pdr["TradingPrice"].ToString());
try
{
price.AvgPrice = double.Parse(pdr["AveragePrice"].ToString());
price.ClosePrice = double.Parse(pdr["TradingPrice"].ToString());
}
catch (Exception) { }
price.BidTotalOrder = double.Parse(pdr["TotalBidOrder"].ToString());
price.BidTotalVolume = double.Parse(pdr["TotalBidVolume"].ToString());
price.AskTotalOrder = double.Parse(pdr["TotalAskOrder"].ToString());
price.AskTotalVolume = double.Parse(pdr["TotalAskVolume"].ToString());
if (double.Parse(pdr["HasForeign"].ToString()) >= 0)
{
price.ForeignCurrentRoom = double.Parse(pdr["RemainFrRoom"].ToString());
price.ForeignTotalRoom = double.Parse(pdr["FrTotalRoom"].ToString());
price.ForeignBuyValue = double.Parse(pdr["BuyFrValue"].ToString()); price.ForeignBuyVolume = double.Parse(pdr["BuyFrVolume"].ToString()); price.ForeignSellValue = double.Parse(pdr["SellFrValue"].ToString()); price.ForeignSellVolume = double.Parse(pdr["SellFrVolume"].ToString());
}
if (bRealtime)
{
price.AskPrice01 = double.Parse(pdr["SellPrice1"].ToString());
price.AskPrice02 = double.Parse(pdr["SellPrice2"].ToString());
price.AskPrice03 = double.Parse(pdr["SellPrice3"].ToString());
price.AskVolume01 = double.Parse(pdr["SellVol1"].ToString());
price.AskVolume02 = double.Parse(pdr["SellVol2"].ToString());
price.AskVolume03 = double.Parse(pdr["SellVol3"].ToString());
price.BidPrice01 = double.Parse(pdr["BidPrice1"].ToString());
price.BidPrice02 = double.Parse(pdr["BidPrice2"].ToString());
price.BidPrice03 = double.Parse(pdr["BidPrice3"].ToString());
price.BidVolume01 = double.Parse(pdr["BidVol1"].ToString());
price.BidVolume02 = double.Parse(pdr["BidVol2"].ToString());
price.BidVolume03 = double.Parse(pdr["BidVol3"].ToString());
}
#endregion
#region Update Center Stats
var key = string.Format(RedisKey.PriceKey, symbol);
if (redis.ContainsKey(key))
redis.Set<StockPrice>(key, price);
else
redis.Add<StockPrice>(key, price);
if (redisPrice.ContainsKey(key))
redisPrice.Set<StockPrice>(key, price);
else
redisPrice.Add<StockPrice>(key, price);
if (price.Price <= 0) continue;
if (Math.Round(price.Price, 2) <= Math.Round(price.FloorPrice, 2)) stats[0]++;
else if (Math.Round(price.Price, 2) < Math.Round(price.RefPrice, 2)) stats[1]++;
else if (Math.Round(price.Price, 2) >= Math.Round(price.CeilingPrice, 2)) stats[4]++;
else if (Math.Round(price.Price, 2) > Math.Round(price.RefPrice, 2)) stats[3]++;
else stats[2]++;
#endregion
}
catch (Exception ex)
{
log.WriteEntry("Price " + symbol + ":" + ex.ToString(), EventLogEntryType.Information);
}
}
#region Center stats
rows = pdt.Select("Symbol='CENTER'");
if (rows.Length == 0) return;
//update center stats
var centerkey = string.Format(RedisKey.KeyCenterIndex, centerId);
var center = redis.ContainsKey(centerkey) ? redis.Get<TradeCenterStats>(centerkey) : new TradeCenterStats() { TradeCenterId = centerId };
center.Ceiling = stats[4];
center.Up = stats[3];
center.Normal = stats[2];
center.Down = stats[1];
center.Floor = stats[0];
center.CurrentDate = (DateTime)rows[0]["TradeDate"];
//log.WriteEntry("UpdatePrice : " + centerId + " : Center : " + rows[0]["TradeDate"], EventLogEntryType.Information);
center.CurrentIndex = double.Parse(rows[0]["TradingPrice"].ToString());
center.PrevIndex = double.Parse(rows[0]["Ref"].ToString());
center.CurrentVolume = double.Parse(rows[0]["TotalTradingVolume"].ToString());
center.CurrentValue = double.Parse(rows[0]["TotalTradingValue"].ToString());
center.ForeignBuyVolume = double.Parse(rows[0]["BuyFrVolume"].ToString());
center.ForeignBuyValue = double.Parse(rows[0]["BuyFrValue"].ToString());
center.ForeignSellVolume = double.Parse(rows[0]["SellFrVolume"].ToString());
center.ForeignSellValue = double.Parse(rows[0]["SellFrValue"].ToString());
//chỉ số theo đợt
if (centerId == 1)
{
center.Index1 = double.Parse(rows[0]["BidPrice1"].ToString());
center.Volume1 = double.Parse(rows[0]["BidVol1"].ToString());
center.Value1 = double.Parse(rows[0]["BidPrice2"].ToString());
center.Index2 = double.Parse(rows[0]["BidVol2"].ToString());
center.Volume2 = double.Parse(rows[0]["BidPrice3"].ToString());
center.Value2 = double.Parse(rows[0]["BidVol3"].ToString());
center.Index3 = double.Parse(rows[0]["SellPrice1"].ToString());
center.Volume3 = double.Parse(rows[0]["SellVol1"].ToString());
center.Value3 = double.Parse(rows[0]["SellPrice2"].ToString());
}
if (!bRealtime) { center.ChartFolder = rows[0]["SecName"].ToString(); }
if (redis.ContainsKey(centerkey))
redis.Set(centerkey, center);
else
redis.Add(centerkey, center);
#endregion
}
catch (Exception ex)
{
log.WriteEntry("PriceData - " + centerId + ": " + ex.ToString(), EventLogEntryType.Error);
}
}