dai.cs

某个公司需要维持良好的客户关系

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


namespace CRM.SQLServerDAL
{
	/// <summary>
	/// temp 的摘要说明。
	/// </summary>
	public class DAI
	{
		private DAI(){}

		private static readonly string CONN_STRING = ConfigurationSettings.AppSettings["ConnectionString"];

		#region RunProcNonQuery
		public static int RunProcNonQuery(string spName,params object[] parameterValues)
		{
			
			return SqlHelper.ExecuteNonQuery(CONN_STRING,spName,parameterValues);
		}

		public static int RunProcNonQuery(string spName)
		{
			return RunProcNonQuery(spName,null);
		}
		#endregion

		#region RunProcReader
		public static SqlDataReader RunProcReader(string spName,params object[] parameterValues)
		{
			return SqlHelper.ExecuteReader(CONN_STRING,spName,parameterValues);
		}
		#endregion

		#region RunProcTable

		public static DataTable RunProcTable(string spName,params object[] parameterValues)
		{
			return SqlHelper.ExecuteDataTable(CONN_STRING,spName,parameterValues);
		}
		#endregion

		#region RunProcScalar
		
		public static object RunProcScalar(string spName,params object[] parameterValues)
		{
			return SqlHelper.ExecuteScalar(CONN_STRING,spName,parameterValues);

		}
		#endregion

		
	}
}