private void muon_load()
{
BAL_sach sach = new BAL_sach();
dgvSach_muon.DataSource = sach.getAllExist();
//ẩn dồng cuối và cột đầu
dgvSach_muon.Columns[10].Visible = false;
btnXatNhan_muon.Enabled = false;
txtNhanVien.Text = FormDangNhap.Nhanvien.Ma_nhan_vien;
}
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;
}
