private void btnInAn_DSLop_Click(object sender, EventArgs e)
{
try
{
SplashScreenManager.ShowForm(typeof(O2S_Common.Utilities.ThongBao.WaitForm_Wait));
if (cboLopHoc.SelectedValue != null)
{
List <reportExcelDTO> thongTinThem = new List <reportExcelDTO>();
//khoa hoc, lop hoc
int _KhoaHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString());
KHOAHOC _khoahoc = KhoaHocLogic.SelectSingle(_KhoaHocId);
int _lophocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString());
LOPHOC _lophoc = LopHocLogic.SelectSingle(_lophocId);
reportExcelDTO _item_makhoahoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.MAKHOAHOC,
value = _khoahoc.MaKhoaHoc,
};
thongTinThem.Add(_item_makhoahoc);
reportExcelDTO _item_tenkhoahoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.TENKHOAHOC,
value = _khoahoc.TenKhoaHoc,
};
thongTinThem.Add(_item_tenkhoahoc);
//
reportExcelDTO _item_malophoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.MALOPHOC,
value = _lophoc.MaLopHoc,
};
thongTinThem.Add(_item_malophoc);
reportExcelDTO _item_tenlophoc = new reportExcelDTO()
{
name = Base.bienTrongBaoCao.TENLOPHOC,
value = _lophoc.TenLopHoc,
};
thongTinThem.Add(_item_tenlophoc);
List <XepLopDTO> _lstXepLop = BangDiemLogic.SelectDSHV_Lop(_lophocId);
string fileTemplatePath = "FUN_XepLop_DanhSachLopHoc.xlsx";
DataTable _databaocao = O2S_Common.DataTables.Convert.ListToDataTable(_lstXepLop);
Utilities.Prints.PrintPreview.ShowPrintPreview_UsingExcelTemplate(fileTemplatePath, thongTinThem, _databaocao);
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
SplashScreenManager.CloseForm();
}
public void LoadDSHVCuaLop()
{
try
{
if (cboLopHoc.SelectedValue != null)
{
int _lophocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString());
List <XepLopDTO> _dsXepLopHocVien = BangDiemLogic.SelectDSHV_Lop(_lophocId);
gridControlDSHV.DataSource = _dsXepLopHocVien;
}
else
{
gridControlDSHV.DataSource = null;
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}
public void LoadDSHVLopChuaDu()
{
try
{
if (cboLopHoc.SelectedValue != null)
{
int _lophocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString());
this.dsXepLopHocVien = BangDiemLogic.SelectDSHV_Lop(_lophocId);
gridControlHV_XepLop.DataSource = this.dsXepLopHocVien;
}
else
{
gridControlHV_XepLop.DataSource = null;
}
lblTongCongHVLop.Text = string.Format("Tổng cộng: {0} học viên", gridViewHV_XepLop.RowCount);
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Warn(ex);
}
}