Пример #1
0
        private static void FindEnumOld(TypedefItem type, EnumConfig enumConfig)
        {
            foreach (var item in type.Items.Values)
            {
                var oi = enumConfig.Items.FirstOrDefault(p => p.Option.ReferenceKey == item.Key);
                if (oi != null)
                {
                    continue;
                }
                enumConfig.Add(oi = new EnumItem
                {
                    Name  = CoderBase.ToWordName(item.Name),
                    Value = item.Value
                });
                oi.Option.ReferenceKey = item.Key;
            }
            enumConfig.Option.ReferenceKey = type.Key;
            if (enumConfig.Items.All(p => !string.Equals(p.Name, "None", StringComparison.OrdinalIgnoreCase)))
            {
                enumConfig.Add(new EnumItem
                {
                    Name    = "None",
                    Caption = "未知",
                    Value   = "0"
                });
            }
            var items = enumConfig.Items.OrderBy(p => p.Value).ToArray();

            enumConfig.Items.Clear();
            foreach (var item in items)
            {
                enumConfig.Add(item);
            }
        }
Пример #2
0
        private void DoImport()
        {
            _trace.Message1 = "连接数据库";
            _trace.Track    = _connectionString;
            using (MySqlConnection connection = new MySqlConnection(_connectionString))
            {
                _trace.Track = "正在连接...";
                connection.Open();
                _trace.Track = "连接成功";
                var tables = new List <string>();

                _trace.Message1 = "分析数据表";
                using (var cmd = connection.CreateCommand())
                {
                    _trace.Message2 = "读取表名";
                    _trace.Track    = "正在读取表名...";
                    cmd.CommandText =
                        $@"select Table_Name from information_schema.tables where table_schema='{_database}' and table_type='base table';";
                    using (var reader = cmd.ExecuteReader())
                    {
                        if (!reader.HasRows)
                        {
                            _trace.Message1 = "没有任何表";
                            return;
                        }
                        while (reader.Read())
                        {
                            tables.Add(reader.GetString(0));
                        }
                    }
                    _trace.Track = $@"读取成功({tables.Count})";
                }
                _trace.Message1 = "分析表结构";
                foreach (var t in tables)
                {
                    string table = t;
                    bool   isnew = false;
                    _trace.Message2 = table;
                    var entity = _solution.Entities.FirstOrDefault(p => string.Equals(p.SaveTable, table, StringComparison.OrdinalIgnoreCase));
                    if (entity == null)
                    {
                        isnew  = true;
                        entity = new EntityConfig
                        {
                            ReadTableName = table,
                            Name          = CoderBase.ToWordName(table),
                            Project       = _database
                        };
                        _trace.Track   = @"新增的表";
                        entity.Caption = BaiduFanYi.FanYi(entity.Name);
                        _dispatcher.Invoke(() =>
                        {
                            _project.Entities.Add(entity);
                            _solution.Entities.Add(entity);
                        });
                    }
                    _trace.Message3 = "列分析";
                    using (var cmd = connection.CreateCommand())
                    {
                        LoadColumn(_database, cmd, table, entity, isnew);
                    }
                }
            }
            _trace.Message1 = "完成";
        }
Пример #3
0
        /*
         * `TABLE_CATALOG` AS `TABLE_CATALOG`,
         * `TABLE_SCHEMA` AS `TABLE_SCHEMA`,
         * `TABLE_NAME` AS `TABLE_NAME`,
         * `COLUMN_NAME` AS `COLUMN_NAME`,
         * `ORDINAL_POSITION` AS `ORDINAL_POSITION`,
         * `COLUMN_DEFAULT` AS `COLUMN_DEFAULT`,
         * `IS_NULLABLE` AS `IS_NULLABLE`,
         * `DATA_TYPE` AS `DATA_TYPE`,
         * `CHARACTER_MAXIMUM_LENGTH` AS `CHARACTER_MAXIMUM_LENGTH`,
         * `CHARACTER_OCTET_LENGTH` AS `CHARACTER_OCTET_LENGTH`,
         * `NUMERIC_PRECISION` AS `NUMERIC_PRECISION`,
         * `NUMERIC_SCALE` AS `NUMERIC_SCALE`,
         * `DATETIME_PRECISION` AS `DATETIME_PRECISION`,
         * `CHARACTER_SET_NAME` AS `CHARACTER_SET_NAME`,
         * `COLLATION_NAME` AS `COLLATION_NAME`,
         * `COLUMN_TYPE` AS `COLUMN_TYPE`,
         * `COLUMN_KEY` AS `COLUMN_KEY`,
         * `EXTRA` AS `EXTRA`,
         * `PRIVILEGES` AS `PRIVILEGES`,
         * `COLUMN_COMMENT` AS `COLUMN_COMMENT`,
         * `GENERATION_EXPRESSION` AS `GENERATION_EXPRESSION`
         */
        private void LoadColumn(string db, MySqlCommand cmd, string table, EntityConfig entity, bool isNewEntity)
        {
            cmd.CommandText =
                $@"select COLUMN_NAME,IS_Nullable,DATA_TYPE,CHARACTER_MAXIMUM_LENGTH,COLUMN_KEY,COLUMN_COMMENT,EXTRA
from information_schema.columns where table_schema='{
                    db}' and table_name='{table}'";
            using (var reader = cmd.ExecuteReader())
            {
                if (!reader.HasRows)
                {
                    return;
                }
                while (reader.Read())
                {
                    var field = reader.GetString(0);
                    _trace.Message4 = field;
                    if (field == null)
                    {
                        continue;
                    }
                    var  dbType = reader.GetString(2);
                    var  column = entity.Properties.FirstOrDefault(p => string.Equals(p.ColumnName, field, StringComparison.OrdinalIgnoreCase));
                    bool isNew  = isNewEntity;
                    if (column == null)
                    {
                        _trace.Track = @"新字段";
                        isNew        = true;
                        column       = new PropertyConfig
                        {
                            ColumnName = field,
                            DbType     = dbType,
                            CsType     = ToCstringType(dbType),
                            Parent     = entity
                        };

                        InvokeInUiThread(() => entity.Properties.Add(column));
                        if (!reader.IsDBNull(5))
                        {
                            column.Caption = reader.GetString(5);
                        }
                        column.Description = column.Caption;
                    }
                    else if (column.DbType != dbType)
                    {
                        _trace.Track  = $@"字段类型变更:{column.DbType }->{dbType}";
                        column.DbType = dbType;
                        column.CsType = ToCstringType(column.DbType);
                    }
                    column.DbNullable   = reader.GetString(1) == "YES";
                    column.IsPrimaryKey = reader.GetString(4) == "PRI";

                    if (!reader.IsDBNull(3))
                    {
                        column.Datalen = (int)reader.GetInt64(3);
                    }

                    if (!reader.IsDBNull(6))
                    {
                        var ext = reader.GetString(6);
                        column.IsIdentity = ext.Contains("auto_increment");
                        if (column.IsIdentity)
                        {
                            _trace.Track = @"自增列";
                        }
                    }
                    if (!isNew)
                    {
                        continue;
                    }
                    _trace.Track = @"分析属性名称";
                    switch (column.DbType.ToLower())
                    {
                    case "varchar":
                    case "longtext":
                        column.Name = FirstBy(column.ColumnName, "m_str", "M_str", "m_", "M_");
                        break;

                    case "int":
                    case "tinyint":
                        column.Name = FirstBy(column.ColumnName, "m_b", "m_n", "m_", "M_");
                        break;

                    case "double":
                        column.Name = FirstBy(column.ColumnName, "m_d", "m_", "M_");
                        break;

                    default:
                        column.Name = FirstBy(column.ColumnName, "m_", "M_");
                        break;
                    }
                    column.Name  = CoderBase.ToWordName(column.Name ?? column.ColumnName);
                    _trace.Track = $@"属性名称:{column.Name}";
                    if (string.IsNullOrWhiteSpace(column.Caption))
                    {
                        column.Caption = BaiduFanYi.FanYi(column.Name);
                        _trace.Track   = $@"通过百度翻译得到中文名称:{column.Caption}";
                    }
                    else
                    {
                        CheckEnum(column);
                        if (column.EnumConfig != null)
                        {
                            column.EnumConfig.Name    = column.Name + "Type";
                            column.EnumConfig.Caption = column.Caption + "自定义类型";
                            column.CustomType         = column.EnumConfig.Name;
                            _trace.Track = $@"解析得到枚举类型:{column.EnumConfig.Name},参考内容{column.EnumConfig.Description}";
                        }
                    }
                    if (string.IsNullOrWhiteSpace(column.Description))
                    {
                        column.Description = column.Caption;
                    }
                    column.Caption = column.Caption.Split(CoderBase.NoneLanguageChar, 2)[0];
                }
            }
        }