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