Пример #1
0
        /// <summary>
        /// 结束告警
        /// </summary>
        public static void RemoveAlarm(AlarmEnd alarm)
        {
            if (alarm == null)
            {
                return;
            }

            if (AlarmIds != null && AlarmIds.Count > 0)
            {
                AlarmIds.Remove(alarm.Id);
            }

            if (Alarms != null && Alarms.Count > 0)
            {
                Alarms.Remove(CommonHelper.JoinKeys(alarm.DeviceId, alarm.PointId));
            }
        }
Пример #2
0
        /// <summary>
        /// 结束告警
        /// </summary>
        public void End(AlarmEnd entity)
        {
            SqlParameter[] parms = { new SqlParameter("@Id",               SqlDbType.VarChar,   100),
                                     new SqlParameter("@TId",              SqlDbType.BigInt),
                                     new SqlParameter("@AreaId",           SqlDbType.VarChar,   100),
                                     new SqlParameter("@StationId",        SqlDbType.VarChar,   100),
                                     new SqlParameter("@RoomId",           SqlDbType.VarChar,   100),
                                     new SqlParameter("@FsuId",            SqlDbType.VarChar,   100),
                                     new SqlParameter("@DeviceId",         SqlDbType.VarChar,   100),
                                     new SqlParameter("@PointId",          SqlDbType.VarChar,   100),
                                     new SqlParameter("@SerialNo",         SqlDbType.VarChar,   100),
                                     new SqlParameter("@NMAlarmId",        SqlDbType.VarChar,   100),
                                     new SqlParameter("@StartTime",        SqlDbType.DateTime),
                                     new SqlParameter("@EndTime",          SqlDbType.DateTime),
                                     new SqlParameter("@AlarmLevel",       SqlDbType.Int),
                                     new SqlParameter("@AlarmFlag",        SqlDbType.Int),
                                     new SqlParameter("@StartValue",       SqlDbType.Float),
                                     new SqlParameter("@EndValue",         SqlDbType.Float),
                                     new SqlParameter("@AlarmDesc",        SqlDbType.VarChar,   120),
                                     new SqlParameter("@AlarmRemark",      SqlDbType.VarChar,   100),
                                     new SqlParameter("@Confirmed",        SqlDbType.Int),
                                     new SqlParameter("@Confirmer",        SqlDbType.VarChar,   100),
                                     new SqlParameter("@ConfirmedTime",    SqlDbType.DateTime),
                                     new SqlParameter("@ReservationId",    SqlDbType.VarChar,   100),
                                     new SqlParameter("@ReservationName",  SqlDbType.VarChar,   200),
                                     new SqlParameter("@ReservationStart", SqlDbType.DateTime),
                                     new SqlParameter("@ReservationEnd",   SqlDbType.DateTime),
                                     new SqlParameter("@PrimaryId",        SqlDbType.VarChar,   100),
                                     new SqlParameter("@RelatedId",        SqlDbType.VarChar,   100),
                                     new SqlParameter("@FilterId",         SqlDbType.VarChar,   100),
                                     new SqlParameter("@ReversalId",       SqlDbType.VarChar,   100),
                                     new SqlParameter("@ReversalCount",    SqlDbType.Int),
                                     new SqlParameter("@Masked",           SqlDbType.Bit) };

            using (var conn = new SqlConnection(this._databaseConnectionString)) {
                conn.Open();
                var trans = conn.BeginTransaction(IsolationLevel.ReadCommitted);
                try {
                    parms[0].Value  = SqlTypeConverter.DBNullStringChecker(entity.Id);
                    parms[1].Value  = SqlTypeConverter.DBNullInt64Checker(entity.TId);
                    parms[2].Value  = SqlTypeConverter.DBNullStringChecker(entity.AreaId);
                    parms[3].Value  = SqlTypeConverter.DBNullStringChecker(entity.StationId);
                    parms[4].Value  = SqlTypeConverter.DBNullStringChecker(entity.RoomId);
                    parms[5].Value  = SqlTypeConverter.DBNullStringChecker(entity.FsuId);
                    parms[6].Value  = SqlTypeConverter.DBNullStringChecker(entity.DeviceId);
                    parms[7].Value  = SqlTypeConverter.DBNullStringChecker(entity.PointId);
                    parms[8].Value  = SqlTypeConverter.DBNullStringChecker(entity.SerialNo);
                    parms[9].Value  = SqlTypeConverter.DBNullStringChecker(entity.NMAlarmId);
                    parms[10].Value = SqlTypeConverter.DBNullDateTimeChecker(entity.StartTime);
                    parms[11].Value = SqlTypeConverter.DBNullDateTimeChecker(entity.EndTime);
                    parms[12].Value = (int)entity.AlarmLevel;
                    parms[13].Value = (int)entity.AlarmFlag;
                    parms[14].Value = SqlTypeConverter.DBNullDoubleChecker(entity.StartValue);
                    parms[15].Value = SqlTypeConverter.DBNullDoubleChecker(entity.EndValue);
                    parms[16].Value = SqlTypeConverter.DBNullStringChecker(entity.AlarmDesc);
                    parms[17].Value = SqlTypeConverter.DBNullStringChecker(entity.AlarmRemark);
                    parms[18].Value = (int)entity.Confirmed;
                    parms[19].Value = SqlTypeConverter.DBNullStringChecker(entity.Confirmer);
                    parms[20].Value = SqlTypeConverter.DBNullDateTimeNullableChecker(entity.ConfirmedTime);
                    parms[21].Value = SqlTypeConverter.DBNullStringChecker(entity.ReservationId);
                    parms[22].Value = SqlTypeConverter.DBNullStringChecker(entity.ReservationName);
                    parms[23].Value = SqlTypeConverter.DBNullDateTimeNullableChecker(entity.ReservationStart);
                    parms[24].Value = SqlTypeConverter.DBNullDateTimeNullableChecker(entity.ReservationEnd);
                    parms[25].Value = SqlTypeConverter.DBNullStringChecker(entity.PrimaryId);
                    parms[26].Value = SqlTypeConverter.DBNullStringChecker(entity.RelatedId);
                    parms[27].Value = SqlTypeConverter.DBNullStringChecker(entity.FilterId);
                    parms[28].Value = SqlTypeConverter.DBNullStringChecker(entity.ReversalId);
                    parms[29].Value = SqlTypeConverter.DBNullInt32Checker(entity.ReversalCount);
                    parms[30].Value = entity.Masked;
                    SqlHelper.ExecuteNonQuery(trans, CommandType.Text, string.Format(SqlCommands_Cs.Sql_Alarm_Repository_End, entity.StartTime.ToString("yyyyMM")), parms);
                    trans.Commit();
                } catch {
                    trans.Rollback();
                    throw;
                }
            }
        }