private void hien()
{
string sql = @"select *from TaiKhoan";
dtgvtaikhoan.DataSource = KetNoi.getTable(sql);
binding();
}
private void NhuCauMuonSach_Load(object sender, EventArgs e)
{
string sql = @"SELECT * FROM Sach";
cmbsach.DataSource = KetNoi.getTable(sql);
cmbsach.DisplayMember = "TenSach";
cmbsach.ValueMember = "MaSach";
string sql1 = @"SELECT * FROM DocGia";
cmbdocgia.DataSource = KetNoi.getTable(sql1);
cmbdocgia.DisplayMember = "TenDocGia";
cmbdocgia.ValueMember = "MaDocGia";
string sql2 = @"SELECT * FROM NhanVien";
cmbnhanvien.DataSource = KetNoi.getTable(sql2);
cmbnhanvien.DisplayMember = "TenNV";
cmbnhanvien.ValueMember = "MaNV";
mobtn();
dongtxt();
hien();
}
private void hien()
{
string sql = @"select MaSach,TenSach,S.MaTheLoai,TheLoai.TenTheLoai,S.MaTG,TacGia.TenTG,NXB,NamXB,GiaTien,SoTrang,TinhTrangSach,SoLuong
from Sach S
inner join TheLoai on S.MaTheLoai=TheLoai.MaTheLoai
inner join TacGia ON S.MaTG=TacGia.MaTG";
dtgvsach.DataSource = KetNoi.getTable(sql);
}
private void hien()
{
string sql = @"select STT,SoPM,Sach.MaSach,Sach.TenSach,SoLuongSachMuon,DocGia.MaDocGia,DocGia.TenDocGia,NgayMuon,NgayHanTra,TinhTrangSach,GhiChu, NhanVien.MaNV, TenNV
from NhuCau
inner join Sach on Sach.MaSach=NhuCau.MaSach
inner join DocGia on DocGia.MaDocGia=NhuCau.MaDocGia
inner join NhanVien on NhanVien.MaNV=NhuCau.MaNV";
dtgv2.DataSource = KetNoi.getTable(sql);
}
private void bttim_Click(object sender, EventArgs e)
{
string sql = @"select* from TacGia";
DataTable data = KetNoi.getTable(sql); //lấy dữ liệu từ bảng KhachHang
if (txttim.Text != "")
{
data.DefaultView.RowFilter = "TenTG LIKE '%" + txttim.Text + "%' or DiaChiTG LIKE '%" + txttim.Text + "%' "; //filter lọc dữ liệu
}
else
{
data.DefaultView.RowFilter = "";
}
dtgvtacgia.DataSource = data;
}
private void bttim_Click(object sender, EventArgs e)
{
string sql = @"select* from TheLoai";
DataTable data = KetNoi.getTable(sql); //lấy dữ liệu từ bảng Thể loại
if (txttim.Text != "")
{
data.DefaultView.RowFilter = "TenTheLoai LIKE '%" + txttim.Text + "%' "; //filter lọc dữ liệu
}
else
{
data.DefaultView.RowFilter = "";
}
dtgvtheloai.DataSource = data;
}
private void bttim_Click(object sender, EventArgs e)
{
string sql = @"select* from NhanVien";
DataTable data = KetNoi.getTable(sql); //lấy dữ liệu từ bảng Nhân viên
if (txttim.Text != "")
{
data.DefaultView.RowFilter = "TenNV LIKE '%" + txttim.Text + "%' or DiaChi LIKE '%" + txttim.Text + "%' or GioiTinh LIKE '%" + txttim.Text + "%' "; //filter lọc dữ liệu
}
else
{
data.DefaultView.RowFilter = "";
}
dtgvnhanvien.DataSource = data;
}
private void bttimkiem_Click(object sender, EventArgs e)
{
string sql = @"select MaSach,TenSach,S.MaTheLoai,S.MaTG,NXB,NamXB,GiaTien,SoTrang,TinhTrangSach,TheLoai.TenTheLoai,TacGia.TenTG,SoLuong
from Sach S
inner join TheLoai on S.MaTheLoai=TheLoai.MaTheLoai
inner join TacGia ON S.MaTG=TacGia.MaTG";
DataTable data = KetNoi.getTable(sql); //lấy dữ liệu từ bảng KhachHang
if (txttim.Text != "")
{
data.DefaultView.RowFilter = "TenSach LIKE '%" + txttim.Text + "%' or NXB LIKE '%" + txttim.Text + "%' or TenTG LIKE '%" + txttim.Text + "%' or TenTheLoai LIKE '%" + txttim.Text + "%'"; //filter lọc dữ liệu
}
else
{
data.DefaultView.RowFilter = "";
}
dtgvsach.DataSource = data; //gán giá trị vào datagridview
}
private void bttimkiem_Click(object sender, EventArgs e)
{
string sql = @"select STT, SoPM,Sach.MaSach,Sach.TenSach,SoLuongSachMuon,DocGia.MaDocGia,DocGia.TenDocGia,NgayMuon,NgayHanTra,TinhTrangSach,GhiChu, NhanVien.MaNV, TenNV
from NhuCau
inner join Sach on Sach.MaSach=NhuCau.MaSach
inner join DocGia on DocGia.MaDocGia=NhuCau.MaDocGia
inner join NhanVien on NhanVien.MaNV=NhuCau.MaNV";
DataTable data = KetNoi.getTable(sql); //lấy dữ liệu từ bảng KhachHang
if (txttim.Text != "")
{
data.DefaultView.RowFilter = "TenDocGia LIKE '%" + txttim.Text + "%' OR TenNV LIKE '%" + txttim.Text + "%' OR TenSach LIKE '%" + txttim.Text + "%'"; //filter lọc dữ liệu
}
else
{
data.DefaultView.RowFilter = "";
}
dtgv2.DataSource = data; //gán giá trị vào datagridview
}
private void Sach_Load(object sender, EventArgs e)
{
string sql = @"SELECT * FROM TheLoai";
cmbMaTL.DataSource = KetNoi.getTable(sql);
cmbMaTL.DisplayMember = "TenTheLoai";
cmbMaTL.ValueMember = "MaTheLoai";
string sql1 = @"SELECT * FROM TacGia";
cmbMaTG.DataSource = KetNoi.getTable(sql1);
cmbMaTG.DisplayMember = "TenTG";
cmbMaTG.ValueMember = "MaTG";
mobtn();
dongtxt();
hien();
}
private void hien()
{
string sql = @"select *from TacGia";
dtgvtacgia.DataSource = KetNoi.getTable(sql);
}
private void hien()
{
string sql = @"select *from TheLoai";
dtgvtheloai.DataSource = KetNoi.getTable(sql);
}
private void hien()
{
string sql = @"select *from NhanVien";
dtgvnhanvien.DataSource = KetNoi.getTable(sql);
}
