/// <summary>
/// 更新24小时市场价,废弃
/// </summary>
/// <param name="platformId"></param>
/// <param name="coinId"></param>
/// <param name="exchangeId"></param>
/// <param name="exName"></param>
/// <param name="platformCode"></param>
/// <param name="coinCode"></param>
public void TaskExecution(int platformId, int coinId, int exchangeId, string exName, string platformCode, string coinCode)
{
Log.Info("执行TaskExecution：" + platformCode + "_" + coinCode + "_" + exName);
try
{
ExchangeType eType = (ExchangeType)Enum.Parse(typeof(ExchangeType), platformCode);
ExChangeBase eb = ExchangeFactory.InstanExchange(eType);
BasePriceModel priceModel = eb.GetNowPrice(coinCode, exName);
if (priceModel == null)
{
return;
}
//得到1970年的时间戳
DateTime timeStamp = new DateTime(1970, 1, 1);
//注意这里有时区问题，用now就要减掉8个小时
string timestamps = Convert.ToString((DateTime.UtcNow.Ticks - timeStamp.Ticks) / 10000);
InsertQuotes(platformId, coinId, exchangeId, platformCode, coinCode, timestamps, priceModel);
GC.Collect();
}
catch (Exception ex)
{
Log.Error("执行查询插入数据出错" + ex);
}
}
public ActionResult Index()
{
var itemsKOT = (from p in dbKOT.PriceListEntries
join a in dbKOT.AccountMs on p.AccountM_UID equals a.UID
join i in dbKOT.AccountMItems on p.AccountMItems_UID equals i.AccountM_UID
select new {
i.ItemCode,
i.ItemName,
p.Price,
a.Description
}
).ToList();
var itemsCount = (from p in db.tblBasePriceItems select p).ToList().Count;
if (itemsKOT.Count > itemsCount)
{
foreach (var item in itemsKOT)
{
var items = (from p in db.tblItems where p.Name == item.ItemName && p.ItemCode == item.ItemCode select p).FirstOrDefault();
var itemcheck = (from p in db.tblBasePriceItems where p.ItemId == items.ItemId && p.CategoryId == items.CategoryId && p.Type == item.Description select p).SingleOrDefault();
if (itemcheck == null)
{
tblBasePriceItem tb = new tblBasePriceItem();
tb.CategoryId = items.CategoryId;
tb.ItemId = items.ItemId;
tb.FullPrice = item.Price;
tb.Type = item.Description;
if (item.Description == "Ac Hall")
{
tb.Vat = 18;
}
else
{
tb.Vat = 12;
}
db.tblBasePriceItems.Add(tb);
db.SaveChanges();
}
}
}
var BaseData = (from p in db.tblBasePriceItems select p).ToList();
List <BasePriceModel> list = new List <BasePriceModel>();
foreach (var item in BaseData)
{
BasePriceModel model = new BasePriceModel();
model.CategoryIds = item.CategoryId;
model.ItemId = item.ItemId;
model.FullPrice = item.FullPrice;
//model.HalfPrice = item.HalfPrice;
model.BasePriceId = item.BasePriceId;
model.Vat = item.Vat;
list.Add(model);
}
return(View(list));
}
public override BasePriceModel GetNowPrice(string coin, string currency)
{
BasePriceModel basePrice = new BasePriceModel();
string Symbol = ConvertSymbolTool.GateConvertSymbol(coin, currency);
var result = gateAPI.SendRequestContent <TicketRequest>(ApiUrlList.API_Ticker, Symbol);
if (result == null)
{
Log.Error("GATE数据为空" + coin);
return(basePrice);
}
basePrice.buyPrice = result.highestBid;
basePrice.sellPice = result.lowestAsk;
basePrice.price = result.last;
return(basePrice);
}
public override BasePriceModel GetNowPrice(string coin, string currency)
{
BasePriceModel basePrice = new BasePriceModel();
string Symbol = ConvertSymbolTool.OKConvertSymbol(coin, currency);
var result = OkAPi.SendRequestContent <TicketRequset>(ApiUrlList.API_Ticker, Symbol);
if (result == null)
{
Log.Error("okex数据为空" + coin);
return(basePrice);
}
basePrice.buyPrice = result.ticker.buy;
basePrice.sellPice = result.ticker.sell;
basePrice.price = result.ticker.last;
return(basePrice);
}
public override BasePriceModel GetNowPrice(string coin, string currency)
{
BasePriceModel basePrice = new BasePriceModel();
string Symbol = ConvertSymbolTool.BiAnConvertSymbol(coin, currency);
var result = api.SendRequestContent <TicketRequest>(ApiUrlList.API_Ticker, Symbol);
if (result == null)
{
Log.Error("币安数据为空" + coin);
return(basePrice);
}
basePrice.buyPrice = result.bidPrice;
basePrice.sellPice = result.askPrice;
basePrice.price = result.lastPrice;
return(basePrice);
}
public override BasePriceModel GetNowPrice(string coin, string currency)
{
BasePriceModel basePrice = new BasePriceModel();
string Symbol = ConvertSymbolTool.HBConvertSymbol(coin, currency);
var result = api.SendRequestContent <TicketRequest>(ApiUrlList.API_Ticker, Symbol);
if (result.status != "ok")
{
return(basePrice);
}
if (result.tick == null)
{
Log.Error("HUOBI数据为空" + coin);
return(basePrice);
}
basePrice.buyPrice = result.tick.bid[0];
basePrice.sellPice = result.tick.ask[0];
basePrice.price = result.tick.close;
return(basePrice);
}
private void InsertQuotes(int platformId, int coinId, int exchangeId, string platformCode, string coinCode, string timestamps, BasePriceModel priceModel)
{
Tmp_Quotes quotes = new Tmp_Quotes();
quotes.CoinName = coinCode;
quotes.Market = platformCode + "_" + coinCode;
quotes.Price = priceModel.price;
quotes.Buyprice = priceModel.buyPrice;
quotes.Sellprice = priceModel.sellPice;
quotes.PlatformId = platformId;
quotes.CoinId = coinId;
quotes.Timestamps = timestamps;
quotes.Currencytype = (int)CurrencyType.USDT;
quotes.CreateTime = DateTime.Now;
if (!quotes.Insert())
{
Log.Error("新增数据失败" + quotes.Market);
}
}
