获得当前时间的SQL脚本 - GetNowSqlScript

2017-02-21 22:42:20 访问(1668) 赞(0) 踩(0)



        /// <summary>
        /// 获得当前时间的SQL脚本 - GetNowSqlScript
        /// </summary>
        /// <param name="emDataBaseHelperValue">数据库类型</param>
        /// <returns></returns>
        public string GetNowSqlScript(SlowX.DAL.Enums.DataBaseHelper.EmDataBaseHelper emDataBaseHelperValue)
        {
            switch (emDataBaseHelperValue)
            {
                case Enums.DataBaseHelper.EmDataBaseHelper.Access:
                    return "now()";
                case Enums.DataBaseHelper.EmDataBaseHelper.Excel:
                    return "now()";
                case Enums.DataBaseHelper.EmDataBaseHelper.Oracle:
                    return "sysdate";
                case Enums.DataBaseHelper.EmDataBaseHelper.SQLServer:
                    return "getdate()";
                default:
                    throw new Exception
               (
                   "方法："
                   + MethodBase.GetCurrentMethod().ReflectedType.FullName
                   + " "
                   + MethodBase.GetCurrentMethod().ToString()
                   + " 发生异常："
                   + "枚举（"
                   + emDataBaseHelperValue.GetType().FullName
                   + "."
                   + emDataBaseHelperValue.ToString()
                   + "）未知，对应的代码尚未实现。"
               );
            }
        }