public void Setup() { conductor = new Conductor(); billet = new InsulatedBillet { Conductor = conductor, PolymerGroup = new PolymerGroup() }; coverPolymerGroup = new PolymerGroup(); fireProtectionClass = new FireProtectionClass(); twistedElementType = new TwistedElementType(); operatingVoltage250 = new OperatingVoltage { ACVoltage = 380, ACFriquency = 400, DCVoltage = 540 }; operatingVoltage660 = new OperatingVoltage { ACVoltage = 660, ACFriquency = 400, DCVoltage = 1000 }; builder = new SkabTitleBuilder(); cable = new Cable { CoverPolymerGroup = coverPolymerGroup, TwistedElementType = twistedElementType, FireProtectionClass = fireProtectionClass, }; }
public override int ParseDataToDatabase() { _recordsCount = 0; var configuratorTSimpleAndKG = new TableParserConfigurator(3, 2, 9, 6, 2, 1); var configuratorTSimpleAndKGS = new TableParserConfigurator(9, 2, 9, 6, 2, 1); var configuratorK = new TableParserConfigurator(3, 2, 7, 6, 2, 1); var configuratorKS = new TableParserConfigurator(9, 2, 7, 6, 2, 1); var techCond = _dbContext.TechnicalConditions.Where(c => c.Title == "ТУ 16.К99-037-2009").First(); var voltage = _dbContext.OperatingVoltages.Find(5); var climaticModUHL = _dbContext.ClimaticMods.Where(c => c.Title == "УХЛ").First(); var climaticModV = _dbContext.ClimaticMods.Where(c => c.Title == "В").First(); var colorOrange = _dbContext.Colors.Where(c => c.Title == "orange").First(); var colorBlack = _dbContext.Colors.Where(c => c.Title == "black").First(); _fireFRLS = _dbContext.FireProtectionClasses.Find(18); _fireFRHF = _dbContext.FireProtectionClasses.Find(23); var polymerLS = _dbContext.PolymerGroups.Find(6); var polymerHF = _dbContext.PolymerGroups.Find(4); var pair = _dbContext.TwistedElementTypes.Find(2); var cablePropertiesSetList = new List <CablePropertySet?> { CablePropertySet.HasFoilShield, CablePropertySet.HasFoilShield | CablePropertySet.HasMicaWinding, CablePropertySet.HasFoilShield | CablePropertySet.HasArmourBraid, CablePropertySet.HasFoilShield | CablePropertySet.HasArmourBraid | CablePropertySet.HasMicaWinding, CablePropertySet.HasFoilShield | CablePropertySet.HasArmourBraid | CablePropertySet.HasArmourTube, CablePropertySet.HasFoilShield | CablePropertySet.HasArmourBraid | CablePropertySet.HasArmourTube | CablePropertySet.HasMicaWinding, }; _coverPolymerGroups = new[] { polymerLS, polymerHF }; _billets = _dbContext.InsulatedBillets.Where(b => b.CableBrandName.BrandName == "КСБ") .Include(b => b.Conductor) .ToList(); _nameBuilder = new KsbgNameBuilder(); _wordTableParser = new XceedWordTableParser(); _wordTableParser.OpenWordDocument(_mSWordFile); var tableDataCommon = new List <TableCellData>(); var cablePresenter = new CablePresenter { TechCondId = techCond.Id, OperatingVoltageId = voltage.Id, ClimaticModId = climaticModUHL.Id, }; _provider.OpenConnection(); try { } finally { _wordTableParser.CloseWordApp(); _provider.CloseConnection(); } return(_recordsCount); }
public override int ParseDataToDatabase() { _recordsCount = 0; var configuratorTop = new TableParserConfigurator(3, 2, 9, 7, 2, 1); var configuratorBottom = new TableParserConfigurator(11, 2, 9, 7, 10, 1); var configuratorSingleBillets = new TableParserConfigurator(4, 1, 2, 7, 3, 0); var techCond = _dbContext.TechnicalConditions.Where(c => c.Title == "ТУ 16.К99-036-2007").First(); var voltage = _dbContext.OperatingVoltages.Find(5); var climaticModUHL = _dbContext.ClimaticMods.Find(3); var colorOrange = _dbContext.Colors.Find(8); _fireFRLS = _dbContext.FireProtectionClasses.Find(18); _fireFRHF = _dbContext.FireProtectionClasses.Find(23); var polymerLS = _dbContext.PolymerGroups.Find(6); var polymerHF = _dbContext.PolymerGroups.Find(4); var single = _dbContext.TwistedElementTypes.Find(1); var pair = _dbContext.TwistedElementTypes.Find(2); var cablePropertiesSetList = new List <CablePropertySet?> { CablePropertySet.HasFoilShield, null, CablePropertySet.HasFoilShield | CablePropertySet.HasMicaWinding, CablePropertySet.HasMicaWinding }; _coverPolymerGroups = new[] { polymerLS, polymerHF }; _billets = _dbContext.InsulatedBillets.Where(b => b.CableBrandName.BrandName == "КПС(Э)") .Include(b => b.Conductor) .ToList(); _nameBuilder = new KpseNameBuilder(); _wordTableParser = new XceedWordTableParser(); _wordTableParser.OpenWordDocument(_mSWordFile); var tableDataCommon = new List <TableCellData>(); var cablePresenter = new CablePresenter { TechCondId = techCond.Id, OperatingVoltageId = voltage.Id, ClimaticModId = climaticModUHL.Id, CoverColorId = colorOrange.Id }; _provider.OpenConnection(); try { var tableIndex = 0; foreach (var cableProps in cablePropertiesSetList) { tableDataCommon.AddRange(_wordTableParser.GetCableCellsCollection(tableIndex, configuratorTop)); tableDataCommon.AddRange(_wordTableParser.GetCableCellsCollection(tableIndex, configuratorBottom)); cablePresenter.TwistedElementTypeId = pair.Id; InsertCablesFromTableCellData(tableDataCommon, cablePresenter, cableProps); tableDataCommon.Clear(); tableDataCommon.AddRange(_wordTableParser.GetCableCellsCollection(4, configuratorSingleBillets)); cablePresenter.TwistedElementTypeId = single.Id; InsertCablesFromTableCellData(tableDataCommon, cablePresenter, cableProps); tableDataCommon.Clear(); configuratorSingleBillets.DataStartColumnIndex += (tableIndex + 1) % 2 == 0 ? -2 : 4; OnParseReport((double)(tableIndex + 1) / cablePropertiesSetList.Count); tableIndex++; } } finally { _wordTableParser.CloseWordApp(); _provider.CloseConnection(); } return(_recordsCount); }