Esempio n. 1
0
        public string GetInsertMeasureDetailSql(int deviceId, int measureId, DateTime samplesTime, string actualValue, int actualMaxValue, int actualMinValue, int actualDelegate, int result)
        {
            Dictionary <string, object> insertData = new Dictionary <string, object>();

            insertData.Add("measure_id", measureId);
            insertData.Add("samples_time", samplesTime.ToString(cstrDateTimeFormatNoMiliSecond));
            insertData.Add("device_id", deviceId);
            insertData.Add("actual_value", actualValue);
            insertData.Add("actual_max_value", actualMaxValue);
            insertData.Add("actual_min_value", actualMinValue);
            insertData.Add("actual_delegate", actualDelegate);
            insertData.Add("result", result);

            return(_db.CreateInsertSql("tbl_measure_detail", insertData));
        }