private void infoout_Click(object sender, RoutedEventArgs e)
{
List <ToolModel> tl = (List <ToolModel>) this.dataGrid1.ItemsSource;
if (tl == null || tl.Count <= 0)
{
return;
}
WrenchExcelOut weo = new WrenchExcelOut();
SaveFileDialog saveFileDialog = new SaveFileDialog();
ExcelHelp _excelHelper = new ExcelHelp();
saveFileDialog.Filter = "Excel (*.XLS)|*.xls";
if ((bool)(saveFileDialog.ShowDialog()))
{
try
{
_excelHelper.SaveToExcel(saveFileDialog.FileName, weo.ToTable(tl));
MessageBox.Show("导出成功");
}
catch (Exception ex)
{
MessageBox.Show("导出失败！");
return;
}
}
}
private void bt_dataout_Click(object sender, RoutedEventArgs e)
{
List <BorrowHistory> tl = (List <BorrowHistory>) this.gd_borrow.ItemsSource;
if (tl == null || tl.Count <= 0)
{
return;
}
SaveFileDialog saveFileDialog = new SaveFileDialog();
BorrowOutToExcel uoe = new BorrowOutToExcel();
ExcelHelp _excelHelper = new ExcelHelp();
saveFileDialog.Filter = "Excel (*.xls)|*.XLS";
if ((bool)(saveFileDialog.ShowDialog()))
{
try
{
_excelHelper.SaveToExcel(saveFileDialog.FileName, uoe.ToTable(tl));
}
catch (Exception ex)
{
MessageBox.Show("导出失败：" + ex.Message);
return;
}
MessageBox.Show("导出成功");
}
}
private void ExportCmdExcute(object param)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Excel (*.XLS)|*.xls";;
if ((bool)(saveFileDialog.ShowDialog()))
{
try
{
_excelHelper.SaveToExcel(saveFileDialog.FileName, _dataGridSource.Table);
}
catch (Exception ex)
{
MessageBox.Show("导出失败：" + ex.Message);
}
MessageBox.Show("导出成功");
}
}