private void SQLAccuDataDump()
{
int nVar = ReadNSqlTypes();
string queryF;
string query = "INSERT INTO " + SchemaName + "." + TableACCU + " (";
string queryTrunc = "TRUNCATE " + SchemaName + "." + TableACCU;
//Truncate table
insertinsql(queryTrunc);
//ManageTime
string date = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
string queryT = "'" + date + "'";
var SQLList = GetPLCSymbolsAccuSQL();
//Get columns Names
string NameCol = string.Join(" , ", SQLList.ToArray());
string NameColClean = "RecordTime ," + cleaner(NameCol);
string queryN = NameColClean + ") VALUES ( ";
query += queryN + queryT;
foreach (string TagSQL in SQLList)
{
string value = adsClient.ReadAny(adsClient.CreateVariableHandle(TagSQL.ToString()), typeof(int)).ToString();
query += (", '" + value.ToString() + "' ");
}
queryF = query + ");";
insertinsql(queryF);
}
private void SQLLiveDataDump()
{
int nVar = ReadNSqlTypes();
string queryF;
string query = "INSERT INTO " + SchemaName + "." + TableRT + " (";
//ManageTime
string date = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
string queryT = "'" + date + "'";
var SQLList = GetPLCSymbolsLiveSQL();
//Get columns Names
string NameCol = string.Join(" , ", SQLList.ToArray());
string NameColClean = "RecordTime ," + cleaner(NameCol);
string queryN = NameColClean + ") VALUES ( ";
query += queryN + queryT;
foreach (string TagSQL in SQLList)
{
string value = adsClient.ReadAny(adsClient.CreateVariableHandle(TagSQL.ToString()), typeof(int)).ToString();
query += (", '" + value.ToString() + "' ");
}
queryF = query + ");";
insertinsql(queryF);
//listBoxDBLog.Items.Add("Row inserted with data from" +date);
}
