public int InsertMeasureDetail(MeasureDetail detail) { var sql = string.Empty; sql += string.Format(" INSERT INTO Measure_Detail (MeasureId, Actual_Value, Samples_time, Detail_Result) VALUES ({0}, {1}, '{2}', {3}); ", detail.MeasureId, detail.Actual_Value, detail.Samples_time?.ToString("yyyy-MM-dd HH:mm:ss.fff"), detail.Detail_Result); lock (_syncDB) { return(_dbConnection.Execute(sql)); } }
public bool InsertDetailMeasure(MeasureDetail measure_detail) { var intRst = _dbConnection.Execute("INSERT INTO Measure_Detail(MeasureId,Actual_Value, Samples_time, Detail_Result) VALUES (@MeasureId, @Actual_Value, @Samples_time, @Detail_Result) ", new MeasureDetail { //DetailId = measure_detail.DetailId, MeasureId = measure_detail.MeasureId, Actual_Value = measure_detail.Actual_Value, Samples_time = measure_detail.Samples_time, Detail_Result = measure_detail.Detail_Result, }); return(intRst > 0); }