public SanPham(string maSanPham, string tenSanPham, Loai_San_Pham loaiSanPham, int gia, HangSanXuat hangSanXuatSanPham, int soLuongTonKho, bool coKhuyenMai, string hinhAnh)
{
this.MaSanPham = maSanPham;
this.TenSanPham = tenSanPham;
this.LoaiSanPham = loaiSanPham;
this.Gia = gia;
this.HangSanXuatSanPham = hangSanXuatSanPham;
SoLuongTonKho1 = soLuongTonKho;
this.CoKhuyenMai = coKhuyenMai;
this.DuongDanHinhAnh = hinhAnh;
}
public SanPham(int maSanPham, string tenSanPham, Loai_San_Pham loaiSanPham, int gia, HangSanXuat hangSanXuatSanPham, int soLuongTonKho, bool coKhuyenMai, string hinhAnh)
{
this.TenSanPham = tenSanPham;
this.LoaiSanPham = loaiSanPham;
this.Gia = gia;
this.HangSanXuatSanPham = hangSanXuatSanPham;
SoLuongTonKho1 = soLuongTonKho;
this.CoKhuyenMai = coKhuyenMai;
this.DuongDanHinhAnh = hinhAnh;
string kiTuDau = "";
if (loaiSanPham == Loai_San_Pham.DIEN_THOAI)
{
kiTuDau = "D";
}
else
{
kiTuDau = "L";
}
this.MaSanPham = kiTuDau + maSanPham.ToString();
}
public List <SanPham> layDanhSachSanPham()
{
List <SanPham> ds = new List <SanPham>();
string query = "select MaSP, TenSP ,MaHSX, GiaThanh, HinhAnh, SoLuongConTrongCH, LoaiHang, TenHSX, QuocGia" +
" from SanPham , NhaSX where MaHSX = MaNSX";
DataTable table = docDuLieu(query);
if (table == null || table.Rows.Count <= 0)
{
return(null);
}
foreach (DataRow row in table.Rows)
{
int maHangSX = Convert.ToInt32(row["MaHSX"]);
string tenHangSX = Convert.ToString(row["TenHSX"]);
string quocGia = Convert.ToString(row["QuocGia"]);
int maSP = Convert.ToInt32(row["MaSP"]);
HangSanXuat hsx = new HangSanXuat(maHangSX, tenHangSX, quocGia);
string tenSP = Convert.ToString(row["TenSP"]);
int gia = Convert.ToInt32(row["GiaThanh"]);
int soLuongTonKho = Convert.ToInt32(row["SoLuongConTrongCH"]);
string image = Convert.ToString(row["HinhAnh"]);
string l = Convert.ToString(row["LoaiHang"]);
Loai_San_Pham loai = Loai_San_Pham.LINH_KIEN;
if (l == "Dien Thoai")
{
loai = Loai_San_Pham.DIEN_THOAI;
}
SanPham sp = new SanPham(maSP, tenSP, loai, gia, hsx, soLuongTonKho, false, image);
ds.Add(sp);
}
return(ds);
}
