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 | 224 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 224 insertions(+), 0 deletions(-)
diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs
index cde8ff5..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)
@@ -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,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");
@@ -2758,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 =>
@@ -3698,6 +3804,10 @@
.HasColumnType("money")
.HasColumnName("jibengongzi");
+ entity.Property(e => e.Jiabangongzi)
+ .HasColumnType("money")
+ .HasColumnName("jiabangongzi");
+
entity.Property(e => e.Modifier)
.IsRequired()
.HasMaxLength(50)
@@ -4195,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")
@@ -4716,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");
@@ -4827,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");
@@ -4879,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 =>
@@ -5350,6 +5537,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)");
@@ -5858,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