protected override void saveParam()
{
int err = -1;
int idListener = DbSources.Sources().Register(m_connSett, false, @"CONFIG_DB");
string query = string.Empty;
m_dbConn = DbSources.Sources().GetConnection(idListener, out err);
if (err == 0)
{
for (PARAMETR_SETUP i = PARAMETR_SETUP.POLL_TIME; i < PARAMETR_SETUP.COUNT_PARAMETR_SETUP; i++)
{
query += getWriteStringRequest(NAME_PARAMETR_SETUP[(int)i], m_arParametrSetup[(int)i], false) + @";";
}
}
else
{
;
}
if (query.Equals(string.Empty) == false)
{
DbTSQLInterface.ExecNonQuery(ref m_dbConn, query, null, null, out err);
}
else
{
;
}
DbSources.Sources().UnRegister(idListener);
}
protected override void saveParam()
{
for (PARAMETR_SETUP i = PARAMETR_SETUP.POLL_TIME; i < PARAMETR_SETUP.COUNT_PARAMETR_SETUP; i++)
{
m_FileINI.WriteString(NAME_SECTION_MAIN, NAME_PARAMETR_SETUP[(int)i], m_arParametrSetup[(int)i]);
}
}
protected override void loadParam(bool bInit)
{
int err = -1;
string query = string.Empty;
//query = @"SELECT * FROM [dbo].[setup] WHERE [KEY]='" + key + @"'";
query = string.Format(@"SELECT * FROM setup");
DataTable table = DbTSQLInterface.Select(ref m_dbConn, query, null, null, out err);
DataRow[] rowRes;
if (err == (int)DbTSQLInterface.Error.NO_ERROR)
{
if (!(table == null))
{
query = string.Empty;
for (PARAMETR_SETUP i = PARAMETR_SETUP.POLL_TIME; i < PARAMETR_SETUP.COUNT_PARAMETR_SETUP; i++)
{
//strRead = readString(NAME_PARAMETR_SETUP[(int)i], strDefault, out err);
rowRes = table.Select(@"KEY='" + NAME_PARAMETR_SETUP[(int)i].ToString() + @"'");
switch (rowRes.Length)
{
case 1:
m_arParametrSetup[(int)i] =
m_arParametrSetupDefault[(int)i] =
rowRes[0][@"VALUE"].ToString().Trim();
break;
case 0:
m_arParametrSetup[(int)i] = m_arParametrSetupDefault[(int)i];
query += getWriteStringRequest(NAME_PARAMETR_SETUP[(int)i], m_arParametrSetup[(int)i], true) + @";";
break;
default:
break;
}
}
if (query.Equals(string.Empty) == false)
{
DbTSQLInterface.ExecNonQuery(ref m_dbConn, query, null, null, out err);
}
else
{
;
}
}
else
{
err = (int)DbTSQLInterface.Error.TABLE_NULL;
}
}
else
{
;
}
setDataGUI(bInit);
}
private void btnReset_Click(object sender, EventArgs e)
{
for (PARAMETR_SETUP i = PARAMETR_SETUP.POLL_TIME; i < PARAMETR_SETUP.COUNT_PARAMETR_SETUP; i++)
{
m_arParametrSetup[(int)i] = m_arParametrSetupDefault[(int)i];
}
}
protected override void loadParam(bool bInit)
{
string strDefault = string.Empty;
for (PARAMETR_SETUP i = PARAMETR_SETUP.POLL_TIME; i < PARAMETR_SETUP.COUNT_PARAMETR_SETUP; i++)
{
m_arParametrSetup[(int)i] = m_FileINI.ReadString(NAME_SECTION_MAIN, NAME_PARAMETR_SETUP[(int)i], strDefault);
if (m_arParametrSetup[(int)i].Equals(strDefault) == true)
{
m_arParametrSetup[(int)i] = m_arParametrSetupDefault[(int)i];
m_FileINI.WriteString(NAME_SECTION_MAIN, NAME_PARAMETR_SETUP[(int)i], m_arParametrSetup[(int)i]);
}
else
{
;
}
}
for (PARAMETR_SETUP i = PARAMETR_SETUP.POLL_TIME; i < PARAMETR_SETUP.COUNT_PARAMETR_SETUP; i++)
{
m_dgvData.Rows.Insert((int)i, new object[] { NAME_PARAMETR_SETUP[(int)i], m_arParametrSetup[(int)i], NAMESI_PARAMETR_SETUP[(int)i] });
m_dgvData.Rows[(int)i].Height = 19;
m_dgvData.Rows[(int)i].Resizable = System.Windows.Forms.DataGridViewTriState.False;
m_dgvData.Rows[(int)i].HeaderCell.Value = ((int)i).ToString();
}
}
public int GetTECIdLinkSourceTM(int id)
{
int iRes = -1;
PARAMETR_SETUP param = PARAMETR_SETUP.UNKNOWN;
//switch (id)
//{
// case 1:
// param = PARAMETR_SETUP.ID_SOURCE_SOTIASSO_BTEC;
// break;
// case 2:
// param = PARAMETR_SETUP.ID_SOURCE_SOTIASSO_TEC2;
// break;
// case 3:
// param = PARAMETR_SETUP.ID_SOURCE_SOTIASSO_TEC3;
// break;
// case 4:
// param = PARAMETR_SETUP.ID_SOURCE_SOTIASSO_TEC4;
// break;
// case 5:
// param = PARAMETR_SETUP.ID_SOURCE_SOTIASSO_TEC5;
// break;
// case 6:
// param = PARAMETR_SETUP.ID_SOURCE_SOTIASSO_BiTEC;
// break;
// default:
// break;
//}
//iRes = Convert.ToInt32(m_arParametrSetup[(int)param]);
return(iRes);
}
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
{
;
}
}
protected override void saveParam()
{
for (PARAMETR_SETUP i = PARAMETR_SETUP.POLL_TIME; i < PARAMETR_SETUP.COUNT_PARAMETR_SETUP; i++)
{
m_FileINI.WriteString(NAME_SECTION_MAIN, m_dictParametrSetup [i].Key, m_dictParametrSetup [i].Value);
}
}
protected override void loadParam(bool bInit)
{
string value = string.Empty
, defValue = string.Empty;
for (PARAMETR_SETUP i = PARAMETR_SETUP.POLL_TIME; i < PARAMETR_SETUP.COUNT_PARAMETR_SETUP; i++)
{
value = m_FileINI.ReadString(NAME_SECTION_MAIN, m_dictParametrSetup [i].Key, defValue);
if (value.Equals(defValue) == true)
{
m_dictParametrSetup[i].Reset();
m_FileINI.WriteString(NAME_SECTION_MAIN, m_dictParametrSetup [i].Key, m_dictParametrSetup [i].Value);
}
else
{
;
}
}
for (PARAMETR_SETUP i = PARAMETR_SETUP.POLL_TIME; i < PARAMETR_SETUP.COUNT_PARAMETR_SETUP; i++)
{
m_dgvData.Rows.Insert((int)i, m_dictParametrSetup[i].DataRow);
m_dgvData.Rows[(int)i].Height = 19;
m_dgvData.Rows[(int)i].Resizable = System.Windows.Forms.DataGridViewTriState.False;
m_dgvData.Rows[(int)i].HeaderCell.Value = ((int)i).ToString();
}
}
private void btnReset_Click(object sender, EventArgs e)
{
for (PARAMETR_SETUP i = PARAMETR_SETUP.POLL_TIME; i < PARAMETR_SETUP.COUNT_PARAMETR_SETUP; i++)
{
m_dictParametrSetup[i].Reset();
}
}
//protected override void btnOk_Click(object sender, EventArgs e)
protected void btnOk_Click(object sender, EventArgs e)
{
for (PARAMETR_SETUP i = PARAMETR_SETUP.POLL_TIME; i < PARAMETR_SETUP.COUNT_PARAMETR_SETUP; i++)
{
m_arParametrSetup[(int)i] = m_dgvData.Rows[(int)i + 0].Cells[1].Value.ToString();
}
saveParam();
mayClose = true;
Close();
}
public string GetWriteRequest(PARAMETR_SETUP key, bool bInsert)
{
string strRes = string.Empty;
if (bInsert == false)
{
strRes = string.Format(@"UPDATE setup SET [VALUE]='{0}', [LAST_UPDATE]=GETDATE() WHERE [KEY]='{1}'", this[key].Value, key);
}
else
{
strRes = string.Format(@"INSERT INTO [setup] ([ID],[VALUE],[KEY],[LAST_UPDATE],[ID_UNIT]) VALUES ('{0}','{1}',GETDATE(),{2})", this [key].Value, key, -1);
}
return(strRes);
}
protected void setDataGUI(bool bInit)
{
for (PARAMETR_SETUP i = PARAMETR_SETUP.POLL_TIME; i < PARAMETR_SETUP.COUNT_PARAMETR_SETUP; i++)
{
if (bInit == true)
{
m_dgvData.Rows.Insert((int)i, new object[] { NAME_PARAMETR_SETUP[(int)i], m_arParametrSetup[(int)i], NAMESI_PARAMETR_SETUP[(int)i] });
m_dgvData.Rows[(int)i].Height = 19;
m_dgvData.Rows[(int)i].Resizable = System.Windows.Forms.DataGridViewTriState.False;
m_dgvData.Rows[(int)i].HeaderCell.Value = ((int)i).ToString();
}
else
{
m_dgvData.Rows[(int)i].Cells[1].Value = m_arParametrSetup[(int)i];
}
}
}
protected override void loadParam(bool bInit)
{
string strDefault = string.Empty;
for (PARAMETR_SETUP i = PARAMETR_SETUP.POLL_TIME; i < PARAMETR_SETUP.COUNT_PARAMETR_SETUP; i++)
{
m_arParametrSetup[(int)i] = m_FileINI.ReadString(NAME_SECTION_MAIN, NAME_PARAMETR_SETUP[(int)i], strDefault);
if (m_arParametrSetup[(int)i].Equals(strDefault) == true)
{
m_arParametrSetup[(int)i] = m_arParametrSetupDefault[(int)i];
m_FileINI.WriteString(NAME_SECTION_MAIN, NAME_PARAMETR_SETUP[(int)i], m_arParametrSetup[(int)i]);
}
else
{
;
}
}
setDataGUI(bInit);
}
public string GetINIParametersOfID(PARAMETR_SETUP id)
{
return(GetINIParametersOfID((int)id));
}
protected override void loadParam(bool bInit)
{
int err = -1;
//DbTSQLInterface.ModeStaticConnectionLeave = DbTSQLInterface.ModeStaticConnectionLeaving.Yes;
_handlerDb.RegisterDbConnection(out err);
string query = string.Empty;
//query = @"SELECT * FROM [dbo].[setup] WHERE [KEY]='" + key + @"'";
query = string.Format(@"SELECT * FROM setup");
DataTable table =
//DbTSQLInterface.Select(m_connSett, query, out err)
_handlerDb.Select(query, out err)
;
DataRow[] rowRes;
if (err == (int)DbTSQLInterface.Error.NO_ERROR)
{
if (Equals(table, null) == false)
{
query = string.Empty;
if (table.Rows.Count > 0)
{
for (PARAMETR_SETUP i = PARAMETR_SETUP.POLL_TIME; i < PARAMETR_SETUP.COUNT_PARAMETR_SETUP; i++)
{
//strRead = readString(NAME_PARAMETR_SETUP[(int)i], strDefault, out err);
rowRes = table.Select($"KEY='{m_dictParametrSetup[i].Key}'");
switch (rowRes.Length)
{
case 1:
m_dictParametrSetup [i].Set(rowRes [0][@"VALUE"].ToString().Trim());
break;
case 0:
m_dictParametrSetup[i].Reset();
query += m_dictParametrSetup.GetWriteRequest(i, true) + @";";
break;
default:
break;
}
}
}
else
{
query = m_dictParametrSetup.GetWriteRequest(true);
}
if (query.Equals(string.Empty) == false)
{
_handlerDb.ExecNonQuery(query, out err);
}
else
{
;
}
}
else
{
err = (int)DbTSQLInterface.Error.TABLE_NULL;
}
}
else
{
;
}
//DbTSQLInterface.ModeStaticConnectionLeave = DbTSQLInterface.ModeStaticConnectionLeaving.No;
_handlerDb.UnRegisterDbConnection();
setDataGUI(bInit);
}
