班次分组和横幅ID

username@email.com

2023-12-14 78b0883ddf8329fa8693d78b01e1e0a7f5b6972e

 zhengcaioa/Model/zhengcaioaContext.cs

@@ -10,6 +10,7 @@
    {
        public zhengcaioaContext()
        {
            this.Database.SetCommandTimeout(60);
        }

        public zhengcaioaContext(DbContextOptions<zhengcaioaContext> options)
@@ -62,6 +63,9 @@
        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<CustomerGuanlianhuiyuan> CustomerGuanlianhuiyuans { 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; }
@@ -93,6 +97,7 @@
        public virtual DbSet<OrderBanci> OrderBancis { get; set; }
        public virtual DbSet<OrderBanciDtl> OrderBanciDtls { get; set; }
        public virtual DbSet<OrderBanciOrder> OrderBanciOrders { get; set; }
        public virtual DbSet<OrderBanciZuowei> OrderBanciZuoweis { get; set; }
        public virtual DbSet<PltAuth> PltAuths { get; set; }
        public virtual DbSet<PltPage> PltPages { get; set; }
        public virtual DbSet<PltRole> PltRoles { get; set; }
@@ -104,6 +109,7 @@
        public virtual DbSet<Projectreason> Projectreasons { get; set; }
        public virtual DbSet<Projectyouxiao> Projectyouxiaos { get; set; }
        public virtual DbSet<Projectzhongbiao> Projectzhongbiaos { get; set; }
        public virtual DbSet<Projectfasongxiaoxi> Projectfasongxiaoxis { get; set; }
        public virtual DbSet<SysAttachment> SysAttachments { get; set; }
        public virtual DbSet<SysBaimingdan> SysBaimingdans { get; set; }
        public virtual DbSet<SysCode> SysCodes { get; set; }
@@ -1028,6 +1034,11 @@
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("kuanggong");

                entity.Property(e => e.Daixinjia)
                  .HasColumnType("decimal(18, 4)")
                  .HasColumnName("daixinjia")
                  .HasDefaultValueSql("(0)");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
@@ -1134,6 +1145,11 @@
                entity.Property(e => e.Qingjia)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("qingjia");

                entity.Property(e => e.Daixinjia)
                 .HasColumnType("decimal(18, 4)")
                 .HasColumnName("daixinjia")
                 .HasDefaultValueSql("(0)");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
@@ -2720,6 +2736,18 @@
                    .HasColumnType("datetime")
                    .HasColumnName("weixintime");

                entity.Property(e => e.Kuaidistatus)
                    .HasMaxLength(1)
                    .HasColumnName("kuaidistatus");

                entity.Property(e => e.Kuaiditime)
                    .HasColumnType("datetime")
                    .HasColumnName("kuaiditime");

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

                entity.Property(e => e.YwName)
                    .HasMaxLength(500)
                    .HasColumnName("yw_name")
@@ -2754,6 +2782,88 @@
                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<CustomerGuanlianhuiyuan>(entity =>
            {
                entity.ToTable("CustomerGuanlianhuiyuan");

                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.Customerid)
                    .HasMaxLength(50)
                    .HasColumnName("customerid");

                entity.Property(e => e.Customertype)
                    .HasMaxLength(50)
                    .HasColumnName("customertype");

                entity.Property(e => e.Huiyuanid)
                    .HasMaxLength(50)
                    .HasColumnName("huiyuanid");

                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')");
            });

            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 =>
@@ -3694,6 +3804,10 @@
                    .HasColumnType("money")
                    .HasColumnName("jibengongzi");

                entity.Property(e => e.Jiabangongzi)
                   .HasColumnType("money")
                   .HasColumnName("jiabangongzi");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
@@ -4191,6 +4305,18 @@
                entity.Property(e => e.Weixintime)
                    .HasColumnType("datetime")
                    .HasColumnName("weixintime");

                entity.Property(e => e.Kuaidistatus)
                  .HasMaxLength(1)
                  .HasColumnName("kuaidistatus");

                entity.Property(e => e.Kuaiditime)
                    .HasColumnType("datetime")
                    .HasColumnName("kuaiditime");

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

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

@@ -4708,6 +4834,19 @@
                entity.Property(e => e.Renshu)
                    .HasColumnName("renshu");

                entity.Property(e => e.Hang)
                  .HasColumnName("hang");

                entity.Property(e => e.Lie)
                  .HasColumnName("lie");

                entity.Property(e => e.Fenzu)
               .HasColumnName("Fenzu");

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

                entity.Property(e => e.Shijian)
                    .HasColumnType("datetime")
                    .HasColumnName("shijian");
@@ -4819,6 +4958,14 @@
                 .HasColumnType("money")
                 .HasColumnName("jifen");

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

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

                entity.Property(e => e.Kechengleixing)
                    .HasMaxLength(100)
                    .HasColumnName("kechengleixing");
@@ -4871,6 +5018,61 @@
                entity.Property(e => e.Xuefei)
                    .HasColumnType("money")
                    .HasColumnName("xuefei");
            });

            modelBuilder.Entity<OrderBanciZuowei>(entity =>
            {
                entity.ToTable("order_banci_zuowei");

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

                entity.Property(e => e.BanciId)
                    .HasMaxLength(50)
                    .HasColumnName("banciId");

                entity.Property(e => e.ColNo).HasColumnName("colNo");

                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.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.RowNo).HasColumnName("rowNo");

                entity.Property(e => e.SeatNo)
                    .HasMaxLength(50)
                    .HasColumnName("seatNo");

                entity.Property(e => e.Status)
                    .HasMaxLength(1)
                    .HasColumnName("status");

                entity.Property(e => e.ZuoweiId)
                    .HasMaxLength(50)
                    .HasColumnName("zuoweiId");
            });

            modelBuilder.Entity<PltAuth>(entity =>
@@ -5342,6 +5544,8 @@
                entity.Property(e => e.ShiyongDateEnd).HasColumnType("datetime");

                entity.Property(e => e.HetongDateEnd).HasColumnType("datetime");

                entity.Property(e => e.FenpeiDate).HasColumnType("datetime");

                entity.Property(e => e.ShiyongPrice).HasColumnType("numeric(18, 2)");

@@ -5850,6 +6054,41 @@
                    .HasColumnName("zb_zhiyistatus");
            });

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

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

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

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

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

                entity.Property(e => e.RecStatus)
                    .HasMaxLength(1)
                    .HasColumnName("rec_status");

                entity.Property(e => e.Xiaoxileixing)
                    .HasMaxLength(50)
                    .HasColumnName("xiaoxileixing");

                entity.Property(e => e.Xiaoxizhonglei)
                    .HasMaxLength(50)
                    .HasColumnName("xiaoxizhonglei");

                entity.Property(e => e.Gyszl)
                   .HasMaxLength(50)
                   .HasColumnName("gyszl");

                entity.Property(e => e.Khname)
                  .HasMaxLength(50)
                  .HasColumnName("khname");
            });

            modelBuilder.Entity<SysAttachment>(entity =>
            {
                entity.ToTable("sys_attachment");