username@email.com
2022-09-23 dc49dcc9160780aac6a0aba280a557ec15e5a622
zhengcaioa/Model/zhengcaioaContext.cs
@@ -62,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; }
@@ -130,6 +131,7 @@
        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; }
@@ -137,12 +139,15 @@
        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");
            }
        }
@@ -2198,6 +2203,18 @@
                    .HasColumnName("money")
                    .HasComment("金额");
                entity.Property(e => e.Jichumoney)
                   .HasColumnType("numeric(18, 2)")
                   .HasColumnName("jichumoney");
                entity.Property(e => e.Xmcode)
                   .HasMaxLength(50)
                   .HasColumnName("xmcode");
                entity.Property(e => e.Xmname)
                .HasMaxLength(500)
                .HasColumnName("xmname");
                entity.Property(e => e.OrderNo)
                    .HasMaxLength(100)
                    .HasColumnName("order_no")
@@ -2628,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 =>
@@ -2802,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);
            });
@@ -3031,6 +3129,10 @@
                    .HasColumnName("danjia")
                    .HasComment("单价");
                entity.Property(e => e.Jifen)
                   .HasColumnType("money")
                   .HasColumnName("jifen");
                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
@@ -3070,6 +3172,10 @@
                    .HasColumnType("money")
                    .HasColumnName("huifei")
                    .HasComment("会费");
                entity.Property(e => e.Jifen)
                    .HasColumnType("money")
                    .HasColumnName("jifen");
                entity.Property(e => e.MemberAuthority)
                    .HasMaxLength(500)
@@ -3120,6 +3226,10 @@
                    .HasColumnType("money")
                    .HasColumnName("feiyong")
                    .HasComment("费用");
                entity.Property(e => e.Jifen)
                  .HasColumnType("money")
                  .HasColumnName("jifen");
                entity.Property(e => e.Modifier)
                    .IsRequired()
@@ -4566,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 =>
@@ -4599,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");
@@ -4629,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()
@@ -5117,6 +5243,8 @@
                entity.Property(e => e.ShiyongDateEnd).HasColumnType("datetime");
                entity.Property(e => e.HetongDateEnd).HasColumnType("datetime");
                entity.Property(e => e.ShiyongPrice).HasColumnType("numeric(18, 2)");
                entity.Property(e => e.Tel)
@@ -5296,6 +5424,10 @@
                    .HasDefaultValueSql("('')")
                    .HasComment("采购人名称");
                entity.Property(e => e.Caigouyusuan)
                    .HasColumnType("money")
                    .HasColumnName("caigouyusuan");
                entity.Property(e => e.Cgfs)
                    .HasMaxLength(50)
                    .HasColumnName("cgfs");
@@ -5333,6 +5465,30 @@
                    .HasDefaultValueSql("('')")
                    .HasComment("采购人名称");
                entity.Property(e => e.DehxTousuchengli)
                    .HasMaxLength(1)
                    .HasColumnName("dehx_tousuchengli");
                entity.Property(e => e.DehxTousushijian)
                    .HasColumnType("datetime")
                    .HasColumnName("dehx_tousushijian");
                entity.Property(e => e.DehxTousustatus)
                    .HasMaxLength(1)
                    .HasColumnName("dehx_tousustatus");
                entity.Property(e => e.DehxZhiyichengli)
                    .HasMaxLength(1)
                    .HasColumnName("dehx_zhiyichengli");
                entity.Property(e => e.DehxZhiyishijian)
                    .HasColumnType("datetime")
                    .HasColumnName("dehx_zhiyishijian");
                entity.Property(e => e.DehxZhiyistatus)
                    .HasMaxLength(1)
                    .HasColumnName("dehx_zhiyistatus");
                entity.Property(e => e.Drhx)
                    .HasMaxLength(500)
                    .HasColumnName("drhx");
@@ -5340,10 +5496,6 @@
                entity.Property(e => e.DrhxDefen)
                    .HasColumnType("money")
                    .HasColumnName("drhx_defen");
                entity.Property(e => e.Caigouyusuan)
                   .HasColumnType("money")
                   .HasColumnName("caigouyusuan");
                entity.Property(e => e.DrhxPrice)
                    .HasMaxLength(500)
@@ -5360,6 +5512,30 @@
                entity.Property(e => e.DshxPrice)
                    .HasMaxLength(500)
                    .HasColumnName("dshx_price");
                entity.Property(e => e.DshxTousuchengli)
                    .HasMaxLength(1)
                    .HasColumnName("dshx_tousuchengli");
                entity.Property(e => e.DshxTousushijian)
                    .HasColumnType("datetime")
                    .HasColumnName("dshx_tousushijian");
                entity.Property(e => e.DshxTousustatus)
                    .HasMaxLength(1)
                    .HasColumnName("dshx_tousustatus");
                entity.Property(e => e.DshxZhiyichengli)
                    .HasMaxLength(1)
                    .HasColumnName("dshx_zhiyichengli");
                entity.Property(e => e.DshxZhiyishijian)
                    .HasColumnType("datetime")
                    .HasColumnName("dshx_zhiyishijian");
                entity.Property(e => e.DshxZhiyistatus)
                    .HasMaxLength(1)
                    .HasColumnName("dshx_zhiyistatus");
                entity.Property(e => e.Fblx).HasMaxLength(500);
@@ -5451,6 +5627,30 @@
                entity.Property(e => e.Reasonremark)
                    .HasMaxLength(500)
                    .HasColumnName("reasonremark");
                entity.Property(e => e.WxTousuchengli)
                    .HasMaxLength(1)
                    .HasColumnName("wx_tousuchengli");
                entity.Property(e => e.WxTousushijian)
                    .HasColumnType("datetime")
                    .HasColumnName("wx_tousushijian");
                entity.Property(e => e.WxTousustatus)
                    .HasMaxLength(1)
                    .HasColumnName("wx_tousustatus");
                entity.Property(e => e.WxZhiyichengli)
                    .HasMaxLength(1)
                    .HasColumnName("wx_zhiyichengli");
                entity.Property(e => e.WxZhiyishijian)
                    .HasColumnType("datetime")
                    .HasColumnName("wx_zhiyishijian");
                entity.Property(e => e.WxZhiyistatus)
                    .HasMaxLength(1)
                    .HasColumnName("wx_zhiyistatus");
            });
            modelBuilder.Entity<Projectyouxiao>(entity =>
@@ -5474,6 +5674,30 @@
                entity.Property(e => e.ProjectId)
                    .IsRequired()
                    .HasMaxLength(50);
                entity.Property(e => e.YxTousuchengli)
                    .HasMaxLength(1)
                    .HasColumnName("yx_tousuchengli");
                entity.Property(e => e.YxTousushijian)
                    .HasColumnType("datetime")
                    .HasColumnName("yx_tousushijian");
                entity.Property(e => e.YxTousustatus)
                    .HasMaxLength(1)
                    .HasColumnName("yx_tousustatus");
                entity.Property(e => e.YxZhiyichengli)
                    .HasMaxLength(1)
                    .HasColumnName("yx_zhiyichengli");
                entity.Property(e => e.YxZhiyishijian)
                    .HasColumnType("datetime")
                    .HasColumnName("yx_zhiyishijian");
                entity.Property(e => e.YxZhiyistatus)
                    .HasMaxLength(1)
                    .HasColumnName("yx_zhiyistatus");
            });
            modelBuilder.Entity<Projectzhongbiao>(entity =>
@@ -5487,6 +5711,10 @@
                    .HasMaxLength(50)
                    .HasColumnName("zhongbiaoId");
                entity.Property(e => e.Defen)
                    .HasColumnType("money")
                    .HasColumnName("defen");
                entity.Property(e => e.Names)
                    .HasMaxLength(500)
                    .HasColumnName("names");
@@ -5499,8 +5727,29 @@
                    .IsRequired()
                    .HasMaxLength(50);
                entity.Property(e => e.Defen).HasColumnType("money")
                    .HasColumnName("defen"); ;
                entity.Property(e => e.ZbTousuchengli)
                    .HasMaxLength(1)
                    .HasColumnName("zb_tousuchengli");
                entity.Property(e => e.ZbTousushijian)
                    .HasColumnType("datetime")
                    .HasColumnName("zb_tousushijian");
                entity.Property(e => e.ZbTousustatus)
                    .HasMaxLength(1)
                    .HasColumnName("zb_tousustatus");
                entity.Property(e => e.ZbZhiyichengli)
                    .HasMaxLength(1)
                    .HasColumnName("zb_zhiyichengli");
                entity.Property(e => e.ZbZhiyishijian)
                    .HasColumnType("datetime")
                    .HasColumnName("zb_zhiyishijian");
                entity.Property(e => e.ZbZhiyistatus)
                    .HasMaxLength(1)
                    .HasColumnName("zb_zhiyistatus");
            });
            modelBuilder.Entity<SysAttachment>(entity =>
@@ -5693,7 +5942,7 @@
                    .HasColumnName("comments");
                entity.Property(e => e.Contents)
                    .HasMaxLength(300)
                    .HasMaxLength(500)
                    .HasColumnName("contents");
                entity.Property(e => e.Creater)
@@ -6945,7 +7194,7 @@
                    .HasColumnName("challenge_id");
                entity.Property(e => e.Evidential)
                    .HasMaxLength(300)
                    .HasMaxLength(4000)
                    .HasColumnName("evidential");
                entity.Property(e => e.Law)
@@ -6959,6 +7208,10 @@
                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");
            });
@@ -7082,6 +7335,25 @@
                    .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");
@@ -7093,7 +7365,7 @@
                    .HasColumnName("complaint_id");
                entity.Property(e => e.Evidential)
                    .HasMaxLength(300)
                    .HasMaxLength(4000)
                    .HasColumnName("evidential");
                entity.Property(e => e.Law)
@@ -7107,6 +7379,10 @@
                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");
            });
@@ -7371,6 +7647,62 @@
                    .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);
        }