private void btnLamMoiTkb_ItemClick(object sender, ItemClickEventArgs e)
{
if (this.ActiveMdiChild.Name == "TKB_HK")
{
TkbHocKyLopForm frm = (TkbHocKyLopForm)this.ActiveMdiChild;
frm.loadData();
}
}
private void TkbHocKyTieuDoanForm_Load(object sender, EventArgs e)
{
if (lops == null)
{
return;
}
if (lops.Count == 0)
{
return;
}
this.Text = $"Thời khoá biểu tiểu đoàn {tieuDoan}";
//Mở file
using (FileStream stream = new FileStream("TKBHK_Lop_template.xlsx", FileMode.Open))
{
xlsxViewer.LoadDocument(stream, DocumentFormat.Xlsx);
wb = xlsxViewer.Document;
}
//Copy đủ sheet lớp
int i = 1;
lops.ForEach(async(lop) =>
{
TkbHocKyLopForm frm = new TkbHocKyLopForm(main, lop);
frm.tietHocs = await apis.GetTietHocs(main.HocKy, lop, "");
frm.loadData();
IWorkbook wb_temp = frm.wb;
wb.Worksheets.Add();
wb.Worksheets[i].CopyFrom(wb_temp.Worksheets[0]);
wb.Worksheets[i].Name = lop.ten;
wb.Worksheets["TKB_HK"].Visible = false;
frm.Close();
frm = null;
i++;
});
}
