예제 #1
0
 /// <summary>
 /// Fetches the data table.
 /// </summary>
 /// <param name="storedProcedure">The stored procedure.</param>
 /// <returns>DataSet</returns>
 public static DataTable FetchDataTable(string storedProcedure)
 {
     return(SAL.FetchDataTable(storedProcedure));
 }
예제 #2
0
 /// <summary>
 /// Fetches the data table.
 /// </summary>
 /// <param name="storedProcedure">The stored procedure.</param>
 /// <param name="paramAndValue">The param and value.</param>
 /// <returns>DataSet</returns>
 public static DataTable FetchDataTable(string storedProcedure, IDictionary paramAndValue)
 {
     return(SAL.FetchDataTable(storedProcedure, paramAndValue));
 }
예제 #3
0
 /// <summary>
 /// Fetches the SP output (returntype - object).
 /// </summary>
 /// <param name="storedProcedure">The stored procedure.</param>
 /// <param name="paramAndValue">The param and value.</param>
 /// <returns>the object</returns>
 public static object FetchSpObject(string storedProcedure, IDictionary paramAndValue)
 {
     return(SAL.FetchSpObject(storedProcedure, paramAndValue));
 }
예제 #4
0
 /// <summary>
 /// Fetches the data set.
 /// </summary>
 /// <param name="storedProcedure">The stored procedure.</param>
 /// <returns>DataSet</returns>
 public static DataSet FetchDataSet(string storedProcedure)
 {
     return(SAL.FetchDataSet(storedProcedure));
 }
예제 #5
0
 /// <summary>
 /// Executes the SP.
 /// </summary>
 /// <param name="storedProcedure">The stored procedure.</param>
 /// <param name="paramAndValue">The param and value.</param>
 /// <returns>Number of Row Affected</returns>
 public static int ExecuteSP(string storedProcedure, IDictionary paramAndValue)
 {
     return(SAL.LoadProcedureItem(storedProcedure, paramAndValue));
 }