// 文件: MES.Service.Modes/ZZCXA.cs
using System;
using SqlSugar;

namespace MES.Service.Modes
{
    /// <summary>
    /// ZZCXA - 组装拆卸 子表（之前的 ZZCXA 字段集合），新增 YD_ID 字段来记录主表 ERPID
    /// </summary>
    [SugarTable("ZZCXA")]
    public class ZZCXA
    {
        /// <summary>
        /// 主键 ID
        /// </summary>
        [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_ZZCXA")]
        public decimal? Id { get; set; }

        /// <summary>
        /// 父表 ID (对应 ZZCX.ID) —— 可用于关系查询
        /// </summary>
        [SugarColumn(ColumnName = "PID")]
        public decimal? Pid { get; set; }

        /// <summary>
        /// YD_ID：写入主表的 ERPID（你要求：子表的 yd_id 存主表的 erpid）
        /// </summary>
        [SugarColumn(ColumnName = "YD_ID")]
        public string YdId { get; set; }

        /// <summary>
        /// ERP 子表/行 id（erpid/eid 等 ERP 行标识）
        /// </summary>
        [SugarColumn(ColumnName = "ERPID")]
        public string Erpid { get; set; }

        /// <summary>
        /// 单据编码
        /// </summary>
        [SugarColumn(ColumnName = "BILL_NO")]
        public string BillNo { get; set; }

        /// <summary>
        /// 单据类型
        /// </summary>
        [SugarColumn(ColumnName = "DJ_LX")]
        public string DjLx { get; set; }

        /// <summary>
        /// 库存组织
        /// </summary>
        [SugarColumn(ColumnName = "KC_ZZ")]
        public string KcZz { get; set; }

        /// <summary>
        /// 事务类型
        /// </summary>
        [SugarColumn(ColumnName = "SW_LX")]
        public string SwLx { get; set; }

        /// <summary>
        /// 日期
        /// </summary>
        [SugarColumn(ColumnName = "TIME")]
        public string Time { get; set; }

        /// <summary>
        /// 部门
        /// </summary>
        [SugarColumn(ColumnName = "BM")]
        public string Bm { get; set; }

        /// <summary>
        /// 仓管员
        /// </summary>
        [SugarColumn(ColumnName = "CGY")]
        public string Cgy { get; set; }

        /// <summary>
        /// 库存组
        /// </summary>
        [SugarColumn(ColumnName = "KCZ")]
        public string Kcz { get; set; }

        /// <summary>
        /// 单据状态
        /// </summary>
        [SugarColumn(ColumnName = "DJ_ZT")]
        public string DjZt { get; set; }

        /// <summary>
        /// 备注
        /// </summary>
        [SugarColumn(ColumnName = "MEMO")]
        public string Memo { get; set; }

        /// <summary>
        /// 成品货主类型
        /// </summary>
        [SugarColumn(ColumnName = "CPHZLX")]
        public string Cphzlx { get; set; }

        /// <summary>
        /// 成品货主
        /// </summary>
        [SugarColumn(ColumnName = "CPHZ")]
        public string Cphz { get; set; }

        /// <summary>
        /// 子件货主类型
        /// </summary>
        [SugarColumn(ColumnName = "ZJHZLX")]
        public string Zjhzlx { get; set; }

        /// <summary>
        /// 子件货主
        /// </summary>
        [SugarColumn(ColumnName = "ZJHZ")]
        public string Zjhz { get; set; }

        /// <summary>
        /// 物料编码 id
        /// </summary>
        [SugarColumn(ColumnName = "ITEM_ID")]
        public string ItemId { get; set; }

        /// <summary>
        /// 数量
        /// </summary>
        [SugarColumn(ColumnName = "QTY")]
        public decimal? Qty { get; set; }

        /// <summary>
        /// 单位
        /// </summary>
        [SugarColumn(ColumnName = "UNIT")]
        public string Unit { get; set; }

        /// <summary>
        /// 仓库
        /// </summary>
        [SugarColumn(ColumnName = "DEPOT_ID")]
        public string DepotId { get; set; }

        [SugarColumn(IsIgnore = true)]
        public List<ZZCXB> SubItems { get; set; } = new List<ZZCXB>();


    }
}