public bool TestAttribute( string uuid, string attribute, object value, string qualifier )
{
bool inBounds = false;
object valueHi;
object valueLo;
DetermineHoLoValues( qualifier, value, out valueHi, out valueLo );
string sql = string.Format("SELECT COUNT(*) as cnt from {0} WHERE {1}=? AND {2}=? AND {3}<=? AND {4}>=?",
InstrumentCapabilitiesBean._TABLE_NAME,
InstrumentCapabilitiesBean._INSTRUMENT_UUID,
InstrumentCapabilitiesBean._ATTRIBUTE,
InstrumentCapabilitiesBean._LOW_VALUE,
InstrumentCapabilitiesBean._HIGH_VALUE );
List<OleDbParameter> dbParams = new List<OleDbParameter>();
dbParams.Add(CreateParameter(InstrumentCapabilitiesBean._INSTRUMENT_UUID, uuid));
dbParams.Add(CreateParameter(InstrumentCapabilitiesBean._ATTRIBUTE, attribute));
dbParams.Add(CreateParameter(InstrumentCapabilitiesBean._LOW_VALUE, valueLo));
dbParams.Add(CreateParameter(InstrumentCapabilitiesBean._HIGH_VALUE, valueHi));
using (OleDbDataReader rs = ExecuteSqlQuery( sql, dbParams.ToArray() ))
{
if (rs != null)
{
if (rs.Read())
{
inBounds = int.Parse( rs["cnt"].ToString() ) > 0;
}
}
}
return inBounds;
}