/// <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: "失败");
}
}
