/// <summary> /// 导出数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private async void BtnExport_ClickAsync(object sender, RoutedEventArgs e) { Button CurBtn = sender as Button; List <Lib.MemberInfoEntity> MemberList = await DataMemberRepository.ReadMembers(new MemberSearch() { }); if (MemberList == null) { return; } System.Windows.Forms.SaveFileDialog fileDialog = new System.Windows.Forms.SaveFileDialog(); fileDialog.Filter = "Excel|*.xls"; if (fileDialog.ShowDialog() == System.Windows.Forms.DialogResult.Cancel) { return; } try { CurBtn.IsEnabled = false; OperationMsg = "正在导出人员信息,请稍候...."; await Task.Run(() => { NpoiExcel.ExportExcels(fileDialog.FileName, "员工信息", MemberList); }); OperationMsg = $"人员信息导出....完成,文件为[{fileDialog.FileName}]。"; CurBtn.IsEnabled = true; } catch (Exception Ex) { AppFuns.ShowMessage(Ex.Message, Caption: "失败"); CurBtn.IsEnabled = true; } }
/// <summary> /// 导出数据。 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Export_ClickAsync(object sender, RoutedEventArgs e) { List <Lib.MemberInfoEntity> EntityList = _PageViewModel.EntityList.ToList(); if (EntityList == null || EntityList.Count < 1) { return; } System.Windows.Forms.SaveFileDialog fileDialog = new System.Windows.Forms.SaveFileDialog(); fileDialog.Filter = "Excel|*.xls"; if (fileDialog.ShowDialog() == System.Windows.Forms.DialogResult.Cancel) { return; } try { NpoiExcel.ExportExcels(fileDialog.FileName, "员工信息", EntityList); AppFuns.ShowMessage("数据导出成功!", Caption: "完成"); } catch (Exception Ex) { AppFuns.ShowMessage(Ex.Message, Caption: "失败"); } }