//Symbols SQL Live data
public int ReadNSqlTypes()
{
TcAdsSymbolInfoLoader symbolLoader;
symbolLoader = adsClient.CreateSymbolInfoLoader();
//parse now
int NTagsSQL = 0;
int Counter = 0;
int Match = 0;
foreach (TcAdsSymbolInfo symbol in symbolLoader)
{
//TODO OPTIONAL: Implement a configurable filter here
if (symbol.Type.Contains("SQL_SND") && symbol.Name.Contains("Val"))
{
PLCvar plcVar = new PLCvar(symbol.Name, symbol.Type);
// listBoxDBLog.Items.Add(symbol.Name); //Debug
Match++;
System.Threading.Thread.Sleep(1);
}
if (Counter > 1 | symbol.Name != null)
{
NTagsSQL = Match;
}
Counter++;
}
//(sender as BackgroundWorker).ReportProgress(100, null);
//listBoxDBLog.Items.Add(NTagsSQL);
return(NTagsSQL);
}
public List <string> ReadSQLTypes()
{
var listSQLTags = new List <string>();
TcAdsSymbolInfoLoader symbolLoader;
symbolLoader = adsClient.CreateSymbolInfoLoader();
foreach (TcAdsSymbolInfo symbol in symbolLoader)
{
if (symbol.Type.Contains("ST_SQL"))
{
PLCvar plcVar = new PLCvar(symbol.Name, symbol.Type);
listSQLTags.Add(symbol.Name);
System.Threading.Thread.Sleep(1);
}
}
return(new List <string>());
}
//Ads Types
public void GetPLCvarInfo(PLCvar pv)
{
ITcAdsSymbol symbol = adsClient.ReadSymbolInfo(pv.PLCname);
pv.PLCtype = symbol.Type;
}
