| | |
| | | namespace Tiger.Model |
| | | { |
| | | /// <summary> |
| | | /// 实体:完工入库批次表 |
| | | /// 实体:完工入库批次表 |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [DisplayName("完工入库批次表")] |
| | | [DisplayName("完工入库批次表")] |
| | | [Serializable] |
| | | [SugarTable("BIZ_ERP_PROD_IN_BTH")] |
| | | public class BIZ_ERP_PROD_IN_BTH : DbEntityWithAuth |
| | | { |
| | | #region 构造函数 |
| | | #region 构造函数 |
| | | /// <summary> |
| | | /// 实体:完工入库批次表 |
| | | /// 实体:完工入库批次表 |
| | | /// </summary> |
| | | public BIZ_ERP_PROD_IN_BTH() {} |
| | | #endregion |
| | | |
| | | #region 公共属性 |
| | | #region 公共属性 |
| | | /// <summary> |
| | | /// 入库单号 |
| | | /// 入库单号 |
| | | /// </summary> |
| | | [DisplayName("入库单号")] |
| | | [DisplayName("入库单号")] |
| | | public string ORDER_NO { get; set; } |
| | | /// <summary> |
| | | /// 工单批次号 |
| | | /// </summary> |
| | | [DisplayName("工单批次号")] |
| | | /// <summary> |
| | | /// 入库批次号 |
| | | /// </summary> |
| | | [DisplayName("入库批次号")] |
| | | public string BATCH_NO { get; set; } |
| | | /// <summary> |
| | | /// 工单号 |
| | | /// 工单号 |
| | | /// </summary> |
| | | [DisplayName("工单号")] |
| | | [DisplayName("工单号")] |
| | | public string WORK_ORDER { get; set; } |
| | | /// <summary> |
| | | /// 物料编码 |
| | | /// 物料编码 |
| | | /// </summary> |
| | | [DisplayName("物料编码")] |
| | | [DisplayName("物料编码")] |
| | | public string ITEM_CODE { get; set; } |
| | | /// <summary> |
| | | /// 物料名称 |
| | | /// 物料名称 |
| | | /// </summary> |
| | | [DisplayName("物料名称")] |
| | | [DisplayName("物料名称")] |
| | | public string ITEM_NAME { get; set; } |
| | | /// <summary> |
| | | /// 已扫描数量 |
| | | /// </summary> |
| | | [DisplayName("已扫描数量")] |
| | | /// <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) |
| | | /// 是否扫描完成(Y/N) |
| | | /// </summary> |
| | | [DisplayName("是否扫描完成(Y/N)")] |
| | | [DisplayName("是否扫描完成(Y/N)")] |
| | | public string IS_SCANED { get; set; } |
| | | /// <summary> |
| | | /// 扫描完成时间 |
| | | /// 扫描完成时间 |
| | | /// </summary> |
| | | [DisplayName("扫描完成时间")] |
| | | [DisplayName("扫描完成时间")] |
| | | public DateTime SCANED_DATE { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// 是否仓库点收(Y/N) |
| | | /// 是否仓库点收(Y/N) |
| | | /// </summary> |
| | | [DisplayName("是否仓库点收(Y/N)")] |
| | | [DisplayName("是否仓库点收(Y/N)")] |
| | | public string IS_RECEIVED { get; set; } |
| | | /// <summary> |
| | | /// 仓库点收时间 |
| | | /// 仓库点收时间 |
| | | /// </summary> |
| | | [DisplayName("仓库点收时间")] |
| | | [DisplayName("仓库点收时间")] |
| | | public DateTime RECEIVED_DATE { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// 是否上架完成(Y/N) |
| | | /// 是否上架完成(Y/N) |
| | | /// </summary> |
| | | [DisplayName("是否上架完成(Y/N)")] |
| | | [DisplayName("是否上架完成(Y/N)")] |
| | | public string IS_IN_STORE { get; set; } |
| | | /// <summary> |
| | | /// 上架完成时间 |
| | | /// 上架完成时间 |
| | | /// </summary> |
| | | [DisplayName("上架完成时间")] |
| | | [DisplayName("上架完成时间")] |
| | | public DateTime IN_STORE_DATE { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// 是否已同步ERP(Y/N) |
| | | /// 是否已同步ERP(Y/N) |
| | | /// </summary> |
| | | [DisplayName("是否已同步ERP(Y/N)")] |
| | | [DisplayName("是否已同步ERP(Y/N)")] |
| | | public string IS_HANDLED { get; set; } |
| | | /// <summary> |
| | | /// 同步ERP时间 |
| | | /// 同步ERP时间 |
| | | /// </summary> |
| | | [DisplayName("同步ERP时间")] |
| | | [DisplayName("同步ERP时间")] |
| | | public DateTime HANDLED_DATE { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// 备注 |
| | | /// 备注 |
| | | /// </summary> |
| | | [DisplayName("备注")] |
| | | [DisplayName("备注")] |
| | | public string REMARK { get; set; } |
| | | #endregion |
| | | #endregion |
| | | |
| | | #region 虚拟属性 |
| | | /*例子 |
| | | #region 虚拟属性 |
| | | /*例子 |
| | | [SugarColumn(IsIgnore = true)] |
| | | public string FieldName { 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 |
| | | [SugarColumn(IsIgnore = true)] |
| | | public int CartonQty { get; set; } |
| | | [SugarColumn(IsIgnore = true)] |
| | | public double CompleteQty { 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 |
| | | */ |
| | | #endregion |
| | | [Navigate(NavigateType.OneToMany, nameof(BIZ_ERP_PROD_IN_SN.SOURCECODE), nameof(WORK_ORDER), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_MES_WO类里面的外键ID字段 |
| | | public List<BIZ_ERP_PROD_IN_SN> ProdInSns { get; set; } |
| | | #endregion |
| | | |
| | | #region 枚举变量 |
| | | /*例子 |
| | | #region 枚举变量 |
| | | /*例子 |
| | | public enum FieldNames |
| | | { |
| | | [Description("枚举描述0")] |
| | | [Description("枚举描述0")] |
| | | Enum0, |
| | | [Description("枚举描述1")] |
| | | [Description("枚举描述1")] |
| | | Enum1, |
| | | } |
| | | */ |
| | | #endregion |
| | | #endregion |
| | | |
| | | #region 公共方法 |
| | | #region 公共方法 |
| | | |
| | | #endregion |
| | | #endregion |
| | | |
| | | }//endClass |
| | | }//endClass |
| | | |
| | | public class ProdInBatch |
| | | { |
| | | /// <summary> |
| | | /// 入库单号 |
| | | /// 入库单号 |
| | | /// </summary> |
| | | [DisplayName("入库单号")] |
| | | [DisplayName("入库单号")] |
| | | public string ORDER_NO { get; set; } |
| | | public string SALES_ORDER { get; set; } |
| | | public string STATUS { get; set; } |
| | | /// <summary> |
| | | /// 工单批次号 |
| | | /// 工单批次号 |
| | | /// </summary> |
| | | [DisplayName("工单批次号")] |
| | | [DisplayName("工单批次号")] |
| | | public string BATCH_NO { get; set; } |
| | | /// <summary> |
| | | /// 工单号 |
| | | /// 工单号 |
| | | /// </summary> |
| | | [DisplayName("工单号")] |
| | | [DisplayName("工单号")] |
| | | public string WORK_ORDER { get; set; } |
| | | /// <summary> |
| | | /// 物料编码 |
| | | /// 物料编码 |
| | | /// </summary> |
| | | [DisplayName("物料编码")] |
| | | [DisplayName("物料编码")] |
| | | public string ITEM_CODE { get; set; } |
| | | /// <summary> |
| | | /// 物料名称 |
| | | /// 物料名称 |
| | | /// </summary> |
| | | [DisplayName("物料名称")] |
| | | [DisplayName("物料名称")] |
| | | public string ITEM_NAME { get; set; } |
| | | public string SapCode { get; set; } |
| | | /// <summary> |
| | | /// 计划数量 |
| | | /// 计划数量 |
| | | /// </summary> |
| | | [DisplayName("计划数量")] |
| | | [DisplayName("计划数量")] |
| | | public double PLAN_QTY { get; set; } |
| | | /// <summary> |
| | | /// 已扫描数量 |
| | | /// 已扫描数量 |
| | | /// </summary> |
| | | [DisplayName("已扫描数量")] |
| | | [DisplayName("已扫描数量")] |
| | | public double SCAN_QTY { get; set; } |
| | | } |
| | | |
| | | public class InStoreScanInfo |
| | | { |
| | | /// <summary> |
| | | /// 条码 |
| | | /// 条码 |
| | | /// </summary> |
| | | [DisplayName("条码")] |
| | | [DisplayName("条码")] |
| | | public string SN { get; set; } |
| | | [DisplayName("工单批次号")] |
| | | public string SALES_ORDER { get; set; } |
| | | [DisplayName("批次号")] |
| | | public string BATCH_NO { get; set; } |
| | | /// <summary> |
| | | /// 工单号 |
| | | /// 工单号 |
| | | /// </summary> |
| | | [DisplayName("工单号")] |
| | | [DisplayName("工单号")] |
| | | public string WORK_ORDER { get; set; } |
| | | /// <summary> |
| | | /// 已扫描数量 |
| | | /// 已扫描数量 |
| | | /// </summary> |
| | | [DisplayName("已扫描数量")] |
| | | [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 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; } |
| | | } |
| | | } |