private string GetTriggerTableSql(ITriggerTables TheClass)
{
string sSql = "Select ";
sSql += TheClass.GetKeyName() + ", " + TheClass.GetBasePlate();
sSql += " from " + TheClass.GetTableName();
sSql += " where " + TheClass.GetKeyName() + " > " + TheClass.LastKeyUsed.ToString();
sSql += " order by " + TheClass.GetKeyName();
return(sSql);
}
private bool MonitorTriggerTable(ITriggerTables theObj)
{
SqlDataReader dataReader = null;
bool bFound = false;
int nKey = -1;
List <string> serialsList = new List <string>();
try
{
Console.WriteLine(DateTime.Now.ToString() + " - Polling " + theObj.GetTableName() + "...");
// ja - read from the generic trigger table (only unprocessed keys) ordered by the table key
dataReader = SqlCmd.GetTrigerReader(theObj);
// ja - only read first result
while (dataReader.Read())
{
bFound = true;
string sKey = dataReader[theObj.GetKeyName()].ToString().Trim();
string sSerialNumber = dataReader[theObj.GetBasePlate()].ToString().Trim();
Console.WriteLine("Found Key in " + theObj.GetTableName() + ": Key = " + sKey + "...");
Console.WriteLine("Found Serial in " + theObj.GetTableName() + ": Serial = " + sSerialNumber + "...");
// ja - store serial numbers so they can be written after this reader is closed as I only maintain one DB connection at a time
if (!String.IsNullOrEmpty(sSerialNumber) && !sSerialNumber.Contains("End"))
{
serialsList.Add(sSerialNumber);
}
// ja - get the last key used
nKey = Convert.ToInt32(sKey);
}
// ja - store the last key...
if (nKey > -1)
{
theObj.LastKeyUsed = nKey;
}
dataReader.Close();
foreach (string serial in serialsList)
{
SqlCmd.FillJobsQueue(theObj, serial);
}
}
catch (Exception ex)
{
dataReader.Close();
Config.Log(ex.Message);
}
return(bFound);
}