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