将枚举SlowX.Core.Enums.SqlLink.EmSqlLink转换为实际的操作符 - ConvertEmSqlLink

2017-02-19 10:53:57 访问(1548) 赞(0) 踩(0)


        /// <summary>
        /// 将枚举SlowX.Core.Enums.SqlLink.EmSqlLink转换为实际的操作符 - ConvertEmSqlLink
        /// </summary>
        /// <param name="_emSqlLink"></param>
        /// <returns></returns>
        public static string ConvertEmSqlLink
            (
                SlowX.Core.Enums.SqlLink.EmSqlLink _emSqlLink)
        {

            switch (_emSqlLink)
            {
                case SlowX.Core.Enums.SqlLink.EmSqlLink.Equal:
                    return "=";

                case SlowX.Core.Enums.SqlLink.EmSqlLink.Less:
                    return "<";

                case SlowX.Core.Enums.SqlLink.EmSqlLink.LessEqual:
                    return "<=";

                case SlowX.Core.Enums.SqlLink.EmSqlLink.Greater:
                    return ">";

                case SlowX.Core.Enums.SqlLink.EmSqlLink.GreaterEqual:
                    return ">=";

                case SlowX.Core.Enums.SqlLink.EmSqlLink.NotEqual:
                    // 
                    //return  "!="; // 不行，Access不支持
                    //
                    return "<>";

                case SlowX.Core.Enums.SqlLink.EmSqlLink._Like_:
                    return "like";

                case SlowX.Core.Enums.SqlLink.EmSqlLink.Like_:
                    return "like";

                case SlowX.Core.Enums.SqlLink.EmSqlLink._Like:
                    return "like";

                case SlowX.Core.Enums.SqlLink.EmSqlLink.Like:
                    return "like";

                case SlowX.Core.Enums.SqlLink.EmSqlLink._NotLike_:
                    return "not like";

                case SlowX.Core.Enums.SqlLink.EmSqlLink._NotLike:
                    return "not like";

                case SlowX.Core.Enums.SqlLink.EmSqlLink.NotLike_:
                    return "not like";

                case SlowX.Core.Enums.SqlLink.EmSqlLink.NotLike:
                    return "not like";

                case SlowX.Core.Enums.SqlLink.EmSqlLink.In:
                    return "in";

                case SlowX.Core.Enums.SqlLink.EmSqlLink.NotIn:
                    return "not in"; 

                default:

                    throw new Exception
                        (
                            "方法："
                            + MethodBase.GetCurrentMethod().ReflectedType.FullName
                            + " "
                            + MethodBase.GetCurrentMethod().ToString()
                            + " 发生异常："
                            + "枚举（"
                            + _emSqlLink.GetType().FullName
                            + "."
                            + _emSqlLink.ToString()
                            + "）未知，对应的代码尚未实现。"
                        );


            }
        }