public DataTable GetComms()
{
db.SetConnection();
string sSQL = "Select * from LMNetComm";
DataTable dt = db.DT(sSQL);
return(dt);
}
public DataTable getDescs()
{
string sSQL = "SELECT [id] "
+ " ,[name] "
+ " ,[description] "
+ " FROM " + table;
return(db.DT(sSQL));
}
// NEXT: figure out difference between use of meas_detector_id and detector_id
public bool Has(DateTimeOffset measDatetime, string measDetId, string item_type)
{
db.SetConnection();
string sSQL = "select * from acquire_parms_rec where meas_detector_id=" + SQLSpecific.Value(measDetId, true) +
" and item_type=" + SQLSpecific.Value(item_type, true);
DataTable dt = db.DT(sSQL);
return(dt.Rows.Count > 0);
}
public bool Has(string DetectorName, string CounterType)
{
db.SetConnection();
Detectors dets = new Detectors(db);
long l = dets.PrimaryKey(DetectorName);
string sSQL = "Select * from INNER JOIN LMMultiplicity, CountingParams ON (LMMultiplicity.detector_id=CountingParams.detector_id) " +
"where detector_id=" + l.ToString() + " AND " + "counter_type=" + SQLSpecific.QVal(CounterType);
DataTable dt = db.DT(sSQL);
return(dt.Rows.Count > 0);
}
public DataTable Get(string measDetId, string item_type)
{
db.SetConnection();
Detectors dets = new Detectors(db);
long l = dets.PrimaryKey(measDetId);
string sSQL = "Select * FROM LMAcquireParams";
sSQL += " where detector_id = " + l.ToString() + " AND item_type=" + SQLSpecific.Value(item_type, true);
sSQL += " ORDER BY MeasDate DESC";
DataTable dt = db.DT(sSQL);
return(dt);
}
public bool DefinitionExists(ElementList els)
{
db.SetConnection();
string sSQL = "Select * FROM detectors where ";
sSQL = sSQL + els.ColumnEqValueAndList;
DataTable dt = db.DT(sSQL);
return(dt.Rows.Count > 0);
}
public DataTable Get(string measDetId)
{
db.SetConnection();
string sSQL = "Select * FROM sr_parms_rec where " + ResolvedKey(measDetId, db);// +" AND sr_type = " + type.ToString();
DataTable dt = db.DT(sSQL);
return(dt);
}
public DataTable Get(string measDetId)
{
db.SetConnection();
Detectors dets = new Detectors(db);
long l = dets.PrimaryKey(measDetId);
string sSQL = "Select * FROM " + table + " where detector_id = " + l.ToString();
DataTable dt = db.DT(sSQL);
return(dt);
}