aboutsummaryrefslogtreecommitdiff
path: root/src/Controllers/CombineTool.cs
diff options
context:
space:
mode:
authorSergey Chebotar <s.chebotar@gmail.com>2022-12-20 12:27:47 +0300
committerSergey Chebotar <s.chebotar@gmail.com>2022-12-20 12:27:47 +0300
commit73569a43644309d0342817580bcfd86c1face5b8 (patch)
treef3c6e15db82130b02ec8c3fa1b64674e6a9cf48d /src/Controllers/CombineTool.cs
parent3d186c22e8665b80839495fdcf4b176c2f3e03b9 (diff)
Namespace refactoring
Diffstat (limited to 'src/Controllers/CombineTool.cs')
-rw-r--r--src/Controllers/CombineTool.cs56
1 files changed, 56 insertions, 0 deletions
diff --git a/src/Controllers/CombineTool.cs b/src/Controllers/CombineTool.cs
new file mode 100644
index 0000000..75c0f51
--- /dev/null
+++ b/src/Controllers/CombineTool.cs
@@ -0,0 +1,56 @@
+using Microsoft.Office.Interop.Excel;
+using RhSolutions.Models;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using Dialog = RhSolutions.Models.Dialog;
+
+namespace RhSolutions.Controllers
+{
+ internal class CombineTool : ToolBase
+ {
+ private List<SourcePriceList> SourceFiles { get; set; }
+
+ public CombineTool()
+ {
+ string[] files = Dialog.GetMultiplyFiles();
+
+ if (files != null)
+ {
+ SourceFiles = SourcePriceList.GetSourceLists(files);
+ }
+
+ else
+ {
+ throw new Exception("Не выбраны файлы");
+ }
+ }
+
+ public override void FillTarget()
+ {
+ using (ProgressBar = new ProgressBar("Заполняю строки...", SourceFiles.Sum(file => file.PositionAmount.Count)))
+ using (ResultBar = new ResultBar())
+ {
+ foreach (SourcePriceList source in SourceFiles)
+ {
+ TargetFile.Sheet.Columns[TargetFile.AmountCell.Column]
+ .EntireColumn
+ .Insert(XlInsertShiftDirection.xlShiftToRight, XlInsertFormatOrigin.xlFormatFromRightOrBelow);
+
+ Range newColumnHeader = TargetFile.Sheet.Cells[TargetFile.AmountCell.Row, TargetFile.AmountCell.Column - 1];
+ newColumnHeader.Value2 = $"{source.Name}";
+ newColumnHeader.WrapText = true;
+
+ foreach (var kvp in source.PositionAmount)
+ {
+ FillPositionAmountToColumns(kvp, TargetFile.AmountCell.Column - 1, TargetFile.AmountCell.Column);
+ ProgressBar.Update();
+ }
+ }
+
+ FilterByAmount();
+ ResultBar.Update();
+ }
+ }
+ }
+}