提交

PC-201906131823\Administrator

2021-11-10 d66cbfe2dec69d08f9905b320851eb11d09567bc

 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; }
@@ -51,6 +52,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; }
@@ -74,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; }
@@ -97,6 +101,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; }
@@ -110,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; }
@@ -415,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 =>
@@ -1777,6 +1840,10 @@
                    .HasColumnName("goods_name")
                    .HasComment("物品名称");

                entity.Property(e => e.ISBN)
                  .HasMaxLength(500)
                  .HasColumnName("ISBN");

                entity.Property(e => e.GoodsNum)
                    .HasColumnType("numeric(18, 2)")
                    .HasColumnName("goods_num")
@@ -1889,6 +1956,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 =>
@@ -3575,6 +3752,49 @@
                entity.Property(e => e.Yufagongziheji)
                    .HasColumnType("decimal(18, 4)")
                    .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 =>
@@ -5329,6 +5549,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");
@@ -6223,6 +6490,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 =>
            {