private void ucHoatDongASXH_Load(object sender, EventArgs e) { registerButtonArray(btnControl); deSearchTuNgay.Ex_FormatCustomDateEdit(); deSearchDenNgay.Ex_FormatCustomDateEdit(); deTuNgay.Ex_FormatCustomDateEdit(); deDenNgay.Ex_FormatCustomDateEdit(); seTongSoTien.Ex_FormatCustomSpinEdit(); seSoLuongNguoiThamGia.Ex_FormatCustomSpinEdit(); var current = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); var nextMonth = current.AddMonths(1); deSearchTuNgay.DateTime = current; deSearchDenNgay.DateTime = nextMonth.AddDays(-1); _listDMASXH = FuncCategory.loadDMASXH(); lueLoaiTapHuan.Properties.DataSource = _listDMASXH; lueLoaiTapHuan.EditValue = _id_loai; _changeLayout((CategoryASXH)_id_loai); FormStatus = EnumFormStatus.VIEW; }
private void _loadData() { WaitDialogForm _wait = new WaitDialogForm("Đang tải dữ liệu ...", "Vui lòng đợi giây lát"); context = new QL_HOIVIEN_KTEntities(); context.QL_HOATDONG_ASXH.Load(); var listDMHoiThao = FuncCategory.loadDMASXH(); var data = (from p in context.QL_HOATDONG_ASXH where deTuNgay.DateTime.Date <= p.ASXH_THOIGIAN_BATDAU && p.ASXH_THOIGIAN_BATDAU <= deDenNgay.DateTime.Date select p).ToList(); List <clsTongKetHoatDong> lists = new List <clsTongKetHoatDong>(); foreach (QL_HOATDONG_ASXH row in data) { clsTongKetHoatDong item = new clsTongKetHoatDong(); item.HD_ID = row.ASXH_ID; item.HD_TEN = row.ASXH_TEN; item.HD_THOIGIAN_BATDAU = row.ASXH_THOIGIAN_BATDAU; item.HD_THOIGIAN_KETTHUC = row.ASXH_THOIGIAN_KETTHUC; item.HD_THOIGIAN = FunctionHelper.formatFromDateToDate(row.ASXH_THOIGIAN_BATDAU, row.ASXH_THOIGIAN_KETTHUC); var dm = listDMHoiThao.Where(p => p.ID == row.ASXH_LOAI_ID).First(); if (dm != null) { item.HD_LOAI_STT = dm.STT; item.HD_LOAI = dm.NAME; } item.HD_NOIDUNG = row.ASXH_NOIDUNG; lists.Add(item); } rptBCTongKetHoatDong_ASXH rpt = new rptBCTongKetHoatDong_ASXH(); string tableName = "TongKetHoatDong"; DataTable dataPrint = FunctionHelper.ConvertToDataTable(lists); dataPrint.TableName = tableName; rpt.pLeftHeader.Value = clsParameter.pHospital; rpt.pParentLeftHeader.Value = clsParameter.pParentHospital; rpt.pTuNgayDenNgay.Value = FunctionHelper.formatFromDateToDate(deTuNgay.DateTime, deDenNgay.DateTime); //rpt.pTitleFooter.Value = ReportHelper.getTitleFooter(LoaiBaoCao.BM10); //rpt.pValueFooter.Value = ReportHelper.getValueFooter(LoaiBaoCao.BM10); rpt.DataSource = dataPrint; rpt.DataMember = tableName; printControl.PrintingSystem = rpt.PrintingSystem; rpt.CreateDocument(true); rptGlobal = rpt; _wait.Close(); }