政采招标oa系统
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
username@email.com
2022-08-27 6e2b929cf381e2320ba6e7dec56c0371124d2b51 
 zhengcaioa/Model/zhengcaioaContext.cs


@@ -29,6 +29,7 @@


        public virtual DbSet<AdmAskCiZhi> AdmAskCiZhis { get; set; }


        public virtual DbSet<AdmAskcost> AdmAskcosts { get; set; }


        public virtual DbSet<AdmAskGood> AdmAskGoods { get; set; }


        public virtual DbSet<AdmGoodsRecord> AdmGoodsRecords { get; set; }


        public virtual DbSet<AdmAskJiaojie> AdmAskJiaojies { get; set; }


        public virtual DbSet<AdmAskJiaojieDtl> AdmAskJiaojieDtls { get; set; }


        public virtual DbSet<AdmAskLeave> AdmAskLeaves { get; set; }


@@ -51,6 +52,8 @@


        public virtual DbSet<AdmGoodsClassify> AdmGoodsClassifies { get; set; }


        public virtual DbSet<AdmGoodsManage> AdmGoodsManages { get; set; }


        public virtual DbSet<AdmPieceCheck> AdmPieceChecks { get; set; }


        public virtual DbSet<AdmTongxunlu> AdmTongxunlus { get; set; }


        public virtual DbSet<AdmZhanghaomima> AdmZhanghaomimas { get; set; }


        public virtual DbSet<Area> Areas { get; set; }


        public virtual DbSet<Cgf> Cgfs { get; set; }


        public virtual DbSet<CooperOrder> CooperOrders { get; set; }


@@ -59,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; }


@@ -74,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; }


@@ -111,18 +116,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");


            }


        }




@@ -416,6 +441,59 @@


                entity.Property(e => e.Tittle)


                    .HasMaxLength(50)


                    .HasColumnName("tittle");


            });




            modelBuilder.Entity<AdmGoodsRecord>(entity =>


            {


                entity.ToTable("adm_goods_record");




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




                entity.Property(e => e.Creater)


                    .IsRequired()


                    .HasMaxLength(50)


                    .HasColumnName("creater")


                    .HasDefaultValueSql("('1')");




                entity.Property(e => e.Createtime)


                    .HasColumnType("datetime")


                    .HasColumnName("createtime")


                    .HasDefaultValueSql("(getdate())");




                entity.Property(e => e.GoodsId)


                    .HasMaxLength(50)


                    .HasColumnName("goodsId");




                entity.Property(e => e.GoodsLeft)


                    .HasColumnType("numeric(18, 2)")


                    .HasColumnName("goods_left");




                entity.Property(e => e.GoodsNum)


                    .HasColumnType("numeric(18, 2)")


                    .HasColumnName("goods_num");




                entity.Property(e => e.Modifier)


                    .IsRequired()


                    .HasMaxLength(50)


                    .HasColumnName("modifier")


                    .HasDefaultValueSql("('1')");




                entity.Property(e => e.Modifytime)


                    .HasColumnType("datetime")


                    .HasColumnName("modifytime")


                    .HasDefaultValueSql("(getdate())");




                entity.Property(e => e.OperationalMatters).HasMaxLength(500);




                entity.Property(e => e.RecStatus)


                    .IsRequired()


                    .HasMaxLength(1)


                    .HasColumnName("rec_status")


                    .HasDefaultValueSql("('A')");




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




                entity.Property(e => e.Remark).HasMaxLength(500);


            });




            modelBuilder.Entity<AdmAskJiaojie>(entity =>


@@ -1778,6 +1856,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")


@@ -1890,6 +1972,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 =>


@@ -2010,6 +2202,18 @@


                    .HasColumnType("numeric(18, 2)")


                    .HasColumnName("money")


                    .HasComment("金额");




                entity.Property(e => e.Jichumoney)


                   .HasColumnType("numeric(18, 2)")


                   .HasColumnName("jichumoney");




                entity.Property(e => e.Xmcode)


                   .HasMaxLength(50)


                   .HasColumnName("xmcode");




                entity.Property(e => e.Xmname)


                .HasMaxLength(500)


                .HasColumnName("xmname");




                entity.Property(e => e.OrderNo)


                    .HasMaxLength(100)


@@ -2441,6 +2645,21 @@


                    .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<CusFangwenjilu>(entity =>


@@ -2615,6 +2834,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);


            });


@@ -2844,6 +3129,10 @@


                    .HasColumnName("danjia")


                    .HasComment("单价");




                entity.Property(e => e.Jifen)


                   .HasColumnType("money")


                   .HasColumnName("jifen");




                entity.Property(e => e.Modifier)


                    .IsRequired()


                    .HasMaxLength(50)


@@ -2883,6 +3172,10 @@


                    .HasColumnType("money")


                    .HasColumnName("huifei")


                    .HasComment("会费");




                entity.Property(e => e.Jifen)


                    .HasColumnType("money")


                    .HasColumnName("jifen");




                entity.Property(e => e.MemberAuthority)


                    .HasMaxLength(500)


@@ -2933,6 +3226,10 @@


                    .HasColumnType("money")


                    .HasColumnName("feiyong")


                    .HasComment("费用");




                entity.Property(e => e.Jifen)


                  .HasColumnType("money")


                  .HasColumnName("jifen");




                entity.Property(e => e.Modifier)


                    .IsRequired()


@@ -3576,6 +3873,49 @@


                entity.Property(e => e.Yufagongziheji)


                    .HasColumnType("decimal(18, 4)")


                    .HasColumnName("yufagongziheji");


            });




            modelBuilder.Entity<HrShebao>(entity =>


            {


                entity.ToTable("hr_shebao");




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




                entity.Property(e => e.Creater)


                    .IsRequired()


                    .HasMaxLength(50)


                    .HasColumnName("creater")


                    .HasDefaultValueSql("('1')");




                entity.Property(e => e.Createtime)


                    .HasColumnType("datetime")


                    .HasColumnName("createtime")


                    .HasDefaultValueSql("(getdate())");




                entity.Property(e => e.Modifier)


                    .IsRequired()


                    .HasMaxLength(50)


                    .HasColumnName("modifier")


                    .HasDefaultValueSql("('1')");




                entity.Property(e => e.Modifytime)


                    .HasColumnType("datetime")


                    .HasColumnName("modifytime")


                    .HasDefaultValueSql("(getdate())");




                entity.Property(e => e.RecStatus)


                    .IsRequired()


                    .HasMaxLength(1)


                    .HasColumnName("rec_status")


                    .HasDefaultValueSql("('A')");




                entity.Property(e => e.Shebaodanwei)


                    .HasColumnType("money")


                    .HasColumnName("shebaodanwei");




                entity.Property(e => e.Shebaogeren)


                    .HasColumnType("money")


                    .HasColumnName("shebaogeren");


            });




            modelBuilder.Entity<IntentionCustomer>(entity =>


@@ -4336,6 +4676,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 =>


@@ -4369,6 +4717,10 @@


                    .HasColumnType("money")


                    .HasColumnName("jine");




                entity.Property(e => e.Jifen)


                 .HasColumnType("money")


                 .HasColumnName("jifen");




                entity.Property(e => e.Kechengleixing)


                    .HasMaxLength(100)


                    .HasColumnName("kechengleixing");


@@ -4399,6 +4751,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()


@@ -4886,6 +5242,8 @@


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




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




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




                entity.Property(e => e.ShiyongPrice).HasColumnType("numeric(18, 2)");




@@ -5459,11 +5817,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)


@@ -6066,7 +6424,6 @@


                    .HasColumnName("expertType");




                entity.Property(e => e.IdCard)


                    .IsRequired()


                    .HasMaxLength(18)


                    .HasColumnName("idCard");




@@ -6118,6 +6475,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");


@@ -6125,7 +6486,6 @@


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




                entity.Property(e => e.Sex)


                    .IsRequired()


                    .HasMaxLength(50)


                    .HasColumnName("sex");




@@ -6271,6 +6631,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 =>


            {


@@ -6428,6 +7060,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);


        }