From 558dae4a18d393ac38daa43a354e8bc9a22e4e26 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期四, 02 十一月 2023 16:52:59 +0800
Subject: [PATCH] 班次安排座位

---
 zhengcaioa/Model/zhengcaioaContext.cs |  185 ++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 185 insertions(+), 0 deletions(-)

diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs
index fdf849e..3327256 100644
--- a/zhengcaioa/Model/zhengcaioaContext.cs
+++ b/zhengcaioa/Model/zhengcaioaContext.cs
@@ -10,6 +10,7 @@
     {
         public zhengcaioaContext()
         {
+            this.Database.SetCommandTimeout(60);
         }
 
         public zhengcaioaContext(DbContextOptions<zhengcaioaContext> options)
@@ -63,6 +64,7 @@
         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; }
@@ -95,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; }
@@ -106,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; }
@@ -1030,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)
@@ -1136,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()
@@ -2722,6 +2736,14 @@
                     .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");
@@ -2780,6 +2802,53 @@
                 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 =>
@@ -3735,6 +3804,10 @@
                     .HasColumnType("money")
                     .HasColumnName("jibengongzi");
 
+                entity.Property(e => e.Jiabangongzi)
+                   .HasColumnType("money")
+                   .HasColumnName("jiabangongzi");
+
                 entity.Property(e => e.Modifier)
                     .IsRequired()
                     .HasMaxLength(50)
@@ -4232,6 +4305,14 @@
                 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")
@@ -4753,6 +4834,12 @@
                 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.Shijian)
                     .HasColumnType("datetime")
                     .HasColumnName("shijian");
@@ -4864,6 +4951,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");
@@ -4916,6 +5011,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 =>
@@ -5897,6 +6047,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");

--
Gitblit v1.9.1