public SqlDataReader GetMaNCC()
{
SqlDataReader mancc = Access.ExecSqlDataReader(SP_LAYMANCC, null);
return(mancc);
}
public DataTable getDSNCC() //danh sach nha cung cap
{
DataTable nhaCC = Access.ExecuteQuery(SP_DS_NCC, null);
return(nhaCC);
}
public DataTable getDS_PHIEUNHAP()
{
DataTable pnhap = Access.ExecuteQuery(SP_DS_PHIEUNHAP, null);
return(pnhap);
}
public SqlDataReader getMaPhieuNhap_TuDong()
{
SqlDataReader mapn = Access.ExecSqlDataReader(SP_LAYPHIEUNHAP_TUDONG, null);
return(mapn);
}
public DataTable getDS_DonDatHang_ChuaNhap()
{
DataTable dondh = Access.ExecuteQuery(SP_DS_DONDATHANG_CHUANHAP, null);
return(dondh);
}
public DataTable getChiNhanh() // lay chi nhanh
{
DataTable chinhanh = Access.ExecuteQuery(SP_LAYCHINHANH, null);
return(chinhanh);
}