转成DateTime - ConvertToDateTime

2017-02-21 22:41:19  访问(1447) 赞(0) 踩(0)

        /// <summary>
        /// 转成DateTime - ConvertToDateTime
        /// </summary>
        /// <param name="emDataBaseHelperValue">数据库类型</param>
        /// <param name="theValue"></param>
        /// <returns></returns>
        public string ConvertToDateTime
            (
                SlowX.DAL.Enums.DataBaseHelper.EmDataBaseHelper emDataBaseHelperValue,
                DateTime theValue
            )
        {

            switch (emDataBaseHelperValue)
            {
                case SlowX.DAL.Enums.DataBaseHelper.EmDataBaseHelper.Oracle:
                    return "to_date('" + theValue.ToString("yyyy-MM-dd HH:mm:ss") + "','yyyy-mm-dd hh24:mi:ss')";
                case SlowX.DAL.Enums.DataBaseHelper.EmDataBaseHelper.Access:
                case SlowX.DAL.Enums.DataBaseHelper.EmDataBaseHelper.Excel:
                    return "cdate('" + theValue.ToString() + "')";
                case SlowX.DAL.Enums.DataBaseHelper.EmDataBaseHelper.SQLServer:
                    return "convert(datetime,'" + theValue.ToString("yyyy-MM-dd HH:mm:ss") + "',20)";
                default:
                    throw new Exception
               (
                   "方法："
                   + MethodBase.GetCurrentMethod().ReflectedType.FullName
                   + " "
                   + MethodBase.GetCurrentMethod().ToString()
                   + " 发生异常："
                   + "枚举（"
                   + emDataBaseHelperValue.GetType().FullName
                   + "."
                   + emDataBaseHelperValue.ToString()
                   + "）未知，对应的代码尚未实现。"
               );
            }
        }

标签：转成DateTime - ConvertToDateTime 

上一条：

下一条：

相关评论

发表评论

类型：	留言 建议 疑问
内容：
	(Alt+Enter)