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