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; }