private void YamlToExcel(string[] fileNames)
{
if (fileNames == null)
{
return;
}
var fileBaseNames = fileNames.Select(fileName => Path.GetFileName(fileName));
var fileDirNames = fileNames.Select(fileName => Path.GetDirectoryName(fileName));
var fileDirName = fileDirNames.First();
if (!fileDirNames.All(_fileDirName => fileDirName == _fileDirName))
{
ShowMessageBox("同じフォルダにあるxlsxファイルのみにして下さい", "エラー");
return;
}
var setting = LoadSetting();
if (setting == null)
{
return;
}
var d = new FileSelectionDialog();
d.FileTypeMask = FileTypeMask.Directory;
d.DialogStyle = DialogStyle.FullApplicationModal;
d.PathMode = PathMode.Relative;
d.Directory = YamlToExcelTargetFolder;
d.CancelEvent += (x, y) => {
d.Destroy();
};
d.OkEvent += (x, y) => {
YamlToExcelTargetFolder = System.IO.Path.Combine(d.Directory, d.TextString);
SaveFormValues();
var options = new ToOptions();
options.files = fileBaseNames;
options.seedInput = SeedPath;
options.xlsxInput = fileDirName;
options.output = YamlToExcelTargetFolder;
options.columnNamesRow = setting.columnNamesRow;
options.dataStartRow = setting.dataStartRow;
options.engine = setting.engine;
options.ignoreColumns = setting.ignoreColumns;
options.ignore = setting.ignore;
options.only = setting.only;
options.subdivide = setting.subdivide;
options.mapping = setting.mapping;
options.versionColumn = setting.versionColumn;
options.requireVersion = setting.requireVersion;
options.delete = setting.delete;
options.seedExtension = setting.seedExtension;
options.calcFormulas = setting.calcFormulas;
d.Destroy();
var dialog = new YamlToExcelDialogX11(options);
this.Layout.Children.Add(dialog);
dialog.Popup(GrabOption.Exclusive);
};
this.Layout.Children.Add(d);
}
internal static void AddNewWidgetToCollection()
{
try
{
var filePath = FileSelectionDialog.GetFile();
if (String.IsNullOrEmpty(filePath))
{
Logger.LogMessage("Aborted: no file selected");
return;
}
if (!File.Exists(filePath))
{
Logger.LogMessage("Aborted: file no longer exists");
return;
}
if (Settings.Default.WidgetItemCollection.Any(r => r.FilePath == filePath))
{
Logger.LogMessage("Aborted: specified widget is alreday exists");
}
else
{
var newItem = new WidgetItem(filePath);
Settings.Default.WidgetItemCollection.Add(newItem);
Logger.LogMessage($"Added new widget for {filePath}");
}
}
catch (Exception ex)
{
Logger.LogError(ex);
}
}
private void SelectFile()
{
this.Text = "Excel Data Viewer";
FileSelectionDialog.Multiselect = false;
FileSelectionDialog.Filter = "Comma separated values|*.csv";
if (FileSelectionDialog.ShowDialog(this) == DialogResult.OK)
{
LoadData(FileSelectionDialog.FileName);
}
}
private void YamlToExcel(string[] fileNames)
{
if (fileNames == null)
{
return;
}
var fileBaseNames = fileNames.Select(fileName => Path.GetFileName(fileName));
var fileDirNames = fileNames.Select(fileName => Path.GetDirectoryName(fileName));
var fileDirName = fileDirNames.First();
if (!fileDirNames.All(_fileDirName => fileDirName == _fileDirName))
{
ShowMessageBox("同じフォルダにあるxlsxファイルのみにして下さい", "エラー");
return;
}
var setting = LoadSetting();
if (setting == null)
{
return;
}
var d = new FileSelectionDialog();
d.FileTypeMask = FileTypeMask.Directory;
d.DialogStyle = DialogStyle.FullApplicationModal;
d.PathMode = PathMode.Relative;
d.Directory = YamlToExcelTargetFolder;
d.CancelEvent += (x, y) => {
d.Destroy();
};
d.OkEvent += (x, y) => {
YamlToExcelTargetFolder = System.IO.Path.Combine(d.Directory, d.TextString);
SaveFormValues();
var options = setting.ToOptions(
files: fileBaseNames,
seedInput: SeedPath,
xlsxInput: fileDirName,
output: YamlToExcelTargetFolder
);
d.Destroy();
var dialog = new YamlToExcelDialogX11(options);
this.Layout.Children.Add(dialog);
dialog.Popup(GrabOption.Exclusive);
};
this.Layout.Children.Add(d);
}
private async Task OpenLastTimeUsedFilesDialog()
{
try
{
var files = PdfFiles.Where(x => x.IsFavorite == false).ToList().OrderBy(x => x.LastTimeOpened).ToList();
if (files.Count == 0)
{
var infoDialog = new MessageDialog("Es gibt noch keine Pdf-Dokumente, die schon einmal geöffnet wurden", "Information");
await infoDialog.ShowAsync();
return;
}
var models = Mapper.Map <List <PdfFile>, List <PdfFileModel> >(files);
var dialog = new FileSelectionDialog("Zuletzt verwendete Dateien", models);
var dialogResult = await dialog.ShowAsync();
if (dialogResult == ContentDialogResult.Primary)
{
if (dialog.Result != null)
{
var pdfFile = dialog.Result;
if (IsFileOpen(pdfFile.FullFilePath))
{
return;
}
PdfFiles.Where(x => x.FullFilePath == pdfFile.FullFilePath).FirstOrDefault().LastTimeOpened = DateTime.Now;
await SaveSettings(PdfFiles);
if (ContentFrame.Content is PdfViewerPageContent content)
{
var file = await OpenFile(pdfFile);
if (file != null)
{
content.LoadPdfViewer(file, pdfFile);
}
}
}
}
}
catch (Exception ex)
{
var errorDialog = new MessageDialog(ex.Message);
await errorDialog.ShowAsync();
}
}
private async Task OpenFavoriteFileDialog()
{
try
{
var files = PdfFiles.Where(x => x.IsFavorite == true).ToList().OrderBy(x => x.LastTimeOpened).ToList();
if (files.Count == 0)
{
var infoDialog = new MessageDialog("Die Favoritenliste ist noch leer", "Information");
await infoDialog.ShowAsync();
return;
}
var models = Mapper.Map <List <PdfFile>, List <PdfFileModel> >(files);
var dialog = new FileSelectionDialog("Favoritenliste", models);
var dialogResult = await dialog.ShowAsync();
if (dialogResult == ContentDialogResult.Primary)
{
if (dialog.Result != null)
{
var pdfFile = dialog.Result;
if (IsFileOpen(pdfFile.FullFilePath))
{
return;
}
PdfFiles.Where(x => x.FullFilePath == pdfFile.FullFilePath).FirstOrDefault().LastTimeOpened = DateTime.Now;
await SaveSettings(PdfFiles);
if (ContentFrame.Content is PdfViewerPageContent content)
{
var file = await OpenFile(pdfFile);
if (file != null)
{
content.LoadPdfViewer(file, pdfFile);
}
}
}
}
}
catch (Exception ex)
{
var errorDialog = new MessageDialog(ex.Message);
await errorDialog.ShowAsync();
}
}
private void seedPathButton_Click(object sender, TonNurako.Events.PushButtonEventArgs e)
{
var d = new FileSelectionDialog();
d.FileTypeMask = FileTypeMask.Directory;
d.DialogStyle = DialogStyle.FullApplicationModal;
d.PathMode = PathMode.Relative;
d.Directory = SeedPath;
d.OkEvent += (x, y) => {
SeedPath = System.IO.Path.Combine(d.Directory, d.TextString);
d.Destroy();
};
d.CancelEvent += (x, y) => {
d.Destroy();
};
this.Layout.Children.Add(d);
}
private void settingPathButton_Click(object sender, TonNurako.Events.PushButtonEventArgs e)
{
var d = new FileSelectionDialog();
d.FileTypeMask = FileTypeMask.Regular;
d.DialogStyle = DialogStyle.FullApplicationModal;
d.PathMode = PathMode.Relative;
if (SettingPath != null && SettingPath.Length > 0)
{
d.Directory = Path.GetDirectoryName(SettingPath);
}
d.OkEvent += (x, y) => {
SettingPath = System.IO.Path.Combine(d.Directory, d.TextString);
d.Destroy();
};
d.CancelEvent += (x, y) => {
d.Destroy();
};
this.Layout.Children.Add(d);
}
private void BrowseDatasheet_Click_1(object sender, RoutedEventArgs e)
{
FileSelectionDialog datasheetFilebroser = new FileSelectionDialog();
datasheetFilebroser.Title = "Please select the datasheet";
datasheetFilebroser.CheckFileExists = true;
datasheetFilebroser.ShowDialog();
if (datasheetFilebroser.DialogResult == MessageBoxResult.OK)
{
if (ORM.SelectedItem is Part)
{
Part sel = (Part)ORM.SelectedItem;
Datasheet ds = sel.Datasheet;
if (ds == null)
{
ds = new Datasheet();
context.Datasheets.Add(ds);
sel.Datasheet = ds;
}
sel.Datasheet.FileName = datasheetFilebroser.FileName;
}
}
}
/// <summary>
/// Вызов диалога выбора текстового файла.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void FileSelectionButton_Click(object sender, EventArgs e)
{
FileSelectionDialog.ShowDialog();
}
private async void ButtonNewPivotItem_Click(object sender, RoutedEventArgs e)
{
var dialog = new FileSelectionDialog(Folder);
await dialog.ShowAsync();
}
