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