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 | 313 ++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 313 insertions(+), 0 deletions(-)
diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs
index 3cce961..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)
@@ -37,6 +38,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; }
@@ -60,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; }
@@ -91,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; }
@@ -102,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; }
@@ -856,6 +864,81 @@
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 =>
{
entity.ToTable("ADM_AskMarketingCost");
@@ -950,6 +1033,11 @@
entity.Property(e => e.Kuanggong)
.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()
@@ -1057,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()
@@ -2643,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")
@@ -2677,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 =>
@@ -3617,6 +3804,10 @@
.HasColumnType("money")
.HasColumnName("jibengongzi");
+ entity.Property(e => e.Jiabangongzi)
+ .HasColumnType("money")
+ .HasColumnName("jiabangongzi");
+
entity.Property(e => e.Modifier)
.IsRequired()
.HasMaxLength(50)
@@ -4018,6 +4209,10 @@
.HasColumnName("khlx")
.HasComment("瀹㈡埛绫诲瀷");
+ entity.Property(e => e.HuiyuanId)
+ .HasMaxLength(50)
+ .HasColumnName("huiyuanId");
+
entity.Property(e => e.Khly)
.HasMaxLength(50)
.HasColumnName("khly")
@@ -4110,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);
@@ -4627,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");
@@ -4738,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");
@@ -4790,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 =>
@@ -5261,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)");
@@ -5769,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