using System.Data;

namespace CSFramework.DB.Common
{
    /// <summary>
    /// 数据类型转换工具类(SqlType,.Net Type,DbType)三者互相转换
    /// </summary>
    public class DataTypeConverter
    {
        /// <summary>
        /// 将SQLServer数据类型（如：varchar）转换为.Net类型（如：String）
        /// </summary>
        /// <param name="sqlTypeString">SQLServer数据类型</param>
        /// <returns></returns>
        public static string SqlTypeName2DotNetType(string sqlTypeString)
        {
            return DBDataTypes.GetNetTypeByMsSql(sqlTypeString).Name;
        }

        /// <summary>
        /// 将SQLServer数据类型（如：varchar）转换为DbType类型（如：String）
        /// </summary>
        /// <param name="sqlTypeString">SQLServer数据类型</param>
        /// <returns></returns>
        public static DbType SqlTypeName2DbType(string sqlTypeString)
        {
            return DBDataTypes.GetDbTypeByMsSqlType(sqlTypeString);
        }

        /// <summary>
        /// 将.NET数据类型（如：String）转换为DbType类型（如：String）
        /// </summary>
        /// <param name="dotNetTypeString">.NET数据类型</param>
        /// <returns></returns>
        public static DbType DotNetType2DbType(string dotNetTypeString)
        {
            return DBDataTypes.GetDbType(dotNetTypeString);
        }
    }
}