From 402f9568e48e6e1a9d29d37dcda46737047425d5 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期四, 25 十一月 2021 10:49:10 +0800 Subject: [PATCH] 专家通讯录优化 --- zhengcaioa/Model/zhengcaioaContext.cs | 153 ++++++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 150 insertions(+), 3 deletions(-) diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index e07f6f2..85daed3 100644 --- a/zhengcaioa/Model/zhengcaioaContext.cs +++ b/zhengcaioa/Model/zhengcaioaContext.cs @@ -77,6 +77,7 @@ public virtual DbSet<HrJixiaoticheng> HrJixiaotichengs { get; set; } public virtual DbSet<HrPosition> HrPositions { get; set; } public virtual DbSet<HrSalary> HrSalaries { get; set; } + public virtual DbSet<HrShebao> HrShebaos { get; set; } public virtual DbSet<IntentionCustomer> IntentionCustomers { get; set; } public virtual DbSet<IntentionOrder> IntentionOrders { get; set; } public virtual DbSet<IntentionVisit> IntentionVisits { get; set; } @@ -117,6 +118,8 @@ public virtual DbSet<ExpertTestTopic> ExpertTestTopics { get; set; } public virtual DbSet<ExpertTestTopicanwser> ExpertTestTopicanwsers { get; set; } public virtual DbSet<ExpertTestTopicjiexi> ExpertTestTopicjiexis { get; set; } + public virtual DbSet<ExpertTestResult> ExpertTestResults { get; set; } + public virtual DbSet<ExpertTestTopicpeizhi> ExpertTestTopicpeizhis { get; set; } #region 琛屾斂绠$悊 public virtual DbSet<AskLeave> AskLeaves { get; set; } @@ -3751,6 +3754,49 @@ .HasColumnName("yufagongziheji"); }); + modelBuilder.Entity<HrShebao>(entity => + { + entity.ToTable("hr_shebao"); + + 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.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.Shebaodanwei) + .HasColumnType("money") + .HasColumnName("shebaodanwei"); + + entity.Property(e => e.Shebaogeren) + .HasColumnType("money") + .HasColumnName("shebaogeren"); + }); + modelBuilder.Entity<IntentionCustomer>(entity => { entity.ToTable("IntentionCustomer"); @@ -5632,7 +5678,7 @@ entity.Property(e => e.Comments) .IsRequired() - .HasMaxLength(50) + .HasMaxLength(100) .HasColumnName("comments"); entity.Property(e => e.Contents) @@ -6239,7 +6285,6 @@ .HasColumnName("expertType"); entity.Property(e => e.IdCard) - .IsRequired() .HasMaxLength(18) .HasColumnName("idCard"); @@ -6291,6 +6336,10 @@ .HasMaxLength(1) .HasColumnName("rec_status"); + entity.Property(e => e.YearJiou) + .HasMaxLength(1) + .HasColumnName("year_jiou"); + entity.Property(e => e.Remark) .HasMaxLength(1000) .HasColumnName("remark"); @@ -6298,7 +6347,6 @@ entity.Property(e => e.ReviewItem).HasMaxLength(50); entity.Property(e => e.Sex) - .IsRequired() .HasMaxLength(50) .HasColumnName("sex"); @@ -6466,6 +6514,10 @@ .HasColumnName("createtime") .HasDefaultValueSql("(getdate())"); + entity.Property(e => e.Jiexi) + .HasMaxLength(4000) + .HasColumnName("jiexi"); + entity.Property(e => e.JiexiStatus) .HasMaxLength(1) .HasColumnName("jiexi_status") @@ -6616,6 +6668,101 @@ .HasMaxLength(50) .HasColumnName("topic"); }); + modelBuilder.Entity<ExpertTestResult>(entity => + { + entity.ToTable("expert_test_result"); + + 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.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.Result) + .HasMaxLength(100) + .HasColumnName("result"); + + entity.Property(e => e.Resulttype) + .HasMaxLength(50) + .HasColumnName("resulttype"); + }); + + modelBuilder.Entity<ExpertTestTopicpeizhi>(entity => + { + entity.ToTable("expert_test_topicpeizhi"); + + 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.Fenshu) + .HasColumnType("numeric(18, 4)") + .HasColumnName("fenshu"); + + entity.Property(e => e.Fenzhi) + .HasColumnType("numeric(18, 4)") + .HasColumnName("fenzhi"); + + 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.ShijianId).HasMaxLength(50); + + entity.Property(e => e.Topictype) + .HasMaxLength(50) + .HasColumnName("topictype"); + + entity.Property(e => e.Zhishitype) + .HasMaxLength(50) + .HasColumnName("zhishitype"); + }); #region 琛屾斂绠$悊瀹炰綋绫� modelBuilder.Entity<SignIn>(entity => -- Gitblit v1.9.1