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 | 387 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 384 insertions(+), 3 deletions(-)
diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs
index b031650..85daed3 100644
--- a/zhengcaioa/Model/zhengcaioaContext.cs
+++ b/zhengcaioa/Model/zhengcaioaContext.cs
@@ -29,6 +29,7 @@
public virtual DbSet<AdmAskCiZhi> AdmAskCiZhis { get; set; }
public virtual DbSet<AdmAskcost> AdmAskcosts { get; set; }
public virtual DbSet<AdmAskGood> AdmAskGoods { get; set; }
+ public virtual DbSet<AdmGoodsRecord> AdmGoodsRecords { get; set; }
public virtual DbSet<AdmAskJiaojie> AdmAskJiaojies { get; set; }
public virtual DbSet<AdmAskJiaojieDtl> AdmAskJiaojieDtls { get; set; }
public virtual DbSet<AdmAskLeave> AdmAskLeaves { get; set; }
@@ -76,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; }
@@ -113,6 +115,11 @@
public virtual DbSet<Expert> Experts { get; set; }
public virtual DbSet<ExpertOrderDispatch> ExpertOrderDispatches { get; set; }
public virtual DbSet<ExpertPromote> ExpertPromotes { get; set; }
+ 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; }
@@ -418,6 +425,59 @@
entity.Property(e => e.Tittle)
.HasMaxLength(50)
.HasColumnName("tittle");
+ });
+
+ modelBuilder.Entity<AdmGoodsRecord>(entity =>
+ {
+ entity.ToTable("adm_goods_record");
+
+ 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.GoodsId)
+ .HasMaxLength(50)
+ .HasColumnName("goodsId");
+
+ entity.Property(e => e.GoodsLeft)
+ .HasColumnType("numeric(18, 2)")
+ .HasColumnName("goods_left");
+
+ entity.Property(e => e.GoodsNum)
+ .HasColumnType("numeric(18, 2)")
+ .HasColumnName("goods_num");
+
+ 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.OperationalMatters).HasMaxLength(500);
+
+ entity.Property(e => e.RecStatus)
+ .IsRequired()
+ .HasMaxLength(1)
+ .HasColumnName("rec_status")
+ .HasDefaultValueSql("('A')");
+
+ entity.Property(e => e.RecordTypeId).HasMaxLength(50);
+
+ entity.Property(e => e.Remark).HasMaxLength(500);
});
modelBuilder.Entity<AdmAskJiaojie>(entity =>
@@ -1779,6 +1839,10 @@
.HasMaxLength(500)
.HasColumnName("goods_name")
.HasComment("鐗╁搧鍚嶇О");
+
+ entity.Property(e => e.ISBN)
+ .HasMaxLength(500)
+ .HasColumnName("ISBN");
entity.Property(e => e.GoodsNum)
.HasColumnType("numeric(18, 2)")
@@ -3690,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");
@@ -5571,7 +5678,7 @@
entity.Property(e => e.Comments)
.IsRequired()
- .HasMaxLength(50)
+ .HasMaxLength(100)
.HasColumnName("comments");
entity.Property(e => e.Contents)
@@ -6178,7 +6285,6 @@
.HasColumnName("expertType");
entity.Property(e => e.IdCard)
- .IsRequired()
.HasMaxLength(18)
.HasColumnName("idCard");
@@ -6230,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");
@@ -6237,7 +6347,6 @@
entity.Property(e => e.ReviewItem).HasMaxLength(50);
entity.Property(e => e.Sex)
- .IsRequired()
.HasMaxLength(50)
.HasColumnName("sex");
@@ -6383,6 +6492,278 @@
.IsUnicode(false)
.HasColumnName("sort");
});
+
+ modelBuilder.Entity<ExpertTestTopic>(entity =>
+ {
+ entity.ToTable("expert_test_topic");
+
+ entity.Property(e => e.Id).HasMaxLength(50);
+
+ entity.Property(e => e.Area)
+ .HasMaxLength(50)
+ .HasColumnName("area");
+
+ 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.Jiexi)
+ .HasMaxLength(4000)
+ .HasColumnName("jiexi");
+
+ entity.Property(e => e.JiexiStatus)
+ .HasMaxLength(1)
+ .HasColumnName("jiexi_status")
+ .HasDefaultValueSql("('D')");
+
+ 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.ShenpiStatus)
+ .HasMaxLength(1)
+ .HasColumnName("shenpi_status")
+ .HasDefaultValueSql("('D')");
+
+ entity.Property(e => e.Topic)
+ .HasMaxLength(4000)
+ .HasColumnName("topic");
+
+ entity.Property(e => e.Topictype)
+ .HasMaxLength(50)
+ .HasColumnName("topictype");
+
+ entity.Property(e => e.Zhishitype)
+ .HasMaxLength(50)
+ .HasColumnName("zhishitype");
+
+ entity.Property(e => e.Zhongdian)
+ .HasMaxLength(1)
+ .HasColumnName("zhongdian");
+ });
+
+ modelBuilder.Entity<ExpertTestTopicanwser>(entity =>
+ {
+ entity.ToTable("expert_test_topicanwser");
+
+ entity.Property(e => e.Id).HasMaxLength(50);
+
+ entity.Property(e => e.Anwser)
+ .HasMaxLength(500)
+ .HasColumnName("anwser");
+
+ entity.Property(e => e.Anwserno)
+ .HasMaxLength(50)
+ .HasColumnName("anwserno");
+
+ 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.Shifouzhengqu)
+ .HasMaxLength(1)
+ .HasColumnName("shifouzhengqu")
+ .HasDefaultValueSql("('D')");
+
+ entity.Property(e => e.Topic)
+ .HasMaxLength(50)
+ .HasColumnName("topic");
+ });
+
+ modelBuilder.Entity<ExpertTestTopicjiexi>(entity =>
+ {
+ entity.ToTable("expert_test_topicjiexi");
+
+ 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.Falv)
+ .HasMaxLength(50)
+ .HasColumnName("falv");
+
+ entity.Property(e => e.Flag)
+ .HasMaxLength(1)
+ .HasColumnName("flag");
+
+ entity.Property(e => e.Fatiao)
+ .HasMaxLength(500)
+ .HasColumnName("fatiao");
+
+ entity.Property(e => e.Jiexi)
+ .HasMaxLength(4000)
+ .HasColumnName("jiexi");
+
+ 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.Topic)
+ .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