private void btnAddFunction_Click(object sender, EventArgs e)
{
LogicColumn newcol = CreateDefaultLogicColumn();
DataSourceTable tbl = CurrentTable;
tbl.DataColumns.Add(newcol);
gridColumns.DataSource = CurrentTable.DataColumns.ConvertAll(c => c as LogicColumn);
}
bool Exists(DataSourceLogicTable table, LogicColumn col)
{
foreach (LogicColumn col2 in table.DataColumns)
{
if (col.FunctionName == col2.ColumnName)
{
return(true);
}
}
return(false);
}
private void gridColumns_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex > -1 && gridColumns.Columns[e.ColumnIndex].Name == "ColParameter" && e.RowIndex > -1)
{
LogicColumn col = (LogicColumn)gridColumns.Rows[e.RowIndex].DataBoundItem;
FormLogicConfig frm = new FormLogicConfig();
frm.ConfigContent = col.ConfigContent;
frm.ShowDialog();
if (frm.IsCanceled == false)
{
col.ConfigContent = frm.ConfigContent;
}
}
}
void AddDefaultListFunctionsAgainOnNewTable(DataSourceTable table, DataSourceLogicTable newTable, int colCounter, Model.DataColumn col)
{
int colCounter2 = 0;
foreach (Model.DataColumn col2 in table.DataColumns)
{
LogicColumn logicColumn = CreateDefaultListFunctionAgainLogicColumn(colCounter, colCounter2, col, col2, newTable);
if (logicColumn != null)
{
newTable.DataColumns.Add(logicColumn);
}
colCounter2++;
}
}
void Test(DataSourceTable tbl, DataSourceLogicTable newTable, List <Model.DataColumn> cols)
{
bool start = false;
if (cols == null)
{
cols = new List <Model.DataColumn>();
}
foreach (Model.DataColumn col in tbl.DataColumns)
{
if (start && col.DataType.ToLower().Contains("int"))
{
cols.Add(col);
LogicColumn newColumn = CreateNewFindLogicColumn(tbl, newTable, cols);
if (Exists(newTable, newColumn) == false)
{
newTable.DataColumns.Add(newColumn);
}
newColumn = CreateNewUpdateLogicColumn(tbl, newTable, cols);
if (Exists(newTable, newColumn) == false)
{
newTable.DataColumns.Add(newColumn);
}
newColumn = CreateNewDeleteLogicColumn(tbl, newTable, cols);
if (Exists(newTable, newColumn) == false)
{
newTable.DataColumns.Add(newColumn);
}
List <Model.DataColumn> tempCols = new List <Model.DataColumn>();
tempCols = tempCols.Concat(cols).ToList();
Test(tbl, newTable, tempCols);
cols.Remove(col);
}
if (cols.Count == 0)
{
start = true;
}
if (cols.Count > 0 && col.ColumnName == cols[cols.Count - 1].ColumnName)
{
start = true;
}
}
}
void AddDefaultFunctions(DataSourceTable table, DataSourceLogicTable newTable)
{
foreach (Model.DataColumn col in table.DataColumns)
{
LogicColumn logicColumn = null;
if (col.DataType.ToLower().Contains("int") == false)
{
logicColumn = CreateDefaultFindAllLogicColumn(table, col, newTable);
newTable.DataColumns.Add(logicColumn);
}
if (col.DataType.ToLower().Contains("int") == false)
{
logicColumn = CreateDefaultUpdateLogicColumn(table, col, newTable);
newTable.DataColumns.Add(logicColumn);
}
if (col.DataType.ToLower().Contains("int") == false)
{
logicColumn = CreateDefaultDeleteLogicColumn(table, col, newTable);
newTable.DataColumns.Add(logicColumn);
}
}
Test(table, newTable, null);
}
