namespace Admin.NET.Plugin.AiDOP.DataPlatform.Inbound;

/// <summary>实体码到 S0 镜像表的路由。已有专用写入方法的表走专用方法，其余表走通用列对齐。</summary>
public static class MdmMirrorCatalog
{
    public sealed record Route(string EntityCode, string Table, string KeyColumn, string? ParentColumn);

    public static readonly Route[] Routes =
    [
        new("MDM_ITEM", "ItemMaster", "ItemNum", null),
        new("MDM_CUSTOMER", "CustMaster", "Cust", null),
        new("MDM_SUPPLIER", "SuppMaster", "Supp", null),
        new("MDM_LOCATION", "LocationMaster", "Location", null),
        new("MDM_EMPLOYEE_HEADCOUNT", "EmployeeMaster", "Employee", null),
        new("MDM_DEPARTMENT", "DepartmentMaster", "Department", null),
        new("MDM_SOURCE_LIST", "srm_purchase", "ItemNum", null),
        new("MDM_BOM", "ProductStructureMaster", "ParentItem", "ParentItem"),
        new("MDM_ROUTING", "RoutingOpDetail", "Routing", "Routing"),
        new("MDM_STD_OPERATION", "StdOpMaster", "StdOpCode", null),
        new("MDM_WORK_CENTER", "WorkCtrMaster", "WorkCtr", null),
        new("MDM_LINE", "LineMaster", "Line", null)
    ];

    public static Route? Find(string? entityCode) =>
        Routes.FirstOrDefault(r => string.Equals(r.EntityCode, entityCode, StringComparison.OrdinalIgnoreCase));
}