Merge pull request #15 from schebotar/dev

Dev

1 files changed, 203 insertions, 0 deletions

diff --git a/src/PriceListTools/AbstractTool.cs b/src/PriceListTools/AbstractTool.cs
new file mode 100644
index 0000000..b4e34cc
--- /dev/null
+++ b/src/PriceListTools/AbstractTool.cs
@@ -0,0 +1,203 @@
+using ExcelDna.Integration;
+using Microsoft.Office.Interop.Excel;
+using RehauSku.Interface;
+using System;
+using System.Collections.Generic;
+using System.Windows.Forms;
+using Application = Microsoft.Office.Interop.Excel.Application;
+using ProgressBar = RehauSku.Interface.ProgressBar;
+
+namespace RehauSku.PriceListTools
+{
+    internal abstract class AbstractTool
+    {
+        protected private Application ExcelApp = (Application)ExcelDnaUtil.Application;
+        protected private TargetPriceList TargetFile;
+        protected private ResultBar ResultBar { get; set; }
+        protected private ProgressBar ProgressBar { get; set; }
+
+        public void OpenNewPrice()
+        {
+            Workbook wb = ExcelApp.Workbooks.Open(RegistryUtil.PriceListPath);
+
+            try
+            {
+                TargetFile = new TargetPriceList(wb);
+            }
+
+            catch (Exception ex)
+            {
+                MessageBox.Show
+                    (ex.Message,
+                    "Ошибка открытия шаблонного прайс-листа",
+                    MessageBoxButtons.OK,
+                    MessageBoxIcon.Information);
+                wb.Close();
+                throw ex;
+            }
+        }
+
+        protected private void FillPositionAmountToColumns(KeyValuePair<Position, double> positionAmount, params int[] columns)
+        {
+            int? row = GetPositionRow(positionAmount.Key.Sku, positionAmount.Key.Group, TargetFile.skuCell.Column);
+
+            if (row != null)
+            {
+                foreach (int column in columns)
+                {
+                    Range sumCell = TargetFile.Sheet.Cells[row, column];
+
+                    if (sumCell.Value2 == null)
+                    {
+                        sumCell.Value2 = positionAmount.Value;
+                    }
+
+                    else
+                    {
+                        sumCell.Value2 += positionAmount.Value;
+                    }
+                }
+
+                ResultBar.IncrementSuccess();
+                return;
+            }
+
+            if (TargetFile.oldSkuCell != null)
+            {
+                Range foundCell = TargetFile.oldSkuCell.EntireColumn.Find(positionAmount.Key.Sku);
+
+                if (foundCell != null)
+                {
+                    row = foundCell.Row;
+
+                    foreach (int column in columns)
+                    {
+                        if (TargetFile.Sheet.Cells[row, column].Value2 == null)
+                        {
+                            TargetFile.Sheet.Cells[row, column].Value2 = positionAmount.Value;
+                        }
+
+                        else
+                        {
+                            TargetFile.Sheet.Cells[row, column].Value2 += positionAmount.Value;
+                        }
+                    }
+
+                    ResultBar.IncrementReplaced();
+                    return;
+                }
+            }
+
+            string sku = positionAmount.Key.Sku.Substring(1, 6);
+            row = GetPositionRow(sku, positionAmount.Key.Group, TargetFile.skuCell.Column);
+
+            if (row != null)
+            {
+                foreach (int column in columns)
+                {
+                    Range amountCell = TargetFile.Sheet.Cells[row, column];
+
+                    if (amountCell.Value2 == null)
+                    {
+                        amountCell.Value2 = positionAmount.Value;
+                    }
+
+                    else
+                    {
+                        amountCell.Value2 += positionAmount.Value;
+                    }
+                }
+
+                ResultBar.IncrementReplaced();
+                return;
+            }
+
+            else
+            {
+                FillMissing(positionAmount, columns);
+                ResultBar.IncrementNotFound();
+            }
+        }
+
+        protected private void FillMissing(KeyValuePair<Position, double> positionAmount, params int[] columns)
+        {
+            int row = TargetFile.Sheet.Cells[TargetFile.Sheet.Rows.Count, TargetFile.skuCell.Column]
+                .End[XlDirection.xlUp]
+                .Row + 1;
+
+            TargetFile.Sheet.Rows[row]
+                .EntireRow
+                .Insert(XlInsertShiftDirection.xlShiftDown, XlInsertFormatOrigin.xlFormatFromLeftOrAbove);
+
+            Range previous = TargetFile.Sheet.Rows[row - 1];
+            Range current = TargetFile.Sheet.Rows[row];
+
+            previous.Copy(current);
+            current.ClearContents();
+
+            TargetFile.Sheet.Cells[row, TargetFile.groupCell.Column].Value2 = positionAmount.Key.Group;
+            TargetFile.Sheet.Cells[row, TargetFile.nameCell.Column].Value2 = positionAmount.Key.Name;
+
+            if (TargetFile.oldSkuCell != null)
+            {
+                TargetFile.Sheet.Cells[row, TargetFile.skuCell.Column].Value2 = "Не найден";
+                TargetFile.Sheet.Cells[row, TargetFile.oldSkuCell.Column].Value2 = positionAmount.Key.Sku;
+            }
+
+            else
+            {
+                TargetFile.Sheet.Cells[row, TargetFile.skuCell.Column].Value2 = positionAmount.Key.Sku;
+            }
+
+            foreach (int column in columns)
+            {
+                if (TargetFile.Sheet.Cells[row, column].Value2 == null)
+                {
+                    TargetFile.Sheet.Cells[row, column].Value2 = positionAmount.Value;
+                }
+
+                else
+                {
+                    TargetFile.Sheet.Cells[row, column].Value2 += positionAmount.Value;
+                }
+            }
+        }
+
+        protected private int? GetPositionRow(string sku, string group, int column)
+        {
+            int? row = null;
+            Range foundCell = TargetFile.Sheet.Columns[column].Find(sku);
+            string foundGroupValue;
+
+            if (foundCell == null) return null;
+
+            else
+            {
+                row = foundCell.Row;
+                foundGroupValue = TargetFile.Sheet.Cells[foundCell.Row, TargetFile.groupCell.Column].Value2.ToString();
+            }
+
+            if (string.IsNullOrEmpty(group) || group.Equals(foundGroupValue))
+                return row;
+
+            else
+                while (true)
+                {
+                    foundCell = TargetFile.skuCell.EntireColumn.FindNext(foundCell);
+                    if (foundCell == null) return row;
+
+                    foundGroupValue = TargetFile.Sheet.Cells[foundCell.Row, TargetFile.groupCell.Column].Value2.ToString();
+                    if (group.Equals(foundGroupValue)) return foundCell.Row;
+                }
+        }
+
+        protected private void FilterByAmount()
+        {
+            AutoFilter filter = TargetFile.Sheet.AutoFilter;
+            int startColumn = filter.Range.Column;
+
+            filter.Range.AutoFilter(TargetFile.amountCell.Column - startColumn + 1, "<>");
+            TargetFile.Sheet.Range["A1"].Activate();
+        }
+    }
+}
\ No newline at end of file