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); }