using System;
|
using SqlSugar;
|
using System.Linq;
|
using System.ComponentModel;
|
using System.Collections.Generic;
|
|
namespace Tiger.Model
|
{
|
/// <summary>
|
/// 实体：完工入库批次表
|
/// </summary>
|
[Description("Primary:ID")]
|
[DisplayName("完工入库批次表")]
|
[Serializable]
|
[SugarTable("BIZ_ERP_PROD_IN_BTH")]
|
public class BIZ_ERP_PROD_IN_BTH : DbEntityWithAuth
|
{
|
#region 构造函数
|
/// <summary>
|
/// 实体：完工入库批次表
|
/// </summary>
|
public BIZ_ERP_PROD_IN_BTH() {}
|
#endregion
|
|
#region 公共属性
|
/// <summary>
|
/// 入库单号
|
/// </summary>
|
[DisplayName("入库单号")]
|
public string ORDER_NO { get; set; }
|
/// <summary>
|
/// 入库批次号
|
/// </summary>
|
[DisplayName("入库批次号")]
|
public string BATCH_NO { get; set; }
|
/// <summary>
|
/// 工单号
|
/// </summary>
|
[DisplayName("工单号")]
|
public string WORK_ORDER { get; set; }
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
[DisplayName("物料编码")]
|
public string ITEM_CODE { get; set; }
|
/// <summary>
|
/// 物料名称
|
/// </summary>
|
[DisplayName("物料名称")]
|
public string ITEM_NAME { get; set; }
|
/// <summary>
|
/// SAP料号
|
/// </summary>
|
[DisplayName("SAP料号")]
|
public string SapCode { get; set; }
|
/// <summary>
|
/// 销售订单
|
/// </summary>
|
[DisplayName("销售订单")]
|
public string SALES_ORDER { get; set; }
|
/// <summary>
|
/// 已扫描数量
|
/// </summary>
|
[DisplayName("已扫描数量")]
|
public double SCAN_QTY { get; set; }
|
/// <summary>
|
/// 是否扫描完成(Y/N)
|
/// </summary>
|
[DisplayName("是否扫描完成(Y/N)")]
|
public string IS_SCANED { get; set; }
|
/// <summary>
|
/// 扫描完成时间
|
/// </summary>
|
[DisplayName("扫描完成时间")]
|
public DateTime SCANED_DATE { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 是否仓库点收(Y/N)
|
/// </summary>
|
[DisplayName("是否仓库点收(Y/N)")]
|
public string IS_RECEIVED { get; set; }
|
/// <summary>
|
/// 仓库点收时间
|
/// </summary>
|
[DisplayName("仓库点收时间")]
|
public DateTime RECEIVED_DATE { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 是否上架完成(Y/N)
|
/// </summary>
|
[DisplayName("是否上架完成(Y/N)")]
|
public string IS_IN_STORE { get; set; }
|
/// <summary>
|
/// 上架完成时间
|
/// </summary>
|
[DisplayName("上架完成时间")]
|
public DateTime IN_STORE_DATE { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 是否已同步ERP(Y/N)
|
/// </summary>
|
[DisplayName("是否已同步ERP(Y/N)")]
|
public string IS_HANDLED { get; set; }
|
/// <summary>
|
/// 同步ERP时间
|
/// </summary>
|
[DisplayName("同步ERP时间")]
|
public DateTime HANDLED_DATE { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[DisplayName("备注")]
|
public string REMARK { get; set; }
|
#endregion
|
|
#region 虚拟属性
|
/*例子
|
[SugarColumn(IsIgnore = true)]
|
public string FieldName { get; set; }
|
*/
|
|
[SugarColumn(IsIgnore = true)]
|
public int CartonQty { get; set; }
|
#endregion
|
|
#region 外键属性
|
/*例子
|
//一对一外键导航
|
[Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_ERP_PROD_IN_BTH类里面的外键ID字段
|
public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
|
//一对多外键导航
|
[Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ERP_PROD_IN_BTHId))]//ClassA表中的BIZ_ERP_PROD_IN_BTHId
|
public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
|
//多对多外键导航
|
[Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_PROD_IN_BTHId), nameof(MappingClass.ClassAId))]//注意顺序
|
public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
|
*/
|
[Navigate(NavigateType.OneToMany, nameof(BIZ_ERP_PROD_IN_SN.BUSINESSCODE), nameof(ORDER_NO), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_MES_WO类里面的外键ID字段
|
public List<BIZ_ERP_PROD_IN_SN> ProdInSns { get; set; }
|
#endregion
|
|
#region 枚举变量
|
/*例子
|
public enum FieldNames
|
{
|
[Description("枚举描述0")]
|
Enum0,
|
[Description("枚举描述1")]
|
Enum1,
|
}
|
*/
|
#endregion
|
|
#region 公共方法
|
|
#endregion
|
|
}//endClass
|
|
public class ProdInBatch
|
{
|
/// <summary>
|
/// 入库单号
|
/// </summary>
|
[DisplayName("入库单号")]
|
public string ORDER_NO { get; set; }
|
public string SALES_ORDER { get; set; }
|
public string STATUS { get; set; }
|
/// <summary>
|
/// 工单批次号
|
/// </summary>
|
[DisplayName("工单批次号")]
|
public string BATCH_NO { get; set; }
|
/// <summary>
|
/// 工单号
|
/// </summary>
|
[DisplayName("工单号")]
|
public string WORK_ORDER { get; set; }
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
[DisplayName("物料编码")]
|
public string ITEM_CODE { get; set; }
|
/// <summary>
|
/// 物料名称
|
/// </summary>
|
[DisplayName("物料名称")]
|
public string ITEM_NAME { get; set; }
|
public string SapCode { get; set; }
|
/// <summary>
|
/// 计划数量
|
/// </summary>
|
[DisplayName("计划数量")]
|
public double PLAN_QTY { get; set; }
|
/// <summary>
|
/// 已扫描数量
|
/// </summary>
|
[DisplayName("已扫描数量")]
|
public double SCAN_QTY { get; set; }
|
}
|
|
public class InStoreScanInfo
|
{
|
/// <summary>
|
/// 条码
|
/// </summary>
|
[DisplayName("条码")]
|
public string SN { get; set; }
|
public string SALES_ORDER { get; set; }
|
[DisplayName("批次号")]
|
public string BATCH_NO { get; set; }
|
/// <summary>
|
/// 工单号
|
/// </summary>
|
[DisplayName("工单号")]
|
public string WORK_ORDER { get; set; }
|
/// <summary>
|
/// 已扫描数量
|
/// </summary>
|
[DisplayName("已扫描数量")]
|
public double SCAN_QTY { get; set; }
|
}
|
|
public class InStoreInfo {
|
public BIZ_ERP_PROD_IN_BTH ErpProdInBth { get; set; }
|
//public ProdInBatch ProdInBatch { get; set; }
|
public InStoreScanInfo InStoreScanInfo { get; set; }
|
}
|
|
public class InStoreInfos
|
{
|
public List<BIZ_ERP_PROD_IN_BTH> ErpProdInBths { get; set; }
|
public List<InStoreScanInfo> InStoreScanInfos { get; set; }
|
}
|
}
|
