private void RefreshDefinition() { filterManager = null; filterManager = new DgvFilterManager(); alarm_definition = m_ds.GetAlarmDefinition(); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dataGridView1.DataSource = new DataTable(); dataGridView1.DataSource = alarm_definition; dataGridView1.Columns["id"].ReadOnly = true;//.Visible = false; DataGridViewComboBoxColumn c = new DataGridViewComboBoxColumn(); c.DataSource = alarm_definition; c.Name = alarm_definition.listColumn.ColumnName; c.ValueMember = "list"; c.DisplayMember = "list"; c.DataSource = m_ds.GetList(); c.DataPropertyName = "list"; dataGridView1.Columns["list"].Visible = false; dataGridView1.Columns.Insert(1, c); filterManager.DataGridView = dataGridView1; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; }
private void RefreshDefinition() { alarm_definition = m_ds.GetAlarmDefinition(); dataGridView1.DataSource = alarm_definition; dataGridView1.Columns["id"].Visible = false; }
public alarm_definitionDataTable GetAlarmDefinition() { var alarm_definition = new AlarmDataSet.alarm_definitionDataTable(); var sql = "select * from alarm_definition "; m_server.FillTable(alarm_definition, sql); alarm_definition.idColumn.AutoIncrementSeed = m_server.NextID("alarm_definition", "id"); return alarm_definition; }
public alarm_definitionDataTable GetAlarmDefinition() { var alarm_definition = new AlarmDataSet.alarm_definitionDataTable(); var sql = "select * from alarm_definition "; m_server.FillTable(alarm_definition, sql); alarm_definition.idColumn.AutoIncrementSeed = m_server.NextID("alarm_definition", "id"); return(alarm_definition); }
public alarm_definitionDataTable GetAlarmDefinition(string siteid, string parameter) { var alarm_definition = new AlarmDataSet.alarm_definitionDataTable(); siteid = PostgreSQL.SafeSqlLikeClauseLiteral(siteid); parameter = SqlServer.SafeSqlLikeClauseLiteral(parameter); var sql = "select * from alarm_definition where siteid='" + siteid + "'" + " and parameter ='" + parameter + "'"; m_server.FillTable(alarm_definition, sql); alarm_definition.idColumn.AutoIncrementSeed = m_server.NextID("alarm_definition", "id"); return alarm_definition; }
public alarm_definitionDataTable GetAlarmDefinition(string siteid, string parameter) { var alarm_definition = new AlarmDataSet.alarm_definitionDataTable(); siteid = PostgreSQL.SafeSqlLikeClauseLiteral(siteid); parameter = SqlServer.SafeSqlLikeClauseLiteral(parameter); var sql = "select * from alarm_definition where siteid='" + siteid + "'" + " and parameter ='" + parameter + "'"; m_server.FillTable(alarm_definition, sql); alarm_definition.idColumn.AutoIncrementSeed = m_server.NextID("alarm_definition", "id"); return(alarm_definition); }
/// <summary> /// Returns a Table of enabled alarm definitions /// </summary> /// <returns></returns> private AlarmDataSet.alarm_definitionDataTable GetActiveAlarmDefinition(string siteid, string parameter) { var alarm_definition = new AlarmDataSet.alarm_definitionDataTable(); siteid = BasicDBServer.SafeSqlLikeClauseLiteral(siteid); parameter = BasicDBServer.SafeSqlLikeClauseLiteral(parameter); var sql = "select * from alarm_definition where siteid='" + siteid + "' and parameter ='" + parameter + "'" + " and enabled = " + m_server.PortableWhereBool(true); Logger.WriteLine(sql); m_server.FillTable(alarm_definition, sql); return(alarm_definition); }