internal MasterTableOperation(MasterTableArticle articles , MasterTableResourceSkill resourceSkill , MasterTableResourceTool resourceTool) { DUMP_TRUCK_WEDDING = new M_Operation { ArticleId = articles.DUMP_TRUCK.Id, Name = "Dump-Truck: Wedding", Duration = 15, ResourceSkillId = resourceSkill.ASSEMBLING.Id, ResourceToolId = resourceTool.ASSEMBLY_SCREWDRIVER.Id, HierarchyNumber = 10 }; GLUE_TRUCK_BED = new M_Operation { ArticleId = articles.DUMP_TRUCK.Id, Name = "Glue Truck-Bed", Duration = 10, ResourceSkillId = resourceSkill.ASSEMBLING.Id, ResourceToolId = resourceTool.ASSEMBLY_SCREWDRIVER.Id, HierarchyNumber = 20 }; // assemble Truck RACE_TRUCK_WEDDING = new M_Operation { ArticleId = articles.RACE_TRUCK.Id, Name = "Race-Truck: Wedding", Duration = 15, ResourceSkillId = resourceSkill.ASSEMBLING.Id, ResourceToolId = resourceTool.ASSEMBLY_SCREWDRIVER.Id, HierarchyNumber = 10 }; GLUE_RACE_WING = new M_Operation { ArticleId = articles.RACE_TRUCK.Id, Name = "Glue Race Wing", Duration = 5, ResourceSkillId = resourceSkill.ASSEMBLING.Id, ResourceToolId = resourceTool.ASSEMBLY_SCREWDRIVER.Id, HierarchyNumber = 20 }; // assemble chassie Dump-Truck DUMP_TRUCK_ASSEMBLE_LAMPS = new M_Operation { ArticleId = articles.CHASSIS_TYPE_DUMP.Id, Name = "Dump-Truck: Assemble Lamps", Duration = 5, ResourceSkillId = resourceSkill.ASSEMBLING.Id, ResourceToolId = resourceTool.ASSEMBLY_SCREWDRIVER.Id, HierarchyNumber = 10 }; DUMP_TRUCK_MOUNT_ENGINE = new M_Operation { ArticleId = articles.CHASSIS_TYPE_DUMP.Id, Name = "Dump-Truck: Mount Engine to Cabin", Duration = 5, ResourceSkillId = resourceSkill.ASSEMBLING.Id, ResourceToolId = resourceTool.ASSEMBLY_SCREWDRIVER.Id, HierarchyNumber = 20 }; // assemble chassie Race Truck RACE_TRUCK_ASSEMBLE_LAMPS = new M_Operation { ArticleId = articles.CHASSIS_TYPE_RACE.Id, Name = "Race-Truck: Assemble Lamps", Duration = 5, ResourceSkillId = resourceSkill.ASSEMBLING.Id, ResourceToolId = resourceTool.ASSEMBLY_SCREWDRIVER.Id, HierarchyNumber = 10 }; RACE_TRUCK_MOUNT_ENGINE_EXTENSION = new M_Operation { ArticleId = articles.CHASSIS_TYPE_RACE.Id, Name = "Mount Engine Extension", Duration = 5, ResourceSkillId = resourceSkill.ASSEMBLING.Id, ResourceToolId = resourceTool.ASSEMBLY_SCREWDRIVER.Id, HierarchyNumber = 20 }; RACE_TRUCK_MOUNT_ENGINE = new M_Operation { ArticleId = articles.CHASSIS_TYPE_RACE.Id, Name = "Race-Truck: Mount Engine to Cabin", Duration = 5, ResourceSkillId = resourceSkill.ASSEMBLING.Id, ResourceToolId = resourceTool.ASSEMBLY_SCREWDRIVER.Id, HierarchyNumber = 30 }; // assemble Skeleton MOUNT_AXIS = new M_Operation { ArticleId = articles.SKELETON.Id, Name = "mount poles with wheels to Skeleton", Duration = 10, ResourceSkillId = resourceSkill.ASSEMBLING.Id, ResourceToolId = resourceTool.ASSEMBLY_SCREWDRIVER.Id, HierarchyNumber = 10 }; SCREW_WHEELS = new M_Operation { ArticleId = articles.SKELETON.Id, Name = "Screw wheels onto poles", Duration = 10, ResourceSkillId = resourceSkill.ASSEMBLING.Id, ResourceToolId = resourceTool.ASSEMBLY_SCREWDRIVER.Id, HierarchyNumber = 20 }; GLUE_SEMITRAILER = new M_Operation { ArticleId = articles.SKELETON.Id, Name = "Glue Semitrailer", Duration = 5, ResourceSkillId = resourceSkill.ASSEMBLING.Id, ResourceToolId = resourceTool.ASSEMBLY_SCREWDRIVER.Id, HierarchyNumber = 30 }; // assemble Truck Bed GLUE_SIDEWALLS = new M_Operation { ArticleId = articles.TRUCK_BED.Id, Name = "Glue side walls and base plate together", Duration = 5, ResourceSkillId = resourceSkill.ASSEMBLING.Id, ResourceToolId = resourceTool.ASSEMBLY_SCREWDRIVER.Id, HierarchyNumber = 10 }; MOUNT_HATCHBACK = new M_Operation { ArticleId = articles.TRUCK_BED.Id, Name = "Mount hatchback", Duration = 5, ResourceSkillId = resourceSkill.ASSEMBLING.Id, ResourceToolId = resourceTool.ASSEMBLY_SCREWDRIVER.Id, HierarchyNumber = 20 }; // assemble Race Wing RACE_WING_CUT = new M_Operation { ArticleId = articles.RACE_WING.Id, Name = "Race Wing: Cut shape", Duration = 10, ResourceSkillId = resourceSkill.CUTTING.Id, ResourceToolId = resourceTool.SAW_BLADE_BIG.Id, HierarchyNumber = 10 }; RACE_WING_DRILL = new M_Operation { ArticleId = articles.RACE_WING.Id, Name = "Race Wing: Drill Mount Holes", Duration = 5, ResourceSkillId = resourceSkill.DRILLING.Id, ResourceToolId = resourceTool.DRILL_HEAD_M6.Id, HierarchyNumber = 20 }; // Engine Race Extension RACE_EXTENSION_CUT = new M_Operation { ArticleId = articles.ENGINE_RACE_EXTENSION.Id, Name = "Engine Race Extension: Cut shape", Duration = 10, ResourceSkillId = resourceSkill.CUTTING.Id, ResourceToolId = resourceTool.SAW_BLADE_BIG.Id, HierarchyNumber = 10 }; RACE_EXTENSION_DRILL = new M_Operation { ArticleId = articles.ENGINE_RACE_EXTENSION.Id, Name = "Engine Race Extension: Drill Mount Holes", Duration = 5, ResourceSkillId = resourceSkill.DRILLING.Id, ResourceToolId = resourceTool.DRILL_HEAD_M6.Id, HierarchyNumber = 20 }; // side Walls for Truck-bed SIDEWALL_LONG_CUT = new M_Operation { ArticleId = articles.SIDEWALL_LONG.Id, Name = "Side wall long: Cut long side", Duration = 10, ResourceSkillId = resourceSkill.CUTTING.Id, ResourceToolId = resourceTool.SAW_BLADE_SMALL.Id, HierarchyNumber = 10 }; SIDEWALL_LONG_DRILL = new M_Operation { ArticleId = articles.SIDEWALL_LONG.Id, Name = "Side wall long: Drill mount holes", Duration = 5, ResourceSkillId = resourceSkill.DRILLING.Id, ResourceToolId = resourceTool.DRILL_HEAD_M6.Id, HierarchyNumber = 20 }; SIDEWALL_SHORT_CUT = new M_Operation { ArticleId = articles.SIDEWALL_SHORT.Id, Name = "Side wall short: Cut short side", Duration = 5, ResourceSkillId = resourceSkill.CUTTING.Id, ResourceToolId = resourceTool.SAW_BLADE_SMALL.Id, HierarchyNumber = 10 }; SIDEWALL_SHORT_DRILL = new M_Operation { ArticleId = articles.SIDEWALL_SHORT.Id, Name = "Side wall short: Drill mount holes", Duration = 5, ResourceSkillId = resourceSkill.DRILLING.Id, ResourceToolId = resourceTool.DRILL_HEAD_M6.Id, HierarchyNumber = 20 }; BASEPLATE_TRUCK_BED_CUT = new M_Operation { ArticleId = articles.BASEPLATE_TRUCK_BED.Id, Name = "Base plate Truck-Bed: Cut Base plate Truck-Bed", Duration = 10, ResourceSkillId = resourceSkill.CUTTING.Id, ResourceToolId = resourceTool.SAW_BLADE_BIG.Id, HierarchyNumber = 10 }; BASEPLATE_TRUCK_BED_DRILL = new M_Operation { ArticleId = articles.BASEPLATE_TRUCK_BED.Id, Name = "Base plate Truck-Bed: Drill mount holes", Duration = 5, ResourceSkillId = resourceSkill.DRILLING.Id, ResourceToolId = resourceTool.DRILL_HEAD_M6.Id, HierarchyNumber = 20 }; // Eengin Block ENGINE_BLOCK_CUT = new M_Operation { ArticleId = articles.ENGINE_BLOCK.Id, Name = "Engine-Block: Cut Engine-Block", Duration = 10, ResourceSkillId = resourceSkill.CUTTING.Id, ResourceToolId = resourceTool.SAW_BLADE_BIG.Id, HierarchyNumber = 10 }; ENGINE_BLOCK_DRILL = new M_Operation { ArticleId = articles.ENGINE_BLOCK.Id, Name = "Engine-Block: Drill mount holes", Duration = 5, ResourceSkillId = resourceSkill.DRILLING.Id, ResourceToolId = resourceTool.DRILL_HEAD_M6.Id, HierarchyNumber = 20 }; // cabin CABIN_CUT = new M_Operation { ArticleId = articles.CABIN.Id, Name = "Cabin: Cut Cabin", Duration = 10, ResourceSkillId = resourceSkill.CUTTING.Id, ResourceToolId = resourceTool.SAW_BLADE_SMALL.Id, HierarchyNumber = 10 }; CABIN_DRILL = new M_Operation { ArticleId = articles.CABIN.Id, Name = "Cabin: Drill mount holes", Duration = 5, ResourceSkillId = resourceSkill.DRILLING.Id, ResourceToolId = resourceTool.DRILL_HEAD_M4.Id, HierarchyNumber = 20 }; // Base Plate BASE_PLATE_CUT = new M_Operation { ArticleId = articles.BASE_PLATE.Id, Name = "Base plate: Cut Base plate", Duration = 10, ResourceSkillId = resourceSkill.CUTTING.Id, ResourceToolId = resourceTool.SAW_BLADE_BIG.Id, HierarchyNumber = 10 }; BASE_PLATE_DRILL = new M_Operation { ArticleId = articles.BASE_PLATE.Id, Name = "Base plate: drill holes for axis mount", Duration = 5, ResourceSkillId = resourceSkill.DRILLING.Id, ResourceToolId = resourceTool.DRILL_HEAD_M4.Id, HierarchyNumber = 20 }; }
internal M_ArticleBom[] Init(MasterDBContext context, MasterTableArticle articles, MasterTableOperation operations) { SKELETON_TO_DUMP_TRUCK = new M_ArticleBom { ArticleChildId = articles.SKELETON.Id, Name = "Skeleton", Quantity = 1, ArticleParentId = articles.DUMP_TRUCK.Id, OperationId = operations.DUMP_TRUCK_WEDDING.Id }; CHASSIS_TYPE_DUMP_TO_DUMP_TRUCK = new M_ArticleBom { ArticleChildId = articles.CHASSIS_TYPE_DUMP.Id, Name = "Chassis Type: Dump", Quantity = 1, ArticleParentId = articles.DUMP_TRUCK.Id, OperationId = operations.DUMP_TRUCK_WEDDING.Id }; GLUE_TO_DUMP_TRUCK_FOR_WEDDING = new M_ArticleBom { ArticleChildId = articles.GLUE.Id, Name = "Glue", Quantity = 5, ArticleParentId = articles.DUMP_TRUCK.Id, OperationId = operations.DUMP_TRUCK_WEDDING.Id }; POLE_TO_DUMP_TRUCK = new M_ArticleBom { ArticleChildId = articles.POLE.Id, Name = "Pole", Quantity = 1, ArticleParentId = articles.DUMP_TRUCK.Id, OperationId = operations.GLUE_TRUCK_BED.Id }; TRUCK_BED_TO_DUMP_TRUCK = new M_ArticleBom { ArticleChildId = articles.TRUCK_BED.Id, Name = "Truck-Bed", Quantity = 1, ArticleParentId = articles.DUMP_TRUCK.Id, OperationId = operations.GLUE_TRUCK_BED.Id }; GLUE_TO_TO_DUMP_TRUCK_FOR_TRUCK_BED = new M_ArticleBom { ArticleChildId = articles.GLUE.Id, Name = "Glue", Quantity = 5, ArticleParentId = articles.DUMP_TRUCK.Id, OperationId = operations.GLUE_TRUCK_BED.Id }; PEGS_TO_DUMP_TRUCK = new M_ArticleBom { ArticleChildId = articles.PEGS.Id, Name = "Pegs", Quantity = 2, ArticleParentId = articles.DUMP_TRUCK.Id, OperationId = operations.GLUE_TRUCK_BED.Id }; BUTTON_TO_DUMP_TRUCK = new M_ArticleBom { ArticleChildId = articles.BUTTON.Id, Name = "Knopf", Quantity = 2, ArticleParentId = articles.DUMP_TRUCK.Id, OperationId = operations.GLUE_TRUCK_BED.Id }; // new M_ArticleBom { ArticleChildId = articles.Single(predicate: a => a.Name == "User Manual").Id, Name = "User Manual", Quantity=1, ArticleParentId = articles.DUMP_TRUCK.Id }, // new M_ArticleBom { ArticleChildId = articles.Single(predicate: a => a.Name == "Packing").Id, Name = "Packing", Quantity=1, ArticleParentId = articles.DUMP_TRUCK.Id }, // Bom For Race Truck SKELETON_TO_RACE_TRUCK = new M_ArticleBom { ArticleChildId = articles.SKELETON.Id, Name = "Skeleton", Quantity = 1, ArticleParentId = articles.RACE_TRUCK.Id, OperationId = operations.RACE_TRUCK_WEDDING.Id }; CHASSIS_TO_RACE_TRUCK = new M_ArticleBom { ArticleChildId = articles.CHASSIS_TYPE_RACE.Id, Name = "Chassis Type: Race", Quantity = 1, ArticleParentId = articles.RACE_TRUCK.Id, OperationId = operations.RACE_TRUCK_WEDDING.Id }; POLE_TO_RACE_TRUCK = new M_ArticleBom { ArticleChildId = articles.POLE.Id, Name = "Pole", Quantity = 1, ArticleParentId = articles.RACE_TRUCK.Id, OperationId = operations.GLUE_RACE_WING.Id }; RACE_WING_TO_RACE_TRUCK = new M_ArticleBom { ArticleChildId = articles.RACE_WING.Id, Name = "Race Wing", Quantity = 1, ArticleParentId = articles.RACE_TRUCK.Id, OperationId = operations.GLUE_RACE_WING.Id }; GLUE_TO_RACE_TRUCK_FOR_WEDDING = new M_ArticleBom { ArticleChildId = articles.GLUE.Id, Name = "Glue", Quantity = 5, ArticleParentId = articles.RACE_TRUCK.Id, OperationId = operations.RACE_TRUCK_WEDDING.Id }; GLUE_TO_RACE_TRUCK_FOR_WING = new M_ArticleBom { ArticleChildId = articles.GLUE.Id, Name = "Glue", Quantity = 5, ArticleParentId = articles.RACE_TRUCK.Id, OperationId = operations.GLUE_RACE_WING.Id }; PEGS_TO_RACE_TRUCK = new M_ArticleBom { ArticleChildId = articles.PEGS.Id, Name = "Pegs", Quantity = 2, ArticleParentId = articles.RACE_TRUCK.Id, OperationId = operations.GLUE_RACE_WING.Id }; BUTTON_TO_RACE_TRUCK = new M_ArticleBom { ArticleChildId = articles.BUTTON.Id, Name = "Knopf", Quantity = 2, ArticleParentId = articles.RACE_TRUCK.Id, OperationId = operations.GLUE_RACE_WING.Id }; // new M_ArticleBom { ArticleChildId = articles.Single(predicate: a => a.Name == "User Manual").Id, Name = "User Manual", Quantity=1, ArticleParentId = articles.RACE_TRUCK.Id }, // new M_ArticleBom { ArticleChildId = articles.Single(predicate: a => a.Name == "Packing").Id, Name = "Packing", Quantity=1, ArticleParentId = articles.RACE_TRUCK.Id }, // Bom for Skeleton BASE_PLATE_TO_SKELETON = new M_ArticleBom { ArticleChildId = articles.BASE_PLATE.Id, Name = "Base plate", Quantity = 1, ArticleParentId = articles.SKELETON.Id, OperationId = operations.MOUNT_AXIS.Id }; POLE_TO_SKELETON = new M_ArticleBom { ArticleChildId = articles.POLE.Id, Name = "Pole", Quantity = 2, ArticleParentId = articles.SKELETON.Id, OperationId = operations.MOUNT_AXIS.Id }; WASHER_TO_SKELETON = new M_ArticleBom { ArticleChildId = articles.WASHER.Id, Name = "Washer", Quantity = 4, ArticleParentId = articles.SKELETON.Id, OperationId = operations.SCREW_WHEELS.Id }; WHEEL_TO_SKELETON = new M_ArticleBom { ArticleChildId = articles.WHEEL.Id, Name = "Wheel", Quantity = 4, ArticleParentId = articles.SKELETON.Id, OperationId = operations.SCREW_WHEELS.Id }; SEMITRAILER_TO_SKELETON = new M_ArticleBom { ArticleChildId = articles.SEMITRAILER.Id, Name = "Semitrailer", Quantity = 1, ArticleParentId = articles.SKELETON.Id, OperationId = operations.GLUE_SEMITRAILER.Id }; GLUE_TO_SKELETON = new M_ArticleBom { ArticleChildId = articles.GLUE.Id, Name = "Glue", Quantity = 5, ArticleParentId = articles.SKELETON.Id, OperationId = operations.GLUE_SEMITRAILER.Id }; // Bom For Chassis Dump CABIN_TO_CHASSIS_DUMP_TRUCK = new M_ArticleBom { ArticleChildId = articles.CABIN.Id, Name = "Cabin", Quantity = 1, ArticleParentId = articles.CHASSIS_TYPE_DUMP.Id, OperationId = operations.DUMP_TRUCK_ASSEMBLE_LAMPS.Id }; PEGS_TO_CHASSIS_DUMP_TRUCK = new M_ArticleBom { ArticleChildId = articles.PEGS.Id, Name = "Pegs", Quantity = 4, ArticleParentId = articles.CHASSIS_TYPE_DUMP.Id, OperationId = operations.DUMP_TRUCK_ASSEMBLE_LAMPS.Id }; BUTTON_TO_CHASSIS_DUMP_TRUCK = new M_ArticleBom { ArticleChildId = articles.BUTTON.Id, Name = "Knopf", Quantity = 2, ArticleParentId = articles.CHASSIS_TYPE_DUMP.Id, OperationId = operations.DUMP_TRUCK_ASSEMBLE_LAMPS.Id }; ENGINE_BLOCK_TO_CHASSIS_DUMP_TRUCK = new M_ArticleBom { ArticleChildId = articles.ENGINE_BLOCK.Id, Name = "Engine-Block", Quantity = 1, ArticleParentId = articles.CHASSIS_TYPE_DUMP.Id, OperationId = operations.DUMP_TRUCK_MOUNT_ENGINE.Id }; GLUE_TO_CHASSIS_DUMP_TRUCK = new M_ArticleBom { ArticleChildId = articles.GLUE.Id, Name = "Glue", Quantity = 7, ArticleParentId = articles.CHASSIS_TYPE_DUMP.Id, OperationId = operations.DUMP_TRUCK_MOUNT_ENGINE.Id }; // Bom For Chassis Race CABIN_TO_CHASSIS_RACE_TRUCK = new M_ArticleBom { ArticleChildId = articles.CABIN.Id, Name = "Cabin", Quantity = 1, ArticleParentId = articles.CHASSIS_TYPE_RACE.Id, OperationId = operations.RACE_TRUCK_ASSEMBLE_LAMPS.Id }; PEGS_TO_CHASSIS_RACE_TRUCK = new M_ArticleBom { ArticleChildId = articles.PEGS.Id, Name = "Pegs", Quantity = 4, ArticleParentId = articles.CHASSIS_TYPE_RACE.Id, OperationId = operations.RACE_TRUCK_ASSEMBLE_LAMPS.Id }; BUTTON_TO_CHASSIS_RACE_TRUCK = new M_ArticleBom { ArticleChildId = articles.BUTTON.Id, Name = "Knopf", Quantity = 2, ArticleParentId = articles.CHASSIS_TYPE_RACE.Id, OperationId = operations.RACE_TRUCK_ASSEMBLE_LAMPS.Id }; ENGINE_BLOCK_TO_CHASSIS_RACE_TRUCK = new M_ArticleBom { ArticleChildId = articles.ENGINE_BLOCK.Id, Name = "Engine-Block", Quantity = 1, ArticleParentId = articles.CHASSIS_TYPE_RACE.Id, OperationId = operations.RACE_TRUCK_MOUNT_ENGINE_EXTENSION.Id }; ENGINE_RACE_EXTENSION_TO_CHASSIS_RACE_TRUCK = new M_ArticleBom { ArticleChildId = articles.ENGINE_RACE_EXTENSION.Id, Name = "Engine Race Extension", Quantity = 1, ArticleParentId = articles.CHASSIS_TYPE_RACE.Id, OperationId = operations.RACE_TRUCK_MOUNT_ENGINE_EXTENSION.Id }; GLUE_TO_CHASSIS_RACE_TRUCK = new M_ArticleBom { ArticleChildId = articles.GLUE.Id, Name = "Glue", Quantity = 7, ArticleParentId = articles.CHASSIS_TYPE_RACE.Id, OperationId = operations.RACE_TRUCK_MOUNT_ENGINE.Id }; // Bom for Truck-Bed SIDEWALL_LONG_TO_TRUCK_BED = new M_ArticleBom { ArticleChildId = articles.SIDEWALL_LONG.Id, Name = "Side wall long", Quantity = 2, ArticleParentId = articles.TRUCK_BED.Id, OperationId = operations.GLUE_SIDEWALLS.Id }; SIDEWALL_SHORT_TO_TRUCK_BED = new M_ArticleBom { ArticleChildId = articles.SIDEWALL_SHORT.Id, Name = "Side wall short", Quantity = 2, ArticleParentId = articles.TRUCK_BED.Id, OperationId = operations.GLUE_SIDEWALLS.Id }; BASE_PLATE_TRUCK_BED_TO_TRUCK_BED = new M_ArticleBom { ArticleChildId = articles.BASEPLATE_TRUCK_BED.Id, Name = "Base plate Truck-Bed", Quantity = 1, ArticleParentId = articles.TRUCK_BED.Id, OperationId = operations.GLUE_SIDEWALLS.Id }; DUMP_JOINT_TO_TRUCK_BED = new M_ArticleBom { ArticleChildId = articles.DUMP_JOINT.Id, Name = "Dump Joint", Quantity = 1, ArticleParentId = articles.TRUCK_BED.Id, OperationId = operations.MOUNT_HATCHBACK.Id }; PEGS_TO_TRUCK_BED = new M_ArticleBom { ArticleChildId = articles.PEGS.Id, Name = "Pegs", Quantity = 10, ArticleParentId = articles.TRUCK_BED.Id, OperationId = operations.MOUNT_HATCHBACK.Id }; BUTTON_TO_TRUCK_BED = new M_ArticleBom { ArticleChildId = articles.BUTTON.Id, Name = "Knopf", Quantity = 2, ArticleParentId = articles.TRUCK_BED.Id, OperationId = operations.MOUNT_HATCHBACK.Id }; GLUE_TO_TRUCK_BED = new M_ArticleBom { ArticleChildId = articles.GLUE.Id, Name = "Glue", Quantity = 7, ArticleParentId = articles.TRUCK_BED.Id, OperationId = operations.MOUNT_HATCHBACK.Id }; POLE_TO_TRUCK_BED = new M_ArticleBom { ArticleChildId = articles.POLE.Id, Name = "Pole", Quantity = 1, ArticleParentId = articles.TRUCK_BED.Id, OperationId = operations.MOUNT_HATCHBACK.Id }; // Bom for some Assemblies TIMBER_PLATE_TO_SIDEWALL_LONG = new M_ArticleBom { ArticleChildId = articles.TIMBER_PLATE.Id, Name = "Timber Plate 1,5m x 3,0m", Quantity = 1, ArticleParentId = articles.SIDEWALL_LONG.Id, OperationId = operations.SIDEWALL_LONG_CUT.Id }; TIMBER_PLATE_TO_SIDEWALL_SHORT = new M_ArticleBom { ArticleChildId = articles.TIMBER_PLATE.Id, Name = "Timber Plate 1,5m x 3,0m", Quantity = 1, ArticleParentId = articles.SIDEWALL_SHORT.Id, OperationId = operations.SIDEWALL_SHORT_CUT.Id }; TIMBER_PLATE_TO_TRUCK_BED = new M_ArticleBom { ArticleChildId = articles.TIMBER_PLATE.Id, Name = "Timber Plate 1,5m x 3,0m", Quantity = 1, ArticleParentId = articles.BASEPLATE_TRUCK_BED.Id, OperationId = operations.BASEPLATE_TRUCK_BED_CUT.Id }; TIMBER_PLATE_TO_BASE_PLATE = new M_ArticleBom { ArticleChildId = articles.TIMBER_PLATE.Id, Name = "Timber Plate 1,5m x 3,0m", Quantity = 1, ArticleParentId = articles.BASE_PLATE.Id, OperationId = operations.BASE_PLATE_CUT.Id }; TIMBER_PLATE_TO_RACE_WING = new M_ArticleBom { ArticleChildId = articles.TIMBER_PLATE.Id, Name = "Timber Plate 1,5m x 3,0m", Quantity = 1, ArticleParentId = articles.RACE_WING.Id, OperationId = operations.RACE_WING_CUT.Id }; TIMBER_BLOCK_TO_CABIN = new M_ArticleBom { ArticleChildId = articles.TIMBER_BLOCK.Id, Name = "Timber Block 0,20m x 0,20m", Quantity = 1, ArticleParentId = articles.CABIN.Id, OperationId = operations.CABIN_CUT.Id }; TIMBER_BLOCK_TO_ENGINE_BLOCK = new M_ArticleBom { ArticleChildId = articles.TIMBER_BLOCK.Id, Name = "Timber Block 0,20m x 0,20m", Quantity = 1, ArticleParentId = articles.ENGINE_BLOCK.Id, OperationId = operations.ENGINE_BLOCK_CUT.Id }; TIMBER_BLOCK_TO_RACE_EXTENSION = new M_ArticleBom { ArticleChildId = articles.TIMBER_BLOCK.Id, Name = "Timber Block 0,20m x 0,20m", Quantity = 1, ArticleParentId = articles.ENGINE_RACE_EXTENSION.Id, OperationId = operations.RACE_EXTENSION_CUT.Id }; // !!! - Important NOTE - !!! // For Boms without Link to an Operation all Materials have to be ready to completed the operation assigned to the Article. var articleBom = new M_ArticleBom[] { // DUMP TRUCK CHASSIS_TYPE_DUMP_TO_DUMP_TRUCK, SKELETON_TO_DUMP_TRUCK, GLUE_TO_DUMP_TRUCK_FOR_WEDDING, POLE_TO_DUMP_TRUCK, TRUCK_BED_TO_DUMP_TRUCK, GLUE_TO_TO_DUMP_TRUCK_FOR_TRUCK_BED, PEGS_TO_DUMP_TRUCK, BUTTON_TO_DUMP_TRUCK, //RACE TRUCK SKELETON_TO_RACE_TRUCK, CHASSIS_TO_RACE_TRUCK, POLE_TO_RACE_TRUCK, RACE_WING_TO_RACE_TRUCK, GLUE_TO_RACE_TRUCK_FOR_WEDDING, GLUE_TO_RACE_TRUCK_FOR_WING, PEGS_TO_RACE_TRUCK, BUTTON_TO_RACE_TRUCK, // SKELETON BASE_PLATE_TO_SKELETON, POLE_TO_SKELETON, WASHER_TO_SKELETON, WHEEL_TO_SKELETON, SEMITRAILER_TO_SKELETON, GLUE_TO_SKELETON, // CHASSIS DUMP TRUCK CABIN_TO_CHASSIS_DUMP_TRUCK, PEGS_TO_CHASSIS_DUMP_TRUCK, BUTTON_TO_CHASSIS_DUMP_TRUCK, ENGINE_BLOCK_TO_CHASSIS_DUMP_TRUCK, GLUE_TO_CHASSIS_DUMP_TRUCK, // CHASSIS RACE TRUCK CABIN_TO_CHASSIS_RACE_TRUCK, PEGS_TO_CHASSIS_RACE_TRUCK, BUTTON_TO_CHASSIS_RACE_TRUCK, ENGINE_BLOCK_TO_CHASSIS_RACE_TRUCK, ENGINE_RACE_EXTENSION_TO_CHASSIS_RACE_TRUCK, GLUE_TO_CHASSIS_RACE_TRUCK, // TRUCK BED SIDEWALL_LONG_TO_TRUCK_BED, SIDEWALL_SHORT_TO_TRUCK_BED, BASE_PLATE_TRUCK_BED_TO_TRUCK_BED, DUMP_JOINT_TO_TRUCK_BED, PEGS_TO_TRUCK_BED, BUTTON_TO_TRUCK_BED, GLUE_TO_TRUCK_BED, POLE_TO_TRUCK_BED, //ASSEMBLIES TIMBER_PLATE_TO_SIDEWALL_LONG, TIMBER_PLATE_TO_SIDEWALL_SHORT, TIMBER_PLATE_TO_TRUCK_BED, TIMBER_PLATE_TO_BASE_PLATE, TIMBER_PLATE_TO_RACE_WING, TIMBER_BLOCK_TO_CABIN, TIMBER_BLOCK_TO_ENGINE_BLOCK, TIMBER_BLOCK_TO_RACE_EXTENSION }; context.ArticleBoms.AddRange(entities: articleBom); context.SaveChanges(); return(articleBom); }
internal void Init(MasterDBContext context, MasterTableBusinessPartner businessPartner, MasterTableArticle article) { var artToBusinessPartner = new M_ArticleToBusinessPartner[] { new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.SKELETON.Id, PackSize = 10, Price = 20.00, TimeToDelivery = 2880 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.TRUCK_BED.Id, PackSize = 10, Price = 20.00, TimeToDelivery = 2880 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.CHASSIS_TYPE_DUMP.Id, PackSize = 10, Price = 20.00, TimeToDelivery = 2880 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.CHASSIS_TYPE_RACE.Id, PackSize = 10, Price = 25.00, TimeToDelivery = 2880 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.CABIN.Id, PackSize = 10, Price = 1.75, TimeToDelivery = 1440 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.ENGINE_BLOCK.Id, PackSize = 10, Price = 0.40, TimeToDelivery = 1440 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.ENGINE_RACE_EXTENSION.Id, PackSize = 10, Price = 1.00, TimeToDelivery = 1440 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.SIDEWALL_LONG.Id, PackSize = 10, Price = 0.55, TimeToDelivery = 1440 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.SIDEWALL_SHORT.Id, PackSize = 10, Price = 0.45, TimeToDelivery = 1440 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.BASEPLATE_TRUCK_BED.Id, PackSize = 10, Price = 0.40, TimeToDelivery = 1440 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.DUMP_JOINT.Id /*Kippgelenk*/, PackSize = 50, Price = 0.90, TimeToDelivery = 1440 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.WHEEL.Id, PackSize = 150, Price = 0.35, TimeToDelivery = 1440 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.BASE_PLATE.Id, PackSize = 10, Price = 0.80, TimeToDelivery = 1440 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.SEMITRAILER.Id /*Aufleger*/, PackSize = 25, Price = 0.10, TimeToDelivery = 1440 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.RACE_WING.Id, PackSize = 10, Price = 1.50, TimeToDelivery = 1440 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.WASHER.Id, PackSize = 150, Price = 0.02, TimeToDelivery = 1440 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.TIMBER_PLATE.Id, PackSize = 100, Price = 0.20, TimeToDelivery = 1440 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.TIMBER_BLOCK.Id, PackSize = 100, Price = 0.20, TimeToDelivery = 1440 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.GLUE.Id, PackSize = 1000, Price = 0.01, TimeToDelivery = 1440 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.PEGS.Id, PackSize = 200, Price = 0.01, TimeToDelivery = 1440 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.POLE.Id, PackSize = 200, Price = 0.25, TimeToDelivery = 1440 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.BUTTON.Id, PackSize = 500, Price = 0.05, TimeToDelivery = 1440 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.PACKING.Id, PackSize = 50, Price = 2.50, TimeToDelivery = 1440 }, new M_ArticleToBusinessPartner { BusinessPartnerId = businessPartner.KREDITOR_MATERIAL_WHOLSALE.Id, ArticleId = article.USER_MANUAL.Id, PackSize = 50, Price = 0.20, TimeToDelivery = 1440 }, }; context.ArticleToBusinessPartners.AddRange(entities: artToBusinessPartner); context.SaveChanges(); }
internal MasterTableOperation(MasterTableArticle articles , MasterTableResourceCapability resourceCapability , bool distributeSetupsExponentially) { SawTools = new TEnumerator <M_ResourceCapability>( obj: resourceCapability.Capabilities.Single(x => x.Name.Equals(resourceCapability.CUTTING.Name)).ChildResourceCapabilities.ToArray() , expDistributed: distributeSetupsExponentially); DrillTools = new TEnumerator <M_ResourceCapability>( obj: resourceCapability.Capabilities.Single(x => x.Name.Equals(resourceCapability.DRILLING.Name)).ChildResourceCapabilities.ToArray() , expDistributed: distributeSetupsExponentially); AssemblyTools = new TEnumerator <M_ResourceCapability>( obj: resourceCapability.Capabilities.Single(x => x.Name.Equals(resourceCapability.ASSEMBLING.Name)).ChildResourceCapabilities.ToArray() , expDistributed: distributeSetupsExponentially); DUMP_TRUCK_WEDDING = new M_Operation { ArticleId = articles.DUMP_TRUCK.Id, Name = "Dump-Truck: Wedding", Duration = 15, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 10 }; GLUE_TRUCK_BED = new M_Operation { ArticleId = articles.DUMP_TRUCK.Id, Name = "Glue Truck-Bed", Duration = 10, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 20 }; // assemble Truck RACE_TRUCK_WEDDING = new M_Operation { ArticleId = articles.RACE_TRUCK.Id, Name = "Race-Truck: Wedding", Duration = 15, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 10 }; GLUE_RACE_WING = new M_Operation { ArticleId = articles.RACE_TRUCK.Id, Name = "Glue Race Wing", Duration = 5, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 20 }; // assemble chassie Dump-Truck DUMP_TRUCK_ASSEMBLE_LAMPS = new M_Operation { ArticleId = articles.CHASSIS_TYPE_DUMP.Id, Name = "Dump-Truck: Assemble Lamps", Duration = 5, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 10 }; DUMP_TRUCK_MOUNT_ENGINE = new M_Operation { ArticleId = articles.CHASSIS_TYPE_DUMP.Id, Name = "Dump-Truck: Mount Engine to Cabin", Duration = 5, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 20 }; // assemble chassie Race Truck RACE_TRUCK_ASSEMBLE_LAMPS = new M_Operation { ArticleId = articles.CHASSIS_TYPE_RACE.Id, Name = "Race-Truck: Assemble Lamps", Duration = 5, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 10 }; RACE_TRUCK_MOUNT_ENGINE_EXTENSION = new M_Operation { ArticleId = articles.CHASSIS_TYPE_RACE.Id, Name = "Mount Engine Extension", Duration = 5, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 20 }; RACE_TRUCK_MOUNT_ENGINE = new M_Operation { ArticleId = articles.CHASSIS_TYPE_RACE.Id, Name = "Race-Truck: Mount Engine to Cabin", Duration = 5, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 30 }; // assemble Skeleton MOUNT_AXIS = new M_Operation { ArticleId = articles.SKELETON.Id, Name = "mount poles with wheels to Skeleton", Duration = 10, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 10 }; SCREW_WHEELS = new M_Operation { ArticleId = articles.SKELETON.Id, Name = "Screw wheels onto poles", Duration = 10, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 20 }; GLUE_SEMITRAILER = new M_Operation { ArticleId = articles.SKELETON.Id, Name = "Glue Semitrailer", Duration = 5, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 30 }; // assemble Truck Bed GLUE_SIDEWALLS = new M_Operation { ArticleId = articles.TRUCK_BED.Id, Name = "Glue side walls and base plate together", Duration = 5, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 10 }; MOUNT_HATCHBACK = new M_Operation { ArticleId = articles.TRUCK_BED.Id, Name = "Mount hatchback", Duration = 5, ResourceCapabilityId = AssemblyTools.GetNext().Id, HierarchyNumber = 20 }; // assemble Race Wing RACE_WING_CUT = new M_Operation { ArticleId = articles.RACE_WING.Id, Name = "Race Wing: Cut shape", Duration = 10, ResourceCapabilityId = SawTools.GetNext().Id, HierarchyNumber = 10 }; RACE_WING_DRILL = new M_Operation { ArticleId = articles.RACE_WING.Id, Name = "Race Wing: Drill Mount Holes", Duration = 5, ResourceCapabilityId = DrillTools.GetNext().Id, HierarchyNumber = 20 }; // Engine Race Extension RACE_EXTENSION_CUT = new M_Operation { ArticleId = articles.ENGINE_RACE_EXTENSION.Id, Name = "Engine Race Extension: Cut shape", Duration = 10, ResourceCapabilityId = SawTools.GetNext().Id, HierarchyNumber = 10 }; RACE_EXTENSION_DRILL = new M_Operation { ArticleId = articles.ENGINE_RACE_EXTENSION.Id, Name = "Engine Race Extension: Drill Mount Holes", Duration = 5, ResourceCapabilityId = DrillTools.GetNext().Id, HierarchyNumber = 20 }; // side Walls for Truck-bed SIDEWALL_LONG_CUT = new M_Operation { ArticleId = articles.SIDEWALL_LONG.Id, Name = "Side wall long: Cut long side", Duration = 10, ResourceCapabilityId = SawTools.GetNext().Id, HierarchyNumber = 10 }; SIDEWALL_LONG_DRILL = new M_Operation { ArticleId = articles.SIDEWALL_LONG.Id, Name = "Side wall long: Drill mount holes", Duration = 5, ResourceCapabilityId = DrillTools.GetNext().Id, HierarchyNumber = 20 }; SIDEWALL_SHORT_CUT = new M_Operation { ArticleId = articles.SIDEWALL_SHORT.Id, Name = "Side wall short: Cut short side", Duration = 5, ResourceCapabilityId = SawTools.GetNext().Id, HierarchyNumber = 10 }; SIDEWALL_SHORT_DRILL = new M_Operation { ArticleId = articles.SIDEWALL_SHORT.Id, Name = "Side wall short: Drill mount holes", Duration = 5, ResourceCapabilityId = DrillTools.GetNext().Id, HierarchyNumber = 20 }; BASEPLATE_TRUCK_BED_CUT = new M_Operation { ArticleId = articles.BASEPLATE_TRUCK_BED.Id, Name = "Base plate Truck-Bed: Cut Base plate Truck-Bed", Duration = 10, ResourceCapabilityId = SawTools.GetNext().Id, HierarchyNumber = 10 }; BASEPLATE_TRUCK_BED_DRILL = new M_Operation { ArticleId = articles.BASEPLATE_TRUCK_BED.Id, Name = "Base plate Truck-Bed: Drill mount holes", Duration = 5, ResourceCapabilityId = DrillTools.GetNext().Id, HierarchyNumber = 20 }; // Eengin Block ENGINE_BLOCK_CUT = new M_Operation { ArticleId = articles.ENGINE_BLOCK.Id, Name = "Engine-Block: Cut Engine-Block", Duration = 10, ResourceCapabilityId = SawTools.GetNext().Id, HierarchyNumber = 10 }; ENGINE_BLOCK_DRILL = new M_Operation { ArticleId = articles.ENGINE_BLOCK.Id, Name = "Engine-Block: Drill mount holes", Duration = 5, ResourceCapabilityId = DrillTools.GetNext().Id, HierarchyNumber = 20 }; // cabin CABIN_CUT = new M_Operation { ArticleId = articles.CABIN.Id, Name = "Cabin: Cut Cabin", Duration = 10, ResourceCapabilityId = SawTools.GetNext().Id, HierarchyNumber = 10 }; CABIN_DRILL = new M_Operation { ArticleId = articles.CABIN.Id, Name = "Cabin: Drill mount holes", Duration = 5, ResourceCapabilityId = DrillTools.GetNext().Id, HierarchyNumber = 20 }; // Base Plate BASE_PLATE_CUT = new M_Operation { ArticleId = articles.BASE_PLATE.Id, Name = "Base plate: Cut Base plate", Duration = 10, ResourceCapabilityId = SawTools.GetNext().Id, HierarchyNumber = 10 }; BASE_PLATE_DRILL = new M_Operation { ArticleId = articles.BASE_PLATE.Id, Name = "Base plate: drill holes for axis mount", Duration = 5, ResourceCapabilityId = DrillTools.GetNext().Id, HierarchyNumber = 20 }; }