//Запись списка колонок и формирование колонок таблиц Params и VedLin
private void MakeColumnsAndFilters()
{
AddEvent("Формирование колонок ведомости");
using (var rec = new RecDao(_vedDb, "VedColumns"))
foreach (var column in _columns)
{
column.ToRecordset(rec);
}
_vedDb.Execute("INSERT INTO VedColumnsFormatConditions SELECT VedColumnsFormatConditions.* FROM [" + _project.File + "].VedColumnsFormatConditions " +
"INNER JOIN [" + _project.File + "].VedColumns ON VedColumnsFormatConditions.ParentId = VedColumns.ColumnId " +
"WHERE VedColumns.Task='" + _task + "' ORDER BY ColumnNum");
_vedDb.Execute("INSERT INTO VedFilters ( Otm, FilterId, FilterNum, FilterType, FilterName, FilterValue, FilterDescription, FilterDefault ) " +
"SELECT VedFilters.Otm, VedFilters.FilterId, VedFilters.FilterNum, VedFilters.FilterType, VedFilters.FilterName, VedFilters.FilterValue, VedFilters.FilterDescription, VedFilters.FilterDefault " +
"FROM [" + _project.File + "].VedFilters" + (_allTasks ? "" : " WHERE VedFilters.Task='" + _task + "';"));
_vedDb.Execute("INSERT INTO VedFiltersObjects SELECT VedFiltersObjects.* " +
"FROM [" + _project.File + "].VedFilters INNER JOIN [" + _project.File + "].VedFiltersObjects ON VedFilters.FilterId = VedFiltersObjects.ParentId" +
(_allTasks ? "" : " WHERE VedFilters.Task='" + _task + "';"));
foreach (var col in _columnsVed.Values)
{
_vedDb.SetColumn("VedLin", col.Code, col.DataType);
}
foreach (var col in _columnsParams.Values)
{
_vedDb.SetColumn("Params", col.Code, col.DataType);
//if (col.LinVedView != VedView.None)
// _vedDb.SetColumn("VedLin", col.Code, col.DataType);
}
}
