storedprocedures.cs

客户关系管理系统ASP.NET+VB.NET编程完整程序！

using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using System.Reflection;

using OrmLib;

namespace ORMBiz
{
	/// <summary>
	/// Wraps stored proceedure calls
	/// </summary>
	public class StoredProcedures 
	{
		private	static DataManager dm;
		/// <summary>
		/// Wraps stored proceedure calls
		/// </summary>
		static StoredProcedures() { dm = new DataManager(Config.Dsn);}
	
		/// <summary>
		/// Calls DeleteDatabase, returning a DataSet of any rows returned 
		/// from the stored proceedure.
		/// </summary>
		/// <returns>DataSet</returns>
		public static DataSet DeleteDatabase(  System.Int32 FKDatabaseID )
		{
			ArrayList arrayParams = new ArrayList();
	
			SqlParameter paramFKDatabaseID = new SqlParameter( "@FKDatabaseID", FKDatabaseID);
			paramFKDatabaseID.SqlDbType = (SqlDbType) Enum.Parse( typeof(SqlDbType), "int", true);
			paramFKDatabaseID.Direction = ParameterDirection.Input;
			paramFKDatabaseID.Size = 4;
			arrayParams.Add( paramFKDatabaseID );


			DataSet ds = dm.ExecuteProcedure("DeleteDatabase", (SqlParameter[]) arrayParams.ToArray(typeof(SqlParameter)));
			
			return ds;
		}

		/// <summary>
		/// Calls sp_LogMetrics, returning a DataSet of any rows returned 
		/// from the stored proceedure.
		/// </summary>
		/// <returns>DataSet</returns>
		public static DataSet sp_LogMetrics(  System.Guid instanceId,
  System.String traceMsg )
		{
			ArrayList arrayParams = new ArrayList();
	
			SqlParameter paraminstanceId = new SqlParameter( "@instanceId", instanceId);
			paraminstanceId.SqlDbType = (SqlDbType) Enum.Parse( typeof(SqlDbType), "uniqueidentifier", true);
			paraminstanceId.Direction = ParameterDirection.Input;
			paraminstanceId.Size = 16;
			arrayParams.Add( paraminstanceId );

			SqlParameter paramtraceMsg = new SqlParameter( "@traceMsg", traceMsg);
			paramtraceMsg.SqlDbType = (SqlDbType) Enum.Parse( typeof(SqlDbType), "varchar", true);
			paramtraceMsg.Direction = ParameterDirection.Input;
			paramtraceMsg.Size = 200;
			arrayParams.Add( paramtraceMsg );


			DataSet ds = dm.ExecuteProcedure("sp_LogMetrics", (SqlParameter[]) arrayParams.ToArray(typeof(SqlParameter)));
			
			return ds;
		}

		/// <summary>
		/// Calls ProcessSchemaUpdate, returning a DataSet of any rows returned 
		/// from the stored proceedure.
		/// </summary>
		/// <returns>DataSet</returns>
		public static DataSet ProcessSchemaUpdate(  System.String xml,
  System.Int32 FKDatabaseID )
		{
			ArrayList arrayParams = new ArrayList();
	
			SqlParameter paramxml = new SqlParameter( "@xml", xml);
			paramxml.SqlDbType = (SqlDbType) Enum.Parse( typeof(SqlDbType), "text", true);
			paramxml.Direction = ParameterDirection.Input;
			paramxml.Size = 16;
			arrayParams.Add( paramxml );

			SqlParameter paramFKDatabaseID = new SqlParameter( "@FKDatabaseID", FKDatabaseID);
			paramFKDatabaseID.SqlDbType = (SqlDbType) Enum.Parse( typeof(SqlDbType), "int", true);
			paramFKDatabaseID.Direction = ParameterDirection.Input;
			paramFKDatabaseID.Size = 4;
			arrayParams.Add( paramFKDatabaseID );


			DataSet ds = dm.ExecuteProcedure("ProcessSchemaUpdate", (SqlParameter[]) arrayParams.ToArray(typeof(SqlParameter)));
			
			return ds;
		}

		/// <summary>
		/// Calls test, returning a DataSet of any rows returned 
		/// from the stored proceedure.
		/// </summary>
		/// <returns>DataSet</returns>
		public static DataSet test(  )
		{
			ArrayList arrayParams = new ArrayList();
	

			DataSet ds = dm.ExecuteProcedure("test", (SqlParameter[]) arrayParams.ToArray(typeof(SqlParameter)));
			
			return ds;
		}


	}
}