コード例 #1
0
        private void ucHoatDongHoiThaoTapHuan_Load(object sender, EventArgs e)
        {
            registerButtonArray(btnControl);

            deSearchTuNgay.Ex_FormatCustomDateEdit();
            deSearchDenNgay.Ex_FormatCustomDateEdit();
            deTuNgay.Ex_FormatCustomDateEdit();
            deDenNgay.Ex_FormatCustomDateEdit();

            seThuLaoGV.Ex_FormatCustomSpinEdit();
            seThuLaoHoTro.Ex_FormatCustomSpinEdit();
            seSoLuongNguoiThamGia.Ex_FormatCustomSpinEdit();
            seSoTienMoiNguoi.Ex_FormatCustomSpinEdit();
            seTongTien.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);

            lueLoaiTapHuan.Properties.DataSource = FuncCategory.loadDMTapHuan();
            lueLoaiTapHuan.EditValue             = _id_loai;

            _changeLayout((CategoryTapHuan)_id_loai);

            FormStatus = EnumFormStatus.VIEW;
        }
コード例 #2
0
        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_TAPHUAN.Load();
            var listDMHoiThao = FuncCategory.loadDMTapHuan();

            var data = (from p in context.QL_HOATDONG_TAPHUAN
                        where deTuNgay.DateTime.Date <= p.TH_THOIGIAN_BATDAU &&
                        p.TH_THOIGIAN_BATDAU <= deDenNgay.DateTime.Date
                        select p).ToList();

            List <clsTongKetHoatDong> lists = new List <clsTongKetHoatDong>();

            foreach (QL_HOATDONG_TAPHUAN row in data)
            {
                clsTongKetHoatDong item = new clsTongKetHoatDong();
                item.HD_ID               = row.TH_ID;
                item.HD_TEN              = row.TH_TEN;
                item.HD_THOIGIAN_BATDAU  = row.TH_THOIGIAN_BATDAU;
                item.HD_THOIGIAN_KETTHUC = row.TH_THOIGIAN_KETTHUC;
                //item.HD_DIADIEM = row.TH_DIADIEM;
                //item.HD_TONGTIEN = row.TH_TONGTIEN??0;
                //item.HD_SONGUOI_THAMGIA = row.TH_SOLUONG??0;
                item.HD_THOIGIAN = FunctionHelper.formatFromDateToDate(row.TH_THOIGIAN_BATDAU, row.TH_THOIGIAN_KETTHUC);
                var dm = listDMHoiThao.Where(p => p.ID == row.TH_LOAI_ID).First();
                if (dm != null)
                {
                    item.HD_LOAI_STT = dm.STT;
                    item.HD_LOAI     = dm.NAME;
                }
                item.HD_NOIDUNG = row.TH_NOIDUNG;
                lists.Add(item);
            }

            rptBCTongKetHoatDong_NangCaoNangLucVaVanDongChinhSach rpt = new rptBCTongKetHoatDong_NangCaoNangLucVaVanDongChinhSach();
            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();
        }
コード例 #3
0
        private void btnControl_btnEventView_Click(object sender, EventArgs e)
        {
            List <clsBCHoatDongTheoDieuKien> listData = new List <clsBCHoatDongTheoDieuKien>();

            if (deTuNgay.EditValue == null || deDenNgay.EditValue == null)
            {
                clsMessage.MessageWarning("Vui lòng nhập điều kiện tìm kiếm");
                return;
            }
            else if (deTuNgay.DateTime.Date > deDenNgay.DateTime.Date)
            {
                clsMessage.MessageWarning("Thời gian tìm kiếm không phù hợp");
                return;
            }

            WaitDialogForm        _wait       = new WaitDialogForm("Đang tải dữ liệu ...", "Vui lòng đợi giây lát");
            QL_HOIVIEN_KTEntities context     = new QL_HOIVIEN_KTEntities();
            List <QL_HOIVIEN>     listHoiVien = context.QL_HOIVIEN.ToList();

            string hoiVienId = lueSearchHoiVien.EditValue + string.Empty;
            //Tập huấn
            var listDayNgheData = (from p in context.QL_HOATDONG_TAPHUAN
                                   let diadiem = p.QL_HOATDONG_TAPHUAN_DIADIEM.FirstOrDefault()
                                                 where deTuNgay.DateTime.Date <= p.TH_THOIGIAN_BATDAU &&
                                                 p.TH_THOIGIAN_BATDAU <= deDenNgay.DateTime.Date &&
                                                 p.TH_DOITUONG_HV_ID.Contains(hoiVienId)
                                                 select new clsBCHoatDongTheoDieuKien
            {
                HD_LOAI_ID = p.TH_LOAI_ID,
                HD_THOIGIAN_BATDAU = p.TH_THOIGIAN_BATDAU,
                HD_THOIGIAN_KETTHUC = p.TH_THOIGIAN_KETTHUC,
                HD_TEN = p.TH_TEN,
                HD_DIADIEM = diadiem.TH_DD_TEN,
                HD_DONVI_PHUTRACH = p.TH_DONVI_PHUTRACH,
                HD_DONVI_TAITRO = p.NTT_TEN,
            }
                                   ).ToList();

            listData.AddRange(listDayNgheData);

            listData = listData.OrderBy(p => p.HD_LOAI).OrderBy(p => p.HD_THOIGIAN_BATDAU).ToList();
            List <dynamicObject> listDm = FuncCategory.loadDMTapHuan();

            foreach (var item in listData)
            {
                var rowCategory = listDm.Where(p => p.ID == item.HD_LOAI_ID).FirstOrDefault();
                item.HD_LOAI = rowCategory != null ? rowCategory.NAME : "";
                item.HD_NGAY = item.HD_THOIGIAN_BATDAU.Value.Date.ToString("dd/MM/yyyy") + " - " + item.HD_THOIGIAN_KETTHUC.Value.Date.ToString("dd/MM/yyyy");
            }
            gcGrid.DataSource = listData;

            _wait.Close();
        }