public static IList <MatHangInfo> LayDsMatHangTheoMa(String MaPhieu)
{
IList <MatHangInfo> ds = new List <MatHangInfo>();
MatHangData data = new MatHangData();
DataTable tbl = data.LayDSMatHangTheoMa(MaPhieu);
IList <MatHangInfo> MatHang = new List <MatHangInfo>();
foreach (DataRow row in tbl.Rows)
{
MatHangInfo MH = new MatHangInfo();
NhaCungCapInfo m_NCC = new NhaCungCapInfo();
m_NCC.TenNCC = Convert.ToString(row["TenNCC"]);
m_NCC.MaNCC = Convert.ToString(row["MaNCC"]);
LoaiTienInfo m_LoaiTien = new LoaiTienInfo();
m_LoaiTien.LoaiTien = Convert.ToString(row["LoaiTien"]);
LoaiGiaoDichInfo m_LoaiGD = new LoaiGiaoDichInfo();
m_LoaiGD.TenGiaoDich = Convert.ToString(row["TenLoaiGiaoDich"]);
MH.MaPhieu = Convert.ToString(row["MaPhieu"]);
MH.MaMH = Convert.ToString(row["MaMH"]);
MH.TenMH = Convert.ToString(row["TenMH"]);
MH.SoLuong = Convert.ToString(row["SoLuong"]);
MH.DonGia = Convert.ToString(row["DonGia"]);
MH.GiaBan = Convert.ToString(row["GiaBan"]);
MH.NgayNhap = Convert.ToDateTime(row["NgayNhap"]);
MH.MaNCC = m_NCC;
MH.MaLoaiGiaoDich = m_LoaiGD;
MH.MaLoaiTien = m_LoaiTien;
MatHang.Add(MH);
}
return(MatHang);
}
public static IList <XuatHangInfo> LayDsXuatHangTheoMa(String MaPhieu)
{
IList <XuatHangInfo> ds = new List <XuatHangInfo>();
XuatHangData data = new XuatHangData();
DataTable tbl = data.LayDSXuatHangTheoMa(MaPhieu);
IList <XuatHangInfo> XuatHang = new List <XuatHangInfo>();
foreach (DataRow row in tbl.Rows)
{
XuatHangInfo XH = new XuatHangInfo();
MatHangInfo m_MH = new MatHangInfo();
m_MH.TenMH = Convert.ToString(row["TenMH"]);
m_MH.MaMH = Convert.ToString(row["MaMH"]);
KhachHangInfo m_KH = new KhachHangInfo();
m_KH.HoTen = Convert.ToString(row["HoTen"]);
m_KH.MaKH = Convert.ToString(row["MaKH"]);
NhanVienInfo m_NV = new NhanVienInfo();
m_NV.HoTen = Convert.ToString(row["HoTenNV"]);
m_NV.MaNV = Convert.ToString(row["MaNV"]);
LoaiTienInfo m_LoaiTien = new LoaiTienInfo();
m_LoaiTien.LoaiTien = Convert.ToString(row["LoaiTien"]);
LoaiGiaoDichInfo m_LoaiGD = new LoaiGiaoDichInfo();
m_LoaiGD.TenGiaoDich = Convert.ToString(row["TenLoaiGiaoDich"]);
XH.MaPhieu = Convert.ToString(row["MaPhieu"]);
XH.SoLuong = Convert.ToString(row["SoLuong"]);
XH.GiaBan = Convert.ToString(row["GiaBan"]);
XH.ThanhTien = Convert.ToString(row["ThanhTien"]);
XH.NgayXuat = Convert.ToDateTime(row["NgayXuat"]);
XH.MaMH = m_MH;
XH.MaKH = m_KH;
XH.MaNV = m_NV;
XH.MaLoaiGiaoDich = m_LoaiGD;
XH.MaLoaiTien = m_LoaiTien;
XuatHang.Add(XH);
}
return(XuatHang);
}
public static IList <DatHangInfo> LayDsDatHangTheoMa(String MaPhieu)
{
IList <DatHangInfo> ds = new List <DatHangInfo>();
DatHangData data = new DatHangData();
DataTable tbl = data.LayDSDatHangTheoMa(MaPhieu);
IList <DatHangInfo> DatHang = new List <DatHangInfo>();
foreach (DataRow row in tbl.Rows)
{
DatHangInfo DH = new DatHangInfo();
MatHangInfo m_MH = new MatHangInfo();
m_MH.TenMH = Convert.ToString(row["TenMH"]);
m_MH.MaMH = Convert.ToString(row["MaMH"]);
KhachHangInfo m_KH = new KhachHangInfo();
m_KH.HoTen = Convert.ToString(row["HoTen"]);
m_KH.MaKH = Convert.ToString(row["MaKH"]);
LoaiTienInfo m_LoaiTien = new LoaiTienInfo();
m_LoaiTien.LoaiTien = Convert.ToString(row["LoaiTien"]);
LoaiGiaoDichInfo m_LoaiGD = new LoaiGiaoDichInfo();
m_LoaiGD.TenGiaoDich = Convert.ToString(row["TenLoaiGiaoDich"]);
DH.MaPhieu = Convert.ToString(row["MaPhieu"]);
DH.ThanhToan = Convert.ToBoolean(row["ThanhToan"]);
DH.SoLuong = Convert.ToString(row["SoLuong"]);
DH.GiaBan = Convert.ToString(row["GiaBan"]);
DH.ThanhTien = Convert.ToString(row["ThanhTien"]);
DH.NgayDat = Convert.ToDateTime(row["NgayDat"]);
DH.MaMH = m_MH;
DH.MaKH = m_KH;
DH.MaLoaiGiaoDich = m_LoaiGD;
DH.MaLoaiTien = m_LoaiTien;
DatHang.Add(DH);
}
return(DatHang);
}
