Exemple #1
0
        /// <summary>
        /// Вносит данные из загруженных файлов в базу данных используя BulkLoader.
        /// </summary>
        /// <param name="serverTableType"></param> тип используемых временных таблиц для загрузки
        public void BulkLoad(ServerTableType serverTableType)
        {
            try
            {
                SetBulkLists(serverTableType);
                switch (serverTableType)
                {
                case ServerTableType.Schema:
                    //ClearTables.ExecuteNonQuery();
                    break;

                case ServerTableType.GlobalTemp:
                    CreateTempFiasTables.ExecuteNonQuery();
                    break;

                case ServerTableType.ConnectionTemp:
                    break;
                }
                OperatingsLoad();
            }
            finally
            {
                switch (serverTableType)
                {
                case ServerTableType.Schema:
                    break;

                case ServerTableType.GlobalTemp:
                    break;

                case ServerTableType.ConnectionTemp:
                    break;
                }
            }
        }
Exemple #2
0
        public void MergeDB(ServerTableType serverTableType)
        {
            switch (serverTableType)
            {
            case ServerTableType.Schema:
                MERGE_fias_ActualStatus.ExecuteNonQuery();
                MERGE_fias_AddressObjectType.ExecuteNonQuery();
                MERGE_fias_CenterStatus.ExecuteNonQuery();
                MERGE_fias_CurrentStatus.ExecuteNonQuery();
                MERGE_fias_EstateStatus.ExecuteNonQuery();
                MERGE_fias_HouseStateStatus.ExecuteNonQuery();
                MERGE_fias_NormativeDocumentType.ExecuteNonQuery();
                MERGE_fias_OperationStatus.ExecuteNonQuery();
                MERGE_fias_RoomType.ExecuteNonQuery();
                MERGE_fias_StructureStatus.ExecuteNonQuery();
                MERGE_fias_NormativeDocument.ExecuteNonQuery();
                MERGE_fias_Object.ExecuteNonQuery();
                MERGE_fias_House.ExecuteNonQuery();
                MERGE_fias_Room.ExecuteNonQuery();
                MERGE_fias_Stead.ExecuteNonQuery();
                break;

            case ServerTableType.GlobalTemp:
                MERGE_GlobalTempActualStatus.ExecuteNonQuery();
                MERGE_GlobalTempAddressObjectType.ExecuteNonQuery();
                MERGE_GlobalTempCenterStatus.ExecuteNonQuery();
                MERGE_GlobalTempCurrentStatus.ExecuteNonQuery();
                MERGE_GlobalTempEstateStatus.ExecuteNonQuery();
                MERGE_GlobalTempHouseStateStatus.ExecuteNonQuery();
                MERGE_GlobalTempNormativeDocumentType.ExecuteNonQuery();
                MERGE_GlobalTempOperationStatus.ExecuteNonQuery();
                MERGE_GlobalTempRoomType.ExecuteNonQuery();
                MERGE_GlobalTempStructureStatus.ExecuteNonQuery();
                MERGE_GlobalTempNormativeDocument.ExecuteNonQuery();
                MERGE_GlobalTempObject.ExecuteNonQuery();
                MERGE_GlobalTempHouse.ExecuteNonQuery();
                MERGE_GlobalTempRoom.ExecuteNonQuery();
                MERGE_GlobalTempStead.ExecuteNonQuery();
                break;

            case ServerTableType.ConnectionTemp:
                MERGE_LocalTempActualStatus.ExecuteNonQuery();
                MERGE_LocalTempAddressObjectType.ExecuteNonQuery();
                MERGE_LocalTempCenterStatus.ExecuteNonQuery();
                MERGE_LocalTempCurrentStatus.ExecuteNonQuery();
                MERGE_LocalTempEstateStatus.ExecuteNonQuery();
                MERGE_LocalTempHouseStateStatus.ExecuteNonQuery();
                MERGE_LocalTempNormativeDocumentType.ExecuteNonQuery();
                MERGE_LocalTempOperationStatus.ExecuteNonQuery();
                MERGE_LocalTempRoomType.ExecuteNonQuery();
                MERGE_LocalTempStructureStatus.ExecuteNonQuery();
                MERGE_LocalTempNormativeDocument.ExecuteNonQuery();
                MERGE_LocalTempObject.ExecuteNonQuery();
                MERGE_LocalTempHouse.ExecuteNonQuery();
                MERGE_LocalTempRoom.ExecuteNonQuery();
                MERGE_LocalTempStead.ExecuteNonQuery();
                break;
            }
        }
Exemple #3
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="serverTableType"></param>
        protected void SetBulkLists(ServerTableType serverTableType)
        {
            List <IMerge> bulkList = new List <IMerge>();

            foreach (var pattern in patterns)
            {
                foreach (FileInfo file in Rootdir.GetFiles(pattern.Pattern).OrderBy(file => file.Length))
                {
                    bulkList.Add(new BulkTableOperator(pattern.TableName, SchemaName, file, serverTableType, Connection));
                }
            }
            OperatingLists.Add(bulkList);
        }
 public BulkTableOperator(string tableName, string tableSchema, FileInfo file, ServerTableType serverTableType = ServerTableType.Schema, SqlConnection connection = null) : base(file, connection)
 {
     TableName       = tableName;
     TableSchema     = tableSchema;
     ServerTableType = serverTableType;
 }