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