From fc1fe356e1cb43c7654c653e8921ee9e72150f96 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期三, 21 七月 2021 16:18:30 +0800 Subject: [PATCH] 今日开发 7月5日以及之前的订单删除 增加功能 账户转账 会员订单同步到会员端 员工获取会员邀请码 --- zhengcaioa/Model/zhengcaioaContext.cs | 1186 +++++++++++++++++++++++++++++++++++++++++++++++++++++++--- 1 files changed, 1,119 insertions(+), 67 deletions(-) diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index 90ed301..3a4f12a 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,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; } @@ -69,6 +90,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; } @@ -108,79 +130,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,11 +170,259 @@ 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 => @@ -385,11 +602,11 @@ .HasDefaultValueSql("('A')"); entity.Property(e => e.ValueEnd) - .HasMaxLength(50) + .HasColumnType("datetime") .HasColumnName("value_end"); entity.Property(e => e.ValueStart) - .HasMaxLength(50) + .HasColumnType("datetime") .HasColumnName("value_start"); }); @@ -992,6 +1209,10 @@ .HasColumnName("remark") .HasComment("宸ヤ綔鍐呭"); + entity.Property(e => e.Shuliang) + .HasColumnType("money") + .HasColumnName("shuliang"); + entity.Property(e => e.UserId) .HasMaxLength(50) .HasColumnName("userId") @@ -1080,6 +1301,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) @@ -1207,11 +1436,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) @@ -1401,6 +1642,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") @@ -1473,6 +1719,10 @@ .HasColumnName("sheng") .HasComment("鐪�"); + entity.Property(e => e.Shifoutianjiaweixin) + .HasMaxLength(1) + .HasColumnName("shifoutianjiaweixin"); + entity.Property(e => e.ShrAddress) .HasMaxLength(500) .HasColumnName("shr_address") @@ -1498,6 +1748,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") @@ -1517,6 +1779,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 => @@ -1598,6 +1907,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() @@ -1912,7 +2223,7 @@ .HasComment("浼氳垂"); entity.Property(e => e.MemberAuthority) - .HasMaxLength(100) + .HasMaxLength(500) .HasColumnName("member_authority") .HasComment("浼氬憳鏉冮檺"); @@ -2293,6 +2604,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"); @@ -2338,6 +2783,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"); @@ -2376,6 +2954,10 @@ .HasColumnType("datetime") .HasColumnName("createtime") .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.Dianxiaozhuanyuan) + .HasMaxLength(50) + .HasColumnName("dianxiaozhuanyuan"); entity.Property(e => e.Email) .HasMaxLength(500) @@ -2469,6 +3051,10 @@ .HasColumnName("sheng") .HasComment("鐪�"); + entity.Property(e => e.Shifoutianjiaweixin) + .HasMaxLength(1) + .HasColumnName("shifoutianjiaweixin"); + entity.Property(e => e.ShrAddress) .HasMaxLength(500) .HasColumnName("shr_address") @@ -2494,6 +3080,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") @@ -2513,6 +3115,10 @@ .HasMaxLength(50) .HasColumnName("ywjl") .HasComment("涓氬姟缁忕悊"); + + entity.Property(e => e.Zuijinzhuizongtime) + .HasColumnType("datetime") + .HasColumnName("zuijinzhuizongtime"); }); modelBuilder.Entity<IntentionOrder>(entity => @@ -2608,6 +3214,10 @@ .HasColumnName("createtime") .HasDefaultValueSql("(getdate())"); + entity.Property(e => e.DuanxinNeirong) + .HasMaxLength(500) + .HasColumnName("duanxin_neirong"); + entity.Property(e => e.Jdr) .HasMaxLength(500) .HasColumnName("jdr") @@ -2677,6 +3287,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"); @@ -2694,9 +3347,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() @@ -2739,9 +3398,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 => @@ -2794,6 +3556,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 => @@ -3031,11 +3992,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") @@ -3069,6 +4042,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") @@ -3099,6 +4076,10 @@ .HasDefaultValueSql("(getdate())") .HasComment("鍚敤鏃堕棿"); + entity.Property(e => e.IpMac) + .HasMaxLength(30) + .HasColumnName("ipmac"); + entity.Property(e => e.IsGmsb) .HasMaxLength(1) .HasColumnName("is_gmsb") @@ -3113,6 +4094,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") @@ -3125,9 +4118,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) @@ -3142,6 +4143,10 @@ .HasColumnName("length_price") .HasDefaultValueSql("('')") .HasComment("宸ラ緞宸ヨ祫锛屽叆鑱屾弧涓�骞寸殑涓嬩竴涓湀鍙韩鍙�"); + + entity.Property(e => e.miniyearsalary) + .HasColumnType("decimal(10, 2)") + .HasColumnName("miniyearsalary"); entity.Property(e => e.Modifier) .IsRequired() @@ -3204,6 +4209,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") @@ -3247,7 +4256,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); @@ -3358,6 +4375,7 @@ .HasMaxLength(50) .HasColumnName("userId"); }); + modelBuilder.Entity<Project>(entity => { entity.ToTable("Project"); @@ -3427,6 +4445,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"); @@ -3434,6 +4456,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) @@ -3446,6 +4472,8 @@ entity.Property(e => e.Feibiaocishu) .HasMaxLength(100) .HasColumnName("feibiaocishu"); + + entity.Property(e => e.Fencha).HasColumnType("money"); entity.Property(e => e.Modifier) .IsRequired() @@ -3574,6 +4602,9 @@ entity.Property(e => e.ProjectId) .IsRequired() .HasMaxLength(50); + + entity.Property(e => e.Defen).HasColumnType("money") + .HasColumnName("defen"); ; }); modelBuilder.Entity<SysAttachment>(entity => @@ -3869,6 +4900,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"); @@ -4216,6 +5264,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