sqlattributes.cs

SharpNuke源代码

using System;
using System.Data;

//
// DotNetNuke -  http://www.dotnetnuke.com
// Copyright (c) 2002-2005
// by Shaun Walker ( [e-mail] ) of Perpetual Motion Interactive Systems Inc. ( http://www.perpetualmotion.ca )
//
// Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated
// documentation files (the "Software"), to deal in the Software without restriction, including without limitation
// the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and
// to permit persons to whom the Software is furnished to do so, subject to the following conditions:
//
// The above copyright notice and this permission notice shall be included in all copies or substantial portions
// of the Software.
//
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED
// TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL
// THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF
// CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
// DEALINGS IN THE SOFTWARE.
//


namespace DotNetNuke.Data
{
	
	//
	// SQLAttributes
	//
	// Sample Usage:
	//
	// Public Function SomeMethod( 
	//     ByVal SomeParameter1 As String,
	//     <SqlParameter(, , , , , ParameterDirection.Output)> ByVal SomeParameter2 As Integer) As Integer
	//
	//
	
	[AttributeUsage(AttributeTargets.Parameter)]
	public class SqlParameterAttribute : Attribute
	{
		private string name;
		private bool paramTypeDefined;
		private SqlDbType paramType;
		private int size;
		private byte precision;
		private byte scale;
		private bool directionDefined;
		private ParameterDirection direction;
		
		public SqlParameterAttribute(string name, int size, byte precision, byte scale) 
		{
			this.name = name;
			this.size = size;
			this.precision = precision;
			this.scale = scale;
		} //New
		
		public SqlParameterAttribute(string name, SqlDbType paramType, int size, byte precision, byte scale, 
			ParameterDirection direction) 
		{
			this.name = name;
			this.paramType = paramType;
			this.paramTypeDefined = true;
			this.size = size;
			this.precision = precision;
			this.scale = scale;
			this.direction = direction;
			this.directionDefined = true;
		} //New
		
		public string Name
		{
			get { return this.name == null ? string.Empty : this.name; }
			set { this.name = value; }
		}
		
		public int Size
		{
			get { return this.size; }			
			set { this.size = value; }
		}
		
		public byte Precision
		{
			get { return this.precision; }
			set { this.precision = value; }
		}
		
		public byte Scale
		{
			get { return this.scale; }
			set { this.scale = value; }
		}
		
		public ParameterDirection Direction
		{
			get { return this.direction; }
			set { this.direction = value; }
		}
		
		public SqlDbType SqlDbType
		{
			get { return this.paramType; }
			set { this.paramType = value; }
		}
		
		public bool IsNameDefined
		{
			get { return (name != null && name.Length > 0); }
		}
		
		public bool IsSizeDefined
		{
			get { return this.size != 0; }
		}
		
		public bool IsTypeDefined
		{
			get { return this.paramTypeDefined; }
		}
		
		public bool IsDirectionDefined
		{
			get { return this.directionDefined; }
		}
		
		public bool IsScaleDefined
		{
			get { return this.scale != 0; }
		}
		
		public bool IsPrecisionDefined
		{
			get { return this.precision != 0; }
		}
		
	}
	
	[AttributeUsage(AttributeTargets.Parameter)]
	public sealed class NonCommandParameterAttribute : Attribute
	{
	}
	
}