private void BtnExport_Click(object sender, EventArgs e)
{
string start = Convert.ToDateTime(dtpStart.Text.Trim()).ToString("yyyyMMddHHmm");
string end = Convert.ToDateTime(dtpEnd.Text.Trim()).ToString("yyyyMMddHHmm");
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "XLS文件(*.xls)|*.xls|所有文件|*.*";//设置保存文件的类型
sfd.InitialDirectory = "D:\\";
//sfd.FileName = DateTime.Now.ToString("yyyyMMddHHmmss") + "测量数据表";
//sfd.FileName = DateTime.Now.ToString("yyyyMMddHHmmss");
sfd.FileName = start + "-" + end;
sfd.DefaultExt = "xls";
sfd.AddExtension = true;
if (Dgv.Rows.Count > 65535)
{
MessageBox.Show("报表导出失败！,原因是表格行数超过65535", "报表导出");
return;
}
if (sfd.ShowDialog() == DialogResult.OK)
{
if (NiceExcelSaveAndRead.SaveToExcelNew(sfd.FileName, this.Dgv))
{
LogHelper.WriteLog($" {CommonMethods.objAdmins.LoginName}导出数据报表");
MessageBox.Show("报表导出成功！", "报表导出");
}
else
{
LogHelper.WriteLog($" {CommonMethods.objAdmins.LoginName}导出数据失败");
MessageBox.Show("报表导出失败！", "报表导出");
}
}
}
private void btn_Export_Click(object sender, EventArgs e)
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "XLS文件(*.xls)|*.xls|所有文件|*.*";//设置保存文件的类型
sfd.FileName = "历史日志导出Excel";
sfd.DefaultExt = "xls";
sfd.AddExtension = true;
if (sfd.ShowDialog() == DialogResult.OK)
{
if (NiceExcelSaveAndRead.SaveToExcelNew(sfd.FileName, this.dgv_Log))
{
MessageBox.Show("报警历史日志导出成功！", "日志导出");
LogHelper.WriteLog(CommonMethods.objAdmins.LoginName + "导出报警日志");
}
else
{
MessageBox.Show("历史日志导出失败！", "日志导出");
LogHelper.WriteLog("FrmAlarm按钮btn_Export导出故障记录失败");
}
}
}