void ExecuteSql(string sql) { var ds = new DBServer(); ds.ExecNonQuery(sql); ds.Dispose(); ds = null; }
public void UpdatePartialOrder(Order o) { Task.Factory.StartNew(() => { string f = "update TempOrders set Count ={0},DoneCount ={1},TotalDoneCount ={2},DonePrice ={3},TotalDoneSum={4},State ={5},price={6} where Id ={7}"; string sql = string.Format(f, o.Count, o.DoneCount, o.TotalDoneCount, o.DonePrice, o.TotalDoneSum, (int)o.State, o.Price, o.Id); using (DBServer db = new DBServer()) { db.ExecNonQuery(sql); } }); }