using System;
|
using SqlSugar;
|
using System.Linq;
|
using System.ComponentModel;
|
using System.Collections.Generic;
|
using Tiger.Model.Minsun;
|
|
namespace Tiger.Model
|
{
|
/// <summary>
|
/// 实体：包装信息
|
/// </summary>
|
[Description("Primary:ID")]
|
[Serializable]
|
[SugarTable("WMS_ITEM_PKG")]
|
public class WMS_ITEM_PKG : DbEntityWithAuth
|
{
|
#region 构造函数
|
/// <summary>
|
/// 实体：包装信息
|
/// </summary>
|
public WMS_ITEM_PKG() { }
|
#endregion
|
|
#region 公共属性
|
/// <summary>
|
/// 条码
|
/// </summary>
|
public string SN { get; set; }
|
/// <summary>
|
/// 父包装条码
|
/// </summary>
|
public string PARENT_SN { get; set; }
|
/// <summary>
|
/// 包装类型(0OnePiece单件|1Container载具|2Carton箱|3Pallet栈板)
|
/// </summary>
|
public int PKG_TYPE { get; set; }
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string ITEM_CODE { get; set; }
|
/// <summary>
|
/// 条码类型(规则编码)
|
/// </summary>
|
public string SN_TYPE { get; set; }
|
/// <summary>
|
/// 数量
|
/// </summary>
|
public double QTY { get; set; }
|
/// <summary>
|
/// 单位
|
/// </summary>
|
public string UNIT { get; set; }
|
/// <summary>
|
/// 业务单据编码
|
/// </summary>
|
public string TRANS_CODE { get; set; }
|
/// <summary>
|
/// 业务单据号码
|
/// </summary>
|
public string TRANS_NO { get; set; }
|
/// <summary>
|
/// 业务单据行号
|
/// </summary>
|
public string TRANS_LINE { get; set; }
|
/// <summary>
|
/// 来源单据编码
|
/// </summary>
|
public string SOURCE_CODE { get; set; }
|
/// <summary>
|
/// 来源单据号码
|
/// </summary>
|
public string SOURCE_ORDER { get; set; }
|
/// <summary>
|
/// 来源单据行号
|
/// </summary>
|
public string SOURCE_LINE { get; set; }
|
/// <summary>
|
/// 供应商代码
|
/// </summary>
|
public string SUPP_CODE { get; set; }
|
/// <summary>
|
/// 供应商批次号
|
/// </summary>
|
public string SUPP_LOTNO { get; set; }
|
/// <summary>
|
/// 批次号
|
/// </summary>
|
public string LOTNO { get; set; }
|
/// <summary>
|
/// 仓库ID
|
/// </summary>
|
public string WH_ID { get; set; }
|
/// <summary>
|
/// 储区ID
|
/// </summary>
|
public string REGION_ID { get; set; }
|
/// <summary>
|
/// 货架/料车ID
|
/// </summary>
|
public string SHELF_ID { get; set; }
|
/// <summary>
|
/// 储位ID
|
/// </summary>
|
public string LOCATION_ID { get; set; }
|
/// <summary>
|
/// ERP库位代码
|
/// </summary>
|
public string ERP_WH { get; set; }
|
/// <summary>
|
/// 打印次数
|
/// </summary>
|
public int PRINT_TIMES { get; set; }
|
/// <summary>
|
/// 最后打印时间
|
/// </summary>
|
public DateTime PRINT_DATE { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 打印人
|
/// </summary>
|
public string PRINT_USER { get; set; }
|
/// <summary>
|
/// 重量
|
/// </summary>
|
[DisplayName("重量")]
|
public double WEIGHT { get; set; }
|
/// <summary>
|
/// 重量单位
|
/// </summary>
|
[DisplayName("重量单位")]
|
public string WEIGHT_UNIT { get; set; }
|
/// <summary>
|
/// 备注
|
/// </summary>
|
public string REMARK { get; set; }
|
#endregion
|
|
#region 虚拟属性
|
/*例子
|
[SugarColumn(IsIgnore = true)]
|
public string FieldName { get; set; }
|
*/
|
[SugarColumn(IsIgnore = true)]
|
public string LEVEL { get; set; }
|
#endregion
|
|
#region 外键属性
|
/*例子
|
//一对一外键导航
|
[Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段
|
public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
|
//一对多外键导航
|
[Navigate(NavigateType.OneToMany, nameof(ClassA.WMS_ITEM_PKGId))]//ClassA表中的WMS_ITEM_PKGId
|
public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
|
//多对多外键导航
|
[Navigate(typeof(MappingClass), nameof(MappingClass.WMS_ITEM_PKGId), nameof(MappingClass.ClassAId))]//注意顺序
|
public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
|
*/
|
// /// <summary>
|
// /// 包含逻辑删除的数据
|
// /// </summary>
|
// [Navigate(NavigateType.OneToMany, nameof(PARENT_SN), nameof(SN))]//ClassA表中的BAS_CODE_RULEId
|
// public List<WMS_ITEM_PKG> ChildrenWithGhost { get; set; }//注意禁止手动赋值，只能是null
|
// /// <summary>
|
// /// 不包含逻辑删除的数据
|
// /// </summary>
|
// [SugarColumn(IsIgnore = true)]
|
// public List<WMS_ITEM_PKG> Children => ChildrenWithGhost?.Where(q => !q.GHOST_ROW).ToList() ?? new List<WMS_ITEM_PKG>();
|
//BAS_ITEM, WMS_WAREHOUSE, WMS_REGION, WMS_SHELF, WMS_LOCATION
|
[Navigate(NavigateType.OneToMany, nameof(BAS_ITEM.ITEM_CODE), nameof(ITEM_CODE), "GHOST_ROW = 0")]
|
public List<BAS_ITEM> _ItemInfos { get; set; } //注意禁止手动赋值，只能是null
|
[SugarColumn(IsIgnore = true)]
|
public BAS_ITEM ItemInfo => _ItemInfos?.FirstOrDefault(q => q.AUTH_ORG == AUTH_ORG);
|
[Navigate(NavigateType.OneToOne, nameof(SN), nameof(WMS_ITEM.SN), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段
|
public WMS_ITEM Item { get; set; } //注意禁止手动赋值，只能是null
|
[Navigate(NavigateType.OneToOne, nameof(SN), nameof(WMS_ITEM_EXT.SN), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段
|
public WMS_ITEM_EXT ExtInfo { get; set; } //注意禁止手动赋值，只能是null
|
[Navigate(NavigateType.OneToOne, nameof(WH_ID), nameof(ID), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段
|
public WMS_WAREHOUSE Warehouse { get; set; } //注意禁止手动赋值，只能是null
|
[Navigate(NavigateType.OneToOne, nameof(REGION_ID), nameof(ID), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段
|
public WMS_REGION Region { get; set; } //注意禁止手动赋值，只能是null
|
[Navigate(NavigateType.OneToOne, nameof(SHELF_ID), nameof(ID), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段
|
public WMS_SHELF Shelf { get; set; } //注意禁止手动赋值，只能是null
|
[Navigate(NavigateType.OneToOne, nameof(LOCATION_ID), nameof(ID), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段
|
public WMS_LOCATION Location { get; set; } //注意禁止手动赋值，只能是null
|
[Navigate(NavigateType.OneToOne, nameof(PARENT_SN), nameof(SN), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段
|
public WMS_ITEM_PKG Parent { get; set; } //注意禁止手动赋值，只能是null
|
#endregion
|
|
#region 枚举变量
|
/// <summary>
|
/// 包装类型(0OnePiece单件|1Container载具|2Carton箱|3Pallet栈板)
|
/// </summary>
|
public enum PKG_TYPEs
|
{
|
[Description("单件")]
|
OnePiece,
|
[Description("载具")]
|
Container,
|
[Description("箱")]
|
Carton,
|
[Description("栈板")]
|
Pallet,
|
}
|
#endregion
|
|
#region 公共方法
|
public static List<WMS_ITEM_PKG> UpdateQty(List<WMS_ITEM_PKG> list)
|
{
|
var minPkgs = list.Where(q => !list.Any(p => p.PARENT_SN == q.SN));
|
var parent = list.Where(q => minPkgs.Any(p => p.PARENT_SN == q.SN));
|
while (parent.Any())
|
{
|
foreach (var item in parent)
|
{
|
item.QTY = list.Where(q => q.PARENT_SN == item.SN).Sum(q => q.QTY);
|
}
|
parent = list.Where(q => parent.Any(p => p.PARENT_SN == q.SN));
|
}
|
|
return list;
|
}
|
#endregion
|
|
}//endClass
|
}
|
