From 964a84d26faa7708ae8905c3b8b92a8527c27787 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期二, 10 八月 2021 15:45:29 +0800 Subject: [PATCH] 提交 --- zhengcaioa/Model/zhengcaioaContext.cs | 613 +++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 610 insertions(+), 3 deletions(-) diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index cda5db5..5788464 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; } @@ -69,6 +76,7 @@ public virtual DbSet<IntentionVisit> IntentionVisits { get; set; } public virtual DbSet<IntentionVisitDuanxin> IntentionVisitDuanxins { get; set; } public virtual DbSet<Liaotian> Liaotians { get; set; } + public virtual DbSet<LiaotianShoucang> LiaotianShoucangs { get; set; } public virtual DbSet<LZhuanjiahuidum> LZhuanjiahuida { get; set; } public virtual DbSet<Oayouhui> Oayouhuis { get; set; } public virtual DbSet<OrderBanci> OrderBancis { get; set; } @@ -89,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; } @@ -116,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"); @@ -248,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 => @@ -672,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 => @@ -1207,6 +1692,10 @@ .HasColumnName("remark") .HasComment("宸ヤ綔鍐呭"); + entity.Property(e => e.Shuliang) + .HasColumnType("money") + .HasColumnName("shuliang"); + entity.Property(e => e.UserId) .HasMaxLength(50) .HasColumnName("userId") @@ -1295,6 +1784,14 @@ .HasColumnType("datetime") .HasColumnName("createtime") .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.HuifangJdr) + .HasMaxLength(100) + .HasColumnName("huifang_jdr"); + + entity.Property(e => e.HuifangKehuyijian) + .HasMaxLength(500) + .HasColumnName("huifang_kehuyijian"); entity.Property(e => e.HuifangStatus) .HasMaxLength(2) @@ -1422,11 +1919,23 @@ .HasColumnName("shr_tel") .HasComment("鑱旂郴鐢佃瘽"); + entity.Property(e => e.SonghuoDanhao) + .HasMaxLength(100) + .HasColumnName("songhuo_danhao"); + + entity.Property(e => e.SonghuoGongsi) + .HasMaxLength(100) + .HasColumnName("songhuo_gongsi"); + entity.Property(e => e.SonghuoStatus) .HasMaxLength(2) .HasColumnName("songhuo_status") .HasDefaultValueSql("('D')") .HasComment("閫佽揣鐘舵��"); + + entity.Property(e => e.SonghuoTime1) + .HasColumnType("datetime") + .HasColumnName("songhuo_time"); entity.Property(e => e.Songhuoer) .HasMaxLength(50) @@ -1616,6 +2125,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") @@ -1720,6 +2234,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) @@ -3045,6 +3567,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"); @@ -3300,9 +3830,15 @@ .HasMaxLength(4000) .HasColumnName("anwser"); + entity.Property(e => e.ChushuStatus) + .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() @@ -3345,9 +3881,55 @@ .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"); + + 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.LiaotianId) + .HasMaxLength(50) + .HasColumnName("Liaotian_id"); + + 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<LZhuanjiahuidum>(entity => @@ -4163,6 +4745,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) @@ -4345,6 +4931,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) @@ -4797,6 +5387,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