From 06e75f18b5b3b0fbfd25731c8b7324cc42df045f Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期三, 07 七月 2021 17:15:30 +0800 Subject: [PATCH] 提交 --- zhengcaioa/Model/zhengcaioaContext.cs | 1089 ++++++++++++++++++++++++++++++++++++++++++++++++++++---- 1 files changed, 1,004 insertions(+), 85 deletions(-) diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index 31ba8bd..cda5db5 100644 --- a/zhengcaioa/Model/zhengcaioaContext.cs +++ b/zhengcaioa/Model/zhengcaioaContext.cs @@ -16,8 +16,19 @@ : 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<SimCostYearView> SimCostYearView { get; set; } + + public virtual DbSet<AdmAskLeave> AdmAskLeaves { get; set; } public virtual DbSet<AdmAskLeaveOff> AdmAskLeaveOffs { 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; } @@ -35,6 +46,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; } @@ -48,12 +60,20 @@ 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<IntentionVisitDuanxin> IntentionVisitDuanxins { 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<OrderBanci> OrderBancis { get; set; } + public virtual DbSet<OrderBanciDtl> OrderBanciDtls { get; set; } + public virtual DbSet<OrderBanciOrder> OrderBanciOrders { get; set; } public virtual DbSet<PltAuth> PltAuths { get; set; } public virtual DbSet<PltPage> PltPages { get; set; } public virtual DbSet<PltRole> PltRoles { get; set; } @@ -108,79 +128,26 @@ .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.EndPoint).HasMaxLength(50); entity.Property(e => e.EndTime) .HasColumnType("datetime") - .HasDefaultValueSql("(getdate())") - .HasComment("缁撴潫鏃堕棿"); - - entity.Property(e => e.LaveDay).HasComment("璇峰亣澶�"); - - entity.Property(e => e.LavehHour).HasComment("璇峰亣鏃�"); - - entity.Property(e => e.Lavetype) - .IsRequired() - .HasMaxLength(50) - .HasComment("璇峰亣绫诲瀷"); - - 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.LaveDay).HasDefaultValueSql("((0))"); - entity.Property(e => e.Remark) - .HasMaxLength(500) - .HasComment("澶囨敞"); - - entity.Property(e => e.SigninId).HasMaxLength(50); - - entity.Property(e => e.StratTime) - .HasColumnType("datetime") - .HasDefaultValueSql("(getdate())") - .HasComment("寮�濮嬫椂闂�"); - }); - - modelBuilder.Entity<AdmAskLeaveOff>(entity => - { - entity.ToTable("ADM_AskLeaveOff"); - - 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.EndTime).HasColumnType("datetime"); + entity.Property(e => e.LavehHour).HasDefaultValueSql("((0))"); entity.Property(e => e.Lavetype).HasMaxLength(50); - - entity.Property(e => e.MedicalRecord) - .HasMaxLength(200) - .HasColumnName("MedicalRecord ") - .HasComment("鐥呬緥"); entity.Property(e => e.Modifier) .IsRequired() @@ -201,18 +168,266 @@ entity.Property(e => e.Remark).HasMaxLength(500); - entity.Property(e => e.SigninId) + entity.Property(e => e.ShenpiStatus) + .HasMaxLength(1) + .HasColumnName("shenpi_status"); + + entity.Property(e => e.SigninId).HasMaxLength(50); + + entity.Property(e => e.StratPoint).HasMaxLength(50); + + entity.Property(e => e.StratTime) + .HasColumnType("datetime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.Tittle) + .HasMaxLength(100) + .HasColumnName("tittle"); + }); + + modelBuilder.Entity<AdmAskLeaveOff>(entity => + { + entity.ToTable("ADM_AskLeaveOff"); + + 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.EndPoint).HasMaxLength(50); + + entity.Property(e => e.EndTime).HasColumnType("datetime"); + + entity.Property(e => e.Lavetype).HasMaxLength(50); + + entity.Property(e => e.MedicalRecord) + .HasMaxLength(200) + .HasColumnName("MedicalRecord "); + + 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"); + + entity.Property(e => e.SigninId).HasMaxLength(50); + + entity.Property(e => e.StratPoint).HasMaxLength(50); + + entity.Property(e => e.StratTime).HasColumnType("datetime"); + + entity.Property(e => e.Tittle) + .HasMaxLength(100) + .HasColumnName("tittle"); + }); + + modelBuilder.Entity<AdmAttendance>(entity => + { + entity.ToTable("ADM_Attendance"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Chidao) + .HasColumnType("decimal(18, 4)") + .HasColumnName("chidao"); + + 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.Islock) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("islock") + .HasDefaultValueSql("('D')"); + + entity.Property(e => e.Jiaban) + .HasColumnType("decimal(18, 4)") + .HasColumnName("jiaban"); + + entity.Property(e => e.Kuanggong) + .HasColumnType("decimal(18, 4)") + .HasColumnName("kuanggong"); + + 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.Offdays) + .HasColumnType("decimal(18, 4)") + .HasColumnName("offdays"); + + entity.Property(e => e.Qingjia) + .HasColumnType("decimal(18, 4)") + .HasColumnName("qingjia"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Shijichuqin) + .HasColumnType("decimal(18, 4)") + .HasColumnName("shijichuqin"); + + entity.Property(e => e.Userid) .IsRequired() .HasMaxLength(50); - entity.Property(e => e.StratTime).HasColumnType("datetime"); + entity.Property(e => e.Xiaojia) + .HasColumnType("decimal(18, 4)") + .HasColumnName("xiaojia"); + + entity.Property(e => e.Year).HasColumnName("year"); + + entity.Property(e => e.Yingchuqin) + .HasColumnType("decimal(18, 4)") + .HasColumnName("yingchuqin"); + + entity.Property(e => e.Zaotui) + .HasColumnType("decimal(18, 4)") + .HasColumnName("zaotui"); + }); + + modelBuilder.Entity<AdmAttendanceDtl>(entity => + { + entity.ToTable("ADM_Attendance_dtl"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.AfternoonIn).HasColumnType("datetime"); + + entity.Property(e => e.AfternoonOut).HasColumnType("datetime"); + + entity.Property(e => e.AttendanceId) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("attendance_id"); + + 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.Iswork) + .HasMaxLength(1) + .HasColumnName("iswork"); + + entity.Property(e => e.Kuanggongtianshu) + .HasColumnType("decimal(18, 4)") + .HasColumnName("kuanggongtianshu"); + + 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.MorningIn).HasColumnType("datetime"); + + entity.Property(e => e.MorningOut).HasColumnType("datetime"); + + entity.Property(e => e.OvertimeIn).HasColumnType("datetime"); + + entity.Property(e => e.OvertimeOut).HasColumnType("datetime"); + + entity.Property(e => e.Qingjia) + .HasColumnType("decimal(18, 4)") + .HasColumnName("qingjia"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.SgninDate) + .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, 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 => { - entity.HasNoKey(); - entity.ToTable("ADM_AttendanceRules"); + + entity.Property(e => e.Id).HasMaxLength(50); entity.Property(e => e.Absenteeism) .HasColumnType("decimal(18, 2)") @@ -247,10 +462,6 @@ .IsRequired() .HasMaxLength(50) .HasColumnName("holiday"); - - entity.Property(e => e.Id) - .IsRequired() - .HasMaxLength(50); entity.Property(e => e.LatePayment1) .HasColumnType("decimal(18, 2)") @@ -340,21 +551,19 @@ entity.Property(e => e.Weekend1).HasColumnName("weekend"); entity.Property(e => e.WorkingEnd) - .IsRequired() .HasMaxLength(50) .HasColumnName("working_end"); entity.Property(e => e.WorkingStart) - .IsRequired() .HasMaxLength(50) .HasColumnName("working_start"); }); modelBuilder.Entity<AdmAttendanceRulesDtl>(entity => { - entity.HasNoKey(); - entity.ToTable("ADM_AttendanceRules_dtl"); + + entity.Property(e => e.Id).HasMaxLength(50); entity.Property(e => e.Creater) .IsRequired() @@ -366,10 +575,6 @@ .HasColumnType("datetime") .HasColumnName("createtime") .HasDefaultValueSql("(getdate())"); - - entity.Property(e => e.Id) - .IsRequired() - .HasMaxLength(50); entity.Property(e => e.Modifier) .IsRequired() @@ -385,7 +590,6 @@ entity.Property(e => e.Name).HasMaxLength(200); entity.Property(e => e.Pid) - .IsRequired() .HasMaxLength(50) .HasColumnName("pid"); @@ -396,14 +600,12 @@ .HasDefaultValueSql("('A')"); entity.Property(e => e.ValueEnd) - .HasColumnType("date") - .HasColumnName("value_end") - .HasDefaultValueSql("(getdate())"); + .HasColumnType("datetime") + .HasColumnName("value_end"); entity.Property(e => e.ValueStart) - .HasColumnType("date") - .HasColumnName("value_start") - .HasDefaultValueSql("(getdate())"); + .HasColumnType("datetime") + .HasColumnName("value_start"); }); modelBuilder.Entity<AdmBreakPrecedent>(entity => @@ -1486,6 +1688,10 @@ .HasColumnName("sheng") .HasComment("鐪�"); + entity.Property(e => e.Shifoutianjiaweixin) + .HasMaxLength(1) + .HasColumnName("shifoutianjiaweixin"); + entity.Property(e => e.ShrAddress) .HasMaxLength(500) .HasColumnName("shr_address") @@ -1511,6 +1717,10 @@ .HasColumnName("url") .HasComment("缃戝潃"); + entity.Property(e => e.Weixin) + .HasMaxLength(50) + .HasColumnName("weixin"); + entity.Property(e => e.YwName) .HasMaxLength(500) .HasColumnName("yw_name") @@ -1530,6 +1740,53 @@ .HasMaxLength(50) .HasColumnName("ywjl") .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 => @@ -1611,6 +1868,8 @@ entity.Property(e => e.Id).HasMaxLength(50); entity.Property(e => e.AccountId).HasMaxLength(50); + + entity.Property(e => e.AccountMoney).HasColumnType("money"); entity.Property(e => e.Creater) .IsRequired() @@ -1925,7 +2184,7 @@ .HasComment("浼氳垂"); entity.Property(e => e.MemberAuthority) - .HasMaxLength(100) + .HasMaxLength(500) .HasColumnName("member_authority") .HasComment("浼氬憳鏉冮檺"); @@ -2306,6 +2565,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"); @@ -2351,6 +2744,139 @@ .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 => { entity.ToTable("IntentionCustomer"); @@ -2389,6 +2915,10 @@ .HasColumnType("datetime") .HasColumnName("createtime") .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.Dianxiaozhuanyuan) + .HasMaxLength(50) + .HasColumnName("dianxiaozhuanyuan"); entity.Property(e => e.Email) .HasMaxLength(500) @@ -2482,6 +3012,10 @@ .HasColumnName("sheng") .HasComment("鐪�"); + entity.Property(e => e.Shifoutianjiaweixin) + .HasMaxLength(1) + .HasColumnName("shifoutianjiaweixin"); + entity.Property(e => e.ShrAddress) .HasMaxLength(500) .HasColumnName("shr_address") @@ -2507,6 +3041,14 @@ .HasColumnName("url") .HasComment("缃戝潃"); + entity.Property(e => e.Weixin) + .HasMaxLength(50) + .HasColumnName("weixin"); + + entity.Property(e => e.Yixiang).HasMaxLength(50); + + entity.Property(e => e.Yixiangtime).HasColumnType("datetime"); + entity.Property(e => e.YwName) .HasMaxLength(500) .HasColumnName("yw_name") @@ -2526,6 +3068,10 @@ .HasMaxLength(50) .HasColumnName("ywjl") .HasComment("涓氬姟缁忕悊"); + + entity.Property(e => e.Zuijinzhuizongtime) + .HasColumnType("datetime") + .HasColumnName("zuijinzhuizongtime"); }); modelBuilder.Entity<IntentionOrder>(entity => @@ -2621,6 +3167,10 @@ .HasColumnName("createtime") .HasDefaultValueSql("(getdate())"); + entity.Property(e => e.DuanxinNeirong) + .HasMaxLength(500) + .HasColumnName("duanxin_neirong"); + entity.Property(e => e.Jdr) .HasMaxLength(500) .HasColumnName("jdr") @@ -2690,6 +3240,49 @@ .HasComment("鑱屽姟"); }); + modelBuilder.Entity<IntentionVisitDuanxin>(entity => + { + entity.ToTable("IntentionVisit_duanxin"); + + 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.DuanxinNeirong) + .HasMaxLength(500) + .HasColumnName("duanxin_neirong"); + + entity.Property(e => e.DuanxinTitle) + .HasMaxLength(50) + .HasColumnName("duanxin_title"); + + 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<Liaotian>(entity => { entity.ToTable("Liaotian"); @@ -2757,6 +3350,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"); @@ -2807,6 +3457,205 @@ entity.Property(e => e.Youtype) .HasMaxLength(50) .HasComment("浼樻儬绫诲瀷"); + }); + + modelBuilder.Entity<OrderBanci>(entity => + { + entity.ToTable("order_banci"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Mingcheng) + .HasMaxLength(100) + .HasColumnName("mingcheng"); + + entity.Property(e => e.Banci) + .HasMaxLength(100) + .HasColumnName("banci"); + + 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.Didian) + .HasMaxLength(500) + .HasColumnName("didian"); + + 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.Renshu) + .HasColumnName("renshu"); + + entity.Property(e => e.Shijian) + .HasColumnType("datetime") + .HasColumnName("shijian"); + + entity.Property(e => e.Shijianend) + .HasColumnType("datetime") + .HasColumnName("shijianend"); + }); + + modelBuilder.Entity<OrderBanciDtl>(entity => + { + entity.ToTable("order_banci_dtl"); + + 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.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.OrderBanciId) + .HasMaxLength(50) + .HasColumnName("order_banci_id"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Shangxiawu) + .HasMaxLength(100) + .HasColumnName("shangxiawu"); + + entity.Property(e => e.Shijian) + .HasMaxLength(100) + .HasColumnName("shijian"); + + entity.Property(e => e.Shixiamg) + .HasMaxLength(500) + .HasColumnName("shixiamg"); + + entity.Property(e => e.Sort) + .HasColumnName("sort") + .HasDefaultValueSql("((0))"); + + entity.Property(e => e.Zhujiangren) + .HasMaxLength(100) + .HasColumnName("zhujiangren"); + }); + + modelBuilder.Entity<OrderBanciOrder>(entity => + { + entity.ToTable("order_banci_order"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.BanciId) + .HasMaxLength(50) + .HasColumnName("banci_id"); + + entity.Property(e => e.Baomingrenshu).HasColumnName("baomingrenshu"); + + entity.Property(e => e.Baomingtime) + .HasColumnType("datetime") + .HasColumnName("baomingtime"); + + 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.Jine) + .HasColumnType("money") + .HasColumnName("jine"); + + entity.Property(e => e.Kechengleixing) + .HasMaxLength(100) + .HasColumnName("kechengleixing"); + + entity.Property(e => e.KechengleixingId) + .HasMaxLength(50) + .HasColumnName("kechengleixing_id"); + + entity.Property(e => e.Lianxidianhua) + .HasMaxLength(100) + .HasColumnName("lianxidianhua"); + + 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.Peixunbanci) + .HasMaxLength(100) + .HasColumnName("peixunbanci"); + + entity.Property(e => e.PersonId) + .HasMaxLength(100) + .HasColumnName("person_id"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Shenfenzheng) + .HasMaxLength(100) + .HasColumnName("shenfenzheng"); + + entity.Property(e => e.Xingming) + .HasMaxLength(100) + .HasColumnName("xingming"); + + entity.Property(e => e.Xuefei) + .HasColumnType("money") + .HasColumnName("xuefei"); }); modelBuilder.Entity<PltAuth>(entity => @@ -3044,11 +3893,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") @@ -3082,6 +3943,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") @@ -3112,6 +3977,10 @@ .HasDefaultValueSql("(getdate())") .HasComment("鍚敤鏃堕棿"); + entity.Property(e => e.IpMac) + .HasMaxLength(30) + .HasColumnName("ipmac"); + entity.Property(e => e.IsGmsb) .HasMaxLength(1) .HasColumnName("is_gmsb") @@ -3126,6 +3995,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") @@ -3138,9 +4019,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) @@ -3155,6 +4044,10 @@ .HasColumnName("length_price") .HasDefaultValueSql("('')") .HasComment("宸ラ緞宸ヨ祫锛屽叆鑱屾弧涓�骞寸殑涓嬩竴涓湀鍙韩鍙�"); + + entity.Property(e => e.miniyearsalary) + .HasColumnType("decimal(10, 2)") + .HasColumnName("miniyearsalary"); entity.Property(e => e.Modifier) .IsRequired() @@ -3217,6 +4110,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") @@ -3259,6 +4156,10 @@ .IsRequired() .HasMaxLength(2) .HasColumnName("user_type"); + + entity.Property(e => e.Usernumber) + .HasMaxLength(30) + .HasColumnName("usernumber"); entity.Property(e => e.Weixin).HasMaxLength(50); @@ -3371,6 +4272,7 @@ .HasMaxLength(50) .HasColumnName("userId"); }); + modelBuilder.Entity<Project>(entity => { entity.ToTable("Project"); @@ -3440,6 +4342,10 @@ .HasMaxLength(500) .HasColumnName("drhx"); + entity.Property(e => e.DrhxDefen) + .HasColumnType("money") + .HasColumnName("drhx_defen"); + entity.Property(e => e.DrhxPrice) .HasMaxLength(500) .HasColumnName("drhx_price"); @@ -3447,6 +4353,10 @@ entity.Property(e => e.Dshx) .HasMaxLength(500) .HasColumnName("dshx"); + + entity.Property(e => e.DshxDefen) + .HasColumnType("money") + .HasColumnName("dshx_defen"); entity.Property(e => e.DshxPrice) .HasMaxLength(500) @@ -3459,6 +4369,8 @@ entity.Property(e => e.Feibiaocishu) .HasMaxLength(100) .HasColumnName("feibiaocishu"); + + entity.Property(e => e.Fencha).HasColumnType("money"); entity.Property(e => e.Modifier) .IsRequired() @@ -3587,6 +4499,9 @@ entity.Property(e => e.ProjectId) .IsRequired() .HasMaxLength(50); + + entity.Property(e => e.Defen).HasColumnType("money") + .HasColumnName("defen"); ; }); modelBuilder.Entity<SysAttachment>(entity => @@ -4229,6 +5144,10 @@ .HasColumnName("danjuId") .HasComment("鍗曟嵁Id"); + entity.Property(e => e.Deelurl) + .HasMaxLength(500) + .HasColumnName("deelurl"); + entity.Property(e => e.Modifier) .IsRequired() .HasMaxLength(50) -- Gitblit v1.9.1