username@email.com
2023-11-02 558dae4a18d393ac38daa43a354e8bc9a22e4e26
zhengcaioa/Model/zhengcaioaContext.cs
@@ -10,6 +10,7 @@
    {
        public zhengcaioaContext()
        {
            this.Database.SetCommandTimeout(60);
        }
        public zhengcaioaContext(DbContextOptions<zhengcaioaContext> options)
@@ -26,13 +27,19 @@
        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<AdmAskzczbwsy> AdmAskzczbwsies { get; set; }
        public virtual DbSet<AdmAskzczbwsydtl> AdmAskzczbwsydtls { get; set; }
        public virtual DbSet<AdmAttendance> AdmAttendances { get; set; }
        public virtual DbSet<AdmAttendanceDtl> AdmAttendanceDtls { get; set; }
        public virtual DbSet<AdmAttendanceRule> AdmAttendanceRules { get; set; }
@@ -45,17 +52,24 @@
        public virtual DbSet<AdmDocBase> AdmDocBases { get; set; }
        public virtual DbSet<AdmDocDoc> AdmDocDocs { get; set; }
        public virtual DbSet<AdmEvaluate> AdmEvaluates { get; set; }
        public virtual DbSet<AdmPhoneMessage> AdmPhoneMessages { get; set; }
        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; }
        public virtual DbSet<CooperVisit> CooperVisits { get; set; }
        public virtual DbSet<CooperatecustomCustomer> CooperatecustomCustomers { get; set; }
        public virtual DbSet<CustomerYwjl> CustomerYwjls { get; set; }
        public virtual DbSet<CustomerGuanlianhuiyuan> CustomerGuanlianhuiyuans { get; set; }
        public virtual DbSet<CustomerGuanlian> CustomerGuanlians { get; set; }
        public virtual DbSet<CusFangwenjilu> CusFangwenjilus { get; set; }
        public virtual DbSet<FiAccount> FiAccounts { get; set; }
        public virtual DbSet<FiAccountRecord> FiAccountRecords { get; set; }
        public virtual DbSet<FiCustomerrecievemoney> FiCustomerrecievemoneys { get; set; }
        public virtual DbSet<FiOrderrecievemoney> FiOrderrecievemoneys { get; set; }
        public virtual DbSet<FiPiecerate> FiPiecerates { get; set; }
        public virtual DbSet<FiSubject> FiSubjects { get; set; }
@@ -71,6 +85,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; }
@@ -82,6 +97,7 @@
        public virtual DbSet<OrderBanci> OrderBancis { get; set; }
        public virtual DbSet<OrderBanciDtl> OrderBanciDtls { get; set; }
        public virtual DbSet<OrderBanciOrder> OrderBanciOrders { get; set; }
        public virtual DbSet<OrderBanciZuowei> OrderBanciZuoweis { get; set; }
        public virtual DbSet<PltAuth> PltAuths { get; set; }
        public virtual DbSet<PltPage> PltPages { get; set; }
        public virtual DbSet<PltRole> PltRoles { get; set; }
@@ -93,7 +109,9 @@
        public virtual DbSet<Projectreason> Projectreasons { get; set; }
        public virtual DbSet<Projectyouxiao> Projectyouxiaos { get; set; }
        public virtual DbSet<Projectzhongbiao> Projectzhongbiaos { get; set; }
        public virtual DbSet<Projectfasongxiaoxi> Projectfasongxiaoxis { 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; }
@@ -107,18 +125,38 @@
        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; }
        public virtual DbSet<AskLeaveOff> AskLeaveOffs { get; set; }
        public virtual DbSet<SignIn> SignIns { get; set; }
        #endregion
        public virtual DbSet<TChallengeItem> TChallengeItems { get; set; }
        public virtual DbSet<TChallengeletter> TChallengeletters { get; set; }
        public virtual DbSet<TChallengeRequestInfo> TChallengeRequestInfos { get; set; }
        public virtual DbSet<TComplaintItem> TComplaintItems { get; set; }
        public virtual DbSet<TComplaintRespondent> TComplaintRespondents { get; set; }
        public virtual DbSet<TComplaintletter> TComplaintletters { get; set; }
        public virtual DbSet<TComplaintGongyingshang> TComplaintGongyingshangs { get; set; }
        public virtual DbSet<TComplaintShouquandaibiao> TComplaintShouquandaibiaos { get; set; }
        public virtual DbSet<Zxdsfxl> Zxdsfxls { get; set; }
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            if (!optionsBuilder.IsConfigured)
            {
#warning To protect potentially sensitive information in your connection string, you should move it out of source code. You can avoid scaffolding the connection string by using the Name= syntax to read it from configuration - see https://go.microsoft.com/fwlink/?linkid=2131148. For more guidance on storing connection strings, see http://go.microsoft.com/fwlink/?LinkId=723263.
                optionsBuilder.UseSqlServer("Data Source=.;Initial Catalog=zhengcaioa;User ID=sa;Password=123456");
                optionsBuilder.UseSqlServer("Data Source=172.26.97.147;Initial Catalog=zhengcaioa;User ID=sa;Password=Za20222812");
            }
        }
@@ -240,6 +278,70 @@
                    .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");
@@ -348,6 +450,165 @@
                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 =>
@@ -603,6 +864,81 @@
                entity.Property(e => e.Youhuistandard).HasMaxLength(50);
            });
            modelBuilder.Entity<AdmAskzczbwsy>(entity =>
            {
                entity.ToTable("ADM_Askzczbwsy");
                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.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.Shiyongstandard)
                    .HasMaxLength(50)
                    .HasColumnName("shiyongstandard");
                entity.Property(e => e.Tittle)
                    .HasMaxLength(50)
                    .HasColumnName("tittle");
            });
            modelBuilder.Entity<AdmAskzczbwsydtl>(entity =>
            {
                entity.ToTable("ADM_Askzczbwsydtl");
                entity.Property(e => e.Id).HasMaxLength(50);
                entity.Property(e => e.AskzczbwsyId)
                    .IsRequired()
                    .HasMaxLength(50);
                entity.Property(e => e.CustomerId).HasMaxLength(50);
                entity.Property(e => e.Customertype).HasMaxLength(50);
                entity.Property(e => e.Customername).HasMaxLength(500);
                entity.Property(e => e.Phone)
                    .HasMaxLength(500)
                    .HasColumnName("phone");
            });
            modelBuilder.Entity<AdmAskMarketingCost>(entity =>
            {
                entity.ToTable("ADM_AskMarketingCost");
@@ -697,6 +1033,11 @@
                entity.Property(e => e.Kuanggong)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("kuanggong");
                entity.Property(e => e.Daixinjia)
                  .HasColumnType("decimal(18, 4)")
                  .HasColumnName("daixinjia")
                  .HasDefaultValueSql("(0)");
                entity.Property(e => e.Modifier)
                    .IsRequired()
@@ -804,6 +1145,11 @@
                entity.Property(e => e.Qingjia)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("qingjia");
                entity.Property(e => e.Daixinjia)
                 .HasColumnType("decimal(18, 4)")
                 .HasColumnName("daixinjia")
                 .HasDefaultValueSql("(0)");
                entity.Property(e => e.RecStatus)
                    .IsRequired()
@@ -1526,6 +1872,22 @@
                    .HasComment("人员id");
            });
            modelBuilder.Entity<AdmPhoneMessage>(entity =>
            {
                entity.ToTable("ADM_PhoneMessage");
                entity.Property(e => e.Id).HasMaxLength(50);
                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");
                entity.Property(e => e.Phone).HasMaxLength(50);
                entity.Property(e => e.Message).HasColumnName("message").HasMaxLength(100);
            });
            modelBuilder.Entity<AdmGoodsClassify>(entity =>
            {
                entity.ToTable("adm_goods_classify");
@@ -1604,6 +1966,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")
@@ -1619,6 +1985,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()
@@ -1711,6 +2082,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 =>
@@ -1831,6 +2312,18 @@
                    .HasColumnType("numeric(18, 2)")
                    .HasColumnName("money")
                    .HasComment("金额");
                entity.Property(e => e.Jichumoney)
                   .HasColumnType("numeric(18, 2)")
                   .HasColumnName("jichumoney");
                entity.Property(e => e.Xmcode)
                   .HasMaxLength(50)
                   .HasColumnName("xmcode");
                entity.Property(e => e.Xmname)
                .HasMaxLength(500)
                .HasColumnName("xmname");
                entity.Property(e => e.OrderNo)
                    .HasMaxLength(100)
@@ -2243,6 +2736,18 @@
                    .HasColumnType("datetime")
                    .HasColumnName("weixintime");
                entity.Property(e => e.Kuaidistatus)
                    .HasMaxLength(1)
                    .HasColumnName("kuaidistatus");
                entity.Property(e => e.Kuaiditime)
                    .HasColumnType("datetime")
                    .HasColumnName("kuaiditime");
                entity.Property(e => e.Ywjltime)
                    .HasColumnType("datetime")
                    .HasColumnName("ywjltime");
                entity.Property(e => e.YwName)
                    .HasMaxLength(500)
                    .HasColumnName("yw_name")
@@ -2262,6 +2767,103 @@
                    .HasMaxLength(50)
                    .HasColumnName("ywjl")
                    .HasComment("业务经理");
                entity.Property(e => e.Yufukuan)
                    .HasColumnType("money")
                    .HasColumnName("yufukuan");
                entity.Property(e => e.Shouxinedu)
                    .HasColumnType("money")
                    .HasColumnName("shouxinedu");
                entity.Property(e => e.Shenyushouxin)
                    .HasColumnType("money")
                    .HasColumnName("shenyushouxin");
                entity.Property(e => e.Taocanjianshu)
                   .HasColumnType("int")
                   .HasColumnName("taocanjianshu");
            });
            modelBuilder.Entity<CustomerYwjl>(entity =>
            {
                entity.ToTable("Customer_Ywjl");
                entity.Property(e => e.Id).HasMaxLength(50);
                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime");
                entity.Property(e => e.UserId)
                    .HasMaxLength(50)
                    .HasColumnName("userId");
                entity.Property(e => e.YwjlId)
                    .HasMaxLength(50)
                    .HasColumnName("ywjlId");
            });
            modelBuilder.Entity<CustomerGuanlianhuiyuan>(entity =>
            {
                entity.ToTable("CustomerGuanlianhuiyuan");
                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.Customerid)
                    .HasMaxLength(50)
                    .HasColumnName("customerid");
                entity.Property(e => e.Customertype)
                    .HasMaxLength(50)
                    .HasColumnName("customertype");
                entity.Property(e => e.Huiyuanid)
                    .HasMaxLength(50)
                    .HasColumnName("huiyuanid");
                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<CustomerGuanlian>(entity =>
            {
                entity.ToTable("CustomerGuanlian");
                entity.Property(e => e.Id).HasMaxLength(50);
                entity.Property(e => e.CustomerId).HasMaxLength(50);
                entity.Property(e => e.Customertype).HasMaxLength(50);
                entity.Property(e => e.SecCustomerId).HasMaxLength(50);
                entity.Property(e => e.SecCustomertype).HasMaxLength(50);
            });
            modelBuilder.Entity<CusFangwenjilu>(entity =>
@@ -2436,6 +3038,72 @@
                entity.Property(e => e.RecordTypeId).HasMaxLength(50);
                entity.Property(e => e.Remark).HasMaxLength(500);
                entity.Property(e => e.SubjectId).HasMaxLength(50);
            });
            modelBuilder.Entity<FiCustomerrecievemoney>(entity =>
            {
                entity.ToTable("fi_Customerrecievemoney");
                entity.Property(e => e.Id).HasMaxLength(50);
                entity.Property(e => e.AccountId).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.CustomerId)
                    .HasMaxLength(50)
                    .HasComment("客户id");
                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.PayTime)
                    .HasColumnType("datetime")
                    .HasColumnName("pay_time")
                    .HasDefaultValueSql("(getdate())")
                    .HasComment("收款日期");
                entity.Property(e => e.PayType)
                    .HasMaxLength(50)
                    .HasColumnName("pay_type")
                    .HasComment("收款方式");
                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");
                entity.Property(e => e.Recievemoney)
                    .HasColumnType("numeric(18, 2)")
                    .HasColumnName("recievemoney")
                    .HasComment("收款金额");
                entity.Property(e => e.RecordTypeId).HasMaxLength(50);
                entity.Property(e => e.Remark)
                    .HasMaxLength(4000)
                    .HasColumnName("remark")
                    .HasComment("收款备注");
                entity.Property(e => e.SubjectId).HasMaxLength(50);
            });
@@ -2665,6 +3333,10 @@
                    .HasColumnName("danjia")
                    .HasComment("单价");
                entity.Property(e => e.Jifen)
                   .HasColumnType("money")
                   .HasColumnName("jifen");
                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
@@ -2704,6 +3376,10 @@
                    .HasColumnType("money")
                    .HasColumnName("huifei")
                    .HasComment("会费");
                entity.Property(e => e.Jifen)
                    .HasColumnType("money")
                    .HasColumnName("jifen");
                entity.Property(e => e.MemberAuthority)
                    .HasMaxLength(500)
@@ -2754,6 +3430,10 @@
                    .HasColumnType("money")
                    .HasColumnName("feiyong")
                    .HasComment("费用");
                entity.Property(e => e.Jifen)
                  .HasColumnType("money")
                  .HasColumnName("jifen");
                entity.Property(e => e.Modifier)
                    .IsRequired()
@@ -3124,6 +3804,10 @@
                    .HasColumnType("money")
                    .HasColumnName("jibengongzi");
                entity.Property(e => e.Jiabangongzi)
                   .HasColumnType("money")
                   .HasColumnName("jiabangongzi");
                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
@@ -3399,6 +4083,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");
@@ -3481,6 +4208,10 @@
                    .HasMaxLength(50)
                    .HasColumnName("khlx")
                    .HasComment("客户类型");
                entity.Property(e => e.HuiyuanId)
                   .HasMaxLength(50)
                   .HasColumnName("huiyuanId");
                entity.Property(e => e.Khly)
                    .HasMaxLength(50)
@@ -3574,6 +4305,18 @@
                entity.Property(e => e.Weixintime)
                    .HasColumnType("datetime")
                    .HasColumnName("weixintime");
                entity.Property(e => e.Kuaidistatus)
                  .HasMaxLength(1)
                  .HasColumnName("kuaidistatus");
                entity.Property(e => e.Kuaiditime)
                    .HasColumnType("datetime")
                    .HasColumnName("kuaiditime");
                entity.Property(e => e.Ywjltime)
                  .HasColumnType("datetime")
                  .HasColumnName("ywjltime");
                entity.Property(e => e.Yixiang).HasMaxLength(50);
@@ -4091,6 +4834,12 @@
                entity.Property(e => e.Renshu)
                    .HasColumnName("renshu");
                entity.Property(e => e.Hang)
                  .HasColumnName("hang");
                entity.Property(e => e.Lie)
                  .HasColumnName("lie");
                entity.Property(e => e.Shijian)
                    .HasColumnType("datetime")
                    .HasColumnName("shijian");
@@ -4157,6 +4906,14 @@
                entity.Property(e => e.Zhujiangren)
                    .HasMaxLength(100)
                    .HasColumnName("zhujiangren");
                entity.Property(e => e.Jiage)
                  .HasColumnType("numeric(18, 2)")
                  .HasColumnName("jiage");
                entity.Property(e => e.Jifen)
                  .HasColumnType("numeric(18, 2)")
                  .HasColumnName("Jifen");
            });
            modelBuilder.Entity<OrderBanciOrder>(entity =>
@@ -4190,6 +4947,18 @@
                    .HasColumnType("money")
                    .HasColumnName("jine");
                entity.Property(e => e.Jifen)
                 .HasColumnType("money")
                 .HasColumnName("jifen");
                entity.Property(e => e.SeatID)
                  .HasMaxLength(50)
                  .HasColumnName("SeatID");
                entity.Property(e => e.SeatName)
                  .HasMaxLength(50)
                  .HasColumnName("SeatName");
                entity.Property(e => e.Kechengleixing)
                    .HasMaxLength(100)
                    .HasColumnName("kechengleixing");
@@ -4221,6 +4990,10 @@
                    .HasMaxLength(100)
                    .HasColumnName("person_id");
                entity.Property(e => e.OrderId)
                    .HasMaxLength(100)
                    .HasColumnName("order_id");
                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
@@ -4238,6 +5011,61 @@
                entity.Property(e => e.Xuefei)
                    .HasColumnType("money")
                    .HasColumnName("xuefei");
            });
            modelBuilder.Entity<OrderBanciZuowei>(entity =>
            {
                entity.ToTable("order_banci_zuowei");
                entity.Property(e => e.Id).HasMaxLength(50);
                entity.Property(e => e.BanciId)
                    .HasMaxLength(50)
                    .HasColumnName("banciId");
                entity.Property(e => e.ColNo).HasColumnName("colNo");
                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.RowNo).HasColumnName("rowNo");
                entity.Property(e => e.SeatNo)
                    .HasMaxLength(50)
                    .HasColumnName("seatNo");
                entity.Property(e => e.Status)
                    .HasMaxLength(1)
                    .HasColumnName("status");
                entity.Property(e => e.ZuoweiId)
                    .HasMaxLength(50)
                    .HasColumnName("zuoweiId");
            });
            modelBuilder.Entity<PltAuth>(entity =>
@@ -4708,6 +5536,10 @@
                entity.Property(e => e.ShiyongDateEnd).HasColumnType("datetime");
                entity.Property(e => e.HetongDateEnd).HasColumnType("datetime");
                entity.Property(e => e.FenpeiDate).HasColumnType("datetime");
                entity.Property(e => e.ShiyongPrice).HasColumnType("numeric(18, 2)");
                entity.Property(e => e.Tel)
@@ -4887,6 +5719,10 @@
                    .HasDefaultValueSql("('')")
                    .HasComment("采购人名称");
                entity.Property(e => e.Caigouyusuan)
                    .HasColumnType("money")
                    .HasColumnName("caigouyusuan");
                entity.Property(e => e.Cgfs)
                    .HasMaxLength(50)
                    .HasColumnName("cgfs");
@@ -4924,6 +5760,30 @@
                    .HasDefaultValueSql("('')")
                    .HasComment("采购人名称");
                entity.Property(e => e.DehxTousuchengli)
                    .HasMaxLength(1)
                    .HasColumnName("dehx_tousuchengli");
                entity.Property(e => e.DehxTousushijian)
                    .HasColumnType("datetime")
                    .HasColumnName("dehx_tousushijian");
                entity.Property(e => e.DehxTousustatus)
                    .HasMaxLength(1)
                    .HasColumnName("dehx_tousustatus");
                entity.Property(e => e.DehxZhiyichengli)
                    .HasMaxLength(1)
                    .HasColumnName("dehx_zhiyichengli");
                entity.Property(e => e.DehxZhiyishijian)
                    .HasColumnType("datetime")
                    .HasColumnName("dehx_zhiyishijian");
                entity.Property(e => e.DehxZhiyistatus)
                    .HasMaxLength(1)
                    .HasColumnName("dehx_zhiyistatus");
                entity.Property(e => e.Drhx)
                    .HasMaxLength(500)
                    .HasColumnName("drhx");
@@ -4931,10 +5791,6 @@
                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)
@@ -4951,6 +5807,30 @@
                entity.Property(e => e.DshxPrice)
                    .HasMaxLength(500)
                    .HasColumnName("dshx_price");
                entity.Property(e => e.DshxTousuchengli)
                    .HasMaxLength(1)
                    .HasColumnName("dshx_tousuchengli");
                entity.Property(e => e.DshxTousushijian)
                    .HasColumnType("datetime")
                    .HasColumnName("dshx_tousushijian");
                entity.Property(e => e.DshxTousustatus)
                    .HasMaxLength(1)
                    .HasColumnName("dshx_tousustatus");
                entity.Property(e => e.DshxZhiyichengli)
                    .HasMaxLength(1)
                    .HasColumnName("dshx_zhiyichengli");
                entity.Property(e => e.DshxZhiyishijian)
                    .HasColumnType("datetime")
                    .HasColumnName("dshx_zhiyishijian");
                entity.Property(e => e.DshxZhiyistatus)
                    .HasMaxLength(1)
                    .HasColumnName("dshx_zhiyistatus");
                entity.Property(e => e.Fblx).HasMaxLength(500);
@@ -5042,6 +5922,30 @@
                entity.Property(e => e.Reasonremark)
                    .HasMaxLength(500)
                    .HasColumnName("reasonremark");
                entity.Property(e => e.WxTousuchengli)
                    .HasMaxLength(1)
                    .HasColumnName("wx_tousuchengli");
                entity.Property(e => e.WxTousushijian)
                    .HasColumnType("datetime")
                    .HasColumnName("wx_tousushijian");
                entity.Property(e => e.WxTousustatus)
                    .HasMaxLength(1)
                    .HasColumnName("wx_tousustatus");
                entity.Property(e => e.WxZhiyichengli)
                    .HasMaxLength(1)
                    .HasColumnName("wx_zhiyichengli");
                entity.Property(e => e.WxZhiyishijian)
                    .HasColumnType("datetime")
                    .HasColumnName("wx_zhiyishijian");
                entity.Property(e => e.WxZhiyistatus)
                    .HasMaxLength(1)
                    .HasColumnName("wx_zhiyistatus");
            });
            modelBuilder.Entity<Projectyouxiao>(entity =>
@@ -5065,6 +5969,30 @@
                entity.Property(e => e.ProjectId)
                    .IsRequired()
                    .HasMaxLength(50);
                entity.Property(e => e.YxTousuchengli)
                    .HasMaxLength(1)
                    .HasColumnName("yx_tousuchengli");
                entity.Property(e => e.YxTousushijian)
                    .HasColumnType("datetime")
                    .HasColumnName("yx_tousushijian");
                entity.Property(e => e.YxTousustatus)
                    .HasMaxLength(1)
                    .HasColumnName("yx_tousustatus");
                entity.Property(e => e.YxZhiyichengli)
                    .HasMaxLength(1)
                    .HasColumnName("yx_zhiyichengli");
                entity.Property(e => e.YxZhiyishijian)
                    .HasColumnType("datetime")
                    .HasColumnName("yx_zhiyishijian");
                entity.Property(e => e.YxZhiyistatus)
                    .HasMaxLength(1)
                    .HasColumnName("yx_zhiyistatus");
            });
            modelBuilder.Entity<Projectzhongbiao>(entity =>
@@ -5078,6 +6006,10 @@
                    .HasMaxLength(50)
                    .HasColumnName("zhongbiaoId");
                entity.Property(e => e.Defen)
                    .HasColumnType("money")
                    .HasColumnName("defen");
                entity.Property(e => e.Names)
                    .HasMaxLength(500)
                    .HasColumnName("names");
@@ -5090,8 +6022,64 @@
                    .IsRequired()
                    .HasMaxLength(50);
                entity.Property(e => e.Defen).HasColumnType("money")
                    .HasColumnName("defen"); ;
                entity.Property(e => e.ZbTousuchengli)
                    .HasMaxLength(1)
                    .HasColumnName("zb_tousuchengli");
                entity.Property(e => e.ZbTousushijian)
                    .HasColumnType("datetime")
                    .HasColumnName("zb_tousushijian");
                entity.Property(e => e.ZbTousustatus)
                    .HasMaxLength(1)
                    .HasColumnName("zb_tousustatus");
                entity.Property(e => e.ZbZhiyichengli)
                    .HasMaxLength(1)
                    .HasColumnName("zb_zhiyichengli");
                entity.Property(e => e.ZbZhiyishijian)
                    .HasColumnType("datetime")
                    .HasColumnName("zb_zhiyishijian");
                entity.Property(e => e.ZbZhiyistatus)
                    .HasMaxLength(1)
                    .HasColumnName("zb_zhiyistatus");
            });
            modelBuilder.Entity<Projectfasongxiaoxi>(entity =>
            {
                entity.ToTable("Projectfasongxiaoxi");
                entity.Property(e => e.Id).HasMaxLength(50);
                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime");
                entity.Property(e => e.ProjectId).HasMaxLength(50);
                entity.Property(e => e.ProjectmingxiId).HasMaxLength(50);
                entity.Property(e => e.RecStatus)
                    .HasMaxLength(1)
                    .HasColumnName("rec_status");
                entity.Property(e => e.Xiaoxileixing)
                    .HasMaxLength(50)
                    .HasColumnName("xiaoxileixing");
                entity.Property(e => e.Xiaoxizhonglei)
                    .HasMaxLength(50)
                    .HasColumnName("xiaoxizhonglei");
                entity.Property(e => e.Gyszl)
                   .HasMaxLength(50)
                   .HasColumnName("gyszl");
                entity.Property(e => e.Khname)
                  .HasMaxLength(50)
                  .HasColumnName("khname");
            });
            modelBuilder.Entity<SysAttachment>(entity =>
@@ -5143,6 +6131,53 @@
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");
                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .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()
@@ -5233,11 +6268,11 @@
                entity.Property(e => e.Comments)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasMaxLength(100)
                    .HasColumnName("comments");
                entity.Property(e => e.Contents)
                    .HasMaxLength(300)
                    .HasMaxLength(500)
                    .HasColumnName("contents");
                entity.Property(e => e.Creater)
@@ -5840,7 +6875,6 @@
                    .HasColumnName("expertType");
                entity.Property(e => e.IdCard)
                    .IsRequired()
                    .HasMaxLength(18)
                    .HasColumnName("idCard");
@@ -5892,6 +6926,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");
@@ -5899,7 +6937,6 @@
                entity.Property(e => e.ReviewItem).HasMaxLength(50);
                entity.Property(e => e.Sex)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("sex");
@@ -6045,6 +7082,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 =>
            {
@@ -6202,6 +7511,528 @@
                entity.Property(e => e.StratTime).HasColumnType("datetime");
            });
            #endregion
            modelBuilder.Entity<TChallengeItem>(entity =>
            {
                entity.ToTable("t_challenge_items");
                entity.Property(e => e.Id).HasColumnName("id");
                entity.Property(e => e.ChallengeId)
                    .HasMaxLength(50)
                    .HasColumnName("challenge_id");
                entity.Property(e => e.Evidential)
                    .HasMaxLength(4000)
                    .HasColumnName("evidential");
                entity.Property(e => e.Law)
                    .HasMaxLength(300)
                    .HasColumnName("law");
                entity.Property(e => e.Lawcoment)
                  .HasMaxLength(300)
                  .HasColumnName("lawcoment");
                entity.Property(e => e.Question)
                    .HasMaxLength(300)
                    .HasColumnName("question");
                entity.Property(e => e.Questionname)
                 .HasMaxLength(500)
                 .HasColumnName("questionname");
                entity.Property(e => e.Sort).HasColumnName("sort");
            });
            modelBuilder.Entity<TChallengeletter>(entity =>
            {
                entity.ToTable("t_challengeletter");
                entity.Property(e => e.Id)
                    .HasMaxLength(50)
                    .HasColumnName("id");
                entity.Property(e => e.Creater)
                    .HasMaxLength(50)
                    .HasColumnName("creater");
                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime");
                entity.Property(e => e.DocumentsDate)
                    .HasColumnType("datetime")
                    .HasColumnName("documents_date");
                entity.Property(e => e.GysAddress)
                    .HasMaxLength(100)
                    .HasColumnName("gys_address");
                entity.Property(e => e.GysContacts)
                    .HasMaxLength(30)
                    .HasColumnName("gys_contacts");
                entity.Property(e => e.GysId)
                    .HasMaxLength(50)
                    .HasColumnName("gys_id");
                entity.Property(e => e.GysName)
                    .HasMaxLength(50)
                    .HasColumnName("gys_name");
                entity.Property(e => e.GysPhone)
                    .HasMaxLength(30)
                    .HasColumnName("gys_phone");
                entity.Property(e => e.GysPostcode)
                    .HasMaxLength(10)
                    .HasColumnName("gys_postcode");
                entity.Property(e => e.IsReply).HasColumnName("is_reply");
                entity.Property(e => e.Modifier)
                    .HasMaxLength(50)
                    .HasColumnName("modifier");
                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime");
                entity.Property(e => e.OrderId)
                    .HasMaxLength(50)
                    .HasColumnName("order_id");
                entity.Property(e => e.PrintNum).HasColumnName("print_num");
                entity.Property(e => e.PurchaserName)
                    .HasMaxLength(50)
                    .HasColumnName("purchaser_name");
                entity.Property(e => e.RequestInfo)
                    .HasMaxLength(300)
                    .HasColumnName("request_info");
                entity.Property(e => e.RespondDate)
                    .HasColumnType("datetime")
                    .HasColumnName("respond_date");
                entity.Property(e => e.RespondInfo)
                    .HasMaxLength(500)
                    .HasColumnName("respond_info");
                entity.Property(e => e.Respondent)
                    .HasMaxLength(50)
                    .HasColumnName("respondent");
                entity.Property(e => e.SqdbAddress)
                    .HasMaxLength(100)
                    .HasColumnName("sqdb_address");
                entity.Property(e => e.SqdbId)
                    .HasMaxLength(50)
                    .HasColumnName("sqdb_id");
                entity.Property(e => e.SqdbName)
                    .HasMaxLength(50)
                    .HasColumnName("sqdb_name");
                entity.Property(e => e.SqdbPhone)
                    .HasMaxLength(30)
                    .HasColumnName("sqdb_phone");
                entity.Property(e => e.SqdbPostcode)
                    .HasMaxLength(10)
                    .HasColumnName("sqdb_postcode");
                entity.Property(e => e.Status).HasColumnName("status");
                entity.Property(e => e.XmCode)
                    .HasMaxLength(30)
                    .HasColumnName("xm_code");
                entity.Property(e => e.XmId)
                    .HasMaxLength(50)
                    .HasColumnName("xm_id");
                entity.Property(e => e.XmName)
                    .HasMaxLength(100)
                    .HasColumnName("xm_name");
                entity.Property(e => e.XmPackage)
                    .HasMaxLength(30)
                    .HasColumnName("xm_package");
            });
            modelBuilder.Entity<TChallengeRequestInfo>(entity =>
            {
                entity.ToTable("t_challenge_requestInfo");
                entity.Property(e => e.Id).HasColumnName("id");
                entity.Property(e => e.ChallengeId)
                    .HasMaxLength(50)
                    .HasColumnName("challenge_id");
                entity.Property(e => e.RequestInfo)
                    .HasMaxLength(50)
                    .HasColumnName("requestInfo");
                entity.Property(e => e.RequestInfoname)
                    .HasMaxLength(500)
                    .HasColumnName("requestInfoname");
            });
            modelBuilder.Entity<TComplaintItem>(entity =>
            {
                entity.ToTable("t_complaint_items");
                entity.Property(e => e.Id).HasColumnName("id");
                entity.Property(e => e.ComplaintId)
                    .HasMaxLength(50)
                    .HasColumnName("complaint_id");
                entity.Property(e => e.Evidential)
                    .HasMaxLength(4000)
                    .HasColumnName("evidential");
                entity.Property(e => e.Law)
                    .HasMaxLength(300)
                    .HasColumnName("law");
                entity.Property(e => e.Lawcoment)
                 .HasMaxLength(300)
                 .HasColumnName("lawcoment");
                entity.Property(e => e.Question)
                    .HasMaxLength(300)
                    .HasColumnName("question");
                entity.Property(e => e.Questionname)
                .HasMaxLength(500)
                .HasColumnName("questionname");
                entity.Property(e => e.Sort).HasColumnName("sort");
            });
            modelBuilder.Entity<TComplaintRespondent>(entity =>
            {
                entity.ToTable("t_complaint_respondents");
                entity.Property(e => e.Id).HasColumnName("id");
                entity.Property(e => e.Address)
                    .HasMaxLength(100)
                    .HasColumnName("address");
                entity.Property(e => e.ComplaintId)
                    .HasMaxLength(50)
                    .HasColumnName("complaint_id");
                entity.Property(e => e.Contacts)
                    .HasMaxLength(30)
                    .HasColumnName("contacts");
                entity.Property(e => e.Phone)
                    .HasMaxLength(30)
                    .HasColumnName("phone");
                entity.Property(e => e.Postcode)
                    .HasMaxLength(10)
                    .HasColumnName("postcode");
                entity.Property(e => e.Respondent)
                    .HasMaxLength(50)
                    .HasColumnName("respondent");
                entity.Property(e => e.Sort).HasColumnName("sort");
            });
            modelBuilder.Entity<TComplaintletter>(entity =>
            {
                entity.ToTable("t_complaintletter");
                entity.Property(e => e.Id)
                    .HasMaxLength(50)
                    .HasColumnName("id");
                entity.Property(e => e.Agency)
                    .HasMaxLength(50)
                    .HasColumnName("agency");
                entity.Property(e => e.ChallengeDate)
                    .HasColumnType("datetime")
                    .HasColumnName("challenge_date");
                entity.Property(e => e.Creater)
                    .HasMaxLength(50)
                    .HasColumnName("creater");
                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime");
                entity.Property(e => e.DocumentsDate)
                    .HasColumnType("datetime")
                    .HasColumnName("documents_date");
                entity.Property(e => e.GysAddress)
                    .HasMaxLength(100)
                    .HasColumnName("gys_address");
                entity.Property(e => e.GysContacts)
                    .HasMaxLength(30)
                    .HasColumnName("gys_contacts");
                entity.Property(e => e.GysId)
                    .HasMaxLength(50)
                    .HasColumnName("gys_id");
                entity.Property(e => e.GysName)
                    .HasMaxLength(50)
                    .HasColumnName("gys_name");
                entity.Property(e => e.GysPhone)
                    .HasMaxLength(30)
                    .HasColumnName("gys_phone");
                entity.Property(e => e.GysPostcode)
                    .HasMaxLength(10)
                    .HasColumnName("gys_postcode");
                entity.Property(e => e.IsNotice)
                    .HasMaxLength(1)
                    .HasColumnName("is_notice");
                entity.Property(e => e.IsResultnotice)
                    .HasMaxLength(1)
                    .HasColumnName("is_resultnotice");
                entity.Property(e => e.Modifier)
                    .HasMaxLength(50)
                    .HasColumnName("modifier");
                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime");
                entity.Property(e => e.NoticeDate)
                    .HasColumnType("datetime")
                    .HasColumnName("notice_date");
                entity.Property(e => e.OrderId)
                    .HasMaxLength(50)
                    .HasColumnName("order_id");
                entity.Property(e => e.PrintNum).HasColumnName("print_num");
                entity.Property(e => e.PurchaserName)
                    .HasMaxLength(50)
                    .HasColumnName("purchaser_name");
                entity.Property(e => e.Questioned)
                    .HasMaxLength(300)
                    .HasColumnName("questioned");
                entity.Property(e => e.RequestInfo)
                    .HasMaxLength(300)
                    .HasColumnName("request_info");
                entity.Property(e => e.RespondDate)
                    .HasColumnType("datetime")
                    .HasColumnName("respond_date");
                entity.Property(e => e.Respondent)
                    .HasMaxLength(300)
                    .HasColumnName("respondent");
                entity.Property(e => e.ResultnoticeDate)
                    .HasColumnType("datetime")
                    .HasColumnName("resultnotice_date");
                entity.Property(e => e.SqdbAddress)
                    .HasMaxLength(100)
                    .HasColumnName("sqdb_address");
                entity.Property(e => e.SqdbId)
                    .HasMaxLength(50)
                    .HasColumnName("sqdb_id");
                entity.Property(e => e.SqdbName)
                    .HasMaxLength(50)
                    .HasColumnName("sqdb_name");
                entity.Property(e => e.SqdbPhone)
                    .HasMaxLength(30)
                    .HasColumnName("sqdb_phone");
                entity.Property(e => e.SqdbPostcode)
                    .HasMaxLength(10)
                    .HasColumnName("sqdb_postcode");
                entity.Property(e => e.Status).HasColumnName("status");
                entity.Property(e => e.TsrAddress)
                    .HasMaxLength(100)
                    .HasColumnName("tsr_address");
                entity.Property(e => e.TsrCorporation)
                    .HasMaxLength(30)
                    .HasColumnName("tsr_corporation");
                entity.Property(e => e.TsrId)
                    .HasMaxLength(50)
                    .HasColumnName("tsr_id");
                entity.Property(e => e.TsrName)
                    .HasMaxLength(50)
                    .HasColumnName("tsr_name");
                entity.Property(e => e.TsrPhone)
                    .HasMaxLength(30)
                    .HasColumnName("tsr_phone");
                entity.Property(e => e.TsrPostcode)
                    .HasMaxLength(10)
                    .HasColumnName("tsr_postcode");
                entity.Property(e => e.XmCode)
                    .HasMaxLength(30)
                    .HasColumnName("xm_code");
                entity.Property(e => e.XmId)
                    .HasMaxLength(50)
                    .HasColumnName("xm_id");
                entity.Property(e => e.XmName)
                    .HasMaxLength(100)
                    .HasColumnName("xm_name");
                entity.Property(e => e.XmPackage)
                    .HasMaxLength(30)
                    .HasColumnName("xm_package");
            });
            modelBuilder.Entity<TComplaintGongyingshang>(entity =>
            {
                entity.ToTable("t_complaint_gongyingshang");
                entity.Property(e => e.Id).HasColumnName("id");
                entity.Property(e => e.ComplaintId)
                    .HasMaxLength(50)
                    .HasColumnName("complaint_id");
                entity.Property(e => e.Dizhi)
                    .HasMaxLength(300)
                    .HasColumnName("dizhi");
                entity.Property(e => e.Gongytingshang)
                    .HasMaxLength(300)
                    .HasColumnName("gongytingshang");
                entity.Property(e => e.Lianxidianhua)
                    .HasMaxLength(300)
                    .HasColumnName("lianxidianhua");
                entity.Property(e => e.Lianxiren)
                    .HasMaxLength(300)
                    .HasColumnName("lianxiren");
                entity.Property(e => e.Sort).HasColumnName("sort");
                entity.Property(e => e.Youbian)
                    .HasMaxLength(300)
                    .HasColumnName("youbian");
            });
            modelBuilder.Entity<TComplaintShouquandaibiao>(entity =>
            {
                entity.ToTable("t_complaint_shouquandaibiao");
                entity.Property(e => e.Id).HasColumnName("id");
                entity.Property(e => e.ComplaintId)
                    .HasMaxLength(50)
                    .HasColumnName("complaint_id");
                entity.Property(e => e.Dizhi)
                    .HasMaxLength(300)
                    .HasColumnName("dizhi");
                entity.Property(e => e.Lianxidianhua)
                    .HasMaxLength(300)
                    .HasColumnName("lianxidianhua");
                entity.Property(e => e.Shouquandaibiao)
                    .HasMaxLength(300)
                    .HasColumnName("shouquandaibiao");
                entity.Property(e => e.Sort).HasColumnName("sort");
                entity.Property(e => e.Youbian)
                    .HasMaxLength(300)
                    .HasColumnName("youbian");
            });
            modelBuilder.Entity<Zxdsfxl>(entity =>
            {
                entity.ToTable("zxdsfxls");
                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.Huiyuanid)
                    .HasMaxLength(50)
                    .HasColumnName("huiyuanid");
                entity.Property(e => e.Huiyuanname)
                    .HasMaxLength(100)
                    .HasColumnName("huiyuanname");
                entity.Property(e => e.Leixing)
                    .HasMaxLength(1)
                    .HasColumnName("leixing");
                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.Token)
                    .HasMaxLength(500)
                    .HasColumnName("token");
                entity.Property(e => e.Visittime)
                    .HasColumnType("datetime")
                    .HasColumnName("visittime");
            });
            OnModelCreatingPartial(modelBuilder);
        }