protected override void saveParam()
{
int err = -1;
string query = string.Empty;
if (err == 0)
{
for (PARAMETR_SETUP i = PARAMETR_SETUP.POLL_TIME; i < PARAMETR_SETUP.COUNT_PARAMETR_SETUP; i++)
{
query += DbTSQLConfigDatabase.DbConfig().GetSetupParameterQuery(NAME_PARAMETR_SETUP[(int)i], m_arParametrSetup[(int)i], DbTSQLInterface.QUERY_TYPE.UPDATE) + @";";
}
}
else
{
;
}
if (query.Equals(string.Empty) == false)
{
DbTSQLConfigDatabase.DataSource().ExecNonQuery(query, out err);
}
else
{
;
}
}
public override void SaveParamKey(string key, string value)
{
int err = -1;
string query = string.Empty;
query += DbTSQLConfigDatabase.DbConfig().GetSetupParameterQuery(key, value, DbTSQLInterface.QUERY_TYPE.UPDATE) + @";";
if (query.Equals(string.Empty) == false)
{
DbTSQLConfigDatabase.DataSource().ExecNonQuery(query, out err);
}
else
{
;
}
}
protected override void saveParam()
{
int err = -1;
string queryInsert = string.Empty;
List <TECComponentBase> listTG;
listTG = m_tec.GetListLowPointDev(TECComponentBase.TYPE.ELECTRO);
for (int j = 0; j < COUNT_TG; j++)
{
if (findElement(indexes_TG_Off, j) == false)
{
queryInsert += DbTSQLConfigDatabase.GetParameterBiyskTGInsertQuery(m_tec.m_id
, $"'{SENSORS_NAME_PREFIX}{(j + 1).ToString ()}{SENSORS_NAME_POSTFIX}',"
, m_tec.GetListLowPointDev(TECComponentBase.TYPE.ELECTRO).Find(x => x.name_shr == SENSORS_NAME_PREFIX + (j + 1).ToString()).m_id
, int.Parse(m_array_tbxTG [(int)HDateTime.INTERVAL.MINUTES, j].Text.Trim())
, int.Parse(m_array_tbxTG [(int)HDateTime.INTERVAL.HOURS, j].Text.Trim())
, m_tg_aiskue_key_default [j].IdObject
, m_tg_aiskue_key_default [j].IdItem);
}
}
DbTSQLConfigDatabase.DataSource().ExecNonQuery(queryInsert, out err);
}
private void loadParam(bool bInit, out int err)
{
err = -1;
string query = string.Empty;
DataTable table = DbTSQLConfigDatabase.DbConfig().GetDataTableSetupParameters(out err);
DataRow[] rowRes;
if (err == (int)DbTSQLInterface.Error.NO_ERROR)
{
if (!(table == null))
{
query = string.Empty;
foreach (PARAMETR_SETUP indx in Enum.GetValues(typeof(PARAMETR_SETUP)))
{
if ((indx == PARAMETR_SETUP.UNKNOWN) ||
(indx == PARAMETR_SETUP.COUNT_PARAMETR_SETUP))
{
continue;
}
else
{
;
}
rowRes = table.Select(@"KEY='" + NAME_PARAMETR_SETUP [(int)indx].ToString() + @"'");
switch (rowRes.Length)
{
case 1:
m_arParametrSetup [(int)indx] =
m_arParametrSetupDefault [(int)indx] =
rowRes [0] [@"VALUE"].ToString().Trim();
break;
case 0:
m_arParametrSetup [(int)indx] = m_arParametrSetupDefault [(int)indx];
query += DbTSQLConfigDatabase.DbConfig().GetSetupParameterQuery(NAME_PARAMETR_SETUP [(int)indx], m_arParametrSetup [(int)indx], DbTSQLInterface.QUERY_TYPE.INSERT) + @";";
break;
default:
break;
}
}
// проверить различия между параметрами в коде и таблице [setup] в БД конфигурации
if (query.Equals(string.Empty) == false)
{
// дополнить таблицу в БД конфигурации отсутствующими параметрами и их значениями по умолчанию
DbTSQLConfigDatabase.DataSource().ExecNonQuery(query, out err);
}
else
{
;
}
}
else
{
err = (int)DbTSQLInterface.Error.TABLE_NULL;
}
}
else
{
;
}
setDataGUI(bInit);
}
