public int UpdateInstantTask(DACTaskResult result) { // always UpdateInstantTask Log.DebugFormat("Updating task result for {0} - {1}", result.Task.DtuID, result.Task.ID); string sql = string.Format( @"update T_TASK_INSTANT set STATUS={0}, FINISHED='{1}', ELAPSED={2}, RESULT_CODE={3}, RESULT_MSG='{4}', RESULT_JSON='{5}' where ID={6}", (int)result.Task.Status, //0 string.Format("{0:yyyy-M-d HH:mm:ss}", result.Finished), //1 result.Elapsed, string.IsNullOrEmpty(result.GetJsonResult()) ? (int)Errors.ERR_UNKNOW : result.ErrorCode, //3 string.IsNullOrEmpty(result.ErrorMsg) || string.IsNullOrEmpty(result.GetJsonResult()) ? "FAILED" : result.ErrorMsg, //4 result.GetJsonResult(), // JsonConvert.SerializeObject(result.SensorResults) 5 result.Task.ID //2 ); // Console.WriteLine(sql); int rows = this._helper.ExecuteSql(sql); Console.WriteLine("{0} rows updated", rows); return(rows); }