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);
}
