/// <summary>
/// 数据导出
/// </summary>
public void DataTableToExcel()
{
string path = string.Empty;
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Execl 表格文件 (*.xls)|*.xls";
saveFileDialog.FilterIndex = 0;
saveFileDialog.RestoreDirectory = true;
saveFileDialog.CreatePrompt = false;
saveFileDialog.Title = "导出Excel文件";
//设置默认文件名称
saveFileDialog.FileName = "报表-" + DateTime.Now.ToString("yyyyMMdd-HHmmss") + ".xls";
if (saveFileDialog.ShowDialog() != System.Windows.Forms.DialogResult.OK)
{
return;
}
if (saveFileDialog.FileName == "")
{
return;
}
Task ta = Task.Factory.StartNew(delegate { DoExcelHelper.GetInstance().DataTableToExcel(EventClass.GetInstance()._gloabledataTable, saveFileDialog.FileName, "Table1"); });
Task.WaitAny(ta);
//DoExcelHelper.GetInstance().DataGridtoExcelModify(EventClass.GetInstance()._gloabledataTable);
}
/// <summary>
/// 数据导入
/// </summary>
public void ImportExcelToDataTable()
{
EventClass.GetInstance().tb = EventClass.GetInstance()._temptb
= DoExcelHelper.GetInstance().ImportExcelToDataTable("readdataTable");
//if(EventClass.GetInstance()._temptb.Rows.Count != 0)
//{
// MessageBox.Show("导入数据成功");
//}
}
