private void btn_Click(object sender, RoutedEventArgs e) { try { var txt = (sender as Button).Name; switch (txt) { case "query": var frmFilter = new FormListFilterPopup(); frmFilter.Filter = m_filter; frmFilter.Hide2(); frmFilter.FilterPopupEvent += (args) => { m_filter = args.Filter; m_lstTemplate = DataFactory.Instance.GetTemplateExecuter().GetExcelTemplate("利润表"); SheetModel = SheetModel; }; frmFilter.Show(); break; case "export": break; case "refresh": m_lstTemplate = DataFactory.Instance.GetTemplateExecuter().GetExcelTemplate("利润表"); SheetModel = SheetModel; break; case "formula": if (SheetModel == SheetModel.FORMULA) { SheetModel = SheetModel.DATA; } else { SheetModel = SheetModel.FORMULA; } break; } } catch (Exception ex) { Console.WriteLine(ex.ToString()); FinanceMessageBox.Error(ex.Message); } }
private void btn_Click(object sender, RoutedEventArgs e) { try { var txt = (sender as Button).Name; switch (txt) { case "query": var frmFilter = new FormListFilterPopup(); frmFilter.Filter = m_filter; frmFilter.Hide2(); frmFilter.FilterPopupEvent += (args) => { m_filter = args.Filter; m_lstTemplate = DataFactory.Instance.GetTemplateExecuter().GetExcelTemplate("利润表"); SheetModel = SheetModel; }; frmFilter.Show(); break; case "export": break; case "refresh": m_lstTemplate = DataFactory.Instance.GetTemplateExecuter().GetExcelTemplate("利润表"); SheetModel = SheetModel; break; case "formula": if (SheetModel == SheetModel.FORMULA) { SheetModel = SheetModel.DATA; } else { SheetModel = SheetModel.FORMULA; } break; case "exportformula": SaveFileDialog sflg = new SaveFileDialog(); sflg.Filter = "Excel(*.xls)|*.xls|Excel(*.xlsx)|*.xlsx"; sflg.FileName = "利润表"; var bRnt = sflg.ShowDialog(); if (bRnt == null || bRnt == false) { return; } ExcelExportor exportor = new ExcelExportor(new ProfitSheetExportHandler()); var dt = EntityConvertor <ExcelTemplateItem> .ToDataTable(m_lstTemplate); MemoryStream ms = new MemoryStream(); string flg = FileHelper.FileSuffix(sflg.FileName); exportor.Export(ms, dt, flg); using (FileStream fs = new FileStream(sflg.FileName, FileMode.Create, FileAccess.Write)) { byte[] data = ms.ToArray(); fs.Write(data, 0, data.Length); fs.Flush(); } ms.Close(); ms.Dispose(); FileHelper.ExplorePath(sflg.FileName.Substring(0, sflg.FileName.LastIndexOf("\\"))); break; case "importformula": OpenFileDialog ofd = new OpenFileDialog(); ofd.Filter = "Excel(*.xls)|*.xls|Excel(*.xlsx)|*.xlsx"; ofd.Title = "选择文件"; ofd.RestoreDirectory = true; if (ofd.ShowDialog() == true) { DataFactory.Instance.GetTemplateExecuter().UploadTemplate("ProfitSheet", ofd.FileName); FinanceMessageBox.Info("导入成功"); } break; } } catch (Exception ex) { Console.WriteLine(ex.ToString()); FinanceMessageBox.Error(ex.Message); } }