public static DmlfResultFieldCollection Run(DmlfResultFieldCollection cols, List <DmlfExpression> avail)
{
var win = new ChooseVisibleColumnsForm(cols, avail);
if (win.ShowDialogEx() == DialogResult.OK)
{
return(win.GetResult());
}
return(null);
}
private DmlfResultFieldCollection GetResult()
{
var res = new DmlfResultFieldCollection();
foreach (DmlfResultField fld in lbxVisibleColumns.Items)
{
res.Add(fld);
}
res.AddRange(m_hidCols);
return(res);
}
public ChooseVisibleColumnsForm(DmlfResultFieldCollection cols, List <DmlfExpression> avail)
{
InitializeComponent();
m_avail = avail;
cols.SplitVisible(out m_visCols, out m_hidCols);
foreach (var av in m_avail)
{
lbxAvailableColumns.Items.Add(av);
}
foreach (var vis in m_visCols)
{
lbxVisibleColumns.Items.Add(vis);
}
}
public void SplitVisible(out DmlfResultFieldCollection visCols, out DmlfResultFieldCollection hidCols)
{
visCols = new DmlfResultFieldCollection();
hidCols = new DmlfResultFieldCollection();
foreach (var fld in this)
{
if (fld.DisplayInfo.Style == ColumnDisplayInfo.UsageStyle.Value)
{
visCols.Add(fld);
}
else
{
hidCols.Add(fld);
}
}
}
public static object[] GetValuesByCols(this IBedRecord record, DmlfColumnRef[] cols, DmlfResultFieldCollection result)
{
if (result == null)
{
return(record.GetValuesByCols(cols.GetNames()));
}
object[] values = new object[cols.Length];
for (int i = 0; i < cols.Length; i++)
{
int index = result.GetColumnIndex(cols[i]);
values[i] = record.GetValue(index);
}
return(values);
}
public DmlfSelect()
{
Columns = new DmlfResultFieldCollection();
From = new DmlfFrom();
}
