数据库字段类型创建 - DataColumnTypeCreate

2017-03-05 10:33:14 访问(1413) 赞(0) 踩(0)


        /// <summary>
        /// 数据库字段类型创建 - DataColumnTypeCreate
        /// </summary>
        /// <param name="em"></param>
        /// <param name="_dataBaseVersion"></param>
        /// <param name="da"></param>
        /// <param name="info"></param>
        /// <returns></returns>
        protected string DataColumnTypeCreate
            (
                SlowX.DAL.Enums.DataBaseHelper.EmDataBaseHelper em,
                int _dataBaseVersion,
                DataBaseTableAttribute da,
                DataBaseColumnAttribute info
            )
        {
            string strLowerDataColumnType 
                = 
                info.DataColumnType.Trim().ToLower();

            switch (strLowerDataColumnType)
            {
                case "bigint":
                case "int":
                case "integer":
                case "date":
                case "datetime":
                case "clob":
                case "blob":
                case "image":
                case "ntext":
                case "text":                    
                    return info.DataColumnType;
                case "char":
                case "varchar":
                case "nvarchar":
                case "varchar2":
                    return info.DataColumnType + "(" + info.SqlSize.ToString() + ")";
                default:

                    if (info.SqlSize == 0)
                        return info.DataColumnType;

                    if (info.SqlSizeEnd == 0)
                        return info.DataColumnType + "(" + info.SqlSize.ToString() + ")";

                    return info.DataColumnType + "(" + info.SqlSize.ToString() + ", " + info.SqlSizeEnd.ToString() + ")";

            }

        }