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; }
/// <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; }
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; }
/// <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; }