Samuele Locatelli
869 lines
32 KiB
C#
869 lines
32 KiB
C#
// <auto-generated />
|
|
using System;
|
|
using GWMS.Data;
|
|
using Microsoft.EntityFrameworkCore;
|
|
using Microsoft.EntityFrameworkCore.Infrastructure;
|
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
|
|
|
|
namespace GWMS.Data.Migrations
|
|
{
|
|
[DbContext(typeof(GWMSContext))]
|
|
[Migration("20210806134012_PlantData_AddLevelReoder")]
|
|
partial class PlantData_AddLevelReoder
|
|
{
|
|
protected override void BuildTargetModel(ModelBuilder modelBuilder)
|
|
{
|
|
#pragma warning disable 612, 618
|
|
modelBuilder
|
|
.HasAnnotation("Relational:MaxIdentifierLength", 64)
|
|
.HasAnnotation("ProductVersion", "5.0.7");
|
|
|
|
modelBuilder.Entity("GWMS.Data.DatabaseModels.AnKeyValModel", b =>
|
|
{
|
|
b.Property<string>("KeyName")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("varchar(50)");
|
|
|
|
b.Property<string>("Descript")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("varchar(250)")
|
|
.HasComment("Descrizione dell'item");
|
|
|
|
b.Property<int>("ValFloat")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("ValInt")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("ValString")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("varchar(250)");
|
|
|
|
b.HasKey("KeyName");
|
|
|
|
b.ToTable("AnKeyVal");
|
|
});
|
|
|
|
modelBuilder.Entity("GWMS.Data.DatabaseModels.ConfigModel", b =>
|
|
{
|
|
b.Property<string>("KeyName")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("varchar(50)");
|
|
|
|
b.Property<string>("Note")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("varchar(250)");
|
|
|
|
b.Property<string>("Val")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("varchar(50)");
|
|
|
|
b.Property<string>("ValStd")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("varchar(50)")
|
|
.HasComment("Valore di default/riferimento per la variabile");
|
|
|
|
b.HasKey("KeyName");
|
|
|
|
b.ToTable("Config");
|
|
});
|
|
|
|
modelBuilder.Entity("GWMS.Data.DatabaseModels.ItemModel", b =>
|
|
{
|
|
b.Property<int>("ItemId")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("ItemCode")
|
|
.HasMaxLength(100)
|
|
.HasColumnType("varchar(100)");
|
|
|
|
b.Property<string>("ItemDesc")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("varchar(250)");
|
|
|
|
b.Property<string>("ItemType")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("varchar(50)");
|
|
|
|
b.Property<string>("UM")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("varchar(50)");
|
|
|
|
b.HasKey("ItemId");
|
|
|
|
b.ToTable("Items");
|
|
});
|
|
|
|
modelBuilder.Entity("GWMS.Data.DatabaseModels.ListValModel", b =>
|
|
{
|
|
b.Property<string>("TabName")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("varchar(50)")
|
|
.HasColumnName("TabName");
|
|
|
|
b.Property<string>("FieldName")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("varchar(50)")
|
|
.HasColumnName("FieldName");
|
|
|
|
b.Property<string>("Val")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("varchar(50)")
|
|
.HasColumnName("Val");
|
|
|
|
b.Property<string>("Descript")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("varchar(250)")
|
|
.HasColumnName("Descript");
|
|
|
|
b.Property<int>("Ordinal")
|
|
.HasColumnType("int")
|
|
.HasColumnName("Ordinal");
|
|
|
|
b.HasKey("TabName", "FieldName", "Val");
|
|
|
|
b.ToTable("ListVal");
|
|
});
|
|
|
|
modelBuilder.Entity("GWMS.Data.DatabaseModels.OrderModel", b =>
|
|
{
|
|
b.Property<int>("OrderId")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
b.Property<DateTime>("DtETA")
|
|
.HasColumnType("datetime(6)");
|
|
|
|
b.Property<DateTime>("DtExecEnd")
|
|
.HasColumnType("datetime(6)");
|
|
|
|
b.Property<DateTime>("DtExecStart")
|
|
.HasColumnType("datetime(6)");
|
|
|
|
b.Property<DateTime>("DtOrder")
|
|
.HasColumnType("datetime(6)");
|
|
|
|
b.Property<double>("ExecutionQty")
|
|
.HasColumnType("double");
|
|
|
|
b.Property<string>("OrderCode")
|
|
.HasMaxLength(100)
|
|
.HasColumnType("varchar(100)");
|
|
|
|
b.Property<string>("OrderDesc")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("varchar(250)");
|
|
|
|
b.Property<double>("OrderQty")
|
|
.HasColumnType("double");
|
|
|
|
b.Property<int>("PlantId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("SupplierId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("TransporterId")
|
|
.HasColumnType("int");
|
|
|
|
b.HasKey("OrderId");
|
|
|
|
b.HasIndex("PlantId");
|
|
|
|
b.HasIndex("SupplierId");
|
|
|
|
b.HasIndex("TransporterId");
|
|
|
|
b.ToTable("Order");
|
|
});
|
|
|
|
modelBuilder.Entity("GWMS.Data.DatabaseModels.PlantDetailModel", b =>
|
|
{
|
|
b.Property<int>("PlantId")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
b.Property<double>("LevelMax")
|
|
.HasColumnType("double");
|
|
|
|
b.Property<double>("LevelReorder")
|
|
.HasColumnType("double");
|
|
|
|
b.Property<string>("PlantCode")
|
|
.HasMaxLength(100)
|
|
.HasColumnType("varchar(100)");
|
|
|
|
b.Property<string>("PlantDesc")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("varchar(250)");
|
|
|
|
b.HasKey("PlantId");
|
|
|
|
b.ToTable("PlantDetail");
|
|
|
|
b.HasData(
|
|
new
|
|
{
|
|
PlantId = 1,
|
|
LevelMax = 26000.0,
|
|
LevelReorder = 15000.0,
|
|
PlantCode = "PIZ03",
|
|
PlantDesc = "Collecchio"
|
|
},
|
|
new
|
|
{
|
|
PlantId = 2,
|
|
LevelMax = 28000.0,
|
|
LevelReorder = 15000.0,
|
|
PlantCode = "PIZ04",
|
|
PlantDesc = "Noceto"
|
|
},
|
|
new
|
|
{
|
|
PlantId = 3,
|
|
LevelMax = 24000.0,
|
|
LevelReorder = 15000.0,
|
|
PlantCode = "PIZ05",
|
|
PlantDesc = "Baganzola"
|
|
},
|
|
new
|
|
{
|
|
PlantId = 4,
|
|
LevelMax = 26000.0,
|
|
LevelReorder = 15000.0,
|
|
PlantCode = "PIZ08",
|
|
PlantDesc = "Pilastrello"
|
|
});
|
|
});
|
|
|
|
modelBuilder.Entity("GWMS.Data.DatabaseModels.PlantLogModel", b =>
|
|
{
|
|
b.Property<int>("PlantDataId")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
b.Property<DateTime>("DtEvent")
|
|
.HasColumnType("datetime(6)");
|
|
|
|
b.Property<string>("FluxType")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("varchar(250)");
|
|
|
|
b.Property<int>("PlantId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<double>("ValNumber")
|
|
.HasColumnType("double");
|
|
|
|
b.Property<string>("ValString")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("varchar(250)");
|
|
|
|
b.HasKey("PlantDataId");
|
|
|
|
b.HasIndex("PlantId");
|
|
|
|
b.ToTable("PlantLog");
|
|
});
|
|
|
|
modelBuilder.Entity("GWMS.Data.DatabaseModels.PlantStatusModel", b =>
|
|
{
|
|
b.Property<int>("PlantId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("FluxType")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("varchar(250)");
|
|
|
|
b.Property<DateTime>("DtEvent")
|
|
.HasColumnType("datetime(6)");
|
|
|
|
b.Property<double>("ValNumber")
|
|
.HasColumnType("double");
|
|
|
|
b.Property<string>("ValString")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("varchar(250)");
|
|
|
|
b.HasKey("PlantId", "FluxType");
|
|
|
|
b.ToTable("PlantStatus");
|
|
});
|
|
|
|
modelBuilder.Entity("GWMS.Data.DatabaseModels.RebootLogModel", b =>
|
|
{
|
|
b.Property<int>("RecordId")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
b.Property<DateTime>("DtEvent")
|
|
.HasColumnType("datetime(6)");
|
|
|
|
b.Property<string>("Item")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("varchar(250)");
|
|
|
|
b.Property<string>("Payload")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("varchar(250)");
|
|
|
|
b.HasKey("RecordId");
|
|
|
|
b.ToTable("RebootLog");
|
|
});
|
|
|
|
modelBuilder.Entity("GWMS.Data.DatabaseModels.SupplierModel", b =>
|
|
{
|
|
b.Property<int>("SupplierId")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("SupplierCode")
|
|
.HasMaxLength(100)
|
|
.HasColumnType("varchar(100)");
|
|
|
|
b.Property<string>("SupplierDesc")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("varchar(250)");
|
|
|
|
b.HasKey("SupplierId");
|
|
|
|
b.ToTable("Supplier");
|
|
|
|
b.HasData(
|
|
new
|
|
{
|
|
SupplierId = 1,
|
|
SupplierCode = "LIQUIGAS",
|
|
SupplierDesc = "Liquigas"
|
|
},
|
|
new
|
|
{
|
|
SupplierId = 2,
|
|
SupplierCode = "VULKANGAS",
|
|
SupplierDesc = "Vulkangas"
|
|
});
|
|
});
|
|
|
|
modelBuilder.Entity("GWMS.Data.DatabaseModels.TransporterModel", b =>
|
|
{
|
|
b.Property<int>("TransporterId")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
b.Property<double>("PositionLatitude")
|
|
.HasColumnType("double");
|
|
|
|
b.Property<double>("PositionLongitude")
|
|
.HasColumnType("double");
|
|
|
|
b.Property<DateTime>("PositionUpdated")
|
|
.HasColumnType("datetime(6)");
|
|
|
|
b.Property<string>("TransporterCode")
|
|
.HasMaxLength(100)
|
|
.HasColumnType("varchar(100)");
|
|
|
|
b.Property<string>("TransporterDesc")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("varchar(250)");
|
|
|
|
b.HasKey("TransporterId");
|
|
|
|
b.ToTable("Transporter");
|
|
|
|
b.HasData(
|
|
new
|
|
{
|
|
TransporterId = 1,
|
|
PositionLatitude = 0.0,
|
|
PositionLongitude = 0.0,
|
|
PositionUpdated = new DateTime(2021, 8, 6, 15, 40, 12, 341, DateTimeKind.Local).AddTicks(9521),
|
|
TransporterCode = "LEVO",
|
|
TransporterDesc = "Levorato"
|
|
},
|
|
new
|
|
{
|
|
TransporterId = 2,
|
|
PositionLatitude = 0.0,
|
|
PositionLongitude = 0.0,
|
|
PositionUpdated = new DateTime(2021, 8, 6, 15, 40, 12, 341, DateTimeKind.Local).AddTicks(9901),
|
|
TransporterCode = "TRAF",
|
|
TransporterDesc = "Traffik"
|
|
});
|
|
});
|
|
|
|
modelBuilder.Entity("GWMS.Data.DatabaseModels.UserModel", b =>
|
|
{
|
|
b.Property<int>("UserId")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("AuthKey")
|
|
.HasMaxLength(100)
|
|
.HasColumnType("varchar(100)");
|
|
|
|
b.Property<string>("Email")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("varchar(250)");
|
|
|
|
b.Property<string>("Firstname")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("varchar(50)");
|
|
|
|
b.Property<bool>("IsActive")
|
|
.HasColumnType("tinyint(1)");
|
|
|
|
b.Property<string>("Lang")
|
|
.HasMaxLength(10)
|
|
.HasColumnType("varchar(10)");
|
|
|
|
b.Property<string>("Lastname")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("varchar(50)");
|
|
|
|
b.Property<int>("Livello")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("MaskPlantId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("MaskSupplierId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("MaskTranspId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("SaltPasswd")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("varchar(250)");
|
|
|
|
b.Property<string>("UserName")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("varchar(50)");
|
|
|
|
b.HasKey("UserId");
|
|
|
|
b.ToTable("Users");
|
|
|
|
b.HasData(
|
|
new
|
|
{
|
|
UserId = 1,
|
|
AuthKey = "th1sIsTh3R1vrOfThNgt98",
|
|
Email = "samuele@steamware.net",
|
|
Firstname = "Samuele",
|
|
IsActive = true,
|
|
Lang = "IT",
|
|
Lastname = "Locatelli",
|
|
Livello = 1,
|
|
MaskPlantId = 0,
|
|
MaskSupplierId = 0,
|
|
MaskTranspId = 0,
|
|
SaltPasswd = "",
|
|
UserName = "samuele.locatelli"
|
|
},
|
|
new
|
|
{
|
|
UserId = 2,
|
|
AuthKey = "th1sIsTh3R1vrOfThNgt91",
|
|
Email = "giancarlo@steamware.net",
|
|
Firstname = "Giancarlo",
|
|
IsActive = true,
|
|
Lang = "IT",
|
|
Lastname = "Rottoli",
|
|
Livello = 1,
|
|
MaskPlantId = 0,
|
|
MaskSupplierId = 0,
|
|
MaskTranspId = 0,
|
|
SaltPasswd = "",
|
|
UserName = "giancarlo.rottoli"
|
|
},
|
|
new
|
|
{
|
|
UserId = 3,
|
|
AuthKey = "th1sIsTh3R1vrOfThNgt93",
|
|
Email = "info@steamware.net",
|
|
Firstname = "Steamware",
|
|
IsActive = true,
|
|
Lang = "IT",
|
|
Lastname = "Admin",
|
|
Livello = 1,
|
|
MaskPlantId = 0,
|
|
MaskSupplierId = 0,
|
|
MaskTranspId = 0,
|
|
SaltPasswd = "",
|
|
UserName = "steamw.admin"
|
|
},
|
|
new
|
|
{
|
|
UserId = 4,
|
|
AuthKey = "th1sIsTh3R1vrOfThNgt97",
|
|
Email = "a.pizzaferri@pizzaferripetroli.it",
|
|
Firstname = "Angelo",
|
|
IsActive = true,
|
|
Lang = "IT",
|
|
Lastname = "Pizzaferri",
|
|
Livello = 2,
|
|
MaskPlantId = 0,
|
|
MaskSupplierId = 0,
|
|
MaskTranspId = 0,
|
|
SaltPasswd = "",
|
|
UserName = "angelo.pizzaferri"
|
|
},
|
|
new
|
|
{
|
|
UserId = 5,
|
|
AuthKey = "th1sIsTh3R1vrOfThNgt99",
|
|
Email = "andrei.valeanu@winnlab.it",
|
|
Firstname = "Andrei",
|
|
IsActive = true,
|
|
Lang = "IT",
|
|
Lastname = "Valeanu",
|
|
Livello = 2,
|
|
MaskPlantId = 0,
|
|
MaskSupplierId = 0,
|
|
MaskTranspId = 0,
|
|
SaltPasswd = "",
|
|
UserName = "andrei.valeanu"
|
|
},
|
|
new
|
|
{
|
|
UserId = 6,
|
|
AuthKey = "th1sIsTh3R1vrOfThNgt92",
|
|
Email = "info@steamware.net",
|
|
Firstname = "User",
|
|
IsActive = true,
|
|
Lang = "IT",
|
|
Lastname = "LIQUIGAS",
|
|
Livello = 4,
|
|
MaskPlantId = 0,
|
|
MaskSupplierId = 1,
|
|
MaskTranspId = 0,
|
|
SaltPasswd = "",
|
|
UserName = "liquigas.user01"
|
|
},
|
|
new
|
|
{
|
|
UserId = 7,
|
|
AuthKey = "th1sIsTh3R1vrOfThNgt94",
|
|
Email = "info@steamware.net",
|
|
Firstname = "User",
|
|
IsActive = true,
|
|
Lang = "IT",
|
|
Lastname = "VULKANGAS",
|
|
Livello = 4,
|
|
MaskPlantId = 0,
|
|
MaskSupplierId = 2,
|
|
MaskTranspId = 0,
|
|
SaltPasswd = "",
|
|
UserName = "vulkangas.user01"
|
|
},
|
|
new
|
|
{
|
|
UserId = 8,
|
|
AuthKey = "th1sIsTh3R1vrOfThNgt95",
|
|
Email = "info@steamware.net",
|
|
Firstname = "User",
|
|
IsActive = true,
|
|
Lang = "IT",
|
|
Lastname = "LEVORATO",
|
|
Livello = 4,
|
|
MaskPlantId = 0,
|
|
MaskSupplierId = 0,
|
|
MaskTranspId = 1,
|
|
SaltPasswd = "",
|
|
UserName = "levorato.user01"
|
|
},
|
|
new
|
|
{
|
|
UserId = 9,
|
|
AuthKey = "th1sIsTh3R1vrOfThNgt96",
|
|
Email = "info@steamware.net",
|
|
Firstname = "User",
|
|
IsActive = true,
|
|
Lang = "IT",
|
|
Lastname = "TRAFFIK",
|
|
Livello = 4,
|
|
MaskPlantId = 0,
|
|
MaskSupplierId = 0,
|
|
MaskTranspId = 2,
|
|
SaltPasswd = "",
|
|
UserName = "traffik.user01"
|
|
},
|
|
new
|
|
{
|
|
UserId = 10,
|
|
AuthKey = "th1sIsTh3R1vrOfThNgt96",
|
|
Email = "info@steamware.net",
|
|
Firstname = "Stazione",
|
|
IsActive = true,
|
|
Lang = "IT",
|
|
Lastname = "Collecchio",
|
|
Livello = 3,
|
|
MaskPlantId = 1,
|
|
MaskSupplierId = 0,
|
|
MaskTranspId = 0,
|
|
SaltPasswd = "",
|
|
UserName = "piz03.user01"
|
|
},
|
|
new
|
|
{
|
|
UserId = 11,
|
|
AuthKey = "th1sIsTh3R1vrOfThNgt96",
|
|
Email = "info@steamware.net",
|
|
Firstname = "Stazione",
|
|
IsActive = true,
|
|
Lang = "IT",
|
|
Lastname = "Noceto",
|
|
Livello = 3,
|
|
MaskPlantId = 2,
|
|
MaskSupplierId = 0,
|
|
MaskTranspId = 0,
|
|
SaltPasswd = "",
|
|
UserName = "piz04.user01"
|
|
},
|
|
new
|
|
{
|
|
UserId = 12,
|
|
AuthKey = "th1sIsTh3R1vrOfThNgt96",
|
|
Email = "info@steamware.net",
|
|
Firstname = "Stazione",
|
|
IsActive = true,
|
|
Lang = "IT",
|
|
Lastname = "Baganzola",
|
|
Livello = 3,
|
|
MaskPlantId = 3,
|
|
MaskSupplierId = 0,
|
|
MaskTranspId = 0,
|
|
SaltPasswd = "",
|
|
UserName = "piz05.user01"
|
|
},
|
|
new
|
|
{
|
|
UserId = 13,
|
|
AuthKey = "th1sIsTh3R1vrOfThNgt96",
|
|
Email = "info@steamware.net",
|
|
Firstname = "Stazione",
|
|
IsActive = true,
|
|
Lang = "IT",
|
|
Lastname = "Pilastrello",
|
|
Livello = 3,
|
|
MaskPlantId = 4,
|
|
MaskSupplierId = 0,
|
|
MaskTranspId = 0,
|
|
SaltPasswd = "",
|
|
UserName = "piz08.user01"
|
|
});
|
|
});
|
|
|
|
modelBuilder.Entity("GWMS.Data.DatabaseModels.WeekPlanModel", b =>
|
|
{
|
|
b.Property<int>("WeekPlanId")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("DayNum")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("DeliveryHour")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("Note")
|
|
.HasMaxLength(250)
|
|
.HasColumnType("varchar(250)");
|
|
|
|
b.Property<int>("PlantId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("SupplierId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("TransporterId")
|
|
.HasColumnType("int");
|
|
|
|
b.HasKey("WeekPlanId");
|
|
|
|
b.HasIndex("PlantId");
|
|
|
|
b.HasIndex("SupplierId");
|
|
|
|
b.HasIndex("TransporterId");
|
|
|
|
b.ToTable("WeekPlan");
|
|
|
|
b.HasData(
|
|
new
|
|
{
|
|
WeekPlanId = 1,
|
|
DayNum = 1,
|
|
DeliveryHour = 20,
|
|
Note = "18K",
|
|
PlantId = 2,
|
|
SupplierId = 1,
|
|
TransporterId = 1
|
|
},
|
|
new
|
|
{
|
|
WeekPlanId = 2,
|
|
DayNum = 2,
|
|
DeliveryHour = 20,
|
|
Note = "18K",
|
|
PlantId = 2,
|
|
SupplierId = 1,
|
|
TransporterId = 1
|
|
},
|
|
new
|
|
{
|
|
WeekPlanId = 3,
|
|
DayNum = 3,
|
|
DeliveryHour = 20,
|
|
Note = "18K",
|
|
PlantId = 2,
|
|
SupplierId = 1,
|
|
TransporterId = 2
|
|
},
|
|
new
|
|
{
|
|
WeekPlanId = 4,
|
|
DayNum = 4,
|
|
DeliveryHour = 15,
|
|
Note = "9K",
|
|
PlantId = 2,
|
|
SupplierId = 1,
|
|
TransporterId = 1
|
|
},
|
|
new
|
|
{
|
|
WeekPlanId = 5,
|
|
DayNum = 4,
|
|
DeliveryHour = 20,
|
|
Note = "18K",
|
|
PlantId = 2,
|
|
SupplierId = 1,
|
|
TransporterId = 1
|
|
},
|
|
new
|
|
{
|
|
WeekPlanId = 6,
|
|
DayNum = 6,
|
|
DeliveryHour = 20,
|
|
Note = "18K",
|
|
PlantId = 2,
|
|
SupplierId = 1,
|
|
TransporterId = 1
|
|
},
|
|
new
|
|
{
|
|
WeekPlanId = 7,
|
|
DayNum = 2,
|
|
DeliveryHour = 14,
|
|
Note = "3K",
|
|
PlantId = 3,
|
|
SupplierId = 1,
|
|
TransporterId = 1
|
|
},
|
|
new
|
|
{
|
|
WeekPlanId = 8,
|
|
DayNum = 2,
|
|
DeliveryHour = 15,
|
|
Note = "15K",
|
|
PlantId = 4,
|
|
SupplierId = 1,
|
|
TransporterId = 1
|
|
},
|
|
new
|
|
{
|
|
WeekPlanId = 9,
|
|
DayNum = 2,
|
|
DeliveryHour = 17,
|
|
Note = "18K",
|
|
PlantId = 1,
|
|
SupplierId = 2,
|
|
TransporterId = 2
|
|
});
|
|
});
|
|
|
|
modelBuilder.Entity("GWMS.Data.DatabaseModels.OrderModel", b =>
|
|
{
|
|
b.HasOne("GWMS.Data.DatabaseModels.PlantDetailModel", "Plant")
|
|
.WithMany()
|
|
.HasForeignKey("PlantId")
|
|
.OnDelete(DeleteBehavior.Restrict)
|
|
.IsRequired();
|
|
|
|
b.HasOne("GWMS.Data.DatabaseModels.SupplierModel", "Supplier")
|
|
.WithMany()
|
|
.HasForeignKey("SupplierId")
|
|
.OnDelete(DeleteBehavior.Restrict)
|
|
.IsRequired();
|
|
|
|
b.HasOne("GWMS.Data.DatabaseModels.TransporterModel", "Transporter")
|
|
.WithMany()
|
|
.HasForeignKey("TransporterId")
|
|
.OnDelete(DeleteBehavior.Restrict)
|
|
.IsRequired();
|
|
|
|
b.Navigation("Plant");
|
|
|
|
b.Navigation("Supplier");
|
|
|
|
b.Navigation("Transporter");
|
|
});
|
|
|
|
modelBuilder.Entity("GWMS.Data.DatabaseModels.PlantLogModel", b =>
|
|
{
|
|
b.HasOne("GWMS.Data.DatabaseModels.PlantDetailModel", "Plant")
|
|
.WithMany()
|
|
.HasForeignKey("PlantId")
|
|
.OnDelete(DeleteBehavior.Restrict)
|
|
.IsRequired();
|
|
|
|
b.Navigation("Plant");
|
|
});
|
|
|
|
modelBuilder.Entity("GWMS.Data.DatabaseModels.PlantStatusModel", b =>
|
|
{
|
|
b.HasOne("GWMS.Data.DatabaseModels.PlantDetailModel", "Plant")
|
|
.WithMany()
|
|
.HasForeignKey("PlantId")
|
|
.OnDelete(DeleteBehavior.Restrict)
|
|
.IsRequired();
|
|
|
|
b.Navigation("Plant");
|
|
});
|
|
|
|
modelBuilder.Entity("GWMS.Data.DatabaseModels.WeekPlanModel", b =>
|
|
{
|
|
b.HasOne("GWMS.Data.DatabaseModels.PlantDetailModel", "Plant")
|
|
.WithMany()
|
|
.HasForeignKey("PlantId")
|
|
.OnDelete(DeleteBehavior.Restrict)
|
|
.IsRequired();
|
|
|
|
b.HasOne("GWMS.Data.DatabaseModels.SupplierModel", "Supplier")
|
|
.WithMany()
|
|
.HasForeignKey("SupplierId")
|
|
.OnDelete(DeleteBehavior.Restrict)
|
|
.IsRequired();
|
|
|
|
b.HasOne("GWMS.Data.DatabaseModels.TransporterModel", "Transporter")
|
|
.WithMany()
|
|
.HasForeignKey("TransporterId")
|
|
.OnDelete(DeleteBehavior.Restrict)
|
|
.IsRequired();
|
|
|
|
b.Navigation("Plant");
|
|
|
|
b.Navigation("Supplier");
|
|
|
|
b.Navigation("Transporter");
|
|
});
|
|
#pragma warning restore 612, 618
|
|
}
|
|
}
|
|
}
|