AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/Entity/AdoOrder.cs

namespace Admin.NET.Plugin.AiDOP.Entity;

/// <summary>
/// Demo 订单表（与 Gitee Ai-DOP Demo 表名 ado_orders 对齐，便于数据迁移）
/// </summary>
[SugarTable("ado_orders", "AiDOP Demo 订单")]
public class AdoOrder
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "integer")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "订单号", Length = 50)]
    public string OrderNo { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "客户Id", IsNullable = true)]
    public long? CustomerId { get; set; }

    [SugarColumn(ColumnDescription = "客户名称", Length = 200)]
    public string CustomerName { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "产品Id", IsNullable = true)]
    public long? ProductId { get; set; }

    [SugarColumn(ColumnDescription = "产品名称", Length = 200)]
    public string Product { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "数量")]
    public int Quantity { get; set; }

    [SugarColumn(ColumnDescription = "单价", DecimalDigits = 4)]
    public decimal UnitPrice { get; set; }

    [SugarColumn(ColumnDescription = "金额", DecimalDigits = 4)]
    public decimal Amount { get; set; }

    [SugarColumn(ColumnDescription = "状态", Length = 50)]
    public string Status { get; set; } = "待处理";

    [SugarColumn(ColumnDescription = "交货日期", IsNullable = true)]
    public DateTime? DeliveryDate { get; set; }

    [SugarColumn(ColumnDescription = "备注", Length = 1000, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedTime { get; set; }

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedTime { get; set; }

    [SugarColumn(ColumnDescription = "创建人", Length = 100, IsNullable = true)]
    public string? CreatedBy { get; set; }
}