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