internal OperationData(ArticleData articles, MasterTableResourceCapability resourceCapability) { SawTools = new TEnumerator <M_ResourceCapability>( obj: resourceCapability.Capabilities.Single(x => x.Name.Equals(resourceCapability.CUTTING.Name)) .ChildResourceCapabilities.ToArray()); DrillTools = new TEnumerator <M_ResourceCapability>( obj: resourceCapability.Capabilities.Single(x => x.Name.Equals(resourceCapability.DRILLING.Name)) .ChildResourceCapabilities.ToArray()); AssemblyTools = new TEnumerator <M_ResourceCapability>( obj: resourceCapability.Capabilities.Single(x => x.Name.Equals(resourceCapability.ASSEMBLING.Name)) .ChildResourceCapabilities.ToArray()); BODENPLATTE_BOHREN = new M_Operation { ArticleId = articles.BODENPLATTE.Id, Name = "Bodenplatte bohren", Duration = 5, ResourceCapabilityId = DrillTools.GetNext().Id, HierarchyNumber = 10 }; BODENPLATTE_ZUSAMMENBAUEN = new M_Operation { ArticleId = articles.BODENPLATTE.Id, Name = "Bodenplatte zusammenbauen", Duration = 5, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 20 }; ABLAGE_ZUSAMMENBAUEN = new M_Operation { ArticleId = articles.ABLAGE.Id, Name = "Ablage zusammenbauen", Duration = 1, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 10 }; DECKPLATTE_BOHREN = new M_Operation { ArticleId = articles.DECKPLATTE.Id, Name = "Deckplatte bohren", Duration = 5, ResourceCapabilityId = DrillTools.GetNext().Id, HierarchyNumber = 10 }; SEITENWAND_BOHREN = new M_Operation { ArticleId = articles.SEITENWAND.Id, Name = "Seitenwand bohren", Duration = 5, ResourceCapabilityId = DrillTools.GetNext().Id, HierarchyNumber = 10 }; RÜCKWAND_ZUSAMMENBAUEN = new M_Operation { ArticleId = articles.RÜCKWAND.Id, Name = "Rückwand zusammenbauen", Duration = 1, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 10 }; SCHRANKTÜR_BOHREN = new M_Operation { ArticleId = articles.SCHRANKTÜR.Id, Name = "Schranktür bohren", Duration = 5, ResourceCapabilityId = DrillTools.GetNext().Id, HierarchyNumber = 10 }; SCHRANKTÜR_ZUSAMMENBAUEN = new M_Operation { ArticleId = articles.SCHRANKTÜR.Id, Name = "Schranktür zusammenbauen", Duration = 10, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 20 }; RAHMEN_ZUSAMMENBAUEN = new M_Operation { ArticleId = articles.RAHMEN.Id, Name = "Rahmen zusammenbauen", Duration = 10, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 10 }; RÜCKWAND_MONTIEREN = new M_Operation { ArticleId = articles.RAHMEN_MIT_RÜCKWAND.Id, Name = "Rückenwand montieren", Duration = 20, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 10 }; REGAL_DÜBEL_ANBRINGEN = new M_Operation { ArticleId = articles.REGAL.Id, Name = "Regal: Dübel anbringen", Duration = 5, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 10 }; REGAL_ABLAGEN_EINBAUEN = new M_Operation { ArticleId = articles.REGAL.Id, Name = "Regal: Ablagen einbauen", Duration = 5, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 20 }; SCHRANK_KLEIDERSTANGENHALTERUNGEN_ANBRINGEN = new M_Operation { ArticleId = articles.SCHRANK.Id, Name = "Schrank: Kleiderstangenhalterungen anbringen", Duration = 5, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 10 }; SCHRANK_KLEIDERSTANGE_EINBAUEN = new M_Operation { ArticleId = articles.SCHRANK.Id, Name = "Schrank: Kleiderstange einbauen", Duration = 2, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 20 }; SCHRANKTÜR_BEFESTIGEN = new M_Operation { ArticleId = articles.SCHRANK.Id, Name = "Schrank: Tür befestigen", Duration = 10, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 30 }; }
internal M_ArticleBom[] Init(MasterDBContext context, ArticleData articles, OperationData operations) { SPANPLATTE_FÜR_RÜCKWAND = new M_ArticleBom { ArticleChildId = articles.SPANPLATTE.Id, Name = "Spanplatte", Quantity = 1, ArticleParentId = articles.RÜCKWAND.Id, OperationId = operations.RÜCKWAND_ZUSAMMENBAUEN.Id }; HOLZBRETT_FÜR_BODENPLATTE = new M_ArticleBom { ArticleChildId = articles.HOLZBRETT_KURZ.Id, Name = "kurzes Holzbrett", Quantity = 1, ArticleParentId = articles.BODENPLATTE.Id, OperationId = operations.BODENPLATTE_BOHREN.Id }; SCHRAUBEN_FÜR_BODENPLATTE = new M_ArticleBom { ArticleChildId = articles.SCHRAUBE.Id, Name = "Schraube", Quantity = 4, ArticleParentId = articles.BODENPLATTE.Id, OperationId = operations.BODENPLATTE_ZUSAMMENBAUEN.Id }; FÜßE_FÜR_BODENPLATTE = new M_ArticleBom { ArticleChildId = articles.FUß.Id, Name = "Fuß", Quantity = 4, ArticleParentId = articles.BODENPLATTE.Id, OperationId = operations.BODENPLATTE_ZUSAMMENBAUEN.Id }; HOLZBRETT_FÜR_ABLAGE = new M_ArticleBom { ArticleChildId = articles.HOLZBRETT_KURZ.Id, Name = "kurzes Holzbrett", Quantity = 1, ArticleParentId = articles.ABLAGE.Id, OperationId = operations.ABLAGE_ZUSAMMENBAUEN.Id }; HOLZBRETT_FÜR_SEITENWAND = new M_ArticleBom { ArticleChildId = articles.HOLZBRETT_LANG.Id, Name = "langes Holzbrett", Quantity = 1, ArticleParentId = articles.SEITENWAND.Id, OperationId = operations.SEITENWAND_BOHREN.Id }; HOLZBRETT_FÜR_SCHRANKTÜR = new M_ArticleBom { ArticleChildId = articles.HOLZBRETT_LANG.Id, Name = "langes Holzbrett", Quantity = 1, ArticleParentId = articles.SCHRANKTÜR.Id, OperationId = operations.SCHRANKTÜR_BOHREN.Id }; SCHRAUBEN_FÜR_SCHRANKTÜR = new M_ArticleBom { ArticleChildId = articles.SCHRAUBE.Id, Name = "Schraube", Quantity = 8, ArticleParentId = articles.SCHRANKTÜR.Id, OperationId = operations.SCHRANKTÜR_ZUSAMMENBAUEN.Id }; TÜRGRIFF_FÜR_SCHRANKTÜR = new M_ArticleBom { ArticleChildId = articles.TÜRGRIFF.Id, Name = "Türgriff", Quantity = 1, ArticleParentId = articles.SCHRANKTÜR.Id, OperationId = operations.SCHRANKTÜR_ZUSAMMENBAUEN.Id }; SCHANIEREN_FÜR_SCHRANKTÜR = new M_ArticleBom { ArticleChildId = articles.SCHARNIERE.Id, Name = "Schaniere", Quantity = 3, ArticleParentId = articles.SCHRANKTÜR.Id, OperationId = operations.SCHRANKTÜR_ZUSAMMENBAUEN.Id }; SCHRAUBEN_FÜR_RAHMEN = new M_ArticleBom { ArticleChildId = articles.SCHRAUBE.Id, Name = "Schraube", Quantity = 8, ArticleParentId = articles.RAHMEN.Id, OperationId = operations.RAHMEN_ZUSAMMENBAUEN.Id }; SEITENWAND_FÜR_RAHMEN = new M_ArticleBom { ArticleChildId = articles.SEITENWAND.Id, Name = "Seitenwand", Quantity = 2, ArticleParentId = articles.RAHMEN.Id, OperationId = operations.RAHMEN_ZUSAMMENBAUEN.Id }; BODENPLATTE_FÜR_RAHMEN = new M_ArticleBom { ArticleChildId = articles.BODENPLATTE.Id, Name = "Bodenplatte", Quantity = 1, ArticleParentId = articles.RAHMEN.Id, OperationId = operations.RAHMEN_ZUSAMMENBAUEN.Id }; DECKPLATTE_FÜR_RAHMEN = new M_ArticleBom { ArticleChildId = articles.DECKPLATTE.Id, Name = "Deckplatte", Quantity = 1, ArticleParentId = articles.RAHMEN.Id, OperationId = operations.RAHMEN_ZUSAMMENBAUEN.Id }; RAHMEN_FÜR_RAHMEN_MIT_RÜCKWAND = new M_ArticleBom { ArticleChildId = articles.RAHMEN.Id, Name = "Rahmen", Quantity = 1, ArticleParentId = articles.RAHMEN_MIT_RÜCKWAND.Id, OperationId = operations.RÜCKWAND_MONTIEREN.Id }; RÜCKWAND_FÜR_RAHMEN_MIT_RÜCKWAND = new M_ArticleBom { ArticleChildId = articles.RÜCKWAND.Id, Name = "Rückwand", Quantity = 1, ArticleParentId = articles.RAHMEN_MIT_RÜCKWAND.Id, OperationId = operations.RÜCKWAND_MONTIEREN.Id }; NAÄGEL_FÜR_RAHMEN_MIT_RÜCKWAND = new M_ArticleBom { ArticleChildId = articles.NAGEL.Id, Name = "Nagel", Quantity = 80, ArticleParentId = articles.RAHMEN_MIT_RÜCKWAND.Id, OperationId = operations.RÜCKWAND_MONTIEREN.Id }; DÜBEL_FÜR_REGAL = new M_ArticleBom { ArticleChildId = articles.METALLDÜBEL.Id, Name = "Metalldübel", Quantity = 16, ArticleParentId = articles.REGAL.Id, OperationId = operations.REGAL_DÜBEL_ANBRINGEN.Id }; RAHMEN_MIT_RÜCKWAND_FÜR_REGAL = new M_ArticleBom { ArticleChildId = articles.RAHMEN_MIT_RÜCKWAND.Id, Name = "Rahmen mit Rückwand", Quantity = 1, ArticleParentId = articles.REGAL.Id, OperationId = operations.REGAL_DÜBEL_ANBRINGEN.Id }; ABLAGEN_FÜR_REGAL = new M_ArticleBom { ArticleChildId = articles.ABLAGE.Id, Name = "Ablage", Quantity = 4, ArticleParentId = articles.REGAL.Id, OperationId = operations.REGAL_ABLAGEN_EINBAUEN.Id }; RAHMEN_MIT_RÜCKWAND_FÜR_SCHRANK = new M_ArticleBom { ArticleChildId = articles.RAHMEN_MIT_RÜCKWAND.Id, Name = "Rahmen mit Rückwand", Quantity = 1, ArticleParentId = articles.SCHRANK.Id, OperationId = operations.SCHRANK_KLEIDERSTANGENHALTERUNGEN_ANBRINGEN.Id }; KLEIDERSTANGENHALTERUNGEN_FÜR_SCHRANK = new M_ArticleBom { ArticleChildId = articles.KLEIDERSTANGENHALTERUNG.Id, Name = "Kleiderstangenhalterung", Quantity = 2, ArticleParentId = articles.SCHRANK.Id, OperationId = operations.SCHRANK_KLEIDERSTANGENHALTERUNGEN_ANBRINGEN.Id }; SCHRAUBEN_FÜR_KLEIDERSTANGENANBRINGUNG_AN_SCHRANK = new M_ArticleBom { ArticleChildId = articles.SCHRAUBE.Id, Name = "Schraube", Quantity = 4, ArticleParentId = articles.SCHRANK.Id, OperationId = operations.SCHRANK_KLEIDERSTANGENHALTERUNGEN_ANBRINGEN.Id }; KLEIDERSTANGE_FÜR_SCHRANK = new M_ArticleBom { ArticleChildId = articles.KLEIDERSTANGE.Id, Name = "Kleiderstange", Quantity = 1, ArticleParentId = articles.SCHRANK.Id, OperationId = operations.SCHRANK_KLEIDERSTANGE_EINBAUEN.Id }; SCHRANKTÜREN_FÜR_SCHRANK = new M_ArticleBom { ArticleChildId = articles.SCHRANKTÜR.Id, Name = "Schranktür", Quantity = 2, ArticleParentId = articles.SCHRANK.Id, OperationId = operations.SCHRANKTÜR_BEFESTIGEN.Id }; SCHRAUBEN_FÜR_SCHRANKTÜRBEFESTIGUNG = new M_ArticleBom { ArticleChildId = articles.SCHRAUBE.Id, Name = "Schraube", Quantity = 12, ArticleParentId = articles.SCHRANK.Id, OperationId = operations.SCHRANKTÜR_BEFESTIGEN.Id }; var articleBom = new M_ArticleBom[] { HOLZBRETT_FÜR_BODENPLATTE, SCHRAUBEN_FÜR_BODENPLATTE, FÜßE_FÜR_BODENPLATTE, HOLZBRETT_FÜR_ABLAGE, HOLZBRETT_FÜR_SEITENWAND, SPANPLATTE_FÜR_RÜCKWAND, HOLZBRETT_FÜR_SCHRANKTÜR, TÜRGRIFF_FÜR_SCHRANKTÜR, SCHRAUBEN_FÜR_SCHRANKTÜR, SCHANIEREN_FÜR_SCHRANKTÜR, SCHRAUBEN_FÜR_RAHMEN, SEITENWAND_FÜR_RAHMEN, BODENPLATTE_FÜR_RAHMEN, DECKPLATTE_FÜR_RAHMEN, RAHMEN_FÜR_RAHMEN_MIT_RÜCKWAND, RÜCKWAND_FÜR_RAHMEN_MIT_RÜCKWAND, DÜBEL_FÜR_REGAL, RAHMEN_MIT_RÜCKWAND_FÜR_REGAL, ABLAGEN_FÜR_REGAL, RAHMEN_MIT_RÜCKWAND_FÜR_SCHRANK, KLEIDERSTANGENHALTERUNGEN_FÜR_SCHRANK, SCHRAUBEN_FÜR_KLEIDERSTANGENANBRINGUNG_AN_SCHRANK, KLEIDERSTANGE_FÜR_SCHRANK, NAÄGEL_FÜR_RAHMEN_MIT_RÜCKWAND, SCHRANKTÜREN_FÜR_SCHRANK, SCHRAUBEN_FÜR_SCHRANKTÜRBEFESTIGUNG }; context.ArticleBoms.AddRange(entities: articleBom); context.SaveChanges(); return(articleBom); }