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