public void ConvertFile(string file, string folderSave)
{
var loader = new ElectroExcelProjectLoader
{
FieldsToCaptions = new Dictionary<Field, string>
{
{Field.ParentDesignation, "КодПП"},
{Field.ParentName, "НаимПП"},
{Field.NumberBySpec, "Поз"},
{Field.Designation, "Код"},
{Field.Name, "Наимен."},
{Field.CountByOne, "На 1 едПП"},
{Field.CountByAll, "КолЕИ по ветке"},
{Field.Size, "pardimstd"},
{Field.InfoAboutZag, "Наимен."},
{Field.ClearWeigthDetail, "чистый вес"},
{Field.WeigthByAll, "КолЕИ по ветке"},
{Field.WeigthByOne, "На 1 едПП"}
}
};
var sss = new RollUpElectroExcelProject
{
IncludeDebugInfo = WriteDebugColumn,
Normalizer = new FieldsNormalizer()
};
var excelProject = loader.LoadStructureProject(file);
if (WriteDebugFiles)
ExportToExcel(excelProject, folderSave, file, "без изм. ");
sss.FilterExcelProject(excelProject);
if (WriteDebugFiles)
ExportToExcel(excelProject, folderSave, file, "фильтр. ");
var rolled = sss.ConvertElectoExcelToDkExcel(excelProject);
if (WriteDebugFiles)
ExportToExcel(rolled, folderSave, file, "без изм. конв. ");
sss.ConvertInfoAbooutZagToAll(rolled);
if (WriteDebugFiles)
ExportToExcel(rolled, folderSave, file, "конв. мат. ");
sss.ClearUnusableInfoAll(rolled);
if (WriteDebugFiles)
ExportToExcel(rolled, folderSave, file, "чист. ст. ");
sss.RecalculateWeigthsAll(rolled);
sss.RecalculateWeigtsWithAllChildrens(rolled);
if (WriteDebugFiles)
ExportToExcel(rolled, folderSave, file, "перес. вес ");
sss.ConvertSize(rolled);
ExportToExcel(rolled, folderSave, file, "оконч. ");
}
public void MergeFiles(List<string> files, string folder)
{
var excelProjects = files.Select(file => new ExcelProjectLoaderWithoutHeader(new FileGetter() {FileName = file})).Select(excelLoader => excelLoader.LoadStructureProject()).ToList();
var mergedExcelProject = new ExcelProject
{
Row = new object[18],
Positions = excelProjects
};
mergedExcelProject.Row[13] = 1;
mergedExcelProject.Row[14] = 1;
ExportToExcel(mergedExcelProject, folder, "Объединённый файл.xlsx", string.Empty);
var sss = new RollUpElectroExcelProject();
sss.RecalculateWeigtsWithAllChildrens(mergedExcelProject);
ExportToExcel(mergedExcelProject, folder, "Пересчитанный объединённый файл.xlsx", string.Empty);
}
