From 0e6d0e8975e92a6395d2d9f692edd5a7d0984c5a Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期三, 15 六月 2022 08:39:59 +0800 Subject: [PATCH] 爬虫 --- zhengcaioa/Model/zhengcaioaContext.cs | 70 +++++++++++++++++++++++++++++++++- 1 files changed, 67 insertions(+), 3 deletions(-) diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index 53daa49..c6bf6f2 100644 --- a/zhengcaioa/Model/zhengcaioaContext.cs +++ b/zhengcaioa/Model/zhengcaioaContext.cs @@ -138,12 +138,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"); } } @@ -2641,6 +2644,9 @@ entity.Property(e => e.Shenyushouxin) .HasColumnType("money") .HasColumnName("shenyushouxin"); + entity.Property(e => e.Taocanjianshu) + .HasColumnType("int") + .HasColumnName("taocanjianshu"); }); modelBuilder.Entity<CusFangwenjilu>(entity => @@ -5200,6 +5206,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) @@ -7028,7 +7036,7 @@ .HasColumnName("challenge_id"); entity.Property(e => e.Evidential) - .HasMaxLength(300) + .HasMaxLength(4000) .HasColumnName("evidential"); entity.Property(e => e.Law) @@ -7176,7 +7184,7 @@ .HasColumnName("complaint_id"); entity.Property(e => e.Evidential) - .HasMaxLength(300) + .HasMaxLength(4000) .HasColumnName("evidential"); entity.Property(e => e.Law) @@ -7454,6 +7462,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); } -- Gitblit v1.9.1