private void txtTimSanPham_KeyUp(object sender, KeyEventArgs e)
{
if (txtTimTheoMa.Text.Trim() == "" && txtTimTheoTen.Text.Trim() == "")
{
HienThiDanhSachSP();
return;
}
if (KiemTraPaste(txtTimTheoMa))
{
return;
}
BAL_SANPHAM bal_sp = new BAL_SANPHAM();
DataView dv = bal_sp.getSanPham_TenHienThi().DefaultView;
dv.RowFilter = "";
if (cbChon.SelectedIndex.Equals(0))
{
if (txtTimTheoMa.Text.Trim() == "")
{
return;
}
if (KiemTraSoQuaLon(txtTimTheoMa))
{
return;
}
dv.RowFilter = string.Format("MaSP = {0}", int.Parse(txtTimTheoMa.Text.Trim()));
}
else if (cbChon.SelectedIndex.Equals(1))
{
if (txtTimTheoMa.Text.Trim() == "")
{
return;
}
if (KiemTraSoQuaLon(txtTimTheoMa))
{
return;
}
dv.RowFilter = string.Format("Gia = {0}", int.Parse(txtTimTheoMa.Text.Trim()));
}
else if (cbChon.SelectedIndex.Equals(2))
{
if (txtTimTheoTen.Text.Trim() == "")
{
return;
}
dv.RowFilter = string.Format("TenLoaiSP LIKE '%{0}%' OR UuDai LIKE '%{0}%' OR TenNSX LIKE '%{0}%' OR TenSP LIKE '%{0}%' OR MoTa LIKE '%{0}%' OR Size LIKE '%{0}%' OR Mau LIKE '%{0}%' OR Hinh LIKE '%{0}%' ", txtTimTheoTen.Text.Trim());
}
dgvSanPham.DataSource = dv;
}
private void ckbXoaSP_CheckedChanged(object sender, EventArgs e)
{
if (ckbXoaSP.Checked)
{
gbThemSanPham.Enabled = false;
btnHuy_Click(sender, e);
BAL_SANPHAM bal_sp = new BAL_SANPHAM();
dgvSanPham.DataSource = bal_sp.getSanPham();
pnTimKiem.Enabled = false;
}
else
{
gbThemSanPham.Enabled = true;
BAL_SANPHAM bal_sp = new BAL_SANPHAM();
dgvSanPham.DataSource = bal_sp.getSanPham_TenHienThi();
pnTimKiem.Enabled = true;
}
}
private void HienThiDanhSachSP()
{
BAL_SANPHAM bal_sp = new BAL_SANPHAM();
dgvSanPham.DataSource = bal_sp.getSanPham_TenHienThi();
}