using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; using Tiger.Model; namespace Tiger.Model { /// /// 实体:V_WH_UNIT /// [Serializable] [SugarTable("V_WH_UNIT")] public class V_WH_UNIT : iViewEntity, iTableHasAuth { #region 构造函数 /// /// 实体:V_WH_UNIT /// public V_WH_UNIT() {} #endregion #region 公共属性 /// /// 组织机构授权标识字段 /// public string AUTH_ORG { get; set; } /// /// 生产单元授权标识 /// public string AUTH_PROD { get; set; } /// /// 仓库单元授权标识 /// public string AUTH_WH { get; set; } /// /// GUID /// public string WH_ID { get; set; } /// /// 仓库代码 /// public string WH_CODE { get; set; } /// /// 仓库名称 /// public string WH_NAME { get; set; } /// /// GUID /// public string REGION_ID { get; set; } /// /// 储区代码 /// public string REGION_CODE { get; set; } /// /// 储区名称 /// public string REGION_NAME { get; set; } /// /// GUID /// public string SHELF_ID { get; set; } /// /// 货架代码 /// public string SHELF_CODE { get; set; } /// /// 货架名称 /// public string SHELF_NAME { get; set; } /// /// 货架类型(0General传统式|1QRCode二维码式|2Smart感应式|3Pallet卡板栈板|4Virtual虚拟货架) /// public int SHELF_TYPE { get; set; } /// /// 货架层数 /// public int FLOORS { get; set; } /// /// 每层储位数 /// public int FLOOR_COUNT { get; set; } /// /// IP地址 /// public string SHELF_IP { get; set; } /// /// 访问端口 /// public string SHELF_PORT { get; set; } /// /// GUID /// public string LOCATION_ID { get; set; } /// /// 储位编码 /// public string LOCATION_CODE { get; set; } /// /// 储位名称 /// public string LOCATION_NAME { get; set; } /// /// 所处层数 /// public int FLOOR_NO { get; set; } /// /// 储位LedId /// public int LEDID { get; set; } /// /// 是否有LED灯(Y/N) /// public string HAS_LED { get; set; } /// /// 是否损坏(Y/N) /// public string IS_DAMAGE { get; set; } /// /// /// public string IS_ACTIVE { get; set; } #endregion #region 虚拟属性 /*例子 [SugarColumn(IsIgnore = true)] public string FieldName { get; set; } */ #endregion #region 枚举变量 /*例子 public enum FieldNames { [Description("枚举描述0")] Enum0, [Description("枚举描述1")] Enum1, } */ #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 ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.WMS_ITEM_PKGId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ [Navigate(NavigateType.OneToOne, nameof(WH_CODE), nameof(WMS_WAREHOUSE.WH_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段 public WMS_WAREHOUSE Warehouse { get; set; } //注意禁止手动赋值,只能是null [Navigate(NavigateType.OneToOne, nameof(REGION_CODE), nameof(WMS_REGION.REGION_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段 public WMS_REGION Region { get; set; } //注意禁止手动赋值,只能是null [Navigate(NavigateType.OneToOne, nameof(SHELF_CODE), nameof(WMS_SHELF.SHELF_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段 public WMS_SHELF Shelf { get; set; } //注意禁止手动赋值,只能是null [Navigate(NavigateType.OneToOne, nameof(LOCATION_CODE), nameof(WMS_LOCATION.LOCATION_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段 public WMS_LOCATION Location { get; set; } //注意禁止手动赋值,只能是null #endregion #region 公共方法 #endregion }//endClass }