专家通讯录优化

username@email.com

2021-11-25 402f9568e48e6e1a9d29d37dcda46737047425d5

 zhengcaioa/Model/zhengcaioaContext.cs

@@ -24,14 +24,25 @@
        public virtual DbSet<HrSalaryAppeal> HrSalaryAppeal { get; set; }
        public virtual DbSet<SimCostYearView> SimCostYearView { get; set; }


        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<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; }
        public virtual DbSet<AdmAskLeaveOff> AdmAskLeaveOffs { get; set; }
        public virtual DbSet<AdmAskMarketingCost> AdmAskMarketingCosts { get; set; }
        public virtual DbSet<AdmAskovertime> AdmAskovertimes { get; set; }
        public virtual DbSet<AdmAskYouHui> AdmAskYouHuis { get; set; }
        public virtual DbSet<AdmAttendance> AdmAttendances { get; set; }
        public virtual DbSet<AdmAttendanceDtl> AdmAttendanceDtls { get; set; }
        public virtual DbSet<AdmAttendanceRule> AdmAttendanceRules { get; set; }
        public virtual DbSet<AdmAttendanceRulesDtl> AdmAttendanceRulesDtls { get; set; }
        public virtual DbSet<AdmBreakPrecedent> AdmBreakPrecedents { get; set; }
        public virtual DbSet<AdmCustomerWithdrawal> AdmCustomerWithdrawals { get; set; }
        public virtual DbSet<AdmHoldPhone> AdmHoldPhones { get; set; }
        public virtual DbSet<AdmMemoBook> AdmMemoBooks { get; set; }
        public virtual DbSet<AdmSignIn> AdmSignIns { get; set; }
@@ -41,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; }
@@ -64,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; }
@@ -87,9 +101,11 @@
        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; }
        public virtual DbSet<SysUpdatetime> SysUpdatetimes { get; set; }
        public virtual DbSet<WfApplytype> WfApplytypes { get; set; }
        public virtual DbSet<WfHistory> WfHistories { get; set; }
        public virtual DbSet<WfLog> WfLogs { get; set; }
@@ -99,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; }
@@ -117,6 +138,454 @@
        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.HasAnnotation("Relational:Collation", "Chinese_PRC_CI_AS");

            modelBuilder.Entity<AdmAskBaiFang>(entity =>
            {
                entity.ToTable("ADM_AskBaiFang");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.BaiFangtime).HasColumnType("datetime");

                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.CustomerId).HasMaxLength(500);

                entity.Property(e => e.Jtype).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.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");

                entity.Property(e => e.VisType).HasMaxLength(50);
            });

            modelBuilder.Entity<AdmAskCar>(entity =>
            {
                entity.ToTable("ADM_AskCar");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.CarLaiyuan).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.Feiyong)
                    .HasColumnType("money")
                    .HasDefaultValueSql("((0))");

                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<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");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Cost)
                    .HasColumnType("money")
                    .HasDefaultValueSql("((0))");

                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<AdmAskGood>(entity =>
            {
                entity.ToTable("ADM_AskGoods");

                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.GoodsId).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.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.Shuliang)
                    .HasColumnType("money")
                    .HasDefaultValueSql("((0))");

                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 =>
            {
                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 =>
            {
                entity.ToTable("ADM_AskLeave");
@@ -249,6 +718,185 @@
                entity.Property(e => e.Tittle)
                    .HasMaxLength(100)
                    .HasColumnName("tittle");
            });

            modelBuilder.Entity<AdmAskovertime>(entity =>
            {
                entity.ToTable("ADM_Askovertime");

                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.Jiabantime)
                    .HasColumnType("datetime")
                    .HasColumnName("jiabantime");

                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.Overtime)
                    .HasColumnType("money")
                    .HasColumnName("overtime")
                    .HasDefaultValueSql("((0))");

                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<AdmAskYouHui>(entity =>
            {
                entity.ToTable("ADM_AskYouHui");

                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.CustomerId).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.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");

                entity.Property(e => e.YouHui)
                    .HasColumnType("money")
                    .HasDefaultValueSql("((0))");

                entity.Property(e => e.Youhuistandard).HasMaxLength(50);
            });

            modelBuilder.Entity<AdmAskMarketingCost>(entity =>
            {
                entity.ToTable("ADM_AskMarketingCost");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.BreakPrecedentId)
                    .HasMaxLength(50)
                    .HasColumnName("break_precedentId");

                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.Feiyong)
                    .HasColumnType("money")
                    .HasDefaultValueSql("((0))");

                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");

                entity.Property(e => e.ToUserId).HasMaxLength(50);
            });

            modelBuilder.Entity<AdmAttendance>(entity =>
@@ -673,6 +1321,78 @@
                    .HasMaxLength(50)
                    .HasColumnName("userId")
                    .HasComment("员工");
            });

            modelBuilder.Entity<AdmCustomerWithdrawal>(entity =>
            {
                entity.ToTable("ADM_Customer_withdrawal");

                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.HuiyuanId).HasMaxLength(50);

                entity.Property(e => e.HuiyuanName).HasMaxLength(100);

                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))");

                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.OrderNo).HasMaxLength(50);

                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.Shenqingtime)
                    .HasColumnType("datetime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Tittle)
                    .HasMaxLength(50)
                    .HasColumnName("tittle");
            });

            modelBuilder.Entity<AdmHoldPhone>(entity =>
@@ -1120,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")
@@ -1135,6 +1859,11 @@
                    .HasColumnName("goods_status")
                    .HasDefaultValueSql("('A')")
                    .HasComment("物品状态");

                entity.Property(e => e.HaocaiStatus)
                   .HasMaxLength(1)
                   .HasColumnName("haocai_status")
                   .HasDefaultValueSql("('D')");

                entity.Property(e => e.Modifier)
                    .IsRequired()
@@ -1208,6 +1937,10 @@
                    .HasColumnName("remark")
                    .HasComment("工作内容");

                entity.Property(e => e.Shuliang)
                    .HasColumnType("money")
                    .HasColumnName("shuliang");

                entity.Property(e => e.UserId)
                    .HasMaxLength(50)
                    .HasColumnName("userId")
@@ -1223,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 =>
@@ -1637,6 +2480,11 @@
                    .HasColumnName("f_tel")
                    .HasComment("联系电话");

                entity.Property(e => e.HuiyuanId)
                    .HasMaxLength(50)
                    .HasColumnName("huiyuanId")
                    .HasComment("会员Id");

                entity.Property(e => e.Hyfl)
                    .HasMaxLength(50)
                    .HasColumnName("hyfl")
@@ -1741,6 +2589,14 @@
                entity.Property(e => e.Weixin)
                    .HasMaxLength(50)
                    .HasColumnName("weixin");

                entity.Property(e => e.Weixiner)
                    .HasMaxLength(50)
                    .HasColumnName("weixiner");

                entity.Property(e => e.Weixintime)
                    .HasColumnType("datetime")
                    .HasColumnName("weixintime");

                entity.Property(e => e.YwName)
                    .HasMaxLength(500)
@@ -2898,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");
@@ -3065,6 +3964,14 @@
                entity.Property(e => e.Weixin)
                    .HasMaxLength(50)
                    .HasColumnName("weixin");

                entity.Property(e => e.Weixiner)
                    .HasMaxLength(50)
                    .HasColumnName("weixiner");

                entity.Property(e => e.Weixintime)
                    .HasColumnType("datetime")
                    .HasColumnName("weixintime");

                entity.Property(e => e.Yixiang).HasMaxLength(50);

@@ -3322,13 +4229,14 @@
                    .HasColumnName("anwser");

                entity.Property(e => e.ChushuStatus)
                   .HasMaxLength(1)
                   .HasColumnName("chushu_status")
                   .HasDefaultValueSql("('D')");
                    .HasMaxLength(1)
                    .HasColumnName("chushu_status")
                    .HasDefaultValueSql("('D')");

                entity.Property(e => e.Clientid)
                    .HasMaxLength(50)
                    .HasColumnName("clientid");
                    .HasColumnName("clientid")
                    .HasDefaultValueSql("('a')");

                entity.Property(e => e.Creater)
                    .IsRequired()
@@ -3371,11 +4279,18 @@
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('a')");

                entity.Property(e => e.Shenheer)
                    .HasMaxLength(50)
                    .HasColumnName("shenheer");

                entity.Property(e => e.Shenhetime)
                    .HasColumnType("datetime")
                    .HasColumnName("shenhetime");

                entity.Property(e => e.Shiyongfatiao)
                    .HasMaxLength(500)
                    .HasMaxLength(1000)
                    .HasColumnName("shiyongfatiao");
            });

            modelBuilder.Entity<LiaotianShoucang>(entity =>
            {
                entity.ToTable("Liaotian_shoucang");
@@ -4228,6 +5143,10 @@

                entity.Property(e => e.Weixin).HasMaxLength(50);

                entity.Property(e => e.Yaoqingma)
                  .HasMaxLength(50)
                  .HasColumnName("yaoqingma");

                entity.Property(e => e.Zhengzhi).HasMaxLength(50);

                entity.Property(e => e.Zhiwustatus)
@@ -4410,6 +5329,10 @@
                entity.Property(e => e.DrhxDefen)
                    .HasColumnType("money")
                    .HasColumnName("drhx_defen");

                entity.Property(e => e.Caigouyusuan)
                   .HasColumnType("money")
                   .HasColumnName("caigouyusuan");

                entity.Property(e => e.DrhxPrice)
                    .HasMaxLength(500)
@@ -4626,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");
@@ -4708,7 +5678,7 @@

                entity.Property(e => e.Comments)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasMaxLength(100)
                    .HasColumnName("comments");

                entity.Property(e => e.Contents)
@@ -4862,6 +5832,23 @@
                    .HasColumnName("wedding_leave")
                    .HasComment("婚假天数");
            });

            modelBuilder.Entity<SysUpdatetime>(entity =>
            {
                entity.ToTable("sys_updatetime");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Updatename)
                    .IsRequired()
                    .HasMaxLength(100)
                    .HasColumnName("updatename");

                entity.Property(e => e.Updatetime)
                    .HasColumnType("datetime")
                    .HasColumnName("updatetime");
            });

            modelBuilder.Entity<WfApplytype>(entity =>
            {
                entity.ToTable("wf_applytype");
@@ -5298,7 +6285,6 @@
                    .HasColumnName("expertType");

                entity.Property(e => e.IdCard)
                    .IsRequired()
                    .HasMaxLength(18)
                    .HasColumnName("idCard");

@@ -5350,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");
@@ -5357,7 +6347,6 @@
                entity.Property(e => e.ReviewItem).HasMaxLength(50);

                entity.Property(e => e.Sex)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("sex");

@@ -5503,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 =>
            {