namespace iWareSda_QQJF.WCSNEW.EDM
|
{
|
using System;
|
using System.Data.Entity;
|
using System.ComponentModel.DataAnnotations.Schema;
|
using System.Linq;
|
|
public partial class Model : DbContext
|
{
|
public Model()
|
: base("name=Model1")
|
{
|
}
|
|
public virtual DbSet<ALERT_ALERT> ALERT_ALERT { get; set; }
|
public virtual DbSet<ALERT_ALERTTIME> ALERT_ALERTTIME { get; set; }
|
public virtual DbSet<BASE_CONTAINER> BASE_CONTAINER { get; set; }
|
public virtual DbSet<BASE_CONTAINER_VS_ITEM> BASE_CONTAINER_VS_ITEM { get; set; }
|
public virtual DbSet<BASE_DESTINATION> BASE_DESTINATION { get; set; }
|
public virtual DbSet<BASE_DEVICE> BASE_DEVICE { get; set; }
|
public virtual DbSet<BASE_INTYPE> BASE_INTYPE { get; set; }
|
public virtual DbSet<BASE_ITEM> BASE_ITEM { get; set; }
|
public virtual DbSet<BASE_Material> BASE_Material { get; set; }
|
public virtual DbSet<BASE_PALLET> BASE_PALLET { get; set; }
|
public virtual DbSet<BASE_PLACE> BASE_PLACE { get; set; }
|
public virtual DbSet<BASE_PLACE_VS_CONTAINER> BASE_PLACE_VS_CONTAINER { get; set; }
|
public virtual DbSet<BASE_PLACETYPE> BASE_PLACETYPE { get; set; }
|
public virtual DbSet<BASE_PRINT> BASE_PRINT { get; set; }
|
public virtual DbSet<BASE_PRODUCTIONLINE> BASE_PRODUCTIONLINE { get; set; }
|
public virtual DbSet<BASE_URL> BASE_URL { get; set; }
|
public virtual DbSet<CAR_CAR> CAR_CAR { get; set; }
|
public virtual DbSet<CAR_CARTASK> CAR_CARTASK { get; set; }
|
public virtual DbSet<ERP_EPRORDER> ERP_EPRORDER { get; set; }
|
public virtual DbSet<KEYVALUE> KEYVALUE { get; set; }
|
public virtual DbSet<LOG_WMSLOG> LOG_WMSLOG { get; set; }
|
public virtual DbSet<ORDER_INORDER> ORDER_INORDER { get; set; }
|
public virtual DbSet<ORDER_OUTORDER> ORDER_OUTORDER { get; set; }
|
public virtual DbSet<PDA_VERSION> PDA_VERSION { get; set; }
|
public virtual DbSet<RECORD_WAREHOUSEINFO> RECORD_WAREHOUSEINFO { get; set; }
|
public virtual DbSet<RgvTask> RgvTask { get; set; }
|
public virtual DbSet<SrmTask> SrmTask { get; set; }
|
public virtual DbSet<STORAGERECORD> STORAGERECORD { get; set; }
|
public virtual DbSet<SYS_DEPT> SYS_DEPT { get; set; }
|
public virtual DbSet<SYS_PERMISSION> SYS_PERMISSION { get; set; }
|
public virtual DbSet<SYS_ROLE> SYS_ROLE { get; set; }
|
public virtual DbSet<SYS_ROLE_VS_PERMISSION> SYS_ROLE_VS_PERMISSION { get; set; }
|
public virtual DbSet<SYS_USER> SYS_USER { get; set; }
|
public virtual DbSet<SYS_USER_VS_ROLE> SYS_USER_VS_ROLE { get; set; }
|
public virtual DbSet<sysdiagrams> sysdiagrams { get; set; }
|
public virtual DbSet<TASK_RECORD> TASK_RECORD { get; set; }
|
public virtual DbSet<TASK_SRMRECORD> TASK_SRMRECORD { get; set; }
|
public virtual DbSet<TASK_TASK> TASK_TASK { get; set; }
|
public virtual DbSet<TranLock> TranLock { get; set; }
|
public virtual DbSet<TranTask> TranTask { get; set; }
|
public virtual DbSet<v3D_Inventory> v3D_Inventory { get; set; }
|
public virtual DbSet<v3D展示数据> v3D展示数据 { get; set; }
|
public virtual DbSet<View_ALERT_ALERT> View_ALERT_ALERT { get; set; }
|
public virtual DbSet<View_BASE_CONTAINER> View_BASE_CONTAINER { get; set; }
|
public virtual DbSet<View_BASE_CONTAINER_VS_ITEM> View_BASE_CONTAINER_VS_ITEM { get; set; }
|
public virtual DbSet<View_BASE_DEVICE> View_BASE_DEVICE { get; set; }
|
public virtual DbSet<View_BASE_INTYPE> View_BASE_INTYPE { get; set; }
|
public virtual DbSet<View_BASE_ITEM> View_BASE_ITEM { get; set; }
|
public virtual DbSet<View_BASE_PLACE> View_BASE_PLACE { get; set; }
|
public virtual DbSet<View_BASE_PLACE_VS_CONTAINER> View_BASE_PLACE_VS_CONTAINER { get; set; }
|
public virtual DbSet<View_BASE_PRODUCTIONLINE> View_BASE_PRODUCTIONLINE { get; set; }
|
public virtual DbSet<View_CAR_CAR> View_CAR_CAR { get; set; }
|
public virtual DbSet<View_CAR_CARTASK> View_CAR_CARTASK { get; set; }
|
public virtual DbSet<View_ITEMSTORAGE> View_ITEMSTORAGE { get; set; }
|
public virtual DbSet<View_ORDER_INORDER> View_ORDER_INORDER { get; set; }
|
public virtual DbSet<View_ORDER_OUTORDER> View_ORDER_OUTORDER { get; set; }
|
public virtual DbSet<View_RGVTASK> View_RGVTASK { get; set; }
|
public virtual DbSet<View_ROLE_VS_PERMISSION> View_ROLE_VS_PERMISSION { get; set; }
|
public virtual DbSet<View_SRMTASK> View_SRMTASK { get; set; }
|
public virtual DbSet<View_SYS_DEPT> View_SYS_DEPT { get; set; }
|
public virtual DbSet<View_SYS_PERMISSION> View_SYS_PERMISSION { get; set; }
|
public virtual DbSet<View_SYS_ROLE> View_SYS_ROLE { get; set; }
|
public virtual DbSet<View_SYS_USER> View_SYS_USER { get; set; }
|
public virtual DbSet<View_TASK_RECORD> View_TASK_RECORD { get; set; }
|
public virtual DbSet<View_TASK_SRMRECORD> View_TASK_SRMRECORD { get; set; }
|
public virtual DbSet<View_TASK_TASK> View_TASK_TASK { get; set; }
|
|
protected override void OnModelCreating(DbModelBuilder modelBuilder)
|
{
|
modelBuilder.Entity<BASE_CONTAINER>()
|
.HasMany(e => e.BASE_CONTAINER_VS_ITEM)
|
.WithOptional(e => e.BASE_CONTAINER)
|
.HasForeignKey(e => e.CONTAINERID);
|
|
modelBuilder.Entity<BASE_CONTAINER>()
|
.HasMany(e => e.BASE_PLACE_VS_CONTAINER)
|
.WithOptional(e => e.BASE_CONTAINER)
|
.HasForeignKey(e => e.CONTAINERID);
|
|
modelBuilder.Entity<BASE_CONTAINER>()
|
.HasMany(e => e.CAR_CARTASK)
|
.WithOptional(e => e.BASE_CONTAINER)
|
.HasForeignKey(e => e.CONTAINERID);
|
|
modelBuilder.Entity<BASE_CONTAINER>()
|
.HasMany(e => e.TASK_RECORD)
|
.WithRequired(e => e.BASE_CONTAINER)
|
.HasForeignKey(e => e.CONTAINERID)
|
.WillCascadeOnDelete(false);
|
|
modelBuilder.Entity<BASE_CONTAINER>()
|
.HasMany(e => e.TASK_SRMRECORD)
|
.WithOptional(e => e.BASE_CONTAINER)
|
.HasForeignKey(e => e.containerId);
|
|
modelBuilder.Entity<BASE_CONTAINER>()
|
.HasMany(e => e.TASK_TASK)
|
.WithOptional(e => e.BASE_CONTAINER)
|
.HasForeignKey(e => e.CONTAINERID);
|
|
modelBuilder.Entity<BASE_DEVICE>()
|
.HasMany(e => e.ALERT_ALERT)
|
.WithOptional(e => e.BASE_DEVICE)
|
.HasForeignKey(e => e.ALERTDEVICEID);
|
|
modelBuilder.Entity<BASE_INTYPE>()
|
.HasMany(e => e.BASE_CONTAINER_VS_ITEM)
|
.WithOptional(e => e.BASE_INTYPE)
|
.HasForeignKey(e => e.INTYPEID);
|
|
modelBuilder.Entity<BASE_ITEM>()
|
.HasMany(e => e.BASE_CONTAINER_VS_ITEM)
|
.WithOptional(e => e.BASE_ITEM)
|
.HasForeignKey(e => e.ITEMID);
|
|
modelBuilder.Entity<BASE_ITEM>()
|
.HasMany(e => e.ORDER_INORDER)
|
.WithOptional(e => e.BASE_ITEM)
|
.HasForeignKey(e => e.ITEMID);
|
|
modelBuilder.Entity<BASE_ITEM>()
|
.HasMany(e => e.ORDER_OUTORDER)
|
.WithOptional(e => e.BASE_ITEM)
|
.HasForeignKey(e => e.ITEMID);
|
|
modelBuilder.Entity<BASE_ITEM>()
|
.HasMany(e => e.TASK_RECORD)
|
.WithOptional(e => e.BASE_ITEM)
|
.HasForeignKey(e => e.ITEMID);
|
|
modelBuilder.Entity<BASE_ITEM>()
|
.HasMany(e => e.TASK_SRMRECORD)
|
.WithOptional(e => e.BASE_ITEM)
|
.HasForeignKey(e => e.itemId);
|
|
modelBuilder.Entity<BASE_PALLET>()
|
.HasMany(e => e.BASE_CONTAINER)
|
.WithOptional(e => e.BASE_PALLET)
|
.HasForeignKey(e => e.PALLETTYPEID);
|
|
modelBuilder.Entity<BASE_PLACE>()
|
.HasMany(e => e.BASE_PLACE_VS_CONTAINER)
|
.WithOptional(e => e.BASE_PLACE)
|
.HasForeignKey(e => e.PLACEID);
|
|
modelBuilder.Entity<BASE_PLACETYPE>()
|
.HasMany(e => e.BASE_PLACE)
|
.WithOptional(e => e.BASE_PLACETYPE)
|
.HasForeignKey(e => e.PLACETYPEID);
|
|
modelBuilder.Entity<BASE_PRODUCTIONLINE>()
|
.HasMany(e => e.ORDER_INORDER)
|
.WithOptional(e => e.BASE_PRODUCTIONLINE)
|
.HasForeignKey(e => e.CREATELINEID);
|
|
modelBuilder.Entity<BASE_PRODUCTIONLINE>()
|
.HasMany(e => e.ORDER_OUTORDER)
|
.WithOptional(e => e.BASE_PRODUCTIONLINE)
|
.HasForeignKey(e => e.TOLINEID);
|
|
modelBuilder.Entity<CAR_CARTASK>()
|
.HasMany(e => e.CAR_CAR)
|
.WithOptional(e => e.CAR_CARTASK)
|
.HasForeignKey(e => e.CARTASKID);
|
|
modelBuilder.Entity<ERP_EPRORDER>()
|
.HasMany(e => e.ORDER_OUTORDER)
|
.WithOptional(e => e.ERP_EPRORDER)
|
.HasForeignKey(e => e.ERPID);
|
|
modelBuilder.Entity<ORDER_INORDER>()
|
.HasMany(e => e.BASE_CONTAINER_VS_ITEM)
|
.WithOptional(e => e.ORDER_INORDER)
|
.HasForeignKey(e => e.INPLANID);
|
|
modelBuilder.Entity<ORDER_OUTORDER>()
|
.HasMany(e => e.BASE_CONTAINER_VS_ITEM)
|
.WithOptional(e => e.ORDER_OUTORDER)
|
.HasForeignKey(e => e.OUTPLANID);
|
|
modelBuilder.Entity<ORDER_OUTORDER>()
|
.HasMany(e => e.CAR_CARTASK)
|
.WithOptional(e => e.ORDER_OUTORDER)
|
.HasForeignKey(e => e.OUTORDERID);
|
|
modelBuilder.Entity<RgvTask>()
|
.HasMany(e => e.RgvTask1)
|
.WithOptional(e => e.PRERGVTASK)
|
.HasForeignKey(e => e.PRETASK);
|
|
modelBuilder.Entity<SYS_DEPT>()
|
.HasMany(e => e.SYS_USER)
|
.WithOptional(e => e.SYS_DEPT)
|
.HasForeignKey(e => e.DEPTID);
|
|
modelBuilder.Entity<SYS_PERMISSION>()
|
.HasMany(e => e.SYS_ROLE_VS_PERMISSION)
|
.WithRequired(e => e.SYS_PERMISSION)
|
.HasForeignKey(e => e.PERMISSIONID)
|
.WillCascadeOnDelete(false);
|
|
modelBuilder.Entity<SYS_ROLE>()
|
.HasMany(e => e.SYS_ROLE_VS_PERMISSION)
|
.WithRequired(e => e.SYS_ROLE)
|
.HasForeignKey(e => e.ROLEID)
|
.WillCascadeOnDelete(false);
|
|
modelBuilder.Entity<SYS_ROLE>()
|
.HasMany(e => e.SYS_USER_VS_ROLE)
|
.WithRequired(e => e.SYS_ROLE)
|
.HasForeignKey(e => e.ROLEID)
|
.WillCascadeOnDelete(false);
|
|
modelBuilder.Entity<SYS_USER>()
|
.HasMany(e => e.BASE_DESTINATION)
|
.WithOptional(e => e.SYS_USER)
|
.HasForeignKey(e => e.CREATOR);
|
|
modelBuilder.Entity<SYS_USER>()
|
.HasMany(e => e.CAR_CAR)
|
.WithOptional(e => e.SYS_USER)
|
.HasForeignKey(e => e.USERID);
|
|
modelBuilder.Entity<SYS_USER>()
|
.HasMany(e => e.CAR_CARTASK)
|
.WithOptional(e => e.SYS_USER)
|
.HasForeignKey(e => e.CREATORID);
|
|
modelBuilder.Entity<SYS_USER>()
|
.HasMany(e => e.ORDER_INORDER)
|
.WithOptional(e => e.SYS_USER)
|
.HasForeignKey(e => e.CREATORID);
|
|
modelBuilder.Entity<SYS_USER>()
|
.HasMany(e => e.ORDER_OUTORDER)
|
.WithOptional(e => e.SYS_USER)
|
.HasForeignKey(e => e.CREATORID);
|
|
modelBuilder.Entity<SYS_USER>()
|
.HasMany(e => e.SYS_ROLE)
|
.WithOptional(e => e.SYS_USER)
|
.HasForeignKey(e => e.CREATORID);
|
|
modelBuilder.Entity<SYS_USER>()
|
.HasMany(e => e.SYS_ROLE1)
|
.WithOptional(e => e.SYS_USER1)
|
.HasForeignKey(e => e.CREATORID);
|
|
modelBuilder.Entity<SYS_USER>()
|
.HasMany(e => e.SYS_USER1)
|
.WithOptional(e => e.SYS_USER2)
|
.HasForeignKey(e => e.CREATORID);
|
|
modelBuilder.Entity<SYS_USER>()
|
.HasMany(e => e.SYS_USER_VS_ROLE)
|
.WithRequired(e => e.SYS_USER)
|
.HasForeignKey(e => e.USERID)
|
.WillCascadeOnDelete(false);
|
|
modelBuilder.Entity<SYS_USER>()
|
.HasMany(e => e.TASK_TASK)
|
.WithOptional(e => e.SYS_USER)
|
.HasForeignKey(e => e.CREATEUSERID);
|
|
modelBuilder.Entity<TASK_TASK>()
|
.HasMany(e => e.RgvTask)
|
.WithRequired(e => e.TASK_TASK)
|
.HasForeignKey(e => e.FASTHERTASKID)
|
.WillCascadeOnDelete(false);
|
|
modelBuilder.Entity<TASK_TASK>()
|
.HasMany(e => e.SrmTask)
|
.WithRequired(e => e.TASK_TASK)
|
.HasForeignKey(e => e.FASTHERTASKID)
|
.WillCascadeOnDelete(false);
|
|
modelBuilder.Entity<TASK_TASK>()
|
.HasMany(e => e.TASK_RECORD)
|
.WithOptional(e => e.TASK_TASK)
|
.HasForeignKey(e => e.TASKID);
|
|
modelBuilder.Entity<TASK_TASK>()
|
.HasMany(e => e.TranTask)
|
.WithRequired(e => e.TASK_TASK)
|
.HasForeignKey(e => e.FASTHERTASKID)
|
.WillCascadeOnDelete(false);
|
|
modelBuilder.Entity<View_BASE_PLACE_VS_CONTAINER>()
|
.Property(e => e.isEmptyContainer)
|
.IsUnicode(false);
|
|
modelBuilder.Entity<View_BASE_PLACE_VS_CONTAINER>()
|
.Property(e => e.stStatus)
|
.IsUnicode(false);
|
|
modelBuilder.Entity<View_ITEMSTORAGE>()
|
.Property(e => e.storageName)
|
.IsUnicode(false);
|
|
modelBuilder.Entity<View_ITEMSTORAGE>()
|
.Property(e => e.totalCost)
|
.HasPrecision(29, 2);
|
|
modelBuilder.Entity<View_ITEMSTORAGE>()
|
.Property(e => e.isOverDay)
|
.IsUnicode(false);
|
|
modelBuilder.Entity<View_RGVTASK>()
|
.Property(e => e.taskType)
|
.IsUnicode(false);
|
|
modelBuilder.Entity<View_SRMTASK>()
|
.Property(e => e.taskType)
|
.IsUnicode(false);
|
}
|
}
|
}
|
