using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; namespace Tiger.Model { /// /// 实体:盘点储位明细 /// [Description("Primary:ID")] [Serializable] [SugarTable("V_WMS_COUNT_LDTL")] public class V_WMS_COUNT_LDTL : DbEntityWithAuth { #region 构造函数 /// /// 实体:盘点储位明细 /// public V_WMS_COUNT_LDTL() {} #endregion #region 公共属性 /// /// 盘点单号 /// public string COUNT_NO { get; set; } /// /// 仓库ID /// public string WH_ID { get; set; } /// /// 储区ID /// public string REGION_ID { get; set; } /// /// 货架/料车ID /// public string SHELF_ID { get; set; } /// /// 储位ID /// public string LOCATION_ID { get; set; } /// /// ERP库位代码 /// public string ERP_WH { get; set; } /// /// 盘点状态(0WaitCount待盘点|1Counted已盘点) /// public int STATUS { get; set; } /// /// 盘点结果(0NoResult无结果|1Balance平帐|2Profit盘盈|3Losses盘亏) /// public int RESULT { get; set; } /// /// 物料编码 /// public string ITEM_CODE { get; set; } /// /// 单位 /// public string UNIT { get; set; } /// /// WMS数量 /// public double QTY { get; set; } /// /// 实际数量 /// public double ACT_QTY { get; set; } /// /// WMS条码数量 /// public double SN_QTY { get; set; } /// /// 实际条码数量 /// public double ACT_SN_QTY { get; set; } /// /// 备注 /// public string REMARK { get; set; } /// /// 物料名称 /// public string ITEM_NAME { get; set; } /// /// 未盘点数量 /// public double NOT_QTY { get; set; } #endregion #region 虚拟属性 /*例子 [SugarColumn(IsIgnore = true)] public string FieldName { get; set; } */ #endregion #region 外键属性 /*例子 //一对一外键导航 [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是WMS_COUNT_LDTL类里面的外键ID字段 public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null //一对多外键导航 [Navigate(NavigateType.OneToMany, nameof(ClassA.WMS_COUNT_LDTLId))]//ClassA表中的WMS_COUNT_LDTLId public List ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.WMS_COUNT_LDTLId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ #endregion #region 枚举变量 /*例子 public enum FieldNames { [Description("枚举描述0")] Enum0, [Description("枚举描述1")] Enum1, } */ /// /// 盘点状态(0WaitCount待盘点|1Counted已盘点)a /// public enum STATUSs { [Description("待盘点")] WaitCount, [Description("已盘点")] Counted, } /// /// 盘点结果(0NotFound未核实|1Founded已核实|2NewFound新找到) /// public enum RESULTs { [Description("未核实")] NotFound, [Description("已核实")] Founded, [Description("新找到")] NewFound, } #endregion #region 公共方法 #endregion }//endClass }