void load(DataList x, string tenhang)
{
HangBLL hb = new HangBLL();
ArrayList lst = new ArrayList();
lst = (ArrayList)hb.showHang("select * from Hang where TenHang like N'%" + tenhang + "%'");
x.DataSource = lst;
x.DataBind();
}
void load(DataList x, string maloai)
{
HangBLL hb = new HangBLL();
ArrayList lst = new ArrayList();
lst = (ArrayList)hb.showHang("select * from Hang where maloai=" + maloai + "order by MaHang desc");
x.DataSource = lst;
x.DataBind();
}
void load(DataList x, string maloai)
{
//Lấy ra số lượng hàng theo từng loại hàng
HangBLL hb = new HangBLL();
ArrayList lst = new ArrayList();
lst = (ArrayList)hb.showHang("select top 5 * from Hang where maloai=" + maloai + "order by MaHang desc");
x.DataSource = lst;
x.DataBind();
}
void loadHang()
{
//lấy ra mã hàng của bảng hàng
HangBLL hb = new HangBLL();
ArrayList lst = new ArrayList();
lst = (ArrayList)hb.showHang("select * from Hang order by MaHang desc");
GridView1.DataSource = lst;
GridView1.DataBind();
}