客户预付款

username@email.com

2022-01-06 cd0277d99c49babe5c2de292ef4d54ac4a720f13

 zhengcaioa/Model/zhengcaioaContext.cs

@@ -26,8 +26,12 @@

        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; }
@@ -48,6 +52,8 @@
        public virtual DbSet<AdmGoodsClassify> AdmGoodsClassifies { get; set; }
        public virtual DbSet<AdmGoodsManage> AdmGoodsManages { get; set; }
        public virtual DbSet<AdmPieceCheck> AdmPieceChecks { get; set; }
        public virtual DbSet<AdmTongxunlu> AdmTongxunlus { get; set; }
        public virtual DbSet<AdmZhanghaomima> AdmZhanghaomimas { get; set; }
        public virtual DbSet<Area> Areas { get; set; }
        public virtual DbSet<Cgf> Cgfs { get; set; }
        public virtual DbSet<CooperOrder> CooperOrders { get; set; }
@@ -56,6 +62,7 @@
        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 +78,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; }
@@ -94,6 +102,7 @@
        public virtual DbSet<Projectyouxiao> Projectyouxiaos { get; set; }
        public virtual DbSet<Projectzhongbiao> Projectzhongbiaos { get; set; }
        public virtual DbSet<SysAttachment> SysAttachments { get; set; }
        public virtual DbSet<SysBaimingdan> SysBaimingdans { get; set; }
        public virtual DbSet<SysCode> SysCodes { get; set; }
        public virtual DbSet<SysCodeDtl> SysCodeDtls { get; set; }
        public virtual DbSet<Systemsetting> Systemsettings { get; set; }
@@ -107,12 +116,28 @@
        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<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; }


        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            if (!optionsBuilder.IsConfigured)
@@ -240,6 +265,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 +437,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 =>
@@ -1114,6 +1362,12 @@

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

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

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

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

                entity.Property(e => e.Jine)
                    .HasColumnType("money")
                    .HasDefaultValueSql("((0))");
@@ -1598,6 +1852,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")
@@ -1613,6 +1871,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()
@@ -1705,6 +1968,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 =>
@@ -2256,6 +2629,18 @@
                    .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");
            });

            modelBuilder.Entity<CusFangwenjilu>(entity =>
@@ -2430,6 +2815,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);
            });
@@ -3393,6 +3844,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");
@@ -4214,6 +4708,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()
@@ -5145,6 +5643,53 @@
                    .HasDefaultValueSql("('A')");
            });

            modelBuilder.Entity<SysBaimingdan>(entity =>
            {
                entity.ToTable("sys_baimingdan");

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

                entity.Property(e => e.BaimingdanName)
                    .HasMaxLength(200)
                    .HasColumnName("baimingdan_name");

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.PostSeq)
                    .HasMaxLength(50)
                    .HasColumnName("post_seq");

                entity.Property(e => e.PostType)
                    .HasMaxLength(50)
                    .HasColumnName("post_type");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");
            });

            modelBuilder.Entity<SysCode>(entity =>
            {
                entity.ToTable("sys_code");
@@ -5227,7 +5772,7 @@

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

                entity.Property(e => e.Contents)
@@ -5834,7 +6379,6 @@
                    .HasColumnName("expertType");

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

@@ -5886,6 +6430,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");
@@ -5893,7 +6441,6 @@
                entity.Property(e => e.ReviewItem).HasMaxLength(50);

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

@@ -6039,6 +6586,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 =>
            {
@@ -6196,6 +7015,445 @@
                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(300)
                    .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.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<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(300)
                    .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.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");
            });

            OnModelCreatingPartial(modelBuilder);
        }