From c28a5cd5367ba6a0d210dc897fd9a7cf6e46e570 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 03 二月 2023 09:40:06 +0800
Subject: [PATCH] 把会员系统和oa系统手机号相同的客户关联起来
---
zhengcaioa/Model/zhengcaioaContext.cs | 128 ++++++++++++++++++++++++++++++++++++++++++
1 files changed, 128 insertions(+), 0 deletions(-)
diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs
index 3cce961..fdf849e 100644
--- a/zhengcaioa/Model/zhengcaioaContext.cs
+++ b/zhengcaioa/Model/zhengcaioaContext.cs
@@ -37,6 +37,8 @@
public virtual DbSet<AdmAskMarketingCost> AdmAskMarketingCosts { get; set; }
public virtual DbSet<AdmAskovertime> AdmAskovertimes { get; set; }
public virtual DbSet<AdmAskYouHui> AdmAskYouHuis { get; set; }
+ public virtual DbSet<AdmAskzczbwsy> AdmAskzczbwsies { get; set; }
+ public virtual DbSet<AdmAskzczbwsydtl> AdmAskzczbwsydtls { get; set; }
public virtual DbSet<AdmAttendance> AdmAttendances { get; set; }
public virtual DbSet<AdmAttendanceDtl> AdmAttendanceDtls { get; set; }
public virtual DbSet<AdmAttendanceRule> AdmAttendanceRules { get; set; }
@@ -60,6 +62,8 @@
public virtual DbSet<CooperOrder> CooperOrders { get; set; }
public virtual DbSet<CooperVisit> CooperVisits { get; set; }
public virtual DbSet<CooperatecustomCustomer> CooperatecustomCustomers { get; set; }
+ public virtual DbSet<CustomerYwjl> CustomerYwjls { get; set; }
+ public virtual DbSet<CustomerGuanlian> CustomerGuanlians { get; set; }
public virtual DbSet<CusFangwenjilu> CusFangwenjilus { get; set; }
public virtual DbSet<FiAccount> FiAccounts { get; set; }
public virtual DbSet<FiAccountRecord> FiAccountRecords { get; set; }
@@ -854,6 +858,81 @@
.HasDefaultValueSql("((0))");
entity.Property(e => e.Youhuistandard).HasMaxLength(50);
+ });
+
+ modelBuilder.Entity<AdmAskzczbwsy>(entity =>
+ {
+ entity.ToTable("ADM_Askzczbwsy");
+
+ 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.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.Shiyongstandard)
+ .HasMaxLength(50)
+ .HasColumnName("shiyongstandard");
+
+ entity.Property(e => e.Tittle)
+ .HasMaxLength(50)
+ .HasColumnName("tittle");
+ });
+
+ modelBuilder.Entity<AdmAskzczbwsydtl>(entity =>
+ {
+ entity.ToTable("ADM_Askzczbwsydtl");
+
+ entity.Property(e => e.Id).HasMaxLength(50);
+
+ entity.Property(e => e.AskzczbwsyId)
+ .IsRequired()
+ .HasMaxLength(50);
+
+ entity.Property(e => e.CustomerId).HasMaxLength(50);
+
+ entity.Property(e => e.Customertype).HasMaxLength(50);
+
+ entity.Property(e => e.Customername).HasMaxLength(500);
+
+ entity.Property(e => e.Phone)
+ .HasMaxLength(500)
+ .HasColumnName("phone");
});
modelBuilder.Entity<AdmAskMarketingCost>(entity =>
@@ -2643,6 +2722,10 @@
.HasColumnType("datetime")
.HasColumnName("weixintime");
+ entity.Property(e => e.Ywjltime)
+ .HasColumnType("datetime")
+ .HasColumnName("ywjltime");
+
entity.Property(e => e.YwName)
.HasMaxLength(500)
.HasColumnName("yw_name")
@@ -2677,6 +2760,41 @@
entity.Property(e => e.Taocanjianshu)
.HasColumnType("int")
.HasColumnName("taocanjianshu");
+ });
+
+
+ modelBuilder.Entity<CustomerYwjl>(entity =>
+ {
+ entity.ToTable("Customer_Ywjl");
+
+ entity.Property(e => e.Id).HasMaxLength(50);
+
+ entity.Property(e => e.Createtime)
+ .HasColumnType("datetime")
+ .HasColumnName("createtime");
+
+ entity.Property(e => e.UserId)
+ .HasMaxLength(50)
+ .HasColumnName("userId");
+
+ entity.Property(e => e.YwjlId)
+ .HasMaxLength(50)
+ .HasColumnName("ywjlId");
+ });
+
+ modelBuilder.Entity<CustomerGuanlian>(entity =>
+ {
+ entity.ToTable("CustomerGuanlian");
+
+ entity.Property(e => e.Id).HasMaxLength(50);
+
+ entity.Property(e => e.CustomerId).HasMaxLength(50);
+
+ entity.Property(e => e.Customertype).HasMaxLength(50);
+
+ entity.Property(e => e.SecCustomerId).HasMaxLength(50);
+
+ entity.Property(e => e.SecCustomertype).HasMaxLength(50);
});
modelBuilder.Entity<CusFangwenjilu>(entity =>
@@ -4018,6 +4136,10 @@
.HasColumnName("khlx")
.HasComment("瀹㈡埛绫诲瀷");
+ entity.Property(e => e.HuiyuanId)
+ .HasMaxLength(50)
+ .HasColumnName("huiyuanId");
+
entity.Property(e => e.Khly)
.HasMaxLength(50)
.HasColumnName("khly")
@@ -4110,6 +4232,10 @@
entity.Property(e => e.Weixintime)
.HasColumnType("datetime")
.HasColumnName("weixintime");
+
+ entity.Property(e => e.Ywjltime)
+ .HasColumnType("datetime")
+ .HasColumnName("ywjltime");
entity.Property(e => e.Yixiang).HasMaxLength(50);
@@ -5262,6 +5388,8 @@
entity.Property(e => e.HetongDateEnd).HasColumnType("datetime");
+ entity.Property(e => e.FenpeiDate).HasColumnType("datetime");
+
entity.Property(e => e.ShiyongPrice).HasColumnType("numeric(18, 2)");
entity.Property(e => e.Tel)
--
Gitblit v1.9.1