void Execute() { if (al.Count == 0) { return; } List <Account> tl; lock (loc) { tl = al.ToList(); al.Clear(); } if (tl == null || tl.Count == 0) { return; } StringBuilder sb = new StringBuilder(); foreach (var v in tl) { sb.AppendFormat(f, v.Sum, v.Frozen, v.Id); } using (DBServer db = new DBServer()) { db.ExecNonQuery(sb.ToString()); } }
/// <summary> /// 更新委托状态为已行权 /// </summary> /// <param name="orderIds"></param> public void UpdateOrderStateToExecuted(List <int> orderIds) { if (orderIds == null || orderIds.Count == 0) { return; } Task.Factory.StartNew(() => { try { string f = "update Orders set State =5,price =0 where Id in ({0}) "; StringBuilder sb = new StringBuilder(); foreach (var v in orderIds) { sb.AppendFormat("{0},", v); } sb.Remove(sb.Length - 1, 1); string s = string.Format(f, sb.ToString()); using (DBServer db = new DBServer()) { db.ExecNonQuery(s); } } catch (Exception e) { Singleton <TextLog> .Instance.Error(e, "update order state for execute"); } }); }
void ExecuteSql2(string sql) { var ds = new DBServer(); ds.ExecNonQuery(sql); ds.Dispose(); ds = null; }
public void UpdatePartial(SpotOrder so) { Task.Factory.StartNew(() => { string sql = string.Format(f, so.Count, so.DoneCount, so.TotalDoneCount, so.DonePrice, so.TotalDoneSum, (int)so.State, so.Price, so.Id); using (DBServer db = new DBServer()) { db.ExecNonQuery(sql); } }); }
public void Flush(Action <StringBuilder, int> a) { var nk = GetNewGenaration(); StringBuilder sb = new StringBuilder(); a(sb, nk); if (sb.Length > 0) { using (DBServer db = new DBServer()) { db.ExecNonQuery(sb.ToString()); } } }
protected void RestoreDb() { string sql = @"use master declare @dbname sysname set @dbname='Option-test' --这个是要删除的数据库库名 declare @s nvarchar(1000) declare tb cursor local for select s='kill '+cast(spid as varchar) from master..sysprocesses where dbid=db_id(@dbname) open tb fetch next from tb into @s while @@fetch_status=0 begin exec(@s) fetch next from tb into @s end close tb deallocate tb exec('drop database ['+@dbname+']')"; var ds = new DBServer(@"Data Source=.\sqlexpress;Initial Catalog=master;Integrated Security=True"); ds.ExecNonQuery(sql); ds.Dispose(); ds = null; //Database.SetInitializer<OptionDbCtx>(new DropCreateDatabaseAlways<OptionDbCtx>()); var context = new OptionDbCtx(); context.Database.Initialize(true); //if (!context.Database.Exists()) //{ // context.Database.Create(); //} //var initor = new TraderInitor(); //initor.Init(context); //var ci = new ContractInitor(); //ci.Init(context); }
void RestoreDb() { string sql = @" USE [master] /****** Object: Database [Option-test] Script Date: 11/26/2014 11:17:06 ******/ DROP DATABASE [Option-test]"; var ds = new DBServer(@"Data Source=.\sqlexpress;Initial Catalog=master;Integrated Security=True"); ds.ExecNonQuery(sql); ds.Dispose(); ds = null; var context = new OptionDbCtx(); var initor = new TraderInitor(); initor.Init(context); //var ci = new ContractInitor(); //ci.Init(context); }