private void btnXuatExcel_ItemClick(object sender, ItemClickEventArgs e)
{
if (this.ActiveMdiChild == null)
{
ribbonIn.Enabled = false;
return;
}
if (this.ActiveMdiChild.Name == "TkbNgayLopForm")
{
TkbNgayLopForm frm = (TkbNgayLopForm)this.ActiveMdiChild;
frm.save();
}
else if (this.ActiveMdiChild.Name == "TkbHocKyLopForm")
{
TkbHocKyLopForm frm = (TkbHocKyLopForm)this.ActiveMdiChild;
frm.save();
}
else if (this.ActiveMdiChild.Name == "TkbTuanTruongForm")
{
TkbTuanTruongForm frm = (TkbTuanTruongForm)this.ActiveMdiChild;
frm.save();
}
else if (this.ActiveMdiChild.Name == "TkbHocKyTieuDoanForm")
{
TkbHocKyTieuDoanForm frm = (TkbHocKyTieuDoanForm)this.ActiveMdiChild;
frm.save();
}
else if (this.ActiveMdiChild.Name == "TkbNgayTatCaLopForm")
{
TkbNgayTatCaLopForm frm = (TkbNgayTatCaLopForm)this.ActiveMdiChild;
frm.save();
}
}
private void btnLamMoiTkb_ItemClick(object sender, ItemClickEventArgs e)
{
if (this.ActiveMdiChild.Name == "TKB_HK")
{
TkbHocKyLopForm frm = (TkbHocKyLopForm)this.ActiveMdiChild;
frm.loadData();
}
}
private void btnXemTKBHK_Click(object sender, EventArgs e)
{
if (Lop == null)
{
return;
}
TkbHocKyLopForm tKB_HK = new TkbHocKyLopForm(main, Lop, this);
tKB_HK.tietHocs = this.tietHocs;
tKB_HK.MdiParent = main;
tKB_HK.Show();
}
private async void btnXemTkbLop_ItemClick(object sender, ItemClickEventArgs e)
{
string choosed = cbxXemTheo.EditValue.ToString();
string str = txtTkbHocKy.EditValue == null ? "" : txtTkbHocKy.EditValue.ToString();
if (choosed == "Lớp")
{
Lop lop = await apis.GetLop(HocKy, str);
if (lop != null)
{
TkbHocKyLopForm tKB_HK = new TkbHocKyLopForm(this, lop);
tKB_HK.tietHocs = await apis.GetTietHocs(HocKy, lop, "");
tKB_HK.MdiParent = this;
tKB_HK.Show();
}
else
{
DialogResult dal = MessageBox.Show("Lớp không tồn tại", "Lỗi", MessageBoxButtons.OK);
}
}
else
{
TieuDoan td = await apis.GetTieuDoan(str);
if (td != null)
{
TkbHocKyTieuDoanForm frm = new TkbHocKyTieuDoanForm(this, str);
frm.lops = await apis.GetLopsByTieuDoan(HocKy, str);
frm.MdiParent = this;
frm.Show();
}
else
{
DialogResult dal = MessageBox.Show("Tiểu đoàn không tồn tại", "Lỗi", MessageBoxButtons.OK);
}
}
}
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++;
});
}
