业务经理意向和合作客户只能1000，90天意向不转合作就制空业务经理，查询没有业务经理的档案客户和合作客户

username@email.com

2023-01-04 5421f9a6e5e2b28cc32aa8aa6dec9becd0c1eb3c

 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; }
@@ -49,6 +51,7 @@
        public virtual DbSet<AdmDocBase> AdmDocBases { get; set; }
        public virtual DbSet<AdmDocDoc> AdmDocDocs { get; set; }
        public virtual DbSet<AdmEvaluate> AdmEvaluates { get; set; }
        public virtual DbSet<AdmPhoneMessage> AdmPhoneMessages { get; set; }
        public virtual DbSet<AdmGoodsClassify> AdmGoodsClassifies { get; set; }
        public virtual DbSet<AdmGoodsManage> AdmGoodsManages { get; set; }
        public virtual DbSet<AdmPieceCheck> AdmPieceChecks { get; set; }
@@ -853,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 =>
@@ -1778,6 +1856,22 @@
                    .HasComment("人员id");
            });

            modelBuilder.Entity<AdmPhoneMessage>(entity =>
            {
                entity.ToTable("ADM_PhoneMessage");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Phone).HasMaxLength(50);
                entity.Property(e => e.Message).HasColumnName("message").HasMaxLength(100);
                
            });

            modelBuilder.Entity<AdmGoodsClassify>(entity =>
            {
                entity.ToTable("adm_goods_classify");
@@ -2625,6 +2719,10 @@
                entity.Property(e => e.Weixintime)
                    .HasColumnType("datetime")
                    .HasColumnName("weixintime");

                entity.Property(e => e.Ywjltime)
                    .HasColumnType("datetime")
                    .HasColumnName("ywjltime");

                entity.Property(e => e.YwName)
                    .HasMaxLength(500)
@@ -4001,6 +4099,10 @@
                    .HasColumnName("khlx")
                    .HasComment("客户类型");

                entity.Property(e => e.HuiyuanId)
                   .HasMaxLength(50)
                   .HasColumnName("huiyuanId");

                entity.Property(e => e.Khly)
                    .HasMaxLength(50)
                    .HasColumnName("khly")
@@ -4094,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");