private void Form1_Load(object sender, EventArgs e)
{
List <Sach_DTO> lstSach = Sach_BUS.LayDSSach();
dgvSach.DataSource = lstSach;
cbonxb.DataSource = NhaXuatBan_BUS.LayDSTK();
cbonxb.DisplayMember = "TenNXB";
cbonxb.ValueMember = "MaNXB";
cbotheloai.DataSource = TheLoai_BUS.LayDSTL();
cbotheloai.DisplayMember = "TenLoai";
cbotheloai.ValueMember = "MaLoai";
dgvSach.Columns["MaSach"].HeaderText = "Mã sách";
dgvSach.Columns["MaSach"].Width = 80;
dgvSach.Columns["TenSach"].HeaderText = "Tên sách";
dgvSach.Columns["TenSach"].Width = 190;
dgvSach.Columns["TheLoai"].HeaderText = "Thể loại";
dgvSach.Columns["TheLoai"].Width = 130;
dgvSach.Columns["TinhTrang"].HeaderText = "Tình trạng";
dgvSach.Columns["NamXB"].HeaderText = "Năm xuất bản";
dgvSach.Columns["NamXB"].Width = 110;
dgvSach.Columns["SoLuong"].HeaderText = "Số lượng";
dgvSach.Columns["SoLuong"].Width = 80;
dgvSach.Columns["TacGia"].HeaderText = "Tác giả";
dgvSach.Columns["TacGia"].Width = 160;
dgvSach.Columns["NhaXB"].HeaderText = "Nhà xuất bản";
dgvSach.Columns["NhaXB"].Width = 170;
hienthi(true);
txttracuu.Enabled = false;
}
private void txttracuu_TextChanged(object sender, EventArgs e)
{
//if (cbotimkiem.Text == "Mã sách")
//{
// dgvSach.DataSource = HienDL(" select * from SACH where MaSach like '%" + txttracuu.Text.Trim() + "%' ");
//}
//if (cbotimkiem.Text == "Tên sách")
//{
// dgvSach.DataSource = HienDL(" select * from SACH where TenSach like N'%" + txttracuu.Text.Trim() + "%' ");
//}
//if (cbotimkiem.Text == "Năm xuất bản")
//{
// dgvSach.DataSource = HienDL(" select * from SACH where NamXB like '%" + txttracuu.Text.Trim() + "%' ");
//}
//if (cbotimkiem.Text == "Tác giả")
//{
// dgvSach.DataSource = HienDL(" select * from SACH where TacGia like N'%" + txttracuu.Text.Trim() + "%' ");
//}
if (txttracuu.Text.Trim() == "")
{
List <Sach_DTO> lstSach = Sach_BUS.LayDSSach();
dgvSach.DataSource = lstSach;
}
else
{
List <Sach_DTO> lstTimKiem = Sach_BUS.TimSach(dieukien, txttracuu.Text);
dgvSach.DataSource = lstTimKiem;
}
}
public void loadMaSach()
{
List <Sach_DTO> lstSach = Sach_BUS.LayDSSach();
cboMaSach.DataSource = lstSach;
cboMaSach.ValueMember = "TenSach";
}
private void cboDieuKien_SelectedIndexChanged(object sender, EventArgs e)
{
if (cboDieuKien.Text == "Mã sách")
{
Sach_DTOBindingSource.DataSource = Sach_BUS.LayDSSach();
this.reportViewer1.RefreshReport();
List <Sach_DTO> lst = Sach_BUS.LayDSSach();
cboMaThe.DataSource = lst;
Sach_DTO d = new Sach_DTO();
d.MaSach = "TC";
d.MaSach = "Tất cả";
lst.Insert(0, d);
cboMaThe.ValueMember = "MaSach";
cboMaThe.DisplayMember = "MaSach";
}
else if (cboDieuKien.Text == "Tên sách")
{
Sach_DTOBindingSource.DataSource = Sach_BUS.LayDSSach();
this.reportViewer1.RefreshReport();
List <Sach_DTO> lst = Sach_BUS.LayDSSach();
cboMaThe.DataSource = lst;
Sach_DTO d = new Sach_DTO();
d.TenSach = "TC";
d.TenSach = "Tất cả";
lst.Insert(0, d);
cboMaThe.ValueMember = "TenSach";
cboMaThe.DisplayMember = "TenSach";
}
else if (cboDieuKien.Text == "Năm xuất bản")
{
Sach_DTOBindingSource.DataSource = Sach_BUS.LayDSSach();
this.reportViewer1.RefreshReport();
List <Sach_DTO> lst = Sach_BUS.LayDSSach();
cboMaThe.DataSource = lst;
Sach_DTO d = new Sach_DTO();
d.NamXB = "TC";
d.NamXB = "Tất cả";
lst.Insert(0, d);
cboMaThe.ValueMember = "NamXB";
cboMaThe.DisplayMember = "NamXB";
}
else if (cboDieuKien.Text == "Tác giả")
{
Sach_DTOBindingSource.DataSource = Sach_BUS.LayDSSach();
this.reportViewer1.RefreshReport();
List <Sach_DTO> lst = Sach_BUS.LayDSSach();
cboMaThe.DataSource = lst;
Sach_DTO d = new Sach_DTO();
d.TacGia = "TC";
d.TacGia = "Tất cả";
lst.Insert(0, d);
cboMaThe.ValueMember = "TacGia";
cboMaThe.DisplayMember = "TacGia";
}
}
private void btnXem_Click(object sender, EventArgs e)
{
if (cboMaThe.Text == "Tất cả")
{
Sach_DTOBindingSource.DataSource = Sach_BUS.LayDSSach();
this.reportViewer1.RefreshReport();
}
else if (cboDieuKien.Text == "Tên sách")
{
dieukien = "TenSach";
Sach_DTOBindingSource.DataSource = Sach_BUS.TimSach(dieukien, cboMaThe.Text);
this.reportViewer1.RefreshReport();
}
else if (cboDieuKien.Text == "Mã sách")
{
dieukien = "MaSach";
Sach_DTOBindingSource.DataSource = Sach_BUS.TimSach(dieukien, cboMaThe.Text);
//dieukien = cboMaThe.SelectedValue.ToString();
//List<SachMuon_DTO> lstTimKiem = SachMuon_BUS.TimSach(dieukien, txttracuu.Text);
//DgvSachMuon.DataSource = lstTimKiem;
this.reportViewer1.RefreshReport();
}
else if (cboDieuKien.Text == "Năm xuất bản")
{
dieukien = "NamXB";
Sach_DTOBindingSource.DataSource = Sach_BUS.TimSach(dieukien, cboMaThe.Text);
//dieukien = cboMaThe.SelectedValue.ToString();
//List<SachMuon_DTO> lstTimKiem = SachMuon_BUS.TimSach(dieukien, txttracuu.Text);
//DgvSachMuon.DataSource = lstTimKiem;
this.reportViewer1.RefreshReport();
}
else if (cboDieuKien.Text == "Tác giả")
{
dieukien = "TacGia";
Sach_DTOBindingSource.DataSource = Sach_BUS.TimSach(dieukien, cboMaThe.Text);
//dieukien = cboMaThe.SelectedValue.ToString();
//List<SachMuon_DTO> lstTimKiem = SachMuon_BUS.TimSach(dieukien, txttracuu.Text);
//DgvSachMuon.DataSource = lstTimKiem;
this.reportViewer1.RefreshReport();
}
}
