void btnExportReport_Click(object sender, EventArgs e)
{
try
{
lable_message.Text = "正在导出，请稍等...";
lable_message.Visible = true;
DateTime datetime = datePickerReporing.Value;
//string filePath = Miscellaneous.GetExcelsFileFullPath(string.Format("绩效统计-{0}.xlsx", datetime.ToString("yyyy-MM")));
string filePath = Miscellaneous.GetExcelsFileFullPath(string.Format("绩效统计-{0}.xls", datetime.ToString("yyyy-MM")));
DataTable dt = DatagridviewHelper.ConvertDataGridViewToTable(dataGridReporting);
ExcelHelper.WriteExcel(filePath, this.dataGridReporting);
MessageBox.Show("导出成功", "提示消息");
}
catch (Exception ex)
{
MessageBox.Show("导出失败:" + ex.Message, "操作失败");
}
finally {
lable_message.Text = string.Empty;
lable_message.Visible = false;
}
}
