using MiniExcelLibs.Attributes;

namespace Admin.NET.Plugin.AiDOP.Dto.S0.Quality;

// 检验规范 Excel 导入行 DTO：主表列 + 明细列平铺在一张表内，按“文件编号”分组还原为“一条主单 + 多条明细”。
// 列名（[ExcelColumnName]）与各检验规范页 qualityConfigs 现有字段一一对齐，导出模板与导入解析共用同一 DTO，保证列头单一来源。

/// <summary>原材料检验规范导入行（对应 qms_jygf / qms_jygfzb）</summary>
public class AdoS0QmsRawInspectionSpecImportRow
{
    [ExcelColumnName("文件编号")] public string? FileNumber { get; set; }
    [ExcelColumnName("版本")] public string? VersionNo { get; set; }
    [ExcelColumnName("图号")] public string? DrawingNo { get; set; }
    [ExcelColumnName("原材料名称")] public string? RawMaterialName { get; set; }
    [ExcelColumnName("物料编码")] public string? MaterialCode { get; set; }
    [ExcelColumnName("生效日期")] public string? EffectiveDate { get; set; }
    [ExcelColumnName("图纸版本")] public string? DrawingVersion { get; set; }
    [ExcelColumnName("材质/材料牌号")] public string? MaterialGrade { get; set; }
    [ExcelColumnName("穴/模")] public string? CavityOrMold { get; set; }
    [ExcelColumnName("附件")] public string? Attachment { get; set; }
    [ExcelColumnName("附件文件名")] public string? FileName { get; set; }
    [ExcelColumnName("附件标题")] public string? Title { get; set; }

    [ExcelColumnName("明细-序号")] public int? Seq { get; set; }
    [ExcelColumnName("明细-检验项目")] public string? InspectionItem { get; set; }
    [ExcelColumnName("明细-检验标准")] public string? InspectionStandard { get; set; }
    [ExcelColumnName("明细-检验工具/方法")] public string? InspectionMethod { get; set; }
    [ExcelColumnName("明细-抽样方案")] public string? SamplingScheme { get; set; }
    [ExcelColumnName("明细-上限")] public string? UpperLimit { get; set; }
    [ExcelColumnName("明细-下限")] public string? LowerLimit { get; set; }
}

/// <summary>过程 / FQC / OQC 检验规范导入行（三者字段一致，对应 qms_gcjygf(zb) / qms_fqcjygf(zb) / qms_oqcjygf(zb)）</summary>
public class AdoS0QmsProcessLikeInspectionSpecImportRow
{
    [ExcelColumnName("适用型号")] public string? ApplicableModel { get; set; }
    [ExcelColumnName("文件编号")] public string? FileNumber { get; set; }
    [ExcelColumnName("版本")] public string? VersionNo { get; set; }
    [ExcelColumnName("生效日期")] public string? EffectiveDate { get; set; }
    [ExcelColumnName("物料编码")] public string? MaterialCode { get; set; }
    [ExcelColumnName("附件")] public string? Attachment { get; set; }
    [ExcelColumnName("附件2")] public string? Attachment2 { get; set; }
    [ExcelColumnName("版本号")] public int? Version { get; set; }

    [ExcelColumnName("明细-工序代号")] public string? OperationCode { get; set; }
    [ExcelColumnName("明细-工序名称")] public string? OperationName { get; set; }
    [ExcelColumnName("明细-检验项目")] public string? InspectionItem { get; set; }
    [ExcelColumnName("明细-检验方法")] public string? InspectionMethod { get; set; }
    [ExcelColumnName("明细-检验规格")] public string? InspectionSpec { get; set; }
    [ExcelColumnName("明细-检验频次")] public string? InspectionFrequency { get; set; }
    [ExcelColumnName("明细-上限")] public string? UpperLimit { get; set; }
    [ExcelColumnName("明细-下限")] public string? LowerLimit { get; set; }
}

/// <summary>检验规范 Excel 导入结果</summary>
public class AdoS0QmsSpecImportResultDto
{
    /// <summary>读取到的数据行总数（不含表头）</summary>
    public int TotalRows { get; set; }

    /// <summary>新增主表（规范）条数</summary>
    public int ImportedMasters { get; set; }

    /// <summary>新增明细条数</summary>
    public int ImportedItems { get; set; }

    /// <summary>跳过行数（如文件编号为空）</summary>
    public int SkippedRows { get; set; }

    /// <summary>逐行提示（跳过/异常原因）。注意：不要命名为 errors，前端响应拦截器会把非空 errors 字段判为请求失败。</summary>
    public List<string> RowMessages { get; set; } = [];

    /// <summary>汇总文案</summary>
    public string Message { get; set; } = string.Empty;
}