private void btnTim_Click(object sender, EventArgs e)
{
List <HienThiGiay_DTO> listGiay = new List <HienThiGiay_DTO>();
HienThiGiay_BUS htgiay_bus = new HienThiGiay_BUS();
string query = "Select G.id,G.tenGiay,S.sizeGiay,HG.tenHang,LG.tenLoaiGiay,S.giaBan,S.giaNhap,G.giamGia,S.soLuong,G.hinhAnh,S.trangThai from HangGiay as HG,LoaiGiay as LG, Giay as G,BangSize as S where G.id = S.idGiay and G.idHangGiay = HG.id and G.idLoaiGiay = LG.id ";
if (rdbTatCa.Checked)
{
CapNhapDanhSachTonKho();
return;
}
else if (rdbTimTheoHangGiay.Checked)
{
if (ckcTimTheoLoaiGiay.Checked)
{
query += "and S.trangThai = 1 and G.trangThai = 1 and idLoaiGiay = " + cbLoaiGiay.SelectedValue;
}
else
{
query += "and S.trangThai = 1 and G.trangThai = 1 and idHangGiay = " + cbHangGiay.SelectedValue;
}
}
else if (rdbTimTheoTenGiay.Checked)
{
query += "and S.trangThai = 1 and G.trangThai = 1 and tenGiay Like N'%" + txtTimTenGiay.Text + "%'";
}
else if (rdbSLTon.Checked)
{
query += "and S.trangThai = 1 and G.trangThai = 1 and soLuong >= " + numSLTon.Value;
}
listGiay = htgiay_bus.Tim(query);
lvTonKho.Tag = listGiay;
lvTonKho.Items.Clear();
foreach (HienThiGiay_DTO item in listGiay)
{
ListViewItem lvItem = new ListViewItem(item.tenGiay);
lvItem.SubItems.Add(item.tenHangGiay);
lvItem.SubItems.Add(item.tenLoaiGiay);
lvItem.SubItems.Add(item.size);
lvItem.SubItems.Add(item.soLuong.ToString());
lvItem.SubItems.Add(item.giaNhap.ToString());
lvTonKho.Items.Add(lvItem);
}
}
void CapNhapDanhSachTonKho()
{
lvTonKho.Items.Clear();
List <HienThiGiay_DTO> listGiay = new List <HienThiGiay_DTO>();
HienThiGiay_BUS htgiay_bus = new HienThiGiay_BUS();
listGiay = htgiay_bus.LayDanhSach();
lvTonKho.Tag = listGiay;
foreach (HienThiGiay_DTO item in listGiay)
{
ListViewItem lvItem = new ListViewItem(item.tenGiay);
lvItem.SubItems.Add(item.tenHangGiay);
lvItem.SubItems.Add(item.tenLoaiGiay);
lvItem.SubItems.Add(item.size);
lvItem.SubItems.Add(item.soLuong.ToString());
lvItem.SubItems.Add(item.giaNhap.ToString());
lvTonKho.Items.Add(lvItem);
}
}
