private void InsertSeries()
{
Resource.TestDB[handle].Lock();
FbTransaction trans = Resource.TestDB[handle].BeginTrans();
try
{
SeriesSettingDataSet seriesSet = Resource.TestDB[handle].SeriesSettingSet;
for (int i = 0; i < PlotSeriesRows.Count; i++)
{
SeriesRow row = PlotSeriesRows[i];
seriesSet.Ip = Resource.Ip;
seriesSet.Mode = 0;
seriesSet.GraphNo = Index;
seriesSet.Checked = row.Checked;
seriesSet.Color = row.Color;
seriesSet.Name = row.Name;
seriesSet.UnitType = row.UnitType;
if (row.RecNo == -1)
{
row.RecNo = (int)Resource.TestDB[handle].GetGenNo("GN_SERIESSETTING");
seriesSet.RecNo = row.RecNo;
seriesSet.Insert(trans);
}
else
{
seriesSet.RecNo = row.RecNo;
seriesSet.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();
}
}
private void LoadPlotSeries()
{
Resource.TestDB[handle].Lock();
try
{
SeriesSettingDataSet set = Resource.TestDB[handle].SeriesSettingSet;
set.Ip = Resource.Ip;
set.Mode = 0;
set.GraphNo = Index;
set.Select();
if (set.GetRowCount() > 0)
{
if (PlotSeriesRows.Count != set.GetRowCount())
{
Resource.TLog.Log((int)ELogItem.Error, "Plot series count is mismatched in CtrlViewGraphPanel.LoadPlotSeries");
}
else
{
for (int i = 0; i < set.GetRowCount(); i++)
{
set.Fetch(i);
PlotSeriesRows[i].RecNo = set.RecNo;
PlotSeriesRows[i].Checked = set.Checked;
PlotSeriesRows[i].Color = set.Color;
}
plotSeriesGridView.RefreshData();
}
}
}
finally
{
Resource.TestDB[handle].Unlock();
}
}