private void _buildButton_Click ( object sender, EventArgs e ) { ListVariant currentVariant = (ListVariant)_variantBox.SelectedItem; try { Controller.DisableControls(); List <object[]> books = null; if (!Run ( () => { books = BuildBookList(currentVariant); } )) { return; } IDictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary.Add("books", books); using (ExcelForm excelForm = new ExcelForm()) { excelForm.ShowBooks ( Connection, currentVariant.FileName.ThrowIfNull(), currentVariant.Columns.ThrowIfNull(), dictionary, _header, books, _footer, currentVariant.FirstLine ); excelForm.ShowDialog(this); } } finally { Controller.EnableControls(); } }
private void excel测试ToolStripMenuItem_Click(object sender, EventArgs e) { ExcelForm frm = new ExcelForm(); if (CheckExist(frm) == true) { frm.Dispose(); frm = null; return; } frm.MdiParent = this; frm.WindowState = FormWindowState.Maximized; frm.Show(); }
} private void Spreadsheet_Click(object sender, EventArgs e) { progressBarControl1.EditValue = 0; if (comboBoxEditNewTerm.Properties.Items.Count == 0) { MessageBox.Show("Bitte suchen sie erstmal nach einem Suchbegriffe ", "Info"); } else { var comboBoxLanguage = this.comboBoxLanguage.SelectedItem as System.Globalization.CultureInfo; //int language = 1031; if (this.comboBoxLanguage.SelectedIndex >= 0) { // set a selected Language language = comboBoxLanguage.LCID; } //var d = (listBoxControl1.Tag as IEnumerable<ListItem>).ToList(); ExcelForm spreadsheet = new ExcelForm(allResults.ToList(), language, connect, this.progressBarControl1); spreadsheet.TopMost = true; spreadsheet.ShowDialog(this); } } private void NewSearch_Click(object sender, EventArgs e)
private List <object[]> BuildBookList ( ListVariant currentVariant ) { IComparer <ExemplarInfo> comparer; ListSort sort = null; this.InvokeIfRequired ( () => { sort = (ListSort)_sortBox.SelectedItem; } ); switch (sort.Field) { case "Description": comparer = ExemplarInfoComparer.ByDescription(); break; case "Number": comparer = ExemplarInfoComparer.ByNumber(); break; default: throw new ApplicationException ( "Unknown field: " + sort.Field.ToVisibleString() ); } ExemplarInfo[] array = ExemplarList .OrderBy(book => book, comparer) .ToArray(); int firstNumber = Convert.ToInt32(_firstNumberBox.Value); foreach (ExemplarInfo item in array) { item.SequentialNumber = firstNumber; firstNumber++; } List <object[]> books = new List <object[]>(array.Length); foreach (ExemplarInfo exemplar in array) { List <object> list = new List <object>(); foreach (ExcelColumn column in currentVariant.Columns) { object o = ReflectionUtility.GetPropertyValue ( exemplar, column.Expression ); list.Add(o); } books.Add(list.ToArray()); } ExcelForm.DummyMethod(); return(books); }