From efad4f05e52c89f3b42774e313144abd039370e4 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 10 二月 2023 11:26:06 +0800
Subject: [PATCH] 考勤怎么加带薪假的计算

---
 zhengcaioa/Model/zhengcaioaContext.cs | 1282 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 1,271 insertions(+), 11 deletions(-)

diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs
index 3d34a3d..9b1addc 100644
--- a/zhengcaioa/Model/zhengcaioaContext.cs
+++ b/zhengcaioa/Model/zhengcaioaContext.cs
@@ -37,6 +37,8 @@
         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; }
@@ -49,6 +51,7 @@
         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; }
@@ -59,9 +62,12 @@
         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<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; }
@@ -77,6 +83,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; }
@@ -114,18 +121,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");
             }
         }
 
@@ -833,6 +860,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");
@@ -927,6 +1029,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()
@@ -1034,6 +1141,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()
@@ -1756,6 +1868,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");
@@ -2181,6 +2309,18 @@
                     .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)
                     .HasColumnName("order_no")
@@ -2592,6 +2732,10 @@
                     .HasColumnType("datetime")
                     .HasColumnName("weixintime");
 
+                entity.Property(e => e.Ywjltime)
+                    .HasColumnType("datetime")
+                    .HasColumnName("ywjltime");
+
                 entity.Property(e => e.YwName)
                     .HasMaxLength(500)
                     .HasColumnName("yw_name")
@@ -2611,6 +2755,56 @@
                     .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<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 =>
@@ -2785,6 +2979,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);
             });
@@ -3014,6 +3274,10 @@
                     .HasColumnName("danjia")
                     .HasComment("鍗曚环");
 
+                entity.Property(e => e.Jifen)
+                   .HasColumnType("money")
+                   .HasColumnName("jifen");
+
                 entity.Property(e => e.Modifier)
                     .IsRequired()
                     .HasMaxLength(50)
@@ -3053,6 +3317,10 @@
                     .HasColumnType("money")
                     .HasColumnName("huifei")
                     .HasComment("浼氳垂");
+
+                entity.Property(e => e.Jifen)
+                    .HasColumnType("money")
+                    .HasColumnName("jifen");
 
                 entity.Property(e => e.MemberAuthority)
                     .HasMaxLength(500)
@@ -3103,6 +3371,10 @@
                     .HasColumnType("money")
                     .HasColumnName("feiyong")
                     .HasComment("璐圭敤");
+
+                entity.Property(e => e.Jifen)
+                  .HasColumnType("money")
+                  .HasColumnName("jifen");
 
                 entity.Property(e => e.Modifier)
                     .IsRequired()
@@ -3748,6 +4020,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");
@@ -3830,6 +4145,10 @@
                     .HasMaxLength(50)
                     .HasColumnName("khlx")
                     .HasComment("瀹㈡埛绫诲瀷");
+
+                entity.Property(e => e.HuiyuanId)
+                   .HasMaxLength(50)
+                   .HasColumnName("huiyuanId");
 
                 entity.Property(e => e.Khly)
                     .HasMaxLength(50)
@@ -3923,6 +4242,10 @@
                 entity.Property(e => e.Weixintime)
                     .HasColumnType("datetime")
                     .HasColumnName("weixintime");
+
+                entity.Property(e => e.Ywjltime)
+                  .HasColumnType("datetime")
+                  .HasColumnName("ywjltime");
 
                 entity.Property(e => e.Yixiang).HasMaxLength(50);
 
@@ -4506,6 +4829,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 =>
@@ -4539,6 +4870,10 @@
                     .HasColumnType("money")
                     .HasColumnName("jine");
 
+                entity.Property(e => e.Jifen)
+                 .HasColumnType("money")
+                 .HasColumnName("jifen");
+
                 entity.Property(e => e.Kechengleixing)
                     .HasMaxLength(100)
                     .HasColumnName("kechengleixing");
@@ -4569,6 +4904,10 @@
                 entity.Property(e => e.PersonId)
                     .HasMaxLength(100)
                     .HasColumnName("person_id");
+
+                entity.Property(e => e.OrderId)
+                    .HasMaxLength(100)
+                    .HasColumnName("order_id");
 
                 entity.Property(e => e.RecStatus)
                     .IsRequired()
@@ -5057,6 +5396,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)
@@ -5236,6 +5579,10 @@
                     .HasDefaultValueSql("('')")
                     .HasComment("閲囪喘浜哄悕绉�");
 
+                entity.Property(e => e.Caigouyusuan)
+                    .HasColumnType("money")
+                    .HasColumnName("caigouyusuan");
+
                 entity.Property(e => e.Cgfs)
                     .HasMaxLength(50)
                     .HasColumnName("cgfs");
@@ -5273,6 +5620,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");
@@ -5280,10 +5651,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)
@@ -5300,6 +5667,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);
 
@@ -5391,6 +5782,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 =>
@@ -5414,6 +5829,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 =>
@@ -5427,6 +5866,10 @@
                     .HasMaxLength(50)
                     .HasColumnName("zhongbiaoId");
 
+                entity.Property(e => e.Defen)
+                    .HasColumnType("money")
+                    .HasColumnName("defen");
+
                 entity.Property(e => e.Names)
                     .HasMaxLength(500)
                     .HasColumnName("names");
@@ -5439,8 +5882,29 @@
                     .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<SysAttachment>(entity =>
@@ -5629,11 +6093,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)
@@ -6236,7 +6700,6 @@
                     .HasColumnName("expertType");
 
                 entity.Property(e => e.IdCard)
-                    .IsRequired()
                     .HasMaxLength(18)
                     .HasColumnName("idCard");
 
@@ -6288,6 +6751,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");
@@ -6295,7 +6762,6 @@
                 entity.Property(e => e.ReviewItem).HasMaxLength(50);
 
                 entity.Property(e => e.Sex)
-                    .IsRequired()
                     .HasMaxLength(50)
                     .HasColumnName("sex");
 
@@ -6441,6 +6907,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 =>
             {
@@ -6598,6 +7336,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);
         }
 

--
Gitblit v1.9.1