public DataTable getItems()
{
db.SetConnection();
string sSQL = "Select * FROM items";
return(db.DT(sSQL));
}
public DataTable getItems()
{
db.SetConnection();
string sSQL = "Select * FROM collar_data_entry";
return(db.DT(sSQL));
}
public DataTable getIsotopics() // all of them and all them's's columns
{
db.SetConnection();
string sSQL = "Select * FROM isotopics";
return(db.DT(sSQL));
}
public DataTable GetCombinedResults(long mid)
{
db.SetConnection();
string sSQL = "SELECT * FROM " + table + "," + MethodTableName() + " where " + table + ".mid=" + mid.ToString() + " AND " + MethodTableName() + ".rid=" + table + ".id";
return(db.DT(sSQL));
}
public DataTable getCompositeIsotopics()
{
db.SetConnection();
string sSQL = "Select * FROM composite_isotopics_rec";
return(db.DT(sSQL));
}
public DataTable Get() // all of them
{
db.SetConnection();
string sSQL = "Select * FROM holdup_config_rec";
DataTable dt = db.DT(sSQL);
return(dt);
}
public DataTable GetCollar() // all of them
{
db.SetConnection();
string sSQL = "Select * FROM collar_rec";
DataTable dt = db.DT(sSQL);
return(dt);
}
public DataTable GetAll()
{
db.SetConnection();
string sSQL = "Select * from LMINCCAppContext";
DataTable dt = db.DT(sSQL);
return(dt);
}
public DataTable Get() // all of them
{
db.SetConnection();
string sSQL = "Select * FROM poison_rod_type_rec";
DataTable dt = db.DT(sSQL);
return(dt);
}
// return the stratums only
public DataTable Get()
{
db.SetConnection();
Detectors dets = new Detectors(db);
string sSQL = "Select * FROM stratum_ids";
DataTable dt = db.DT(sSQL);
return(dt);
}
public DataTable Get(string detname, DateTime date)
{
db.SetConnection();
Measurements ms = new Measurements(db);
long l = ms.PrimaryKey(detname, date);
string sSQL = "Select * FROM " + table + " where mid = " + l.ToString();
DataTable dt = db.DT(sSQL);
return(dt);
}
public DataTable AllResults(string name = null)
{
if (!String.IsNullOrEmpty(name))
{
return(ResultsForDet(name));
}
else
{
db.SetConnection();
string sSQL = "SELECT * FROM results_rec";
return(db.DT(sSQL));
}
}
public DataTable AllHVPlateauResults(string name = null)
{
if (!String.IsNullOrEmpty(name))
{
return(AllHVPlateauResults(name));
}
else
{
db.SetConnection();
string sSQL = "SELECT * FROM HVResult";
return(db.DT(sSQL));
}
}
public DataTable AllMeasurements(string name = null)
{
if (!String.IsNullOrEmpty(name))
{
return(MeasurementsForDet(name));
}
else
{
db.SetConnection();
string sSQL = "SELECT * FROM measurements";
return(db.DT(sSQL));
}
}
public DataTable GetCounterParams(long mid)
{
db.SetConnection();
string sSQL = "SELECT * from " + table + "_m" + " where mid=" + mid.ToString();
return(db.DT(sSQL));
}
public DataTable getItems()
{
db.SetConnection();
string sSQL = "Select * FROM items";
//DbCommand dbcmd = DBMain.DBCmd;
//dbcmd.Connection = db.sql_con;
//DbParameter p = dbcmd.CreateParameter();
//p.ParameterName = "items";
//p.Value = "items";
//dbcmd.CommandType = CommandType.Text;
//dbcmd.Parameters.Add(p);
//dbcmd.CommandText = "Select * FROM";
//DbDataReader dbr = dbcmd.ExecuteReader();
return(db.DT(sSQL));
}
public DataTable Get() // all of them
{
db.SetConnection();
string sSQL = "Select * FROM test_parms_rec";
DataTable dt = db.DT(sSQL);
return(dt);
}
