dbhelper.cs

前台用户可以在线留言

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace messageboardtest.DataAccess
{
	public sealed class DbHelper
	{
		static string ConnStr = System.Configuration.ConfigurationSettings.AppSettings["ConnStr"];
 

		/// <summary>
		///调用无参数存储过程
		/// </summary>
		/// <param name="sqlSpName">存储过程名称</param>
		/// <returns>返回DataTable</returns>
		public static DataTable GetTable(string sqlSpName)
		{
			return SqlHelper.ExecuteDataset(ConnStr, sqlSpName).Tables[0];
		}


		/// <summary>
		/// 调用有参数存储过程
		/// </summary>
		/// <param name="sqlSpName">存储过程名称</param>
		/// <param name="parameters">参数数组 object类型</param>
		/// <returns>返回DataTable</returns>
		public static DataTable GetTable(string sqlSpName, params object[] parameters)
		{
			return SqlHelper.ExecuteDataset(ConnStr, sqlSpName, parameters).Tables[0];
		}
		
		
		/// <summary>
		///调用无参数存储过程
		/// </summary>
		/// <param name="sqlSpName">存储过程名称</param>
		/// <returns>返回DataSet</returns>
		public static DataSet GetSet(string sqlSpName)
		{
			return SqlHelper.ExecuteDataset(ConnStr, sqlSpName);
		}
		
		
		/// <summary>
		/// 调用有参数存储过程
		/// </summary>
		/// <param name="sqlSpName">存储过程名称</param>
		/// <param name="parameters">参数数组 object类型</param>
		/// <returns>返回DataSet</returns>
		public static DataSet GetSet(string sqlSpName, params object[] parameters)
		{
			return SqlHelper.ExecuteDataset(ConnStr, sqlSpName, parameters);
		}

		/// <summary>
		/// 调用无参数存储过程
		/// </summary>
		/// <param name="sqlSpName">存储过程名称</param>
		/// <returns>如果不为空，返回一行数据；如果为空，返回null</returns>
		public static DataRow GetRow(string sqlSpName)
		{
			DataTable dt= GetTable(sqlSpName);

			if(dt.Rows.Count > 0)
				return dt.Rows[0];
			else
				return null;
		}

		/// <summary>
		/// 调用有参数存储过程
		/// </summary>
		/// <param name="sqlSpName">存储过程名称</param>
		/// <param name="parameters">参数数组 object类型</param>
		/// <returns>如果不为空，返回一行数据；如果为空，返回null</returns>
		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;
		}

		/// <summary>
		/// 调用有参数存储过程
		/// </summary>
		/// <param name="sqlSpName">存储过程名称</param>
		/// <returns> 返回状态值 </returns>
		public static int GetNonQuery(string sqlSpName)
		{
			return SqlHelper.ExecuteNonQuery(ConnStr, sqlSpName);
		}
		
		/// <summary>
		/// 
		/// </summary>
		/// <param name="sqlSpName">存储过程名称</param>
		/// <param name="parameters">参数数组 object类型</param>
		/// <returns>返回状态值</returns>
		public static int GetNonQuery(string sqlSpName, params object[] parameters)
		{
			return SqlHelper.ExecuteNonQuery(ConnStr, sqlSpName, parameters);
		}

		/// <summary>
		/// 调用无参数存储过程
		/// </summary>
		/// <param name="sqlSpName">存储过程名称</param>
		/// <returns>返回第一行第一列值</returns>
		public static object GetScalar(string sqlSpName)
		{
			return SqlHelper.ExecuteScalar(ConnStr, sqlSpName);
		}

		/// <summary>
		/// 调用有参数存储过程
		/// </summary>
		/// <param name="sqlSpName">存储过程名称</param>
		/// <param name="parameters">参数数组 object类型</param>
		/// <returns>返回第一行第一列值</returns>
		public static object GetScalar(string sqlSpName, params object[] parameters)
		{
			return SqlHelper.ExecuteScalar(ConnStr, sqlSpName, parameters);
		}

		/// <summary>
		/// 调用无参数存储过程
		/// </summary>
		/// <param name="sqlSpName">存储过程名称</param>
		/// <returns>返回第一行值</returns>
		public static object GetReader(string sqlSpName)
		{
			return SqlHelper.ExecuteReader(ConnStr, sqlSpName);
		}

		/// <summary>
		/// 调用有参数存储过程
		/// </summary>
		/// <param name="sqlSpName">存储过程名称</param>
		/// <param name="parameters">参数数组 object类型</param>
		/// <returns>返回第一行值</returns>
		public static SqlDataReader GetReader(string sqlSpName, params object[] parameters)
		{
			return SqlHelper.ExecuteReader(ConnStr, sqlSpName, parameters);
		}
	}
}