//lay ma kho theo ten
public SqlDataReader getMaKho(string[] param)
{
String[] name = { "@TENKHO" };
SqlDataReader maKho = Access.ExecSqlDataReader(SP_LAY_MA_KHO, name, param, 1);
return(maKho);
}
//kiem tra role nhan vien co duoc chuyen sang chi nhanh khac hay kg
//neu role conty thi kg dc chuyen
public SqlDataReader KiemTraNV(string[] param)
{
string[] name = { "@MANV" };
SqlDataReader role = Access.ExecSqlDataReader(SP_KIEMTRA_ROLE, name, param, 1);
return(role);
}
public SqlDataReader getLogin(string[] param)
{
string[] name = { "@LOGINNAME" };
SqlDataReader reader = Access.ExecSqlDataReader("SP_DANGNHAP", name, param, 1);
return(reader);
}
//lay ma hoa don
public SqlDataReader getMaPX()
{
SqlDataReader maHD = Access.ExecSqlDataReader(SP_LAYMA_PHIEUXUAT, null);
return(maHD);
}
public SqlDataReader getMaKhachHang()
{
SqlDataReader maKH = Access.ExecSqlDataReader(SP_LAYMAKHACHHANG, null);
return(maKH);
}
public SqlDataReader getMaDDH()
{
SqlDataReader maddh = Access.ExecSqlDataReader(SP_LAYMADONDATHANG_TUDONG, null);
return(maddh);
}
public SqlDataReader getMaPhieuNhap_TuDong()
{
SqlDataReader mapn = Access.ExecSqlDataReader(SP_LAYPHIEUNHAP_TUDONG, null);
return(mapn);
}
public SqlDataReader GetMaNCC()
{
SqlDataReader mancc = Access.ExecSqlDataReader(SP_LAYMANCC, null);
return(mancc);
}
