private void RefreshEventsGroup(TagHandler Tags)
{
for (int i = 0; i < EvGroups.Count; i++)
{
//All the events are in evGroups
//refresh from OPC all events (diferents OPCs)
if (EvGroups[i].opcgroup.ServerName.Length > 1)
{
EvGroups[i].opcgroup.GetData();
Tags.RefreshFromGroup(EvGroups[i].opcgroup);
}
else
{
Tags.RefreshFromEvents(EvGroups[i].opcgroup);
}
}
//Refresh the struc EVENTS (that contain inserts/updates)
for (int i = 0; i < OPCEvents.Count; i++)
{
int indexer = Tags.SearchTag(OPCEvents[i].Tagevent);
if (indexer != -1)
{
TagEvent evt = OPCEvents[i];
evt.Activated = Tags.Values[indexer].Activated;
evt.Deactivated = Tags.Values[indexer].Deactivated;
OPCEvents[i] = evt;
}
}
}
private void RefreshWhereGroup(TagHandler Tags)
{
for (int i = 0; i < WhereGroups.Count; i++)
{
WhereGroups[i].opcgroup.GetData();
Tags.RefreshFromGroup(WhereGroups[i].opcgroup);
}
}
private void RefreshVarGroup(string tagevent, TagHandler Tags)
{
for (int i = 0; i < VarGroups.Count; i++)
{
if (VarGroups[i].tagEvent == tagevent)
{
VarGroups[i].opcgroup.GetData();
Tags.RefreshFromGroup(VarGroups[i].opcgroup);
}
}
}
private Boolean GenerateTagsInWhereTable(TagHandler Tags)
{
string sqlQuery;
List <string> tags = new List <string>();
sqlQuery = "delete from PLC2DB_TagsInWhere";
Logging log = new Logging(sqlQuery);
try
{
using (SqlConnection connection = new SqlConnection(IntData.CfgConn))
{
connection.Open();
SqlCommand cmd = new SqlCommand(sqlQuery, connection);
cmd.ExecuteNonQuery();
sqlQuery = "select ID, Cond from PLC2DB_Cfg where Cond is Not Null and Cond <>''";
cmd = new SqlCommand(sqlQuery, connection);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
if (Tags.GetTagsInString(sdr[1].ToString(), tags) != 0)
{
InsertTagInWhere(Convert.ToInt32(sdr[0]), ref tags);
}
}
sdr.Close();
}
log.Success();
return(true);
}
catch (Exception ex)
{
log.Fatal(ex);
return(false);
}
}
public void Refresh(TagHandler Tags)
{
RefreshEventsGroup(Tags);
RefreshTimerEvents();
IntData.SaveRecordsetFlag = false;
for (int i = 0; i < OPCEvents.Count; i++)
{
if (OPCEvents[i].Enable)
{
if (OPCEvents[i].Activated)
{
RefreshVarGroup(OPCEvents[i].Tagevent, Tags);
RefreshWhereGroup(Tags);
for (int index = 0; index < OPCEvents[i].Targets[POSITIVE_FLANC].Count; index++)
{
OPCEvents[i].Targets[POSITIVE_FLANC][index].Execute(true, OPCEvents[i].Tagevent, Tags);
}
Tags.ExecuteScripts(OPCEvents[i].ScriptsList, POSITIVE_FLANC);
}
if (OPCEvents[i].Deactivated)
{
RefreshVarGroup(OPCEvents[i].Tagevent, Tags);
RefreshWhereGroup(Tags);
for (int index = 0; index < OPCEvents[i].Targets[NEGATIVE_FLANC].Count; index++)
{
OPCEvents[i].Targets[NEGATIVE_FLANC][index].Execute(true, OPCEvents[i].Tagevent, Tags);
}
Tags.ExecuteScripts(OPCEvents[i].ScriptsList, NEGATIVE_FLANC);
}
}
}
if (IntData.SaveRecordsetFlag)
{
//***JB1 MsgBox "grabarRecordsetFlag"
//tcklog.log "Saving Record Set"
}
for (int i = 0; i < TimerEvents.Count; i++)
{
if (TimerEvents[i].enable)
{
if (TimerEvents[i].Activated)
{
RefreshVarGroup(TimerEvents[i].Tagevent, Tags);
RefreshWhereGroup(Tags);
for (int index = 0; index < TimerEvents[i].Targets[POSITIVE_FLANC].Count; index++)
{
TimerEvents[i].Targets[POSITIVE_FLANC][index].Execute(true, TimerEvents[i].Tagevent, Tags);
}
Tags.ExecuteScripts(TimerEvents[i].ScriptsList, POSITIVE_FLANC);
}
if (TimerEvents[i].Deactivated)
{
RefreshVarGroup(TimerEvents[i].Tagevent, Tags);
RefreshWhereGroup(Tags);
for (int index = 0; index < TimerEvents[i].Targets[NEGATIVE_FLANC].Count; index++)
{
TimerEvents[i].Targets[NEGATIVE_FLANC][index].Execute(true, TimerEvents[i].Tagevent, Tags);
}
Tags.ExecuteScripts(TimerEvents[i].ScriptsList, NEGATIVE_FLANC);
}
}
}
}
