大写 - GetUpper

2017-02-21 22:41:34 访问(1371) 赞(0) 踩(0)


        /// <summary>
        /// 大写 - GetUpper
        /// </summary>
        /// <param name="str"></param>
        /// <param name="emDataBaseHelperValue">数据库类型</param>
        /// <returns></returns>
        public string GetUpper
            (
                SlowX.DAL.Enums.DataBaseHelper.EmDataBaseHelper emDataBaseHelperValue,
                string str
            )
        {
            StringBuilder theResult = new StringBuilder();

            switch (emDataBaseHelperValue)
            {
                case SlowX.DAL.Enums.DataBaseHelper.EmDataBaseHelper.Access:
                case SlowX.DAL.Enums.DataBaseHelper.EmDataBaseHelper.Excel:

                    theResult.Append("ucase(");
                    theResult.Append(str);
                    theResult.Append(")");

                    return theResult.ToString();

                case SlowX.DAL.Enums.DataBaseHelper.EmDataBaseHelper.Oracle:

                    theResult.Append("upper(");
                    theResult.Append(str);
                    theResult.Append(")");

                    return theResult.ToString();

                case SlowX.DAL.Enums.DataBaseHelper.EmDataBaseHelper.SQLServer:
                    theResult.Append("upper(");
                    theResult.Append(str);
                    theResult.Append(")");

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