OA2023/OASystem/OASystem.Domain/Entities/Task/WorkOrder.cs

using SqlSugar;
using System;
using System.Collections.Generic;

namespace OASystem.Domain.Entities.WorkOrder
{
    /// <summary>
    /// 主表：工单
    /// </summary>
    [SugarTable("Task_WorkOrder", TableDescription = "工单主表")]
    public class Task_WorkOrder : EntityBase
    {
        /// <summary>
        /// 工单名称
        /// </summary>
        [SugarColumn(Length = 200, IsNullable = false, ColumnDescription = "工单名称")]
        public string Name { get; set; }

        /// <summary>
        /// 任务开始时间
        /// </summary>
        [SugarColumn(ColumnDescription = "任务开始时间")]
        public DateTime StartTime { get; set; }

        /// <summary>
        /// 所属团组ID
        /// </summary>
        [SugarColumn(ColumnDescription = "所属团组ID")]
        public int GroupId { get; set; }

        /// <summary>
        /// 指派用户ID
        /// </summary>
        [SugarColumn(ColumnDescription = "指派用户ID")]
        public int AssignedUserId { get; set; }

        /// <summary>
        /// 外办选项ID
        /// </summary>
        [SugarColumn(ColumnDescription = "外办选项ID")]
        public int ForeignOptionId { get; set; }

        /// <summary>
        /// 部门类型
        /// </summary>
        public int TypeId { get; set; }

        /// <summary>
        /// 进度ID
        /// </summary>
        [SugarColumn(ColumnDescription = "进度ID")]
        public int ProgressId { get; set; }

        /// <summary>
        /// 子任务集合（导航属性，不映射数据库）
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public List<Task_WorkTask> Tasks { get; set; }
    }

    /// <summary>
    /// 从表：任务
    /// </summary>
    [SugarTable("Task_WorkTask", TableDescription = "工单任务表")]
    public class Task_WorkTask : EntityBase
    {
        /// <summary>
        /// 任务名称
        /// </summary>
        [SugarColumn(Length = 200, IsNullable = false, ColumnDescription = "任务名称")]
        public string Name { get; set; }

        /// <summary>
        /// 优先级ID
        /// </summary>
        [SugarColumn(ColumnDescription = "优先级ID")]
        public int PriorityId { get; set; }

        /// <summary>
        /// 是否加急
        /// </summary>
        [SugarColumn(ColumnDescription = "是否加急")]
        public bool IsUrgent { get; set; }

        /// <summary>
        /// 指派用户ID
        /// </summary>
        [SugarColumn(ColumnDescription = "指派用户ID")]
        public int AssignedUserId { get; set; }

        /// <summary>
        /// 任务开始时间
        /// </summary>
        [SugarColumn(ColumnDescription = "任务开始时间")]
        public DateTime StartTime { get; set; }

        /// <summary>
        /// 任务结束时间
        /// </summary>
        [SugarColumn(ColumnDescription = "任务结束时间", IsNullable = true)]
        public DateTime? EndTime { get; set; }

        /// <summary>
        /// 任务耗时（小时数）
        /// </summary>
        [SugarColumn(ColumnDescription = "任务耗时(小时)", IsNullable = true)]
        public double? DurationHours { get; set; }

        /// <summary>
        /// 是否为额外任务
        /// </summary>
        [SugarColumn(ColumnDescription = "是否为额外任务")]
        public bool IsExtraTask { get; set; }

        /// <summary>
        /// 工单主表ID
        /// </summary>
        [SugarColumn(ColumnDescription = "工单主表ID")]
        public int WorkOrderId { get; set; }

        /// <summary>
        /// 排序
        /// </summary>
        public int Sort { get; set; }

        /// <summary>
        /// 工单导航属性（不映射数据库）
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        [Navigate(NavigateType.ManyToOne, nameof(WorkOrderId))]
        public Task_WorkOrder WorkOrder { get; set; }

        /// <summary>
        /// 任务回执集合（不映射数据库）
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public List<Task_WorkTaskReceipt> Receipts { get; set; }
    }

    /// <summary>
    /// 从表：任务回执
    /// </summary>
    [SugarTable("Task_WorkTaskReceipt", TableDescription = "工单任务回执表")]
    public class Task_WorkTaskReceipt : EntityBase
    {
        /// <summary>
        /// 工单主表ID
        /// </summary>
        [SugarColumn(ColumnDescription = "工单主表ID")]
        public int WorkOrderId { get; set; }

        /// <summary>
        /// 任务ID
        /// </summary>
        [SugarColumn(ColumnDescription = "任务ID")]
        public int WorkTaskId { get; set; }

        /// <summary>
        /// 任务是否完成
        /// </summary>
        [SugarColumn(ColumnDescription = "任务是否完成")]
        public int IsCompleted { get; set; }

        /// <summary>
        /// 相关内容
        /// </summary>
        [SugarColumn(Length = 2000, IsNullable = true, ColumnDescription = "相关内容")]
        public string Content { get; set; }

        /// <summary>
        /// 文件路径
        /// </summary>
        [SugarColumn(Length = 500, IsNullable = true, ColumnDescription = "文件路径")]
        public string FilePath { get; set; }

        /// <summary>
        /// 是否通过审核 0未审核 1通过 -1驳回
        /// </summary>
        [SugarColumn(ColumnDescription = "是否通过审核")]
        public int IsApproved { get; set; }

        /// <summary>
        /// 未通过审核原因
        /// </summary>
        [SugarColumn(Length = 500, IsNullable = true, ColumnDescription = "未通过审核原因")]
        public string RejectReason { get; set; }

        /// <summary>
        /// 任务导航属性（不映射数据库）
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        [Navigate(NavigateType.OneToOne, nameof(WorkTaskId))]
        public Task_WorkTask WorkTask { get; set; }

        /// <summary>
        /// 工单导航属性（不映射数据库）
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public Task_WorkOrder WorkOrder { get; set; }
    }

    /// <summary>
    /// 默认任务表
    /// </summary>
    public class Task_WorkOrderDefault : EntityBase
    {
        /// <summary>
        /// 任务名称
        /// </summary>
        [SugarColumn(Length = 200, IsNullable = false, ColumnDescription = "任务名称")]
        public string Name { get; set; }

        /// <summary>
        /// 优先级ID
        /// </summary>
        [SugarColumn(ColumnDescription = "优先级ID")]
        public int PriorityId { get; set; }

        /// <summary>
        /// 是否加急
        /// </summary>
        [SugarColumn(ColumnDescription = "是否加急")]
        public bool IsUrgent { get; set; }

        /// <summary>
        /// 任务耗时（小时数）
        /// </summary>
        [SugarColumn(ColumnDescription = "任务耗时(小时)", IsNullable = true)]
        public double DurationHours { get; set; } = 0;

        /// <summary>
        /// 部门类型
        /// </summary>
        public int TypeId { get; set; }

        /// <summary>
        /// 排序
        /// </summary>
        public int Sort { get; set; }
    }

}