From 6672a68f11621bc7a49265fc47d4c1e7ae4c060d Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期三, 13 十月 2021 15:45:17 +0800 Subject: [PATCH] 专家测试--题库管理 完成 --- zhengcaioa/Model/zhengcaioaContext.cs | 234 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 234 insertions(+), 0 deletions(-) diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index b031650..e07f6f2 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; } @@ -113,6 +114,9 @@ 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; } #region 琛屾斂绠$悊 public virtual DbSet<AskLeave> AskLeaves { get; set; } @@ -418,6 +422,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 +1836,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)") @@ -6383,6 +6444,179 @@ .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.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"); + }); + #region 琛屾斂绠$悊瀹炰綋绫� modelBuilder.Entity<SignIn>(entity => { -- Gitblit v1.9.1