/// <summary> /// Get Dataset /// </summary> /// <param name="proc"></param> /// <param name="pName"></param> /// <param name="pValue"></param> /// <returns></returns> public static DataSet GetDataset(string proc, List <string> pName, List <object> pValue) { List <DbParameter> parameters = new List <DbParameter>(); for (int i = 0; i < pName.Count; i++) { parameters.Add(Data.CreateParameter(pName[i], pValue[i])); } return(SqlHelper.ExecuteDataSet(Data.ConnectionString, CommandType.StoredProcedure, proc, parameters.ToArray())); }
/// <summary> /// ExecuteScalar /// </summary> /// <param name="Query"></param> /// <param name="commandType"></param> /// <param name="pName"></param> /// <param name="pValue"></param> public static object ExecuteScalar(string Query, CommandType commandType, List <string> pName, List <object> pValue) { List <DbParameter> parameters = new List <DbParameter>(); if (pName != null) { for (int i = 0; i < pName.Count; i++) { parameters.Add(Data.CreateParameter(pName[i], pValue[i])); } } return(SqlHelper.ExecuteScalar(Data.ConnectionString, commandType, Query, parameters.ToArray())); }