public DataSet LayListBaoHanh()
{
return(db.ExecuteQueryDataSet("spLayListBaoHanh", CommandType.StoredProcedure, null));
}
public DataSet LayListHoaDonNhapHang()
{
return(db.ExecuteQueryDataSet("spLayListHDNhapHang", CommandType.StoredProcedure, null));
}
public DataSet LayListThanhToanCN()
{
return(db.ExecuteQueryDataSet("spLayListThanhToanCongNo", CommandType.StoredProcedure, null));
}
public DataSet ThongKeSLToanBo()
{
return(db.ExecuteQueryDataSet("spThongKeSoLuongSPBanRaToanBo", CommandType.StoredProcedure, null));
}
public DataSet LayListSanPham()
{
return(db.ExecuteQueryDataSet("spLayListSanPham", CommandType.StoredProcedure, null));
}
public DataSet LayListNhaCungCap()
{
return(db.ExecuteQueryDataSet("spLayListNhaCC", CommandType.StoredProcedure, null));
}
// Lấy tất cả chi tiết nhập
public DataSet LayTatCaChiTietNhap()
{
return(db.ExecuteQueryDataSet("spLayChiTietDonNhap", CommandType.StoredProcedure));
}