private void LoadXAxis() { Resource.TestDB[handle].Lock(); try { XAxisSettingDataSet set = Resource.TestDB[handle].XAxisSettingSet; set.Ip = Resource.Ip; set.Mode = 0; set.GraphNo = Index; set.Select(); if (set.GetRowCount() > 0) { set.Fetch(0); xAxis.RecNo = set.RecNo; xAxis.Minutes = set.Minutes; } } finally { Resource.TestDB[handle].Unlock(); } }
public void InsertXAxis() { Resource.TestDB[handle].Lock(); FbTransaction trans = Resource.TestDB[handle].BeginTrans(); try { XAxisSettingDataSet xAxisSet = Resource.TestDB[handle].XAxisSettingSet; xAxisSet.Ip = Resource.Ip; xAxisSet.Mode = 0; xAxisSet.GraphNo = Index; xAxisSet.Minutes = xAxis.Minutes; if (xAxis.RecNo == -1) { xAxis.RecNo = (int)Resource.TestDB[handle].GetGenNo("GN_XAXISSETTING"); xAxisSet.RecNo = xAxis.RecNo; xAxisSet.Insert(trans); } else { xAxisSet.RecNo = xAxis.RecNo; xAxisSet.Update(trans); } Resource.TestDB[handle].CommitTrans(); } catch (Exception e) { Resource.TLog.Log((int)ELogItem.Exception, e.ToString()); Resource.TestDB[handle].RollbackTrans(); } finally { Resource.TestDB[handle].Unlock(); } }