private void btnTimSach_muon_Click_1(object sender, EventArgs e) { BAL_sach xulysach = new BAL_sach(); if (IsNumber(txtTimSach_muon.Text) == true) { DataTable Table = null; Table = xulysach.searcher_msach(txtTimSach_muon.Text); if (Table != null && Table.Rows.Count > 0) { dgvSach_muon.DataSource = Table; dgvSach_muon.AllowUserToAddRows = false; } else if (string.IsNullOrEmpty(txtTimSach_muon.Text)) { dgvSach_muon.DataSource = xulysach.getAll(); //xóa dòng cuối dgvSach_muon.AllowUserToAddRows = false; } else { MessageBox.Show("Mã này " + txtTimSach_muon.Text + " chưa tồn tại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { DataTable Table = xulysach.searcher_sach(txtTimSach_muon.Text); if (Table != null && Table.Rows.Count > 0) { dgvSach_muon.DataSource = Table; dgvSach_muon.AllowUserToAddRows = false; } else if (string.IsNullOrEmpty(txtTimSach_muon.Text)) { dgvSach_muon.DataSource = xulysach.getAll(); //xóa dòng cuối dgvSach_muon.AllowUserToAddRows = false; } else { MessageBox.Show("Sách này " + txtTimSach_muon.Text + " chưa tồn tại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
private void FormQLSach_Load(object sender, EventArgs e) { AutoCompleteStringCollection acsc = new AutoCompleteStringCollection(); txtGiaMuon.MaxLength = 20; txtMaSach.Enabled = false; txtNamPhatHanh.MaxLength = 20; txtTenSach.MaxLength = 20; txtTim.MaxLength = 20; hienthidanhsachnhaxuatban(cboNhaPhatHanh); hienthidanhsachtacgia(cboTacGia); hienthidanhsachtheloai(cboTheLoai); dgvQuanLySach.AllowUserToAddRows = false; dgvQuanLySach.RowHeadersVisible = false; btnXatNhan.Visible = btnLamMoi.Visible = btnQuayLai.Visible = false; BAL_sach xulySach = new BAL_sach(); DataTable data; if (FormDangNhap.Nhanvien.Quan_ly) { data = xulySach.getAll(); dgvQuanLySach.DataSource = data; rowtosach(0); btnKhoiPhuc.Visible = sach.Da_xoa; } else { data = xulySach.getAllExist(); dgvQuanLySach.DataSource = data; rowtosach(0); //ẩn đòng trạng thái đã xóa đi dgvQuanLySach.Columns[9].Visible = false; } foreach (DataRow row in data.Rows) { acsc.Add(row["ma_sach"].ToString()); acsc.Add(row["ten_sach"].ToString()); } txtTim.AutoCompleteCustomSource = acsc; }
private void FormMuonTraSach_Load(object sender, EventArgs e) { AutoCompleteStringCollection acsc = new AutoCompleteStringCollection(); AutoCompleteStringCollection acsc_tra = new AutoCompleteStringCollection(); DataTable data = null; DataTable data_tra = null; BAL_sach xulysach = new BAL_sach(); data = xulysach.getAll(); BAL_phieumuon xulyphieumuon = new BAL_phieumuon(); data_tra = xulyphieumuon.GetAll(); //****************************** //**Muon dgvSach_muon.AllowUserToAddRows = false; dgvSach_muon.RowHeadersVisible = false; dgvSachMuon_muon.AllowUserToAddRows = false; dgvSachMuon_muon.RowHeadersVisible = false; muon_load(); //****************************** //**Tra dgvPhieuMuon.AllowUserToAddRows = false; dgvPhieuMuon.RowHeadersVisible = false; dgvThongTinPhieu.AllowUserToAddRows = false; dgvThongTinPhieu.RowHeadersVisible = false; tra_load(); foreach (DataRow row in data.Rows) { acsc.Add(row["ma_sach"].ToString()); acsc.Add(row["ten_sach"].ToString()); } foreach (DataRow row in data_tra.Rows) { acsc_tra.Add(row["ma_phieu"].ToString()); acsc_tra.Add(row["doc_gia"].ToString()); acsc_tra.Add(row["nhan_vien"].ToString()); } txtTimSach_muon.AutoCompleteCustomSource = acsc; txtTimTra.AutoCompleteCustomSource = acsc_tra; }