C# (CSharp) ExecutableCommand.AddParameter示例

示例#1

文件： SQLHelper.cs 项目： jiguixin/Craig-s-Utility-Library

 /// <summary>
 /// Adds a parameter to the call (for all types other than strings)
 /// </summary>
 /// <param name="ID">Name of the parameter</param>
 /// <param name="Value">Value to add</param>
 /// <param name="Type">SQL type of the parameter</param>
 /// <param name="Direction">Parameter direction (defaults to input)</param>
 public virtual void AddParameter(string ID, DbType Type, object Value = null, ParameterDirection Direction = ParameterDirection.Input)
 {
     if (ExecutableCommand != null)
     {
         ExecutableCommand.AddParameter(ID, Type, Value, Direction);
     }
 }

示例#2

文件： SQLHelper.cs 项目： jiguixin/Craig-s-Utility-Library

 /// <summary>
 /// Adds a parameter to the call (for strings only)
 /// </summary>
 /// <param name="ID">Name of the parameter</param>
 /// <param name="Value">Value to add</param>
 /// <param name="Length">Size of the string(either -1 or greater than 4000 should be used to indicate nvarchar(max))</param>
 /// <param name="Direction">Parameter direction (defaults to input)</param>
 public virtual void AddParameter(string ID, int Length, string Value = "", ParameterDirection Direction = ParameterDirection.Input)
 {
     if (ExecutableCommand != null)
     {
         ExecutableCommand.AddParameter(ID, Length, Value, Direction);
     }
 }

示例#3

文件： SQLHelper.cs 项目： MarkWalls/Craig-s-Utility-Library

 /// <summary>
 /// Adds a parameter to the call (for all types other than strings)
 /// </summary>
 /// <param name="ID">Name of the parameter</param>
 /// <param name="Value">Value to add</param>
 /// <param name="Type">SQL type of the parameter</param>
 /// <param name="Direction">Parameter direction (defaults to input)</param>
 /// <returns>This</returns>
 public virtual SQLHelper AddParameter(string ID, DbType Type, object Value = null, ParameterDirection Direction = ParameterDirection.Input)
 {
     if (ExecutableCommand != null)
     {
         ExecutableCommand.AddParameter(ID, Type, Value, Direction);
     }
     return(this);
 }

示例#4

文件： SQLHelper.cs 项目： MarkWalls/Craig-s-Utility-Library

 /// <summary>
 /// Adds a parameter to the call (for strings only)
 /// </summary>
 /// <param name="ID">Name of the parameter</param>
 /// <param name="Value">Value to add</param>
 /// <param name="Length">Size of the string(either -1 or greater than 4000 should be used to indicate nvarchar(max))</param>
 /// <param name="Direction">Parameter direction (defaults to input)</param>
 /// <returns>This</returns>
 public virtual SQLHelper AddParameter(string ID, int Length, string Value = "", ParameterDirection Direction = ParameterDirection.Input)
 {
     if (ExecutableCommand != null)
     {
         ExecutableCommand.AddParameter(ID, Length, Value, Direction);
     }
     return(this);
 }