wcs_server_kate_suzhou/WcsMain/DataBase/TableEntity/AppConveyTask.cs

using SqlSugar;
using System.Text.Json.Serialization;
using WcsMain.WcsAttribute.Clear;

namespace WcsMain.DataBase.TableEntity;

/// <summary>
/// 输送线任务表
/// </summary>
[SugarTable("tbl_app_convey_task")]
[ClearTable("create_time", 30)]
public class AppConveyTask
{
    /// <summary>
    /// 任务号
    /// </summary>
    [SugarColumn(ColumnName = "task_id", IsPrimaryKey = true)]
    [JsonPropertyName("taskId")]
    public string? TaskId { get; set; }

    /// <summary>
    /// 任务组
    /// </summary>
    [SugarColumn(ColumnName = "task_group")]
    [JsonPropertyName("taskGroup")]
    public string? TaskGroup { get; set; }

    /// <summary>
    /// 载具号
    /// </summary>
    [SugarColumn(ColumnName = "vehicle_no")]
    [JsonPropertyName("vehicleNo")]
    public string? VehicleNo { get; set; }

    /// <summary>
    /// 任务类型
    /// </summary>
    [SugarColumn(ColumnName = "task_type")]
    [JsonPropertyName("taskType")]
    public int? TaskType { get; set; }

    /// <summary>
    /// 任务状态
    /// </summary>
    [SugarColumn(ColumnName = "task_status")]
    [JsonPropertyName("taskStatus")]
    public int? TaskStatus { get; set; }

    /// <summary>
    /// 点位
    /// </summary>
    [SugarColumn(ColumnName = "location")]
    [JsonPropertyName("location")]
    public string? Location {  get; set; }


    /// <summary>
    /// 实际到达的点位
    /// </summary>
    [SugarColumn(ColumnName = "arrive_location")]
    [JsonPropertyName("arriveLocation")]
    public string? ArriveLocation { get; set; }

    /// <summary>
    /// 创建人
    /// </summary>
    [SugarColumn(ColumnName = "create_person")]
    [JsonPropertyName("createPerson")]
    public string? CreatePerson { get; set; }

    /// <summary>
    /// 创建时间
    /// </summary>
    [SugarColumn(ColumnName = "create_time")]
    [JsonPropertyName("createTime")]
    public DateTime? CreateTime { get; set; }

    /// <summary>
    /// 移栽时间
    /// </summary>
    [SugarColumn(ColumnName = "move_time")]
    [JsonPropertyName("moveTime")]
    public DateTime? MoveTime { get; set; }

    /// <summary>
    /// 完成时间
    /// </summary>
    [SugarColumn(ColumnName = "complete_time")]
    [JsonPropertyName("completeTime")]
    public DateTime? CompleteTime { get; set; }

    /// <summary>
    /// 备注信息
    /// </summary>
    [SugarColumn(ColumnName = "remark")]
    [JsonPropertyName("remark")]
    public string? Remark { get; set; }




}