From e0c631282dc9fd2323762f02441d0b835ffcc0ae Mon Sep 17 00:00:00 2001 From: LR-20210131IOQH\Administrator <jackcold@163.com> Date: 星期二, 15 六月 2021 09:16:00 +0800 Subject: [PATCH] 增加商城后台临时跳转 --- zhengcaioa/Model/zhengcaioaContext.cs | 305 ++++++++++++++++++++++++++++++++++++++++---------- 1 files changed, 240 insertions(+), 65 deletions(-) diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index 5bd4626..eef7cde 100644 --- a/zhengcaioa/Model/zhengcaioaContext.cs +++ b/zhengcaioa/Model/zhengcaioaContext.cs @@ -18,6 +18,8 @@ } 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; } @@ -108,79 +110,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 +150,235 @@ 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, 2)") + .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, 2)") + .HasColumnName("jiaban"); + + entity.Property(e => e.Kuanggong) + .HasColumnType("decimal(18, 2)") + .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, 2)") + .HasColumnName("offdays"); + + entity.Property(e => e.Qingjia) + .HasColumnType("decimal(18, 2)") + .HasColumnName("qingjia"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Shijichuqin) + .HasColumnType("decimal(18, 2)") + .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, 2)") + .HasColumnName("xiaojia"); + + entity.Property(e => e.Year).HasColumnName("year"); + + entity.Property(e => e.Yingchuqin) + .HasColumnType("decimal(18, 2)") + .HasColumnName("yingchuqin"); + + entity.Property(e => e.Zaotui) + .HasColumnType("decimal(18, 2)") + .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.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, 2)") + .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.Xiaojia) + .HasColumnType("decimal(18, 2)") + .HasColumnName("xiaojia"); }); modelBuilder.Entity<AdmAttendanceRule>(entity => @@ -385,11 +558,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"); }); @@ -1599,6 +1772,8 @@ entity.Property(e => e.AccountId).HasMaxLength(50); + entity.Property(e => e.AccountMoney).HasColumnType("money"); + entity.Property(e => e.Creater) .IsRequired() .HasMaxLength(50) -- Gitblit v1.9.1