private void ShowSanPhamToDGV()
{
SanPhamBUL spb = new SanPhamBUL();
DanhMucBUL dmb = new DanhMucBUL();
List <DanhMucDTO> dsDanhMuc = dmb.DanhSach();
List <SanPhamDTO> dsSanPham = spb.DanhSach();
//Linq
dgvSanPham.DataSource = (from sp in dsSanPham
from dm in dsDanhMuc
where sp.MaDanhMuc.Equals(dm.MaDanhMuc)
select new
{
sp.MaSanPham,
sp.TenSanPham,
sp.DonGia,
sp.SoLuong,
sp.MaDanhMuc,
dm.TenDanhMuc
}
).ToList();
dgvSanPham.Columns["MaSanPham"].HeaderText = "Mã Sản Phẩm";
dgvSanPham.Columns["TenSanPham"].HeaderText = "Tên Sản Phẩm";
dgvSanPham.Columns["DonGia"].HeaderText = "Đơn Giá";
dgvSanPham.Columns["SoLuong"].HeaderText = "Số Lượng";
dgvSanPham.Columns["MaDanhMuc"].Visible = false;
dgvSanPham.Columns["TenDanhMuc"].HeaderText = "Danh Mục";
dgvSanPham.PerformLayout();
}
private void FillDataDanhMuc()
{
DanhMucBUL dmb = new DanhMucBUL();
cboDanhMuc.DataSource = dmb.DanhSach();
cboDanhMuc.DisplayMember = "TenDanhMuc";
cboDanhMuc.ValueMember = "MaDanhMuc";
}
