dataaccesslayer.cs

Windows CE Web应用MobileQQ

using System;
using System.Data.SqlClient;
using System.Data;
namespace DateAccessLayer
{
	/// <summary>
	/// Class1 的摘要说明。
	/// </summary>
	/// 



	public class DataCommand
	{

		private DataCommand()
		{
		
		}

		public static SqlCommand BuildStoredProcCmd(string procName , SqlParameter[] parameters)
		{
			SqlConnection conn = DataConnection.Build();
			SqlCommand comm = conn.CreateCommand();
			comm.CommandType = CommandType.StoredProcedure;
			comm.CommandText = procName;
			for(int i=0 ; i<parameters.Length ; i++)
				comm.Parameters.Add(parameters[i]);
			return comm;
		}

		public static SqlCommand BuildStoredProcCmd(string procName)
		{
			SqlConnection conn = DataConnection.Build();
			SqlCommand comm = conn.CreateCommand();
			comm.CommandType = CommandType.StoredProcedure;
			comm.CommandText = procName;
			return comm;
		}

		public static SqlParameter BuildParameter(string paramName , SqlDbType paramType, int paramSize , ParameterDirection direction ,Object paramValue)
		{
			SqlParameter param = new SqlParameter(paramName ,paramType , paramSize);
			param.Direction = direction;
			param.Value = paramValue;
			return param;
		}
	
		public static void DestroyCmd(SqlCommand cmd)
		{
			if(cmd.Connection.State == ConnectionState.Open )
			{
				cmd.Connection.Close();
				cmd.Connection.Dispose();
			}
			cmd.Dispose();
		}
		

	}

	public class DataConnection
	{
		static string m_connectionString=null;

		public static string ConnectionString
		{
			get
			{
				if(m_connectionString == null)
				{
					m_connectionString= System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];			
				}
				return m_connectionString;
			}
			
			set
			{
				m_connectionString = value;
			}
		}

		private  DataConnection()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		
		public static SqlConnection Build()
		{
			SqlConnection conn = new SqlConnection(ConnectionString);
			return conn;			
		}
	
	}


}