From 072169e3c5446f94e2cf4e570e5c7952bb5b15b9 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期二, 27 七月 2021 14:47:44 +0800 Subject: [PATCH] 今日开发 考勤规则里增加 公司安排加班 调整请假时间计算 加班日考勤计算 --- zhengcaioa/Model/zhengcaioaContext.cs | 1075 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 1,062 insertions(+), 13 deletions(-) diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index 26a050e..f142b9c 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<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<AdmAskovertime> AdmAskovertimes { get; set; } public virtual DbSet<AdmAttendance> AdmAttendances { get; set; } public virtual DbSet<AdmAttendanceDtl> AdmAttendanceDtls { get; set; } public virtual DbSet<AdmAttendanceRule> AdmAttendanceRules { get; set; } @@ -37,6 +48,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,12 +62,21 @@ 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<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; } + 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; } @@ -71,6 +92,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; } @@ -98,6 +120,117 @@ protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.HasAnnotation("Relational:Collation", "Chinese_PRC_CI_AS"); + + 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"); @@ -232,6 +365,65 @@ .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<AdmAttendance>(entity => { entity.ToTable("ADM_Attendance"); @@ -239,7 +431,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 +452,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 +473,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 +487,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 +495,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 +535,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 +563,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 +576,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 => @@ -1165,6 +1381,10 @@ .HasColumnName("remark") .HasComment("宸ヤ綔鍐呭"); + entity.Property(e => e.Shuliang) + .HasColumnType("money") + .HasColumnName("shuliang"); + entity.Property(e => e.UserId) .HasMaxLength(50) .HasColumnName("userId") @@ -1253,6 +1473,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) @@ -1380,11 +1608,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) @@ -1574,6 +1814,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") @@ -1646,6 +1891,10 @@ .HasColumnName("sheng") .HasComment("鐪�"); + entity.Property(e => e.Shifoutianjiaweixin) + .HasMaxLength(1) + .HasColumnName("shifoutianjiaweixin"); + entity.Property(e => e.ShrAddress) .HasMaxLength(500) .HasColumnName("shr_address") @@ -1671,6 +1920,18 @@ .HasColumnName("url") .HasComment("缃戝潃"); + 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) .HasColumnName("yw_name") @@ -1690,6 +1951,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 => @@ -2087,7 +2395,7 @@ .HasComment("浼氳垂"); entity.Property(e => e.MemberAuthority) - .HasMaxLength(100) + .HasMaxLength(500) .HasColumnName("member_authority") .HasComment("浼氬憳鏉冮檺"); @@ -2468,6 +2776,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"); @@ -2513,6 +2955,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"); @@ -2551,6 +3126,10 @@ .HasColumnType("datetime") .HasColumnName("createtime") .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.Dianxiaozhuanyuan) + .HasMaxLength(50) + .HasColumnName("dianxiaozhuanyuan"); entity.Property(e => e.Email) .HasMaxLength(500) @@ -2644,6 +3223,10 @@ .HasColumnName("sheng") .HasComment("鐪�"); + entity.Property(e => e.Shifoutianjiaweixin) + .HasMaxLength(1) + .HasColumnName("shifoutianjiaweixin"); + entity.Property(e => e.ShrAddress) .HasMaxLength(500) .HasColumnName("shr_address") @@ -2669,6 +3252,22 @@ .HasColumnName("url") .HasComment("缃戝潃"); + 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.Yixiang).HasMaxLength(50); + + entity.Property(e => e.Yixiangtime).HasColumnType("datetime"); + entity.Property(e => e.YwName) .HasMaxLength(500) .HasColumnName("yw_name") @@ -2688,6 +3287,10 @@ .HasMaxLength(50) .HasColumnName("ywjl") .HasComment("涓氬姟缁忕悊"); + + entity.Property(e => e.Zuijinzhuizongtime) + .HasColumnType("datetime") + .HasColumnName("zuijinzhuizongtime"); }); modelBuilder.Entity<IntentionOrder>(entity => @@ -2783,6 +3386,10 @@ .HasColumnName("createtime") .HasDefaultValueSql("(getdate())"); + entity.Property(e => e.DuanxinNeirong) + .HasMaxLength(500) + .HasColumnName("duanxin_neirong"); + entity.Property(e => e.Jdr) .HasMaxLength(500) .HasColumnName("jdr") @@ -2852,6 +3459,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"); @@ -2869,9 +3519,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() @@ -2914,9 +3570,112 @@ .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) .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 => + { + 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 => @@ -2969,6 +3728,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 => @@ -3206,11 +4164,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 +4214,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 +4248,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 +4266,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 +4290,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 +4315,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 +4381,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") @@ -3422,7 +4428,15 @@ .HasMaxLength(2) .HasColumnName("user_type"); + entity.Property(e => e.Usernumber) + .HasMaxLength(30) + .HasColumnName("usernumber"); + entity.Property(e => e.Weixin).HasMaxLength(50); + + entity.Property(e => e.Yaoqingma) + .HasMaxLength(50) + .HasColumnName("yaoqingma"); entity.Property(e => e.Zhengzhi).HasMaxLength(50); @@ -3533,6 +4547,7 @@ .HasMaxLength(50) .HasColumnName("userId"); }); + modelBuilder.Entity<Project>(entity => { entity.ToTable("Project"); @@ -3602,6 +4617,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"); @@ -3609,6 +4628,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) @@ -3621,6 +4644,8 @@ entity.Property(e => e.Feibiaocishu) .HasMaxLength(100) .HasColumnName("feibiaocishu"); + + entity.Property(e => e.Fencha).HasColumnType("money"); entity.Property(e => e.Modifier) .IsRequired() @@ -3749,6 +4774,9 @@ entity.Property(e => e.ProjectId) .IsRequired() .HasMaxLength(50); + + entity.Property(e => e.Defen).HasColumnType("money") + .HasColumnName("defen"); ; }); modelBuilder.Entity<SysAttachment>(entity => @@ -4044,6 +5072,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"); @@ -4391,6 +5436,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