AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/Order/Entity/ContractReview.cs

namespace Admin.NET.Plugin.AiDOP.Order;

/// <summary>
/// 合同评审主表（ado_contract_review）
/// </summary>
[SugarTable("ado_contract_review", "合同评审主表")]
public class ContractReview
{
    [SugarColumn(ColumnName = "RecID", IsPrimaryKey = true, IsIdentity = true)]
    public int RecID { get; set; }

    /// <summary>单据编号（业务主键，格式 CRyyyyMMxxxx）</summary>
    [SugarColumn(ColumnName = "BillNo", Length = 64)]
    public string BillNo { get; set; } = string.Empty;

    /// <summary>合同标题</summary>
    [SugarColumn(ColumnName = "Title", Length = 256, IsNullable = true)]
    public string? Title { get; set; }

    /// <summary>客户名称</summary>
    [SugarColumn(ColumnName = "CustomerName", Length = 128, IsNullable = true)]
    public string? CustomerName { get; set; }

    /// <summary>客户编号</summary>
    [SugarColumn(ColumnName = "CustomerNo", Length = 64, IsNullable = true)]
    public string? CustomerNo { get; set; }

    /// <summary>销售公司</summary>
    [SugarColumn(ColumnName = "SalesCompany", Length = 64, IsNullable = true)]
    public string? SalesCompany { get; set; }

    /// <summary>销售区域</summary>
    [SugarColumn(ColumnName = "SalesArea", Length = 64, IsNullable = true)]
    public string? SalesArea { get; set; }

    /// <summary>项目编号</summary>
    [SugarColumn(ColumnName = "ProjectCode", Length = 64, IsNullable = true)]
    public string? ProjectCode { get; set; }

    /// <summary>CRM机会编号</summary>
    [SugarColumn(ColumnName = "CrmNo", Length = 64, IsNullable = true)]
    public string? CrmNo { get; set; }

    /// <summary>负责人账号</summary>
    [SugarColumn(ColumnName = "ResponsibleAccount", Length = 64, IsNullable = true)]
    public string? ResponsibleAccount { get; set; }

    /// <summary>负责人姓名</summary>
    [SugarColumn(ColumnName = "ResponsibleName", Length = 64, IsNullable = true)]
    public string? ResponsibleName { get; set; }

    /// <summary>项目开始日期</summary>
    [SugarColumn(ColumnName = "ProjectStartDate", IsNullable = true)]
    public DateTime? ProjectStartDate { get; set; }

    /// <summary>当前审批阶段（0=草稿, 1~5=各环节）</summary>
    [SugarColumn(ColumnName = "CurrentStage", IsNullable = true)]
    public int? CurrentStage { get; set; }

    /// <summary>当前审批部门</summary>
    [SugarColumn(ColumnName = "CurrentDept", Length = 64, IsNullable = true)]
    public string? CurrentDept { get; set; }

    /// <summary>项目孵化状态</summary>
    [SugarColumn(ColumnName = "ProjectStatus", Length = 64, IsNullable = true)]
    public string? ProjectStatus { get; set; }

    /// <summary>项目成单概率</summary>
    [SugarColumn(ColumnName = "WinRate", Length = 32, IsNullable = true)]
    public string? WinRate { get; set; }

    /// <summary>预计进单月份</summary>
    [SugarColumn(ColumnName = "ExpectedOrderMonth", IsNullable = true)]
    public DateTime? ExpectedOrderMonth { get; set; }

    /// <summary>预计发货日期</summary>
    [SugarColumn(ColumnName = "ExpectedDeliveryDate", IsNullable = true)]
    public DateTime? ExpectedDeliveryDate { get; set; }

    /// <summary>项目需求说明</summary>
    [SugarColumn(ColumnName = "ProjectRequirement", Length = 1024, IsNullable = true)]
    public string? ProjectRequirement { get; set; }

    /// <summary>备注</summary>
    [SugarColumn(ColumnName = "Remark", Length = 512, IsNullable = true)]
    public string? Remark { get; set; }

    /// <summary>流程状态：draft/reviewing/completed/rejected</summary>
    [SugarColumn(ColumnName = "FlowStatus", Length = 32, IsNullable = true)]
    public string? FlowStatus { get; set; }

    [SugarColumn(ColumnName = "CreateUser", Length = 64, IsNullable = true)]
    public string? CreateUser { get; set; }

    [SugarColumn(ColumnName = "CreateTime", IsNullable = true)]
    public DateTime? CreateTime { get; set; }

    [SugarColumn(ColumnName = "UpdateUser", Length = 64, IsNullable = true)]
    public string? UpdateUser { get; set; }

    [SugarColumn(ColumnName = "UpdateTime", IsNullable = true)]
    public DateTime? UpdateTime { get; set; }

    [SugarColumn(ColumnName = "IsActive", IsNullable = true)]
    public int? IsActive { get; set; }
}