114 lines
3.6 KiB
C#
114 lines
3.6 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Drawing;
|
|
using System.Windows.Forms;
|
|
using System.IO;
|
|
using NPOI.SS.UserModel;
|
|
using NPOI.XSSF.UserModel;
|
|
using NPOI.SS.Util;
|
|
using NPOIBorderStyle = NPOI.SS.UserModel.BorderStyle;
|
|
using NPOIHorizontalAlignment = NPOI.SS.UserModel.HorizontalAlignment;
|
|
|
|
namespace WindowsFormsApp6
|
|
{
|
|
public partial class MainForm : Form
|
|
{
|
|
private Form1 form1Instance;
|
|
private Form2 form2Instance;
|
|
private Form3 form3Instance;
|
|
|
|
public MainForm()
|
|
{
|
|
InitializeComponent();
|
|
InitializeTabControl();
|
|
InitializeEmbeddedForms();
|
|
}
|
|
|
|
private void InitializeTabControl()
|
|
{
|
|
tabControl1.SelectedIndexChanged += TabControl1_SelectedIndexChanged;
|
|
}
|
|
|
|
private void TabControl1_SelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
}
|
|
|
|
private void InitializeEmbeddedForms()
|
|
{
|
|
form1Instance = new Form1();
|
|
form1Instance.TopLevel = false;
|
|
form1Instance.FormBorderStyle = FormBorderStyle.None;
|
|
form1Instance.Dock = DockStyle.Fill;
|
|
tabPage1.Controls.Add(form1Instance);
|
|
form1Instance.Show();
|
|
|
|
form2Instance = new Form2();
|
|
form2Instance.TopLevel = false;
|
|
form2Instance.FormBorderStyle = FormBorderStyle.None;
|
|
form2Instance.Dock = DockStyle.Fill;
|
|
tabPage2.Controls.Add(form2Instance);
|
|
form2Instance.Show();
|
|
|
|
form3Instance = new Form3();
|
|
form3Instance.TopLevel = false;
|
|
form3Instance.FormBorderStyle = FormBorderStyle.None;
|
|
form3Instance.Dock = DockStyle.Fill;
|
|
tabPage3.Controls.Add(form3Instance);
|
|
form3Instance.Show();
|
|
}
|
|
|
|
private void buttonPrint_Click(object sender, EventArgs e)
|
|
{
|
|
MessageBox.Show("打印功能开发中", "提示");
|
|
}
|
|
|
|
private void buttonExport_Click(object sender, EventArgs e)
|
|
{
|
|
SaveFileDialog saveFileDialog = new SaveFileDialog
|
|
{
|
|
Filter = "Excel 文件 (*.xlsx)|*.xlsx",
|
|
FileName = $"测试报告_{DateTime.Now:yyyyMMdd_HHmmss}",
|
|
Title = "导出整合报告"
|
|
};
|
|
|
|
if (saveFileDialog.ShowDialog() == DialogResult.OK)
|
|
{
|
|
ExportIntegratedReport(saveFileDialog.FileName);
|
|
}
|
|
}
|
|
|
|
private void ExportIntegratedReport(string filePath)
|
|
{
|
|
try
|
|
{
|
|
IWorkbook workbook = new XSSFWorkbook();
|
|
CreateForm1Sheet(workbook);
|
|
CreateForm2Sheet(workbook);
|
|
CreateForm3Sheet(workbook);
|
|
|
|
using (FileStream fs = new FileStream(filePath, FileMode.Create, FileAccess.Write))
|
|
{
|
|
workbook.Write(fs);
|
|
}
|
|
|
|
MessageBox.Show($"导出成功：{filePath}", "成功");
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
MessageBox.Show($"导出失败：{ex.Message}", "错误");
|
|
}
|
|
}
|
|
|
|
private void MainForm_FormClosing(object sender, FormClosingEventArgs e)
|
|
{
|
|
Application.Exit();
|
|
}
|
|
|
|
private void CreateForm1Sheet(IWorkbook workbook) { }
|
|
private void CreateForm2Sheet(IWorkbook workbook) { }
|
|
private void CreateForm3Sheet(IWorkbook workbook) { }
|
|
private (ICellStyle, ICellStyle, ICellStyle, ICellStyle) CreateReportStyles(IWorkbook workbook) { return (null, null, null, null); }
|
|
private void SetBorders(ICellStyle style) { }
|
|
}
|
|
}
|