using System;
|
using SqlSugar;
|
using System.Linq;
|
using System.ComponentModel;
|
using System.Collections.Generic;
|
using Tiger.Model.Minsun;
|
using Tiger.Model.Extensions;
|
using Microsoft.SqlServer.Server;
|
|
namespace Tiger.Model
|
{
|
/// <summary>
|
/// 实体:库存信息
|
/// </summary>
|
[Description("Primary:ID")]
|
[Serializable]
|
[SugarTable("V_ITEM_BIZ_ERP_RECEIPT_SN")]
|
public class V_ITEM_BIZ_ERP_RECEIPT_SN : DbEntityWithAuth
|
{
|
#region 构造函数
|
/// <summary>
|
/// 实体:库存信息
|
/// </summary>
|
public V_ITEM_BIZ_ERP_RECEIPT_SN() {}
|
#endregion
|
|
#region 公共属性
|
/// <summary>
|
/// 条码
|
/// </summary>
|
public string SN { get; set; }
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string ITEM_CODE { get; set; }
|
/// <summary>
|
/// 储存状态(0NotExists不存在|10Incoming送货中|20WaitTest待检验|30WaitIn待入库|40InStore在库|50OffShelf已下架|60Sended已发料|70Loaded已上料|80UseUp已耗尽|90Returned已退料|100Shipped已出货)
|
/// </summary>
|
public int STATUS { get; set; }
|
/// <summary>
|
/// 数量
|
/// </summary>
|
public double QTY { get; set; }
|
/// <summary>
|
/// 业务单据号码
|
/// </summary>
|
public string TRANS_NO { get; set; }
|
/// <summary>
|
/// 箱号
|
/// </summary>
|
public string CARTON_NO { get; set; }
|
/// <summary>
|
/// 栈板号
|
/// </summary>
|
public string PALLET_NO { get; set; }
|
#endregion
|
|
#region 虚拟属性
|
/*例子
|
[SugarColumn(IsIgnore = true)]
|
public string FieldName { get; set; }
|
*/
|
#endregion
|
|
#region 外键属性
|
/*例子
|
//一对一外键导航
|
[Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是WMS_ITEM类里面的外键ID字段
|
public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null
|
//一对多外键导航
|
[Navigate(NavigateType.OneToMany, nameof(ClassA.WMS_ITEMId))]//ClassA表中的WMS_ITEMId
|
public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值,只能是null
|
//多对多外键导航
|
[Navigate(typeof(MappingClass), nameof(MappingClass.WMS_ITEMId), nameof(MappingClass.ClassAId))]//注意顺序
|
public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null
|
*/
|
#endregion
|
|
#region 枚举变量
|
#endregion
|
|
#region 公共方法
|
|
#endregion
|
|
}//endClass
|
}
|