public static DataTable XemTonKho() { DataProvider p = new DataProvider(); p.Connect(); DataTable dt = p.SL("sp_XemTonKho", CommandType.StoredProcedure); p.Disconnect(); return(dt); }
public static DataTable XemTonKhoTheoKho(int MaKho) { DataProvider p = new DataProvider(); p.Connect(); SqlParameter p1 = new SqlParameter("@MaKho", SqlDbType.Int) { Value = MaKho }; DataTable dt = p.SL("sp_XemTonKhoTheoKho", CommandType.StoredProcedure, p1); p.Disconnect(); return(dt); }