// 文件: 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>();
|
|
|
}
|
}
|
