protected override void InternalConfigure(EntityTypeBuilder <ProductionOrder> builder)
{
base.InternalConfigure(builder);
builder.ToTable("production_order");
ImmsDbContext.RegisterEntityTable <ProductionOrder>("production_order");
builder.Property(e => e.ProductionId).HasColumnName("production_id");
builder.Property(e => e.ProductionCode).HasColumnName("production_code");
builder.Property(e => e.ProductionName).HasColumnName("production_name");
// builder.Property(e => e.WorkshopId).HasColumnName("workshop_id").HasColumnType("bigint(20)");
// builder.Property(e => e.WorkshopCode).HasColumnName("workshop_code");
// builder.Property(e => e.WorkshopName).HasColumnName("workshop_name");
builder.Property(e => e.PlanDate).HasColumnName("plan_date");
builder.Property(e => e.QtyPlanned).HasColumnName("qty_planned").HasColumnType("int(11)");
builder.Property(e => e.QtyGood).HasColumnName("qty_good").HasColumnType("int(11)");
builder.Property(e => e.QtyBad).HasColumnName("qty_bad").HasColumnType("int(11)");
builder.HasOne(e => e.Production).WithMany().HasForeignKey(e => e.ProductionId).HasConstraintName("production_id");
// builder.HasOne(e => e.Workshop).WithMany().HasForeignKey(e => e.WorkshopId).HasConstraintName("workshop_id");
builder.HasMany(e => e.QualityChecks).WithOne(e => e.ProductionOrder).HasForeignKey(e => e.ProductionOrderId).HasConstraintName("production_order_id");
builder.HasMany(e => e.Progresses).WithOne(e => e.ProductionOrder).HasForeignKey(e => e.ProductionOrderId).HasConstraintName("production_order_id");
}
protected override void InternalConfigure(EntityTypeBuilder <RfidCard> builder)
{
base.InternalConfigure(builder);
builder.ToTable("rfid_card");
ImmsDbContext.RegisterEntityTable <RfidCard>("rfid_card");
builder.Property(e => e.RfidNo).HasColumnName("rfid_no");
builder.Property(e => e.CardType).HasColumnName("card_type");
builder.Property(e => e.CardStatus).HasColumnName("card_status");
builder.Property(e => e.ProductionId).HasColumnName("production_id");
builder.Property(e => e.ProductionCode).HasColumnName("production_code");
builder.Property(e => e.ProductionName).HasColumnName("production_name");
builder.Property(e => e.WorkshopId).HasColumnName("workshop_id");
builder.Property(e => e.WorkshopCode).HasColumnName("workshop_code");
builder.Property(e => e.WorkshopName).HasColumnName("workshop_name");
builder.Property(e => e.IssueQty).HasColumnName("issue_qty");
builder.Property(e => e.StockQty).HasColumnName("stock_qty");
builder.Property(e => e.KanbanNo).HasColumnName("kanban_no");
builder.Property(e => e.TowerNo).HasColumnName("tower_no");
builder.Property(e => e.OutsourceQty).HasColumnName("outsource_qty");
builder.HasOne(e => e.Production).WithMany().HasForeignKey(e => e.ProductionId).HasConstraintName("production_id");
builder.HasOne(e => e.Workshop).WithMany().HasForeignKey(e => e.WorkshopId).HasConstraintName("workshop_id");
}
public void Configure(EntityTypeBuilder <MaterialType> builder)
{
ImmsDbContext.RegisterEntityTable <MaterialType>("simple_code");
builder.Ignore(e => e.MaterialTypeCode);
builder.Ignore(e => e.MaterialTypeName);
}
public void Configure(EntityTypeBuilder <EquipmentType> builder)
{
ImmsDbContext.RegisterEntityTable <EquipmentType>("simple_code");
builder.Ignore(e => e.EquipmentTypeNo);
builder.Ignore(e => e.EquipmentTypeName);
}
protected override void InternalConfigure(EntityTypeBuilder <QualityCheck> builder)
{
base.InternalConfigure(builder);
builder.ToTable("quality_check");
ImmsDbContext.RegisterEntityTable <ProductionOrder>("quality_check");
builder.Property(e => e.ProductionOrderId).HasColumnName("production_order_id");
builder.Property(e => e.ProductionOrderNo).HasColumnName("production_order_no");
builder.Property(e => e.ProductionId).HasColumnName("production_id");
builder.Property(e => e.ProductionCode).HasColumnName("production_code");
builder.Property(e => e.ProductionName).HasColumnName("production_name");
builder.Property(e => e.TimeOfOrigin).HasColumnName("time_of_origin");
builder.Property(e => e.TimeOfOriginWork).HasColumnName("time_of_origin_work");
builder.Property(e => e.ShiftId).HasColumnName("shift_id");
builder.Property(e => e.WorkshopId).HasColumnName("workshop_id");
builder.Property(e => e.WorkshopCode).HasColumnName("workshop_code");
builder.Property(e => e.WorkshopName).HasColumnName("workshop_name");
builder.Property(e => e.DefectId).HasColumnName("defect_id");
builder.Property(e => e.DefectCode).HasColumnName("defect_code");
builder.Property(e => e.DefectName).HasColumnName("defect_name");
builder.Property(e => e.Qty).HasColumnName("qty");
builder.Property(e => e.WocgCode).HasColumnName("wocg_code");
builder.Property(e => e.LocCode).HasColumnName("loc_code");
builder.HasOne(e => e.ProductionOrder).WithMany(e => e.QualityChecks).HasForeignKey(e => e.ProductionOrderId).HasConstraintName("production_order_id");
builder.HasOne(e => e.Production).WithMany().HasForeignKey(e => e.ProductionId).HasConstraintName("production_id");
}
protected override void InternalConfigure(EntityTypeBuilder <SystemRole> builder)
{
base.InternalConfigure(builder);
builder.ToTable("system_role");
ImmsDbContext.RegisterEntityTable <SystemRole>("system_role");
builder.Property(e => e.RoleCode).IsRequired().HasColumnName("role_code").HasMaxLength(20).IsUnicode(false);
builder.Property(e => e.RoleName).IsRequired().HasColumnName("role_name").HasMaxLength(50).IsUnicode(false);
}
protected override void InternalConfigure(EntityTypeBuilder <Defect> builder)
{
base.InternalConfigure(builder);
builder.ToTable("defect");
ImmsDbContext.RegisterEntityTable <Defect>("defect");
builder.Property(e => e.DefectCode).HasColumnName("defect_code");
builder.Property(e => e.DefectName).HasColumnName("defect_name");
}
protected override void InternalConfigure(EntityTypeBuilder <SimpleCode> builder)
{
base.InternalConfigure(builder);
builder.ToTable("simple_code");
ImmsDbContext.RegisterEntityTable <SimpleCode>("simple_code");
builder.Property(e => e.CodeName).IsRequired().HasColumnName("code_name").HasMaxLength(30).IsUnicode(false);
builder.Property(e => e.CodeNo).IsRequired().HasColumnName("code_no").HasMaxLength(10).IsUnicode(false);
builder.Property(e => e.Description).HasColumnName("description").HasMaxLength(250).IsUnicode(false);
}
public void Configure(EntityTypeBuilder <Workshop> builder)
{
ImmsDbContext.RegisterEntityTable <Workshop>("work_organization_unit");
builder.Ignore(e => e.WorkshopCode);
builder.Ignore(e => e.WorkshopName);
builder.Property(e => e.OperationIndex).HasColumnName("operation_index");
builder.Property(e => e.PrevOperationIndex).HasColumnName("prev_operation_index");
builder.Property(e => e.WorkshopType).HasColumnName("workshop_type");
}
protected override void InternalConfigure(EntityTypeBuilder <ProductionMoving> builder)
{
base.InternalConfigure(builder);
builder.ToTable("production_moving");
ImmsDbContext.RegisterEntityTable <ProductionOrder>("production_moving");
builder.Property(e => e.ProductionOrderId).HasColumnName("production_order_id");
builder.Property(e => e.ProductionOrderNo).HasColumnName("production_order_no");
builder.Property(e => e.ProductionId).HasColumnName("production_id");
builder.Property(e => e.ProductionCode).HasColumnName("production_code");
builder.Property(e => e.ProductionName).HasColumnName("production_name");
builder.Property(e => e.RfidCardId).HasColumnName("rfid_card_id");
builder.Property(e => e.RfidNo).HasColumnName("rfid_no");
builder.Property(e => e.RfidTerminatorId).HasColumnName("rfid_terminator_id");
builder.Property(e => e.RfidControllerGroupId).HasColumnName("rfid_controller_group_id");
builder.Property(e => e.Qty).HasColumnName("qty");
builder.Property(e => e.OperatorId).HasColumnName("operator_id");
builder.Property(e => e.EmployeeId).HasColumnName("employee_id");
builder.Property(e => e.EmployeeName).HasColumnName("employee_name");
builder.Property(e => e.TimeOfOrigin).HasColumnName("time_of_origin");
builder.Property(e => e.TimeOfOriginWork).HasColumnName("time_of_origin_work");
builder.Property(e => e.ShiftId).HasColumnName("shift_id");
builder.Property(e => e.WorkstationId).HasColumnName("workstation_id");
builder.Property(e => e.WorkstationCode).HasColumnName("workstation_code");
builder.Property(e => e.WorkstationName).HasColumnName("workstation_name");
builder.Property(e => e.WorkshopId).HasColumnName("workshop_id");
builder.Property(e => e.WorkshopCode).HasColumnName("workshop_code");
builder.Property(e => e.WorkshopName).HasColumnName("workshop_name");
builder.Property(e => e.WorkshopIdFrom).HasColumnName("workshop_id_from");
builder.Property(e => e.WorkshopCodeFrom).HasColumnName("workshop_code_from");
builder.Property(e => e.WorkshopNameFrom).HasColumnName("workshop_name_from");
builder.Property(e => e.OperatorIdFrom).HasColumnName("operator_id_from");
builder.Property(e => e.EmployeeIdFrom).HasColumnName("employee_id_from");
builder.Property(e => e.EmployeeNameFrom).HasColumnName("employee_name_from");
builder.Property(e => e.PrevProgressRecordId).HasColumnName("prev_progress_record_id");
builder.HasOne(e => e.RfidCard).WithMany().HasForeignKey(e => e.RfidCardId).HasConstraintName("rfid_card_id");
builder.HasOne(e => e.ProductionOrder).WithMany().HasForeignKey(e => e.ProductionOrderId).HasConstraintName("production_order_id");
builder.HasOne(e => e.Production).WithMany().HasForeignKey(e => e.ProductionId).HasConstraintName("production_id");
builder.HasOne(e => e.Workshop).WithMany().HasForeignKey(e => e.WorkshopId).HasConstraintName("workshop_id");
builder.HasOne(e => e.Workstation).WithMany().HasForeignKey(e => e.WorkstationId).HasConstraintName("workstation_id");
builder.HasOne(e => e.Operator).WithMany().HasForeignKey(e => e.OperatorId).HasConstraintName("operator_id");
}
protected override void InternalConfigure(EntityTypeBuilder <ProgramPrivilege> builder)
{
base.InternalConfigure(builder);
builder.ToTable("program_privilege");
ImmsDbContext.RegisterEntityTable <ProgramPrivilege>("program_privilege");
builder.Property(e => e.PrivilegeCode).IsRequired().HasColumnName("privilege_code").HasMaxLength(50).IsUnicode(false);
builder.Property(e => e.PrivilegeName).IsRequired().HasColumnName("privilege_name").HasMaxLength(120).IsUnicode(false);
builder.Property(e => e.ProgramId).IsRequired().HasColumnName("program_id").HasMaxLength(50).IsUnicode(false);
builder.HasOne(e => e.Program).WithMany(e => e.Privielges).HasForeignKey(x => x.ProgramId).HasConstraintName("program_id");
}
protected override void InternalConfigure(EntityTypeBuilder <RoleUser> builder)
{
base.InternalConfigure(builder);
builder.ToTable("role_user");
ImmsDbContext.RegisterEntityTable <RoleUser>("role_user");
builder.Property(e => e.RoleId).HasColumnName("role_id").HasColumnType("bigint(20)");
builder.Property(e => e.UserId).HasColumnName("user_id").HasColumnType("bigint(20)");
builder.HasOne(e => e.User).WithMany(e => e.Roles).HasForeignKey(e => e.UserId).HasConstraintName("user_id");
builder.HasOne(e => e.Role).WithMany(e => e.Users).HasForeignKey(e => e.RoleId).HasConstraintName("role_id");
}
protected override void InternalConfigure(EntityTypeBuilder <SystemParameter> builder)
{
base.InternalConfigure(builder);
builder.ToTable("system_parameter");
ImmsDbContext.RegisterEntityTable <SystemParameter>("system_parameter");
builder.Property(e => e.ParameterClassCode).HasColumnName("parameter_class_code");
builder.Property(e => e.parameterClassName).HasColumnName("parameter_class_name");
builder.Property(e => e.ParameterCode).HasColumnName("parameter_code");
builder.Property(e => e.ParameterName).HasColumnName("parameter_name");
builder.Property(e => e.ParameterValue).HasColumnName("parameter_value");
}
protected override void InternalConfigure(EntityTypeBuilder <Material> builder)
{
base.InternalConfigure(builder);
builder.ToTable("material");
ImmsDbContext.RegisterEntityTable <Material>("material");
builder.Property(e => e.Description).HasColumnName("description").HasMaxLength(250);
builder.Property(e => e.MaterialName).IsRequired().HasColumnName("material_name").HasMaxLength(50);
builder.Property(e => e.MaterialCode).IsRequired().HasColumnName("material_code").HasMaxLength(20);
builder.Property(e => e.AutoFinishedProgress).HasColumnName("auto_finished_progress");
}
public void UpdateRoles(long userId, RoleUser[] roleUsers, DbContext dbContext)
{
string sql = "delete from " + ImmsDbContext.GetEntityTableName <RoleUser>() + " where user_id = @p0";
dbContext.Database.ExecuteSqlCommand(sql, userId);
foreach (RoleUser roleUser in roleUsers)
{
dbContext.Set <RoleUser>().Add(roleUser);
}
dbContext.SaveChanges();
}
protected override void InternalConfigure(EntityTypeBuilder <RfidController> builder)
{
base.InternalConfigure(builder);
builder.ToTable("v_rfid_controller");
ImmsDbContext.RegisterEntityTable <RfidController>("v_rfid_controller");
builder.Property(e => e.GroupId).HasColumnName("group_id");
builder.Property(e => e.ControllerName).HasColumnName("controller_name");
builder.Property(e => e.Position).HasColumnName("position");
builder.Property(e => e.Ip).HasColumnName("ip");
builder.Property(e => e.Port).HasColumnName("port");
builder.Property(e => e.IsUse).HasColumnName("is_use");
}
protected override void InternalConfigure(EntityTypeBuilder <Equipment> builder)
{
base.InternalConfigure(builder);
builder.ToTable("equipment");
ImmsDbContext.RegisterEntityTable <Equipment>("equipment");
builder.Property(e => e.EquipmentNo).HasColumnName("equipment_no");
builder.Property(e => e.EquipmentName).HasColumnName("equipment_name");
builder.Property(e => e.Description).HasColumnName("description");
builder.Property(e => e.Status).HasColumnName("status");
builder.Property(e => e.EquipmentTypeId).HasColumnName("equipment_type_id");
builder.HasOne(e => e.EquipmentType).WithMany().HasForeignKey(e => e.EquipmentTypeId).HasConstraintName("equipment_type_id");
}
protected override void InternalConfigure(EntityTypeBuilder <Operator> builder)
{
base.InternalConfigure(builder);
builder.ToTable("operator");
ImmsDbContext.RegisterEntityTable <Operator>("operator");
builder.Property(e => e.orgName).HasColumnName("org_name");
builder.Property(e => e.orgId).HasColumnName("org_id");
builder.Property(e => e.orgCode).HasColumnName("org_code");
builder.Property(e => e.EmployeeId).HasColumnName("employee_id");
builder.Property(e => e.EmployeeName).HasColumnName("employee_name");
builder.Property(e => e.EmployeeCardNo).HasColumnName("employee_card_no");
}
protected override void InternalConfigure(EntityTypeBuilder <TreeCode> builder)
{
base.InternalConfigure(builder);
builder.ToTable("tree_code");
ImmsDbContext.RegisterEntityTable <TreeCode>("tree_code");
builder.Property(e => e.CodeNo).IsRequired().HasColumnName("code_no").HasMaxLength(10).IsUnicode(false);
builder.Property(e => e.CodeName).IsRequired().HasColumnName("code_name").HasMaxLength(30).IsUnicode(false);
builder.Property(e => e.Description).HasColumnName("description").HasMaxLength(250).IsUnicode(false);
builder.Property(e => e.ParentId).HasColumnName("parent_id").HasColumnType("bigint(20)").HasDefaultValueSql("0");
builder.HasMany(e => e.Children).WithOne(e => e.Parent).HasForeignKey(e => e.ParentId).HasConstraintName("parent_id");
}
protected override void InternalConfigure(EntityTypeBuilder <CodeSeed> builder)
{
base.InternalConfigure(builder);
builder.ToTable("code_seed");
ImmsDbContext.RegisterEntityTable <CodeSeed>("code_seed");
builder.Property(e => e.InitialValue).HasColumnName("initial_value");
builder.Property(e => e.Postfix).IsRequired().HasColumnName("postfix").HasMaxLength(10);
builder.Property(e => e.Prefix).IsRequired().HasColumnName("prefix").HasMaxLength(10);
builder.Property(e => e.SeedName).IsRequired().HasColumnName("seed_name").HasMaxLength(50);
builder.Property(e => e.SeedNo).IsRequired().HasColumnName("seed_no").HasMaxLength(50);
builder.Property(e => e.TotalLength).HasColumnName("total_length");
}
protected override void InternalConfigure(EntityTypeBuilder <WorkOrganizationUnit> builder)
{
base.InternalConfigure(builder);
builder.ToTable("work_organization_unit");
ImmsDbContext.RegisterEntityTable <WorkOrganizationUnit>("work_organization_unit");
builder.Property(e => e.OrgCode).IsRequired().HasColumnName("org_code").HasMaxLength(10).IsUnicode(false);
builder.Property(e => e.OrgName).IsRequired().HasColumnName("org_name").HasMaxLength(50).IsUnicode(false);
builder.Property(e => e.Description).HasColumnName("description").HasMaxLength(250).IsUnicode(false);
builder.Property(e => e.ParentId).HasColumnName("parent_id").HasColumnType("bigint(20)");
builder.Property(e => e.ParentCode).HasColumnName("parent_code");
builder.Property(e => e.ParentName).HasColumnName("parent_name");
builder.HasMany(e => e.Children).WithOne(e => e.Parent).HasForeignKey(e => e.ParentId).HasConstraintName("parent_id");
}
protected override void InternalConfigure(EntityTypeBuilder <SystemUser> builder)
{
base.InternalConfigure(builder);
builder.ToTable("system_user");
ImmsDbContext.RegisterEntityTable <SystemUser>("system_user");
builder.Property(e => e.Email).IsRequired().HasColumnName("email").HasMaxLength(255).IsUnicode(false);
builder.Property(e => e.IsOnline).HasColumnName("is_online").HasColumnType("bit(1)").HasDefaultValueSql("b'0'");
builder.Property(e => e.LastLoginTime).HasColumnName("last_login_time");
builder.Property(e => e.Pwd).IsRequired().HasColumnName("pwd").HasMaxLength(50).IsUnicode(false);
builder.Property(e => e.UserCode).IsRequired().HasColumnName("user_code").HasMaxLength(20).IsUnicode(false);
builder.Property(e => e.UserName).IsRequired().HasColumnName("user_name").HasMaxLength(50).IsUnicode(false);
builder.Property(e => e.UserStatus).HasColumnName("user_status").HasColumnType("tinyint(4)");
// builder.Property(e=>e.PhoneNumber).HasColumnName("phone_number");
}
public void Configure(EntityTypeBuilder <Workstation> builder)
{
ImmsDbContext.RegisterEntityTable <Workstation>("work_organization_unit");
builder.Ignore(e => e.WorkStaitonCode);
builder.Ignore(e => e.WorkStationName);
builder.Property(e => e.RfidControllerId).HasColumnName("rfid_controller_id");
builder.Property(e => e.RfidTerminatorId).HasColumnName("Rfid_terminator_id");
builder.Property(e => e.WocgCode).HasColumnName("wocg_code");
builder.Property(e => e.RfidTemplateIndex).HasColumnName("rfid_template_index");
builder.Property(e => e.AutoReportCount).HasColumnName("auto_report_count");
builder.Property(e => e.LocCode).HasColumnName("loc_code");
builder.HasOne(e => e.RfidController).WithMany().HasForeignKey(e => e.RfidControllerId).HasConstraintName("rfid_controller_id");
}
protected override void InternalConfigure(EntityTypeBuilder <WorkstationSession> builder)
{
base.InternalConfigure(builder);
builder.ToTable("workstation_session");
ImmsDbContext.RegisterEntityTable <Operator>("workstation_session");
builder.Property(e => e.WorkstationId).HasColumnName("workstation_id");
builder.Property(e => e.SessionType).HasColumnName("session_type");
builder.Property(e => e.CurrentStep).HasColumnName("current_step");
builder.Property(e => e.OperatorId).HasColumnName("operator_id");
builder.Property(e => e.EmployeeId).HasColumnName("employee_id");
builder.Property(e => e.EmployeeName).HasColumnName("employee_name");
builder.Property(e => e.EmployeeCardNo).HasColumnName("employee_card_no");
builder.Property(e => e.GID).HasColumnName("GID");
builder.Property(e => e.DID).HasColumnName("DID");
builder.Property(e => e.CreateTime).HasColumnName("create_time");
builder.Property(e => e.LastProcessTime).HasColumnName("last_process_time");
builder.Property(e => e.ExpireTime).HasColumnName("expire_time");
}
protected override void InternalConfigure(EntityTypeBuilder <CardIssue> builder)
{
base.InternalConfigure(builder);
builder.ToTable("card_issue");
ImmsDbContext.RegisterEntityTable <RfidCard>("card_issue");
builder.Property(e => e.CardId).HasColumnName("card_id");
builder.Property(e => e.CardNo).HasColumnName("card_no");
builder.Property(e => e.IssueUserId).HasColumnName("issue_user_id");
builder.Property(e => e.IssueUserCode).HasColumnName("issue_user_code");
builder.Property(e => e.IssueUserName).HasColumnName("issue_user_name");
builder.Property(e => e.WorkstationId).HasColumnName("workstation_id");
builder.Property(e => e.WorkstationCode).HasColumnName("workstation_code");
builder.Property(e => e.WorkstationName).HasColumnName("workstation_name");
builder.Property(e => e.IssueQty).HasColumnName("issue_qty");
}
protected override void InternalConfigure(EntityTypeBuilder <SystemProgram> builder)
{
base.InternalConfigure(builder);
builder.ToTable("system_program");
ImmsDbContext.RegisterEntityTable <SystemProgram>("system_program");
builder.Property(e => e.Glyph).HasColumnName("glyph").HasMaxLength(100).IsUnicode(false);
builder.Property(e => e.Parameters).IsRequired().HasColumnName("parameters").HasMaxLength(255).IsUnicode(false);
builder.Property(e => e.ParentId).IsRequired().HasColumnName("parent_id").HasMaxLength(50).IsUnicode(false);
builder.Property(e => e.ProgramCode).IsRequired().HasColumnName("program_code").HasMaxLength(50).IsUnicode(false);
builder.Property(e => e.ProgramName).IsRequired().HasColumnName("program_name").HasMaxLength(120).IsUnicode(false);
builder.Property(e => e.ShowOrder).HasColumnName("show_order").HasColumnType("int(11)");
builder.Property(e => e.Url).IsRequired().HasColumnName("url").HasMaxLength(255).IsUnicode(false);
builder.Property(e => e.ProgramStatus).HasColumnName("program_status");
builder.Ignore(e => e.Leaf);
builder.Ignore(e => e.Expanded);
builder.HasMany(e => e.Children).WithOne(e => e.Parent).HasForeignKey(e => e.ParentId).HasConstraintName("parent_id").HasPrincipalKey(x => x.RecordId);
}
protected override void InternalConfigure(EntityTypeBuilder <WorkstationLogin> builder)
{
base.InternalConfigure(builder);
builder.ToTable("Workstation_login");
ImmsDbContext.RegisterEntityTable <Operator>("Workstation_login");
builder.Property(e => e.RfidTerminatorId).HasColumnName("rfid_terminator_id");
builder.Property(e => e.RfidControllerGroupId).HasColumnName("rfid_controller_group_id");
builder.Property(e => e.RfidCardNo).HasColumnName("rfid_card_no");
builder.Property(e => e.LoginTime).HasColumnName("login_time");
builder.Property(e => e.RfidControllerId).HasColumnName("rfid_controller_id");
builder.Property(e => e.WorkstationId).HasColumnName("workstation_id");
builder.Property(e => e.RfidCardId).HasColumnName("rfid_card_id");
builder.Property(e => e.OperatorId).HasColumnName("operator_id");
builder.HasOne(e => e.RfidCard).WithMany().HasForeignKey(e => e.RfidCardId).HasConstraintName("rfid_card_id");
builder.HasOne(e => e.Operator).WithMany().HasForeignKey(e => e.OperatorId).HasConstraintName("operator_id");
builder.HasOne(e => e.WorkStation).WithMany().HasForeignKey(e => e.WorkstationId).HasConstraintName("workstation_id");
builder.HasOne(e => e.RfidController).WithMany().HasForeignKey(e => e.RfidControllerId).HasConstraintName("rfid_controller_id");
}
protected override void InternalConfigure(EntityTypeBuilder <ProductSummary> builder)
{
base.InternalConfigure(builder);
builder.ToTable("product_summary");
ImmsDbContext.RegisterEntityTable <ProductionOrder>("product_summary");
builder.Property(e => e.ProductDate).HasColumnName("product_date");
builder.Property(e => e.WorkshopId).HasColumnName("workshop_id");
builder.Property(e => e.WorkshopCode).HasColumnName("workshop_code");
builder.Property(e => e.WorkshopName).HasColumnName("workshop_name");
builder.Property(e => e.ProductionId).HasColumnName("production_id");
builder.Property(e => e.ProductionCode).HasColumnName("production_code");
builder.Property(e => e.ProductionName).HasColumnName("production_name");
builder.Property(e => e.QtyGood_0).HasColumnName("qty_good_0");
builder.Property(e => e.QtyDefect_0).HasColumnName("qty_defect_0");
builder.Property(e => e.QtyGood_1).HasColumnName("qty_good_1");
builder.Property(e => e.QtyDefect_1).HasColumnName("qty_defect_1");
}
protected override void InternalConfigure(EntityTypeBuilder <Bom> builder)
{
base.InternalConfigure(builder);
builder.ToTable("bom");
ImmsDbContext.RegisterEntityTable <Material>("bom");
builder.Property(e => e.BomNo).IsRequired().HasColumnName("bom_no");
builder.Property(e => e.BomType).IsRequired().HasColumnName("bom_type");
builder.Property(e => e.BomStatus).IsRequired().HasColumnName("bom_status");
builder.Property(e => e.MaterialId).IsRequired().HasColumnName("material_id");
builder.Property(e => e.MaterialName).IsRequired().HasColumnName("material_name").HasMaxLength(50);
builder.Property(e => e.MaterialCode).IsRequired().HasColumnName("material_code").HasMaxLength(20);
builder.Property(e => e.ComponentId).HasColumnName("component_id");
builder.Property(e => e.ComponentCode).HasColumnName("component_code");
builder.Property(e => e.ComponentName).HasColumnName("component_name");
builder.Property(e => e.MaterialQty).HasColumnName("material_qty");
builder.Property(e => e.ComponentQty).HasColumnName("component_qty");
builder.Property(e => e.EffectDate).HasColumnName("effect_date");
}
protected override void InternalConfigure(EntityTypeBuilder <MaterialStock> builder)
{
base.InternalConfigure(builder);
builder.ToTable("material_stock");
ImmsDbContext.RegisterEntityTable <Material>("material_stock");
builder.Property(e => e.MaterialId).IsRequired().HasColumnName("material_id");
builder.Property(e => e.MaterialName).IsRequired().HasColumnName("material_name").HasMaxLength(50);
builder.Property(e => e.MaterialCode).IsRequired().HasColumnName("material_code").HasMaxLength(20);
builder.Property(e => e.StoreId).HasColumnName("store_id");
builder.Property(e => e.StoreCode).HasColumnName("store_code");
builder.Property(e => e.StoreName).HasColumnName("store_name");
builder.Property(e => e.QtyStock).HasColumnName("qty_stock");
builder.Property(e => e.QtyMoveIn).HasColumnName("qty_move_in");
builder.Property(e => e.QtyBackIn).HasColumnName("qty_back_in");
builder.Property(e => e.QtyBackOut).HasColumnName("qty_back_out");
builder.Property(e => e.QtyConsumeGood).HasColumnName("qty_consume_good");
builder.Property(e => e.QtyConsumeDefect).HasColumnName("qty_consume_defect");
builder.Property(e => e.QtyGood).HasColumnName("qty_good");
builder.Property(e => e.QtyDefect).HasColumnName("qty_defect");
builder.Property(e => e.QtyMoveOut).HasColumnName("qty_move_out");
}
