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++; }); }