public void Delete(int recNo) { CalibratorDataSet row = Resource.Db.CalibratorSet; CalibratorRowDataSet rowSet = Resource.Db.CalibratorRowSet; CalibPointDataSet pointSet = Resource.Db.CalibPointSet; BeginTrans(); try { rowSet.Select(recNo); for (int i = 0; i < rowSet.GetRowCount(); i++) { rowSet.Fetch(i); pointSet.Delete(rowSet.RecNo, Trans); } rowSet.Delete(recNo, Trans); row.Delete(recNo, Trans); CommitTrans(); } catch (Exception e) { Resource.TLog.Log((int)ELogItem.Exception, e.ToString()); RollbackTrans(); } }
public void Load(int recNo) { CalibratorDataSet set = CalibratorSet; Dictionary <int, CalibratorRow> allRows = Resource.Server.Devices.Calibrators.Category["All"]; try { set.Select(recNo); if (set.GetRowCount() > 0) { set.Fetch(); CalibratorRowDataSet rowSet = CalibratorRowSet; rowSet.Select(set.RecNo); for (int i = 0; i < rowSet.GetRowCount(); i++) { rowSet.Fetch(i); CalibratorRow row = null; if (allRows.TryGetValue(rowSet.Channel, out row) == true) { row.No = rowSet.Channel; row.Calibrator.Active = true; row.Calibrator.RawA = rowSet.RawA; row.Calibrator.RawB = rowSet.RawB; row.Calibrator.RawC = rowSet.RawC; row.Calibrator.DiffA = rowSet.DiffA; row.Calibrator.DiffB = rowSet.DiffB; row.Calibrator.DiffC = rowSet.DiffC; CalibPointDataSet pointSet = CalibPointSet; pointSet.Select(rowSet.RecNo); for (int j = 0; j < pointSet.GetRowCount(); j++) { pointSet.Fetch(j); row.Calibrator.Points[j].PV = (float)pointSet.PV; row.Calibrator.Points[j].SV = (float)pointSet.SV; } } } } } catch (Exception e) { Resource.TLog.Log((int)ELogItem.Exception, e.ToString()); throw new Exception("Occurred loading error of calibrator in UlFirebird.Load"); } }