fieldconverter.cs

动易SiteFactory&#8482 网上商店系统1.0源代码

namespace PowerEasy.SqlServerDal.Contents
{
    using PowerEasy.Enumerations;
    using System;
    using System.Data;
    using System.Text;

    public sealed class FieldConverter
    {
        private FieldConverter()
        {
        }

        public static DbType GetFieldParameType(FieldType fieldType)
        {
            switch (fieldType)
            {
                case FieldType.TextType:
                case FieldType.MultipleTextType:
                case FieldType.MultipleHtmlTextType:
                case FieldType.ListBoxType:
                case FieldType.LookType:
                case FieldType.LinkType:
                case FieldType.CountType:
                case FieldType.PictureType:
                case FieldType.FileType:
                case FieldType.ColorType:
                case FieldType.TemplateType:
                case FieldType.AuthorType:
                case FieldType.SourceType:
                case FieldType.KeywordType:
                case FieldType.OperatingType:
                case FieldType.Producer:
                case FieldType.Trademark:
                case FieldType.ContentType:
                case FieldType.TitleType:
                case FieldType.MultiplePhotoType:
                    return DbType.String;

                case FieldType.NumberType:
                    return DbType.Double;

                case FieldType.MoneyType:
                    return DbType.Currency;

                case FieldType.DateTimeType:
                    return DbType.DateTime;

                case FieldType.BoolType:
                    return DbType.Boolean;
            }
            return DbType.Int32;
        }

        public static void GetFieldSqlType(FieldType fieldType, StringBuilder sqlText)
        {
            switch (fieldType)
            {
                case FieldType.TextType:
                case FieldType.ListBoxType:
                case FieldType.LookType:
                case FieldType.CountType:
                case FieldType.ColorType:
                case FieldType.TemplateType:
                case FieldType.AuthorType:
                case FieldType.SourceType:
                case FieldType.KeywordType:
                case FieldType.OperatingType:
                case FieldType.Producer:
                case FieldType.Trademark:
                case FieldType.TitleType:
                    sqlText.Append("[nvarchar] (255)");
                    return;

                case FieldType.MultipleTextType:
                case FieldType.MultipleHtmlTextType:
                case FieldType.LinkType:
                case FieldType.PictureType:
                case FieldType.FileType:
                case FieldType.ContentType:
                case FieldType.MultiplePhotoType:
                    sqlText.Append("[ntext]");
                    return;

                case FieldType.NumberType:
                    sqlText.Append(" [float] ");
                    return;

                case FieldType.MoneyType:
                    sqlText.Append(" [money] ");
                    return;

                case FieldType.DateTimeType:
                    sqlText.Append("[datetime]");
                    return;

                case FieldType.BoolType:
                    sqlText.Append("[bit]");
                    return;
            }
            sqlText.Append("[Int]");
        }
    }
}