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