public override DataSqlGeneratorColumnSet GetColumnSet()
{
var res = new DataSqlGeneratorColumnSet();
if (rbtAllColumns.Checked)
{
res.Mode = DataSqlGeneratorColumnSet.ModeEnum.AllColumns;
}
if (rbtChooseColumns.Checked)
{
res.Mode = DataSqlGeneratorColumnSet.ModeEnum.ExplicitColumns;
res.Columns.AddRange(m_columns);
}
if (rbtNoKeyColumns.Checked)
{
res.Mode = DataSqlGeneratorColumnSet.ModeEnum.NoPkCols;
}
if (rbtPrimaryKey.Checked)
{
res.Mode = DataSqlGeneratorColumnSet.ModeEnum.PrimaryKey;
}
if (rbtSelectedColumns.Checked)
{
res.Mode = DataSqlGeneratorColumnSet.ModeEnum.SelectedColumns;
}
if (rbtNoSelectedColumns.Checked)
{
res.Mode = DataSqlGeneratorColumnSet.ModeEnum.NoSelectedColumns;
}
return(res);
}
protected static string[] GetColumns(DataSqlGeneratorColumnSet colset, ITableStructure ts, string[] selcolumns)
{
switch (colset.Mode)
{
case DataSqlGeneratorColumnSet.ModeEnum.AllColumns:
return(ts.Columns.GetNames());
case DataSqlGeneratorColumnSet.ModeEnum.ExplicitColumns:
return(colset.Columns.ToArray());
case DataSqlGeneratorColumnSet.ModeEnum.NoPkCols:
return(ts.GetNoPkColumnNames());
case DataSqlGeneratorColumnSet.ModeEnum.PrimaryKey:
return(ts.GetPkColumnNames());
case DataSqlGeneratorColumnSet.ModeEnum.SelectedColumns:
return(selcolumns);
case DataSqlGeneratorColumnSet.ModeEnum.NoSelectedColumns:
{
var res = new List <string>();
foreach (string col in ts.Columns.GetNames())
{
if (Array.IndexOf(selcolumns, col) <= 0)
{
res.Add(col);
}
}
return(res.ToArray());
}
}
return(null);
}
public override DataSqlGeneratorColumnSet GetColumnSet()
{
var res = new DataSqlGeneratorColumnSet();
res.Mode = DataSqlGeneratorColumnSet.ModeEnum.ExplicitColumns;
for (int i = 0; i < checkedListBox1.Items.Count; i++)
{
bool value = checkedListBox1.GetItemChecked(i);
if (m_currentCheck != null && i == m_currentCheck.Index)
{
value = m_currentCheck.NewValue == CheckState.Checked;
}
if (value)
{
res.Columns.Add(checkedListBox1.Items[i].ToString());
}
}
return(res);
}