private void ucHoatDongHNXH_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); _listDM = FuncCategory.loadDMHNXH(); lueLoaiTapHuan.Properties.DataSource = _listDM; lueLoaiTapHuan.EditValue = _id_loai; _changeLayout((CategoryHNXH)_id_loai); FormStatus = EnumFormStatus.VIEW; }
private void ucUser_Load(object sender, EventArgs e) { initData(); base.registerButtonArray(btnControl); repLueFucnName.DataSource = FuncCategory.loadFunctionName(); FormStatus = EnumFormStatus.VIEW; }
private void frmNhaTaiTro_V2_Load(object sender, EventArgs e) { lueCaNhanToChuc.Properties.DataSource = FuncCategory.loadDMCaNhanToChuc(); FuncCategory.loadCategoryByName(CategoryEntitiesTable.DM_NHA_TAI_TRO_LOAI, lueLoaiNhaTaiTro); seSoTien.Ex_FormatCustomSpinEdit(); FormStatus = EnumFormStatus.VIEW; }
private void ucBCHoiVienTongNKTTheoTrinhDoHocVan_Load(object sender, EventArgs e) { registerButtonArray(btnControl); FuncCategory.loadCategoryByName(CategoryEntitiesTable.DM_TINH, lueThanhPho); LibraryDev.PermissionButton(btnControl, previewBar1); lueThanhPho.Properties.PopupFormMinSize = lueThanhPho.Size; _loadData(); }
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(); }
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(); }
private void frmNhaTaiTro_Load(object sender, EventArgs e) { FuncCategory.loadCategoryByName(CategoryEntitiesTable.DM_GIOITINH, lueGioiTinh); FunctionHelper.dateFormat(deNgayCap_Nam, deNgayCap_Thang, deNgayCap_Ngay); seThuLao_1.Ex_FormatCustomSpinEdit(); seThuLao_2.Ex_FormatCustomSpinEdit(); seThuLao_3.Ex_FormatCustomSpinEdit(); seThuLao_4.Ex_FormatCustomSpinEdit(); string tinhTrangKT_Value = lueDangTat.EditValue + string.Empty; lueDangTat.Ex_SetDataSource(CategoryEntitiesTable.DM_KHUYETTAT_TINHTRANG.Ex_ToString()); lueDangTat.EditValue = tinhTrangKT_Value; lueDangTat.RefreshEditValue(); FuncCategory.loadCategoryByName(CategoryEntitiesTable.DM_DOITUONG2, lueDoiTuong); _changeLayout((CategoryTapHuanChiTietLoai)_loai_id); FormStatus = EnumFormStatus.VIEW; }
private void ucBaoCaoHoiVienTheoDieuKien_Load(object sender, EventArgs e) { btnControl_btnEventView_Click(null, null); foreach (var item in grpDisplayColumn.Controls) { CheckEdit chk = item as CheckEdit; if (item != null) { chk.Checked = true; chk.CheckedChanged += new System.EventHandler(this.DisplayColumn_CheckedChanged); } } FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_GIOITINH, repLueGioiTinh); FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_DANTOC, repLueDanToc); FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_TONGIAO, repLueTonGiao); FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_NGHE_NGHIEP, repLueNgheNghiep); FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_TRINH_DO_HOC_VAN, repLueTrinhDoVanHoa); FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_TRINH_DO_CHUYEN_MON, repLueTrinhDoChuyenMon); FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_CHUCVU_HOI, repLueChucVu); FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_XA, repLueThuongTru_Phuong); FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_HUYEN, repLueThuongTru_Quan); FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_TINH, repLueThuongTru_ThanhPho); FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_XA, repLueTamTru_Phuong); FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_HUYEN, repLueTamTru_Quan); FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_TINH, repLueTamTru_ThanhPho); FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_KHUYETTAT_MUCDO, repLueMucDo); FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_KHUYETTAT_TINHTRANG, repLueKTTinhTrang); FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_KHUYETTAT_NGUYENNHAN, repLueKTNguyenNhan); FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_PHUONGTIEN_DILAI, repLuePhuongTienDiLai); FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_TINHTRANG_HONNHAN, repLueHonNhan); FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_DOITUONG, repLueDoiTuong); }
private void frmHoatDongDayNgheDoiTuongKhac_Load(object sender, EventArgs e) { FuncCategory.loadCategoryByName(CategoryEntitiesTable.DM_GIOITINH, lueGioiTinh); FunctionHelper.dateFormat(deNgayCap_Nam, deNgayCap_Thang, deNgayCap_Ngay); FormStatus = EnumFormStatus.VIEW; }
private void lueQuan_EditValueChanged(object sender, EventArgs e) { FuncCategory.loadDMXa(luePhuong, lueQuan.EditValue + string.Empty); luePhuong.EditValue = null; }
private void lueThanhPho_EditValueChanged(object sender, EventArgs e) { FuncCategory.loadDMHuyen(lueQuan, lueThanhPho.EditValue + string.Empty); }
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_DAYNGHE.Load(); //Dạy nghề var data = (from p in context.QL_HOATDONG_DAYNGHE where deTuNgay.DateTime.Date <= p.DN_THOIGIAN_BATDAU && p.DN_THOIGIAN_BATDAU <= deDenNgay.DateTime.Date select p).ToList(); List <clsTongKetHoatDong> lists = new List <clsTongKetHoatDong>(); foreach (QL_HOATDONG_DAYNGHE row in data) { clsTongKetHoatDong item = new clsTongKetHoatDong(); item.HD_ID = row.DN_ID; item.HD_TEN = row.DN_NGHE; item.HD_THOIGIAN_BATDAU = row.DN_THOIGIAN_BATDAU; item.HD_THOIGIAN_KETTHUC = row.DN_THOIGIAN_KETTHUC; item.HD_DIADIEM = row.DN_DIADIEM; item.HD_SONGUOI_THAMGIA = row.DN_SOLUONG_NU ?? 0; item.HD_SONGUOI_NU_TONGSO = string.Format("{0}/{1}", row.DN_SOLUONG_NU, row.DN_SOLUONG); item.HD_THOIGIAN = FunctionHelper.formatFromDateToDate(row.DN_THOIGIAN_BATDAU, row.DN_THOIGIAN_KETTHUC); item.HD_LOAI_STT = 1; item.HD_LOAI = "Việc làm"; item.HD_NOIDUNG = row.DN_NOIDUNG; lists.Add(item); } //Giai quyet viẹc lam context.QL_HOATDONG_VIECLAM.Load(); var listDMViecLam = FuncCategory.loadDMViecLam(); var dataViecLam = (from p in context.QL_HOATDONG_VIECLAM where deTuNgay.DateTime.Date <= p.VL_THOIGIAN_BATDAU && p.VL_THOIGIAN_BATDAU <= deDenNgay.DateTime.Date select p).ToList(); foreach (QL_HOATDONG_VIECLAM row in dataViecLam) { clsTongKetHoatDong item = new clsTongKetHoatDong(); item.HD_ID = row.VL_ID; item.HD_TEN = row.VL_TEN; item.HD_THOIGIAN_BATDAU = row.VL_THOIGIAN_BATDAU; item.HD_THOIGIAN_KETTHUC = row.VL_THOIGIAN_KETTHUC; item.HD_DIADIEM = row.VL_DIADIEM; item.HD_SONGUOI_THAMGIA = row.VL_SOLUONG_NU ?? 0; item.HD_SONGUOI_NU_TONGSO = string.Format("{0}/{1}", row.VL_SOLUONG_NU, row.VL_SOLUONG); item.HD_THOIGIAN = FunctionHelper.formatFromDateToDate(row.VL_THOIGIAN_BATDAU, row.VL_THOIGIAN_KETTHUC); var dm = listDMViecLam.Where(p => p.ID == row.VL_LOAI_ID).FirstOrDefault(); if (dm != null) { item.HD_LOAI_STT = 2; item.HD_LOAI = dm.NAME; } item.HD_NOIDUNG = row.VL_NOIDUNG; lists.Add(item); } //vay vốn context.QL_HOATDONG_VIECLAM.Load(); var dataVayVon = (from p in context.QL_HOATDONG_VAYVON where deTuNgay.DateTime.Date <= p.VV_THOIGIAN_BATDAU && p.VV_THOIGIAN_BATDAU <= deDenNgay.DateTime.Date select p).ToList(); foreach (QL_HOATDONG_VAYVON row in dataVayVon) { clsTongKetHoatDong item = new clsTongKetHoatDong(); item.HD_ID = row.VV_ID; item.HD_TEN = row.VV_TEN; item.HD_THOIGIAN_BATDAU = row.VV_THOIGIAN_BATDAU; item.HD_THOIGIAN_KETTHUC = row.VV_THOIGIAN_KETTHUC; item.HD_DIADIEM = row.VV_DIADIEM; item.HD_SONGUOI_THAMGIA = row.VV_SOLUONG_NU ?? 0; item.HD_SONGUOI_NU_TONGSO = string.Format("{0}/{1}", row.VV_SOLUONG_NU, row.VV_SOLUONG); item.HD_THOIGIAN = FunctionHelper.formatFromDateToDate(row.VV_THOIGIAN_BATDAU, row.VV_THOIGIAN_KETTHUC); item.HD_LOAI_STT = 3; item.HD_LOAI = "Vay vốn nhỏ tự mưu sinh"; item.HD_NOIDUNG = row.VV_NOIDUNG; lists.Add(item); } //hội trợ triễn lãm context.QL_HOATDONG_HOICHO_TRIENLAM.Load(); var dataHoiCho = (from p in context.QL_HOATDONG_HOICHO_TRIENLAM where deTuNgay.DateTime.Date <= p.HC_THOIGIAN_BATDAU && p.HC_THOIGIAN_BATDAU <= deDenNgay.DateTime.Date select p).ToList(); foreach (QL_HOATDONG_HOICHO_TRIENLAM row in dataHoiCho) { clsTongKetHoatDong item = new clsTongKetHoatDong(); item.HD_ID = row.HC_ID; item.HD_TEN = row.HC_TEN; item.HD_THOIGIAN_BATDAU = row.HC_THOIGIAN_BATDAU; item.HD_THOIGIAN_KETTHUC = row.HC_THOIGIAN_KETTHUC; item.HD_DIADIEM = row.HC_DIADIEM; item.HD_SONGUOI_THAMGIA = row.HC_SOLUONG_NU ?? 0; item.HD_SONGUOI_NU_TONGSO = string.Format("{0}/{1}", row.HC_SOLUONG_NU, row.HC_SOLUONG); item.HD_THOIGIAN = FunctionHelper.formatFromDateToDate(row.HC_THOIGIAN_BATDAU, row.HC_THOIGIAN_KETTHUC); item.HD_LOAI_STT = 4; item.HD_LOAI = "Hội chợ triễn lãm, thi tay nghề"; item.HD_NOIDUNG = row.HC_NOIDUNG; lists.Add(item); } rptBCTongKetHoatDong_ViecLam rpt = new rptBCTongKetHoatDong_ViecLam(); 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(); }
protected override bool SaveData() { if (_validateControl()) { WaitDialogForm _wait = new WaitDialogForm("Đang lưu dữ liệu ...", "Vui lòng đợi giây lát"); using (var _context = new QL_HOIVIEN_KTEntities()) { QL_USERS item; switch (_formStatus) { case EnumFormStatus.ADD: item = new QL_USERS(); _setObjectEntities(ref item); _context.QL_USERS.Add(item); var listFunc = FuncCategory.loadFunctionName(); foreach (var func in listFunc) { QL_USERS_PERMISSION per = new QL_USERS_PERMISSION(); per.PER_NAME = Convert.ToInt32(func.ID); per.PER_VIEW = true; per.PER_ADD = false; per.PER_MODIFY = false; per.PER_DELETE = false; per.PER_PRINT = false; per.QL_USERS = item; _context.QL_USERS_PERMISSION.Add(per); } break; case EnumFormStatus.MODIFY: Int64 userId = Convert.ToInt64(gvGrid.GetFocusedRowCellValue(colUSER_ID)); item = (from p in _context.QL_USERS where p.USER_ID == userId select p).FirstOrDefault <QL_USERS>(); if (item != null) { _setObjectEntities(ref item); } var entity = _context.QL_USERS.Find(userId); _context.Entry(entity).CurrentValues.SetValues(item); gvChucNang.PostEditor(); gvChucNang.UpdateCurrentRow(); context.SaveChanges(); break; case EnumFormStatus.DELETE: Int64 deleteId = Convert.ToInt64(gvGrid.GetFocusedRowCellValue(colUSER_ID)); var entitiesPermission = (from p in _context.QL_USERS_PERMISSION where p.USER_ID == deleteId select p); foreach (var per in entitiesPermission) { _context.QL_USERS_PERMISSION.Remove(per); } QL_USERS entities = (from p in _context.QL_USERS where p.USER_ID == deleteId select p).FirstOrDefault(); _context.QL_USERS.Remove(entities); break; default: break; } _context.SaveChanges(); } FormStatus = EnumFormStatus.VIEW; _wait.Close(); } return(base.SaveData()); }