private AlarmLevelSetOR SetValue()
        {
            AlarmLevelSetOR m_Alar = new AlarmLevelSetOR();
            if (Request.QueryString["id"] != null)
                m_Alar.Id = int.Parse(Request.QueryString["id"]);
            m_Alar.Priority = int.Parse(dpdPriority.Text);//级别
            m_Alar.Levelname = txtLevelname.Text;//待级名称
            m_Alar.Upinterval = int.Parse(txtUpinterval.Text);//自动升级间隔时间

            return m_Alar;
        }
Example #2
0
        /// <summary>
        /// 插入t_AlarmLevelSet
        /// </summary>
        public virtual bool Insert(AlarmLevelSetOR alarmLevelSet)
        {
            string sql = "insert into t_AlarmLevelSet ( Priority, LevelName, UpInterval) values ( @Priority, @LevelName, @UpInterval)";
            SqlParameter[] parameters = new SqlParameter[]
            {

                new SqlParameter("@Priority", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Priority", DataRowVersion.Default, alarmLevelSet.Priority),
                new SqlParameter("@LevelName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "LevelName", DataRowVersion.Default, alarmLevelSet.Levelname),
                new SqlParameter("@UpInterval", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "UpInterval", DataRowVersion.Default, alarmLevelSet.Upinterval)
            };
            return db.ExecuteNoQuery(sql, parameters) > -1;
        }
Example #3
0
 public AlarmLevelSetOR selectARowDate(string m_id)
 {
     string sql = string.Format("select * from t_AlarmLevelSet where  Id='{0}'", m_id);
     DataTable dt = null;
     try
     {
         dt = db.ExecuteQueryDataSet(sql).Tables[0];
     }
     catch (Exception ex)
     {
         throw ex;
     }
     if (dt == null)
         return null;
     if (dt.Rows.Count == 0)
         return null;
     DataRow dr = dt.Rows[0];
     AlarmLevelSetOR m_Alar = new AlarmLevelSetOR(dr);
     return m_Alar;
 }
Example #4
0
 /// <summary>
 /// 更新t_AlarmLevelSet
 /// </summary>
 public virtual bool Update(AlarmLevelSetOR alarmLevelSet)
 {
     string sql = "update t_AlarmLevelSet set  Priority = @Priority,  LevelName = @LevelName,  UpInterval = @UpInterval where  ID = @ID";
     SqlParameter[] parameters = new SqlParameter[]
     {
         new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ID", DataRowVersion.Default, alarmLevelSet.Id),
         new SqlParameter("@Priority", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Priority", DataRowVersion.Default, alarmLevelSet.Priority),
         new SqlParameter("@LevelName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "LevelName", DataRowVersion.Default, alarmLevelSet.Levelname),
         new SqlParameter("@UpInterval", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "UpInterval", DataRowVersion.Default, alarmLevelSet.Upinterval)
     };
     return db.ExecuteNoQuery(sql, parameters) > -1;
 }