diff options
Diffstat (limited to 'src/PriceListTools/Target.cs')
-rw-r--r-- | src/PriceListTools/Target.cs | 18 |
1 files changed, 13 insertions, 5 deletions
diff --git a/src/PriceListTools/Target.cs b/src/PriceListTools/Target.cs index a7e87ec..996a092 100644 --- a/src/PriceListTools/Target.cs +++ b/src/PriceListTools/Target.cs @@ -1,21 +1,29 @@ using Microsoft.Office.Interop.Excel; using System; +using System.Linq; namespace RehauSku.PriceListTools { internal class Target : PriceList { + private const string oldSkuHeader = "Прежний материал"; + public Range oldSkuCell { get; private set; } + public Target(Workbook workbook) { Sheet = workbook.ActiveSheet; Name = workbook.FullName; - amountCell = Sheet.Cells.Find(amountHeader); - skuCell = Sheet.Cells.Find(skuHeader); - groupCell = Sheet.Cells.Find(groupHeader); - nameCell = Sheet.Cells.Find(nameHeader); + Range[] cells = new[] + { + amountCell = Sheet.Cells.Find(amountHeader), + skuCell = Sheet.Cells.Find(skuHeader), + groupCell = Sheet.Cells.Find(groupHeader), + nameCell = Sheet.Cells.Find(nameHeader), + oldSkuCell = Sheet.Cells.Find(oldSkuHeader) + }; - if (amountCell == null || skuCell == null || groupCell == null || nameCell == null) + if (cells.Any(x => x == null)) { throw new ArgumentException($"Шаблон { Name } не является прайс-листом"); } |