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 | 237 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 230 insertions(+), 7 deletions(-)
diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs
index e60d401..c6bf6f2 100644
--- a/zhengcaioa/Model/zhengcaioaContext.cs
+++ b/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; }
@@ -133,6 +134,11 @@
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)
@@ -140,7 +146,7 @@
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");
}
}
@@ -2626,6 +2632,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 =>
@@ -2800,6 +2821,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);
});
@@ -4628,6 +4715,10 @@
.HasMaxLength(100)
.HasColumnName("person_id");
+ entity.Property(e => e.OrderId)
+ .HasMaxLength(100)
+ .HasColumnName("order_id");
+
entity.Property(e => e.RecStatus)
.IsRequired()
.HasMaxLength(1)
@@ -5114,6 +5205,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)");
@@ -6943,12 +7036,16 @@
.HasColumnName("challenge_id");
entity.Property(e => e.Evidential)
- .HasMaxLength(300)
+ .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)
@@ -7087,12 +7184,16 @@
.HasColumnName("complaint_id");
entity.Property(e => e.Evidential)
- .HasMaxLength(300)
+ .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)
@@ -7186,9 +7287,13 @@
.HasMaxLength(10)
.HasColumnName("gys_postcode");
- entity.Property(e => e.IsNotice).HasColumnName("is_notice");
+ entity.Property(e => e.IsNotice)
+ .HasMaxLength(1)
+ .HasColumnName("is_notice");
- entity.Property(e => e.IsResultnotice).HasColumnName("is_resultnotice");
+ entity.Property(e => e.IsResultnotice)
+ .HasMaxLength(1)
+ .HasColumnName("is_resultnotice");
entity.Property(e => e.Modifier)
.HasMaxLength(50)
@@ -7213,7 +7318,7 @@
.HasColumnName("purchaser_name");
entity.Property(e => e.Questioned)
- .HasMaxLength(50)
+ .HasMaxLength(300)
.HasColumnName("questioned");
entity.Property(e => e.RequestInfo)
@@ -7225,7 +7330,7 @@
.HasColumnName("respond_date");
entity.Property(e => e.Respondent)
- .HasMaxLength(50)
+ .HasMaxLength(300)
.HasColumnName("respondent");
entity.Property(e => e.ResultnoticeDate)
@@ -7295,6 +7400,124 @@
.HasColumnName("xm_package");
});
+ modelBuilder.Entity<TComplaintGongyingshang>(entity =>
+ {
+ entity.ToTable("t_complaint_gongyingshang");
+
+ entity.Property(e => e.Id).HasColumnName("id");
+
+ entity.Property(e => e.ComplaintId)
+ .HasMaxLength(50)
+ .HasColumnName("complaint_id");
+
+ entity.Property(e => e.Dizhi)
+ .HasMaxLength(300)
+ .HasColumnName("dizhi");
+
+ entity.Property(e => e.Gongytingshang)
+ .HasMaxLength(300)
+ .HasColumnName("gongytingshang");
+
+ entity.Property(e => e.Lianxidianhua)
+ .HasMaxLength(300)
+ .HasColumnName("lianxidianhua");
+
+ entity.Property(e => e.Lianxiren)
+ .HasMaxLength(300)
+ .HasColumnName("lianxiren");
+
+ entity.Property(e => e.Sort).HasColumnName("sort");
+
+ entity.Property(e => e.Youbian)
+ .HasMaxLength(300)
+ .HasColumnName("youbian");
+ });
+
+ modelBuilder.Entity<TComplaintShouquandaibiao>(entity =>
+ {
+ entity.ToTable("t_complaint_shouquandaibiao");
+
+ entity.Property(e => e.Id).HasColumnName("id");
+
+ entity.Property(e => e.ComplaintId)
+ .HasMaxLength(50)
+ .HasColumnName("complaint_id");
+
+ entity.Property(e => e.Dizhi)
+ .HasMaxLength(300)
+ .HasColumnName("dizhi");
+
+ entity.Property(e => e.Lianxidianhua)
+ .HasMaxLength(300)
+ .HasColumnName("lianxidianhua");
+
+ entity.Property(e => e.Shouquandaibiao)
+ .HasMaxLength(300)
+ .HasColumnName("shouquandaibiao");
+
+ entity.Property(e => e.Sort).HasColumnName("sort");
+
+ entity.Property(e => e.Youbian)
+ .HasMaxLength(300)
+ .HasColumnName("youbian");
+ });
+
+
+ modelBuilder.Entity<Zxdsfxl>(entity =>
+ {
+ entity.ToTable("zxdsfxls");
+
+ entity.Property(e => e.Id).HasMaxLength(50);
+
+ entity.Property(e => e.Creater)
+ .IsRequired()
+ .HasMaxLength(50)
+ .HasColumnName("creater")
+ .HasDefaultValueSql("('1')");
+
+ entity.Property(e => e.Createtime)
+ .HasColumnType("datetime")
+ .HasColumnName("createtime")
+ .HasDefaultValueSql("(getdate())");
+
+ entity.Property(e => e.Huiyuanid)
+ .HasMaxLength(50)
+ .HasColumnName("huiyuanid");
+
+ entity.Property(e => e.Huiyuanname)
+ .HasMaxLength(100)
+ .HasColumnName("huiyuanname");
+
+ entity.Property(e => e.Leixing)
+ .HasMaxLength(1)
+ .HasColumnName("leixing");
+
+ entity.Property(e => e.Modifier)
+ .IsRequired()
+ .HasMaxLength(50)
+ .HasColumnName("modifier")
+ .HasDefaultValueSql("('1')");
+
+ entity.Property(e => e.Modifytime)
+ .HasColumnType("datetime")
+ .HasColumnName("modifytime")
+ .HasDefaultValueSql("(getdate())");
+
+ entity.Property(e => e.RecStatus)
+ .IsRequired()
+ .HasMaxLength(1)
+ .HasColumnName("rec_status")
+ .HasDefaultValueSql("('A')");
+
+ entity.Property(e => e.Token)
+ .HasMaxLength(500)
+ .HasColumnName("token");
+
+ entity.Property(e => e.Visittime)
+ .HasColumnType("datetime")
+ .HasColumnName("visittime");
+ });
+
OnModelCreatingPartial(modelBuilder);
}
--
Gitblit v1.9.1