From ef80d35cdbabf2ac5fd83f84714b4254e6444fef Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期二, 28 九月 2021 14:22:27 +0800 Subject: [PATCH] 通讯录,账号密码 --- zhengcaioa/Model/zhengcaioaContext.cs | 350 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 349 insertions(+), 1 deletions(-) diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index 7cc84d4..b031650 100644 --- a/zhengcaioa/Model/zhengcaioaContext.cs +++ b/zhengcaioa/Model/zhengcaioaContext.cs @@ -26,8 +26,11 @@ public virtual DbSet<AdmAskBaiFang> AdmAskBaiFangs { get; set; } public virtual DbSet<AdmAskCar> AdmAskCars { get; set; } + public virtual DbSet<AdmAskCiZhi> AdmAskCiZhis { get; set; } public virtual DbSet<AdmAskcost> AdmAskcosts { get; set; } public virtual DbSet<AdmAskGood> AdmAskGoods { get; set; } + public virtual DbSet<AdmAskJiaojie> AdmAskJiaojies { get; set; } + public virtual DbSet<AdmAskJiaojieDtl> AdmAskJiaojieDtls { get; set; } public virtual DbSet<AdmAskLeave> AdmAskLeaves { get; set; } public virtual DbSet<AdmAskLeaveOff> AdmAskLeaveOffs { get; set; } public virtual DbSet<AdmAskMarketingCost> AdmAskMarketingCosts { get; set; } @@ -48,6 +51,8 @@ public virtual DbSet<AdmGoodsClassify> AdmGoodsClassifies { get; set; } public virtual DbSet<AdmGoodsManage> AdmGoodsManages { get; set; } public virtual DbSet<AdmPieceCheck> AdmPieceChecks { get; set; } + public virtual DbSet<AdmTongxunlu> AdmTongxunlus { get; set; } + public virtual DbSet<AdmZhanghaomima> AdmZhanghaomimas { get; set; } public virtual DbSet<Area> Areas { get; set; } public virtual DbSet<Cgf> Cgfs { get; set; } public virtual DbSet<CooperOrder> CooperOrders { get; set; } @@ -94,6 +99,7 @@ public virtual DbSet<Projectyouxiao> Projectyouxiaos { get; set; } public virtual DbSet<Projectzhongbiao> Projectzhongbiaos { get; set; } public virtual DbSet<SysAttachment> SysAttachments { get; set; } + public virtual DbSet<SysBaimingdan> SysBaimingdans { get; set; } public virtual DbSet<SysCode> SysCodes { get; set; } public virtual DbSet<SysCodeDtl> SysCodeDtls { get; set; } public virtual DbSet<Systemsetting> Systemsettings { get; set; } @@ -240,6 +246,70 @@ .HasColumnName("tittle"); }); + modelBuilder.Entity<AdmAskCiZhi>(entity => + { + entity.ToTable("ADM_AskCiZhi"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.CreaterName) + .HasMaxLength(50) + .HasColumnName("createrName"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.CreatetimeName).HasMaxLength(50); + + entity.Property(e => e.DeptName).HasMaxLength(50); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.OrderType).HasMaxLength(50); + + entity.Property(e => e.Outtime).HasColumnType("datetime"); + + entity.Property(e => e.PostName).HasMaxLength(50); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Remark).HasMaxLength(2000); + + entity.Property(e => e.RuzhitimeName).HasMaxLength(50); + + entity.Property(e => e.JiaojieUser).HasMaxLength(500); + + entity.Property(e => e.ShenpiStatus) + .HasMaxLength(1) + .HasColumnName("shenpi_status") + .HasDefaultValueSql("('D')"); + + entity.Property(e => e.Tittle) + .HasMaxLength(50) + .HasColumnName("tittle"); + }); + modelBuilder.Entity<AdmAskcost>(entity => { entity.ToTable("ADM_Askcost"); @@ -348,6 +418,112 @@ entity.Property(e => e.Tittle) .HasMaxLength(50) .HasColumnName("tittle"); + }); + + modelBuilder.Entity<AdmAskJiaojie>(entity => + { + entity.ToTable("ADM_AskJiaojie"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.CiZhiId).HasMaxLength(50); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.CreaterName) + .HasMaxLength(50) + .HasColumnName("createrName"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Remark).HasMaxLength(500); + + entity.Property(e => e.ShenpiStatus) + .HasMaxLength(1) + .HasColumnName("shenpi_status") + .HasDefaultValueSql("('D')"); + + entity.Property(e => e.Tittle) + .HasMaxLength(50) + .HasColumnName("tittle"); + }); + + modelBuilder.Entity<AdmAskJiaojieDtl>(entity => + { + entity.ToTable("ADM_AskJiaojieDtl"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.JiaojieId).HasMaxLength(50); + + entity.Property(e => e.JiaojieNeirong).HasMaxLength(500); + + entity.Property(e => e.JiaojieStatus) + .HasMaxLength(1) + .HasColumnName("jiaojie_status") + .HasDefaultValueSql("('D')"); + + entity.Property(e => e.JiaojieType).HasMaxLength(50); + + entity.Property(e => e.JiaojieUserId).HasMaxLength(50); + + entity.Property(e => e.Jiaojietime).HasColumnType("datetime"); + + entity.Property(e => e.JieShoutime).HasColumnType("datetime"); + + entity.Property(e => e.Kehudanwei).HasMaxLength(500); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); }); modelBuilder.Entity<AdmAskLeave>(entity => @@ -1114,6 +1290,12 @@ entity.Property(e => e.HuiyuanPhone).HasMaxLength(50); + entity.Property(e => e.BankAcount).HasMaxLength(50); + + entity.Property(e => e.BankName).HasMaxLength(50); + + entity.Property(e => e.Username).HasMaxLength(50); + entity.Property(e => e.Jine) .HasColumnType("money") .HasDefaultValueSql("((0))"); @@ -1614,6 +1796,11 @@ .HasDefaultValueSql("('A')") .HasComment("鐗╁搧鐘舵��"); + entity.Property(e => e.HaocaiStatus) + .HasMaxLength(1) + .HasColumnName("haocai_status") + .HasDefaultValueSql("('D')"); + entity.Property(e => e.Modifier) .IsRequired() .HasMaxLength(50) @@ -1705,6 +1892,116 @@ .HasColumnName("work_time") .HasDefaultValueSql("(getdate())") .HasComment("宸ヤ綔鏃堕棿"); + }); + + modelBuilder.Entity<AdmTongxunlu>(entity => + { + entity.ToTable("adm_tongxunlu"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Beuzhu) + .HasMaxLength(500) + .HasColumnName("beuzhu"); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.DanweiName) + .HasMaxLength(100) + .HasColumnName("danwei_name"); + + entity.Property(e => e.Lianxidianhua) + .HasMaxLength(100) + .HasColumnName("lianxidianhua"); + + entity.Property(e => e.Lianxiren) + .HasMaxLength(100) + .HasColumnName("lianxiren"); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.TypeId) + .HasMaxLength(50) + .HasColumnName("type_id"); + }); + + modelBuilder.Entity<AdmZhanghaomima>(entity => + { + entity.ToTable("adm_zhanghaomima"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Chanpinxiangmu) + .HasMaxLength(100) + .HasColumnName("chanpinxiangmu"); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.Mibao) + .HasMaxLength(100) + .HasColumnName("mibao"); + + entity.Property(e => e.Mima) + .HasMaxLength(100) + .HasColumnName("mima"); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.TypeId) + .HasMaxLength(50) + .HasColumnName("type_id"); + + entity.Property(e => e.Zhanghao) + .HasMaxLength(100) + .HasColumnName("zhanghao"); }); modelBuilder.Entity<Area>(entity => @@ -3884,7 +4181,7 @@ .HasColumnName("shenhetime"); entity.Property(e => e.Shiyongfatiao) - .HasMaxLength(500) + .HasMaxLength(1000) .HasColumnName("shiyongfatiao"); }); modelBuilder.Entity<LiaotianShoucang>(entity => @@ -4926,6 +5223,10 @@ .HasColumnType("money") .HasColumnName("drhx_defen"); + entity.Property(e => e.Caigouyusuan) + .HasColumnType("money") + .HasColumnName("caigouyusuan"); + entity.Property(e => e.DrhxPrice) .HasMaxLength(500) .HasColumnName("drhx_price"); @@ -5141,6 +5442,53 @@ .HasDefaultValueSql("('A')"); }); + modelBuilder.Entity<SysBaimingdan>(entity => + { + entity.ToTable("sys_baimingdan"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.BaimingdanName) + .HasMaxLength(200) + .HasColumnName("baimingdan_name"); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.PostSeq) + .HasMaxLength(50) + .HasColumnName("post_seq"); + + entity.Property(e => e.PostType) + .HasMaxLength(50) + .HasColumnName("post_type"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + }); + modelBuilder.Entity<SysCode>(entity => { entity.ToTable("sys_code"); -- Gitblit v1.9.1