public long Create(string detname, DateTime date, ElementList resParams)
{
db.SetConnection();
Measurements ms = new Measurements(db);
long mid = ms.PrimaryKey(detname, date);
return(Create(mid, resParams));
}
public DataTable GetMethod(string detname, DateTime date)
{
db.SetConnection();
Measurements ms = new Measurements(db);
long l = ms.PrimaryKey(detname, date);
string sSQL = "Select * FROM " + MethodTableName + "where mid = " + l.ToString();
DataTable dt = db.DT(sSQL);
return(dt);
}
// TODO: update results and method results in same step
public bool unraeadyUpdate(string detname, DateTime date, ElementList resParams, ElementList methodParams)
{
db.SetConnection();
Measurements ms = new Measurements(db);
ArrayList sqlList = new ArrayList(); //.......
long l = ms.PrimaryKey(detname, date);
string sSQL1 = "UPDATE " + table + " SET ";
string wh = " where mid=" + l.ToString();
string sSQL = sSQL1 + resParams.ColumnEqValueList + wh;
return(db.Execute(sSQL));
}
// TODO: update results and method results in same step
public bool unraeadyUpdate(string detname, DateTime date, ElementList resParams, ElementList methodParams)
{
db.SetConnection();
Measurements ms = new Measurements(db);
ArrayList sqlList = new ArrayList(); //.......
long l = ms.PrimaryKey(detname, date);
string sSQL1 = "UPDATE " + table + " SET ";
string wh = " where mid=" + l.ToString();
string sSQL = sSQL1 + resParams.ColumnEqValueList + wh;
return db.Execute(sSQL);
}
public long Create(string detname, DateTime date, ElementList resParams)
{
db.SetConnection();
Measurements ms = new Measurements(db);
long mid = ms.PrimaryKey(detname, date);
return Create(mid, resParams);
}
public DataTable GetMethod(string detname, DateTime date)
{
db.SetConnection();
Measurements ms = new Measurements(db);
long l = ms.PrimaryKey(detname, date);
string sSQL = "Select * FROM " + MethodTableName + "where mid = " + l.ToString();
DataTable dt = db.DT(sSQL);
return dt;
}
