static string ConnStr = System.Configuration.ConfigurationSettings.AppSettings["ConnStr"].ToString();
public static SqlDataReader GetReader(string sqlSpName)
{
return SqlHelper.ExecuteReader(ConnStr, sqlSpName);
}
public static SqlDataReader GetReader(string sqlSpName, params object[] parameters)
{
return SqlHelper.ExecuteReader(ConnStr, sqlSpName, parameters);
}
public static DataTable GetTable(string sqlSpName)
{
return SqlHelper.ExecuteDataset(ConnStr, sqlSpName).Tables[0];
}
public static DataTable GetTable(string sqlSpName, params object[] parameters)
{
return SqlHelper.ExecuteDataset(ConnStr, sqlSpName, parameters).Tables[0];
}
public static DataSet GetSet(string sqlSpName)
{
return SqlHelper.ExecuteDataset(ConnStr, sqlSpName);
}
public static DataSet GetSet(string sqlSpName, params object[] parameters)
{
return SqlHelper.ExecuteDataset(ConnStr, sqlSpName, parameters);
}
public static DataRow GetRow(string sqlSpName)
{
DataTable dt= GetTable(sqlSpName);
if(dt.Rows.Count > 0)
return dt.Rows[0];
else
return null;
}
public static DataRow GetRow(string sqlSpName, params object[] parameters)
{
DataTable dt= GetTable(sqlSpName, parameters);
if(dt.Rows.Count > 0)
return dt.Rows[0];
else
return null;
}
public static int GetNonQuery(string sqlSpName)
{
return SqlHelper.ExecuteNonQuery(ConnStr, sqlSpName);
}
public static int GetNonQuery(string sqlSpName, params object[] parameters)
{
return SqlHelper.ExecuteNonQuery(ConnStr, sqlSpName, parameters);
}
public static object GetScalar(string sqlSpName)
{
return SqlHelper.ExecuteScalar(ConnStr, sqlSpName);
}
public static object GetScalar(string sqlSpName, params object[] parameters)
{
return SqlHelper.ExecuteScalar(ConnStr, sqlSpName, parameters);
}