コード例 #1
0
        /// <summary>
        /// 访问表达式中的函数调用
        /// </summary>
        /// <param name="node"></param>
        /// <param name="fieldName"></param>
        /// <returns></returns>
        protected Expression VisitMethodCall(MethodCallExpression node, string fieldName)
        {
            string sqlMethodName = node.Method.Name.ToLower();
            string callName      = SqlMethodNameCallBack.MethodNameCallback(sqlMethodName);

            if (!string.IsNullOrEmpty(callName))
            {
                parameters.Add(fieldName, new Parameter(callName, callName)
                {
                    IsMethodType = true
                });
            }
            else
            {
                throw new NotSupportedException(string.Format("{0}数据库中不支持函数{1}", "SqlServer", sqlMethodName));
            }

            return(base.VisitMethodCall(node));
        }
コード例 #2
0
        /// <summary>
        /// 访问方法
        /// </summary>
        /// <param name="node"></param>
        /// <returns></returns>
        protected override Expression VisitMethodCall(MethodCallExpression node)
        {
            var methodInfo = node.Method;

            if (methodInfo.DeclaringType == typeof(SQLMethod))
            {
                bool tleft = isleft;
                isleft = true;
                if (node.Arguments.Count > 0)
                {
                    this.Visit(node.Arguments[0]);
                }
                isleft = tleft;
                switch (methodInfo.Name)
                {
                case "IsNull":
                    sb.Append(" is NULL");
                    break;

                case "IsNotNull":
                    sb.Append(" is NOT NULL");
                    break;

                default:
                    string methodName = methodInfo.Name.ToLower();
                    string funcName   = SqlMethodNameCallBack.MethodNameCallback(methodName);

                    if (!string.IsNullOrEmpty(funcName))
                    {
                        sb.Append(funcName);
                    }
                    else
                    {
                        throw new NotSupportedException(
                                  string.Format("{0}数据库中不支持函数{1}", "sqlserver", methodName));
                    }
                    break;
                }
            }


            if (methodInfo.DeclaringType == typeof(string))
            {
                switch (methodInfo.Name)
                {
                case "Contains":
                    VisitStringFuncByOneParamter(node,
                                                 v => string.Format("%{0}%", v));
                    break;

                case "StartsWith":
                    VisitStringFuncByOneParamter(node,
                                                 v => string.Format("{0}%", v));
                    break;

                case "EndsWith":
                    VisitStringFuncByOneParamter(node,
                                                 v => string.Format("%{0}", v));
                    break;
                }
            }
            if (methodInfo.DeclaringType == typeof(Enumerable))
            {
                if (methodInfo.DeclaringType == typeof(Enumerable))
                {
                    this.Visit(node.Arguments[1]);
                    sb.Append(" In ");
                    this.Visit(node.Arguments[0]);
                }
            }
#if COREFX
            if (methodInfo.DeclaringType.GetTypeInfo().GetInterface("IEnumerable", false) != null)
#else
            if (methodInfo.DeclaringType?.GetInterface("IEnumerable", false) != null)
#endif
            {
                this.Visit(node.Arguments[0]);
                sb.Append(" In ");
                this.Visit(node.Object);
            }

            if (methodInfo.DeclaringType == typeof(System.Convert))
            {
                this.Visit(node.Arguments[0]);
            }


            return(node);
        }