Exemple #1
0
        /// <summary>根据数据行取得数据表</summary>
        /// <param name="rows">数据行</param>
        /// <param name="names">指定表名</param>
        /// <param name="data">扩展</param>
        /// <returns></returns>
        protected List <IDataTable> GetTables(DataRow[] rows, String[] names, IDictionary <String, DataTable> data = null)
        {
            if (rows == null || rows.Length == 0)
            {
                return(new List <IDataTable>());
            }

            // 表名过滤
            if (names != null && names.Length > 0)
            {
                var hs = new HashSet <String>(names, StringComparer.OrdinalIgnoreCase);
                rows = rows.Where(dr => TryGetDataRowValue(dr, _.TalbeName, out String name) && hs.Contains(name)).ToArray();
            }

            var columns      = data?["Columns"];
            var indexes      = data?["Indexes"];
            var indexColumns = data?["IndexColumns"];

            if (columns == null)
            {
                columns = GetSchema(_.Columns, null);
            }
            if (indexes == null)
            {
                indexes = GetSchema(_.Indexes, null);
            }
            if (indexColumns == null)
            {
                indexColumns = GetSchema(_.IndexColumns, null);
            }

            var list = new List <IDataTable>();

            foreach (var dr in rows)
            {
                #region 基本属性
                var table = DAL.CreateTable();
                table.TableName = GetDataRowValue <String>(dr, _.TalbeName);

                // 描述
                table.Description = GetDataRowValue <String>(dr, "DESCRIPTION");

                // 拥有者
                table.Owner = GetDataRowValue <String>(dr, "OWNER");

                // 是否视图
                table.IsView = "View".EqualIgnoreCase(GetDataRowValue <String>(dr, "TABLE_TYPE"));

                table.DbType = Database.Type;
                #endregion

                #region 字段及修正
                var cs = GetFields(table, columns, data);
                if (cs != null && cs.Count > 0)
                {
                    table.Columns.AddRange(cs);
                }

                var dis = GetIndexes(table, indexes, indexColumns);
                if (dis != null && dis.Count > 0)
                {
                    table.Indexes.AddRange(dis);
                }

                FixTable(table, dr, data);

                // 修正关系数据
                table.Fix();

                list.Add(table);
                #endregion
            }

            return(list);
        }
Exemple #2
0
        /// <summary>根据数据行取得数据表</summary>
        /// <param name="rows">数据行</param>
        /// <returns></returns>
        protected List <IDataTable> GetTables(DataRow[] rows)
        {
            if (_columns == null)
            {
                try { _columns = GetSchema(_.Columns, null); }
                catch (Exception ex) { DAL.WriteDebugLog(ex.ToString()); }
            }
            if (_indexes == null)
            {
                try { _indexes = GetSchema(_.Indexes, null); }
                catch (Exception ex) { DAL.WriteDebugLog(ex.ToString()); }
            }
            if (_indexColumns == null)
            {
                try { _indexColumns = GetSchema(_.IndexColumns, null); }
                catch (Exception ex) { DAL.WriteDebugLog(ex.ToString()); }
            }

            try
            {
                var list = new List <IDataTable>();
                foreach (DataRow dr in rows)
                {
                    #region 基本属性
                    IDataTable table = DAL.CreateTable();
                    table.TableName = GetDataRowValue <String>(dr, _.TalbeName);

                    // 顺序、编号
                    Int32 id = 0;
                    if (TryGetDataRowValue <Int32>(dr, "TABLE_ID", out id))
                    {
                        table.ID = id;
                    }
                    else
                    {
                        table.ID = list.Count + 1;
                    }

                    // 描述
                    table.Description = GetDataRowValue <String>(dr, "DESCRIPTION");

                    // 拥有者
                    table.Owner = GetDataRowValue <String>(dr, "OWNER");

                    // 是否视图
                    table.IsView = "View".EqualIgnoreCase(GetDataRowValue <String>(dr, "TABLE_TYPE"));

                    table.DbType = Database.DbType;
                    #endregion

                    #region 字段及修正
                    // 字段的获取可能有异常,但不应该影响整体架构的获取
                    try
                    {
                        var columns = GetFields(table);
                        if (columns != null && columns.Count > 0)
                        {
                            table.Columns.AddRange(columns);
                        }

                        var indexes = GetIndexes(table);
                        if (indexes != null && indexes.Count > 0)
                        {
                            table.Indexes.AddRange(indexes);
                        }

                        // 先修正一次关系数据
                        table.Fix();
                    }
                    catch (Exception ex)
                    {
                        if (DAL.Debug)
                        {
                            DAL.WriteLog(ex.ToString());
                        }
                    }

                    FixTable(table, dr);

                    list.Add(table);
                    #endregion
                }

                #region 表间关系处理
                //// 某字段名,为另一个表的(表名+单主键名)形式时,作为关联字段处理
                //foreach (var table in list)
                //{
                //    foreach (var rtable in list)
                //    {
                //        if (table != rtable) table.Connect(rtable);
                //    }
                //}
                ModelHelper.Connect(list);

                //// 因为可能修改了表间关系,再修正一次
                //foreach (var table in list)
                //{
                //    table.Fix();
                //}
                #endregion

                return(list);
                // 不要把这些清空。因为,多线程同时操作的时候,前面的线程有可能把后面线程的数据给清空了
            }
            finally
            {
                _columns      = null;
                _indexes      = null;
                _indexColumns = null;
            }
        }