AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/MaterialWarehouse/InventoryPosting/Entity/AdoInventoryMobileTask.cs

using SqlSugar;

namespace Admin.NET.Plugin.AiDOP.MaterialWarehouse.InventoryPosting.Entity;

/// <summary>
/// DOP-L3 库存移动任务（C7 shadow）。承载 `pr_WMS_BPM_AddMobileTask` 的 IQC 可达能力
/// （@ExecuterTypeID=0 → 按 TaskID upsert：exists→UPDATE 否则 INSERT）。**不写旧 MobileTask 表。**
/// IQC 可达任务名：`InvUpShelf`（收货后待上架，TaskID=Receiver）、`PurOrdRctByMRBChoose`（挑选，TaskID=QCNbr）。
/// TaskID 幂等：DB UNIQUE (tenant_id, domain_code, task_id)。
/// </summary>
[SugarTable("ado_inventory_mobile_task", "DOP-L3库存移动任务(C7 shadow,非旧MobileTask)")]
[SugarIndex("uk_ado_inv_mobile_task", nameof(TenantId), OrderByType.Asc, nameof(DomainCode), OrderByType.Asc, nameof(TaskId), OrderByType.Asc, IsUnique = true)]
public class AdoInventoryMobileTask : AdoInvEntityBase
{
    [SugarColumn(ColumnName = "posting_id", ColumnDescription = "过账头Id", IsNullable = true)]
    public long? PostingId { get; set; }

    [SugarColumn(ColumnName = "fbillno", ColumnDescription = "来料检验单号", Length = 50, IsNullable = true)]
    public string FbillNo { get; set; }

    [SugarColumn(ColumnName = "task_id", ColumnDescription = "任务Id(幂等键;InvUpShelf=Receiver/挑选=QCNbr)", Length = 100, IsNullable = false, DefaultValue = "")]
    public string TaskId { get; set; }

    [SugarColumn(ColumnName = "type_id", ColumnDescription = "类型(Wms)", Length = 20, IsNullable = true)]
    public string TypeId { get; set; }

    [SugarColumn(ColumnName = "name", ColumnDescription = "任务名(InvUpShelf/PurOrdRctByMRBChoose)", Length = 50, IsNullable = true)]
    public string Name { get; set; }

    [SugarColumn(ColumnName = "description", ColumnDescription = "描述", Length = 1000, IsNullable = true)]
    public string Description { get; set; }

    [SugarColumn(ColumnName = "executer", ColumnDescription = "执行人", Length = 1000, IsNullable = true)]
    public string Executer { get; set; }

    [SugarColumn(ColumnName = "executer_type_id", ColumnDescription = "执行人类型(IQC=0)", DefaultValue = "0")]
    public int ExecuterTypeId { get; set; }

    [SugarColumn(ColumnName = "plan_date", ColumnDescription = "计划时间", IsNullable = true)]
    public DateTime? PlanDate { get; set; }

    [SugarColumn(ColumnName = "status", ColumnDescription = "任务状态", Length = 20, IsNullable = true)]
    public string Status { get; set; }

    [SugarColumn(ColumnName = "receiver", ColumnDescription = "收货单号", Length = 50, IsNullable = true)]
    public string Receiver { get; set; }

    [SugarColumn(ColumnName = "rct_qc_nbr", ColumnDescription = "检验单号", Length = 100, IsNullable = true)]
    public string RctQcNbr { get; set; }
}