Example #1
0
        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));
            }
        }
Example #2
0
        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);
        }