/// <summary>
        /// 模糊转义
        /// </summary>
        /// <param name="value"></param>
        /// <param name="param"></param>
        /// <returns></returns>
        public override object FuzzyEscaping(object value, ref string param, EFuzzyLocation eFuzzyLocation = EFuzzyLocation.Both)
        {
            if (value != null && value.ToString() != string.Empty)
            {
                switch (eFuzzyLocation)
                {
                case EFuzzyLocation.Right:
                    value = $@"\{value}%";
                    break;

                case EFuzzyLocation.Left:
                    value = $@"%\{value}";
                    break;

                case EFuzzyLocation.Both:
                default:
                    value = $@"%\{value}%";
                    break;
                }
                param += @" ESCAPE'\'";
            }
            else
            {
                base.FuzzyEscaping(value, ref param, eFuzzyLocation);
            }
            return(value);
        }
Пример #2
0
        /// <summary>
        /// 模糊转义
        /// </summary>
        /// <param name="value"></param>
        /// <param name="param"></param>
        /// <returns></returns>
        public virtual object FuzzyEscaping(object value, ref string param, EFuzzyLocation eFuzzyLocation = EFuzzyLocation.Both)
        {
            switch (eFuzzyLocation)
            {
            case EFuzzyLocation.Right:
                value = $"{value}%";
                return(value);

            case EFuzzyLocation.Left:
                value = $"%{value}";
                return(value);

            case EFuzzyLocation.Both:
            default:
                value = $"%{value}%";
                return(value);
            }
        }