username@email.com
2021-06-15 884e6a825427ef6511e7b7396635fe39c53f4fb4
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,18 +150,242 @@
                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 =>
            {
                entity.HasNoKey();
                entity.ToTable("ADM_AttendanceRules");
                entity.Property(e => e.Id).HasMaxLength(50);
                entity.Property(e => e.Absenteeism)
                    .HasColumnType("decimal(18, 2)")
@@ -247,10 +420,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 +509,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 +533,6 @@
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");
                entity.Property(e => e.Id)
                    .IsRequired()
                    .HasMaxLength(50);
                entity.Property(e => e.Modifier)
                    .IsRequired()
@@ -385,7 +548,6 @@
                entity.Property(e => e.Name).HasMaxLength(200);
                entity.Property(e => e.Pid)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("pid");
@@ -396,14 +558,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 =>
@@ -1612,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)