public List <HoaDonChiTietDTO> LoadHDCT(string MaHD) { List <HoaDonChiTietDTO> hdlist = new List <HoaDonChiTietDTO>(); string sql = "SP_HOADONCHITIET_DS @MAHOADON"; DataTable data = DataProvider.Instance.ExecuteQuery(sql, new object[] { MaHD }); foreach (DataRow items in data.Rows) { String ngaynhap = items["NGAYNHAP"].ToString(); String ngayxuat = items["NGAYXUAT"].ToString(); String tennv = items["TENNV"].ToString(); String maban = items["MABAN"].ToString(); float giamgia = (float)Convert.ToDouble(items["GIAMGIA"].ToString()); float vat = (float)Convert.ToDouble(items["VAT"].ToString()); float thanhtoan = (float)Convert.ToDouble(items["THANHTOAN"].ToString()); String masp = items["MASP"].ToString(); String tensp = items["TENSP"].ToString(); int soluong = Convert.ToInt32(items["SOLUONG"].ToString()); String dongia = items["DONGIABAN"].ToString(); String maca = items["TENCA"].ToString(); HoaDonChiTietDTO hdct = new HoaDonChiTietDTO(MaHD, ngaynhap, ngayxuat, "", maban, giamgia, vat, thanhtoan, "", masp, tensp, tennv, soluong, dongia, maca); hdlist.Add(hdct); } return(hdlist); }
public List <HoaDonChiTietDTO> GetListHoaDonChiTiet(int mahoadon) { List <HoaDonChiTietDTO> list = new List <HoaDonChiTietDTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM ChiTietHoaDon WHERE MaHoaDon = " + mahoadon); foreach (DataRow item in data.Rows) { HoaDonChiTietDTO hoadon = new HoaDonChiTietDTO(item); list.Add(hoadon); } return(list); }
public List <HoaDonChiTietDTO> BangHDCT() { List <HoaDonChiTietDTO> ds = new List <HoaDonChiTietDTO>(); KetNoiCoSoDuLieu.Moketnoi(); string SQlSL = "SELECT * FROM HoaDonChiTiet"; SqlCommand cmd = new SqlCommand(SQlSL, KetNoiCoSoDuLieu.chuoiketnoi); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { HoaDonChiTietDTO sp = new HoaDonChiTietDTO(dr["MaHoaDon"].ToString(), dr["MaHang"].ToString(), dr["SoLuong"].ToString()); ds.Add(sp); } KetNoiCoSoDuLieu.Dongketnoi(); return(ds); }