diff options
| -rw-r--r-- | src/PriceListTools/PriceListTool.cs | 21 | ||||
| -rw-r--r-- | src/Ribbon/RibbonController.cs | 12 |
2 files changed, 32 insertions, 1 deletions
diff --git a/src/PriceListTools/PriceListTool.cs b/src/PriceListTools/PriceListTool.cs index cbae4d9..918b6de 100644 --- a/src/PriceListTools/PriceListTool.cs +++ b/src/PriceListTools/PriceListTool.cs @@ -6,6 +6,27 @@ using System.Linq; namespace RehauSku.PriceListTools { + internal class ConvertTool : PriceListTool + { + private Source Current; + + public void GetCurrent() + { + Current = new Source(ExcelApp.ActiveWorkbook); + } + + public void FillTarget() + { + ExcelApp.ScreenUpdating = false; + FillColumn(Current.SkuAmount, TargetFile.amountCell.Column); + FilterByAmount(); + ExcelApp.ScreenUpdating = true; + + Forms.Dialog.SaveWorkbookAs(); + } + } + + internal abstract class PriceListTool { protected private Application ExcelApp = (Application)ExcelDnaUtil.Application; diff --git a/src/Ribbon/RibbonController.cs b/src/Ribbon/RibbonController.cs index b00e23a..99f44df 100644 --- a/src/Ribbon/RibbonController.cs +++ b/src/Ribbon/RibbonController.cs @@ -20,13 +20,14 @@ namespace RehauSku.Ribbon <tab id='rau' label='REHAU'> <group id='priceList' label='Прайс-лист'> <button id='exportToPrice' label='Экспорт в новый файл' size='normal' imageMso='PivotExportToExcel' onAction='OnExportPressed'/> + <button id='convertPrice' label='Обновить прайс-лист' size='normal' imageMso='FileUpdate' onAction='OnConvertPressed'/> <menu id='conjoinMenu' label='Объединить' imageMso='Copy'> <button id='mergeFiles' label='Сложить' onAction='OnMergePressed'/> <button id='combineFiles' label='По колонкам' onAction='OnCombinePressed'/> </menu> </group> <group id='rausettings' label='Настройки'> - <button id='setPriceList' label='Файл прайс-листа' size='large' imageMso='CurrentViewSettings' onAction='OnSetPricePressed'/> + <button id='setPriceList' label='Указать путь к шаблону' size='large' imageMso='CurrentViewSettings' onAction='OnSetPricePressed'/> </group> </tab> </tabs> @@ -80,6 +81,15 @@ namespace RehauSku.Ribbon } } + public void OnConvertPressed(IRibbonControl control) + { + ConvertTool convertTool = new ConvertTool(); + + convertTool.GetCurrent(); + convertTool.OpenNewPrice(); + convertTool.FillTarget(); + } + public void OnSetPricePressed(IRibbonControl control) { string path = Dialog.GetFilePath(); |