aboutsummaryrefslogtreecommitdiff
path: root/src/PriceListTools/MergeTool.cs
diff options
context:
space:
mode:
Diffstat (limited to 'src/PriceListTools/MergeTool.cs')
-rw-r--r--src/PriceListTools/MergeTool.cs55
1 files changed, 2 insertions, 53 deletions
diff --git a/src/PriceListTools/MergeTool.cs b/src/PriceListTools/MergeTool.cs
index 0e98b95..51884dd 100644
--- a/src/PriceListTools/MergeTool.cs
+++ b/src/PriceListTools/MergeTool.cs
@@ -1,58 +1,7 @@
-using Microsoft.Office.Interop.Excel;
-using System;
-
-namespace RehauSku.PriceListTools
+namespace RehauSku.PriceListTools
{
- internal class MergeTool : AbstractPriceListTool, IDisposable
+ internal class MergeTool : PriceListTool
{
- public override void FillPriceList()
- {
- int exportedValues = 0;
-
- ExcelApp.ScreenUpdating = false;
-
- foreach (var sheet in sourcePriceLists)
- {
- if (sheet.SkuAmount.Count == 0)
- continue;
-
- foreach (var kvp in sheet.SkuAmount)
- {
- Range cell = NewPriceList.Sheet.Columns[NewPriceList.skuCell.Column].Find(kvp.Key);
-
- if (cell == null)
- {
- System.Windows.Forms.MessageBox.Show
- ($"Артикул {kvp.Key} отсутствует в таблице заказов {RegistryUtil.PriceListPath}",
- "Отсутствует позиция в конечной таблице заказов",
- System.Windows.Forms.MessageBoxButtons.OK,
- System.Windows.Forms.MessageBoxIcon.Information);
- }
-
- else
- {
- Range sumCell = NewPriceList.Sheet.Cells[cell.Row, NewPriceList.amountCell.Column];
-
- if (sumCell.Value2 == null)
- sumCell.Value2 = kvp.Value;
- else
- sumCell.Value2 += kvp.Value;
-
- exportedValues++;
- }
- }
- }
-
- FilterByAmount();
- ExcelApp.ScreenUpdating = true;
-
- AddIn.Excel.StatusBar = $"Экспортировано {exportedValues} строк из {sourcePriceLists.Count} файлов";
- Forms.Dialog.SaveWorkbookAs();
- }
- public void Dispose()
- {
- GC.SuppressFinalize(this);
- }
}
}