From 6ee35d97c90d5aa8860b9c9d6df22f76315515f1 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期一, 28 六月 2021 12:44:13 +0800 Subject: [PATCH] 提交 --- zhengcaioa/Model/zhengcaioaContext.cs | 492 +++++++++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 481 insertions(+), 11 deletions(-) diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index 26a050e..61265c2 100644 --- a/zhengcaioa/Model/zhengcaioaContext.cs +++ b/zhengcaioa/Model/zhengcaioaContext.cs @@ -16,6 +16,13 @@ : base(options) { } + + public virtual DbSet<SimBind> SimBind { get; set; } + public virtual DbSet<SimBindView> SimBindView { get; set; } + public virtual DbSet<SimCost> SimCost { get; set; } + public virtual DbSet<SimCostView> SimCostView { get; set; } + public virtual DbSet<HrSalaryAppeal> HrSalaryAppeal { get; set; } + public virtual DbSet<AdmAskLeave> AdmAskLeaves { get; set; } public virtual DbSet<AdmAskLeaveOff> AdmAskLeaveOffs { get; set; } public virtual DbSet<AdmAttendance> AdmAttendances { get; set; } @@ -37,6 +44,7 @@ public virtual DbSet<CooperOrder> CooperOrders { get; set; } public virtual DbSet<CooperVisit> CooperVisits { get; set; } public virtual DbSet<CooperatecustomCustomer> CooperatecustomCustomers { get; set; } + public virtual DbSet<CusFangwenjilu> CusFangwenjilus { get; set; } public virtual DbSet<FiAccount> FiAccounts { get; set; } public virtual DbSet<FiAccountRecord> FiAccountRecords { get; set; } public virtual DbSet<FiOrderrecievemoney> FiOrderrecievemoneys { get; set; } @@ -50,11 +58,15 @@ public virtual DbSet<GroupTopic> GroupTopics { get; set; } public virtual DbSet<GroupTuiguang> GroupTuiguangs { get; set; } public virtual DbSet<HrDept> HrDepts { get; set; } + public virtual DbSet<HrJibengongzi> HrJibengongzis { get; set; } + public virtual DbSet<HrJixiaoticheng> HrJixiaotichengs { get; set; } public virtual DbSet<HrPosition> HrPositions { get; set; } + public virtual DbSet<HrSalary> HrSalaries { get; set; } public virtual DbSet<IntentionCustomer> IntentionCustomers { get; set; } public virtual DbSet<IntentionOrder> IntentionOrders { get; set; } public virtual DbSet<IntentionVisit> IntentionVisits { get; set; } public virtual DbSet<Liaotian> Liaotians { get; set; } + public virtual DbSet<LZhuanjiahuidum> LZhuanjiahuida { get; set; } public virtual DbSet<Oayouhui> Oayouhuis { get; set; } public virtual DbSet<PltAuth> PltAuths { get; set; } public virtual DbSet<PltPage> PltPages { get; set; } @@ -239,7 +251,7 @@ entity.Property(e => e.Id).HasMaxLength(50); entity.Property(e => e.Chidao) - .HasColumnType("decimal(18, 2)") + .HasColumnType("decimal(18, 4)") .HasColumnName("chidao"); entity.Property(e => e.Creater) @@ -260,11 +272,11 @@ .HasDefaultValueSql("('D')"); entity.Property(e => e.Jiaban) - .HasColumnType("decimal(18, 2)") + .HasColumnType("decimal(18, 4)") .HasColumnName("jiaban"); entity.Property(e => e.Kuanggong) - .HasColumnType("decimal(18, 2)") + .HasColumnType("decimal(18, 4)") .HasColumnName("kuanggong"); entity.Property(e => e.Modifier) @@ -281,11 +293,11 @@ entity.Property(e => e.Month).HasColumnName("month"); entity.Property(e => e.Offdays) - .HasColumnType("decimal(18, 2)") + .HasColumnType("decimal(18, 4)") .HasColumnName("offdays"); entity.Property(e => e.Qingjia) - .HasColumnType("decimal(18, 2)") + .HasColumnType("decimal(18, 4)") .HasColumnName("qingjia"); entity.Property(e => e.RecStatus) @@ -295,7 +307,7 @@ .HasDefaultValueSql("('A')"); entity.Property(e => e.Shijichuqin) - .HasColumnType("decimal(18, 2)") + .HasColumnType("decimal(18, 4)") .HasColumnName("shijichuqin"); entity.Property(e => e.Userid) @@ -303,17 +315,17 @@ .HasMaxLength(50); entity.Property(e => e.Xiaojia) - .HasColumnType("decimal(18, 2)") + .HasColumnType("decimal(18, 4)") .HasColumnName("xiaojia"); entity.Property(e => e.Year).HasColumnName("year"); entity.Property(e => e.Yingchuqin) - .HasColumnType("decimal(18, 2)") + .HasColumnType("decimal(18, 4)") .HasColumnName("yingchuqin"); entity.Property(e => e.Zaotui) - .HasColumnType("decimal(18, 2)") + .HasColumnType("decimal(18, 4)") .HasColumnName("zaotui"); }); @@ -343,6 +355,14 @@ .HasColumnName("createtime") .HasDefaultValueSql("(getdate())"); + entity.Property(e => e.Iswork) + .HasMaxLength(1) + .HasColumnName("iswork"); + + entity.Property(e => e.Kuanggongtianshu) + .HasColumnType("decimal(18, 4)") + .HasColumnName("kuanggongtianshu"); + entity.Property(e => e.Modifier) .IsRequired() .HasMaxLength(50) @@ -363,7 +383,7 @@ entity.Property(e => e.OvertimeOut).HasColumnType("datetime"); entity.Property(e => e.Qingjia) - .HasColumnType("decimal(18, 2)") + .HasColumnType("decimal(18, 4)") .HasColumnName("qingjia"); entity.Property(e => e.RecStatus) @@ -376,9 +396,25 @@ .HasColumnType("datetime") .HasDefaultValueSql("(getdate())"); + entity.Property(e => e.Shangwuchidaofenzhong) + .HasColumnType("decimal(18, 4)") + .HasColumnName("shangwuchidaofenzhong"); + + entity.Property(e => e.Shangwuzaotuifenzhong) + .HasColumnType("decimal(18, 4)") + .HasColumnName("shangwuzaotuifenzhong"); + entity.Property(e => e.Xiaojia) - .HasColumnType("decimal(18, 2)") + .HasColumnType("decimal(18, 4)") .HasColumnName("xiaojia"); + + entity.Property(e => e.Xiawuchidaofenzhong) + .HasColumnType("decimal(18, 4)") + .HasColumnName("xiawuchidaofenzhong"); + + entity.Property(e => e.Xiawuzaotuifenzhong) + .HasColumnType("decimal(18, 4)") + .HasColumnName("xiawuzaotuifenzhong"); }); modelBuilder.Entity<AdmAttendanceRule>(entity => @@ -1692,6 +1728,53 @@ .HasComment("涓氬姟缁忕悊"); }); + modelBuilder.Entity<CusFangwenjilu>(entity => + { + entity.ToTable("cus_fangwenjilu"); + + 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.Fasongfangshi) + .HasMaxLength(50) + .HasColumnName("fasongfangshi"); + + entity.Property(e => e.Fasongneirong) + .HasMaxLength(4000) + .HasColumnName("fasongneirong"); + + entity.Property(e => e.Jieshouren) + .HasMaxLength(2000) + .HasColumnName("jieshouren"); + + 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<FiAccount>(entity => { entity.ToTable("fi_account"); @@ -2468,6 +2551,140 @@ .HasColumnName("superior_top"); }); + modelBuilder.Entity<HrJibengongzi>(entity => + { + entity.ToTable("hr_jibengongzi"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Baomifei) + .HasColumnType("money") + .HasColumnName("baomifei"); + + 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.Dianhuabutie) + .HasMaxLength(50) + .HasColumnName("dianhuabutie"); + + entity.Property(e => e.Effecttime) + .HasColumnType("datetime") + .HasColumnName("effecttime"); + + entity.Property(e => e.Jiaotongbutie) + .HasColumnType("money") + .HasColumnName("jiaotongbutie"); + + entity.Property(e => e.Jibengongzi) + .HasColumnType("money") + .HasColumnName("jibengongzi"); + + 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.PostId) + .HasMaxLength(50) + .HasColumnName("post_id"); + + entity.Property(e => e.Quanqingjiang) + .HasColumnType("money") + .HasColumnName("quanqingjiang"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Shebaodanwei) + .HasColumnType("money") + .HasColumnName("shebaodanwei"); + + entity.Property(e => e.Shebaogeren) + .HasColumnType("money") + .HasColumnName("shebaogeren"); + }); + + modelBuilder.Entity<HrJixiaoticheng>(entity => + { + entity.ToTable("hr_jixiaoticheng"); + + 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.Effecttime) + .HasColumnType("datetime") + .HasColumnName("effecttime"); + + 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.PiecerateId) + .HasMaxLength(50) + .HasColumnName("piecerate_id"); + + entity.Property(e => e.PostId) + .HasMaxLength(50) + .HasColumnName("post_id"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Renwu) + .HasColumnType("money") + .HasColumnName("renwu"); + + entity.Property(e => e.Renwustandard) + .HasMaxLength(50) + .HasColumnName("renwustandard"); + + entity.Property(e => e.Ticheng) + .HasColumnType("money") + .HasColumnName("ticheng"); + + entity.Property(e => e.Tichengstandard) + .HasMaxLength(50) + .HasColumnName("tichengstandard"); + }); + modelBuilder.Entity<HrPosition>(entity => { entity.ToTable("hr_position"); @@ -2511,6 +2728,139 @@ .HasMaxLength(1) .HasColumnName("rec_status") .HasDefaultValueSql("('A')"); + }); + + modelBuilder.Entity<HrSalary>(entity => + { + entity.ToTable("hr_salary"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Baomifei) + .HasColumnType("decimal(18, 4)") + .HasColumnName("baomifei"); + + entity.Property(e => e.Bufagongzi) + .HasColumnType("decimal(18, 4)") + .HasColumnName("bufagongzi"); + + 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.Daozhanggongzi) + .HasColumnType("decimal(18, 4)") + .HasColumnName("daozhanggongzi"); + + entity.Property(e => e.Dianhuabutie) + .HasColumnType("decimal(18, 4)") + .HasColumnName("dianhuabutie"); + + entity.Property(e => e.Dianhuafei) + .HasColumnType("decimal(18, 4)") + .HasColumnName("dianhuafei"); + + entity.Property(e => e.Fakuan) + .HasColumnType("decimal(18, 4)") + .HasColumnName("fakuan"); + + entity.Property(e => e.Geshui) + .HasColumnType("decimal(18, 4)") + .HasColumnName("geshui"); + + entity.Property(e => e.Gongzuobutie) + .HasColumnType("decimal(18, 4)") + .HasColumnName("gongzuobutie"); + + entity.Property(e => e.Islock) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("islock") + .HasDefaultValueSql("('D')"); + + entity.Property(e => e.Jiabangongzi) + .HasColumnType("decimal(18, 4)") + .HasColumnName("jiabangongzi"); + + entity.Property(e => e.Jiangjin) + .HasColumnType("decimal(18, 4)") + .HasColumnName("jiangjin"); + + entity.Property(e => e.Jiaotngbutie) + .HasColumnType("decimal(18, 4)") + .HasColumnName("jiaotngbutie"); + + entity.Property(e => e.Jibengongzi) + .HasColumnType("decimal(18, 4)") + .HasColumnName("jibengongzi"); + + entity.Property(e => e.Jiucuo) + .HasColumnType("decimal(18, 4)") + .HasColumnName("jiucuo"); + + entity.Property(e => e.Jixiaoticheng) + .HasColumnType("decimal(18, 4)") + .HasColumnName("jixiaoticheng"); + + 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.Month).HasColumnName("month"); + + entity.Property(e => e.Peichang) + .HasColumnType("decimal(18, 4)") + .HasColumnName("peichang"); + + entity.Property(e => e.Quanqinjiang) + .HasColumnType("decimal(18, 4)") + .HasColumnName("quanqinjiang"); + + entity.Property(e => e.Queqin) + .HasColumnType("decimal(18, 4)") + .HasColumnName("queqin"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Shebao) + .HasColumnType("decimal(18, 4)") + .HasColumnName("shebao"); + + entity.Property(e => e.Shebaokou) + .HasColumnType("decimal(18, 4)") + .HasColumnName("shebaokou"); + + entity.Property(e => e.Userid) + .IsRequired() + .HasMaxLength(50); + + entity.Property(e => e.Year).HasColumnName("year"); + + entity.Property(e => e.Yufagongzi) + .HasColumnType("decimal(18, 4)") + .HasColumnName("yufagongzi"); + + entity.Property(e => e.Yufagongziheji) + .HasColumnType("decimal(18, 4)") + .HasColumnName("yufagongziheji"); }); modelBuilder.Entity<IntentionCustomer>(entity => @@ -2919,6 +3269,63 @@ .HasColumnName("shiyongfatiao"); }); + modelBuilder.Entity<LZhuanjiahuidum>(entity => + { + entity.ToTable("l_zhuanjiahuida"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Anwser) + .HasMaxLength(4000) + .HasColumnName("anwser"); + + 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.Question) + .HasMaxLength(500) + .HasColumnName("question"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.HuidaStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("huida_status") + .HasDefaultValueSql("('D')"); + + entity.Property(e => e.Userid) + .HasMaxLength(50) + .HasColumnName("userid"); + + entity.Property(e => e.Username) + .HasMaxLength(100) + .HasColumnName("username"); + }); + modelBuilder.Entity<Oayouhui>(entity => { entity.ToTable("Oayouhui"); @@ -3206,11 +3613,23 @@ entity.Property(e => e.Id).HasMaxLength(50); + entity.Property(e => e.advancewages) + .HasColumnType("decimal(10, 2)") + .HasColumnName("advancewages"); + entity.Property(e => e.BasicPrice) .HasMaxLength(500) .HasColumnName("basic_price") .HasDefaultValueSql("('')") .HasComment("钖祫寰呴亣"); + + entity.Property(e => e.baomisalary) + .HasColumnType("decimal(10, 2)") + .HasColumnName("baomisalary"); + + entity.Property(e => e.Beizhu) + .HasMaxLength(500) + .HasColumnName("beizhu"); entity.Property(e => e.Birthday) .HasColumnType("datetime") @@ -3244,6 +3663,10 @@ .HasMaxLength(50) .HasColumnName("email"); + entity.Property(e => e.geshuiqizheng) + .HasColumnType("decimal(10, 2)") + .HasColumnName("geshuiqizheng"); + entity.Property(e => e.HjAddress) .HasMaxLength(500) .HasColumnName("hj_address") @@ -3274,6 +3697,10 @@ .HasDefaultValueSql("(getdate())") .HasComment("鍚敤鏃堕棿"); + entity.Property(e => e.IpMac) + .HasMaxLength(30) + .HasColumnName("ipmac"); + entity.Property(e => e.IsGmsb) .HasMaxLength(1) .HasColumnName("is_gmsb") @@ -3288,6 +3715,18 @@ .HasDefaultValueSql("('')") .HasComment("宸茬璁㈠悎鍚�"); + entity.Property(e => e.Istravelsubsidy) + .HasMaxLength(1) + .HasColumnName("is_travelsubsidy"); + + entity.Property(e => e.Iswdenter) + .HasMaxLength(1) + .HasColumnName("is_wdenter"); + + entity.Property(e => e.Isxmenter) + .HasMaxLength(1) + .HasColumnName("is_xmenter"); + entity.Property(e => e.IsYwjl) .HasMaxLength(1) .HasColumnName("is_ywjl") @@ -3300,9 +3739,17 @@ .HasDefaultValueSql("('')") .HasComment("绫嶈疮"); + entity.Property(e => e.jibensalary) + .HasColumnType("decimal(10, 2)") + .HasColumnName("jibensalary"); + entity.Property(e => e.Jinji).HasMaxLength(50); entity.Property(e => e.JinjiPhone).HasMaxLength(50); + + entity.Property(e => e.jintiesalary) + .HasColumnType("decimal(10, 2)") + .HasColumnName("jintiesalary"); entity.Property(e => e.JzAddress) .HasMaxLength(500) @@ -3317,6 +3764,10 @@ .HasColumnName("length_price") .HasDefaultValueSql("('')") .HasComment("宸ラ緞宸ヨ祫锛屽叆鑱屾弧涓�骞寸殑涓嬩竴涓湀鍙韩鍙�"); + + entity.Property(e => e.miniyearsalary) + .HasColumnType("decimal(10, 2)") + .HasColumnName("miniyearsalary"); entity.Property(e => e.Modifier) .IsRequired() @@ -3379,6 +3830,10 @@ entity.Property(e => e.School).HasMaxLength(50); + entity.Property(e => e.senioritywages) + .HasColumnType("decimal(10, 2)") + .HasColumnName("senioritywages"); + entity.Property(e => e.Sex) .HasMaxLength(1) .HasColumnName("sex") @@ -3421,6 +3876,10 @@ .IsRequired() .HasMaxLength(2) .HasColumnName("user_type"); + + entity.Property(e => e.Usernumber) + .HasMaxLength(30) + .HasColumnName("usernumber"); entity.Property(e => e.Weixin).HasMaxLength(50); @@ -3606,6 +4065,14 @@ .HasMaxLength(500) .HasColumnName("drhx_price"); + entity.Property(e => e.DrhxDefen) + .HasColumnType("money") + .HasColumnName("drhx_defen"); + + entity.Property(e => e.DshxDefen) + .HasColumnType("money") + .HasColumnName("dshx_defen"); + entity.Property(e => e.Dshx) .HasMaxLength(500) .HasColumnName("dshx"); @@ -3749,6 +4216,9 @@ entity.Property(e => e.ProjectId) .IsRequired() .HasMaxLength(50); + + entity.Property(e => e.Defen).HasColumnType("money") + .HasColumnName("defen"); ; }); modelBuilder.Entity<SysAttachment>(entity => -- Gitblit v1.9.1