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