From ef80d35cdbabf2ac5fd83f84714b4254e6444fef Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期二, 28 九月 2021 14:22:27 +0800
Subject: [PATCH] 通讯录，账号密码
---
zhengcaioa/Model/zhengcaioaContext.cs | 541 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 540 insertions(+), 1 deletions(-)
diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs
index 5b551f4..b031650 100644
--- a/zhengcaioa/Model/zhengcaioaContext.cs
+++ b/zhengcaioa/Model/zhengcaioaContext.cs
@@ -24,18 +24,24 @@
public virtual DbSet<HrSalaryAppeal> HrSalaryAppeal { get; set; }
public virtual DbSet<SimCostYearView> SimCostYearView { get; set; }
+ public virtual DbSet<AdmAskBaiFang> AdmAskBaiFangs { get; set; }
public virtual DbSet<AdmAskCar> AdmAskCars { get; set; }
+ public virtual DbSet<AdmAskCiZhi> AdmAskCiZhis { get; set; }
public virtual DbSet<AdmAskcost> AdmAskcosts { get; set; }
public virtual DbSet<AdmAskGood> AdmAskGoods { get; set; }
+ public virtual DbSet<AdmAskJiaojie> AdmAskJiaojies { get; set; }
+ public virtual DbSet<AdmAskJiaojieDtl> AdmAskJiaojieDtls { get; set; }
public virtual DbSet<AdmAskLeave> AdmAskLeaves { get; set; }
public virtual DbSet<AdmAskLeaveOff> AdmAskLeaveOffs { get; set; }
public virtual DbSet<AdmAskMarketingCost> AdmAskMarketingCosts { get; set; }
public virtual DbSet<AdmAskovertime> AdmAskovertimes { get; set; }
+ public virtual DbSet<AdmAskYouHui> AdmAskYouHuis { get; set; }
public virtual DbSet<AdmAttendance> AdmAttendances { get; set; }
public virtual DbSet<AdmAttendanceDtl> AdmAttendanceDtls { get; set; }
public virtual DbSet<AdmAttendanceRule> AdmAttendanceRules { get; set; }
public virtual DbSet<AdmAttendanceRulesDtl> AdmAttendanceRulesDtls { get; set; }
public virtual DbSet<AdmBreakPrecedent> AdmBreakPrecedents { get; set; }
+ public virtual DbSet<AdmCustomerWithdrawal> AdmCustomerWithdrawals { get; set; }
public virtual DbSet<AdmHoldPhone> AdmHoldPhones { get; set; }
public virtual DbSet<AdmMemoBook> AdmMemoBooks { get; set; }
public virtual DbSet<AdmSignIn> AdmSignIns { get; set; }
@@ -45,6 +51,8 @@
public virtual DbSet<AdmGoodsClassify> AdmGoodsClassifies { get; set; }
public virtual DbSet<AdmGoodsManage> AdmGoodsManages { get; set; }
public virtual DbSet<AdmPieceCheck> AdmPieceChecks { get; set; }
+ public virtual DbSet<AdmTongxunlu> AdmTongxunlus { get; set; }
+ public virtual DbSet<AdmZhanghaomima> AdmZhanghaomimas { get; set; }
public virtual DbSet<Area> Areas { get; set; }
public virtual DbSet<Cgf> Cgfs { get; set; }
public virtual DbSet<CooperOrder> CooperOrders { get; set; }
@@ -91,6 +99,7 @@
public virtual DbSet<Projectyouxiao> Projectyouxiaos { get; set; }
public virtual DbSet<Projectzhongbiao> Projectzhongbiaos { get; set; }
public virtual DbSet<SysAttachment> SysAttachments { get; set; }
+ public virtual DbSet<SysBaimingdan> SysBaimingdans { get; set; }
public virtual DbSet<SysCode> SysCodes { get; set; }
public virtual DbSet<SysCodeDtl> SysCodeDtls { get; set; }
public virtual DbSet<Systemsetting> Systemsettings { get; set; }
@@ -122,6 +131,64 @@
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.HasAnnotation("Relational:Collation", "Chinese_PRC_CI_AS");
+
+ modelBuilder.Entity<AdmAskBaiFang>(entity =>
+ {
+ entity.ToTable("ADM_AskBaiFang");
+
+ entity.Property(e => e.Id).HasMaxLength(50);
+
+ entity.Property(e => e.BaiFangtime).HasColumnType("datetime");
+
+ 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.CustomerId).HasMaxLength(500);
+
+ entity.Property(e => e.Jtype).HasMaxLength(50);
+
+ 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.Tittle)
+ .HasMaxLength(50)
+ .HasColumnName("tittle");
+
+ entity.Property(e => e.VisType).HasMaxLength(50);
+ });
modelBuilder.Entity<AdmAskCar>(entity =>
{
@@ -168,6 +235,70 @@
.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.Tittle)
+ .HasMaxLength(50)
+ .HasColumnName("tittle");
+ });
+
+ modelBuilder.Entity<AdmAskCiZhi>(entity =>
+ {
+ entity.ToTable("ADM_AskCiZhi");
+
+ 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.CreatetimeName).HasMaxLength(50);
+
+ entity.Property(e => e.DeptName).HasMaxLength(50);
+
+ 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.OrderType).HasMaxLength(50);
+
+ entity.Property(e => e.Outtime).HasColumnType("datetime");
+
+ entity.Property(e => e.PostName).HasMaxLength(50);
+
+ entity.Property(e => e.RecStatus)
+ .IsRequired()
+ .HasMaxLength(1)
+ .HasColumnName("rec_status")
+ .HasDefaultValueSql("('A')");
+
+ entity.Property(e => e.Remark).HasMaxLength(2000);
+
+ entity.Property(e => e.RuzhitimeName).HasMaxLength(50);
+
+ entity.Property(e => e.JiaojieUser).HasMaxLength(500);
entity.Property(e => e.ShenpiStatus)
.HasMaxLength(1)
@@ -287,6 +418,112 @@
entity.Property(e => e.Tittle)
.HasMaxLength(50)
.HasColumnName("tittle");
+ });
+
+ modelBuilder.Entity<AdmAskJiaojie>(entity =>
+ {
+ entity.ToTable("ADM_AskJiaojie");
+
+ entity.Property(e => e.Id).HasMaxLength(50);
+
+ entity.Property(e => e.CiZhiId).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.Tittle)
+ .HasMaxLength(50)
+ .HasColumnName("tittle");
+ });
+
+ modelBuilder.Entity<AdmAskJiaojieDtl>(entity =>
+ {
+ entity.ToTable("ADM_AskJiaojieDtl");
+
+ 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.JiaojieId).HasMaxLength(50);
+
+ entity.Property(e => e.JiaojieNeirong).HasMaxLength(500);
+
+ entity.Property(e => e.JiaojieStatus)
+ .HasMaxLength(1)
+ .HasColumnName("jiaojie_status")
+ .HasDefaultValueSql("('D')");
+
+ entity.Property(e => e.JiaojieType).HasMaxLength(50);
+
+ entity.Property(e => e.JiaojieUserId).HasMaxLength(50);
+
+ entity.Property(e => e.Jiaojietime).HasColumnType("datetime");
+
+ entity.Property(e => e.JieShoutime).HasColumnType("datetime");
+
+ entity.Property(e => e.Kehudanwei).HasMaxLength(500);
+
+ 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<AdmAskLeave>(entity =>
@@ -482,11 +719,75 @@
.HasColumnName("tittle");
});
+ modelBuilder.Entity<AdmAskYouHui>(entity =>
+ {
+ entity.ToTable("ADM_AskYouHui");
+
+ 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.CustomerId).HasMaxLength(50);
+
+ 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.OrderType).HasMaxLength(50);
+
+ 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.Tittle)
+ .HasMaxLength(50)
+ .HasColumnName("tittle");
+
+ entity.Property(e => e.YouHui)
+ .HasColumnType("money")
+ .HasDefaultValueSql("((0))");
+
+ entity.Property(e => e.Youhuistandard).HasMaxLength(50);
+ });
+
modelBuilder.Entity<AdmAskMarketingCost>(entity =>
{
entity.ToTable("ADM_AskMarketingCost");
entity.Property(e => e.Id).HasMaxLength(50);
+
+ entity.Property(e => e.BreakPrecedentId)
+ .HasMaxLength(50)
+ .HasColumnName("break_precedentId");
entity.Property(e => e.Creater)
.IsRequired()
@@ -962,6 +1263,78 @@
.HasComment("鍛樺伐");
});
+ modelBuilder.Entity<AdmCustomerWithdrawal>(entity =>
+ {
+ entity.ToTable("ADM_Customer_withdrawal");
+
+ 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.HuiyuanId).HasMaxLength(50);
+
+ entity.Property(e => e.HuiyuanName).HasMaxLength(100);
+
+ entity.Property(e => e.HuiyuanPhone).HasMaxLength(50);
+
+ entity.Property(e => e.BankAcount).HasMaxLength(50);
+
+ entity.Property(e => e.BankName).HasMaxLength(50);
+
+ entity.Property(e => e.Username).HasMaxLength(50);
+
+ entity.Property(e => e.Jine)
+ .HasColumnType("money")
+ .HasDefaultValueSql("((0))");
+
+ 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.OrderNo).HasMaxLength(50);
+
+ 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.Shenqingtime)
+ .HasColumnType("datetime")
+ .HasDefaultValueSql("(getdate())");
+
+ entity.Property(e => e.Tittle)
+ .HasMaxLength(50)
+ .HasColumnName("tittle");
+ });
+
modelBuilder.Entity<AdmHoldPhone>(entity =>
{
entity.ToTable("ADM_HoldPhone");
@@ -1423,6 +1796,11 @@
.HasDefaultValueSql("('A')")
.HasComment("鐗╁搧鐘舵��");
+ entity.Property(e => e.HaocaiStatus)
+ .HasMaxLength(1)
+ .HasColumnName("haocai_status")
+ .HasDefaultValueSql("('D')");
+
entity.Property(e => e.Modifier)
.IsRequired()
.HasMaxLength(50)
@@ -1514,6 +1892,116 @@
.HasColumnName("work_time")
.HasDefaultValueSql("(getdate())")
.HasComment("宸ヤ綔鏃堕棿");
+ });
+
+ modelBuilder.Entity<AdmTongxunlu>(entity =>
+ {
+ entity.ToTable("adm_tongxunlu");
+
+ entity.Property(e => e.Id).HasMaxLength(50);
+
+ entity.Property(e => e.Beuzhu)
+ .HasMaxLength(500)
+ .HasColumnName("beuzhu");
+
+ 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.DanweiName)
+ .HasMaxLength(100)
+ .HasColumnName("danwei_name");
+
+ entity.Property(e => e.Lianxidianhua)
+ .HasMaxLength(100)
+ .HasColumnName("lianxidianhua");
+
+ entity.Property(e => e.Lianxiren)
+ .HasMaxLength(100)
+ .HasColumnName("lianxiren");
+
+ 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.TypeId)
+ .HasMaxLength(50)
+ .HasColumnName("type_id");
+ });
+
+ modelBuilder.Entity<AdmZhanghaomima>(entity =>
+ {
+ entity.ToTable("adm_zhanghaomima");
+
+ entity.Property(e => e.Id).HasMaxLength(50);
+
+ entity.Property(e => e.Chanpinxiangmu)
+ .HasMaxLength(100)
+ .HasColumnName("chanpinxiangmu");
+
+ 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.Mibao)
+ .HasMaxLength(100)
+ .HasColumnName("mibao");
+
+ entity.Property(e => e.Mima)
+ .HasMaxLength(100)
+ .HasColumnName("mima");
+
+ 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.TypeId)
+ .HasMaxLength(50)
+ .HasColumnName("type_id");
+
+ entity.Property(e => e.Zhanghao)
+ .HasMaxLength(100)
+ .HasColumnName("zhanghao");
});
modelBuilder.Entity<Area>(entity =>
@@ -3693,7 +4181,7 @@
.HasColumnName("shenhetime");
entity.Property(e => e.Shiyongfatiao)
- .HasMaxLength(500)
+ .HasMaxLength(1000)
.HasColumnName("shiyongfatiao");
});
modelBuilder.Entity<LiaotianShoucang>(entity =>
@@ -4735,6 +5223,10 @@
.HasColumnType("money")
.HasColumnName("drhx_defen");
+ entity.Property(e => e.Caigouyusuan)
+ .HasColumnType("money")
+ .HasColumnName("caigouyusuan");
+
entity.Property(e => e.DrhxPrice)
.HasMaxLength(500)
.HasColumnName("drhx_price");
@@ -4950,6 +5442,53 @@
.HasDefaultValueSql("('A')");
});
+ modelBuilder.Entity<SysBaimingdan>(entity =>
+ {
+ entity.ToTable("sys_baimingdan");
+
+ entity.Property(e => e.Id).HasMaxLength(50);
+
+ entity.Property(e => e.BaimingdanName)
+ .HasMaxLength(200)
+ .HasColumnName("baimingdan_name");
+
+ 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.PostSeq)
+ .HasMaxLength(50)
+ .HasColumnName("post_seq");
+
+ entity.Property(e => e.PostType)
+ .HasMaxLength(50)
+ .HasColumnName("post_type");
+
+ entity.Property(e => e.RecStatus)
+ .IsRequired()
+ .HasMaxLength(1)
+ .HasColumnName("rec_status")
+ .HasDefaultValueSql("('A')");
+ });
+
modelBuilder.Entity<SysCode>(entity =>
{
entity.ToTable("sys_code");
--
Gitblit v1.9.1