From 5421f9a6e5e2b28cc32aa8aa6dec9becd0c1eb3c Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期三, 04 一月 2023 10:19:57 +0800 Subject: [PATCH] 业务经理意向和合作客户只能1000,90天意向不转合作就制空业务经理,查询没有业务经理的档案客户和合作客户 --- zhengcaioa/Model/zhengcaioaContext.cs | 89 ++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 89 insertions(+), 0 deletions(-) diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index 3cce961..cde8ff5 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; } @@ -854,6 +856,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 +2720,10 @@ .HasColumnType("datetime") .HasColumnName("weixintime"); + entity.Property(e => e.Ywjltime) + .HasColumnType("datetime") + .HasColumnName("ywjltime"); + entity.Property(e => e.YwName) .HasMaxLength(500) .HasColumnName("yw_name") @@ -4018,6 +4099,10 @@ .HasColumnName("khlx") .HasComment("瀹㈡埛绫诲瀷"); + entity.Property(e => e.HuiyuanId) + .HasMaxLength(50) + .HasColumnName("huiyuanId"); + entity.Property(e => e.Khly) .HasMaxLength(50) .HasColumnName("khly") @@ -4111,6 +4196,10 @@ .HasColumnType("datetime") .HasColumnName("weixintime"); + entity.Property(e => e.Ywjltime) + .HasColumnType("datetime") + .HasColumnName("ywjltime"); + entity.Property(e => e.Yixiang).HasMaxLength(50); entity.Property(e => e.Yixiangtime).HasColumnType("datetime"); -- Gitblit v1.9.1