public static void Record(string coin, HistoryKline line)
{
var dao = new KlineDao();
dao.CheckTable(coin);
dao.Record(coin, line);
}
public void Record(string name, HistoryKline line)
{
try
{
var sql = $"insert into t_coin_{name}(Id, Open, Close, Low, High, Vol, Count, CreateTime) values({line.Id},{line.Open},{line.Close},{line.Low},{line.High},{line.Vol},{line.Count}, now())";
Database.Execute(sql);
}
catch (Exception ex)
{
}
}
public void DeleteAndRecordKlines(string symbolName, HistoryKline line)
{
long id = line.Id;
using (var tx = Database.BeginTransaction())
{
var sql = $"delete from t_coin_{symbolName} where id={id}";
Database.Execute(sql);
sql = $"insert into t_coin_{symbolName}(Id, Open, Close, Low, High, Vol, Count, CreateTime) values({line.Id},{line.Open},{line.Close},{line.Low},{line.High},{line.Vol},{line.Count}, now())";
Database.Execute(sql);
tx.Commit();
}
}
