private async Task LoadDuLieu() { _model = new QuanLyDoiModel(); await _model.XUAT_CANH_TRAI_PHEP.Where(p => p.NGAY_DI.HasValue && p.NGAY_DI.Value >= dateTuNgay.DateTime && p.NGAY_DI <= dateDenNgay.DateTime).LoadAsync(); xUAT_CANH_TRAI_PHEPBindingSource.DataSource = _model.XUAT_CANH_TRAI_PHEP.Local; }
public FormXuatCanhTraiPhep() { InitializeComponent(); _model = new QuanLyDoiModel(); _modelTimKiem = new QuanLyDoiModel(); _khongCheckNhungNguoiNay = new List <NGUOI>(); LstXuatCanhTraiPhep = new List <XUAT_CANH_TRAI_PHEP>(); }
public FormDanhSachCanBoTrucTuan(int id_truc_tuan) { InitializeComponent(); _db = new QuanLyDoiModel(); _idTrucTuan = id_truc_tuan; }
public FormChonXa(int thang, int nam, List <string> cac_xa_co_dau) { InitializeComponent(); _db = new QuanLyDoiModel(); _thang = thang; _nam = nam; _cacXaCoDau = cac_xa_co_dau; txtThang.Text = _thang.ToString(); txtNam.Text = _nam.ToString(); }
public FormIntro() { InitializeComponent(); _db = new QuanLyDoiModel(); grvLichCongTac .AddRowNumber() .SetGridViewAppearance(); grvTrucTuan .AddRowNumber() .SetGridViewAppearance(); }
private void tRUC_TUANBindingSource_CurrentChanged(object sender, EventArgs e) { _dbCanBoTrucTuan.SaveChanges(); _dbCanBoTrucTuan = new QuanLyDoiModel(); TRUC_TUAN trucTuan = tRUC_TUANBindingSource.Current as TRUC_TUAN; if (trucTuan != null) { _dbCanBoTrucTuan.TRUC_TUAN_CAN_BO.Where(p => p.IdTrucTuan == trucTuan.IdTrucTuan).Load(); tRUC_TUAN_CAN_BOBindingSource.DataSource = _dbCanBoTrucTuan.TRUC_TUAN_CAN_BO.Local; } }
private async void bAO_CAO_DINH_KYBindingSource_CurrentChanged(object sender, EventArgs e) { if (this.Current != null) { await _dbNgayBaoCao.SaveChangesAsync(); _dbNgayBaoCao = new QuanLyDoiModel(); lblTrangThai.ChangeTextAsync("Đang tải dữ liệu...", Color.Blue); await _dbNgayBaoCao.BAO_CAO_DINH_KY_NGAY_BAO_CAO.Where(p => p.IdBaoCaoDinhKy == this.Current.IdBaoCaoDinhKy).LoadAsync(); nGAY_BAO_CAOBindingSource.DataSource = _dbNgayBaoCao.BAO_CAO_DINH_KY_NGAY_BAO_CAO.Local; lblTrangThai.ChangeTextAsync("Sẵn sàng", Color.Black); } }
private async void btnTaiDuLieu_Click(object sender, EventArgs e) { await _db?.SaveChangesAsync(); btnTaiDuLieu.Enabled = false; _db = new QuanLyDoiModel(); await _db.LICH_CONG_TAC.Where(p => (p.ThoiGian >= dateTuNgay.DateTime && p.ThoiGian <= dateDenNgay.DateTime) || (p.DenNgay >= dateTuNgay.DateTime && p.DenNgay <= dateDenNgay.DateTime)).LoadAsync(); lICH_CONG_TACBindingSource.DataSource = _db.LICH_CONG_TAC.Local; btnTaiDuLieu.Enabled = true; }
private async void btnAddNew_Click(object sender, EventArgs e) { if (_model.ChangeTracker.HasChanges() && ThongBao.XacNhan("Lưu trước khi nhập mới", MessageBoxButtons.YesNo) == DialogResult.Yes) { if (!await this.LuuDuLieu()) { return; } } _model = new QuanLyDoiModel(); NguoiXuatCanh = new NGUOI(); nGUOIBindingSource.DataSource = NguoiXuatCanh; xUAT_CANH_TRAI_PHEPBindingSource.DataSource = _model.XUAT_CANH_TRAI_PHEP.Local; }
private async void cbbNam_SelectedIndexChanged(object sender, EventArgs e) { await _context.SaveChangesAsync(); _context = new QuanLyDoiModel(); _context = new QuanLyDoiModel(); cbbNam.Enabled = false; cbbNam.SelectedValueChanged -= cbbNam_SelectedIndexChanged; await _context.CONG_VAN .Where(p => p.NgayNhan.HasValue && p.NgayNhan.Value.Year == (int)cbbNam.SelectedItem) .LoadAsync(); cONG_VANBindingSource.DataSource = _context.CONG_VAN.Local;//.Where(p => p.NgayNhan.HasValue && p.NgayNhan.Value.Year == (int)cbbNam.SelectedItem); cbbNam.SelectedValueChanged += cbbNam_SelectedIndexChanged; cbbNam.Enabled = true; }
public static async Task <List <LICH_CONG_TAC> > LichCongTacNhungNgayToiAsync(int so_nga_toi = 14) { QuanLyDoiModel _db = new QuanLyDoiModel(); List <LICH_CONG_TAC> res = new List <LICH_CONG_TAC>(); var moc14Ngay = DateTime.Now.AddDays(so_nga_toi); var ngayHomNay = DateTime.Now.Date; //tải dữ liệu lịch trình var lichTrinh = await _db.LICH_CONG_TAC.Where(p => (p.ThoiGian >= ngayHomNay && p.ThoiGian <= moc14Ngay) || (p.DenNgay >= ngayHomNay && p.DenNgay <= moc14Ngay)).ToListAsync(); res.AddRange(lichTrinh); //Thêm báo cáo định kỳ vào lịch trình công tác int namNay = DateTime.Now.Year; var baoCaoDinhKy = (await _db.BAO_CAO_DINH_KY_NGAY_BAO_CAO.ToListAsync()).Where(p => p.NgayBaoCaoNamNay >= ngayHomNay && p.NgayBaoCaoNamNay <= moc14Ngay); foreach (var bcdk in baoCaoDinhKy) { res.Add(new LICH_CONG_TAC() { NoiDung = $"Báo cáo định kỳ {bcdk.BAO_CAO_DINH_KY.NoiDung} ({bcdk.GhiChu}) gửi {bcdk.BAO_CAO_DINH_KY.DonViNhanBaoCao}", ThoiGian = new DateTime(namNay, bcdk.Thang, bcdk.Ngay), }); } //Thêm sinh nhật vào lịch trình công tác var sinhNhat = await _db.CAN_BO.Where(p => p.NgayThangNamSinh.HasValue && p.NgayThangNamSinh.Value.Month == DateTime.Now.Month && p.NgayThangNamSinh.Value.Day >= ngayHomNay.Day).ToListAsync(); foreach (var cb in sinhNhat) { res.Add(new LICH_CONG_TAC() { NoiDung = $"Sinh nhật đồng chí {cb.HoVaTen}", ThoiGian = cb.NgayThangNamSinh }); } return(res); }
public static async Task LoadBangMaAsync(QuanLyDoiModel db) { await db.MA_CHUC_VU.LoadAsync(); await db.MA_CAP_BAC.LoadAsync(); await db.MA_DIA_BAN_XA.LoadAsync(); await db.MA_LOAI_CONG_VAN.LoadAsync(); await db.MA_DIA_BAN_XA.LoadAsync(); await db.MA_DIA_BAN_THON.LoadAsync(); await db.MA_DOI.LoadAsync(); await db.MA_LOAI_CONG_VAN.LoadAsync(); await db.MA_DAN_TOC.LoadAsync(); }
private async Task <bool> LuuDuLieu() { if (_khongLuu) { return(true); } hO_VA_TENTextBox.Focus(); gIOI_TINHComboBoxEdit.Focus(); xUAT_CANH_TRAI_PHEPBindingSource.EndEdit(); nGUOIBindingSource.EndEdit(); QuanLyDoiModel temp = new QuanLyDoiModel(); if (NguoiXuatCanh.ID == 0 && !string.IsNullOrEmpty(NguoiXuatCanh.HO_VA_TEN)) { NguoiXuatCanh.ID = SequenceId.NGUOI(); temp.NGUOI.Add(NguoiXuatCanh); await temp.SaveChangesAsync(); } foreach (XUAT_CANH_TRAI_PHEP xc in xUAT_CANH_TRAI_PHEPBindingSource) { xc.ID_NGUOI = NguoiXuatCanh.ID; } try { await _model.SaveChangesAsync(); return(true); } catch { return(false); } }
public FormLichTrinhCongTac() { InitializeComponent(); _db = new QuanLyDoiModel(); }
public FormBaoCaoDinhKy() { InitializeComponent(); _db = new QuanLyDoiModel(); _dbNgayBaoCao = new QuanLyDoiModel(); }
public FormDanhSachCanBo() { InitializeComponent(); _db = new QuanLyDoiModel(); }
static Global() { DbBangMa = new QuanLyDoiModel(); }
private void linkRefresh_Click(object sender, EventArgs e) { _db = new QuanLyDoiModel(); this.FormIntro_Load(sender, e); }
public FormTrucTuan() { InitializeComponent(); _dbTrucTuan = new QuanLyDoiModel(); _dbCanBoTrucTuan = new QuanLyDoiModel(); }
public FormNhapThongTinKhoiTao() { InitializeComponent(); _db = new QuanLyDoiModel(); }
public FormThongKeXuatCanhTraiPhep() { InitializeComponent(); _model = new QuanLyDoiModel(); }
public frmCongVanDen() { InitializeComponent(); _context = new QuanLyDoiModel(); _category = new QuanLyDoiModel(); }
public FormNhiemVuGiayDiDuong() { _context = new QuanLyDoiModel(); InitializeComponent(); }