示例#1
0
        /// <summary>
        /// Inserv_ts a new Parameter at the given Index for the Command
        /// </summary>
        /// <param name="oCmd">The Command</param>
        /// <param name="iParameterIndex">The Index</param>
        /// <param name="sParameterName">Paramter Name</param>
        /// <param name="oParameterValue">Parameter Value</param>
        /// <param name="DbType">Parameter Type</param>
        public static void InsertParameter(System.Data.IDbCommand oCmd, int iParameterIndex, string sParameterName, object oParameterValue, XDbType DbType)
        {
            XrDbCommand   o      = (XrDbCommand)oCmd;
            XrDbParameter oParam = CreateParameter(sParameterName, oParameterValue, DbType, 0, System.Data.ParameterDirection.Input);

            o.Parameters.Insert(iParameterIndex, oParam);
        }
示例#2
0
        /// <summary>
        /// Adds a new Parameter to the Command
        /// </summary>
        /// <param name="oCmd">The Command</param>
        /// <param name="sParameterName">Parameter Name</param>
        /// <param name="oParameterValue">Parameter Value</param>
        /// <param name="DbType">Parameter Type</param>
        /// <param name="iSize">Data Size</param>
        /// <param name="pdDirection">Parameter Direction</param>
        public static void AddParameter(System.Data.IDbCommand oCmd, string sParameterName, object oParameterValue, XDbType DbType, int iSize, System.Data.ParameterDirection pdDirection)
        {
            XrDbCommand   o      = (XrDbCommand)oCmd;
            XrDbParameter oParam = CreateParameter(sParameterName, oParameterValue, DbType, iSize, pdDirection);

            // Replace or Add
            if (o.Parameters.Contains(sParameterName))
            {
                o.Parameters[sParameterName] = oParam;
            }
            else
            {
                o.Parameters.Add(oParam);
            }
        }
示例#3
0
        protected static XrDbParameter CreateParameter(string sParameterName, object oParameterValue, XDbType DbType, int iSize, System.Data.ParameterDirection direction)
        {
            XrDbParameter oParam;

            if (iSize != 0)
            {
                oParam = new XrDbParameter(sParameterName, (XrDbType)DbType, iSize);
            }
            else
            {
                oParam = new XrDbParameter(sParameterName, (XrDbType)DbType);
            }

            oParam.Direction = direction;
            oParam.Value     = oParameterValue;

            return(oParam);
        }