YD_SmartSports.Api/VOL.Entity/DomainModels/IOT/I_TrainingData.cs

using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using VOL.Entity.Enum;
using VOL.Entity.SystemModels;

namespace VOL.Entity.DomainModels
{
    /// <summary>
    /// 课堂训练信息表
    /// </summary>
    [Table("I_TrainingData")]
    [Entity(TableCnName = "课堂训练信息表", TableName = "I_TrainingData")]
    public class I_TrainingData : BaseEntity
    {
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        [Display(Description = "主键Id")]
        [Comment("Id")]
        public int Id { get; set; }

        /// <summary>
        ///数据来源
        /// </summary>
        [Display(Name = "数据来源")]
        [Comment("数据来源")]
        [Column(TypeName = "int")]
        public DataSource DataSource { get; set; }

        /// <summary>
        ///学校Code
        /// </summary>
        [Display(Name = "学校Code")]
        [Comment("学校Code")]
        [Column(TypeName = "nvarchar(100)")]
        public string SchoolCode { get; set; }

        /// <summary>
        /// 年级编号
        /// </summary>
        [Display(Name = "年级编号")]
        [Comment("年级编号")]
        [Column(TypeName = "int")]
        public int GradeId { get; set; }

        /// <summary>
        ///班级Id
        /// </summary>
        [Display(Name = "班级Id")]
        [Comment("班级Id")]
        [Column(TypeName = "int")]
        public int ClassId { get; set; }

        /// <summary>
        /// 年级名称
        /// </summary>
        [Display(Name = "年级名称")]
        [Comment("年级名称")]
        [Column(TypeName = "nvarchar(100)")]
        public string GradeName { get; set; }

        /// <summary>
        /// 班级名称
        /// </summary>
        [Display(Name = "班级名称")]
        [Comment("班级名称")]
        [Column(TypeName = "nvarchar(100)")]
        public string ClassName { get; set; }

        /// <summary>
        ///老师Id
        /// </summary>
        [Display(Name = "老师Id")]
        [Comment("老师Id")]
        [Column(TypeName = "int")]
        public int TeacherId { get; set; }

        /// <summary>
        /// 项目类型
        /// </summary>
        [Display(Name = "项目类型")]
        [Comment("项目类型")]
        [Column(TypeName = "int")]
        public int ItemType { get; set; }

        /// <summary>
        /// 开始时间
        /// </summary>
        [Display(Name = "开始时间")]
        [Comment("开始时间")]
        [Column(TypeName = "datetime")]
        public DateTime? InsertTime { get; set; }

        /// <summary>
        /// 结束时间
        /// </summary>
        [Display(Name = "结束时间")]
        [Comment("结束时间")]
        [Column(TypeName = "datetime")]
        public DateTime? EndTime { get; set; }

        /// <summary>
        /// 参与人数
        /// </summary>
        [Display(Name = "参与人数")]
        [Comment("参与人数")]
        [Column(TypeName = "int")]
        public int TotalNumber { get; set; }

        /// <summary>
        /// 总轮次
        /// </summary>
        [Display(Name = "总轮次")]
        [Comment("总轮次")]
        [Column(TypeName = "int")]
        public int TtotalGroup { get; set; }

        /// <summary>
        /// 训练类型
        /// </summary>
        [Display(Name = "训练类型")]
        [Comment("训练类型")]
        [Column(TypeName = "int")]
        public int TrainType { get; set; }

        /// <summary>
        /// 模式类型
        /// </summary>
        [Display(Name = "模式类型")]
        [Comment("模式类型")]
        [Column(TypeName = "int")]
        public int ModeType { get; set; }

        /// <summary>
        /// 模式名称
        /// </summary>
        [Display(Name = "模式名称")]
        [Comment("模式名称")]
        [Column(TypeName = "nvarchar(100)")]
        public string ModelName { get; set; }

        /// <summary>
        /// 限时
        /// </summary>
        [Display(Name = "限时")]
        [Comment("限时")]
        [Column(TypeName = "int")]
        public int LimitTime { get; set; }

        /// <summary>
        /// 限数
        /// </summary>
        [Display(Name = "限数")]
        [Comment("限数")]
        [Column(TypeName = "int")]
        public int LimitNumber { get; set; }

        /// <summary>
        /// 训练成绩[1:优秀,2:良好,3:及格,4:不及格]
        /// 心率项目[1:达标,2:未达标]
        /// </summary>
        [Display(Name = "训练成绩")]
        [Comment("训练成绩")]
        [Column(TypeName = "int")]
        public int ClassScore { get; set; }

        /// <summary>
        /// 男孩优秀的评分标准
        /// </summary>
        [Display(Name = "男孩优秀的评分标准")]
        [Comment("男孩优秀的评分标准")]
        [Column(TypeName = "float")]
        public double BoyLevelHigh { get; set; }

        /// <summary>
        /// 男孩良好的评分标准
        /// </summary>
        [Display(Name = "男孩良好的评分标准")]
        [Comment("男孩良好的评分标准")]
        [Column(TypeName = "float")]
        public double BoyLevelMiddle { get; set; }

        /// <summary>
        /// 男孩及格的评分标准
        /// </summary>
        [Display(Name = "男孩及格的评分标准")]
        [Comment("男孩及格的评分标准")]
        [Column(TypeName = "float")]
        public double BoyLevelLow { get; set; }

        /// <summary>
        /// 女孩优秀的评分标准
        /// </summary>
        [Display(Name = "女孩优秀的评分标准")]
        [Comment("女孩优秀的评分标准")]
        [Column(TypeName = "float")]
        public double GirlLevelHigh { get; set; }

        /// <summary>
        /// 女孩良好的评分标准
        /// </summary>
        [Display(Name = "女孩良好的评分标准")]
        [Comment("女孩良好的评分标准")]
        [Column(TypeName = "float")]
        public double GirlLevelMiddle { get; set; }

        /// <summary>
        /// 女孩及格的评分标准
        /// </summary>
        [Display(Name = "女孩及格的评分标准")]
        [Comment("女孩及格的评分标准")]
        [Column(TypeName = "float")]
        public double GirlLevelLow { get; set; }

        /// <summary>
        /// 班级人数
        /// </summary>
        [Display(Name = "班级人数")]
        [Comment("班级人数")]
        [Column(TypeName = "int")]
        public int ClassNum { get; set; }

        /// <summary>
        /// 开始日期
        /// </summary>
        [Display(Name = "开始日期")]
        [Comment("开始日期")]
        [Column(TypeName = "nvarchar(100)")]
        public string ClassDate { get; set; }

        /// <summary>
        /// 开始时间
        /// </summary>
        [Display(Name = "开始时间")]
        [Comment("开始时间")]
        [Column(TypeName = "nvarchar(100)")]
        public string ClassTime { get; set; }

        /// <summary>
        /// 训练倒计时时间 (1, 2 分钟)
        /// </summary>
        [Display(Name = "训练倒计时时间")]
        [Comment("训练倒计时时间 (1, 2 分钟)")]
        public int? TrainingTime { get; set; }

        /// <summary>
        /// 当前模式类型 (1: 倒计时，2: 正向计数，3: 限时限数)
        /// </summary>
        [Display(Name = "当前模式类型")]
        [Comment("当前模式类型 (1: 倒计时，2: 正向计数，3: 限时限数)")]
        public int? ModelType { get; set; }

        /// <summary>
        /// 正向计数总共使用时间 (秒)
        /// </summary>
        [Display(Name = "正向计数总共使用时间")]
        [Comment("正向计数总共使用时间 (秒)")]
        public int? TrainTimer { get; set; }

        /// <summary>
        /// 限时限数总耗时
        /// </summary>
        [Display(Name = "限时限数总耗时")]
        [Comment("限时限数总耗时")]
        public int? TotalTime { get; set; }

        /// <summary>
        /// 总个数 (协调项目：所有学生总个数)
        /// </summary>
        [Display(Name = "总个数")]
        [Comment("总个数 (协调项目：所有学生总个数)")]
        [Column(TypeName = "nvarchar(100)")]
        public string ClassTotal { get; set; }

        /// <summary>
        /// 平均kcal (协调项目：所有学生总个数)
        /// </summary>
        [Display(Name = "平均kcal")]
        [Comment("平均kcal (协调项目：所有学生总个数)")]
        [Column(TypeName = "nvarchar(100)")]
        public string ClassAvgKcal { get; set; }

        /// <summary>
        /// 平均数
        /// </summary>
        [Display(Name = "平均数")]
        [Comment("平均数")]
        [Column(TypeName = "float")]
        public double ClassNumAvg { get; set; }

        /// <summary>
        /// 中位数
        /// </summary>
        [Display(Name = "中位数")]
        [Comment("中位数")]
        [Column(TypeName = "int")]
        public int ClassMedian { get; set; }

        /// <summary>
        /// 最大圈数
        /// </summary>
        [Display(Name = "最大圈数")]
        [Comment("最大圈数")]
        [Column(TypeName = "int")]
        public int ClassMaxNum { get; set; }

        /// <summary>
        /// 最小圈数
        /// </summary>
        [Display(Name = "最小圈数")]
        [Comment("最小圈数")]
        [Column(TypeName = "int")]
        public int ClassMinNum { get; set; }

        /// <summary>
        /// 优秀人数 (心率的达标人数)
        /// </summary>
        [Display(Name = "优秀人数")]
        [Comment("优秀人数 (心率的达标人数)")]
        public int? ClassHightPer { get; set; }

        /// <summary>
        /// 良好
        /// </summary>
        [Display(Name = "良好")]
        [Comment("良好")]
        public int? ClassWellNum { get; set; }

        /// <summary>
        /// 合格
        /// </summary>
        [Display(Name = "合格")]
        [Comment("合格")]
        public int? ClassLowNum { get; set; }

        /// <summary>
        /// 总轮次
        /// </summary>
        [Display(Name = "总轮次")]
        [Comment("总轮次")]
        public int? TotalRound { get; set; }

        /// <summary>
        /// 自由模式设置 距离所需时间 (算合格)
        /// </summary>
        [Display(Name = "自由模式设置距离所需时间")]
        [Comment("自由模式设置 距离所需时间 (算合格)")]
        public float? DistanceUseTime { get; set; }

        /// <summary>
        /// 自由模式 设置跑步距离
        /// </summary>
        [Display(Name = "自由模式设置跑步距离")]
        [Comment("自由模式 设置跑步距离")]
        public int? Distance { get; set; }

        /// <summary>
        /// 学生名称
        /// </summary>
        [Display(Name = "学生名称")]
        [Comment("学生名称")]
        [Column(TypeName = "nvarchar(100)")]
        public string StuName { get; set; }

        /// <summary>
        /// 速度 (个/s)
        /// </summary>
        [Display(Name = "速度")]
        [Comment("速度 (个/s)")]
        [Column(TypeName = "nvarchar(100)")]
        public string Speed { get; set; }

        /// <summary>
        /// 时间平均数
        /// </summary>
        [Display(Name = "时间平均数")]
        [Comment("时间平均数")]
        [Column(TypeName = "nvarchar(100)")]
        public string ClassAvgTime { get; set; }

        /// <summary>
        /// 时间中位数
        /// </summary>
        [Display(Name = "时间中位数")]
        [Comment("时间中位数")]
        public int? ClassTimeMedian { get; set; }

        /// <summary>
        /// 男生平均
        /// </summary>
        [Display(Name = "男生平均")]
        [Comment("男生平均")]
        [Column(TypeName = "nvarchar(100)")]
        public string AvgNumMan { get; set; } = "";

        /// <summary>
        /// 男生最大值
        /// </summary>
        [Display(Name = "男生最大值")]
        [Comment("男生最大值")]
        [Column(TypeName = "nvarchar(100)")]
        public string MaxNumMan { get; set; } = "";

        /// <summary>
        /// 男生最小值
        /// </summary>
        [Display(Name = "男生最小值")]
        [Comment("男生最小值")]
        [Column(TypeName = "nvarchar(100)")]
        public string MinNumMan { get; set; } = "";

        /// <summary>
        /// 男生中位数
        /// </summary>
        [Display(Name = "男生中位数")]
        [Comment("男生中位数")]
        [Column(TypeName = "nvarchar(100)")]
        public string MedianNumMan { get; set; } = "";

        /// <summary>
        /// 女生平均
        /// </summary>
        [Display(Name = "女生平均")]
        [Comment("女生平均")]
        [Column(TypeName = "nvarchar(100)")]
        public string AvgNumWom { get; set; } = "";

        /// <summary>
        /// 女生最大值
        /// </summary>
        [Display(Name = "女生最大值")]
        [Comment("女生最大值")]
        [Column(TypeName = "nvarchar(100)")]
        public string MaxNumWom { get; set; } = "";

        /// <summary>
        /// 女生最小值
        /// </summary>
        [Display(Name = "女生最小值")]
        [Comment("女生最小值")]
        [Column(TypeName = "nvarchar(100)")]
        public string MinNumWom { get; set; } = "";

        /// <summary>
        /// 女生中位数
        /// </summary>
        [Display(Name = "女生中位数")]
        [Comment("女生中位数")]
        [Column(TypeName = "nvarchar(100)")]
        public string MedianNumWom { get; set; } = "";

        /// <summary>
        /// 握力效率大值
        /// </summary>
        [Display(Name = "握力效率大值")]
        [Comment("握力效率大值")]
        [Column(TypeName = "nvarchar(100)")]
        public string MaxEff { get; set; }

        /// <summary>
        /// 握力效率最小值
        /// </summary>
        [Display(Name = "握力效率最小值")]
        [Comment("握力效率最小值")]
        [Column(TypeName = "nvarchar(100)")]
        public string MinEff { get; set; }

        /// <summary>
        /// 握力效率平均值
        /// </summary>
        [Display(Name = "握力效率平均值")]
        [Comment("握力效率平均值")]
        [Column(TypeName = "nvarchar(100)")]
        public string AvgEff { get; set; }

        /// <summary>
        /// 限时限数班级中最小用时
        /// </summary>
        [Display(Name = "限时限数班级中最小用时")]
        [Comment("限时限数班级中最小用时")]
        public int? MinUseTime { get; set; }

        /// <summary>
        /// 限时限数班级中最大用时
        /// </summary>
        [Display(Name = "限时限数班级中最大用时")]
        [Comment("限时限数班级中最大用时")]
        public int? MaxUseTime { get; set; }

        /// <summary>
        /// 跳绳等级高低1
        /// </summary>
        [Display(Name = "跳绳等级高低1")]
        [Comment("跳绳等级高低1")]
        public int Level1 { get; set; } = 0;

        /// <summary>
        /// 跳绳等级高低2
        /// </summary>
        [Display(Name = "跳绳等级高低2")]
        [Comment("跳绳等级高低2")]
        public int Level2 { get; set; } = 0;

        /// <summary>
        /// 跳绳等级高低3
        /// </summary>
        [Display(Name = "跳绳等级高低3")]
        [Comment("跳绳等级高低3")]
        public int Level3 { get; set; } = 0;

        /// <summary>
        /// 跳绳等级高低4
        /// </summary>
        [Display(Name = "跳绳等级高低4")]
        [Comment("跳绳等级高低4")]
        public int Level4 { get; set; } = 0;

        /// <summary>
        /// 跳绳等级高低5
        /// </summary>
        [Display(Name = "跳绳等级高低5")]
        [Comment("跳绳等级高低5")]
        public int Level5 { get; set; } = 0;

        /// <summary>
        /// 跳绳等级高低6
        /// </summary>
        [Display(Name = "跳绳等级高低6")]
        [Comment("跳绳等级高低6")]
        public int Level6 { get; set; } = 0;

        /// <summary>
        /// 跳绳等级高低7
        /// </summary>
        [Display(Name = "跳绳等级高低7")]
        [Comment("跳绳等级高低7")]
        public int Level7 { get; set; } = 0;

        /// <summary>
        /// 跳绳等级高低8
        /// </summary>
        [Display(Name = "跳绳等级高低8")]
        [Comment("跳绳等级高低8")]
        public int Level8 { get; set; } = 0;

        /// <summary>
        /// 跳绳等级高低9
        /// </summary>
        [Display(Name = "跳绳等级高低9")]
        [Comment("跳绳等级高低9")]
        public int Level9 { get; set; } = 0;

        /// <summary>
        /// 跳绳等级高低10
        /// </summary>
        [Display(Name = "跳绳等级高低10")]
        [Comment("跳绳等级高低10")]
        public int Level10 { get; set; } = 0;

        /// <summary>
        /// 握力红队KO时间
        /// </summary>
        [Display(Name = "握力红队KO时间")]
        [Comment("握力红队KO时间")]
        public string KoTimeR { get; set; }

        /// <summary>
        /// 握力黄队KO时间
        /// </summary>
        [Display(Name = "握力黄队KO时间")]
        [Comment("握力黄队KO时间")]
        public string KoTimeY { get; set; }

        /// <summary>
        /// 握力红队总握力
        /// </summary>
        [Display(Name = "握力红队总握力")]
        [Comment("握力红队总握力")]
        public string TotalR { get; set; }

        /// <summary>
        /// 握力黄队总握力
        /// </summary>
        [Display(Name = "握力黄队总握力")]
        [Comment("握力黄队总握力")]
        public string TotalY { get; set; }

        /// <summary>
        /// 是否显示
        /// </summary>
        [Display(Name = "是否显示")]
        [Comment("是否显示")]
        [Column(TypeName = "bit")]
        [Editable(true)]
        public bool IsDisplay { get; set; }


        /// <summary>
        /// 排名列表导航属性
        /// </summary>
        public List<I_TrainRanking> TrainRankingData { get; set; } = new List<I_TrainRanking>();

        /// <summary>
        /// 排名列表导航属性
        /// </summary>
        public List<I_TrainGroup> TrainGroupData { get; set; } = new List<I_TrainGroup>();
    }
}