From 63f97a810a8dcd213f4624533aa52f7bc2647d49 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期二, 24 八月 2021 13:50:53 +0800 Subject: [PATCH] 提交 --- zhengcaioa/Model/zhengcaioaContext.cs | 561 +++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 554 insertions(+), 7 deletions(-) diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index ec20a40..654c745 100644 --- a/zhengcaioa/Model/zhengcaioaContext.cs +++ b/zhengcaioa/Model/zhengcaioaContext.cs @@ -24,14 +24,21 @@ 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<AdmAskcost> AdmAskcosts { get; set; } + public virtual DbSet<AdmAskGood> AdmAskGoods { 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; } @@ -90,6 +97,7 @@ public virtual DbSet<SysCode> SysCodes { get; set; } public virtual DbSet<SysCodeDtl> SysCodeDtls { get; set; } public virtual DbSet<Systemsetting> Systemsettings { get; set; } + public virtual DbSet<SysUpdatetime> SysUpdatetimes { get; set; } public virtual DbSet<WfApplytype> WfApplytypes { get; set; } public virtual DbSet<WfHistory> WfHistories { get; set; } public virtual DbSet<WfLog> WfLogs { get; set; } @@ -117,6 +125,231 @@ 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 => + { + entity.ToTable("ADM_AskCar"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.CarLaiyuan).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.Feiyong) + .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.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<AdmAskcost>(entity => + { + entity.ToTable("ADM_Askcost"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Cost) + .HasColumnType("money") + .HasDefaultValueSql("((0))"); + + 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<AdmAskGood>(entity => + { + entity.ToTable("ADM_AskGoods"); + + 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.GoodsId).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.Shuliang) + .HasColumnType("money") + .HasDefaultValueSql("((0))"); + + entity.Property(e => e.Tittle) + .HasMaxLength(50) + .HasColumnName("tittle"); + }); + modelBuilder.Entity<AdmAskLeave>(entity => { entity.ToTable("ADM_AskLeave"); @@ -249,6 +482,185 @@ entity.Property(e => e.Tittle) .HasMaxLength(100) .HasColumnName("tittle"); + }); + + modelBuilder.Entity<AdmAskovertime>(entity => + { + entity.ToTable("ADM_Askovertime"); + + 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.Jiabantime) + .HasColumnType("datetime") + .HasColumnName("jiabantime"); + + 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.Overtime) + .HasColumnType("money") + .HasColumnName("overtime") + .HasDefaultValueSql("((0))"); + + 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<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() + .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.Feiyong) + .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.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.ToUserId).HasMaxLength(50); }); modelBuilder.Entity<AdmAttendance>(entity => @@ -673,6 +1085,78 @@ .HasMaxLength(50) .HasColumnName("userId") .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 => @@ -1136,6 +1620,11 @@ .HasDefaultValueSql("('A')") .HasComment("鐗╁搧鐘舵��"); + entity.Property(e => e.HaocaiStatus) + .HasMaxLength(1) + .HasColumnName("haocai_status") + .HasDefaultValueSql("('D')"); + entity.Property(e => e.Modifier) .IsRequired() .HasMaxLength(50) @@ -1207,6 +1696,10 @@ .HasMaxLength(4000) .HasColumnName("remark") .HasComment("宸ヤ綔鍐呭"); + + entity.Property(e => e.Shuliang) + .HasColumnType("money") + .HasColumnName("shuliang"); entity.Property(e => e.UserId) .HasMaxLength(50) @@ -1637,6 +2130,11 @@ .HasColumnName("f_tel") .HasComment("鑱旂郴鐢佃瘽"); + entity.Property(e => e.HuiyuanId) + .HasMaxLength(50) + .HasColumnName("huiyuanId") + .HasComment("浼氬憳Id"); + entity.Property(e => e.Hyfl) .HasMaxLength(50) .HasColumnName("hyfl") @@ -1741,6 +2239,14 @@ entity.Property(e => e.Weixin) .HasMaxLength(50) .HasColumnName("weixin"); + + entity.Property(e => e.Weixiner) + .HasMaxLength(50) + .HasColumnName("weixiner"); + + entity.Property(e => e.Weixintime) + .HasColumnType("datetime") + .HasColumnName("weixintime"); entity.Property(e => e.YwName) .HasMaxLength(500) @@ -3066,6 +3572,14 @@ .HasMaxLength(50) .HasColumnName("weixin"); + entity.Property(e => e.Weixiner) + .HasMaxLength(50) + .HasColumnName("weixiner"); + + entity.Property(e => e.Weixintime) + .HasColumnType("datetime") + .HasColumnName("weixintime"); + entity.Property(e => e.Yixiang).HasMaxLength(50); entity.Property(e => e.Yixiangtime).HasColumnType("datetime"); @@ -3322,13 +3836,14 @@ .HasColumnName("anwser"); entity.Property(e => e.ChushuStatus) - .HasMaxLength(1) - .HasColumnName("chushu_status") - .HasDefaultValueSql("('D')"); + .HasMaxLength(1) + .HasColumnName("chushu_status") + .HasDefaultValueSql("('D')"); entity.Property(e => e.Clientid) .HasMaxLength(50) - .HasColumnName("clientid"); + .HasColumnName("clientid") + .HasDefaultValueSql("('a')"); entity.Property(e => e.Creater) .IsRequired() @@ -3371,11 +3886,18 @@ .HasColumnName("rec_status") .HasDefaultValueSql("('a')"); + entity.Property(e => e.Shenheer) + .HasMaxLength(50) + .HasColumnName("shenheer"); + + entity.Property(e => e.Shenhetime) + .HasColumnType("datetime") + .HasColumnName("shenhetime"); + entity.Property(e => e.Shiyongfatiao) - .HasMaxLength(500) + .HasMaxLength(1000) .HasColumnName("shiyongfatiao"); }); - modelBuilder.Entity<LiaotianShoucang>(entity => { entity.ToTable("Liaotian_shoucang"); @@ -4228,6 +4750,10 @@ entity.Property(e => e.Weixin).HasMaxLength(50); + entity.Property(e => e.Yaoqingma) + .HasMaxLength(50) + .HasColumnName("yaoqingma"); + entity.Property(e => e.Zhengzhi).HasMaxLength(50); entity.Property(e => e.Zhiwustatus) @@ -4410,6 +4936,10 @@ entity.Property(e => e.DrhxDefen) .HasColumnType("money") .HasColumnName("drhx_defen"); + + entity.Property(e => e.Caigouyusuan) + .HasColumnType("money") + .HasColumnName("caigouyusuan"); entity.Property(e => e.DrhxPrice) .HasMaxLength(500) @@ -4862,6 +5392,23 @@ .HasColumnName("wedding_leave") .HasComment("濠氬亣澶╂暟"); }); + + modelBuilder.Entity<SysUpdatetime>(entity => + { + entity.ToTable("sys_updatetime"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Updatename) + .IsRequired() + .HasMaxLength(100) + .HasColumnName("updatename"); + + entity.Property(e => e.Updatetime) + .HasColumnType("datetime") + .HasColumnName("updatetime"); + }); + modelBuilder.Entity<WfApplytype>(entity => { entity.ToTable("wf_applytype"); -- Gitblit v1.9.1